How to Track Accounts Receivable: Fields, Reports and a Weekly Routine

To track accounts receivable, keep a live record of every unpaid invoice with its customer, amount, invoice date, due date and days past due, then review it on a fixed weekly schedule and act on anything overdue. Most businesses start in a spreadsheet, move to the aging report in their accounting system as volume grows, and adopt dedicated software once the number of open invoices exceeds what one person can chase by hand. The tracking itself is easy; doing something about what it shows every single week is the part that decides whether you get paid.

Tracking receivables has a low ceiling as a skill and a very high cost when it lapses. Any competent bookkeeper can produce an accurate list of who owes you what. What separates businesses with a 32-day DSO from ones sitting at 58 is not the quality of the report, it is what happens in the two hours after someone reads it.

What does it mean to track accounts receivable?

Tracking accounts receivable means maintaining a current, accurate view of every invoice you have issued that has not yet been paid, along with how overdue each one is and what has been done about it. A complete tracking record answers four questions at any moment: how much are we owed in total, who owes it, how old is each balance, and what is the next action on each account.

That last column is the one most systems leave out, and it is the one that turns a report into a process.

What to track for every open invoice

Whatever tool you use, these are the fields that earn their place:

How to track accounts receivable in Excel

A spreadsheet is a perfectly reasonable starting point under roughly 50 open invoices. Build one row per invoice with the fields above, then add a formula for days past due (=TODAY()-[due date]) and a bucket column that sorts each invoice into current, 1 to 30, 31 to 60, 61 to 90 and 90-plus days. Conditional formatting on the bucket column gives you a usable aging view in about twenty minutes.

Two rules make the difference between a spreadsheet that works and one that quietly rots. First, update it on a fixed day each week, not when you remember. Second, never let it become the system of record: it should be reconciled against your accounting system every time you touch it, because the moment the two disagree, people stop trusting the sheet and it dies.

The honest limitation is that a spreadsheet tracks but does not act. It will tell you eleven invoices crossed 30 days this week. It will not email any of them.

How to track accounts receivable in QuickBooks

If your books are already in QuickBooks, use the built-in aging report rather than rebuilding it by hand. Run Reports, then Accounts Receivable Aging Summary for the overview, or Aging Detail to see individual invoices. Set the aging buckets to match your terms, and memorize the report so it lands in your inbox on the same day each week.

QuickBooks also lets you set automatic invoice reminders, which is worth switching on. Be clear about what that gets you: a scheduled email to the invoice contact. It does not follow up on the reply, escalate when nothing happens, or tell you which customer has quietly stretched from 28 days to 51. Our walkthrough of how to automate accounts receivable in QuickBooks covers what is achievable natively and where it stops. Xero, NetSuite and Sage Intacct all offer a broadly similar aging report and reminder combination.

How often should you review your receivables?

Weekly, at a set time, with someone accountable for the actions that come out of it. Monthly is too slow: an invoice reviewed for the first time at day 35 has already passed the point where a quick call would have fixed it. Daily is unnecessary for most businesses and turns into box-ticking.

The review should take fifteen minutes and produce a list, not a feeling. Which invoices crossed a bucket boundary this week, which promised payment dates were missed, which accounts need escalating, and which need a human conversation rather than another email.

The metrics worth tracking alongside the list

The invoice list tells you today's position. These tell you whether it is getting better or worse:

• Days sales outstanding. The headline number: how long, on average, it takes to collect. Our DSO explainer covers the formula and what a good number looks like in your industry.
• Percentage current. The share of your total AR that is not yet past due. Falling means trouble is building even if the total looks flat.
• Aging distribution. The shape across buckets. A growing 60-plus column is the earliest reliable warning of bad debt.
• Collection effectiveness index. How much of what was collectible you actually collected. See our AR KPIs guide.
• Average days delinquent. How late the late ones are, which DSO alone can hide.

Track the trend, not the snapshot. A DSO of 44 means nothing on its own; a DSO that has gone 38, 41, 44 over three months means you have a problem forming right now.

When does tracking stop being enough?

There is a reasonably clear threshold. Once you have more open invoices than one person can personally follow up on in a week, the tracking stays accurate but the acting quietly stops, and your aging report becomes an increasingly precise description of a problem nobody has time to fix.

The symptoms are consistent: the aging report is up to date but the 60-plus bucket keeps growing, follow-ups happen when someone is annoyed rather than on schedule, payments arrive that nobody can match to an invoice, and the same three customers get chased while forty smaller balances drift. At that point better tracking is not the answer. If pulling answers out of your ledger has itself become the bottleneck, being able to ask questions of your data in plain English is a faster route than another pivot table, but it still leaves the chasing undone.

What changes the outcome is moving the follow-up off a person's memory. Accounts receivable software that chases on a schedule turns the aging report from a record of the past into something acted on automatically: every invoice followed up as it ages, escalating from email to SMS to a phone call, with incoming payments matched back to the ledger. Our guide on whether you need AR automation software works through the threshold honestly, including when the answer is no.

A simple weekly routine that works

1. Pull the aging report from your accounting system on the same day each week.
2. Reconcile anything that looks wrong, especially partial payments and credits.
3. List every invoice that crossed a bucket boundary since last week.
4. Check every promised payment date that has passed and follow up the same day.
5. Escalate anything over 60 days to a call, not another email.
6. Flag disputes separately and route them for resolution rather than chasing them.
7. Record the DSO and percentage-current figures so you have a trend by month three.

Seven steps, fifteen minutes, done every week without exception. That routine outperforms almost any software running inconsistently.

The bottom line

Track every open invoice with its due date, days past due and next action, review the list weekly at a fixed time, and watch DSO and your aging distribution as trends rather than snapshots. Start in a spreadsheet if you are small, graduate to your accounting system's aging report as you grow, and move to dedicated software at the point where you can see the problem clearly but no longer have the hours to chase it. Tracking receivables well is genuinely easy. Acting on what the tracking shows, every week, for every invoice, is the hard part, and it is the only part that turns into cash.