Skip to main content
InvoicingTemplate.com main content

How to Use

Assuming you have downloaded and installed Uniform Invoice Software:

  1. Download Past Due Invoice Template. Double-click the downloaded file to extract all files.
  2. Open the template "past-due.xlsx" or "past-due-uis.xlsx" with Microsoft Excel.
  3. Click "Design Mode" on the "Invoice" Excel ribbon tab to put it into design mode.
  4. Enter your business information and replace the default logo image to make it your own. (How?)
  5. Click "Design Mode" again to exit design mode.
  6. Create invoice (tutorial movie)!

Prefer to have a look at other samples? Try our Search tool!

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 Past Due Invoice Template (c5107)

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

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

364 KBDownload

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

2.82 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.

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, Past 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
Printable with Papaer Size / OrientationA4 (210 mm x 297 mm) - Portrait
Default Margins (Points)
Left22.68
Right22.68
Top45.35
Bottom45.35

Sample Templates