Direct Cash Flow Forecasting: Build It From What Will Actually Hit Your Bank

You have $80,000 in the bank today. That sounds comfortable.

But payroll is due this Friday. A few suppliers need paying next week. Rent is coming up. There are credit card bills, software subscriptions, fuel, office expenses and taxes during the month.

At the same time, customers owe you money. Some will pay this week. Some are due next week. And there will probably be a few who do not pay when the invoice says they should.

So the question is not really “we have $80,000 today. Are we okay?” A more useful question is “what will happen to this $80,000 over the next few weeks?”

This is where direct cash flow forecasting becomes useful. Instead of starting with profit and making accounting adjustments, you start with the cash you actually have, and work through the money you expect to receive and the money you expect to pay.

The calculation itself is simple:

If you want to build this as you read, start with our free 13-Week Cash Flow Forecast Template. Put in your opening bank balance, expected collections, payments and recurring expenses, and start building a week-by-week view of where your cash is heading.

Now let’s look at what actually goes into it.

First, gather what you need

You don’t need a complicated system to build your first direct cash flow forecast. Most of the information is probably already sitting in your accounting software, bank account, payroll system, CRM — or with someone in your sales and operations teams.

Start with:

If you use QuickBooks or another accounting system, don’t assume everything you need will be there. An approved purchase may not have become an invoice yet. A customer order may not have been billed. Sales may know that a customer is going to pay late. Management may have approved an expense that hasn’t reached accounting.

If you are not sure what to collect, our Cash Flow Forecast Data Checklist walks through the accounting and operational information to bring together before you build.

You don’t need every input to be perfect before starting. Start with what you know, and improve it every week.

Step 1: Start with what is actually in the bank

For our example: opening cash $80,000. That is our starting point.

If the business has several bank accounts, bring together the cash genuinely available for operations. If some cash is restricted, don’t include it just because it makes the forecast look better.

And don’t add accounts receivable yet. If customers owe you $65,000, that does not mean you have $145,000 available. You have $80,000. The $65,000 becomes cash when customers actually pay.

That difference sounds obvious. It is also one of the main reasons a profitable business can still find itself short of cash.

Step 2: Work out what money is actually coming in

Let’s say your AR aging shows $65,000 outstanding. At first glance you may be tempted to drop the full $65,000 into the forecast based on invoice due dates. But when will that money actually reach the bank?

Let’s look at it customer by customer.

Customer	Amount outstanding	Due	When we actually expect cash
Customer A	$20,000	Week 1	Week 1
Customer B	$15,000	Week 1	Week 2
Customer C	$30,000	Week 2	Week 3
Total	$65,000

Why are we moving Customer B and Customer C? Because the invoice due date and the expected cash date are not always the same. Customer B normally pays about a week late. Customer C has already told your account manager that its next payment run is in Week 3.

Your accounting system knows when the invoice is due. Your team often knows when the money is actually likely to arrive. That second thing is what we want in a direct cash flow forecast.

For your larger receivables, ask:

You are estimating the bank date, not the accounting due date.

If you regularly find a lot of your cash sitting with customers, our free Working Capital Calculator works out your DSO, inventory days, payable days and overall cash conversion cycle. It gives you a quick view of where cash is getting stuck.

Step 3: What about sales that haven’t been invoiced yet?

Now suppose your sales team has confirmed another $8,000 order. Good news. But that does not mean another $8,000 of cash this week.

Suppose the order is delivered in Week 1, the invoice is raised at the end of Week 1, and the customer has 15-day payment terms. Cash is therefore expected in Week 4. The journey is:

For short-term forecasting, try not to jump from “we made a sale” straight to “we have cash.” They are different events.

This matters especially for wholesalers, FMCG businesses, manufacturers, distributors and e-commerce businesses with wholesale channels — anywhere there is a meaningful gap between making a sale and collecting the money.

What about the sales pipeline?

Be more careful here. Suppose your sales team says there is a $40,000 opportunity with a very good chance of closing this month. Should $40,000 go into this month’s cash forecast?

Probably not. First the opportunity has to close. Then the product or service may need to be delivered. Then an invoice needs raising. Then the customer’s payment terms begin. Then the customer actually has to pay.

There can be a big difference between an expected sale and an expected cash receipt. For a base short-term forecast, use receipts where there is reasonable visibility. Less certain pipeline can sit in an upside scenario rather than making the base case look artificially comfortable.

The categories your payments fall into

