Cash Flow Projection

A cash flow projection is a forward-looking estimate of the cash a business expects to receive and pay out over a future period. It takes current balances and applies assumptions about timing and amount to show what the bank balance is likely to look like weeks or months from now.

How It's Built

A cash flow projection has no single formula, but it follows a consistent structure. You start with the opening cash balance, add projected inflows, subtract projected outflows, and arrive at a closing balance for each period.

Closing Cash Balance = Opening Cash Balance + Projected Inflows - Projected Outflows

That closing balance becomes the opening balance for the next period, and the projection rolls forward.

Projected inflows typically include:

Expected customer payments, based on outstanding invoices and historical collection timing

Scheduled recurring revenue

Any other anticipated cash receipts (asset sales, tax refunds, loan drawdowns)

Projected outflows typically include:

Supplier payments, based on outstanding payables and payment terms

Payroll and related costs

Rent, utilities, and fixed operating costs

Loan repayments and interest

Estimated tax payments

Planned capital expenditures

The quality of a projection depends entirely on the quality of those assumptions. A projection built from live accounts receivable and payable data is more reliable than one built from rough monthly estimates. The closer the inputs are to actual scheduled transactions, the more useful the output.

A small retail business wants to project its cash position over the next four weeks. Its opening bank balance is $18,000.

Week 1

• Expected customer payments: +$14,000
• Supplier invoice due: -$9,000
• Payroll: -$6,000
• Closing balance: $17,000

Week 2

• Expected customer payments: +$11,000
• Rent due: -$4,500
• Utilities: -$800
• Closing balance: $22,700

Week 3

• Expected customer payments: +$8,000
• Supplier invoice due: -$12,000
• Payroll: -$6,000
• Estimated tax payment: -$5,500
• Closing balance: $7,200

Week 4

• Expected customer payments: +$16,000
• Supplier invoice due: -$7,000
• Closing balance: $16,200

Week 3 is the problem. The combination of a large supplier invoice, payroll, and a tax payment drops the balance to $7,200, tight, but manageable here. If any of those payments were larger, or if the customer receipts in Week 3 came in late, the balance could go negative. The projection shows that before it happens, which is the point.

It makes timing problems visible before they become cash problems

A business can have strong sales and still run out of cash if payments arrive after obligations fall due. A projection maps the gap between when cash goes out and when it comes in. That gap is often invisible on a profit and loss statement, which records revenue when earned rather than when collected.

It gives you time to act

A projection that shows a low balance in six weeks is useful. A bank statement that shows a low balance today is not. The forward view is what creates room to make decisions: chase a receivable, negotiate a payment extension, draw on a credit facility, or delay a discretionary purchase. None of those options is easy to exercise once the balance is already short.

It's a communication tool as well as a planning tool

Lenders want to see projected cash positions before approving a loan or credit line. Investors want to understand how the business will fund its operations over the next year. A well-structured projection makes those conversations more concrete and more productive than a discussion of historical results alone.

A projection turns assumptions about sales and timing into a forward balance, so you see a shortfall while there is time to act.

• The mechanism is straightforward: every assumption you make about a future inflow or outflow gets translated into a specific week or month on the projection, and the running balance shows where cash will be tight. A business that updates its projection regularly, as invoices are raised, as payments come in, as unexpected costs appear, gets a view that is continuously recalibrated rather than a static estimate that ages out of relevance within days of being built.

What makes this practical rather than theoretical is the connection to real data. A projection built on actual outstanding invoices and scheduled payments is doing something different from one built on average monthly revenue estimates. The first is tracking real money moving through the business. The second is an approximation. Both are better than nothing, but only the first catches the specific week where the tax payment and the large supplier invoice land on the same day as a customer who always pays late.

Cash Flow Frog connects to QuickBooks Online, QuickBooks Desktop, Xero, and Sage Intacct and builds a rolling cash flow projection automatically from your accounting data. QuickBooks records what happened. Cash Flow Frog projects what is coming.

Because the projection pulls from live accounting data, the inflows and outflows reflect actual invoices and bills rather than estimates typed into a spreadsheet. The forecast runs up to three years out and updates as your books update, so the projection stays current without manual rebuilding. If you want to understand what is driving a balance at a particular point, the tool drills down to the transaction level. For businesses with multiple entities or currencies, that works natively. You can see how projections work in Cash Flow Frog at cashflowfrog.com/features/projections/.

Frequently Asked Questions

What's the difference between a cash flow projection and a cash flow forecast?

In practice, the terms are used interchangeably, and there is no universal standard that separates them. Some accountants use "projection" for a short-term, transaction-level view (weeks to a few months) and "forecast" for a longer-term, assumption-based view (months to years). Others use them as synonyms. What matters more than the label is knowing the time horizon, the inputs, and how often the numbers are updated.

How far ahead should a cash flow projection go?

It depends on your business cycle and what you are trying to manage. A business with 30-day payment terms and predictable costs can get useful insight from a four-to-eight-week projection. A business planning a capital purchase, managing seasonal swings, or applying for financing typically needs three to twelve months of visibility. The further out the projection goes, the more it relies on assumptions rather than known transactions, so the two are not equivalent in reliability.

How often should a projection be updated?

Often enough that it reflects current reality. For most small businesses, that means at minimum weekly if the projection is being used to manage near-term cash, and monthly if it is being used for planning purposes. A projection that has not been updated in three weeks is likely showing you a picture that no longer matches what is actually in the pipeline.

Payment timing is the main one. Customers who were expected to pay in Week 2 pay in Week 4 instead, and the projection assumed the earlier date. After timing, the next most common issue is missing outflows, expenses that were not in the books when the projection was built, or irregular costs like tax payments and insurance renewals that fall outside the normal monthly pattern. Both problems are reduced when the projection pulls from live accounts receivable and payable data rather than manual estimates.

Can a cash flow projection show the business is healthy when it isn't?

Yes, if the assumptions are optimistic. A projection built on best-case collection timing or overstated sales will show a comfortable forward balance that does not materialise. That is why the assumptions behind a projection matter as much as the projection itself. Scenario planning, running a base case and a downside case where key customers pay late or a major sale does not close, gives a more honest picture of the range of outcomes.

Is a cash flow projection the same as a budget?

No. A budget sets targets for revenue and expenditure over a period, usually a year. A cash flow projection estimates when cash will actually move, which depends on payment timing rather than accounting periods. A business can be on budget and still face a cash shortfall in a specific week if timing is unfavorable. The two tools answer different questions and are more useful together than either is alone.

• Cash Flow Forecast
• Cash Flow Statement
• Operating Cash Flow
• Accounts Receivable
• Working Capital
• Scenario Planning