13-Week Cash Flow Forecast for a Small Service Business: Excel Example
A business can report a profitable month and still struggle to make payroll on Friday. Profit and cash timing are different questions: an invoice may be recognized in the books before the client actually pays, while rent and supplier bills must be settled on real dates. A 13-week cash flow forecast puts expected bank-account movements on a weekly calendar so a business owner can spot pressure before it becomes an emergency.
This guide demonstrates a direct, receipts-and-payments forecast using fictional U.S.-dollar data and a working Excel example. It is intended for planning and learning, not financial, tax, credit, or investment advice. You should reconcile your actual figures to your accounting records and banking information before using such a forecast for decisions.
What belongs in a weekly cash forecast?
Start with the opening available cash at the beginning of Week 1. It should come from a reconciled account balance, adjusted for payments already committed or not yet cleared when appropriate. Record each expected receipt in the week cash is genuinely likely to arrive—not simply the week a customer was invoiced.
Outflows should include payroll, supplies, software charges, rent, taxes, debt repayments, and other cash payments as applicable. Classify them into a few useful categories; don't build a hundred-row chart if twenty rows would make decisions clearer. Keep transfers between company accounts distinct from operating receipts so you do not count the same money twice.
The IRS guidance on business records emphasizes maintaining supporting documents such as receipts, invoices, and bank records. A forecast complements these records but does not replace the underlying accounting books.
The four formulas behind the model
Every week follows the same arithmetic:
1. Total receipts = expected customer collections + other real cash receipts. 2. Total payments = payroll + suppliers + other expected cash outflows. 3. Net movement = total receipts − total payments. 4. Closing cash = opening cash + net movement. The next week's opening cash equals the previous week's closing cash.
One extra control makes the forecast actionable: headroom = projected closing cash − minimum operating cash buffer. A negative result means the forecast is below the business's own chosen buffer, not automatically insolvent. The buffer is an internal management assumption; do not present it as an IRS or lender requirement.
Worked example: Harbor Field Services (fictional)
Suppose a small appointment-based service business starts with $12,000 available cash and selects a provisional $6,000 minimum buffer. Its first three weeks look like this:
| Week | Opening cash | Expected receipts | Expected payments | Closing cash | Headroom vs $6,000 | |---|---:|---:|---:|---:|---:| | 1 | $12,000 | $5,000 | $6,500 | $10,500 | +$4,500 | | 2 | $10,500 | $3,600 | $8,500 | $5,600 | −$400 | | 3 | $5,600 | $8,200 | $5,300 | $8,500 | +$2,500 |
In Week 1, the calculation is $12,000 + $5,000 − $6,500 = $10,500. Week 2 opens at $10,500 and closes at $5,600. The lowest closing balance across these three fictional weeks is $5,600, which is $400 below the chosen buffer. Week 3 recovers to $8,500 if the projected collection arrives as scheduled.
That conditional phrase matters. A forecast is not a promise. An overdue client payment can move $4,000 from Week 3 to Week 5 in a single afternoon, reducing the earlier weeks' cash positions. The forecast helps a manager plan questions before money is gone; it cannot guarantee receipts.
Build the workbook without double counting
The companion Excel workbook contains an Inputs sheet, a 13-Week Forecast sheet, and a Scenario Notes sheet. It includes synthetic numbers for every week and formula-driven weekly closing balances. Blue-font cells are intended for editable inputs; derived values are calculated. No external financial accounts are connected.
In the Inputs sheet, confirm the opening cash balance and the minimum buffer first. Then adjust customer receipts, other inflows, payroll, suppliers, and other payments by week. Review whether amounts reflect actual cash dates and whether taxes or loan principal have been omitted from the correct cash category. If sales tax or payroll liabilities apply, ask a qualified accountant how to represent their payment timing for your operation.
A useful control is an independent reconciliation: when a week completes, compare the spreadsheet's prior forecast with actual bank movements and explain each major difference. Do not silently overwrite an older forecast; keep a date-stamped snapshot to learn why assumptions were inaccurate.
Run a late-payment scenario
Assume that $4,000 of Week 3's expected customer collections will arrive in Week 5 instead. Keep all other assumptions unchanged. In your working copy, reduce Week 3 customer receipts by $4,000 and add the same amount to Week 5. The total receipts over all 13 weeks are unchanged, but Week 3 and Week 4 closing cash each fall by $4,000 until the delayed receipt arrives. This is an example of timing risk, not a change in total sales.
If another large payment falls due in Week 4, the short-term cash shortfall could be deeper. Highlight the lowest projected closing balance across the full thirteen weeks, not just the final Week 13 number. A healthy ending cash balance can hide a dangerous dip in the middle.
Possible responses include following up on invoices before due dates, reviewing payment timing with suppliers, avoiding nonessential spending, or exploring appropriate financing with qualified advisers. Do not assume you may withhold legally due payroll, taxes, or other mandatory payments merely because a spreadsheet shows a shortfall.
How often should it be updated?
For a cash-sensitive small company, a weekly review is a reasonable starting workflow. Assign one owner to confirm the opening balance, update customer collection expectations, review payables, and note changes made to the assumptions. Roll the horizon forward each week: drop the completed week, add a new thirteenth week, and preserve the prior snapshot.
A forecast based only on optimistic invoice dates will look reassuring and be unreliable. Ask the person responsible for collections to distinguish promised payment dates, contractual due dates, and historical payment patterns. Label uncertain cash inflows so they cannot be mistaken for money already received.
If you have a large seasonal swing, a twelve-month budget can complement the thirteen-week view. A budget estimates the longer-term operating plan; a weekly cash forecast focuses on when money enters and leaves. Maintain both when useful, rather than stretching one worksheet beyond its intended purpose.
Three checks before using the forecast
Check 1: Opening balance. Does Week 1 match the cash available after reconciling bank statements and material pending transactions? Unreconciled starting balances make every downstream formula misleading.
Check 2: Plausible receipts. Is every expected receipt tied to a named invoice, confirmed booking payment, or a clearly identified assumption? The IRS recordkeeping overview explains why businesses need reliable income and expense records to understand results.
Check 3: Dates, not just totals. Are payroll, rent, taxes, and supplier payments placed in the actual payment week? A forecast with correct totals but wrong dates can miss the exact period when liquidity is tight.
When testing the workbook, set a customer's payment to zero and see whether all following closing balances change. Restore it, then move it to another week and confirm that the change flows forward but does not alter the thirteen-week total. These simple tests catch hardcoded totals and broken carried-forward formulas.
What this forecast does not tell you
It does not calculate accounting profit, determine taxable income, establish creditworthiness, or predict whether a customer will pay. It does not automatically reconcile bank feeds or create an auditable general ledger. It also does not select an objectively correct cash buffer; that number depends on the business's obligations, seasonality, risk tolerance, and available financing.
For related fundamentals, read VectoraWork's small-business bookkeeping workflow and the accounts receivable aging example. The former supports accurate records; the latter helps identify which invoices may require realistic collection assumptions in a forecast.
Takeaway
If you start with a reconciled balance, place receipts and payments in the right weeks, calculate carried-forward cash, and stress-test a delayed payment, a simple thirteen-week model can reveal problems hidden by monthly summaries. The most useful part of the exercise is the conversation it creates about cash timing—not the spreadsheet's apparent precision.
Editorial note: Harbor Field Services and all figures are fictional. Numbers are in USD. The workbook is an educational model; obtain professional advice for tax, lending, wage payments, and material financing decisions.
Sources
Practical takeaway
Opening cash plus received cash less cash paid equals closing cash; test uncertain collection timing and inspect the lowest weekly balance.
Sources and further reading
External references relevant to this guide. We encourage you to check current primary documentation.
Published by VectoraWork Editorial Team. This is general educational information, not individualized legal, tax, financial, employment or security advice. Request a correction.
