A 13-week cash flow forecast gives a small business a rolling view of expected cash receipts, payments, and minimum cash balance. This guide explains how to build one in a spreadsheet, choose realistic timing assumptions, model payroll and taxes, test shortfalls, and run a weekly review that turns changing information into better operating decisions.
Overview
A cash flow forecast is different from a profit-and-loss report. Profit measures revenue and expenses when accounting rules recognize them; a cash forecast focuses on when money is expected to enter or leave the bank account. A profitable business can still face a cash shortage if customers pay slowly, inventory must be purchased in advance, or a large tax or loan payment is due before collections arrive.
The 13-week period is long enough to show upcoming pressure and short enough for assumptions to remain manageable. Use one column for each week and update it at least once a week. The forecast should begin with the cash actually available, not an accounting balance that includes uncleared transactions.
A practical template can use these rows:
- Opening cash balance: the cash available at the start of each week.
- Cash in: customer collections, deposits, refunds received, financing proceeds, owner contributions, and other receipts.
- Total cash in: the sum of all inflows for the week.
- Cash out: payroll, contractor payments, suppliers, rent, software, utilities, taxes, debt service, shipping, inventory, refunds, and owner distributions.
- Total cash out: the sum of all planned outflows.
- Net cash movement: total cash in minus total cash out.
- Closing cash balance: opening balance plus net cash movement.
- Minimum cash threshold: the lowest balance the business wants to maintain for operating resilience.
- Surplus or shortfall: closing cash balance minus the minimum threshold.
Each week’s opening balance should equal the prior week’s closing balance. That simple link makes errors easier to detect and prevents the forecast from becoming a series of unrelated estimates.
How to estimate
Start with a bank reconciliation or current account balance. Remove transactions that have already cleared from the future forecast, then list every known receipt and payment by its expected bank date. Use separate rows for material items rather than hiding them in a single “other” category.
The core cash flow forecasting formula is:
Closing cash = Opening cash + Cash received − Cash paid
For a customer invoice, forecast the collection week rather than the invoice date. Review open invoices, agreed payment terms, customer payment history, scheduled direct debits, and any disputes. If a customer usually pays late, model the likely receipt date instead of relying only on the contractual due date. For uncertain receipts, place them in a separate “risk-adjusted” or “possible” row so the base case does not depend on money that may not arrive.
For recurring expenses, use the payment date and not merely the month in which the cost is incurred. Payroll should include the expected pay date, employer-related costs where applicable, contractor invoices, and any regular benefits or reimbursements. Taxes should be modeled according to the business’s actual filing and payment schedule. Because tax deadlines and obligations vary by jurisdiction and entity type, confirm dates and amounts with the relevant authority or a qualified adviser rather than copying a generic calendar.
Build three views:
- Base case: the most reasonable estimate using current orders, normal collection behavior, and committed spending.
- Downside case: slower collections, lower sales, higher returns, or an unexpected repair or supplier payment.
- Action case: the downside case after planned responses such as delaying a purchase, accelerating collections, reducing discretionary spending, or arranging financing.
Keep financing separate from operating cash flow. A credit line draw can improve the bank balance, but it does not solve an underlying operating deficit. Show the draw, repayment, fees, and interest as distinct rows so management can see both liquidity and borrowing needs.
Inputs and assumptions
Document the assumption beside each estimate. Useful fields include customer or supplier, amount, expected date, confidence level, and source of the estimate. This creates an audit trail when a forecast changes.
For cash in, classify receipts as committed, probable, or uncertain. A committed receipt may be a scheduled payment with a reliable customer; a probable receipt may depend on an order being completed; an uncertain receipt may be a proposal, disputed invoice, or forecast sale. Do not treat a sales pipeline as cash until it has a credible collection date.
For cash out, separate committed obligations from discretionary decisions. Committed items include signed rent, approved payroll, due supplier invoices, debt payments, and known tax obligations. Discretionary items may include equipment, marketing, hiring, nonessential travel, or inventory purchases that can be rescheduled.
Use realistic payment timing for card processors and online payment platforms. A sale recorded today may settle later, and refunds may leave the account on a different date. If the business operates across currencies, record the expected settlement currency and use an exchange-rate assumption that is clearly labeled as an estimate. Review international payment fees and settlement timing when comparing providers; the international payment processor checklist can help organize that review.
Inventory-heavy businesses should connect purchasing assumptions to demand and lead times. A reorder decision that looks affordable in isolation can create a cash gap when supplier invoices arrive before inventory sells. Use the inventory reorder point and safety stock worksheet alongside the forecast.
Worked examples
Assume a business begins Week 1 with $24,000 in available cash. It expects $18,000 in customer collections and $5,000 in other receipts. Planned payments total $21,500, including $9,000 of payroll, $6,000 of supplier invoices, $3,500 of operating overhead, and $3,000 of taxes.
The calculation is:
- Opening cash: $24,000
- Total cash in: $23,000
- Total cash out: $21,500
- Net cash movement: $1,500
- Closing cash: $25,500
If the business sets a minimum cash threshold of $20,000, the Week 1 surplus is $5,500. However, suppose the $18,000 collection is delayed by two weeks. The base-case closing balance would fall to $7,500 before considering other changes. That result does not prove a crisis will occur, but it identifies a decision point: follow up on the invoice, negotiate a supplier date, delay discretionary spending, or review available financing before the shortfall arrives.
For variance tracking, compare the forecast with actual results:
Cash variance = Actual amount − Forecast amount
For timing, record the difference in weeks between the expected and actual date. A forecast that repeatedly overstates collections by amount or timing needs a revised assumption, even if the annual revenue forecast is unchanged. Businesses with subscription, project, wholesale, or seasonal revenue can also compare expected receipts by customer, channel, or product to identify where forecasting errors originate.
Cash planning should complement, not replace, broader financial analysis. For profitability and break-even context, review the unit economics guide. For customer collections, use an accounts receivable aging workflow to connect overdue invoices with forecast dates.
When to recalculate
Recalculate the forecast every week on a fixed day. First, replace the prior week’s estimates with actual bank movements. Second, roll the forecast forward by one week so it always covers 13 future weeks. Third, move receipts to the dates customers now indicate, update supplier and payroll amounts, and remove transactions that have been canceled. Fourth, compare the closing balance with the minimum threshold and review the downside case.
Run an immediate update after a large order, lost customer, delayed collection, new hire, supplier price change, tax notice, loan offer, equipment purchase, or change in payment-platform settlement timing. Revisit assumptions when interest rates, financing terms, exchange rates, shipping costs, or supplier lead times move materially. Economic context can also affect demand and borrowing decisions; the economic indicators guide provides a framework for interpreting those changes.
Turn the review into a short operating meeting with four questions: What changed from last week? Which receipts are at risk? Which payments can be controlled without harming operations? What action is required before the minimum cash threshold is breached? Assign an owner and deadline to every action.
Finally, save dated versions of the forecast. Comparing successive versions reveals whether the business is consistently optimistic about collections or missing certain costs. A 13-week forecast is most valuable when it becomes a living decision tool: update it with actuals, challenge weak assumptions, and use the earliest warning to make measured changes to hiring, purchasing, collections, or financing.
