Execute accounts receivable aging

I need the accounts receivable aging run for all customers with invoices older than 60 days and at-risk credit status. Generate the aging report, attach the supporting invoice and payment history for each line over 60 days, and export a PDF by customer folder so I can send collections notices Friday morning. Check that unapplied cash is shown and flag any negative balances first.

Before I send this aging to collections, make the report easy to act on — put total past‑due and dispute amounts at the top for each customer, show the date and user for the last activity, and highlight invoices where unapplied cash or credit memos exist. Flag anything that would make a collector hesitate: recent credit holds, active disputes, or legal cases.

Customer DuraTech just hit 61 days past due on three invoices worth 84,500. The collector says there’s a disputed charge but the notes are thin and finance can’t find a remittance. I’m afraid we’ll escalate to legal if I misclassify and lose leverage. What’s the most likely diagnosis and the next concrete step to resolve the hold quickly?

Every month I spend a day reconciling unapplied cash and correcting dispute flags before the aging is reliable. That costs credibility with collections and delays cash forecasting. Which habit should I change so the monthly aging is clean without last‑minute firefighting?