Description
Forecast cash you will collect each week from open invoices – due dates, each customer's usual payment delay and collection probability – for a realistic cash plan.
- Automatic summary: Open receivables, Expected to collect (weighted), Expected in next 4 weeks, Doubtful amount
- Calculated for you: Expected pay date, Week no., Probability, Expected amount
- Drop-down menus for quick, consistent entry
- Colour-coded status and progress highlights
- Built-in chart that updates as you type
- 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.