How to Create a 13-Week Cash Flow Forecast for a Small Business in Nigeria

To create a 13-week cash flow forecast for a small business in Nigeria, start with the money genuinely available today, estimate the cash you expect to receive and pay during each of the next 13 weeks, and carry each week's closing balance forward as the following week's opening balance. Update the plan every week. Its value is not predicting the future perfectly: it is identifying a cash shortage early enough to collect overdue invoices, review stock purchases or arrange funding before an important bill falls due.

Consider a profitable retailer in Enugu that receives customer transfers daily but must pay a supplier before restocking. Or a Lagos catering company that buys ingredients today but receives a corporate customer's final payment next month. Both businesses can report healthy sales while having too little available cash for wages or rent. The British Business Bank's forecasting guidance emphasises actual expected cash receipt and payment dates, not simply the dates sales or expenses are recorded.

This guide explains a practical 13-week spreadsheet, provides a fully reconciled naira-denominated example, and shows how to test a late-payment scenario. All monetary figures are fictional and do not represent a real Nigerian business. Research verified 2 November 2026.

What is a 13-week cash flow forecast?

It is a rolling direct-method liquidity forecast covering approximately one quarter, with one column for each week. Instead of calculating accounting profit, it records anticipated money in and money out. The underlying approach is consistent with the distinction between cash movements and accrual-based results described by the IFRS Foundation's IAS 7 cash-flow guidance . This management forecast is not itself a formal IAS 7 financial statement.

A month-end budget might show a surplus even though the business cannot cover payroll in the second week. The weekly view exposes that timing gap. A 13-week forecasting guide for business operators recommends using opening cash, receipts, disbursements, closing cash and regular variance checks to maintain a useful projection. Keep a longer annual budget too, particularly for capital investment and seasonal plans.

Step 1: Reconcile your real opening cash

Use the funds genuinely available to pay current business obligations: reconciled business bank balances, usable cash on hand and cleared balances in relevant payment accounts. Deduct uncleared outgoing payments and exclude restricted funds that cannot be spent on operations. Record any available borrowing facility separately rather than pretending a loan not yet drawn is cash already held.

For example, if a business has ₦900,000 in its operating bank account, ₦200,000 in accessible POS settlements and ₦100,000 cash in hand, its starting available cash is ₦1,200,000, provided all three amounts are cleared, unencumbered and not duplicated elsewhere.

Moving ₦50,000 from your business bank to the cash drawer is a transfer, not a new sale or operating expense. Counting both legs as fresh revenue and spending distorts the forecast. KudiScope's money-tracking documentation similarly distinguishes own-account transfers from actual income and spending. Keep personal and business cash separate wherever practical.

Step 2: Divide the next quarter into 13 weeks

Start with your next weekly review date. Use consistently dated periods, such as Monday through Sunday, and put the week-end date at the top of each column. For a sample forecast starting Monday, 2 November 2026, week one is 2–8 November and week thirteen is 25–31 January 2027. Your own forecast should begin on its actual preparation date.

Keep one column per week for opening cash, expected receipts, payments, net movement, closing cash and a minimum safety buffer. Put detailed transactions on a separate input sheet so the summary can remain readable. If an important payment and receipt fall on different days within the same week, maintain a more detailed daily view for the affected period; a positive weekly closing balance can still hide a midweek cash shortage.

Step 3: Forecast receipts when the money will arrive

Start with money the business has evidence it can collect. Separate immediate cash sales, cleared bank transfers, card or POS settlements, outstanding customer invoices, subscription receipts and other credible inflows. Loans, owner capital and asset sales may be included as financing or other inflows, but label them separately from sales so performance is not overstated.

For credit customers, use historical payment behaviour rather than optimistic invoice due dates. An invoice for ₦300,000 raised in November may not become available cash until December. An unconfirmed sales lead should not be treated like a settled invoice. Classify receipts as confirmed, likely or uncertain, and use conservative scenarios for uncertain collections.

