The 13-Week Cash Flow Forecast: How to Build the System That Keeps You Ahead of Every Cash Problem
The businesses that never get surprised by a cash crisis are not the ones with more revenue. They are the ones that can see 90 days ahead.
EveryCentCounts
•
•
12 min read
•
— views
The 13-Week Forecast Explained
This video walks through the logic behind the 13-week cash flow forecast: why 13 weeks specifically, how it differs from an annual budget, and what the weekly update discipline actually looks like in practice for a small business owner.
Video: How to build and use a 13-week cash flow forecast. EveryCentCounts.
The 13-week cash flow forecast is the tool that turnaround advisors build first when they walk into a business in trouble. It is also the tool that well-managed businesses use to make sure they never find themselves in that position. The logic is simple: most cash crises are not sudden. They are visible weeks in advance in the data — if someone is looking at the right data in the right format.
This post builds the 13-week forecast from scratch. Wednesday's cash flow glossary covered the vocabulary. Monday's post on why profitable businesses run out of cash established why the forecast matters. Today is the practical build.
The forecast template referenced in this post is available through the tool below. All figures in the illustrative examples are hypothetical. Nothing here constitutes accounting or financial advice specific to your business.
Why 13 Weeks Specifically
The 13-week horizon is not arbitrary. It reflects the practical limits of cash flow predictability for most small businesses.
Short enough to be accurate
Beyond 90 days, revenue projections for most small businesses become speculative. Customer payment behavior, seasonal shifts, and unexpected expenses make longer-range cash forecasts increasingly unreliable. At 13 weeks, the forecast is grounded in known commitments: invoices already issued, bills already received, payroll already scheduled.
Long enough to act
Most corrective actions available to a business in a cash squeeze — accelerating collections, negotiating a payment extension, drawing on a line of credit, deferring a capital purchase — require two to six weeks of lead time to execute. A 13-week horizon gives you enough runway to see a problem and respond before it becomes a crisis.
Built for weekly updates
The forecast rolls forward by one week each time it is updated. Last week drops off the back; a new week is added to the front. The result is that the business always maintains a consistent 90-day forward view, updated with actual results as each week closes. This rolling discipline is what separates a forecast from a budget.
The Structure: What Goes in Each Row
A 13-week cash flow forecast has a straightforward structure. Each column is a week. Each row is a category of cash movement. The bottom row is the ending cash balance for that week, which becomes the starting balance for the next.
What goes in the inflow rows
- Customer payments on existing invoices (by due date)
- Expected payments from new sales (based on terms)
- Loan or line of credit proceeds
- Owner contributions or equity injections
- Asset sale proceeds
- Grant reimbursements (nonprofits)
- Tax refunds or deposits expected
- Any other known cash receipt
What goes in the outflow rows
- Payroll and payroll taxes (by pay date)
- Rent and lease payments (by due date)
- Supplier and vendor payments
- Loan and line of credit repayments
- Insurance premiums
- Utility bills
- Tax payments (estimated quarterly taxes, sales tax)
- Capital expenditures planned
- Owner distributions
The key discipline is to place each item in the week the cash actually moves, not the week the obligation is incurred. Rent due on the first of the month goes in the week containing the first. A customer invoice due in 30 days goes in the week that falls 30 days from the invoice date, adjusted for your historical knowledge of that customer's actual payment behavior.
An Illustrative 4-Week Snapshot
The following example shows a simplified four-week slice of a 13-week forecast for a Virginia professional services firm with $180,000 in monthly revenue. Week 3 surfaces a cash concern with enough lead time to address it.
| Category | Week 1 May 12 |
Week 2 May 19 |
Week 3 May 26 |
Week 4 Jun 2 |
|---|---|---|---|---|
| CASH INFLOWS | ||||
| AR collections (existing invoices) | $42,000 | $38,000 | $12,000 | $45,000 |
| New sales (est. collection) | $8,000 | $10,000 | $8,000 | $9,000 |
| Total Inflows | $50,000 | $48,000 | $20,000 | $54,000 |
| CASH OUTFLOWS | ||||
| Payroll | $28,000 | — | $28,000 | — |
| Rent & facilities | — | — | — | $8,500 |
| Vendor payments | $6,000 | $4,500 | $6,000 | $4,500 |
| Loan repayment | — | $3,200 | — | $3,200 |
| Insurance / utilities / other | $2,100 | $1,800 | $2,100 | $1,800 |
| Total Outflows | $36,100 | $9,500 | $36,100 | $18,000 |
| Net Cash Movement | +$13,900 | +$38,500 | -$16,100 | +$36,000 |
| Ending Cash Balance | $63,900 | $102,400 | $86,300 | $122,300 |
Starting cash balance: $50,000. All figures illustrative. — indicates no payment in that category for that week.
How to Build Your Forecast: Six Steps
Set up your column structure
Open a spreadsheet. Label column A as your row categories. Label columns B through N as Week 1 through Week 13, with the Monday date of each week as a subheader. Add a column O for the 13-week total. Your starting cash balance goes in the first data row of column B.
Enter your fixed outflows first
These are the easiest to populate because they are predictable: payroll dates and amounts, rent due dates, loan repayment dates, insurance premiums, and any other recurring fixed obligation. Place each in the week the cash actually leaves your account. This gives you the non-negotiable cash floor for each week before you add a single revenue dollar.
Pull your accounts receivable aging report
Export your current AR aging from your accounting software. For each outstanding invoice, determine the week you realistically expect payment: not the invoice due date, but your actual experience with that customer. A customer who always pays in 45 days should be entered 45 days out, regardless of what their net-30 terms say. This is where honest forecasting differs from optimistic forecasting.
Estimate new sales inflows conservatively
For revenue not yet invoiced, use a conservative estimate based on your pipeline visibility. If you have signed contracts, use those amounts and apply realistic collection timing. If you are projecting from historical averages, apply a 10–15% haircut to account for timing variability. The forecast is most useful when inflows are slightly understated and outflows are slightly overstated — surprises should be positive ones.
Add variable outflows
These include vendor payments (check your AP aging for due dates), estimated tax payments, planned capital expenditures, and any known one-time expenses in the period. For variable operating costs without fixed due dates, spread them across the weeks based on your typical payment pattern. When in doubt, place them earlier in the period rather than later.
Calculate net movement and ending balance for each week
Total inflows minus total outflows gives you net cash movement for each week. Add that to the prior week's ending balance to get each week's ending balance. Highlight any week where the ending balance falls below your minimum cash threshold. Those highlighted weeks are your action items — and you now have the lead time to address them.
The Weekly Update Rhythm
A forecast built once and never updated is a budget. The 13-week cash flow forecast derives its value from the weekly update discipline. The routine takes 20 to 30 minutes once established.
Monday morning is the natural update window. The prior week has closed, actual bank transactions are settled, and you have a full week ahead to act on anything the updated forecast surfaces. Building this into a consistent Monday routine is the single most important habit in cash flow management.
Record actuals for the week just closed
Replace the prior week's forecasted figures with actual cash received and paid. Note any variance: did a customer pay later than expected? Did an unexpected expense arise? These variances inform your assumptions for future weeks.
Roll the forecast forward by one week
Delete the week that just closed from the front of the forecast and add a new Week 13 at the back. This maintains the consistent 90-day forward view. Update the new week with known outflows and your best current estimate of inflows.
Review highlighted weeks and assign actions
Any week where the projected ending balance falls below your minimum cash threshold requires a specific action before that week arrives: follow up on a specific overdue invoice, draw on the line of credit, defer a discretionary expense, or accelerate a pending sale. The forecast identifies the problem; the action list is your response.
Update your key metrics
Each week, recalculate your cash runway (current balance divided by average weekly net burn) and your 13-week total net cash position. Tracking these over time tells you whether the business's cash position is improving or deteriorating — independent of any single week's noise.
Virginia-Specific Considerations
Federal payment cycles in Northern Virginia and the broader DMV corridor routinely run 45 to 90 days. For contractors, this means the inflow side of the forecast requires particular care: entered by actual expected receipt date rather than invoice date, with a buffer for agency processing variability. A contractor with $300,000 in outstanding federal invoices and a 60-day payment cycle needs to model that timing explicitly — the money is real but it is not available this week, and the forecast makes that visible.
For Virginia Beach, the Northern Neck, and Shenandoah Valley tourism businesses, the 13-week forecast is most valuable in the transition periods: the ramp into summer and the wind-down into fall. These are the weeks where the gap between high fixed outflows and lower-than-peak inflows is widest. A forecast built in March that runs through May gives a seasonal business the lead time to manage that transition deliberately rather than reactively.
As covered in Tuesday's post on nonprofit cash flow management, the weeks approaching June 30 are the most cash-sensitive of the year for many Virginia nonprofits. A 13-week forecast built now — covering mid-May through mid-August — gives finance teams visibility into reimbursement submission timing, spend-down acceleration needs, and the post-close cash trough that typically follows the end of the grant year.
13-Week Cash Flow Forecast Template
A ready-to-use spreadsheet template with the full 13-week structure pre-built: inflow categories, outflow categories, net movement calculation, ending balance row, and a minimum cash balance threshold highlighter. Enter your numbers and your forecast is live.
Get the Free TemplateAction Steps
The fixed outflows — payroll, rent, loan payments — are the easiest rows to complete and take the least time. Starting there gives you the cash floor for each of the next 13 weeks in under an hour. The inflow side follows naturally once you can see the floor.
Export your current accounts receivable aging from your accounting software. For each invoice, enter the payment in the week you realistically expect it — based on that customer's actual payment history, not their stated terms. This single step is where most of the forecast's value comes from.
Choose a minimum cash balance appropriate for your business — at minimum, two weeks of payroll plus one month of fixed expenses is a reasonable starting point. Use conditional formatting to highlight any week where the ending balance falls below that threshold. Those highlighted cells are your work queue.
A forecast updated once is useful. A forecast updated every week for six months is transformative. The weekly habit is where the value compounds. Enter last week's actuals, roll the forecast forward, review the highlighted weeks, and assign any necessary actions before the work week begins.
Now that you have a forecast that makes the inflow side visible, Saturday's post closes the week with the fastest lever most businesses have for improving it: accounts receivable management. Tightening your collections process is often the quickest way to shift your forecast from concerning to comfortable without cutting a single expense.
References
- Financial Accounting Standards Board (FASB). 2016. ASC 230: Statement of Cash Flows. Norwalk, CT: FASB. https://fasb.org/
- Brigham, Eugene F., and Joel F. Houston. 2022. Fundamentals of Financial Management, 16th ed. Mason, OH: South-Western Cengage Learning.
- American Institute of CPAs (AICPA). 2024. Financial Reporting Framework for Small- and Medium-Sized Entities. Durham, NC: AICPA. https://www.aicpa-cima.com/
- Association for Financial Professionals (AFP). 2023. AFP Liquidity Survey. Bethesda, MD: AFP. https://www.afponline.org/
- Small Business Administration (SBA). 2024. Cash Flow Management for Small Businesses. Washington, DC: SBA. https://www.sba.gov/
EveryCentCounts
Financial Services & Digital Presence Management — Ladysmith, VA
EveryCentCounts builds cash flow management systems for Virginia small businesses and nonprofits. We help owners move from reacting to cash problems to seeing them weeks in advance and acting before they arrive.
Want Help Building Your First 13-Week Forecast?
EveryCentCounts can build the forecast with you, set up the weekly update process, and help you interpret what it is telling you about your business. One session is enough to get it running.
Book a Free Consultation