Master Cash Flow Forecasting


This guide will show you how to master cash flow forecasting. You do not need expensive software or a finance degree. You just need to be ready to understand your business better.
Step 1: Gather All Your Financial Data
You cannot forecast without information. Your first step is to collect all the data about money coming in and going out of your business. Many businesses use multiple payment systems, so be thorough.
What to Collect:
Bank Statements: Get the latest statements from all your business bank accounts.
Mobile Money Records: This is crucial. Download your statements from M-Pesa, MTN Mobile Money, Airtel Money, or whatever service you use. This is often where a lot of daily transactions happen.
Cash Records: Do you have a physical cash box or a notebook where you track cash sales and expenses? This information is vital. If you don't track it, start now.
Sales Invoices: A list of all the invoices you have sent to customers. Note which ones are paid and which are not.
Expense Receipts and Bills: Collect all your receipts for things you buy and bills you need to pay. This includes rent, electricity, supplier costs, and transport.
Pro-Tip :
Many small businesses operate with a "box-file" system for receipts and a simple notebook for cash. That is a fine start. The goal here is to get organized. Take one afternoon and put all this information into a simple format. A spreadsheet is best, but even a bigger, more organized notebook works. The key is to see everything in one place.
Example:
Aminata runs a fashion boutique in Lagos, Nigeria. She needs to gather:
Her GTBank account statements.
Her OPay and Paga transaction histories for customer payments.
The physical notebook where she records cash sales.
A file of receipts from her fabric suppliers and the bill for her shop's rent.
Step 2: Categorize Your Cash Inflows and Outflows
Now that you have your data, you need to organize it. This helps you see where your money comes from and where it goes. Create two main lists: Cash Inflows (money in) and Cash Outflows (money out).
Cash Inflows (Money In):
This is all the cash coming into your business.
Cash Sales: Money from customers who pay immediately in cash or by mobile money.
Credit Sales (Receivables): Money from customers who will pay you later. It is important to know when you expect them to pay.
Loans: Money you receive from a bank, microfinance institution, or investor.
Owner's Capital: Money you personally put into the business.
Cash Outflows (Money Out):
This is all the cash leaving your business. It is helpful to split these into two types.
Fixed Costs: These are expenses that stay the same every month. They are predictable.
Rent
Salaries
Loan repayments
Variable Costs: These are expenses that change based on your business activity.
Cost of Goods Sold (COGS): Buying new stock or raw materials.
Marketing & Advertising: Your spending on social media ads or flyers.
Utilities: Electricity and water bills, which can vary.
Transport & Delivery: Fuel costs or fees for delivery services.
Generator Fuel/Maintenance: A common and important cost in many countries due to power issues.
Bank and Mobile Money Fees: The small charges on your transactions add up.
Example:
Aminata from the Lagos boutique categorizes her money movements.
Inflows: Daily cash and OPay sales, payment from a corporate client who buys in bulk (receivable), and a small loan she took from a cooperative.
Outflows (Fixed): Shop rent, salary for her one assistant.
Outflows (Variable): Buying new ankara fabric, paying for Instagram ads, fuelling the generator, transport to the market.
Step 3: Choose Your Forecasting Period and Tool
You need to decide how far into the future you want to look. For most small and medium-sized businesses, a short-term forecast is the most useful.
Forecasting Period: A 13-week (or 3-month) rolling forecast is the gold standard. It is long enough to see upcoming challenges but short enough to be accurate. You can also start with a simple 4-week (monthly) forecast. Do what feels manageable.
Forecasting Tool: You do not need anything fancy.
Good: Notebook. You can draw a simple table. It is better than nothing.
Better: Spreadsheet. Use Google Sheets (free) or Microsoft Excel. This is the best tool for most businesses. It does the math for you and is easy to update.
Advanced: Accounting Software. Tools like Zoho Books or Wave have forecasting features, but master the spreadsheet first.
Let's focus on the spreadsheet. Create a simple table.
Columns: Label them "Week 1," "Week 2," "Week 3," "Week 4."
Rows: Create rows for your categories from Step 2. It should look something like this:
Category | Week 1 | Week 2 | Week 3 | Week 4 |
Opening Cash Balance | ||||
Cash Inflows | ||||
Cash Sales | ||||
Receivables Paid | ||||
Total Inflows | ||||
Cash Outflows | ||||
Rent | ||||
Salaries | ||||
Stock Purchase | ||||
Generator Fuel | ||||
Total Outflows | ||||
Closing Cash Balance |
Step 4: Build Your First Forecast
This is where you fill in the numbers. We will use the direct method, which is simple and powerful. The main formula is:
Opening Balance + Total Inflows - Total Outflows = Closing Balance
Let's walk through it.
Find Your Opening Balance: This is the total cash you have right now. Add up the money in your bank account, your mobile money wallet, and your cash box. Put this number in the "Opening Cash Balance" cell for Week 1.
Estimate Your Cash Inflows: Look at your past sales data. Be realistic, not just optimistic.
If you make around ₦200,000 in sales per week, use that number. Do not predict a sudden jump unless you have a big marketing campaign planned.
Look at your unpaid invoices. When do you realistically expect customers to pay? Put that expected income in the correct week.
Estimate Your Cash Outflows: This is often easier to predict.
List all your fixed costs. Rent is due in Week 1. Salaries are due in Week 4. Put these costs in the correct columns.
Plan for your variable costs. Do you need to buy stock in Week 2? How much will it cost? When is the electricity bill due?
Do the Math:
For each week, add up all your inflows to get "Total Inflows."
Add up all your outflows to get "Total Outflows."
Calculate your "Closing Cash Balance" for Week 1.
Crucially, the Closing Balance for Week 1 becomes the Opening Balance for Week 2. Repeat the process for all four weeks.
Example: A 4-Week Forecast for Aminata's Boutique (in ₦)
Category | Week 1 | Week 2 | Week 3 | Week 4 |
Opening Cash Balance | 150,000 | 270,000 | 390,000 | 500,000 |
Cash Inflows | ||||
Cash Sales | 200,000 | 200,000 | 200,000 | 250,000 |
Receivables Paid | 0 | 50,000 | 0 | 0 |
Total Inflows | 200,000 | 250,000 | 200,000 | 250,000 |
Cash Outflows | ||||
Rent | 30,000 | 0 | 0 | 0 |
Salaries | 0 | 0 | 0 | 80,000 |
Stock Purchase | 50,000 | 30,000 | 90,000 | 0 |
Generator Fuel | 0 | 0 | 0 | 10,000 |
Total Outflows | 80,000 | 30,000 | 90,000 | 90,000 |
Closing Cash Balance | 270,000 | 390,000 | 500,000 | 660,000 |
This forecast shows Aminata that her cash position is strong and growing.
Step 5: Stress-Test Your Forecast for African Realities
A forecast is just a plan. Now, you must prepare for reality. Things can change quickly. This step separates good business owners from great ones. Ask yourself "What if?" and create different scenarios.
Scenario 1: The Currency Fluctuation Scenario
The Problem: Aminata buys some fabric from a supplier who prices in US dollars. If the Naira weakens against the dollar, her costs go up suddenly.
The Action: Create a "Pessimistic" version of your forecast. What if her stock purchase costs 20% more? Recalculate your outflows. Does this cause a problem? If so, she might need to find a local supplier or increase her prices slightly.
Scenario 2: The Late Payment Scenario
The Problem: The corporate client who owed Aminata ₦50,000 in Week 2 says they will pay two weeks late.
The Action: Move that ₦50,000 inflow from Week 2 to Week 4 in your forecast. See what that does to your cash balance in Week 2 and 3. Can you still cover your costs? If not, you know you need to chase that payment more aggressively or delay a non-essential purchase.
Scenario 3: The Supply Chain Disruption Scenario
The Problem: A protest blocks the main road to the market. Aminata cannot get new stock for a week. This means her sales might drop.
The Action: Create a forecast where sales in one week are 50% lower than expected. How does this impact your cash? This helps you understand how much of a cash buffer you need to survive slow periods.
By creating best-case, worst-case, and most-likely scenarios, you are no longer just hoping for the best. You are actively preparing for different outcomes. This gives you the power to act, not just react.
Take Control of Your Cash
Your first forecast will not be perfect, and that is okay. The habit of planning and reviewing your cash flow every week or month is what will transform your business. You will sleep better at night knowing you have a map for your money, helping you navigate the exciting but challenging journey of building a successful business. Start today.
Subscribe to my newsletter
Read articles from edda dena directly inside your inbox. Subscribe to the newsletter, and don't miss out.
Written by
