BoostExcel main content


License: Private Use (not for distribution or resale). See our Terms of Use.

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.

546 KBDownload

Download this if you want this design to be set as the default template by the installer program.

6.08 MBDownload

Screenshots and Images

The printed version.

Past Due Invoice Template

Open the template in Excel.

Past Due Invoice Template (IMFE Edition)


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, at c5027 Invoice with Previous Balance (Service). On our original web site it is C5-007 and named "Invoice Template with Previous Balance". The following description from 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 field oknAccountBalance added to the "InvHdr" database table to display the previous balance of the current customer. Another custom field, oknTotalBalance, 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 tableField nameField type
InvHdrAccountBalanceDecimal (12,2)
InvHdrTotalBalanceDecimal (12,2)

Format and Specification

NamePast Due Invoice Template
CategorySales Invoice Template
Release DateFriday, March 24, 2017
Format (XLS or XLSX).xlsx
Line Height (Points)19.50
Print Area$F$3:$N$48
Papaer Size / OrientationPortrait
Default Margins (Points)
PriceFree (0.00USD)
SystemWindows 7 and later, and Excel 2007 and later.