Sample 13-week forecast preview
The paid workbook places open invoices using each customer’s average days late, spreads recurring payments, and flags items outside the window. This page shows a summary of closing cash for the sample so you can see the shape of the output before buying.
| Week | Opening | Receipts | Payments | Closing | Gap to min. |
|---|---|---|---|---|---|
| 1 | 32,000 | 1,300 | 9,270 | 24,030 | 16,030 |
| 2 | 24,030 | 4,100 | 640 | 27,490 | 19,490 |
| 3 | 27,490 | 0 | 12,800 | 14,690 | 6,690 |
| 8 | 12,920 | 0 | 2,400 | 10,520 | 2,520 |
| 9 | 10,520 | 0 | 8,320 | 2,200 | -5,800 |
| 13 | 1,350 | 4,100 | 6,200 | -750 | -8,750 |
Test suite highlights for this sample: first week below minimum = week 9; lowest week = week 13; 1 overdue review item.
Download free sample CSV Buy full workbook – $12
Numbers above are the exact sample-model values checked in the v1.0.0 LibreOffice suite. The free CSV contains all 13 weeks. The paid .xlsx contains the live formulas that produce them.