Small Business Cash Flow Forecast Template (Free Excel)

Small business cash flow forecast template is more than a spreadsheet: it is a way to find out whether your business will have enough money in the bank when bills actually come due. A shop can make sales all week and still struggle to pay rent if customers pay later, suppliers expect payment now, and a tax deposit falls on the same Friday.

This guide includes a free Excel-compatible 13-week cash flow forecast, a 12-month planning version, formulas, practical examples, and step-by-step instructions for U.S. small business owners. The templates use fictional numbers for teaching; replace them with your own receipts, payment dates, cash balance, and required minimum reserve before using the forecast for a decision. Reviewed October 27, 2026.

Quick answer: Start with today’s actual cash balance. For each future week or month, enter money you reasonably expect to receive and money you expect to pay. Closing cash = opening cash + cash received − cash paid. Roll that closing balance into the next period, set a minimum safety balance, and update the forecast every week.

Download the free small business cash flow forecast template

Use the Excel package for two connected-by-purpose worksheets (weekly and monthly) or download an individual CSV that opens in spreadsheet software. There is no email gate and no bank-account connection.

• Download the free Excel workbook — ZIP package (.xlsx inside). The most reliable download choice; includes the 13-week and 12-month forecast.
• Direct Excel workbook (.xlsx). If your browser displays the file instead of saving it, use the ZIP link above.
• Download the 13-week forecast (.csv). Lightweight file with editable figures and formulas.
• Download the 12-month forecast (.csv). Use for seasonal planning, rent, payroll, and equipment purchases.

Before you edit: All opening balances, receipts, expenses and reserves in these files are illustrative U.S.-dollar examples. The Excel files do not import transactions from banks or tax systems. The CSV files have a flat layout and may not retain formatting when opened; use the Excel version if you prefer a styled workbook.

Why profit and cash flow tell different stories

Profit is an accounting measure of revenue minus expenses using the applicable accounting basis. Cash flow shows when money actually enters or leaves. A $6,000 invoice sent today may count toward revenue under accrual accounting, but it provides no cash for rent until the customer pays. Similarly, paying cash for equipment can reduce the bank balance immediately even when the purchase is treated differently in the income statement.

The FDIC and SBA Money Smart for Small Business program includes a Managing Cash Flow module that teaches owners to distinguish actual cash results from projections. The participant guide emphasizes planning cash coming in, cash going out, and using projections to solve problems before a shortfall.

What is in our cash flow forecast spreadsheet?

Both forecasts calculate the opening balance, total cash in, total cash out, net movement, closing cash, and the amount remaining above the reserve floor. A negative number means the assumptions show a potential cash shortfall—not necessarily that the business is insolvent.

How to use the 13-week cash flow forecast: step by step

Step 1: enter actual available bank cash

Open the 13-week worksheet and change the sample opening balance to the business cash available at the start of Week 1. Exclude personal funds that are not committed to the business and uncollected invoices. If a tax or payroll amount is already set aside in a restricted account, do not casually treat it as freely spendable cash.

Step 2: record money according to expected deposit dates

Enter expected customer payments in the week funds should clear. A sale today is not the same as a payment today. Use realistic customer behavior and existing terms: card settlement delays, 30-day invoices, marketplace payout cycles, deposits, or expected funding. Keep owner contributions and loan proceeds on their own row so they do not inflate business sales.

Step 3: place expenses in the week they must be paid

Use the actual or best-known due dates for payroll, rent, utilities, supplier invoices, shipping, software, taxes, equipment and owner drawings. Don’t automatically spread everything evenly: one annual insurance renewal or equipment purchase can make an otherwise comfortable week suddenly tight.

Step 4: set a minimum cash floor

A cash floor is the amount you choose not to spend casually because it covers upcoming uncertainty. Our weekly template displays $1,500 only as an editable illustration. Your real floor depends on unavoidable fixed costs, payroll, seasonality and access to funding.

Step 5: inspect every closing balance

The spreadsheet uses three core formulas: Total Cash In = sum of all receipts; Total Cash Out = sum of payments; and Closing Cash = Opening Cash + Total Cash In − Total Cash Out. The next week’s opening balance equals this week’s closing balance. The final line compares cash with your floor.

Step 6: compare forecast with what actually happened

At the end of each week, replace estimates for the elapsed period with actual deposits and withdrawals, then revise the remaining weeks. Keep a saved copy of the old forecast so you can learn from your estimates. A weekly cash review can be as valuable as the file itself.

