On December 15, your inbox fills with urgent requests from your tax preparer while you are still chasing a $12,000 invoice that is 90 days past due. For a small finance team, the final weeks of the fiscal year are a race against the calendar. Unreconciled invoices, unapplied credits, and forgotten bad debt distort your balance sheet — and they can lead to an unnecessarily high tax bill.
Cleaning up your accounts receivable (AR) before the year ends ensures your financial statements reflect reality. It also prevents your CPA from billing you extra hours to fix basic ledger errors.
This checklist provides a step-by-step process to clean up your AR ledger before tax season. Note: This guide is for educational purposes only and does not constitute formal tax advice. Always consult a certified public accountant (CPA) before making final adjustments to your books.
Step 1: Run and review your AR aging report
Your cleanup begins with a clear view of who owes you money and how long those balances have been outstanding. You need to pull your current AR aging report, which groups unpaid invoices into time-based buckets: 0–30 days, 31–60 days, 61–90 days, and over 90 days.
When you look at this report, pay close attention to the oldest buckets. Invoices in the 90+ and 120+ day columns represent your highest risk. Some of these might be simple disputes you can resolve with a phone call — others may be completely uncollectible. Identifying these balances early gives your team time to make one final collection push before the year ends.
Takeaway: An accurate aging report is the foundation of your entire year-end cleanup process.
Step 2: Match outstanding invoices against bank deposits
Before you call a client to demand payment on an overdue invoice, make sure they have not already paid. It is common for payments to arrive in your bank account but remain unapplied in your invoicing system. This happens when clients pay via bank transfer without including an invoice number — or when credit card payments are batched together without individual reconciliation.
Go through your bank deposits from the past twelve months. Match them against your open invoices to find any discrepancies. Watch out for:
- Bank fees: A client might have sent a wire transfer for $1,000, but after intermediary bank fees, you only received $985. The remaining $15 might still show as an open balance.
- Incorrect customer accounts: A payment from "Parent Company LLC" might have been applied to the wrong subsidiary account — leaving one account with an open invoice and another with an unapplied credit.
- Manual data entry errors: A team member might have recorded a $5,040 payment as $5,004, leaving a tiny, phantom balance open on the invoice.
Takeaway: Reconciling deposits first prevents you from chasing clients who have already paid.
Step 3: Identify and write off uncollectible bad debt
Once you have reconciled your deposits, you will likely be left with a handful of invoices that are truly uncollectible. This often happens when a client goes out of business, files for bankruptcy, or simply refuses to pay after multiple collection attempts.
To write these off, you must determine if they qualify as bad debt. Under IRS rules, if your business uses the accrual accounting method, you can generally deduct bad debts that were previously included in your gross income. If you use the cash method, you cannot write off these balances as bad debt because you never recorded the revenue in the first place.
Illustrative example: Writing off an uncollectible balance
Let us look at a realistic scenario. Suppose your business uses accrual accounting.
- In March, you sent an invoice for $6,000 for services rendered.
- You recorded this $6,000 as revenue on your books.
- In October, the client officially declared bankruptcy, and your legal team confirmed you will not receive payment.
- To clean this up, you must write off the $6,000 as bad debt. This adjustment reduces your accounts receivable balance and your taxable income by $6,000 — ensuring you do not pay income tax on money you never received.
Always document your collection efforts — such as emails, letters, and call logs — to prove to the IRS that the debt is genuinely worthless. Speak with your CPA to ensure you format these write-offs correctly in your general ledger.
Takeaway: Clean out dead accounts to avoid paying taxes on income you will never receive, but always verify write-offs with your CPA.
Step 4: Resolve unapplied credits and prepayments
Sometimes, your AR ledger shows negative balances. These are usually unapplied customer credits, overpayments, or deposits for work that has not yet been completed.
Leaving these credits unresolved can artificially understate your total AR balance. It can also complicate your tax filing. If a customer paid you a deposit for a project that starts next year, your CPA needs to know how to categorize that cash. Depending on your accounting method, it may need to be treated as deferred revenue rather than immediate income.
Review all negative balances on your aging report. Reach out to the customers to determine if the credit should be applied to an active invoice, held for a future project, or refunded via check or ACH.
Takeaway: Clearing unapplied credits ensures your balance sheet accurately reflects what you are owed.
Step 5: Verify your invoicing tool syncs with your accounting software
Many small finance teams use one platform for sending invoices and another, like QuickBooks Online or Xero, for their general ledger. If these two systems do not share data perfectly, your financial reports will be inconsistent.
Run a sync check between your systems. Compare the total AR balance on your invoicing dashboard with the AR balance on your general ledger's trial balance. If the numbers do not match, look for:
- Invoices created in your billing system that failed to export to your accounting software.
- Payments recorded directly in your general ledger that did not sync back to the original invoice.
- Direct journal entries made by an accountant that bypassed the invoicing tool entirely.
Resolving these discrepancies now prevents your CPA from spending expensive billable hours trying to locate missing transactions during tax preparation.
Takeaway: Your invoicing ledger and your general ledger must match perfectly before you hand files to your tax preparer.
Step 6: Export clean AR reports for your CPA
Once your ledger is clean, your final step is to package the data for your tax preparer. A standard tax preparation package should include your reconciled year-end AR aging report, a list of bad debt write-offs, and a report of any outstanding customer credits.
Using a dedicated invoicing platform makes this process much simpler. LedgerFlow helps you track outstanding balances with clear AR aging dashboards and automatically syncs your invoicing data with QuickBooks Online and Xero. This keeps your financial records consistent across both platforms — saving your team hours of manual export work at year-end.
Takeaway: Providing organized, reconciled reports to your CPA saves time and reduces tax preparation fees.
Streamline your year-end financial workflow
Managing accounts receivable does not have to be a source of stress every December. By maintaining a clean ledger throughout the year, you can avoid the rush of last-minute reconciliations and hand off pristine records to your accountant. LedgerFlow helps small businesses manage this process with professional invoicing, automated payment reminders, and clear AR aging reports that keep your cash flow predictable.
FAQs
When is the best time to start a year-end AR cleanup?
You should begin the cleanup process at least four to six weeks before your fiscal year ends. This gives your finance team enough time to contact slow-paying clients, resolve disputed invoices, and consult with your CPA regarding potential bad debt write-offs before the books officially close.
Can a business write off any unpaid invoice as bad debt?
No. You can only write off unpaid invoices if you use the accrual accounting method and have previously recognized the unpaid amount as income. If you use the cash method, you cannot write off bad debt because you never recorded the revenue. Always consult a certified public accountant (CPA) to confirm your eligibility.
What is the difference between AR reconciliation and bank reconciliation?
Bank reconciliation matches your bank statement transactions to your internal accounting records. AR reconciliation specifically ensures that the total of all individual unpaid customer invoices matches the accounts receivable balance on your general ledger and balance sheet.
How do unapplied customer credits affect year-end taxes?
Unapplied credits can distort your total accounts receivable balance, making it look lower than it actually is. Depending on your accounting method, unresolved prepayments might also need to be recognized as revenue in the current tax year — which is why they must be cleared or properly categorized before closing the books.