Table of Contents
- The Complete 20-Step Year-End Accounts Receivable Checklist
- Year-End Accounts Receivable Checklist: Quick Reference
- What Happens If You Skip Year-End Accounts Receivable Cleanup?
- Accounts Receivable Cleanup Example: Before and After
- How to Complete Your AR Cleanup in 30 Days
- Which Businesses Need a Year-End AR Cleanup Most?
- How to Prevent Accounts Receivable Problems in 2027
- When Should You Hire an Accounting Consultant for AR Cleanup?
- How Shah & Associates Helps With Year-End Accounts Receivable Cleanup
- FAQs
- Final Thoughts: Don’t Carry Unresolved Receivables Into 2027
As 2026 comes to an end, many business owners are reviewing revenue, expenses, payroll, and taxes. But one critical area often receives less attention: accounts receivable (AR).
Your business may have generated strong sales throughout the year, but how much of that revenue has actually been collected?
Unpaid customer invoices, unapplied payments, outdated balances, billing disputes, and inaccurate receivable records can create problems that follow your business into 2027.
A year-end accounts receivable cleanup helps you identify those issues before closing your books.
Whether you operate a construction company, professional services firm, healthcare business, wholesale company, or growing small business, this year end accounts receivable checklist will help you organize outstanding invoices, improve collection visibility, identify potential bad debts, and prepare more reliable financial statements.
At Shah & Associates, an Accounting & Business Consulting firm serving businesses across the United States, we believe year-end accounting should do more than prepare numbers for tax season. It should give business owners the financial clarity needed to make better decisions.
What Is a Year-End Accounts Receivable Cleanup?
A year-end accounts receivable cleanup is the process of reviewing, reconciling, correcting, and organizing unpaid customer invoices and related balances before closing the accounting year.
It typically includes reviewing an AR aging report, matching payments to invoices, investigating overdue accounts, correcting duplicate or inaccurate entries, resolving credit balances, evaluating potentially uncollectible amounts, and reconciling the AR subledger with the general ledger.
The goal is to begin 2027 with accurate customer balances, reliable financial reporting, and a clear collection plan.
Why Should You Clean Up Accounts Receivable Before 2027?
For businesses using a calendar-year reporting period, December 31, 2026, is an important financial cutoff.
Your accounts receivable balance may influence:
- The accuracy of your balance sheet
- Working capital reporting
- Customer collection decisions
- Cash flow forecasting
- Lending discussions
- Revenue reporting
- Allowances for credit losses, where applicable
- Tax planning and recordkeeping
- Financial decisions for 2027
A high receivables balance is not necessarily positive.
If a significant portion is overdue or unlikely to be collected, the amount shown on your balance sheet may not reflect the cash you realistically expect to receive.
A proper year-end review helps distinguish between invoiced revenue, collectible receivables, and actual cash.

