Skip to content
← All tools

13-week cash flow forecast

Most businesses that fail are profitable on paper but run out of cash. Put in what you have today and what is coming in and going out, and see every week's closing balance for the next three months.

ItemIn / outAmount (₦)How oftenWeekRemove

Week: for "once" the week it lands (1–13); for "monthly" the week of each month (1–4); for "every week" the week it starts.

Cash runs out in week 2. You need about ₦3,440,000 more by week 12: chase invoices, take deposits, or move a payment.

W1Week 1: ₦1,580,000W2Week 2: -₦140,000W3Week 3: -₦60,000W4Week 4: -₦2,180,000W5Week 5: -₦2,100,000W6Week 6: ₦480,000W7Week 7: ₦560,000W8Week 8: -₦1,560,000W9Week 9: -₦1,480,000W10Week 10: -₦1,400,000W11Week 11: -₦1,320,000W12Week 12: -₦3,440,000W13Week 13: -₦3,360,000
WeekCash inCash outClosing
Week 1900k820k₦1,580,000
Week 2900k2.6m-₦140,000
Week 3900k820k-₦60,000
Week 4900k3.0m-₦2,180,000
Week 5900k820k-₦2,100,000
Week 63.4m820k₦480,000
Week 7900k820k₦560,000
Week 8900k3.0m-₦1,560,000
Week 9900k820k-₦1,480,000
Week 10900k820k-₦1,400,000
Week 11900k820k-₦1,320,000
Week 12900k3.0m-₦3,440,000
Week 13900k820k-₦3,360,000

Saved on this device only. Update it every Monday with your real bank balance.

Keep these free tools handy

We'll email you the links, plus a few short tips on getting paid faster and the e-invoicing changes coming for small businesses. Unsubscribe any time.

Why 13 weeks

Thirteen weeks is one quarter: far enough ahead to fix a gap by chasing invoices, taking deposits or moving a supplier payment, and near enough that the numbers are real. Banks, turnaround advisers and CFOs use the same format.

How to fill it in

Start with the cash in your bank accounts today, not your profit. Add money in as you expect to actually receive it, not when you invoice. Put salaries and rent in the week they leave your account. Update it every Monday with the real balance.

What to do when you see a gap

Ask big customers for part-payment, offer a small discount for paying now, take deposits on new orders, agree a later date with a supplier before the due date, or delay non-essential spending. Acting four weeks early is far cheaper than an emergency loan.

Frequently asked questions

What is the difference between profit and cash flow?
Profit is sales minus costs over a period. Cash flow is when money actually enters and leaves your account. A business can be profitable while customers owe it money, and still miss payroll.
How do monthly items work?
Pick the week of each month the payment lands (1–4). The forecast repeats it in each of the three months.
Is my data private?
Yes. The forecast is saved only in your browser on this device and is never sent to our servers.

Want this live from your sales and bank data?

We build owner dashboards that pull sales, expenses and bank balances into a live cash forecast for your business.

Ask about a dashboard