Worked example: sales are up, but Week 3 needs attention

Imagine an owner-operated service business with $6,200 in cash at the start of its sample Week 1. The figures below reproduce the hypothetical initial weeks of the downloadable weekly template.

In Week 2, cash improves because $2,200 arrives while $1,620 leaves. In Week 3, the business collects less and buys equipment, so closing cash falls by $1,280. The company may still be profitable on paper, but the calendar—not a monthly sales graph—shows the immediate cash pressure.

With the example $1,500 minimum cash floor, the Week 3 forecast has $4,000 above the floor. That is not a reason to stop watching: an unexpected tax payment, late customer or equipment breakdown could narrow the buffer. This is why a forecast should be recalculated when assumptions change.

A second example: what if a customer pays late?

Suppose you enter Week 4 expecting $2,200 of collected customer invoices, and you have $2,000 in unavoidable payments. With $3,000 opening cash, the expected closing balance is $3,200. Now suppose $1,400 of expected invoices are postponed until Week 5. Week 4’s receipts fall to $800; closing cash becomes $1,800. If your cash floor is $2,500, the model signals a $700 buffer gap for that week.

The delayed $1,400 may arrive next week, but that does not eliminate today’s $700 reserve shortfall. Possible responses include following up on overdue invoices, negotiating payment dates before they are due, reducing optional inventory orders, or confirming an appropriate short-term funding option. Never assume a customer will pay early without checking.

How a 12-month cash flow forecast is different

A 13-week view is an operating calendar; a monthly forecast helps identify seasonal patterns. A seasonal retailer might pay for holiday inventory in September and receive most sales in November and December. A landscaping company may collect more in warm months, while a consultant may collect irregular project deposits. Neither business should divide annual income and expenses by 12 and call the result a reliable forecast.

• Monthly opening balance: January begins with actual available cash; every later month inherits the prior closing balance.
• Customer receipts: project collections based on historical payment behavior and expected contracts, not merely invoices you hope to send.
• Purchases and payroll: schedule inventory replenishment, hiring and pay periods realistically.
• Tax remittances: place estimated payments or deposits when they are actually due for your circumstances.
• Seasonal stress test: prepare a conservative case with slower receipts, faster cash outflows or a major one-time bill.

The monthly template includes a hypothetical 2027 example. Edit month labels, assumptions, expenses and the reserve floor for your actual planning period. It is not a financial statement and should not be treated as one.

The six cash forecast lines owners often forget

1. Taxes held for later remittance

Sales tax collected for a taxing authority and money earmarked for income or payroll taxes should not be treated as freely available profit. The IRS estimated-tax guidance explains that many self-employed taxpayers must make estimated tax payments, with specific rules and due dates. Cash forecasting helps make those upcoming payments visible; it does not calculate the exact legal amount owed.

2. Customer payment delays

If a client routinely pays 10 days after an invoice is issued, use the expected collection date rather than the invoice date. A forecast should reflect real payment behavior. Track overdue accounts separately so you can identify concentration risk from one large customer.

3. Inventory paid before it sells

Retailers often pay suppliers before products are sold. Replenishment, shrinkage, freight and returns can drain cash, even when reported sales are increasing. Link planned stock purchases to specific reorder dates and inventory turnover expectations.

4. Annual and one-off charges

Insurance renewals, professional-license renewals, equipment replacements, tax preparers and software renewals can disappear from an ‘average month’ assumption. Put them where the money is due.

5. Owner draws and loan repayments

A cash withdrawal by the owner may be essential to household survival but is not necessarily an operating expense in the profit-and-loss statement. Financing cash inflows are not customer revenue, and principal payments can affect cash differently from accounting profit.

6. The minimum viable reserve

Cash that exists in the bank is not necessarily spare cash. Reserve enough for the bills the company cannot responsibly postpone; explicitly monitor the balance above that safety level.

Industry-specific adjustments

13-week forecast versus annual budget: why you need both

A budget says what you plan to earn and spend in an accounting period. A cash forecast indicates whether the bank balance can meet obligations on the relevant dates. If you rely exclusively on one annual total, you can miss a temporary shortfall in February even if the year looks profitable in December. Combining near-term and monthly views improves decisions about staffing, purchasing and financing.