The Complete 20-Step Year-End Accounts Receivable Checklist
1. Generate an Accounts Receivable Aging Report
Start by running an AR aging report dated December 31, 2026, once year-end transactions have been properly recorded.
Your report should identify:
- Customer name
- Invoice number
- Invoice date
- Due date
- Original invoice amount
- Payments received
- Remaining balance
- Days overdue
A typical aging report groups balances into current, 1–30, 31–60, 61–90, and more than 90 days overdue.
Example: Accounts Receivable Aging Report
| Aging Category | Outstanding Balance |
|---|---|
| Current | $85,000 |
| 1–30 days overdue | $42,000 |
| 31–60 days overdue | $28,000 |
| 61–90 days overdue | $18,000 |
| More than 90 days overdue | $27,000 |
| Total AR | $200,000 |
In this example, $73,000 is more than 30 days overdue.
That represents 36.5% of total accounts receivable.
The business should investigate the underlying invoices and determine which balances need collection action, correction, or further evaluation.
Year-end action: Export and retain a dated copy of the AR aging report.
2. Reconcile Accounts Receivable With the General Ledger
Your customer-level AR records should agree with the accounts receivable control account in the general ledger.
For example:
AR aging report: $200,000
General ledger AR balance: $207,500
Difference: $7,500
That discrepancy requires investigation.
Possible causes include:
- Manual journal entries
- Missing invoices
- Incorrect payment applications
- Duplicate entries
- Posting-date differences
- Adjustments made outside the customer subledger
Do not simply post a balancing journal entry without identifying the underlying cause.
Year-end action: Reconcile the AR subledger to the general ledger and document all differences.
3. Review Every Outstanding Customer Invoice
Not every invoice appearing as unpaid is necessarily collectible or even correctly recorded.
Review invoices for:
- Incorrect customer information
- Duplicate billing
- Incorrect amounts
- Missing purchase orders
- Wrong payment terms
- Unapproved work
- Billing disputes
- Incomplete supporting documentation
Pay particular attention to large balances and older invoices.
A $25,000 invoice that has been disputed for six months deserves a different response than a $500 invoice that became due yesterday.
Year-end action: Create a prioritized list of invoices requiring investigation.
4. Identify Duplicate Invoices
Duplicate invoices can inflate receivables and distort customer balances.
For example, an invoice may have been entered twice because:
- It was imported automatically and entered manually.
- Two employees processed the same transaction.
- A corrected invoice was issued without properly handling the original.
- Data was duplicated during a software migration.
Compare customer names, invoice numbers, dates, amounts, and supporting records.
Year-end action: Correct confirmed duplicates using the appropriate accounting process while maintaining a clear audit trail.
5. Match Unapplied Customer Payments
An unapplied payment occurs when a customer payment has been recorded but not correctly matched to an invoice.
For example:
Customer invoice: $8,000
Customer payment received: $8,000
Invoice still shows unpaid because the payment was not applied.
The business may unnecessarily contact the customer for payment.
Unapplied payments can also distort AR aging and customer statements.
Year-end action: Review unapplied receipts and match them to the correct invoices using payment documentation.
6. Investigate Customer Credit Balances
A customer may have a credit balance because of:
- Overpayment
- Duplicate payment
- Credit memo
- Refund
- Incorrect payment application
- Advance payment
These balances should not be ignored or automatically offset against unrelated invoices.
Determine whether the balance represents a legitimate customer credit, a refund obligation, an advance, or a bookkeeping error.
Year-end action: Investigate credit balances and classify them correctly.
7. Review All Invoices More Than 90 Days Overdue
Older invoices require closer attention.
An invoice that remains unpaid for more than 90 days may indicate:
- Customer financial difficulties
- Billing disputes
- Missing documentation
- Weak collection procedures
- Incorrect customer information
- Potential collectibility problems
Do not automatically assume every invoice over 90 days old is uncollectible.
Review the customer’s payment history, communication, contract terms, and current circumstances.
Year-end action: Categorize older balances into collectible, disputed, payment-plan, and potentially uncollectible accounts.
8. Contact Customers With Overdue Balances
Year-end is a useful opportunity to follow up on outstanding invoices.
A professional collection message should identify:
- Invoice number
- Outstanding amount
- Original due date
- Payment instructions
- Contact information for questions
For larger balances, consider direct communication with the customer’s accounts payable team.
The objective is to resolve issues and encourage payment without damaging valuable business relationships.
Year-end action: Assign an owner and follow-up date to each material overdue balance.
9. Resolve Billing Disputes Before Closing the Books
An unpaid invoice may not be a collection problem.
It may be a billing problem.
Common disputes include:
- Incorrect pricing
- Incomplete services
- Missing purchase orders
- Unapproved change orders
- Quantity discrepancies
- Contract interpretation
- Customer dissatisfaction
Work with the sales, operations, and billing teams to understand the cause.
If a credit memo or adjustment is warranted, record it in the appropriate accounting period based on the facts and applicable accounting policies.
Year-end action: Maintain a dispute log showing the issue, responsible person, expected resolution, and accounting treatment.
10. Review Credit Memos and Refunds
Credit memos reduce customer balances and may affect revenue reporting.
Review:
- Issued credit memos
- Unapplied credits
- Pending refunds
- Approved customer adjustments
- Credits issued after year-end that relate to earlier transactions
Confirm that every adjustment is supported and authorized.
Year-end action: Resolve outstanding credits and verify their accounting treatment.
11. Check the December 2026 Revenue Cutoff
Year-end accounting requires careful attention to timing.
For accrual-basis businesses, revenue recognition generally depends on when the applicable recognition criteria are met – not simply when an invoice is issued or paid.
For cash-basis federal income tax reporting, receipt and constructive receipt rules can produce different timing results.
Examples requiring review include:
- December services billed in January
- January services invoiced in December
- Customer deposits
- Advance payments
- Year-end credit memos
- Payments received near December 31
The financial reporting treatment and federal tax treatment may differ.
Year-end action: Review transactions around December 31, 2026, using the business’s applicable accounting and tax methods.
12. Evaluate Potentially Uncollectible Receivables
Some customer balances may not be fully recoverable.
Warning signs include:
- Repeated missed payment commitments
- Customer bankruptcy
- Extended collection delays
- Financial distress
- Unresolved disputes
- Failed collection attempts
Businesses preparing financial statements under U.S. GAAP may need to evaluate expected credit losses under applicable accounting guidance.
The appropriate approach depends on the company’s reporting framework and circumstances.
Year-end action: Document collectibility concerns and evaluate whether an accounting adjustment is necessary.
13. Review Bad Debt Write-Offs Carefully
A bad debt write-off should not be used simply to make an aging report look cleaner.
Before writing off an invoice, determine:
- Whether the debt is genuinely uncollectible
- Whether collection efforts are documented
- Whether the amount was previously recognized as income where required
- Whether the proposed treatment is appropriate for financial reporting
- Whether it qualifies for a federal tax deduction
Important U.S. tax distinction: An accrual-method business that previously included an eligible receivable in income may qualify for a bad debt deduction when the relevant tax requirements are met. A cash-method business generally cannot deduct an unpaid customer invoice that was never included in taxable income.
A bookkeeping write-off and a tax deduction are not automatically the same thing.
Year-end action: Obtain an appropriate review before recording material bad debt adjustments.
14. Review Customer Deposits and Advance Payments
Cash received before goods or services are delivered may need different treatment from an ordinary payment of an outstanding invoice.
For example:
A customer pays $15,000 in December 2026 for services scheduled in February 2027.
Depending on the accounting framework and tax rules, this amount may require separate treatment from revenue earned during 2026.
Do not automatically classify every customer receipt as payment of an existing receivable.
Year-end action: Identify deposits, advances, and deferred-revenue balances separately where applicable.
15. Confirm Customer Statements and Large Balances
For material accounts, consider sending customer statements or requesting balance confirmations as an internal reconciliation practice.
This can help identify:
- Payments not recorded
- Missing invoices
- Disputed charges
- Customer credits
- Differences between customer and company records
Not every small business needs formal balance confirmations.
Prioritize large customers, unusual balances, and accounts with frequent disputes.
Year-end action: Investigate discrepancies and retain supporting correspondence.
16. Calculate Days Sales Outstanding (DSO)
Days Sales Outstanding estimates how long a business takes to collect receivables.
A common calculation is:
DSO = Average Accounts Receivable ÷ Credit Sales × Number of Days
Example:
Average AR: $180,000
Annual credit sales: $1,800,000
Days: 365
DSO:
36.5 days
This suggests an average collection period of approximately 37 days under the simplified calculation.
DSO is most useful when compared with prior periods, payment terms, and the business’s operating model.
Year-end action: Calculate DSO for 2026 and establish a monitoring target for 2027.
17. Identify Customer Concentration Risk
If one customer represents a large share of outstanding receivables, your business may face concentrated collection risk.
For example:
Total AR: $300,000
Largest customer balance: $120,000
Customer concentration:
40%
A delayed payment from that customer could create a meaningful cash shortage.
Review the largest outstanding balances and consider their impact on liquidity.
Year-end action: Identify the top five or ten customers by AR balance and evaluate collection exposure.
18. Update Your 2027 Cash Flow Forecast
Outstanding invoices should feed into cash planning.
Do not assume every invoice will be collected on its due date.
Forecast collections based on:
- Customer payment history
- Invoice aging
- Confirmed payment commitments
- Billing disputes
- Contractual terms
- Expected collection delays
For example, a $200,000 receivables balance does not necessarily mean $200,000 will arrive in January.
Year-end action: Build a realistic January–March 2027 collection forecast.
19. Preserve Supporting Documentation
Maintain organized records of:
- Customer invoices
- Contracts
- Purchase orders
- Payment confirmations
- Bank deposits
- Credit memos
- Customer statements
- Collection correspondence
- Write-off approvals
- Reconciliation workpapers
These records support accurate financial reporting, tax preparation, and future account investigations.
Year-end action: Store documentation securely and follow applicable retention requirements.
20. Create a 2027 Accounts Receivable Collection Policy
Year-end cleanup should lead to better systems – not simply a one-time correction.
Create clear procedures for:
- Customer credit approval
- Invoice timing
- Payment terms
- Payment reminders
- Overdue follow-up
- Dispute resolution
- Credit memos
- Write-offs
- AR aging review
- Management escalation
Assign responsibility to specific employees or teams.
Year-end action: Establish a recurring AR review process for 2027.
Year-End Accounts Receivable Checklist: Quick Reference
| Checklist Item | Priority | Recommended Timing |
|---|---|---|
| Generate AR aging report | High | December / year-end close |
| Reconcile AR to general ledger | High | Year-end close |
| Review unpaid invoices | High | November–December |
| Remove confirmed duplicate entries | High | Before final close |
| Match unapplied payments | High | Before final close |
| Investigate customer credits | High | Before final close |
| Review 90+ day balances | High | November–December |
| Follow up on overdue invoices | High | Throughout Q4 |
| Resolve billing disputes | High | Before final close where possible |
| Review credit memos | High | Year-end close |
| Check revenue cutoff | High | December–January |
| Evaluate uncollectible accounts | High | Year-end close |
| Review bad debt treatment | High | Before final reporting/tax filing |
| Review customer deposits | High | Year-end close |
| Confirm material customer balances | Medium | December–January |
| Calculate DSO | Medium | After year-end data is ready |
| Assess customer concentration | Medium | December–January |
| Forecast 2027 collections | High | December–January |
| Organize supporting records | High | Year-end close |
| Update AR collection policy | Medium | January 2027 |
What Happens If You Skip Year-End Accounts Receivable Cleanup?
Your Balance Sheet May Be Misleading
Accounts receivable may include:
- Duplicate invoices
- Incorrect balances
- Unapplied payments
- Disputed amounts
- Potentially uncollectible balances
These issues can make it harder to evaluate financial health.
Your Cash Flow Forecast May Be Unrealistic
If management assumes all receivables will be collected promptly, it may overestimate available cash.
That can affect hiring, inventory purchases, payroll planning, and expansion.
Your 2027 Collection Process May Start Behind
Old unresolved invoices do not disappear on January 1.
Without a clear collection plan, overdue balances can continue aging while new invoices accumulate.
Your Financial Reporting May Become Less Reliable
Incorrect receivables can affect reported assets and, depending on the underlying error, revenue, credit-loss expenses, and other financial statement accounts.
Your Tax Preparation May Become More Complicated
Unresolved invoices, inconsistent revenue timing, and unsupported bad debt adjustments can create additional year-end questions.
Accounts Receivable Cleanup Example: Before and After
Consider a hypothetical U.S. service business with $450,000 in reported accounts receivable at year-end.
A detailed review identifies:
| Finding | Amount |
|---|---|
| Starting reported AR | $450,000 |
| Duplicate invoices | -$15,000 |
| Customer credit memos requiring correction | -$8,000 |
| Unapplied payments requiring reconciliation | -$22,000 |
| Corrected gross AR | $405,000 |
The business also identifies $30,000 in older receivables requiring collectibility evaluation.
Important: That $30,000 should not automatically be removed from the books or treated as a tax deduction. It requires review under the applicable financial reporting and tax rules.
The cleanup produces two valuable outcomes:
- A more reliable customer receivables balance.
- A clearer understanding of which balances require collection or accounting action.
The improvement is not simply cosmetic. It helps management make better financial decisions.
How to Complete Your AR Cleanup in 30 Days
Week 1: Review and Reconcile
- Export the AR aging report.
- Reconcile AR to the general ledger.
- Identify duplicate invoices.
- Investigate unapplied payments.
- Review customer credits.
Week 2: Investigate Outstanding Balances
- Review older invoices.
- Contact customers.
- Resolve billing disputes.
- Confirm major balances.
- Review missing documentation.
Week 3: Evaluate Accounting Adjustments
- Review potential bad debts.
- Investigate customer deposits.
- Check revenue cutoff.
- Review credit memos.
- Document proposed adjustments.
Week 4: Finalize and Plan for 2027
- Complete approved corrections.
- Produce an updated AR aging report.
- Calculate DSO.
- Update the cash forecast.
- Establish collection responsibilities.
- Prepare the final reconciliation package.
Note: For a calendar-year business, the final December 31 reconciliation and cutoff review will normally be completed after year-end when the necessary records are available. This 30-day plan can begin in December and continue into January.
Which Businesses Need a Year-End AR Cleanup Most?
Construction Companies
Construction businesses may have:
- Progress billings
- Retainage
- Change orders
- Long payment cycles
- Contract disputes
They should distinguish ordinary trade receivables from other contract-related balances where applicable.
Professional Services Firms
Consultants, agencies, and other service providers should review:
- Unbilled services
- Outstanding invoices
- Client disputes
- Retainers
- Project-related credits
Healthcare Practices
Healthcare organizations may need to investigate:
- Patient balances
- Insurance-related receivables
- Contractual adjustments
- Denials
- Delayed reimbursements
Wholesale and Distribution Businesses
These businesses should pay particular attention to:
- Customer credit limits
- Large outstanding balances
- Returns
- Credit memos
- Payment deductions
Multi-Location Businesses
Companies operating multiple locations should ensure customer balances are recorded in the correct entity or location and that reporting is consistent.

