UniformSoftware main content

Past Due Invoice Template

Template#: c5107

Download

DescriptionSizeDownload

The template works with both the Microsoft Store edition and the desktop edition of the app. Make sure you have installed one of them.

How to use:

  1. Download the EXE package.
  2. Double-click to extract the files into a folder. Make sure you have full access privileges to the folder, such as a subfolder inside “My Documents”.
  3. Open the template.
432 KBDownload

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

Screenshot

The screen shot for Past Due Invoice Template

Detail

When an invoice is past due, you send a past-due letter for collection. If the client has made new purchases, you can also include the overdue amount or previous balance in the new invoice to show the total amount due.

This form is a revised version of Previous Balance (Sales) (c5007). A version for service is also available at Previous Balance (Service) (c5027).

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 balance due and the previous balance due.

Here is a list of the custom fields used in this template and database:

Database tableField nameField type
InvHdrAccountBalanceDecimal (12,2)
InvHdrTotalBalanceDecimal (12,2)

Format and Specification

Template#c5107
Belongs to

Sales

Format (XLS or XLSX).xlsx
Columns5
Lines12
Line Height (Points)19.50
Print Area$F$3:$N$48
Papaer OrientationPortrait
Default Margins (Points)
Left22.68
Right22.68
Top45.35
Bottom45.35
PriceFree