How to Build a 13-Week Cash Flow Forecast for Your Small Business

A profitable month can still end with an overdrawn account. Customers pay late, payroll and rent don’t wait, and a quarterly tax payment lands in the same week as a big supplier bill. A cash flow forecast shows those collisions weeks in advance, while you still have time to act.

The most practical version for a small business is the 13-week cash flow forecast: a week-by-week projection of cash in and cash out over roughly the next quarter, updated every week. It’s short enough to predict with reasonable accuracy and long enough to spot trouble early. This guide walks through building one, with a hypothetical worked example and the levers to pull when the numbers look tight.

This is general information, not financial, tax or legal advice. Your accountant or bookkeeper can help tailor a forecast to your business.

Key takeaways

• Profit and cash differ: sales you’ve invoiced but not collected can’t pay this week’s bills.
• Use the direct method, placing each receipt and payment in the week cash actually moves.
• Start from your real bank balance, set a minimum cash buffer and flag any week below it.
• Update weekly, compare forecast with actual and keep best, base and worst cases.
• Close gaps early with faster invoicing, deposits, better terms and a credit line arranged in advance.

Why Profit and Cash Aren’t the Same Thing

Your profit and loss statement shows whether you earned more than you spent. Your bank balance shows whether you can pay what’s due this week. The two drift apart for predictable reasons:

• Customers pay on terms. An invoice sent today on net-30 terms may not become cash for a month or more.
• Some large payments aren’t expensed right away, or at all: loan principal, equipment, inventory bought ahead of sales and owner draws.
• Timing is lumpy. Payroll, rent, insurance and taxes hit on specific dates.
• Growth consumes cash. More work often means paying staff and suppliers before customers pay you.

The SBA’s guidance on managing your finances illustrates the gap: under the accrual method, a sale made in January and paid in February is recorded in January, while the cash method records it in February. Whichever method your books use, your forecast should track when cash actually moves.

Uneven cash is common. In the Federal Reserve Banks’ 2025 Report on Employer Firms, based on their 2024 Small Business Credit Survey, 51% of employer firms cited uneven cash flows as a financial challenge.

Direct vs. Indirect Cash Flow Forecasting

Factor	Direct method	Indirect method
Starts from	Expected receipts and payments	Projected net income, adjusted for non-cash items and working capital
Best horizon	Weeks to a few months	Quarters and years
Typical users	Owners managing day-to-day cash	Accountants, lenders, annual planning

For cash flow forecasting for small business, start with the direct method. It uses what you already know (who owes you, when payroll runs, when rent is due) and answers the key short-term question: will there be enough in the bank each week? The indirect method suits longer-range planning with your accountant.

How to Build a 13-Week Cash Flow Forecast

Set up a sheet with Weeks 1 to 13 across the top, each labeled with its start date, and categories down the side.

Step 1: Start With Your Real Opening Balance

Use the combined cleared balance of your operating accounts on the start date. Reconcile first; a forecast built on the wrong starting number is wrong every week after.

Step 2: Forecast Receipts by Source and Timing

List cash coming in, in the week you expect it to arrive:

• Open invoices. Place each invoice in the week that customer typically pays, not the week it’s due. If a client routinely pays two weeks late, forecast it that way.
• Expected new sales. Estimate when you’ll bill and add the customer’s usual payment delay. Be conservative; a CRM pipeline with realistic close dates helps (see our guide to choosing a CRM).
• Card and online payments. Processors pay out on a schedule, usually net of fees, so forecast the deposit amount and date.
• Recurring revenue from retainers or subscriptions, adjusted for expected cancellations.
• Other inflows such as loan proceeds or owner contributions, only once confirmed.

Step 3: List Every Disbursement

Then list cash going out, by the week it leaves the account:

