How to Track Accounts Receivable
Accurate accounts receivable tracking keeps your cash position, your revenue, and your balance sheet trustworthy. This step by step guide walks through how to track accounts receivable, with real examples and a printable checklist.
Tracking accounts receivable is the practice of recording every invoice you issue, applying every payment you receive, and confirming that the balance each customer still owes matches what is actually outstanding. Accurate receivables are what make your cash position, your revenue, and your balance sheet trustworthy. When receivables drift, you collect late, you write off invoices you could have recovered, and your reports overstate the money you expect to receive.
This guide walks through how to track accounts receivable from start to finish. It is written for small business owners who handle their own books and for teams who want a consistent routine to follow every month. If your books are already behind, start with our guide on catch up bookkeeping and how to get back on track before you attempt a clean receivables pass.
How to Track Accounts Receivable
Tracking accounts receivable is a methodical process, not a quick scan. Work through these steps in order, one invoice and one payment at a time, until every receivable is recorded, every payment is applied, and your aging matches what is actually outstanding.
1. Issue Every Invoice Promptly and Accurately
Receivables tracking starts the moment you issue an invoice. Send every invoice promptly after the work is completed or the product is delivered, and confirm the customer name, invoice number, date, line items, amount, and payment terms are all correct before it goes out. A delayed or incorrect invoice is a delayed or disputed payment. The faster an accurate invoice reaches your customer, the faster it becomes a receivable you can track.
Why it matters. You cannot track a receivable that was never recorded. Late invoices mean late payments and a receivables balance that understates what you actually earned.
Common mistake. Waiting until the end of the month to issue all your invoices at once. By then, some customers have already forgotten the details, and disputes take longer to resolve.
2. Record Every Invoice in Your Books
Enter every issued invoice into your bookkeeping software as an accounts receivable transaction, posted to the correct customer and the correct revenue account. Confirm the invoice amount, date, and due date match the invoice you sent. If you report on an accrual basis, recording the invoice is what recognizes the revenue for the period it was earned. If you report on a cash basis, the invoice still creates the receivable you will track until it is paid.
Why it matters. Every open invoice is a receivable. An invoice that exists in your billing tool but not in your books is money owed that your reports do not see.
Common mistake. Issuing invoices from a separate billing tool and never entering them in your bookkeeping software. The receivable exists for the customer but not for your books.
3. Apply Every Received Payment to the Correct Invoice
When a payment arrives, record it and apply it to the specific invoice it pays off. Match the payment amount to the invoice amount, confirm the customer name matches, and let your software mark that invoice as paid. A payment recorded but not applied sits as unapplied cash and leaves the old invoice open, which makes both your receivables and your cash look wrong at the same time.
Why it matters. Applied payments are what close invoices and reduce your receivables balance. Unapplied payments leave open invoices that distort what is actually owed.
Common mistake. Recording a deposit as a lump of cash without matching it to the invoice. The invoice stays open, the customer appears to still owe you, and the aging is wrong.
4. Reconcile Receivables to Your Bank Deposits
Confirm that every payment you applied to a receivable also cleared your bank account as a deposit. Match each applied payment to the corresponding bank transaction, and investigate any payment that appears applied in your books but has not cleared the bank. Reconciling receivables to your bank deposits is what proves the cash actually arrived. For a full walkthrough, see our guide on how to reconcile a business bank account.
Why it matters. An applied payment that never cleared the bank is not real cash. Reconciliation is what catches payments recorded but never received.
Common mistake. Marking an invoice paid based on a payment confirmation alone, without confirming the deposit cleared. A failed or reversed transfer leaves the invoice open and the cash missing.
5. Review Your Accounts Receivable Aging Regularly
Pull your accounts receivable aging report on a set schedule, ideally every week or every two weeks. The aging groups open invoices by how long they have been outstanding, such as current, up to 30 days, up to 60 days, up to 90 days, and over 90 days. Scan every line for invoices that are older than they should be, balances that look unfamiliar, and customers whose total has crept up. The aging report is your early warning system for slow payers.
Why it matters. The aging report shows you exactly which invoices need attention before they become uncollectible. Without it, you find out about problem accounts only when a balance is already too old to recover.
Common mistake. Looking only at the total receivables balance. A total that looks fine can still hide a single large overdue invoice that needs immediate follow up.
6. Follow Up on Overdue Invoices
Contact customers about invoices that have passed their due date. Send a polite reminder with the invoice attached, confirm the customer received it, and ask when payment is expected. Track each promise to pay and follow up again if the date passes without payment. Consistent follow up is the single most effective way to shorten the time it takes to collect, and it keeps small delays from turning into write offs.
Why it matters. Customers pay the vendors who follow up. A reminder is often all it takes to move an invoice to the top of the pile.
Common mistake. Avoiding follow up because it feels uncomfortable. The longer an invoice sits unpaid, the lower the chance you ever collect it.
7. Record Customer Deposits and Prepayments Correctly
When a customer pays before the work is completed, record the payment as a customer deposit or unearned revenue liability rather than as revenue. The deposit is money you owe in service or product until the work is delivered, not income you have earned. When the invoice is issued or the work is completed, apply the deposit to the invoice to close it out. Recording a prepayment as revenue overstates your income and your receivables at the same time.
Why it matters. A prepayment is a liability until it is earned. Recording it as revenue overstates your income and misstates what you still owe the customer.
Common mistake. Recording a deposit as a direct payment against revenue. The income is recognized before it is earned, and the receivable never appears when the invoice is later issued.
8. Handle Partial Payments Without Closing the Invoice
When a customer pays part of an invoice, record the partial payment and apply it to the invoice, but leave the invoice open for the remaining balance. Confirm the remaining amount matches what the customer still owes. Closing the invoice on a partial payment hides the outstanding balance and makes your receivables understated. Track each partial payment so the aging reflects the true amount still due.
Why it matters. A partially paid invoice is still partially open. Closing it hides the remaining balance and makes the customer appear current when they are not.
Common mistake. Marking an invoice paid when a partial payment arrives. The remaining balance disappears from your aging and from your follow up list.
9. Write Off Uncollectible Invoices Deliberately
When an invoice is truly uncollectible, write it off deliberately and record the decision. Document the reason, the amount, and the date, and remove the balance from your receivables so your aging reflects only what is still collectible. A written off invoice is a deliberate decision, not a balance that quietly drifted to zero. Keep a record of every write off so you can explain the change in your receivables at year end.
Why it matters. A stale receivable you will never collect overstates your assets and your revenue. Writing it off keeps your books honest.
Common mistake. Letting an old invoice sit open for years because no one wants to admit it will not be collected. The balance stays in your aging and your reports long after it is real.
10. Separate Receivables From Your Overall Cash Balance
Understand that your receivables balance is not the same as your cash balance. Receivables are money you have earned but have not yet collected, while cash is money you have actually received. Reading a receivables total as available cash leads to spending decisions your bank account cannot support. Track both balances separately so you always know what you have collected and what you still expect.
Why it matters. Receivables and cash tell different stories. Confusing the two leads to overdrafts and spending based on money you do not have yet.
Common mistake. Treating a large receivables balance as proof the business can afford a purchase. Until the invoices are collected, that money is not in the bank.
11. Review Receivables During Every Monthly Close
Make receivables review a fixed part of your monthly close. Pull the aging, confirm every open invoice is real, investigate any negative balances, and confirm your total receivables matches the balance on your balance sheet. A monthly review catches problems while they are small and keeps your aging accurate all year. Pair it with your broader routine using our monthly bookkeeping checklist for small businesses.
Why it matters. A monthly review keeps your receivables accurate and your collections on track. Skip it and small errors compound into a cleanup.
Common mistake. Reviewing receivables only when cash looks tight. By then, the aging is usually months behind and the oldest invoices are already hard to collect.
12. Keep Customer Notes and Payment History
Keep a short note on each customer account with their payment habits, preferred payment method, and any history of disputes or late payments. Notes help you spot patterns, set appropriate credit terms, and hand off cleanly if someone new takes over the books. A customer who always pays at 45 days is not late, they are predictable, and your notes let you plan around it.
Why it matters. Payment history is context. Without it, every overdue invoice looks like a surprise when some customers are simply slow but reliable.
Common mistake. Deleting old payment notes to keep the account clean. The history is what helps you tell a slow payer from a problem account.
13. Confirm Receivables Match the Balance Sheet
At the end of every month, confirm your total accounts receivable aging matches the accounts receivable balance on your balance sheet. If the two disagree, one of them is wrong, and the difference is usually an unapplied payment, a missing invoice, or a write off that was never posted. A receivables balance that matches the balance sheet is the proof your tracking is complete.
Why it matters. The aging and the balance sheet must agree. A mismatch means a transaction was recorded in one place but not the other.
Common mistake. Trusting the balance sheet total without checking it against the aging. A correct total can still hide a wrong individual balance.
14. Lock the Period After the Receivables Review
Once every invoice is recorded, every payment is applied, every write off is posted, and the aging matches the balance sheet, lock the period. Locking prevents future edits to the transactions you just confirmed, which protects the integrity of the month and keeps the next review clean. A locked period is a protected baseline that the next month builds on.
Why it matters. A locked close is a fixed reference point. Without it, a later edit can silently change a prior month and reopen gaps you already resolved.
Common mistake. Leaving the period unlocked because you might need to adjust it later. Edits to a closed period are exactly what create discrepancies in future months.
Two Real Small Business Examples
Example: A small landscaping company. A landscaping owner issued invoices from his scheduling app but entered them in his bookkeeping software only when a payment arrived. His receivables balance was always understated, and he could not tell which customers owed him money at any given time. He started entering every invoice the day it was issued, applied each payment to the correct invoice, and reviewed his aging every two weeks. Within one month, his receivables matched his balance sheet, his collections sped up, and he caught two invoices he had completely forgotten to send.
Example: A growing consulting firm. A consulting firm owner recorded every deposit as a lump of cash without matching it to the invoice it paid. Her bank balance looked right, but her aging showed dozens of open invoices that had actually been paid months earlier. During her monthly close, she matched each deposit to its invoice, cleared the aging, and confirmed her total receivables matched her balance sheet for the first time. Without that review, the open invoices would have stayed on the books and distorted her reported revenue.
Printable Accounts Receivable Tracking Checklist
Use this checklist to track your accounts receivable every month. Print it, save it, or share it with whoever handles your books.
- Issue every invoice promptly and confirm the details are correct.
- Record every invoice in your bookkeeping software as a receivable.
- Apply every received payment to the specific invoice it pays off.
- Reconcile every applied payment to the bank deposit that cleared.
- Pull your accounts receivable aging on a set schedule.
- Follow up on every overdue invoice and track each promise to pay.
- Record customer deposits and prepayments as liabilities, not revenue.
- Keep invoices open for the remaining balance after a partial payment.
- Write off uncollectible invoices deliberately and document the reason.
- Track receivables and cash separately so you know what is collected.
- Review receivables as a fixed part of every monthly close.
- Keep customer notes on payment habits and dispute history.
- Confirm the aging total matches the balance sheet each month.
- Lock the period after the receivables review is complete.
Getting Started
Tracking accounts receivable is the discipline that turns invoicing into cash. Every invoice you record, every payment you apply, and every aging you review keeps your balances accurate and your collections on track. The good news is that the process is the same every month: issue every invoice, apply every payment, review the aging, and confirm the totals match. If your receivables are already behind or the tracking feels overwhelming, the best next step is a conversation about where your books stand today.
Ready to track your receivables accurately every month? Explore our bookkeeping services and let us record every invoice, apply every payment, and review your aging each month. We handle bookkeeping and payroll. We do not prepare income tax returns, offer tax planning, or perform audits, but we keep your books accurate and organized so you can run your business and your tax preparer can do their part efficiently.
Frequently Asked Questions
What does it mean to track accounts receivable?
Tracking accounts receivable means recording every invoice you issue, applying every payment you receive to the correct invoice, and confirming the balance each customer still owes matches what is actually outstanding. Accurate receivables keep your cash position, your revenue, and your balance sheet trustworthy.
How often should I review my accounts receivable aging?
Review your aging at least every two weeks, and make it a fixed part of your monthly close. The aging report groups open invoices by how long they have been outstanding, so it shows you exactly which invoices need attention before they become uncollectible. Waiting only until cash looks tight usually means the oldest invoices are already hard to recover.
Why do my receivables not match my bank balance?
Receivables are money you have earned but have not yet collected, while your bank balance is money you have actually received. They are different balances that tell different stories. Reading a receivables total as available cash leads to spending decisions your bank account cannot support, because the invoices have not been collected yet.
What is an unapplied payment, and why does it matter?
An unapplied payment is cash you received and recorded but never matched to the specific invoice it pays off. The payment sits as unapplied cash while the old invoice stays open, which makes both your receivables and your cash look wrong at the same time. Applying every payment to the correct invoice is what keeps both balances accurate.
How do I handle a customer who pays before the invoice is issued?
Record the prepayment as a customer deposit or unearned revenue liability rather than as revenue. The deposit is money you owe in service or product until the work is delivered, not income you have earned. When the invoice is issued or the work is completed, apply the deposit to the invoice to close it out.
When should I write off an invoice I cannot collect?
Write off an invoice only when you are confident it is truly uncollectible, and record the decision deliberately. Document the reason, the amount, and the date, and remove the balance from your receivables so your aging reflects only what is still collectible. A written off invoice is a deliberate decision, not a balance that quietly drifted to zero.
Can Chess Bookkeeping & Payroll track my accounts receivable for me?
Yes. Accounts receivable tracking is a core part of our bookkeeping service. We record every invoice, apply every payment, review your aging, and confirm your receivables match your balance sheet each month. We handle bookkeeping and payroll. We do not prepare income tax returns, offer tax planning, or perform audits, but we keep your books accurate and organized so your tax preparer can do their part efficiently.
Need help getting your books in order?
We focus exclusively on bookkeeping and payroll. Let's talk about where your books stand today.
Get StartedReady to simplify your books and payroll?
Schedule a consultation and let's talk about how precise bookkeeping and reliable payroll can give your business the clarity it deserves.