Every December, small finance teams face the same headache. You are staring at a ledger filled with unapplied deposits, old outstanding balances, and mismatched accounts while trying to close the books on time. Waiting until December 31 to sort through months of customer balances leads to long nights and delayed tax filings.
Taking a systematic approach to your accounts receivable (AR) ledger now ensures your financial statements are accurate before they reach your CPA. This checklist is not formal tax advice—always consult a certified public accountant (CPA) regarding your specific tax position.
Here is your step-by-step checklist to clean up your open AR before year-end.
1. Run and review your aging AR report
Your cleanup starts with a clear view of who owes you money and how long those balances have been outstanding. Pull an accounts receivable aging report from your billing system or accounting software.
This report groups your unpaid invoices into standard time buckets:
- Current (0–30 days)
- Past due (31–60 days)
- Past due (61–90 days)
- Past due (90+ days)
Reviewing these buckets helps you spot immediate problems. For example, a balance in the 90+ day bucket might be an invoice that a customer ignored—or it could be a dispute your team forgot to resolve. A clean aging report is the foundation of your year-end AR cleanup. It tells you exactly where to focus your collection efforts and which accounts require deeper investigation.
2. Match payments to open invoices
Sometimes, a customer pays their bill, but the payment is never properly linked to their invoice in your system. This often happens when clients pay via ACH or wire transfer without including an invoice number—leaving the funds sitting in an unapplied deposits account.
Go through your bank deposits and match them against outstanding invoices. Check for:
- Partial payments: A client might have paid a portion of an invoice while disputing the rest.
- Mismatched names: The deposit might come from a parent company name that does not match the customer name in your billing system.
- Double-entry errors: Ensure a payment was not manually entered twice—which artificially lowers your outstanding AR.
Reconcile every bank deposit to ensure your open invoice list is accurate. If you skip this step, you risk chasing clients for payments they already made—which damages customer relationships.
A worked example of payment matching
Let us look at a realistic example of how unmatched payments distort your books.
Suppose your company, Acme Services, has an open invoice for Customer ABC for $5,000. In October, you received an ACH transfer of $5,000 from "Holdings LLC" with no memo line. Because the names did not match, the transaction was placed into an unapplied cash account.
At year-end, your AR aging report still shows Customer ABC owes $5,000. Meanwhile, your bank reconciliation shows $5,000 in unapplied cash. By matching the $5,000 deposit from Holdings LLC to Customer ABC's open invoice, you reduce your open AR balance to $0 and correctly close out the transaction before tax season.
3. Identify and write off uncollectible bad debt
Despite your best collection efforts, some invoices will never be paid. This might happen because a client went out of business, filed for bankruptcy—or simply disappeared.
Leaving these dead invoices on your books artificially inflates your assets. To fix this, you must identify which outstanding invoices are truly uncollectible and write them off as bad debt.
When writing off bad debt:
- Establish a clear policy: For example, you might decide that any invoice over 120 days past due with no customer contact is a candidate for a write-off.
- Document your efforts: Keep records of your emails and phone calls to show you made a reasonable effort to collect the debt.
- Consult your CPA: The way you write off bad debt depends on your accounting method. Your CPA will help you adjust your general ledger correctly.
Writing off bad debt keeps your balance sheet accurate and can reduce your taxable income—depending on your tax filing status.
4. Address credit memos and overpayments
Customer credits and overpayments can quietly distort your financial reporting if they are left unaddressed at year-end. This occurs when a customer pays more than the invoiced amount—or when you issue a credit memo for a return or discount but never apply it.
During your cleanup, review all outstanding credit balances:
- Apply open credits: If the customer has an active open invoice, apply the credit memo to reduce their outstanding balance.
- Issue refunds: If the customer has no active invoices and you do not expect future business from them, issue a refund check or card reversal.
- Verify balances: Ensure that credit memos were not created in error to cover up unpaid invoices that should have been marked as bad debt.
Clear out outstanding credits to present a true AR balance to your accountant. This prevents your liabilities and assets from being overstated.
5. Sync your invoicing data with your accounting software
Many small businesses use one platform to send invoices and another to manage their general ledger. If these two systems do not share data perfectly, discrepancies will emerge.
Before you hand your books over to your accountant, perform a complete sync between your invoicing tool and your accounting software—such as QuickBooks Online or Xero.
Look for common sync errors:
- Invoices that exist in your billing tool but did not transfer to your ledger.
- Payments marked as received in your accounting software that still show as "unpaid" in your invoicing system.
- Tax rate discrepancies between the two platforms.
A tight integration between your invoicing tool and general ledger prevents manual reconciliation errors. It ensures that your profit and loss statement matches your sub-ledgers.
6. Export clean reports for your CPA
Once your payments are matched, bad debts are written off, and your systems are synced, you are ready to prepare your final reports. Your CPA will need these documents to file your taxes accurately and find potential deductions.
Gather the following reports for your tax professional:
- Year-end AR aging summary and detail reports.
- A list of all bad debt write-offs made during the fiscal year.
- A reconciliation report showing that your AR sub-ledger matches your general ledger balance.
Providing organized, reconciled reports saves your CPA time and reduces your tax preparation costs.
Using a dedicated platform like LedgerFlow simplifies this entire process. LedgerFlow helps you track open invoices, view your AR aging dashboard, and keep your data aligned with QuickBooks Online or Xero through a direct two-way sync. This keeps your books organized month after month—so you do not have to scramble when tax season arrives.
If you want to simplify your year-end reconciliation, LedgerFlow can help you automate your invoice tracking and keep your records clean.
FAQs
When should I start my year-end accounts receivable cleanup?
It is best to start your AR cleanup at least four to six weeks before the end of your fiscal year. This gives your finance team enough time to contact slow-paying clients, resolve disputes—and consult with your CPA on bad debt write-offs.
How does writing off bad debt affect my taxes?
Writing off uncollectible invoices reduces your accounts receivable asset balance and—depending on whether you use accrual or cash accounting—can reduce your taxable income. You should consult a certified CPA to determine the correct tax treatment for your specific business.
What is the difference between cash and accrual accounting for year-end AR?
Under accrual accounting, you record revenue when the invoice is sent—meaning open AR affects your tax liability and uncollectible invoices must be formally written off. Under cash accounting, you only record revenue when payment is received, so unpaid invoices do not impact your taxable income.
How can I prevent AR cleanup issues next year?
You can minimize year-end cleanup by automating payment reminders, reviewing your aging reports monthly rather than annually, and using invoicing software that syncs directly with your accounting platform.