Cash Flow Forecasting: Looking Three Months Ahead

Cash Flow Forecasting: Looking Three Months Ahead

A bakery is busy. Orders are full, and customers keep coming back. Then in one week, the owner cannot pay the flour supplier and has to delay wages.

The bakery was profitable. So how did it run out of cash? The answer was that nobody had looked ahead.

What a Cash Flow Forecast Is

A cash flow forecast is a simple estimate of the money coming in and going out over the next few weeks or months. It shows whether you will have enough cash on each date.

It differs from profit. Profit measures performance over a period. Cash flow tracks the timing of actual money, and timing is where problems hide.

A business can be profitable and still run short of cash, for example when customers pay late or stock is bought in bulk.

Many owners judge their business by the bank balance alone. But a healthy balance today says nothing about next month. A forecast adds the time dimension that the balance lacks.

Think of it as a weather forecast for your cash. You cannot control the weather, but you can take an umbrella.

Building a Three-Month View

Start with today’s cash balance. Add the money you expect to receive each week, based on invoices due and typical sales.

Then subtract what you expect to pay: suppliers, wages, rent, loan repayments and taxes. Put each item in the week it is due, not the week it is earned.

The result is your expected balance for each week. A three-month view is about thirteen weeks, so a simple table with thirteen columns, one for each week, is enough.

Use your records to be realistic. Last year’s sales by month, your supplier terms and your customers’ usual payment habits are all good guides. If customers normally pay in thirty days, forecast thirty days.

Keep it simple. Rows for the main receipts and payments are enough, with a closing balance for each week.

Watch the Big Dates

Some payments are larger and less frequent than others. Annual licences, insurance, equipment repairs and seasonal stock all deserve their own line.

A forecast may show one tight week when several payments overlap, such as an annual licence and a large flour order. Knowing it in advance gives time to talk to the supplier.

Also be careful with receipts. Count money when you realistically expect to receive it, not when you hope the customer will pay.

Do not forget payments that happen irregularly, such as tax payments, loan instalments and bonuses. They are easy to overlook until the week they fall due. Put them on the forecast as soon as you know them.

Seasonal businesses should look back at least a year. Which months bring the largest costs, and which bring the best sales?

Planning for the Unexpected

Forecasts are estimates, so build in some room. Try a cautious version, where sales are lower or customers pay later, and see what happens to your balance.

If the cautious version shows a shortfall, plan now. Options include agreeing payment terms, chasing overdue invoices or delaying a purchase.

A forecast does not remove risk. It gives you time to respond.

Also check what would happen if your largest customer paid two weeks late. If the forecast shows a gap, agree a small credit limit with your supplier in advance.

Keep some cash set aside for surprises, even if it is small. A reserve gives you room when something goes wrong.

Keeping It Up to Date

Update the forecast weekly. Replace estimates with actual figures and extend it by one more week.

This takes about twenty minutes. Over time, you learn how accurate your estimates are and improve them.

The owner then checks the forecast every Monday. Do you know what your bank balance will look like in three months?

Compare each week’s actual cash with the forecast. Large differences tell you where your estimates need work, and which customers or suppliers behave differently from what you assumed.

Share the forecast with the people who make buying decisions. It is much easier to delay a purchase when everyone can see the cash picture.

See Cash Problems Before They Arrive

JS Morlu Gambia can help you build a simple cash flow forecast from your own records and keep it up to date. Our accounting team prepares clear financial reports that show where your cash is going and when pressure points may appear. Seeing a tight week early can give you time to plan, instead of reacting at the last minute.

To learn more about FinovatePro, visit www.finovatepro.com or contact the FinovatePro team at hello@finovatepro.com.

JS Morlu Gambia is a professional accounting firm and property valuation specialist based at Salameh Complex, Sukuta Highway, Brusubi, Kombo North, West Coast Region, The Gambia. We serve businesses, NGOs, and institutions across Banjul, Serekunda, Brikama, and throughout the country with structured financial reporting, compliance support, independent property valuation, and coordinated audit assistance designed to strengthen financial transparency and support sustainable growth.