A cash flow forecast answers a question every founder eventually asks in a panic: will I have enough money in the account to cover salaries, rent, and suppliers next month? Businesses that never ask this question in advance find out the hard way, often on a Friday afternoon when payroll is due and the account balance says otherwise. A cash flow forecast turns that panic into a planned, manageable process, and it takes less time to build than most founders expect.
This guide walks through building a working cash flow forecast from scratch, with a rolling structure you can maintain in an ordinary spreadsheet.
What a Cash Flow Forecast Actually Is
A cash flow forecast is a projection of the money you expect to receive and pay out over a future period, typically broken into weekly or monthly intervals. Unlike a budget, which plans your overall income and expenses, a forecast focuses specifically on timing, when cash actually lands and leaves your account, not when a sale is recorded or an invoice is issued.
This distinction matters enormously in Nigeria's business environment, where customers, especially corporate and government clients, routinely pay 30, 60, or even 90 days after an invoice is issued. A profitable sale on paper can leave you cash short for months if you haven't planned around the payment delay.
Step 1: Choose Your Forecast Period and Interval
For most small businesses, a rolling 13 week forecast, broken down week by week, offers the best balance of detail and manageability. Thirteen weeks gives you enough runway to see problems coming while staying granular enough to be genuinely useful for day to day decisions.
If your business has simpler, more predictable cash patterns, a monthly forecast covering the next six to twelve months can work instead, though it will catch short term cash crunches less precisely than a weekly view.
Step 2: Start With Your Actual Cash Position
Your forecast begins with a real number: how much cash you actually have on hand and in your business bank accounts today. This is your opening balance for week one. Every subsequent week's opening balance is simply the previous week's closing balance, carried forward.
Step 3: List Every Expected Cash Inflow, Week by Week
Go through every source of incoming cash and place each expected payment in the specific week you realistically expect to receive it, not the week you'd prefer to receive it.
Customer payments should be placed based on actual payment terms and, honestly, on that customer's actual payment history rather than the terms on paper. If a distributor in Kano has never once paid on the agreed 30 day term and typically pays at 45 days, forecast it at 45 days. Optimistic forecasting defeats the entire purpose of the exercise.
Loan or investment inflows go in the specific week funds are expected to clear, not the week the agreement was signed.
Other income, interest from a business savings account on Cowrywise or PiggyVest, asset sales, or refunds, gets its own line, however small.
Step 4: List Every Expected Cash Outflow, Week by Week
Do the same for money leaving the business.
Fixed costs like rent, loan repayments, and salaries are usually the easiest to forecast accurately since they occur on predictable dates.
Variable costs, inventory purchases, generator diesel, transport, packaging, need more judgment. Base them on recent actual spending patterns, and adjust for anything you know is changing, a bulk stock purchase planned for week six, for instance.
Tax and statutory payments deserve their own dedicated lines: FIRS remittances, LIRS Pay As You Earn deductions if you have staff, and pension contributions. These are easy to forget in a forecast and painful when they arrive unplanned.
Step 5: Calculate Your Weekly Net Cash Flow and Running Balance
For each week, subtract total outflows from total inflows to get that week's net cash flow. Add this to the previous week's closing balance to get the current week's closing balance, which becomes next week's opening balance.
This running balance is the single most important number in your entire forecast. Any week where the balance turns negative is a warning sign, a cash shortfall you now have weeks of advance notice to address, rather than discovering it the day salaries are due.
Step 6: Identify and Address Cash Gaps Early
When your forecast shows a negative balance approaching, you have real options, precisely because you saw it coming. You can follow up early on overdue customer invoices, negotiate extended payment terms with a supplier for that specific period, delay a planned but non urgent purchase, or arrange short term financing, a bank overdraft facility or a working capital loan, before the crunch hits rather than during it.
This is the entire value of forecasting: turning a crisis into a decision you get to make in advance, with options, rather than a decision forced on you by an empty account.
Step 7: Update It Weekly, Not Just Once
A forecast built once and never revisited quickly drifts away from reality. Every week, replace your projected numbers for the week just ended with actual figures, and extend the forecast one more week further out, keeping it a genuine rolling 13 week view at all times.
This weekly update also sharpens your forecasting accuracy over time. You'll notice patterns, which customers reliably pay late, which months carry higher generator costs, and your projections will get measurably better the longer you maintain the habit.
Common Mistakes to Avoid
Forecasting customer payments too optimistically. Use actual payment history, not agreed terms, especially for corporate or government clients known for slow payment.
Ignoring seasonal patterns. Retail and hospitality businesses often see cash flow swings around festive periods, school resumption, and salary payment cycles for corporate customers. Build these patterns into your forecast rather than treating each week as identical.
Leaving out irregular but predictable costs. Annual insurance renewals, equipment maintenance, and business permit renewals need to appear in the specific week they're due, not get forgotten until the bill lands.
Treating the forecast as a one time document. A cash flow forecast is a living tool, not a report you generate once for a bank loan application and then abandon.
The Bottom Line
A cash flow forecast is one of the highest value habits a Nigerian business owner can build, and it requires nothing more sophisticated than a spreadsheet and thirty minutes a week. It won't make your cash problems disappear, but it gives you the one thing that actually solves them: enough advance warning to act while you still have options. Start with your real numbers today, update it every week, and you'll never again be blindsided by a Friday payroll you can't cover.
