Ageing Buckets and the Allowance for Doubtful Accounts: a Provision Matrix
This lesson is part of the subscription
The first lesson of every course is free. A subscription unlocks all lessons, labs, exams and certificates.
Or start the free course: Excel for Finance
Lessons in this course
- The Invoice Ledger: Open Items and Balances by Customer with SUMIFSFree
- DSO Two Ways: the Simple Ratio and the Count-Back Method Pro
- Collection Effectiveness Index (CEI): How Much of the Collectible AR Came In Pro
- Ageing Buckets and the Allowance for Doubtful Accounts: a Provision Matrix Pro
- Credit Limits and Utilisation: Over-Limit Flags and the Order-Release Test Pro
- Payment Behaviour: Average Days Late per Customer with AVERAGEIFS Pro
- The Dunning Schedule: Which Reminder Is Due Today? Pro
- Bad-Debt Write-Off, Recovery and the Allowance Roll-Forward (Journal and Chart) Pro