Screenshots and Images
The printed version.
Open the template in Excel.
You are safe to download the resources. We've added our digital signatures to the files.
Download this if you have already installed the Microsoft Store edition of Invoice Manager for Excel, and are looking for additional customized templates.
Download this if you want this design to be set as the default template by the installer program.
When an invoice is past due, you send a past due letter for collection. If the client has new purchases you can also include the overdue amount / previous balance in the new invoice to show the total amount due. This blank overdue invoice template is printable with A4 paper.
If you need a sample of how to word your past due letter, you can find it at Friendly Collection Letter, or at First Collection Letter - A Friendly Reminder of a Past Due and Second Collection Letter: Turning Up the Heat. Writing a friendly collection letter is a good way to remind your customers that they are late on their invoices. Another way to give the message is just adding the current account balance due to the new invoice. This is what we do in this past due invoice template.
This past due invoice template is a revisited version of c5007 Invoice with Previous Balance (Sales), which is a sales invoice template that includes the "Shipping Address" on the printable form. A service invoice version of c5007 is also available here on InvoicingTemplate.com, at c5027 Invoice with Previous Balance (Service). On our original web site office-kit.com it is C5-007 and named "Invoice Template with Previous Balance". The following description from office-kit.com could help you get a better understanding of this template.
The invoice template adds/forwards previous balance and shows it on the current invoice form. The amount of "Previous Balance" is retrieved when you pick up a customer by clicking the "select-a-customer" button. The "Total Balance" cell calculates the sum of the current balance and previous balance.
The template uses a custom fieldadded to the "InvHdr" database table to display the previous balance of the current customer. Another custom field, , which is also added to the "InvHdr" database table, displays the sum of the current invoice balance and previous balance.
The template does not mark previous invoices as paid. If you post payments to invoices, you need to do it on a per-invoice basis, including the previous invoices.
Here is a list of the custom fields used in this template/database:
|Database table||Field name||Field type|
Format and Specification
|Name||Past Due Invoice Template|
|Category||Sales Invoice Template|
|Release Date||Friday, March 24, 2017|
|Format (XLS or XLSX)||.xlsx|
|Line Height (Points)||19.50|
|Papaer Size / Orientation||Portrait|
|Default Margins (Points)|
|Price||Free (0.00 USD)|
|System||Windows 7 and later, and Excel 2007 and later.|