Nigerian businesses using bank transfers or payment gateways should account for actual settlement delays and fees. A sales receipt recorded at checkout is not necessarily cleared cash in the operating account on the same day. For broader payment-collection context, FlyingEze previously reported on FCMB Collect and digital business collections in Nigeria ; use each provider's actual settlement terms when forecasting rather than assuming identical arrangements.

Step 4: Forecast payments by their real due dates

List supplier invoices, new stock deposits, raw materials, salaries, rent, electricity, generator fuel, transport, internet, payment processing fees, equipment repairs, loan instalments, taxes, regulatory payments and owner drawings. Include recurring subscriptions and infrequent expenses that can catch the business unprepared.

Use the actual statutory obligations and due dates applicable to your entity; not every Nigerian small business has the same VAT, PAYE, pension, company-tax or state-level responsibilities. Ask your accountant to verify current obligations rather than copying a generic tax rate or payment calendar. A cash forecast predicts payment timing—it does not establish the correct tax treatment.

Keep loan principal and interest payments visible, and distinguish a new loan drawdown from trading revenue. Include owner withdrawals because cash leaving the business for household spending still reduces its ability to pay staff and suppliers. The Australian Government's cash-flow guidance recommends tracking money entering and leaving the business, while the British Business Bank emphasises forecasting working-capital shortfalls before they become urgent.

Step 5: Build the 13-week spreadsheet formulas

In Excel or Google Sheets, place weeks one to thirteen across columns B through N. Use this simple row layout:

For week two, enter =B17 in cell C2 so the previous closing balance flows forward; copy the pattern across. Use conditional formatting to highlight a negative closing balance in red, and a closing balance below the chosen safety buffer in amber. Don't enter negative payment figures if your total payment formula already subtracts them, or you may reverse the intended arithmetic.

Step 6: Work through a 13-week example in naira

Suppose a fictional retail and distribution business starts with ₦1.2 million available. The table below is expressed in ₦'000: an entry of 540 means ₦540,000, not ₦540. All figures reconcile, and each week's closing amount becomes the next week's opening amount.

Across the 13 weeks, projected receipts are ₦8.60 million and payments are ₦8.89 million. Net cash movement is therefore −₦290,000, leaving a final closing balance of ₦910,000 from the ₦1.2 million start.

But the ending figure conceals a significant risk: week five closes at just ₦380,000, while week eight closes at ₦450,000. If management has set an illustrative minimum safety balance of ₦500,000, the worst gap below that buffer is ₦120,000 in week five. The business has not necessarily run out of money, but it has less protection against delayed payments or an emergency expense than its owners intended.

Step 7: Stress-test late payments and rising costs

A base-case forecast is only one possible outcome. Create a realistic downside scenario for important uncertainties. For example, if ₦300,000 expected in week four is instead collected in week six, week five's forecast closing balance falls from ₦380,000 to just ₦80,000, assuming everything else stays unchanged. After the delayed payment arrives in week six, the cumulative difference from this single timing change disappears. That is exactly why timing matters.

Test further cases: 15% lower cash sales, a supplier requesting an advance payment, increased diesel expense, late POS settlements, an equipment breakdown or a customer default. Record which assumptions change, when the risk starts and the resulting lowest cash balance. Don't automatically add every hypothetical shock together without explaining that it is a severe combined scenario.

A practical minimum-cash buffer might be based on your next payroll, essential supplier requirements and fixed operating costs. There is no universal Nigerian SME buffer amount: calculate the amount that makes sense for your obligations and risk tolerance.

Step 8: Make an action plan before the shortfall arrives

For week five in the fictional example, management could contact customers whose invoices are due, offer clearer payment instructions, tighten collections, negotiate a realistic supplier payment schedule or postpone non-essential stock and equipment purchases. It should not arbitrarily delay contractual wages or taxes without understanding the legal and operational consequences.

Where borrowing is necessary, compare the financing cost, repayment dates and actual ability to service the debt. Add the loan inflow in the week funds are confirmed available and every loan repayment in its due week. A loan may solve a timing problem but can make future weeks worse if its costs exceed the business's capacity.

