Skip to main content
InvoicingTemplate.com 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 Uniform Invoice Software. This is what you will see when you open past-due-uis.xlsx.

Past Due Invoice Template (UIS Edition)

Past Due Invoice Template - UIS edition

Download

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.

DescriptionSizeDownload

Without database file. How to download and use

117 KBDownload

Download this if you have already installed UIS, but are looking for additional customized templates.

361 KBDownload

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

2.83 MBDownload

Detail

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 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 InvoicingTemplate.com, 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 or 2016.

Format and Specification

Template#c5107
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
Columns5
Lines12
Line Height (Points)19.50
Print Area$F$3:$N$48
Papaer Size / OrientationPortrait
Default Margins (Points)
Left22.68
Right22.68
Top45.35
Bottom45.35