An accounts receivable Excel template is a spreadsheet that logs every customer invoice and automatically works out what is still outstanding, whether it is overdue, and how many days late it is. You enter the customer, invoice number, invoice date, due date, amount, and amount paid, and the template calculates the rest.
The free template below tracks invoiced, paid and outstanding totals, flags each invoice as Paid, Open or Overdue against today's date, and shows your overdue total at a glance. It opens in Excel or Google Sheets and uses only simple functions (TODAY, IF, SUM, SUMIF). Replace the sample rows with your own invoices and you have a working accounts receivable tracker in minutes.
Spreadsheets are still the fastest way for a small business to keep on top of who owes what. The trick is letting formulas do the aging and status for you so the sheet stays current without manual updates.
What is inside the template
One tab tracks your invoices; a second explains how to use it. The columns are:
| Column | What it does |
|---|---|
| Customer, Invoice #, Invoice date, Due date, Amount, Amount paid | You enter these |
| Outstanding | Amount minus amount paid, calculated |
| Days overdue | Days past the due date, from today, calculated |
| Status | Paid, Open or Overdue, calculated |
The TOTAL row sums invoiced, paid and outstanding, and a separate cell shows your overdue total so you know exactly how much is past due right now.
How do I track accounts receivable in Excel?
Create a row per invoice with the customer, invoice number, invoice date, due date, amount and amount paid, then use formulas to calculate outstanding (amount minus paid), days overdue (=MAX(0, today - due date)) and a status flag. The template above already contains these formulas, so you only enter the invoice details.What should an accounts receivable spreadsheet include?
At a minimum: customer, invoice number, invoice and due dates, amount, amount paid, outstanding balance, days overdue and a status. Totals for invoiced, paid and outstanding, plus an overdue total, make it a usable tracker rather than just a list.Does the template work in Google Sheets?
Yes. Open the Excel file in Google Sheets with File, then Import, then Upload, or use the CSV. The functions used (TODAY, IF, MAX, SUM, SUMIF) work the same in Excel and Google Sheets.How do I calculate overdue invoices automatically?
Use the due date and today's date. Days overdue is =MAX(0, TODAY() - due date) when an invoice is still outstanding, and the status is Overdue when today is past the due date and the balance is above zero. The template flags these for you.Is a spreadsheet enough, or do I need software?
A spreadsheet is fine for a small, manageable book of invoices. As volumes grow, reminders, late fees and reconciliation become time-consuming by hand, which is when teams move to dedicated accounts receivable software. See our independent software guide.Last updated June 9, 2026. This guide is general information, not accounting, tax, or financial advice.