Skip to main content main content
Sharing Is Caring! We do appreciate your efforts to let others know us!

Screenshots and Images

The printed version.

Past Due Invoice Template

Past Due Invoice Template (c5107)

c5107 now includes the customized invoice template for the latest version of Invoice Manager for Excel. This is what you will see when you open past-due.xlsx.

Past Due Invoice Template (IMFE Edition)

Past Due Invoice Template - IMFE edition


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 want this design to be set as the default template by the installer program.

3.74 MBDownload

Without database file. How to download and use

122 KBDownload

Download this if you have already installed IMFE, and are looking for additional customized templates; or if you want a template for Invoice Manager (Lite).

616 KBDownload


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)

Like other form designs here on, Payment Due Invoice Form is free (offered to you at a price of 0.00USD). It works on Windows XP and all newer versions of Windows, and Excel 2007, 2010, 2013, 2016 or 2019.

Format and Specification

NamePast Due Invoice Template
CategorySales Invoice Template
Release DateFriday, March 24, 2017
Format (XLS or XLSX).xlsx
Excel Version Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016 / Excel 2019
Line Height (Points)19.50
Print Area$F$3:$N$48
Papaer Size / OrientationPortrait
Default Margins (Points)