Short answer: A 13-week cash flow forecast is a week-by-week table of the cash you expect to receive (inflows) and pay out (outflows) over the next quarter. Start with today's bank balance, add each week's expected inflows, subtract expected outflows and carry the ending balance into the next week. Any week where the ending balance drops below your minimum cash buffer is an early warning. Update it every week, replacing forecasts with actual figures, so you can act weeks before a shortfall instead of days.
This guide is general education by the Pearset Editorial Team. All figures in the examples are illustrative, not data from a real business. For advice on your own accounts, speak with an accountant or a free SBA-affiliated business counselor.
What a cash flow forecast is, and why 13 weeks
A cash flow forecast projects the actual money moving in and out of your bank account over a period. It is different from a profit and loss statement. A P&L records revenue when you earn it and expenses when you incur them; a cash forecast records money only when it actually lands or leaves. A business can be profitable on paper and still run out of cash if customers pay late or a big bill lands at the wrong time. Our guide on how to read a profit and loss statement explains the other side.
Why 13 weeks? Thirteen weeks is one quarter. It is long enough to see payroll cycles, rent, quarterly tax payments and seasonal swings, and short enough that you can estimate each week with reasonable accuracy. Weekly detail also catches problems that a monthly view hides, such as two payrolls and rent landing in the same week.
What you need before you start
- Your current bank balance across all business accounts (not including credit lines).
- Accounts receivable: unpaid customer invoices and when each customer usually pays.
- Accounts payable: unpaid bills and their due dates.
- Recurring costs: payroll dates, rent, loan payments, insurance, software subscriptions.
- Known one-off items: estimated tax payments, equipment purchases, annual renewals.
- Three to six months of bank statements to see typical patterns.
A spreadsheet is enough. Put weeks across the top (Week 1 to Week 13) and categories down the side.
How to build the forecast, step by step
Step 1: Enter the opening cash balance
Week 1's opening balance is the cash in your business accounts today. Every later week's opening balance equals the previous week's closing balance.
Step 2: List expected cash inflows
Inflows are cash you expect to receive in each week:
- Collections from existing invoices, placed in the week each customer usually pays, not the invoice due date. If a client pays 45 days after invoicing, forecast it at 45 days.
- New sales you expect to collect within the 13 weeks, using conservative estimates based on recent weeks.
- Card and online sales, timed to when the processor actually deposits them.
- Other cash, such as a loan disbursement or owner investment, only if it is confirmed.
Step 3: List expected cash outflows
Outflows are cash leaving the account each week: payroll and payroll taxes, rent, supplier payments, loan payments, insurance, utilities, subscriptions, marketing, owner draws and estimated taxes. Place each one in the exact week it will leave the account.
Step 4: Calculate net cash flow and closing balance
For each week: net cash flow = total inflows − total outflows, and closing balance = opening balance + net cash flow.
Step 5: Set a minimum cash buffer
Decide the lowest balance you are comfortable holding, for example two weeks of fixed costs or one full payroll. Add a row that flags any week where the closing balance falls below that line.
A worked 13-week example
Here is a simplified forecast for an illustrative service business with $18,000 in the bank, payroll every two weeks of $9,000, rent of $3,500 at the start of each month, and customers who usually pay within 30 to 45 days. For space, the table shows weeks 1 to 6 and a summary of weeks 7 to 13.
| Line | Wk 1 | Wk 2 | Wk 3 | Wk 4 | Wk 5 | Wk 6 |
|---|---|---|---|---|---|---|
| Opening balance | $18,000 | $12,300 | $14,600 | $7,400 | $10,700 | $2,200 |
| Customer collections | $4,800 | $6,500 | $3,900 | $7,200 | $4,100 | $8,600 |
| Card and online sales | $1,200 | $1,100 | $1,300 | $1,200 | $1,000 | $1,400 |
| Total inflows | $6,000 | $7,600 | $5,200 | $8,400 | $5,100 | $10,000 |
| Payroll and payroll taxes | $9,000 | $0 | $9,000 | $0 | $9,000 | $0 |
| Rent | $0 | $0 | $0 | $0 | $3,500 | $0 |
| Suppliers | $1,500 | $4,200 | $2,100 | $3,800 | $1,000 | $2,600 |
| Loan payment, software, insurance | $1,200 | $1,100 | $1,300 | $1,300 | $100 | $400 |
| Total outflows | $11,700 | $5,300 | $12,400 | $5,100 | $13,600 | $3,000 |
| Net cash flow | −$5,700 | +$2,300 | −$7,200 | +$3,300 | −$8,500 | +$7,000 |
| Closing balance | $12,300 | $14,600 | $7,400 | $10,700 | $2,200 | $9,200 |
| Below $9,000 buffer? | No | No | Yes | No | Yes | No |
What the example shows: the business is not losing money overall, but weeks 3 and 5 dip below the $9,000 buffer because payroll, rent and a slow week of collections land together. Week 5 is especially tight at $2,200. Seeing this five weeks ahead gives the owner time to act. Weeks 7 to 13 would follow the same pattern, with a quarterly estimated tax payment added in the week it is due.
Warning signs to watch in your forecast
| Warning sign | What it usually means | What to do |
|---|---|---|
| Closing balance below your buffer in any week | Timing gap between bills and collections | Move payment dates, chase invoices, arrange a backup credit line early |
| Several weeks of negative net cash flow in a row | Costs are running ahead of sales | Review pricing and fixed costs; pause discretionary spending |
| Collections lagging forecast week after week | Customers are paying slower | Shorten terms, invoice immediately, offer card or instant payment |
| Growing reliance on credit cards or credit lines | Borrowing to cover operations | Find the root cause; borrowing costs rise when rates go up |
| One customer is a large share of inflows | Concentration risk | Model the forecast without that customer and diversify |
| Forecast misses by more than 10% to 15% repeatedly | Assumptions are off | Rebuild estimates from actual bank data |
What to do when the forecast shows a shortfall
Speed up inflows:
- Send invoices the same day work is done, with clear due dates and payment links.
- Follow up on overdue invoices politely but promptly; a short call often works better than another email.
- Offer a small early-payment discount if your margin allows it, or ask for deposits on large jobs.
Slow down outflows:
- Ask key suppliers for longer payment terms; our guide on negotiating with suppliers covers how.
- Delay discretionary purchases until after the tight weeks.
- Cancel unused subscriptions and services.
Plan financing before you need it: lenders are more willing to help a business that sees a gap coming than one already in trouble. Remember that variable-rate credit gets more expensive when interest rates rise, a trend small business owners reported in the NFIB October 2026 survey.
Keep it alive: a 20-minute weekly routine
- Every Monday, replace last week's forecast with the actual figures from your bank account.
- Roll the forecast forward by adding a new week 13.
- Update collections based on which invoices were actually paid.
- Note any variance over 10% and why it happened.
- Check the buffer row and decide on any action this week.
Over time, comparing forecast with actual figures is what makes the forecast accurate. Pair it with a one-page business plan so short-term cash and long-term goals stay connected. If you run a business on the side, keeping separate accounts makes all of this easier; see how to separate business and personal finances.
Cash flow forecasting for income-producing assets
The same method applies to any asset that earns income and has costs, such as a truck, a piece of equipment or a kiosk. Revenue arrives on its own schedule while fuel, maintenance, insurance and loan payments go out on theirs. Operators who forecast weekly can plan for repairs and slow weeks instead of being surprised by them. If you own fractional shares of such assets through Pearset Assets, the income you receive depends on that operating cash flow, which is why payouts can vary from month to month. You can follow asset activity on Pearset Tracking.
Frequently asked questions
What is a 13-week cash flow forecast?
It is a week-by-week projection of the cash a business expects to receive and pay out over the next 13 weeks, or one quarter. It shows the expected bank balance at the end of each week so you can spot shortfalls early.
What is the difference between a cash flow forecast and a profit and loss statement?
A profit and loss statement records revenue when earned and expenses when incurred. A cash flow forecast records money only when it actually enters or leaves your bank account, so it shows timing gaps that a P&L can hide.
How often should I update a cash flow forecast?
Weekly. Replace last week's forecast with actual bank figures, add a new week at the end and review any week that falls below your minimum cash buffer.
How much cash buffer should a small business keep?
There is no single rule. Many owners aim for at least one full payroll or two to four weeks of fixed costs, and more if sales are seasonal or customers pay slowly.
What are the warning signs in a cash flow forecast?
Watch for weeks below your cash buffer, several weeks of negative net cash flow, customer payments arriving later than forecast, growing use of credit to cover costs and heavy reliance on one customer.
What should I do if my forecast shows a cash shortfall?
Act early: invoice and chase payments faster, ask for deposits, ask suppliers for longer terms, delay discretionary spending and arrange financing before the tight week arrives.
Sources
Links located on November 14, 2026. The worked example is an illustration by the Pearset Editorial Team, not data from a real business.
- U.S. Small Business Administration: Manage your finances (link located November 14, 2026)
- SCORE: Finance and accounting resources for small businesses (link located November 14, 2026)