CFO & Advisory
Cash-Flow Forecast: Why Your Bank Balance Misleads You
Create a dated cash-flow forecast that accounts for receivables, payroll, taxes, cards, debt, equipment, owner activity, and uncertainty.
A cash flow forecast starts with usable cash, then adds expected receipts and subtracts payroll, taxes, debt, vendors, cards, owner decisions, and other commitments by week. The bank balance alone shows none of those future dates.
Build the forecast from reconciled opening cash and evidence-based timing. An invoice due next Tuesday is not the same as a customer expected to pay next Tuesday. A credit-card balance, tax liability, or annual insurance renewal may be real even when the cash has not moved yet.
Why the bank balance is incomplete
The bank shows cleared cash in one account at one moment. It does not automatically include checks in transit, card balances, payroll funding, tax deposits, vendor bills, customer refunds, debt payments, or cash expected from receivables.
It may also include customer deposits, loan proceeds, owner contributions, or transfers that are not current-period profit. A reliable cash-versus-profit review explains the balance before the forecast extends it forward.
Build the forecast from evidence
Choose a useful horizon and level of detail
A rolling weekly forecast is useful for near-term liquidity. Thirteen weeks is one practical horizon because it covers several payroll, tax, billing, and vendor cycles, but it is not a universal requirement. A monthly model may be more useful for longer decisions such as hiring, equipment, or a second location.
Use enough detail to identify decisions. Do not create hundreds of lines that nobody can update. Group stable recurring payments, but show large or uncertain items separately.
Start with verified opening cash
Use reconciled bank balances as of a defined date. Subtract known outstanding checks and payments that have not cleared. Add only deposits in transit that are supported and expected to clear. Keep restricted or designated funds separate from general operating cash.
If the opening balance cannot be reconciled, the forecast begins with an unexplained error. Fix the books before relying on a precise projection.
Forecast cash receipts realistically
- Residential cards and ACH: use expected settlement dates net of known processing timing, while recording gross revenue and fees correctly in the books.
- Commercial invoices: use customer payment behavior, approval status, disputes, and promised dates, not only stated terms.
- Deposits and progress billings: place them on the date supported by the contract and billing plan.
- Loans or owner funding: show them as financing, not customer collections.
- Asset sales, refunds, or credits: list material nonrecurring receipts separately.
Do not forecast the full receivable aging as if every customer will pay on the due date. Apply a documented collection assumption and flag concentrated or disputed accounts.
Forecast cash payments by actual date
Include net payroll, payroll taxes, benefits, workers’ compensation, vendors, cards, rent, insurance, software, fuel, debt principal and interest, equipment, tax payments, owner distributions, and planned transfers. Separate committed payments from discretionary plans.
Credit-card purchases should not disappear. The purchase may occur today while the cash leaves on the statement due date. The forecast needs the payment date, while the books still record the expense or asset under the applicable accounting policy.
A weekly forecast that exposes the shortfall
Assume opening available cash is $92,000. During the next week, expected collections are $58,000. Scheduled payroll and related funding are $46,000, vendors and cards are $39,000, debt is $8,000, and tax payments are $12,000. This is a simplified hypothetical, not a client result.
Forecast ending cash is $45,000: $92,000 plus $58,000 minus $105,000. The current bank balance looked strong, but the dated commitments show much less flexibility. If $25,000 of collections slips one week, ending cash falls to $20,000. That downside case may change the timing of a truck deposit or owner distribution.
Use scenarios instead of one confident number
Build a base case, a downside case, and decision triggers. The downside case might delay a large commercial collection, add a callback or refund, or reduce seasonal demand. It should be plausible, not theatrical.
Define what happens when projected cash crosses an internal decision level. Actions may include accelerating approved billing, pausing discretionary spending, changing a purchase date, drawing an available credit line, or revising owner distributions. Borrowing decisions require lender terms and professional review.
Compare forecast with actual
Every update should explain why actual cash differed from forecast. Separate timing from amount. A customer may pay the correct amount one week late, while a vendor bill may be larger than expected. Those require different responses.
Track collection variance, payroll variance, material timing, card spending, taxes, debt, and unplanned purchases. Update the next forecast rather than rewriting the prior version. The working-capital guide explains how to preserve operating assumptions and scenarios.
Forecasts that look precise but fail
Common failures include starting from unreconciled cash, using invoice due dates as guaranteed collection dates, omitting card payments, treating a credit limit as cash, ignoring taxes and debt principal, and forecasting owner distributions as whatever remains.
A cash forecast can also give false comfort when it replaces the P&L. Delaying vendors, drawing a credit line, or postponing purchases may protect this week’s bank balance without improving the economics of the business. Review cash, profit, and the balance sheet together using the cash flow versus profit framework.
Assign confidence levels to incoming cash
Not every expected receipt belongs in the forecast at the same confidence. Separate confirmed card settlements and approved invoices from unsigned proposals, disputed invoices, unapproved change orders, and customers who routinely pay late. Use the expected bank date, not the date the team hopes to collect.
Keep a short collection note beside material receipts: customer, invoice, amount, required approval, last contact, committed date, and owner. If a large payment moves, update the related vendor and payroll decisions immediately. This creates a forecast the team can operate, not a static spreadsheet that is correct only on the day it was created.
Review forecast accuracy too. Compare last week’s expected receipts and payments with what actually cleared. Separate timing errors from amount errors. Recurring optimistic collections or missing tax debits point to a process that needs correction.
Include a short decision column for every week below the minimum cash level. State whether the response is collection follow-up, payment timing, spending approval, financing, owner funding, or another documented action, and confirm who can authorize it.
Convert the bank balance into available operating cash
Label every account included in opening cash and remove amounts that are restricted, held for customers, reserved for payroll or taxes, or otherwise unavailable for ordinary operations. Adjust for supported outstanding checks, pending transfers, and deposits in transit so the forecast can be reconciled back to the bank and books.
Then add a payment calendar and a collection schedule. The published 13-week forecast guide explains the complete model. This page focuses on the first decision error: treating today’s bank balance as money that can be spent without considering what it already has to cover.
Compare actual cash with the prior forecast every week. Separate timing, amount, omission, decision, and data errors. If expected collections are repeatedly late, change the assumptions rather than moving the same optimistic date forward. A forecast earns trust by explaining its misses.
Educational information only. Tax, payroll, and compliance rules change and may vary by jurisdiction. Confirm the current requirements for your facts with the appropriate agency or a qualified professional.
If the bank balance feels comfortable until payroll week, Steady can build and maintain a decision-ready forecast through its cash-flow budgeting service.
Frequently asked questions
What is a cash-flow forecast?
It is a dated estimate of opening cash, expected receipts, expected payments, and ending cash for future periods.
How often should it be updated?
Update it often enough to reflect material collections, payroll, taxes, purchases, and decisions. Businesses under tighter pressure may update weekly or more often.
Is a 13-week forecast required?
No. It is one practical near-term format. Choose a horizon that covers the decisions and payment cycles your business needs to manage.
Should accounts receivable be included?
Yes, but forecast expected collection dates and amounts based on evidence, not merely invoice due dates.
Does a cash forecast replace a budget?
No. A budget often focuses on planned revenue and expense, while a cash forecast focuses on when cash is expected to move.
Why compare forecast with actual?
The comparison reveals weak assumptions, late collections, unplanned spending, and operating changes, making the next forecast more useful.
Turn this guide into action