Sheet template · Finance
Accounts Receivable Tracker
Track invoices, due dates, payments, balances, aging, and collection follow-up in one receivables register.
Small businesses, agencies, and finance operators tracking unpaid invoices without a full accounts-receivable system.
Sign in to start an independent editable workbook from this Sheets template.
Structured preview
Accounts Receivable Tracker at a glance
Preview only9 columns · 3 sample rows
| Invoice # | Customer | Issue date | Due date | Invoice amount | Paid | Balance | Status | Next follow-up |
|---|---|---|---|---|---|---|---|---|
| INV-1042 | Northwind Office | 2026-09-01 | 2026-09-30 | $2,400 | $2,400 | =E4-F4 | Paid | — |
| INV-1047 | Harbor Lane | 2026-09-08 | 2026-10-08 | $5,800 | $2,000 | =E5-F5 | Part paid | 2026-10-02 |
| Open balance | =SUM(G4:G6) |
Update payment and follow-up fields as invoices move; aging and collection decisions remain a human review step.
What's included
- Invoice and customer register
- Due date and payment fields
- Balance formulas
- Status and next-follow-up fields for collections review
How to use it
- 1Add one row per invoice and keep invoice numbers consistent with your billing records.
- 2Update paid amounts and status whenever a payment arrives.
- 3Review open balances and due dates with the owner of your billing process; the sheet does not send reminders or make collection decisions.
Continue exploring