Free Accounts Receivable Template (Excel)

What's in the accounts receivable template

The template is a single AR Ledger with 200 rows, built for one line per invoice: customer name, invoice number, invoice date, payment terms in days, the amount billed, and any amount already paid.

That's enough structure to run your whole receivables process from one tab instead of juggling a separate note for who's paid and who hasn't. Every invoice you're owed money on lives in the same list, sorted however you like by customer or by date.

A Collection notes column sits at the end of each row so you can log what happened on a follow-up call, a promised payment date, or a dispute, right next to the invoice it relates to.

Aging buckets: Current through 90+

The moment you enter an invoice date and payment terms, the template computes a due date automatically. From there, days overdue and the aging bucket update on their own: Current, 1-30, 31-60, 61-90, or 90+.

The summary block at the top totals your outstanding AR by bucket, so you can see at a glance how much of what you're owed is fresh versus how much is aging into risky territory.

Balances that slip into 61-90 or 90+ are flagged with conditional formatting, which makes the accounts that need a phone call today obvious without scanning every row.

What calculates automatically

Due date, balance due, days overdue, and the aging bucket assignment all calculate as soon as you enter the invoice date, terms, amount, and any payment received. There's no formula to write or drag down.

The only manual work is entering the invoice details themselves. Everything downstream stays correct as you add rows, mark payments, and update your collection notes.

AR ledger vs. AR KPI dashboard

This page is the ledger: the raw invoice-by-invoice record of who owes you what and how overdue it is. If you also want DSO, percent overdue, and AR turnover calculated from that data, the free AR KPI Dashboard template is the companion page built for that analytics layer.

Most businesses start here with the ledger, since it's the record you need day to day for collections. The KPI dashboard is the next step once you want to report on receivables health rather than chase individual invoices.

Who this template is for

Small businesses and freelancers who invoice on terms - net 30 or net 60 - and need a simple, reliable way to see who's paid and who isn't are the core fit. If you're issuing a handful to a few dozen invoices a month, this ledger does the job without a subscription.

It also works well as a stopgap for a business between accounting tools, or for a bookkeeper managing AR for a few small clients who don't have their own system yet.

Because it's just Excel or Google Sheets, anyone on your team can open it, add an invoice, and see the current aging picture without training or a login.