Collections Management Checklist
Aging Review and Triage
Pull the A/R aging summary and tie the total to the receivables control account on the trial balance. Investigate any variance before working the aging — a sub-ledger that doesn't tie usually means an unposted journal entry, a credit memo applied to the wrong invoice, or a deposit booked to income instead of A/R.
Run the aging by customer in QBO, Xero, or NetSuite as of the prior business day. Export to a working file and flag any account over 60 days, any balance over $5,000, and any customer whose total exposure exceeds their approved credit limit.
Determine the oldest material bucket on the aging — the answer drives the dunning cadence for the rest of the run. "120+" means an escalation conversation, not another email blast. Anything older than 90 days needs a named owner and a deadline before write-off review.
Before chasing a customer, confirm you haven't already received the money. Run the unapplied payments report and the open credit memos report; apply anything that matches an open invoice. Calling a customer about a paid invoice burns trust faster than any late notice.
Dunning and Customer Outreach
Use the standard friendly-reminder template with the invoice PDF re-attached and a payment link. Most 30-day balances are A/P-side processing delays, not disputes — keep the tone neutral and confirm the remit-to address.
Email-only chasing stops working past 60 days. Call the named A/P contact, confirm the invoice is in their system, and get a scheduled pay date. If they cite a missing PO or pricing dispute, route to the account owner before the call ends.
Send the final-demand letter via certified mail with return receipt and a PDF copy by email. The letter states the balance, the due date, and the consequence (credit hold, agency placement, or suit) with a hard response deadline of 10 business days.
Date, channel, person spoken to, promise-to-pay date, and any dispute reason go in the customer record. If this account ends up at a collections agency or in small-claims court, the contemporaneous log is the evidence — undocumented calls don't exist.
Dispute and Credit Hold
Route pricing, PO-mismatch, and short-ship disputes to the salesperson or project manager who owns the account, not to collections. Set a 5-business-day target to resolve. Disputes left open past 30 days are the single biggest driver of 90+ aging.
Flag the customer record in the GL/ERP so new orders or shipments require controller approval. Notify sales and operations the same day — discovering a hold after a truck has shipped is how A/R loses internal credibility.
Once the dispute is settled, void the original invoice or apply a credit memo with a clear memo line referencing the dispute case number. Re-send the corrected invoice with a fresh net-30 due date so the customer's A/P system has a clean record to pay against.
Escalation and Write-Off Review
Controller reviews each balance over 120 days with the account owner. The choices are agency placement (typical contingency 25-40%), small-claims or civil suit (under the state's jurisdictional limit), settlement at a discount, or write-off. Document the rationale on the customer file.
Submit the placement packet — signed contract or terms, invoice copies, statement of account, full communication log, and any signed POs. Stop direct contact with the customer the moment placement is confirmed; parallel collection efforts violate most agency contracts and confuse the debtor.
If using the allowance method, debit Allowance for Doubtful Accounts and credit A/R. If direct write-off (smaller cash-basis shops), debit Bad Debt Expense and credit A/R. Attach the controller-approved write-off memo as the workpaper. Do not write off anything that hasn't gone through the escalation review above.
Cash Application and Reporting
Match each deposit to specific invoices using the customer's remittance advice. Avoid the lazy pattern of applying to the oldest invoice automatically — that masks disputes and inflates DSO. Short payments need a written reason on the receipt before posting.
Refresh the dashboard with rolling 3-month DSO, CEI (collection effectiveness index), percentage current, and write-off rate. Variances of more than 5 days in DSO month-over-month deserve commentary in the package to the CFO.
The package: aging summary, top-10 overdue with owner and next action, disputes opened/resolved this week, accounts on credit hold, and KPI movement. Keep it to one page — the goal is decisions, not a data dump.
Use this template in Manifestly
- Monthly Close Process
- Budgeting and Forecasting Checklist
- Monthly Bookkeeping and Accounting Close
- Financial Statement Audit Checklist
- Business Succession Planning
- Expense Reporting and Reimbursement Checklist
- Bank Reconciliation Checklist
- Risk Management Checklist
- Fixed Assets Management Checklist
- Client Onboarding Checklist
- Accounts Receivable Checklist
- Cash Flow Analysis Checklist
- Consulting and Advisory Services Checklist
- Accounts Payable Checklist
- Tax Planning Checklist
- Account Reconciliation Checklist
- Audit Preparation Checklist
- Financial Reporting Checklist
- Business Valuation Checklist
- Payroll Processing Checklist
- Internal Controls Review Checklist
- New Business Structuring Checklist
- Chart of Accounts Maintenance Checklist
- Debt Management Checklist
- Journal Entry Checklist
- Lease Accounting Checklist
- Investment Reconciliation Checklist
- Regulatory Compliance Checklist
- Credit and Collections Checklist
- Loan Covenant Compliance Checklist
- Individual Tax Return Preparation Checklist
- Business Tax Compliance Checklist
- Cash Flow Management Checklist
- New Employee Onboarding Checklist (Accounting Department)
- New Client Onboarding Checklist
- Financial Analysis Checklist
- Employee Termination Checklist (Accounting Department)
- Employee Expense Policy Compliance Checklist
- Cost Accounting Checklist
- Accounting Policy Update Cycle
- Inventory Accounting Close Checklist
- Quarterly Budget Review Checklist
- Quarterly Internal Control Review Checklist
- Client Engagement Letter Renewal
- End-of-Month Sales and Revenue Reporting
- Capital Expenditure (CapEx) Approval Checklist
- Grant Accounting Checklist
- Performance Review Checklist (Accounting Staff)
- Accounting Software Migration Checklist
- Financial Statement Preparation Checklist
- Yearly Accounting Department Goals Setting
- Quarterly Financial Reporting Checklist
- Vendor Contract Negotiation Checklist
- Chart of Accounts Review Checklist
- Fixed Assets Audit Checklist
- Accounting Standards Update Adoption Checklist
- Sales Tax Reporting Checklist
- Merger and Acquisition Due Diligence Checklist
- Monthly Management Reports Checklist
- Financial Risk Assessment Checklist
- Firm Insurance Renewal Checklist
- Payroll Services Checklist
- Accounts Payable Ledger Checklist
- Quarterly Payroll Tax Compliance Checklist
- AP Payment Processing Checklist
- Vendor Setup and Maintenance Checklist
- Employee Expense Reimbursement Checklist
- Monthly Accounting Close Checklist
- Annual Financial Statements Checklist
- Accounting Department Workflow Optimization
- Accounts Payable Aging Report Checklist
- Payroll Tax Filing Checklist
- Corporate Tax Return Preparation Checklist
- Internal Audit Preparation Checklist
- Internal Control Procedures Checklist
- External Audit Preparation Checklist
- Daily Bookkeeping Checklist
- Customer Credit Approval Checklist
- Accounts Receivable Aging Report Checklist
- Budget Variance Analysis Checklist
- Cash Application Checklist
- Financial Audit Checklist
- Cost-Benefit Analysis Checklist
- Weekly Bookkeeping Checklist
- Client Engagement Closeout Checklist
- Corporate Tax Preparation Checklist
- Year-End Bookkeeping Checklist
- Billing Process Checklist
- Risk Assessment Checklist
- Cash Flow Analysis Checklist
- Legal Entity Management Checklist
- Monthly Financial Review Checklist
- M&A Due Diligence Checklist
- Post-Merger Audit Checklist
- Profitability Analysis Checklist
- Acquisition Integration Checklist
- Year-End Tax Planning Checklist
- Segregation of Duties Assessment
- Fraud Prevention Checklist
- Cash Management Checklist
- Financial Project Planning Checklist
- System Access Control Checklist
- SOX Compliance Checklist
- Financial Ratio Analysis Checklist
- Accounting Software Implementation Checklist
- Monthly Bookkeeping Close Checklist
- Tax Audit Documentation Checklist
- Contract Review Checklist
- Project Cost Control Checklist
- Deal Closure Checklist
- Engagement Risk Management Checklist
- Year-End Accounting Checklist
- Quarterly Bookkeeping Checklist
- Staff Offboarding Checklist
- Engagement Budgeting Checklist
- Monthly Financial Reporting Checklist
- Monthly Financial Close Checklist
- New Vendor Onboarding Checklist
- Annual Budget Preparation Checklist
- New Employee Onboarding Checklist
- Month-End Close Checklist
Ready to take control of your recurring tasks?
Start Free 14-Day TrialUse Slack? Sign up with one click