For more practical help, see our related article Working Capital for Small Businesses, our breakdown of startup costs by industry, and the example of starting a small business with $5,000.

Common spreadsheet mistakes that distort the answer

• Recording sales instead of collections: move the invoice amount to the week the bank is expected to receive it.
• Counting loans as sales: funding can temporarily increase cash but creates obligations and does not show customer demand.
• Excluding the owner’s cash needs: a company can remain cash-positive while its owner cannot pay essential personal bills.
• Mixing operating and financing rows: separate the reasons cash moves so you can understand what is sustainable.
• Assuming last year’s best month repeats: use conservative scenarios as well as your expected case.
• Forgetting to update: a forecast that never changes becomes a historical guess, not a decision tool.
• Treating the CSV as the same as the styled XLSX: use the Excel download for formatting and separate worksheets; CSVs are simpler exports.

A 20-minute weekly cash review routine

1. Open your actual bank balance and reconcile recent transactions.
2. Replace the just-finished week’s estimated amounts with collected and paid cash.
3. Move invoices that have not cleared to realistic later dates.
4. Check due dates for payroll, taxes, lease, insurance and large orders.
5. Look for any period where closing cash drops below zero or below your floor.
6. Assign one action to each risk: collect earlier, defer optional spending, renegotiate terms or verify financing.
7. Save a copy of the previous forecast so you can compare planned versus actual results.

The SBA guidance on managing business finances emphasizes understanding financial records and anticipating future obligations. The SCORE 36-month projection resource is another useful reference for founders seeking a longer-horizon exercise. Our downloadable workbook was created independently for Tendências Centrais and is not an official government template.

Frequently asked questions

How do I create a cash flow forecast for a small business?

Start with available cash, assign expected receipts and payments to the periods in which cash will move, calculate the closing balance, roll it forward, and compare it against a cash reserve target. Update the forecast when invoices or bills change.

Is the cash flow forecast Excel template really free?

Yes. The workbook and the two CSV versions are offered without a paywall or email gate. They contain illustrative input values and spreadsheet formulas; you must substitute actual figures before relying on any decision.

Should I use a 13-week or 12-month cash flow forecast?

Use 13 weeks to manage upcoming payroll, accounts receivable and bills with precise dates. Use 12 months for seasonality, planned inventory purchases, hiring and longer-term cash strategy. Many businesses benefit from both.

Does profit mean positive cash flow?

No. A business may report a profit yet run short of cash because its customers pay late or because it invests in inventory or equipment. Profit and cash use different measurement rules.

Where do I put a small business loan in the template?

Place the proceeds under financing or owner contributions, not sales. Put cash loan payments in the relevant payment row. This educational template does not automatically separate interest and principal for tax or accounting statements.

How do I forecast sales when my company is brand new?

Use conservative customer-acquisition assumptions based on your quoted pipeline and a small paid test. Keep optimistic numbers in a separate scenario and do not treat expressions of interest as confirmed deposits.

How should I forecast estimated taxes?

Consult the IRS guidance and a qualified professional for your actual obligations. Schedule estimated tax payments in the periods they are due and keep amounts earmarked for taxes distinct from general-purpose cash.

What if the cash forecast shows a negative balance?

Recheck the assumptions and due dates, then examine collection efforts, optional expenses, inventory orders, payment arrangements and responsible funding choices. A forecast warning is an opportunity to act before the shortage occurs.

Can the spreadsheet import bank transactions automatically?

No. This version is an offline educational workbook. It deliberately requires manual entry, so you control the inputs and are not asked to share private banking credentials.

Sources, calculations and editorial disclosure

Published October 27, 2026. The cash-flow planning principles are based on the educational materials below. All dollar amounts in the workbook, Week 1–3 example, delayed-payment scenario, forecasts and minimum reserve are hypothetical editorial scenarios, not reported financial results or forecasts by the cited organizations. The workbook’s examples should not replace accounting, legal, tax, lending or financial advice.

• FDIC and SBA — Money Smart for Small Business
• FDIC/SBA — Managing Cash Flows: Participant Guide
• SBA — Manage your business
• IRS — Estimated taxes
• SCORE — Simple 36-month cash flow projection

Want to put the method to work? Download the Excel forecast workbook and fill in this Friday’s actual bank balance before adding the next 13 weeks.

Retailers: Pair your cash forecast with our inventory management guide for small retail stores to avoid tying up working capital in slow-moving merchandise.