.png)
The 13-Week Cash Flow Forecast: How to Stop Being Surprised by a Tight Month
A profitable business can still run short of cash.
You may have signed contracts, unpaid invoices, and a healthy profit and loss statement, but if customer payments arrive after payroll, rent, loan payments, or taxes are due, the timing can create a serious problem.
That is why a 13-week cash flow forecast is one of the most useful planning tools for a small business. It helps you see when cash is expected to come in, when it will leave, and whether your balance may fall below the amount you need to operate comfortably.
Most importantly, it gives you time to make decisions before a tight month becomes an emergency.
What Is a 13-Week Cash Flow Forecast?
A 13-week cash flow forecast is a rolling schedule that estimates your business’s cash position for the next 13 weeks.
It focuses on actual cash movement, not just income and expenses recorded on an accrual-basis profit and loss statement.
The basic formula is:
Opening cash balance + cash inflows − cash outflows = ending cash balance
Each week’s ending balance becomes the next week’s opening balance.
A simple forecast might include:
Category | Week 1 | Week 2 | Week 3 |
Opening cash | $20,000 | $18,500 | $21,000 |
Customer collections | $8,000 | $12,000 | $6,000 |
Payroll | ($5,000) | - | ($5,000) |
Vendor payments | ($3,500) | ($4,000) | ($2,000) |
Ending cash | $19,500 | $26,500 | $20,000 |
The forecast does not need to be complicated. It needs to be realistic, updated consistently, and detailed enough to show when cash may become tight.
Why 13 Weeks Is the Sweet Spot
Why not forecast just 30 days? Why not create a 12-month projection?
Both can be useful, but 13 weeks is particularly practical for short-term cash management.
Thirteen weeks is:
Long enough to see around corners: You can identify upcoming payroll cycles, quarterly tax payments, annual renewals, large vendor bills, and seasonal slowdowns.
Short enough to remain reasonably accurate: The further into the future you forecast, the more assumptions you have to make. A 13-week window keeps most of your estimates within a manageable range.
Easy to review weekly: You can maintain a rolling schedule without spending hours rebuilding an annual budget.
Useful for immediate decisions: It can help you determine whether you can afford a purchase, hire, owner draw, or marketing investment.
A 13-week forecast is not intended to replace your annual budget or long-term business plan. Instead, it gives you a close-up view of the cash decisions directly in front of you.
Step 1: Start With Your Current Bank Balance
Begin with the actual available cash in your business bank accounts.
Ideally, use a balance from accounts that have been recently reconciled in QuickBooks Online. If your books are not current, the forecast may begin with an incorrect number, and every future week will be affected.
Include:
Operating checking accounts
Business savings that are available for operations
Cash reserves you expect to use
Be careful with:
Restricted funds
Sales tax or payroll tax amounts being held for remittance
Security deposits
Funds reserved for a specific purpose
Accounts that are not actually available to the business
If you have multiple accounts, decide whether your forecast will show them separately or combine them into one operating cash figure. What matters most is consistency.
Step 2: Estimate Weekly Cash Coming In
Next, list the cash you reasonably expect to receive during each of the next 13 weeks.
Potential inflows include:
Customer payments on outstanding invoices
Deposits from current sales
Recurring subscription or retainer revenue
Credit card or payment processor deposits
Loan proceeds
Owner contributions
Tax refunds or other expected receipts
QuickBooks Online can provide useful starting information. Review your Accounts Receivable Aging Detail and open invoice reports to identify unpaid invoices, amounts due, and customer payment history.
Do not automatically place an invoice in the week of its due date. Instead, estimate when the money is likely to reach your bank account.
For example:
A customer who consistently pays on the due date may belong in the expected collection week.
A customer who usually pays 15 days late should be moved later.
An invoice under dispute may need to be excluded from the expected view until the issue is resolved.
A deposit-based business may need to forecast payments according to booking dates rather than invoice dates.
It is better to forecast a conservative collection than to count money that may not arrive in time.
Step 3: Estimate Weekly Cash Going Out
Now list every significant payment expected to leave the business.
Common outflows include:
Payroll and payroll taxes
Rent or lease payments
Vendor bills
Inventory purchases
Loan and credit line payments
Insurance
Software subscriptions
Utilities
Estimated tax payments
Sales tax or payroll tax remittances
Owner draws or distributions
Planned equipment purchases
Professional fees
In QuickBooks Online, review your Accounts Payable Aging Detail, unpaid bills, and vendor payment schedules. Then place each payment in the week it is expected to clear your bank account, not necessarily the week the bill was entered.
Also check outside QuickBooks Online:
Your payroll provider’s payment calendar
Loan statements
Insurance renewal schedules
Tax payment reminders
Credit card autopay dates
Vendor agreements
Upcoming one-time purchases
Do not spread a large, irregular payment across several weeks just to make the forecast look smoother. If a $6,000 quarterly tax payment will leave your account in Week 8, show the full $6,000 in Week 8.
Accurate timing is the point of the forecast.
How to Handle Irregular Income
Some businesses have predictable weekly or monthly revenue. Others do not.
Contractors, consultants, seasonal businesses, online sellers, and project-based companies may have income that arrives in large, uneven amounts.
For irregular income:
List confirmed payments separately from possible payments.
Use signed contracts and scheduled deposits as your strongest assumptions.
Review the customer’s actual payment history.
Avoid including proposals, verbal commitments, or hoped-for sales as guaranteed cash.
Consider whether a project payment depends on a milestone, approval, shipment, or completed work.
Add a separate “possible inflows” section instead of mixing uncertain income into your expected total.
This allows you to see two different realities: the cash you can reasonably count on and the cash that may arrive if everything goes well.
Build an Expected View and a Worst-Case View
A single forecast can create false confidence. Consider preparing at least two versions.
Expected view
This uses your best realistic assumptions:
Customers pay according to their normal patterns.
Recurring revenue continues.
Scheduled expenses occur as expected.
Known bills are paid on their normal dates.
Worst-case view
This asks what happens if conditions are less favorable:
Your largest customer pays two or four weeks late.
Sales are lower than expected.
A major repair or purchase occurs.
A project is delayed.
A vendor requires payment sooner than planned.
An owner draw or distribution is postponed.
You do not need to assume that every possible problem happens at once. Start with the risks most relevant to your business.
If the worst-case view falls below your minimum cash floor, that does not automatically mean your business is failing. It means you have identified a decision that needs attention.
Set a minimum cash floor based on your operating needs. For some businesses, that may be two to four weeks of essential expenses. Others may need more because of seasonality, payroll size, or unpredictable revenue.
What to Do When the Forecast Shows a Shortfall
A projected shortfall is valuable information. It gives you options while there is still time to use them.
Possible actions include:
Chase receivables earlier
Contact customers before invoices become overdue. Send reminders, clarify payment details, and ask whether anything is holding up approval. For larger invoices, confirm the expected payment date directly.
Delay discretionary spending
Separate essential payments from expenses that can move. A new piece of equipment, optional software upgrade, or non-urgent marketing project may be better scheduled after the tight period.
Talk with vendors
Ask whether a vendor can extend payment terms, split a payment, or accept a revised schedule. Conversations are usually easier before a payment is missed.
Adjust owner draws
If your business structure and personal situation allow, consider whether an owner draw or distribution can be reduced or delayed. Make sure you understand the tax and legal implications before changing compensation arrangements.
Line up credit early
If financing may be necessary, begin the conversation before the account is nearly empty. A lender or credit provider may need financial statements, tax returns, bank records, and a forecast. Preparing while your business is stable gives you more choices than applying during a crisis.
Forecasting a shortfall early is what turns a crisis into a decision.
Create a Short Weekly Review Rhythm
A 13-week forecast only works if you use it regularly.
Set aside 20 to 30 minutes each week, often on Monday, to:
Update the completed week with actual bank activity.
Compare actual inflows and outflows with your forecast.
Investigate significant differences.
Move delayed customer payments to a more realistic week.
Add new bills, commitments, and expected receipts.
Drop the completed week.
Add a new Week 13 at the end.
Pay attention to the reason for each variance:
Timing variance: The money arrived or left, but in a different week.
Amount variance: The actual payment was higher or lower than expected.
Assumption variance: The expected sale, collection, or expense did not happen.
Over time, these comparisons make your forecast more accurate. You will learn which customers pay late, which expenses are easy to overlook, and how much cash buffer your business truly needs.
Pair Cash Flow Forecasting With Tax Planning
Cash flow and taxes are closely connected.
A forecast can help you see when estimated tax payments, payroll tax deposits, sales tax remittances, or year-end purchases may affect your available cash. Tax planning can then help you evaluate potential deductions, retirement contributions, equipment purchases, and estimated payments before deadlines arrive.
However, tax savings do not automatically make an expense affordable. A deduction may reduce taxable income, but the business still has to pay the cash first. Your cash flow forecast helps you consider both sides of the decision.
For more guidance, review Your Business Accountant’s tax planning and filing services.
Need Help Building Your Forecast?
A reliable forecast depends on reliable books. If your bank accounts are not reconciled, invoices are missing, bills are entered late, or transactions remain uncategorized, your forecast will be built on incomplete information.
Your Business Accountant helps small business owners understand and manage their numbers through:
Cash flow forecasting and financial reporting
Financial coaching and decision support
You can also review our guide on getting an accurate cash flow report in QuickBooks Online.
You do not need to predict the future perfectly. You need enough visibility to recognize what may be coming and enough time to respond.
Start with your current bank balance, map your expected cash in and cash out, and update the forecast every week. With that habit in place, a tight month becomes something you can prepare for, not something that surprises you.
Comments