TOOLS CLUB TEMPLATE

Accounts Receivable Ledger Template

If you invoice more than a couple of clients, keeping track of who owes what — and for how long — gets hard fast without a dedicated system. This ledger tracks every invoice by customer, with automatic running balances, so nothing slips through unnoticed.

Join the Tools Club — $7/mo Already a Member? Log In

Included in the $7/mo Tools Club · Works in Excel or Google Sheets · Includes a built-in AI prompt

Who this is for

Business owners invoicing multiple clients regularly
Freelancers juggling several active client balances at once
Anyone who has lost track of an unpaid invoice before
Bookkeepers managing receivables for a small business client

What's included

Per-customer invoice log with amount, date, and due date
Automatic running outstanding balance per customer
Payment tracking against each invoice
Built-in AI prompt to flag customers trending toward chronic late payment

Why use a template instead of starting from scratch?

Tracking who owes you money from memory or scattered invoice emails means something eventually gets missed. A dedicated ledger gives you one place to see every customer’s outstanding balance at a glance, instead of reconstructing it from your inbox every time you need to know.

How to Use This Template

Download and open in Excel or Google Sheets

Requires a Tools Club membership — log in first to access the file.

Set up a row for each customer

Group multiple invoices under the same customer to see their total outstanding balance.

Log every invoice as you send it

Amount, invoice date, and due date, tied to the right customer.

Record payments as they come in

Mark each invoice paid and watch the running balance update automatically.

Run the built-in AI prompt periodically

Attach the saved file to ChatGPT or Claude and ask which customers are trending toward chronic late payment.

Built-in AI prompt

Once you've filled this template in, it includes a ready-to-use prompt at the bottom of the sheet. Attach your saved file to ChatGPT, Claude, or any AI chat tool and paste it in — you'll get plain-English feedback on which customers are trending toward chronic late payment, and which overdue balances are worth following up on first, no accounting background required.

Common Mistakes to Avoid

Not updating it the moment an invoice is sent

The ledger is only useful if it stays current — log every invoice immediately, not in a weekly batch.

Forgetting to record partial payments

A customer who pays part of an invoice needs that partial payment reflected, or the outstanding balance will be wrong going forward.

Losing track of very old outstanding invoices

The oldest unpaid invoices are the ones most likely to become uncollectible — review anything significantly overdue regularly, not just recent invoices.

Mixing this up with your revenue figures

Revenue is recognized when earned, not when collected — this ledger tracks what’s owed, separate from your P&L revenue recognition.

Frequently Asked Questions

What’s the difference between accounts receivable and revenue?

Revenue is recorded on your P&L when it’s earned, regardless of whether you’ve been paid. Accounts receivable specifically tracks the cash still owed to you for invoices already sent — this ledger is about collection, not recognition.

How is this different from the AR Aging Report Template?

This ledger is your ongoing transaction-level record of every invoice and payment by customer. The AR Aging Report groups your outstanding balances by how overdue they are (0-30 days, 31-60, etc.) — a snapshot view built from data like this.

How often should I update this?

Every time you send an invoice or receive a payment — real-time updates are what make it a reliable source of truth.

Is this included in the free plan?

No, this is a Tools Club template. iLuvAccounting also has a free Invoice Template if you just need to create individual invoices.

What should I do about a customer with a growing overdue balance?

Follow up promptly and consistently — the AI Prompt Library has ready-to-use overdue-payment follow-up prompts, and this ledger helps you catch the pattern early rather than after it’s become a large balance.

Should I write off an invoice that will never be paid?

That’s a decision to make with your accountant, since it has tax implications — but keeping accurate records here is what makes that eventual decision possible.

Can I track multiple invoices per customer in one place?

Yes — that’s the core purpose of this ledger, grouping every invoice by customer so you see their total outstanding balance, not just individual invoices in isolation.

Related Templates

Related Resources

Want the Full Template Library?

70+ editable templates, each with a built-in AI prompt. $7/month, cancel anytime.

Join the Tools Club