• Payroll, including employer taxes and benefits, on actual pay dates. The IRS explains that employers deposit employment taxes on a monthly or semiweekly schedule, determined before each calendar year.
• Rent and utilities on their due dates.
• Suppliers and contractors, in the week you’ll actually pay.
• Taxes. If you’re in business for yourself, the IRS says you generally need to make estimated tax payments, with the year divided into four payment periods. Add sales tax remittances if you collect it.
• Loan and lease payments, including principal, which doesn’t appear on your P&L.
• Subscriptions, including annual renewals.
• Insurance, owner draws and one-off purchases such as equipment.

To catch forgotten items, scan three to six months of bank and card statements for anything recurring.

Step 4: Calculate the Closing Balance

Each week, opening balance plus receipts minus disbursements equals the closing balance, which becomes next week’s opening balance. Enter the formulas once and let them carry forward.

Step 5: Set a Minimum Cash Buffer

Decide the lowest balance you’re willing to see and highlight any week below it. There’s no universal number. Many owners base it on a few weeks of essential costs, such as payroll, rent and loan payments, and hold more if revenue is seasonal or depends on a few customers.

A Worked Example: A Hypothetical Design Studio

This is a hypothetical example, not a real business. A five-person studio starts with $42,000 and sets a $20,000 buffer. Payroll runs every two weeks ($14,000 with employer costs); rent ($4,500), software ($900) and a loan payment ($1,200) come roughly monthly, plus contractors, an equipment purchase and an estimated tax payment. Each week opens with the previous week’s closing cash.

Week	Cash in	Cash out	Closing cash	Main outflows
1	$9,000	$20,000	$31,000	Payroll, rent
2	$12,000	$3,500	$39,500	Contractors, software
3	$8,000	$15,800	$31,700	Payroll, loan
4	$15,000	$3,100	$43,600	Contractors
5	$6,000	$19,100	$30,500	Payroll, rent
6	$10,000	$8,500	$32,000	Equipment, contractors
7	$7,000	$15,800	$23,200	Payroll, loan
8	$9,000	$2,600	$29,600	Contractors
9	$5,000	$26,100	$8,500	Payroll, rent, tax
10	$22,000	$3,500	$27,000	Contractors, software
11	$11,000	$15,800	$22,200	Payroll, loan
12	$13,000	$3,100	$32,100	Contractors
13	$9,000	$19,100	$22,000	Payroll, rent

What the owner learns, about two months ahead:

• Week 9 falls to $8,500, well below the buffer, as payroll, rent and tax coincide with slow receipts.
• The fix is mostly timing. Week 10’s receipts include a $22,000 project milestone. Getting it paid a week sooner, by invoicing earlier and following up, would lift Week 9 to about $30,500. Delaying the equipment purchase adds margin.
• The trend matters too. Over the quarter, $156,000 goes out and only $136,000 comes in. Is that timing, or a pricing, cost or sales problem?

Update Weekly and Watch for Warning Signs

Pick a fixed weekly slot to keep the forecast current.

The Weekly Routine

1. Enter actuals for last week beside the forecast.
2. Reset the opening balance to the real bank balance.
3. Drop the completed week and add a new Week 13, so you always see a quarter ahead. That’s what makes it a rolling forecast.
4. Update for new invoices, bills, hires and commitments.
5. Check the buffer line and decide on actions.

Forecast vs. Actual Variance

Variance is actual minus forecast. Ignore small differences and look for patterns:

• Receipts consistently late: customers pay slower than assumed, so push timing out and tighten collections.
• Receipts consistently low: sales estimates are optimistic, so include only likely deals.
• Surprise payments: recurring or annual items are missing, so add them and recheck statements.

Warning Signs to Act On

• Any week below your minimum buffer.
• A closing balance trending down across the 13 weeks.
• Receivables growing faster than sales, or one customer dominating expected receipts.
• Delaying supplier payments or tax deposits to cover payroll.
• Using credit cards or a credit line for routine expenses month after month.
• Large variances you can’t explain.

