Accounts Receivable Tracker — How to Track What You're Owed Without Accounting Software

An accounts receivable tracker is how small businesses stay on top of who owes them money without losing track in email threads or spreadsheets that haven't been opened in three weeks. Accounts receivable is just a formal name for money people owe you — and knowing exactly what's outstanding, and for how long, is one of the most important things you can track.

You don't need accounting software to do it. A well-structured spreadsheet, reviewed weekly, gives you everything you need to stay on top of what you're owed and follow up before small delays become real problems.

Why accounts receivable tracking matters

Revenue on paper and cash in your account are two different things. A bill tracker shows what you owe; accounts receivable shows what you're owed — you need both to see the full picture. A business can be profitable on its invoices and still run out of money if those invoices aren't getting paid. This is called a cash flow problem, and it's one of the most common reasons small businesses struggle even when they're winning work.

Tracking accounts receivable gives you early warning. When you can see that a client is 45 days overdue on a $4,000 invoice, you can act. When that invoice is buried in an email thread and you've lost track of it, you can't.

What your accounts receivable tracker needs

One row per invoice. At minimum, each row should capture:

The ageing report — your most important view

The single most useful thing you can do with your accounts receivable tracker is sort it by days overdue. This creates what accountants call an ageing report — a ranked list of who owes you money, from the most overdue to the most recent.

The ageing buckets that matter are:

Current — invoiced and not yet due. No action needed.

1–30 days overdue — send a polite reminder. Most late payments in this bucket are genuine oversights.

31–60 days overdue — follow up directly. A phone call is more effective than another email at this point.

61–90 days overdue — escalate. Consider pausing work for this client until the invoice is resolved.

90+ days overdue — formal demand or debt collection. At this point the relationship is secondary to recovering the money.

Looking at your tracker through this lens every week tells you exactly who to contact and with what level of urgency.

How to follow up on overdue invoices

The first reminder — friendly

Send this at 7 days overdue. Keep it brief and assume it's an oversight. Reference the invoice number and amount, give them an easy way to pay, and ask if there's anything they need from you to process it. Most late payments are resolved at this stage.

The second reminder — direct

Send this at 21 days overdue. The tone shifts from friendly to businesslike. State that the invoice is now X days overdue, confirm the amount, and ask when you can expect payment. Add that you're available to discuss if there's an issue.

The phone call

At 30–45 days overdue, stop emailing and call. Emails are easy to ignore or deprioritise. A phone call is harder to avoid and often resolves payment faster than any number of follow-up emails. Keep the call factual and professional — you're not there to argue, just to confirm when the invoice will be paid.

Formal demand

At 60+ days overdue with no response to reminders and calls, send a formal letter of demand. This is a written notice that payment is required by a specific date and that you will pursue recovery through legal channels or a debt collection agency if payment is not received. Some businesses resolve invoices at this stage simply because the formal letter signals that you're serious.

Preventing late payments before they happen

Clear payment terms on every invoice. State the due date explicitly — not "Net 30" without a date. Write: "Payment due by 15 April 2025." Ambiguous terms create ambiguous expectations. A professional invoice template includes the due date, your bank details, and your payment terms by default.

Invoice immediately. The sooner an invoice goes out after work is completed, the sooner the clock starts. Delaying invoicing by a week is effectively extending credit by a week for no reason.

Deposits for new clients. For clients you haven't worked with before, require a deposit before work starts. This filters out clients who never intended to pay promptly and gives you partial coverage if a dispute arises.

Make payment easy. The harder it is to pay you, the longer it takes. Accept bank transfer, credit card, and any other method your clients actually use. Include your bank details on every invoice so they don't have to ask.

What to do when a client disputes an invoice

Mark it in your notes column immediately. Record the date of the dispute, what the client claims, and what your position is. Keep all communication in writing from this point forward.

Disputes fall into two categories: genuine misunderstandings about scope or quality, and manufactured disputes designed to delay payment. The first can usually be resolved with a conversation and, if necessary, a partial credit. The second requires you to have clear documentation of what was agreed, what was delivered, and the communications history.

This is why written quotes, written scope changes, and written sign-off matter. They're not bureaucracy — they're protection.

Reviewing your tracker weekly

Set aside 15 minutes every Monday morning — blocking it into your work-from-home weekly schedule makes it a non-negotiable habit. Open the tracker, sort by days overdue, and work through the list from the top:

Anything new overdue this week — send the first reminder. Anything in the 21-day bucket — send the second reminder. Anything over 30 days with no response — make the call. Update the notes column after every action so you have a clean record of what's been done.

Fifteen minutes a week is the entire maintenance cost of a system that protects your cash flow. Most businesses that have cash flow problems aren't short of revenue — they're short of follow-up.