To forecast cash from unpaid invoices, take each invoice's due date, add that client's usual delay to get an expected date, drop each amount into the week it lands, and set the weekly totals against your household bills. The running balance shows the weeks that will be tight, before they arrive.
What do I need on the invoice list?
- Client and invoice amount.
- Due date.
- Usual delay in days for that client, taken from your own payment history.
- Expected date, calculated as due date plus delay.
With the due date in C2 and the delay in D2, the expected date in E2 is =C2+D2. If you have no history for a new client, start with a delay of zero and be ready to revise it.
Be honest about delays. If a client has paid on time once and late three times, use the late figure. A forecast that is too cheerful is worse than none, because it tells you that you can pay a bill you cannot.
Once a week, replace expected dates with actual ones as money arrives, and push the rest later if they have not. A forecast that is updated every week stays useful. One that is built once and forgotten is a fiction by the third week.
What does the forecast look like in numbers?
Hypothetical invoices and delays:
| Client | Amount (₹) | Due | Usual delay | Expected |
|---|---|---|---|---|
| Client A | 40,000 | 6 Nov | 3 days | 9 Nov |
| Client B | 25,000 | 12 Nov | 14 days | 26 Nov |
| Client C | 60,000 | 15 Nov | 20 days | 5 Dec |
| Client D | 18,000 | 20 Nov | 0 days | 20 Nov |
Now drop them into weeks, running Monday to Sunday: week 1 is 3 to 9 November, week 2 is 10 to 16, week 3 is 17 to 23, week 4 is 24 to 30 and week 5 is 1 to 7 December. Weekly bills in this household vary, because rent and EMI fall in different weeks. Opening balance is ₹5,000.
| Week | Opening (₹) | Receipts (₹) | Bills (₹) | Closing (₹) |
|---|---|---|---|---|
| Week 1 | 5,000 | 40,000 | 30,000 | 15,000 |
| Week 2 | 15,000 | 0 | 12,000 | 3,000 |
| Week 3 | 3,000 | 18,000 | 14,000 | 7,000 |
| Week 4 | 7,000 | 25,000 | 22,000 | 10,000 |
| Week 5 | 10,000 | 60,000 | 20,000 | 50,000 |
Check week 3: 3,000 plus 18,000 minus 14,000 is 7,000. Week 5: 10,000 plus 60,000 minus 20,000 is 50,000. The tightest point is the end of week 2, with only ₹3,000 left.
How do I sum receipts by week in a sheet?
Put the week's start date in H2 and use this, filling down. It works in Excel and Google Sheets:
=SUMIFS($B$2:$B$50,$E$2:$E$50,">="&H2,$E$2:$E$50,"<="&H2+6)
Here column B holds amounts and column E the expected dates. Add your bills by week in the next column and a running balance in the last.
What if one payment comes later than expected?
Stress-test the plan. If Client A's ₹40,000 slips from week 1 into week 2, week 1 closes at 5,000 plus 0 minus 30,000, which is minus ₹25,000. You would be short in week 1 and only recover in week 2, when the balance becomes minus 25,000 plus 40,000 minus 12,000, which is ₹3,000. That tells you that week 1 needs a cushion, or a bill moved, or a conversation with Client A before the due date.
How far ahead should I forecast?
Five or six weeks is enough. Beyond that, the assumptions outweigh the data. Update the forecast when a payment arrives or a promised date changes. If you import statements into SpendixAI you can compare the actual credit dates against your expected ones and refine the delay numbers over time.
A weekly forecast routine
- Update received payments and remove them from the open list.
- Recalculate expected dates for anything that moved.
- Check the lowest closing balance across the next five weeks.
- If it goes below zero, move a bill, chase an invoice or draw on the buffer on purpose.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


