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.

5 sections 17 steps Collects data
1

Aging Review and Triage

  1. 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.

  2. 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
  3. 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
  4. 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.

2

Dunning and Customer Outreach

  1. 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.

  2. 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.

  3. 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.

  4. 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
3

Dispute and Credit Hold

  1. 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.

  2. 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.

  3. 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.

4

Escalation and Write-Off Review

  1. 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
  2. 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.

  3. 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
5

Cash Application and Reporting

  1. 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.

  2. 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.

  3. 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.


Sections 5
Steps 17
Category Accounting
Price Free to start
Need a different process

Browse hundreds of free templates across every team and industry.

Back to template library

Run Collections Management Checklist with your team

Customize the steps, assign roles, set a schedule, and keep a complete record for every run.