ExcelFlux
← Workbooks

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.

Worksheet from the completed Excel sample
View from the Excel workbook. Open the image to enlarge it.
MeasureSample result
Total open on report date1,300
F-101 open and overdue800
Days overdue for F-10111 days

How do you start with your own data?

  1. Set the as-of date and assign each invoice a unique code on the blank sheet.
  2. Enter each payment with the matching invoice code, date and amount in the right-hand table.
  3. Resolve check warnings and read the open balance alongside each invoice’s status.