Description
Compare each customer's agreed credit terms with how fast they actually pay, calculate days sales outstanding (DSO) and see the cash tied up by slow payers.
- Automatic summary: Total receivables now, Total credit sales in period, Overall DSO (days), Cash tied up by late paying
- Calculated for you: Actual DSO (days), Days over terms, Extra cash tied up, Status
- Colour-coded status and progress highlights
- Example rows and a step-by-step "How to Use" sheet
Instant download (.xlsx). Works in Excel 2010+, Excel online, Google Sheets, Numbers and LibreOffice. Works with any currency.
Payment & Security
Your payment information is processed securely. We do not store credit card details nor have access to your credit card information.