Skip to content
Nika

📥 Free Accounts Receivable Template

Below is a complete accounts receivable tracker: client, invoice number, amount, due date, and collection status. Copy it into a spreadsheet and know exactly who owes you money and how late they are.

Accounts receivable is the money customers owe you for goods or services you’ve already delivered. The faster you collect, the healthier your cash flow. This template helps you track every outstanding invoice, prioritise follow-ups, and spot chronic late payers before they become a problem.

Invoice Tracker Columns

FieldsDescription
Client / Customer*Who owes you money.
Invoice Number*Your invoice reference.
Invoice Date*When you issued the invoice.
Due Date*When payment is expected.
Amount (net)*Excluding VAT/tax.
VAT / TaxTax portion, if applicable.
Total Due*Net + VAT.
Status*Sent / Partially Paid / Paid / Overdue.
Amount ReceivedWhat the client has paid so far.
Balance Outstanding*Total Due − Amount Received.
Last Follow-up DateWhen you last chased the payment.

Aging Summary

FieldsDescription
Current*Not yet due.
1–30 Days Overdue*Send a friendly reminder.
31–60 Days OverdueEscalate — call the client.
60+ Days OverdueConsider a final demand or collection.
Total Receivables*Sum of all outstanding invoices.

How to use

  1. 1Log every invoice the moment you issue it — don’t wait.
  2. 2Filter by Due Date and Status to see what is overdue.
  3. 3Send a reminder 3–5 days before the due date as a courtesy.
  4. 4Follow up the day after a payment is late — the longer you wait, the harder it is to collect.
  5. 5Record every partial payment immediately so the Balance Outstanding is always accurate.
  6. 6Review the Aging Summary weekly and prioritise the oldest overdue invoices.

Or automate this

Chasing late payments manually is uncomfortable and easy to put off. Nika can send automated payment reminders on a schedule, record incoming payments, and flag overdue accounts — from {price} per invoice. She does the uncomfortable follow-up so you can focus on the work.

Questions

What is a good accounts receivable turnover ratio?

It depends on your industry, but generally a higher ratio is better — it means you collect faster. Calculate it as Net Credit Sales ÷ Average Accounts Receivable. Compare it to your payment terms: if your terms are Net 30 but your average collection is 55 days, customers are paying late.

When should I write off an uncollectable invoice?

Typically after 90–180 days of non-payment with documented follow-up attempts. The invoice can then be moved to a bad-debt expense, which may be tax-deductible. Consult your accountant for the rules in your jurisdiction and keep records of all collection efforts.

Automate with Nika

Other templates