Today's cash balance may not cover the payments scheduled over the next six weeks. A 13-week cash flow forecast makes that timing gap visible: a $50,000 project payment that shifts from week 2 to week 5 exposes a cash gap while the commitments due in between stay put. Seeing the gap early gives you time to accelerate collection or postpone a discretionary commitment ahead of the projected shortfall.
A 13-week cash flow forecast maps expected cash receipts, payments, and closing balances by week over the next quarter. Building one starts with current balances, expected receipts, scheduled payments, and a weekly closing-balance formula. Weekly placement also reveals the first projected shortfall before it arrives.
Why a 13-week cash flow forecast improves short-term visibility
Weekly cash flow forecasting separates timing events that monthly totals compress. The Federal Reserve's 2024 Small Business Credit Survey documents that pressure. It reached more than 7,600 small employer firms, and more than half cited paying operating expenses (56%) or uneven cash flows (51%) as challenges. At the start of a quarter, a weekly forecast shows whether a quarterly tax payment or annual insurance premium clears before a large invoice arrives. It also places a software renewal in its exact week.
A 13-week window gives you time to act while keeping scheduled invoices and debits useful. Use signed contracts and open invoices to fill much of the next quarter, then add scheduled debits, though collection dates still require judgment.
How to build your 13-week cash flow forecast step by step
Four building blocks turn raw account data into a forecast you can act on: the inputs you collect, how you place inflows, the formula that carries balances forward, and the threshold that flags weeks needing attention. Work through them in order, since each step depends on the accuracy of the one before it.
Gather the forecast inputs
Start with the balances available today. Then organize expected receipts and scheduled payments across the quarter, and calculate the balance carried into the following week. The direct method tracks cash in and cash out rather than accruals, which makes the forecast usable for weekly decisions.
At your first forecast session, gather expected inflows and outflows by week, such as open invoices with different payment dates or a scheduled tax debit. You can pull the information from your bank account and QuickBooks Online in one sitting:
Current available balances for every account as of the forecast date; adjust them for pending or uncleared transactions and check them against your latest reconciliation
Open invoices, with each customer's actual payment history alongside
Recurring outflows and their real debit dates, including rent, recurring subscriptions, insurance, and loan payments
Irregular but known outflows, such as quarterly estimated taxes and annual renewals
Your own pay, as a real line item rather than whatever is left over
Check each transaction date carefully. An accurate amount assigned to the wrong week will distort the closing balance.
Place expected inflows by week
Customer payment dates create the most uncertainty because clients pay on their own schedule rather than the invoice's, so pull the accounts receivable aging report, which groups unpaid invoices by how long they have been outstanding, from QuickBooks Online.
Base the forecast date for each invoice on that customer's payment history. A client who reliably pays 45 days after invoicing belongs in the week 45 days out, whatever the due date says. For a proposal likely to close, enter a discounted amount or mark it as an estimate. Mark estimates clearly so you can see how much of any given week depends on uncertain income.
Set up the weekly balance formula
In a spreadsheet, weeks run across the columns, inflow and outflow line items run down the rows, and a closing-balance row sits at the bottom.
Build the spreadsheet in five steps:
Enter the week-1 opening balance.
Place each expected inflow in the week the cash will arrive.
Place each outflow in the week it will clear. Don't smooth lumpy costs into monthly averages; a quarterly tax payment belongs in one week, at full size.
Calculate the week's closing balance: opening plus in, minus out.
Extend those weekly columns through week 13.
For example, say week 1 opens at $38,000, and you expect $22,000 in from two invoices. Another $27,500 will go out for rent, subscriptions, a tax payment, and your own pay. Week 1 closes at $32,500, and week 2 opens there.
Spreadsheet blueprint
Lay out the sheet with the following rows. Columns run from Week 1 through Week 13, with a header row for the Monday date of each week so the forecast rolls forward cleanly.
Row | What goes here |
|---|---|
Opening balance | Week-1 opening balance in column B; every other week pulls from the prior week's closing balance automatically |
Cash inflows | One row per source (customer payments, deposits, refunds, other income), placed in the week the cash arrives |
Total inflows | Auto-sums each week's inflow rows |
Cash outflows | One row per category (payroll, rent, subscriptions, loan payments, taxes, owner's pay, other), placed in the week each debit clears |
Total outflows | Auto-sums each week's outflow rows |
Closing balance | Opening + total inflows − total outflows |
Minimum threshold | Your minimum comfortable balance; conditional formatting flags any week that dips below it |
Notes | Reason codes for timing changes, estimate confidence, and variance review comments |
Set the formulas so the sheet can roll forward during each weekly review.
Combine account balances and set a cash threshold
If your cash sits across multiple accounts, add every available balance to get the week-1 opening balance. Transfers between your own accounts net to zero in a consolidated forecast; only money that enters or leaves the business counts. If separate logins make that total hard to read, the Relay banking platform keeps multiple business checking and savings accounts in one place with no monthly maintenance fees on the Starter plan.
Set a minimum comfortable balance before you use the forecast to make decisions. Base it on the payments you need to cover before the next dependable deposits arrive. Include your own pay. Then add every scheduled debit and known tax obligation.
Enter that threshold as a separate row beneath the weekly closing balances. The threshold row immediately identifies the first week requiring attention, even if its balance remains above zero, without treating every normal change as a crisis.
How should you update a rolling cash flow forecast?
A forecast stays useful when actual transactions replace estimates and future assumptions change with new information.
At Friday's close or on Monday morning, update the forecast and reserve a short calendar block for the review.
The weekly routine has four steps:
Replace last week's estimates with actuals from your bank activity.
Note where the actuals diverged from what you forecast.
Adjust the assumptions in future weeks to match what you learned.
Drop the completed week, shift the remaining columns forward, and add a new Week 13 at the end, so the forecast always looks 13 weeks ahead.
Most of the review time should go to steps 2 and 3, the judgment steps. Settled bank transactions can move from Relay to QuickBooks Online automatically, so you don't need to enter each one by hand during the weekly update.
Aim for tighter estimates in weeks 1 through 4, while marking any receipts or costs that remain uncertain. For weeks 5 through 13, keep a brief note beside estimates tied to a proposal or an uncertain payment date. Add a separate note if the amount may change. Those notes show which assumptions need attention first at the next review.
If you miss several reviews, old dates and settled items can obscure the current exposure. When that happens (it will, some quarter), don't rebuild from scratch; restart with your latest actuals and roll forward from there.
Common forecasting mistakes to avoid
A few recurring errors quietly distort weekly forecasts. Check for these during each weekly review:
Invoices whose forecast dates no longer match each client's latest payment pattern
Quarterly obligations split across multiple weeks instead of entered as one full debit in the week they clear
Skipping irregular expenses (annual renewals, equipment repairs) until they hit the bank
Using today's bank balance in place of projected weekly closing balances
Correct these items before rolling the forecast forward so the next review starts from current dates and balances.
How should you revise the forecast when cash timing changes?
When a payment slips or a cost lands early, move that line item to the week it will now happen. The change then flows through the closing-balance row. Revising timing is different from revising amounts: a delayed payment moves across columns while the quarter's total stays the same; a lost project comes out of the forecast entirely.
Record the timing change beside each moved item by noting both weeks. Add the reason in the same note. During the review, use that history to tell whether timing or the amount changed. Then decide whether to use the original assumption for future transactions.
How can forecast variances guide operating decisions?
When Friday's bank balance differs from your forecast, compare each line item to find the wrong assumption or behavior. A total that lands within a few hundred dollars can hide an invoice that came in early and an expense category overrun, two errors that happened to cancel.
If the same variance keeps recurring, update the related assumption. The client who pays two weeks late every time gets a forecast two weeks late from now on. The category that runs 15% over its estimate month after month gets a 15% higher baseline.
Review surplus weeks with the same care as tight ones. The forecast shows which weeks can fund cash reserves or absorb a large purchase. It also shows when a quarterly estimated payment can clear without strain. Use that timing to replace "we had a good month" with a specific allocation decision. Profit First and similar envelope methods divide incoming cash among accounts for taxes, your pay, profit, and operating costs. For example, the forecast can show whether next Friday's deposit supports the planned tax transfer.
Build your 13-week forecast this Friday
Relay keeps multiple business checking and savings accounts visible in one place, which makes the opening balance easier to confirm before each weekly review. Save a one-page forecast with the owner, review date, and version to keep a record of timing and estimate changes. The saved copies also reveal recurring manual work you may be able to remove.
When forecast upkeep starts taking time away from timing decisions, opening a Relay account gives you percentage-based transfer rules on all plans, so planned allocations can happen without manual transfers. Starter has no monthly maintenance fees. You can spend the weekly review on the assumptions that changed.
Frequently asked questions
Why 13 weeks instead of a 12-month forecast?
Thirteen weeks gives you a near-term operating view without trying to make weekly estimates reliable for a full year. Use a 12-month forecast for planning and goals beyond the quarter.
How often should I update a 13-week cash flow forecast?
Use the same review day each week. That routine keeps the forecast current as completed weeks drop off and new weeks are added.
Can I build a 13-week cash flow forecast in a spreadsheet, or do I need software?
A spreadsheet is enough while you can complete the review reliably. Consider software when multiple accounts or entities make balance aggregation difficult, or when manual transaction entry makes the process hard to finish. Choose a tool that keeps the weekly closing balance and threshold visible while leaving enough time for the variance review.
How accurate does a 13-week forecast need to be?
The forecast is accurate enough when it shows whether you need to accelerate collection or postpone a discretionary payment. Expect less certainty in later weeks, and revise the assumption behind each variance.
