Credit and Collections Checklist
Monthly A/R credit and collections workflow run by the controller and collections specialist. Covers aging review, risk reassessment, tiered collections outreach, FDCPA-compliant documentation, and escalation of seriously delinquent accounts.
Aging Review and Triage
-
Pull the A/R aging report from the GL
Run the aging detail report in QuickBooks Online, Sage Intacct, or NetSuite as of month-end. Tie the total to the GL receivables control account before working the buckets — an aging that doesn't tie indicates an unposted invoice batch or a misapplied payment.
-
Tie aging to the GL control account
Variance between the sub-ledger total and the GL balance must be zero or fully explained. Common causes: journal entries posted directly to the receivables account, deposits applied to the wrong customer, credit memos not yet applied.
Collects number -
Bucket receivables by 30/60/90/120+ days
Compute DSO and compare to trailing-three-month average. A jump of more than 5 days warrants a written explanation in the close commentary.
-
Flag accounts over $5,000 in 60+ bucket
These are the working list for the month. Pull the customer's payment history, prior collections notes, and credit limit utilization before drafting outreach.
Customer Risk Reassessment
-
Pull updated D&B or Experian commercial reports
Refresh credit bureau data on every customer in the 60+ bucket and on any account utilizing more than 80% of its credit limit. Watch for PAYDEX score drops and new UCC filings against the customer.
-
Recalculate credit limits using the scoring matrix
Apply the firm's scoring matrix: payment history (40%), bureau score (30%), trade references (20%), tenure (10%). Limits above $50K require controller sign-off; limits above $250K require CFO approval per the credit policy.
-
Document any credit hold decisions
Set the customer to credit hold in the GL and notify sales the same day. Record the reason and the conditions for release (full payment of 90+ balance, executed payment plan, etc.) in the customer notes.
Collects list Collects paragraph
Tiered Collections Outreach
-
Send statement reminders to 1-30 day accounts
Automated email reminder with statement attached and a payment link (Bill.com, Stripe, or QuickBooks Payments). No phone call required at this tier; the goal is friction-free self-service before escalation.
-
Make first-call outreach on 31-60 day accounts
Use the approved call script. Confirm receipt of invoice, identify any disputes, and obtain a verbal commit-to-pay date. Log the call in Karbon or the practice management system the same day — undocumented calls might as well not have happened.
-
Issue formal demand letter on 61-90 day accounts
Send via certified mail with return receipt and email PDF copy. Letter must reference the contract terms, late-fee accrual, and the cure period before further escalation. Avoid any FDCPA-style language if the receivable is consumer rather than commercial.
-
Document every contact in the customer record
Date, time, person contacted, summary of conversation, commit-to-pay date. The contact log is the audit trail when the account moves to legal or third-party collection.
-
Confirm whether 90+ accounts have responded
For each account in the 90+ bucket, mark whether the customer responded with a payment, payment plan proposal, or substantive dispute — or whether all outreach has gone unanswered.
Collects list
Escalation and Legal Review
-
Compile the escalation packet for counsel
Include signed credit application, executed contract or PO, all invoices, statements, demand letter with delivery proof, and the contact log. Counsel will not review an incomplete file; partial packets are the most common reason legal action stalls.
Collects file -
Review FDCPA and state-law applicability with counsel
FDCPA applies to consumer debt; commercial B2B receivables are governed by state collection statutes and the UCC. Confirm the venue's statute of limitations on the contract type and any pre-suit notice requirements.
-
Approve assignment to third-party collections
CFO sign-off required before placing the account with the agency. Confirm the agency's contingency rate, the cutoff for litigation referral, and that their licensing covers the customer's state.
Collects list
Bad-Debt Reserve and Write-Offs
-
Recalculate the allowance for doubtful accounts
Apply the firm's reserve methodology — typically a percentage-of-aging schedule (e.g., 1% of 0-30, 5% of 31-60, 25% of 61-90, 50% of 91-120, 100% of 120+) adjusted for specific identified risks. Document the methodology consistently with prior periods or disclose the change.
-
Post the bad-debt reserve adjusting entry
Debit bad debt expense, credit allowance for doubtful accounts. Memo references the aging snapshot and the reserve calculation workpaper. Never plug to retained earnings.
-
Process specific write-offs with controller approval
For each customer balance being written off, attach the documented basis: bankruptcy notice, agency uncollectible report, or written authorization. Controller signature on the write-off log is required before the entry posts.
Collects signature
Reporting and Policy Review
-
Publish the monthly collections KPI dashboard
DSO, CEI (collections effectiveness index), aging mix, bad-debt-to-revenue, and dispute-cycle time. Distribute to CFO, sales leadership, and the partner overseeing the engagement.
-
Review credit policy exceptions granted this period
List every credit limit override, terms exception, or hold release granted during the month. A pattern of exceptions for the same customer or salesperson signals the policy needs an update rather than another override.
-
Schedule the quarterly credit committee meeting
Standing agenda: top 10 exposures, watchlist movements, write-off summary, policy change proposals, regulatory updates (FDCPA amendments, state collection-license changes). Minutes filed in the SOX-equivalent control evidence folder.
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 Credit and Collections Checklist with your team
Customize the steps, assign roles, set a schedule, and keep a complete record for every run.