Accounts Receivable Aging Tracker

For small businesses that invoice other businesses on terms and need to know, every week, who owes what and how late it is.

List customers with their payment terms and credit limits, then enter invoices and the payments that arrive. The workbook works out each invoice's due date, what's been paid, the balance and how many days it is past due, and sorts every open balance into Current, 1–30, 31–60, 61–90 and over-90-day buckets as of the date you choose (change the limits on Settings). Part payments, overpayments, payments on account and payments quoted against the wrong invoice are handled and flagged instead of silently skewing the totals. Pick a customer on the Statement sheet to print a statement of account with their open items and aging. The Collections Log keeps every reminder and call, and marks each promise to pay as Kept, Pending or Broken by checking the payments that actually came in. The Dashboard shows total receivables, overdue %, DSO, average days to pay, customers over their credit limit, top overdue customers and a chart by age.

Included: worked-example and blank workbooks (9 sheets, 21,812 formulas; 150 customers, 1,500 invoices, 2,000 payments), plus a 7-page PDF in US Letter and A4 with a quick start, a collections playbook with reminder wording, and blank and filled statement, aging summary and collections call-log pages.

General information, not legal, credit or accounting advice.