What the template includes
- Invoices: customer, number, date, payment terms, amount, amount paid. Due date, outstanding balance and days overdue calculate automatically. 200 rows.
- Aging buckets: not yet due, 1–30, 31–60, 61–90, 90+ days.
- Summary: balance by customer, buckets, overdue share and a chart.
How to use it
- Enter the report date (usually today).
- Copy in open invoices and enter payments in the "Paid" column.
- Every week, check debts more than 30 days overdue and contact the customer.
- For debts more than 90 days overdue, consider stopping new sales and taking legal steps.
To see how debts affect cash flow: DSO calculator and cash gap calculator.