Set an accountable owner and a deadline for each action: “Accounts manager to confirm collection of ₦300,000 before week four” is more useful than “Improve cash flow.” The British Business Bank's reforecasting guidance similarly recommends revising assumptions and plans as circumstances change.

Step 9: Refresh the forecast every week

At the close of each week, replace estimates with reconciled actual receipts and payments. Explain important differences: a customer paid late, supplier prices changed, a purchase was delayed or fewer units were sold. Move incomplete transactions to their new expected weeks rather than leaving them behind in an old column.

Then remove the completed week and append a fresh week thirteen, maintaining a rolling quarter. Review which week has the lowest projected closing cash, the largest receipts at risk and the highest unavoidable cash commitments. Business owners, finance staff and operational managers should agree on the numbers rather than producing a spreadsheet that nobody uses.

For operators tracking numerous shops, departments or workspaces, aggregate cash across genuinely available business accounts but preserve branch-level receipts, inventory requirements and upcoming payments underneath. Internal transfers between your own accounts must not inflate total receipts or expenses.

Which tools can help a Nigerian small business maintain this forecast?

A basic spreadsheet is enough to start. Once transactions multiply, look for tools that help maintain reliable inputs—not a dashboard that promises to predict cash without underlying records.

For tracking bank, wallet and cash movements, budgets and upcoming commitments, KudiScope offers money-recording and planning features, including business workspaces where available. Its tracked records can inform a forecast, but businesses should still independently construct and verify the 13-week receipt-and-payment schedule; KudiScope does not hold their money or replace their bank.

For a hospitality or retail operation with integrated sales and procurement needs, P-Biz Solutions lists POS, inventory, purchasing and financial-management capabilities. These kinds of operational records can feed cash planning, but owners should confirm feature availability, implementation and export suitability before relying on any platform. Neither tool substitutes for a qualified accountant when tax, borrowing or financial reporting decisions are material.

Common mistakes to avoid

Using sales instead of receipts: an unpaid ₦500,000 invoice is not ₦500,000 available to spend. Assuming every transfer settles immediately: check banking and payment-provider arrangements. Ignoring unusual costs: annual rent, generator repair, insurance and tax payments may create the lowest week.

Omitting owner drawings: cash taken out of the business affects its liquidity. Counting internal transfers twice: moving cash between your accounts changes location, not total available funds. Mixing finance with sales: a bank loan is a funding inflow, not customer revenue. Never updating the model: estimates become stale as soon as customers pay later or suppliers change terms.

Frequently asked questions

Why use 13 weeks instead of a monthly forecast?

Thirteen weekly periods cover approximately one quarter while revealing short-term cash gaps hidden by month-end totals. Keep a monthly or annual forecast alongside it for longer-range planning.

Do I need accounting software to start?

No. A spreadsheet built from actual bank balances, invoices and known commitments is sufficient initially. Good records and weekly review matter more than the software used.

Should I include VAT, PAYE and other taxes?

Include all tax and statutory cash payments actually applicable to the business, in their expected payment weeks. Verify current obligations and due dates with appropriate official guidance or a qualified adviser.

Can a profitable business have negative cash flow?

Yes. A customer may owe you for a profitable sale while suppliers, staff or rent must be paid immediately. Profit and liquidity describe different things.

What if a week falls below my minimum cash buffer?

Treat it as an early warning. Check the payment dates, identify collectible receivables and discretionary expenses, then assess realistic financing or renegotiation options before the week arrives.

How often should I update the forecast?

At least weekly for an active 13-week forecast; update more often when balances are tight, major receipts are uncertain or important payments are approaching.

Conclusion

A good 13-week cash flow forecast tells a Nigerian business not just whether it expects to make money, but when it will actually have enough money to meet its commitments. Start with reconciled cash, assign realistic collection and payment weeks, calculate a rolling balance, set a reasonable buffer and update actuals regularly. If a shortfall emerges, use the lead time to improve collections, control discretionary spending or arrange suitable funding instead of reacting after the cash has run out.