How to Prevent Accounts Receivable Problems in 2027
The best year-end cleanup is the one that reveals what needs to change.
Consider establishing these recurring controls:
Weekly: Review overdue invoices and collection commitments.
Monthly: Reconcile the AR subledger, review aging, investigate unapplied payments, and evaluate significant disputes.
Quarterly: Analyze DSO, customer concentration, credit policies, and recurring collection problems.
Annually: Complete a documented year-end AR reconciliation, cutoff review, and collectibility assessment.
These processes help prevent old problems from accumulating again.
When Should You Hire an Accounting Consultant for AR Cleanup?
Professional support may be useful when:
- AR reports do not match the general ledger.
- Bookkeeping is several months behind.
- Unapplied payments are accumulating.
- Customer balances are unreliable.
- Management cannot explain overdue receivables.
- Financial statements are needed for financing.
- The company has multiple locations or entities.
- Bad debt and revenue-cutoff questions are becoming complicated.
- The owner needs a stronger monthly collection and reporting process.
An accounting consultant can help organize records, improve reconciliation procedures, strengthen financial reporting, and build more reliable management processes.
How Shah & Associates Helps With Year-End Accounts Receivable Cleanup
Shah & Associates is an Accounting & Business Consulting firm serving businesses across the United States.
We help business owners improve the accounting processes and financial visibility needed for better decision-making.
Depending on your business’s requirements, our accounting and business consulting support may include:
- Bookkeeping cleanup
- Accounts receivable reconciliation
- AR aging review
- Financial reporting
- Cash flow analysis
- Cash flow forecasting
- Working capital analysis
- Accounting process improvement
- Monthly financial reviews
- Year-end bookkeeping readiness
- Business financial planning
Our goal is to help business owners move into 2027 with more reliable financial records, clearer collection priorities, and better cash flow visibility.
FAQs
What is a year-end accounts receivable checklist?
A year-end accounts receivable checklist is a set of tasks used to review unpaid customer invoices, reconcile AR balances, investigate unapplied payments, evaluate overdue accounts, and prepare accurate receivable records for year-end financial reporting.
Why should businesses clean up accounts receivable before 2027?
Cleaning up receivables helps identify billing errors, overdue invoices, customer credits, and potentially uncollectible amounts. It also improves financial reporting and helps businesses plan collections and cash flow for the new year.
What should be included in an AR aging report?
An AR aging report typically includes customer names, invoice numbers, due dates, outstanding balances, and aging categories that show how long invoices have remained unpaid.
How do you reconcile accounts receivable at year-end?
Compare the total customer-level AR subledger with the accounts receivable control account in the general ledger. Investigate differences involving invoices, payments, credit memos, adjustments, and posting dates.
Should all unpaid invoices be written off at year-end?
No. Unpaid invoices are not automatically uncollectible. Businesses should investigate the customer’s circumstances, collection history, and applicable accounting requirements before recording a write-off.
Can a business deduct unpaid invoices as bad debt?
It depends on the tax method and circumstances. An accrual-method business may qualify when an eligible amount was previously included in income and applicable bad debt requirements are met. A cash-method business generally cannot deduct an unpaid invoice that was never included in taxable income.
What is the difference between bad debt expense and a bad debt write-off?
Bad debt expense may reflect an estimated credit loss under an applicable accounting framework. A write-off removes a specific receivable when the required criteria are met. The accounting treatment and federal tax treatment may differ.
What is an unapplied customer payment?
An unapplied payment is money received from a customer that has not been correctly matched to an outstanding invoice or otherwise classified.
How do customer credit balances affect AR?
Customer credits may represent overpayments, refunds, advance payments, or other adjustments. They should be investigated and classified correctly rather than left unresolved.
What is DSO in accounts receivable?
Days Sales Outstanding is a metric estimating how long a business takes to collect receivables. It is commonly calculated using average AR, credit sales, and the number of days in the period.
What is a good DSO for a small business?
There is no universal ideal DSO. A useful target depends on the industry, payment terms, customer mix, and business model. Compare DSO with contractual payment terms and historical performance.
Should accounts receivable be reviewed monthly?
Yes. Regular monthly reconciliation and aging analysis can help identify problems before they become larger year-end issues. Some businesses also benefit from weekly collection reviews.
How does accounts receivable affect cash flow?
Accounts receivable represents amounts owed by customers. Slow collections can create cash shortages because the business may need to pay employees, vendors, and other obligations before customers pay.
Can AR cleanup improve profitability?
AR cleanup can improve financial accuracy and help identify collection losses, billing errors, and process weaknesses. It does not automatically increase profit, but the findings can support better financial decisions.
What is the difference between AR and revenue?
Revenue represents income recognized from business activities under the applicable accounting method. Accounts receivable represents amounts owed by customers. Revenue recognition and cash collection can occur at different times.
Should customer deposits be included in accounts receivable?
Customer deposits and advance payments require appropriate classification based on their nature and the applicable accounting framework. They should not automatically be treated as payments against existing receivables.
How long should businesses keep accounts receivable records?
Retention periods depend on the documents, applicable tax rules, legal obligations, and business circumstances. Businesses should maintain records long enough to support financial and tax reporting requirements.
What should businesses do with invoices older than 90 days?
Investigate the invoice, contact the customer, resolve disputes, document collection efforts, and evaluate collectibility. An invoice’s age alone does not automatically justify writing it off.
Can accounting software automatically clean up AR?
Accounting software can assist with aging reports, payment matching, reminders, and reconciliation. However, disputed balances, duplicate invoices, cutoff issues, and potential write-offs often require human review.
When should a business hire an accounting consultant for year-end cleanup?
Professional support may be valuable when receivables do not reconcile, customer balances are unreliable, bookkeeping is behind, significant invoices are overdue, or management needs better financial reporting and cash flow visibility.
Final Thoughts: Don’t Carry Unresolved Receivables Into 2027
A profitable year on paper does not guarantee strong cash flow.
If your business has unresolved invoices, unapplied payments, inaccurate customer balances, or overdue receivables, those problems can affect your financial visibility long after December 31.
Completing a year end accounts receivable checklist helps you identify those issues, correct your records, strengthen collections, and prepare more reliable financial reports.
The most important actions are to:
- Reconcile receivables.
- Investigate outstanding invoices.
- Resolve payment and credit discrepancies.
- Evaluate collection risks.
- Review year-end accounting treatment.
- Forecast incoming cash.
- Improve collection procedures for 2027.
A cleaner accounts receivable system gives your business a stronger starting point for the new year.
Start 2027 With Cleaner Books and Better Cash Flow Visibility
Are overdue invoices, unreconciled customer balances, or outdated bookkeeping making it difficult to understand your company’s financial position?
Shah & Associates helps U.S. businesses improve bookkeeping, accounts receivable processes, financial reporting, and cash flow management.



[…] Year-end payroll reconciliation is not simply an administrative task. […]