Plan Best, Base and Worst Cases

Your base case is your most realistic forecast. Keep two variations beside it:

• Best case: a big deal closes early or a slow payer catches up. Don’t spend that cash until it arrives.
• Worst case: your biggest customer pays a month late, a contract doesn’t renew or sales fall by a set percentage. Note how low the balance goes, and when.

Copy the base case and change a few key assumptions rather than rebuilding. For each worst-case gap, write down what you’d do and by when: which costs you’d cut, which payments you’d renegotiate and where extra cash would come from.

Levers to Improve Cash Flow

When the forecast shows a gap, these are the main levers of cash flow management.

Bring Cash In Sooner

• Invoice promptly. Every day an invoice waits pushes payment back.
• Set clear payment terms, as short as your market allows, with terms and any late fees on every invoice.
• Take deposits or milestone payments on larger projects.
• Add online payment links to invoices.
• Automate reminders before and after the due date. Our guide to accounting software for small business covers which features to require.
• Call about large overdue invoices instead of relying on emails alone.

Manage Cash Going Out

• Negotiate payables. Ask key suppliers for longer terms, and pay on the due date unless an early-payment discount is worth taking.
• Keep inventory lean; stock on shelves is cash you can’t spend.
• Audit subscriptions for unused tools, extra seats and upcoming annual renewals. Our lean startup tech stack guide helps keep your tool list tight.
• Time discretionary spending for weeks with comfortable balances.

Arrange a Credit Line Before You Need It

A line of credit can bridge short timing gaps like Week 9 above. Apply while your finances look healthy, since lenders will review them. The SBA’s 7(a) loan program lists working capital among eligible uses and includes line-of-credit options. Use credit for timing gaps, not to cover a business that consistently spends more than it earns.

Tools for Cash Flow Forecasting

A Simple Spreadsheet Structure

A spreadsheet is enough for most small businesses. Stack these rows under the week columns: opening balance (linked to last week’s close), receipts by major customer or source, disbursements by category, totals, closing balance and a buffer flag. Add actuals and variance tabs in the same layout.

Accounting Software Forecasting Features

Some accounting platforms build short-term forecasts from invoices, bills and bank data in your books. Xero, for example, describes its analytics tools as including short-term cash flow forecasts, with the horizon varying by plan. They only know what’s been entered, so check that planned hires, tax payments and expected deals are included.

Dedicated Forecasting Tools

Apps such as Float and Fathom connect to accounting software for more detailed forecasting and reporting. They suit businesses running several scenarios or multiple entities. Whatever you choose, the weekly update matters more than the tool.

Frequently Asked Questions

Why use 13 weeks instead of a monthly forecast?

Thirteen weeks is about a quarter, so it captures monthly bills, several payroll runs and quarterly payments such as estimated taxes. Weekly detail shows dips a monthly view hides. Many businesses pair it with a 12-month forecast for longer-range planning.

How accurate does a cash flow forecast need to be?

Accurate enough to make decisions. The first few weeks should be close; later weeks are estimates. Track variance and adjust assumptions weekly.

What’s a good minimum cash buffer?

It depends on how predictable your revenue is, how concentrated your customers are and how quickly you could cut costs. Seasonal or project-based businesses usually need more. Agree on a number with your accountant.

Can my accounting software build the forecast for me?

Partly. Built-in forecasts only see what’s in your books, so add expected sales, planned purchases and unrecorded tax payments yourself.

Next Steps: Build Your First Forecast This Week

Open a spreadsheet, enter today’s bank balance and list every receipt and payment you expect over the next 13 weeks. Set a buffer, flag the weak weeks and book a weekly update. If you see a gap, pull the levers above now, while you still have options.

Browse the Fintech & Finance hub for more money guides, the Tools & Software hub for your wider stack, or everything at GrandPeoples.com. Our editorial policy explains how we research guides, and you can contact us with questions or corrections.