Cellgrids Cellgrids
Home › Excel case studies › Accounts Receivable Aging & Collections Priority

Accounts Receivable Aging & Collections Priority

A distributor has money stuck in unpaid invoices. Build the aging report, size the bad-debt provision, and decide which customers to chase first. **What you’ll learn:** Due dates, days overdue and aging buckets from messy invoice data Provisioning by bucket and calculating DSO Flagging customers over their credit limit

Open this Excel case study

Work on a realistic business scenario for data analytics and business analytics practice. See the full details and get the assignment on Cellgrids.

View case study → Free Excel formula practice

All Excel case studies · Excel interview prep · Excel formulas