This is where forecasts become too broad. Someone builds a cash forecast and includes payroll, suppliers, rent and taxes — and assumes most of the outflow is covered. Usually it isn’t.

Look at your bank and credit card statements from the last couple of months. You will probably also find:

Some are weekly. Some monthly. Some quarterly or annual. Some are simply irregular. Individually, many of these don’t look significant. Together, they are.

Suppose you forecast all the major payments correctly, but normally spend another $10,000 to $15,000 a month through company cards, fuel, subscriptions, travel, meals and supplies. Leave those out and the forecast will always look better than the bank account eventually does.

The next three steps are how to forecast each of these groups: what is already sitting in your payables, what recurs every week or month, and what runs on its own calendar.

Step 4: Start with AP, but don’t stop at AP

Your accounts payable aging is a good starting point.

Supplier	Amount	Due	Expected payment
Supplier A	$14,000	Week 1	Week 1
Supplier B	$10,000	Week 2	Week 2
Supplier C	$16,000	Week 2	Week 3
Supplier D	$8,000	Week 3	Week 3
Total	$48,000

Again, we care about when the money actually leaves the bank. But AP only tells you about invoices already recorded.

Suppose you have placed a $22,000 inventory order and the supplier hasn’t invoiced you yet — $10,000 goes out as a deposit in Week 1, the $12,000 balance on delivery in Week 4. Or management approved a marketing campaign starting next month. Or your annual insurance premium falls due in three weeks. Or you have committed to an equipment deposit.

None of those appear in today’s AP aging. They are still expected cash outflows. A useful direct forecast includes known commitments, not only invoices already sitting in AP.

Step 5: Add your regular operating payments

This doesn’t need to become complicated. Suppose recent bank and card activity tells you the business normally spends about this:

Operating expense	Typical timing	Expected cash
Fuel	Weekly	$1,000
Meals and entertainment	Weekly	$400
Employee reimbursements	Weekly	$600
Software subscriptions	Monthly (Week 2)	$1,000
Utilities	Monthly (Week 4)	$600
Cleaning and maintenance	Monthly (Week 4)	$400

That is $2,000 in a normal week, $3,000 in the weeks the monthly items land — about $10,000 a month.

You don’t need to forecast every $42 lunch bill separately. That creates work without improving the decision. For predictable expenses, use the actual payment schedule. For smaller variable ones, recent actual spending gives you a reasonable weekly assumption.

The question is not “can we predict every small transaction?” It is “have we allowed enough cash for the normal costs that will hit the bank?”

Step 6: Put payroll where it actually happens

Payroll is the clearest example of why timing matters. Suppose payroll is $32,000 every two weeks. Don’t spread $64,000 evenly across four weeks to make the forecast look neat.

Your actual cash movement is:

	Week 1	Week 2	Week 3	Week 4
Payroll	$32,000	—	$32,000	—

That is what goes into the forecast. Why? Because we are trying to find the week when cash gets tight, and smoothing a large payment across several weeks hides exactly what the forecast is supposed to show you.

The same applies to taxes, rent, debt repayments, insurance and large subscriptions.

Now let’s come back to our $80,000

Bring the receipts and payments together and the forecast looks like this:

	Week 1	Week 2	Week 3	Week 4
Opening cash	$80,000	$40,000	$34,000	$6,000
Customer collections	$20,000	$15,000	$30,000	$10,000
Other receipts	—	$5,000	—	$8,000
Cash available	$100,000	$60,000	$64,000	$24,000
Supplier and inventory payments	($24,000)	($10,000)	($24,000)	($12,000)
Payroll	($32,000)	—	($32,000)	—
Rent, tax and other fixed	($2,000)	($10,000)	—	($3,000)
Regular operating expenses	($2,000)	($3,000)	($2,000)	($3,000)
Other commitments	—	($3,000)	—	($2,000)
Closing cash	$40,000	$34,000	$6,000	$4,000

Reading across the rows: collections are Customers A, B and C landing on the dates we expect them, plus $10,000 of invoices raised in the first two weeks on short terms. Other receipts are a $5,000 customer deposit and the $8,000 order collecting in Week 4. Supplier payments are the AP aging plus the inventory deposit in Week 1 and its balance in Week 4.

Now the $80,000 tells us something useful. If we only looked at the bank today, things would seem fine. The forecast tells us Week 3 could be difficult.

And that is information we can act on:

The important point is that you can make those decisions while there is still $80,000 in the bank. Not when the balance has already reached $6,000.

