Forecasting template
Small business cash flow forecast template (13 weeks)
A small business cash flow forecast lists the cash you expect in and out each week, so you can see a shortfall weeks before it reaches your bank account.
Last updated: November 2026
How do I forecast cash flow for my small business?
Start with today's bank balance, list the cash you expect to collect each week, list every payment due each week, and roll the ending balance forward for 13 weeks. Update it every Monday with actual numbers. This 1West template and worksheet below do the structure for you, so you only add your figures.
Definition
Why a 13-week forecast works for small businesses
A cash flow forecast is not a budget. A budget says what you plan to spend over a year. A forecast says what will actually hit your bank account, week by week, based on when customers really pay and when bills are really due.
Thirteen weeks equals one quarter. It is long enough to show a payroll week that lands before a big customer payment, a quarterly tax bill, or a seasonal slowdown. It is short enough that your estimates stay grounded in invoices you have already sent and bills you already know about.
The most useful habit is the weekly update. Replace last week's estimates with actual numbers, then add a new week thirteen. Over time you learn which customers pay late and which costs you underestimate, and the forecast gets sharper.
This page is part of the 1West guide to how to improve small business cash flow, which walks through every fix in order.
What the template includes
- Opening bank balance for each week
- Cash in: customer payments, deposits, other receipts
- Cash out: payroll, rent, inventory, suppliers, loan payments, insurance, taxes, owner draws
- Net cash flow and ending balance
- A minimum cushion line and a gap below cushion line
Opens in Excel, Google Sheets, or Numbers. Free, no sign-up.
Procedure
How to build your forecast in six steps
Step 1: Start with your opening balance
Use the actual balance in your business checking account today, not your accounting software balance, which may include payments that have not cleared.Step 2: List cash in by the week it will arrive
Place each open invoice in the week the customer usually pays, not the week it is due. If a customer typically pays two weeks late, forecast it two weeks late.Step 3: List every cash out by due date
Payroll dates, rent, loan payments, supplier bills, insurance, software, and taxes. Quarterly and annual bills are the ones owners most often forget.Step 4: Roll the balance forward
Ending balance equals opening balance plus cash in minus cash out. That ending balance becomes next week’s opening balance.Step 5: Mark your cushion
Decide the lowest balance you are comfortable holding. Any week that dips below it is a gap to plan for now.Step 6: Act on the gaps
Move collections earlier, shift discretionary spending, or ask suppliers for terms. If a gap remains, compare short-term and longer-term financing.
Calculator
Estimate your cash gap
Not ready for the full template? Enter four figures to see your monthly net cash flow, your projected balance in three months, and how far it could fall below your cushion.
Your estimate appears here
Enter all four figures and select Estimate my cash gap. The worksheet projects your balance three months (about 13 weeks) ahead and shows how far it could dip below the cushion you want to keep.
Reading the result
What should I do if my forecast shows a gap?
| What the forecast shows | What it usually means | First move |
|---|---|---|
| No week below cushion | Cash is healthy at current figures | Keep updating weekly; build the reserve |
| One or two weeks dip, totals balance | A timing gap | Pull collections forward, push flexible spending back |
| Recurring seasonal dips | A predictable timing gap | Line up a line of credit before the slow season |
| Steady decline every month | A profit gap | Fix pricing, costs, or volume before borrowing |
Related guides
Keep going
- Cash flow statement for small businessA sample cash flow statement, the three sections, and the formula.
- Fix late customer paymentsA collections routine that speeds up receivables, plus invoice financing basics.
- Short-term vs long-term financingHow to match the financing term to the cash need, with a side-by-side table.
FAQ
Common questions
How do I forecast cash flow for my small business?
Start with your opening bank balance, list expected cash in by week, list expected cash out by week, and calculate each week’s ending balance. A 13-week view covers one quarter and catches gaps early. Update it every week with actual numbers. The cash flow forecast page on this site includes a free template and a worksheet that estimates your cash gap.
See this answer in the full FAQWhat are the three sections of a cash flow statement?
A cash flow statement has three sections: operating, investing, and financing activities. Operating covers day-to-day cash from sales and spending on payroll, rent, and supplies. Investing covers buying or selling equipment and property. Financing covers loan proceeds, loan repayments, and owner contributions or draws. Together they explain exactly why your bank balance changed over the period.
See this answer in the full FAQHow much cash flow should a small business have?
There is no single required number, but a common planning rule is to keep enough cash to cover three to six months of operating expenses. Many businesses fall short: 39% of small businesses say they lack enough cash on hand to cover one month of operating expenses in an emergency, according to Kaplan Collection Agency’s compilation of small business cash flow statistics.
See this answer in the full FAQHow do seasonal businesses manage cash flow?
Seasonal businesses manage cash flow by saving during peak months, forecasting the slow season in advance, and lining up flexible financing before they need it. A business line of credit is often a good fit because you can draw during slow months and repay when revenue returns, typically paying interest only on the amount you actually use.
See this answer in the full FAQHow do I build a cash reserve?
Set a target, such as one month of operating expenses to start, then move a fixed percentage of every deposit into a separate account and treat the transfer like a bill. Build the reserve in strong months so it is there in slow ones. Kaplan Collection Agency’s statistics note that only 31% of small businesses actively optimize cash flow rather than reacting week to week.
See this answer in the full FAQCan ChatGPT make a cash flow statement?
An AI assistant can lay out a cash flow statement format and explain each line, but it cannot know your real numbers unless you supply them, and it can make arithmetic or classification mistakes. Use it to draft a template or check your understanding, then build the statement from your bank records and accounting software, and have a bookkeeper or accountant review it.
See this answer in the full FAQYour forecast still shows a gap? Compare options with 1West.
One application through ABLE, 1West's Automated Business Lending Engine, available 24/7. 1West generally looks for six months in business, four months of business bank statements, $20,000+ monthly revenue, and a 600+ FICO score. Eligibility and final terms depend on the product and lender.