Open Invoices and Aging
Link invoices to partial payments. See open and overdue balances as of the selected date.
Macro-free .xlsx · Includes a worked example
Results from the sample workbook
- Total open on report date
- 1,300
- F-101 open and overdue
- 800
- Days overdue for F-101
- 11 days
Who can use it, and for what?
Accounting and collections
Find what to follow up after a partial payment.
Service firms and businesses selling on credit
Separate invoices due today from invoices already overdue.
A worked example from the workbook
On the 12 November report, F-101 shows 400 paid against a 1,200 invoice. The remaining 800 is 11 days overdue. A payment dated 13 November is outside that report.

| Measure | Sample result |
|---|---|
| Total open on report date | 1,300 |
| F-101 open and overdue | 800 |
| Days overdue for F-101 | 11 days |
How do you start with your own data?
- Set the as-of date and assign each invoice a unique code on the blank sheet.
- Enter each payment with the matching invoice code, date and amount in the right-hand table.
- Resolve check warnings and read the open balance alongside each invoice’s status.