You found the difficult week. What now?

Once a forecast identifies a squeeze, the next question is usually “what should we actually pay this week, what should we chase, and what can wait?” That is slightly different from forecasting.

Our free Weekly Cash Decision Calculator is built for that shorter-term decision. Enter available cash, expected collections and bills due, and work through which payments need protecting versus where there may be some flexibility.

Think about the two tools differently. The 13-week forecast helps you see where a problem may be coming. The weekly cash decision helps you work through what needs attention now.

Direct vs indirect cash flow forecasting

This is often made more complicated than it needs to be.

A direct cash flow forecast asks: what cash will actually come into the bank, and what cash will actually leave it? An indirect cash flow forecast generally starts with profit or another accounting measure, then adjusts for non-cash items and movements in working capital.

Both are useful. They answer different questions. If you are building an annual budget, a longer-term plan or an integrated three-statement model, an indirect or balance-sheet-driven approach makes sense.

But when the owner asks “will we have enough cash to make all our payments three Fridays from now?” — for that, we want the actual expected receipts and payments. That is where the direct method becomes much more useful operationally. If you want the fuller comparison, we have written it up here.

Does every week need this level of detail?

No. And this is where top-down cash flow forecasting works alongside the direct method.

For the next two or three weeks you know quite a lot. You know the outstanding invoices. You know which customers normally pay late. You know the next payroll date, the supplier payments, the rent, the credit card bill.

But can you name every customer receipt and supplier payment six months from now? Probably not. So the level of detail changes as you move further out:

Forecast period	How we might forecast it
Weeks 1–4	Detailed customer receipts, supplier payments, payroll and known commitments
Weeks 5–13	AR and AP, confirmed orders, purchase orders and recurring operating assumptions
Beyond 13 weeks	Revenue, margins, DSO, inventory, DPO, payroll and other business drivers

The further out you go, the more you move from individual transactions towards business drivers and assumptions. That is not a weakness in the forecast. It is recognising that certainty changes with time.

For businesses wanting to extend beyond short-term cash visibility into a full financial plan, our free SMB 3-Statement Financial Model takes the other approach — connecting revenue, costs, working capital, capex and funding across the income statement, balance sheet and cash flow statement.

Use the right model for the question you are trying to answer.

You don’t need a perfect cash forecast on day one. You need enough visibility to see the difficult week before you reach it. That is ultimately what direct cash flow forecasting is supposed to give you.

If you would like a second pair of eyes on yours, email me at anant@ease.pro. I hope you have a great day.

Frequently asked questions

What is direct cash flow forecasting?

You start with the cash you actually have and work through the money you expect to receive and the money you expect to pay, week by week. Opening cash, plus cash in, minus cash out, equals closing cash — and this week's closing becomes next week's opening. Nothing is derived from profit, so every line traces back to a real invoice, order or commitment.

How is it different from indirect cash flow forecasting?

A direct forecast asks what cash will actually enter and leave the bank. An indirect forecast starts with profit or another accounting measure and adjusts for non-cash items and working capital movements. Both are useful, they just answer different questions. For an annual budget or a three-statement model, indirect makes sense. For whether you can make all your payments three Fridays from now, you want the direct view.

Should I use the invoice due date or the date I expect to be paid?

The date you expect to be paid. Your accounting system knows when the invoice is due; your team often knows when the money is actually likely to arrive — that this customer normally pays a week late, or that their next payment run is in week three. You are trying to estimate the bank date, not the accounting due date.

Should the sales pipeline go into a cash forecast?

Be careful with it. An opportunity has to close, then be delivered, then invoiced, then the payment terms begin, then the customer actually has to pay. That is a long way from cash. For a base short-term forecast, use receipts where there is reasonable visibility and let less certain pipeline sit in an upside scenario rather than making the base case look artificially comfortable.

What do people most often leave out?

The small recurring outflows. Payroll, suppliers, rent and taxes get forecast carefully, and then fuel, subscriptions, travel, meals, reimbursements, bank charges and office costs get missed. Individually they look immaterial. Together they can be ten to fifteen thousand a month, and leaving them out means the forecast will always look better than the bank account eventually does.

How far ahead should a direct forecast go?

Thirteen weeks is the standard window, and the level of detail should change as you move out. Weeks one to four can be named receipts and payments. Weeks five to thirteen work off AR, AP, confirmed orders and recurring assumptions. Beyond that you are better served by business drivers — revenue, margins, DSO, inventory, DPO — in a three-statement model.