Collections Management Checklist
Weekly A/R collections cycle for a controller or collections lead — aging review, dunning sequence, escalation decisions, and payment posting. Designed for SMB finance teams running collections out of QuickBooks Online, Xero, or NetSuite.
Aging Review and Triage
-
Reconcile A/R sub-ledger to the GL
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.
-
Pull the 30/60/90/120+ aging report
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.
Collects file -
Identify the highest-risk balance
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.
Collects list -
Confirm unapplied cash and credit memos
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
-
Send the 30-day reminder email
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.
-
Call the A/P contact on 60-day balances
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.
-
Issue the formal demand letter at 90 days
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.
-
Log every touch in the CRM
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.
Collects list
Dispute and Credit Hold
-
Open a dispute case with the account owner
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.
-
Place the customer on credit hold
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.
-
Issue a corrected invoice or credit memo
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
-
Decide on escalation for 120+ accounts
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.
Collects list -
Place the account with the collections agency
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.
-
Post the bad-debt write-off entry
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.
Collects number Collects signature
Cash Application and Reporting
-
Apply the week's lockbox and ACH receipts
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.
-
Update the DSO and collections KPIs
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.
-
Send the weekly A/R 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.
Collects file
Use this template
Copy it to your account, customize the steps, and run it with your team in minutes.
Browse hundreds of free templates across every team and industry.
Back to template libraryRelated templates
More workflows your team can run.
Run Collections Management Checklist with your team
Customize the steps, assign roles, set a schedule, and keep a complete record for every run.