The next payroll run may be covered. The more useful question is what happens when the following payroll lands in the same week as a large vendor payment, an insurance renewal, and a slower-than-expected customer collection.
A 13-week cash flow forecast helps you see those overlaps early enough to do something about them. It puts expected receipts and payments on a weekly schedule, showing how much cash should remain as the business moves through the next three months.
That visibility is particularly useful at the beginning of the year. New spending plans start taking effect while prior-year bills, seasonal changes, and upcoming tax obligations still need attention. An annual budget provides direction, but it may not reveal the specific week when several commitments will put pressure on your bank balance.
The purpose of forecasting is to give yourself time to make a considered decision before a payment becomes urgent.
What Is a 13-Week Cash Flow Forecast?
A 13-week cash flow forecast estimates the money entering and leaving a business during each of the next 13 weeks, roughly one quarter. It typically uses the direct method: expected cash receipts less expected cash payments.
Each week follows a straightforward calculation:
Beginning cash balance + cash inflows − cash outflows = ending cash balance
The ending balance then becomes the following week’s beginning balance. This weekly structure makes it easier to see payment timing that a monthly total can obscure.
For example, a customer payment arriving on the last Friday of the month cannot cover payroll that must be funded the preceding Tuesday. A monthly forecast might show sufficient cash overall while missing that gap.
Thirteen weeks offers a practical planning window. Near-term estimates can be grounded in invoices, payroll schedules, and known commitments, while later weeks provide time to adjust purchases, pursue collections, or discuss financing.
How to Build a 13-Week Cash Flow Model
Start with current bank information, accounts receivable and payable reports, payroll schedules, debt payments, and known spending commitments. Your bookkeeping should be current enough to support the forecast.
A spreadsheet can work well. The harder part is deciding when money will actually move.
Establish an accurate starting cash balance
Use a beginning balance that reconciles to your records. Account for outstanding checks and payments already initiated, either in the opening balance or as upcoming outflows, without counting them twice.
Identify any restricted funds separately. Also make tax reserves and other earmarked amounts visible so they are not mistaken for money available for discretionary spending.
An undrawn credit line is not cash in the bank. Show available borrowing separately, and include a draw as an inflow only when there is a realistic basis for expecting the funds to be available.
Estimate receipts using payment behavior
An invoice due date is a starting point, not a promise.
For larger receivables, consider the customer’s payment history, whether the invoice has been approved, and whether a dispute could delay collection. An overdue invoice should not automatically appear in next week’s receipts simply because you need the money.
For retail or other card-based businesses, allow for processing and settlement timing. For project work, distinguish signed contracts from opportunities still under discussion.
Small business cash flow forecasting becomes much more useful when those assumptions are written down. “Expected next week” should have a reason behind it.
Schedule payments in the weeks cash leaves
Enter rent, payroll, vendor bills, debt payments, and other commitments according to their expected payment dates. Avoid dividing monthly expenses evenly across four weeks.
Include spending that may not appear as an operating expense on your profit and loss statement, such as loan principal payments, equipment purchases, and owner distributions.
Payroll also needs careful handling. If your payroll provider withdraws wages, taxes, and fees together, use that funding schedule. If withdrawals occur separately, show them separately. Do not enter an all-inclusive payroll withdrawal and then add the same taxes again.
Review less frequent payments as well. Annual subscriptions, insurance premiums, equipment deposits, and scheduled repairs are easy to miss when a forecast is built only from last month’s expenses.
What a Weekly Cash Flow Forecast Template Should Include
A useful weekly cash flow forecast template has one column for each week, labeled with actual dates, and enough detail to explain significant changes.
| Forecast section | What to include |
| Beginning cash | Cash carried forward from the previous week |
| Operating receipts | Customer collections, cash sales, and other operating receipts |
| Operating payments | Payroll funding, vendors, rent, utilities, insurance, and other operating costs |
| Tax payments | Applicable business tax payments and deposits, without duplicating payroll withdrawals |
| Other cash movements | Loan proceeds and repayments, equipment purchases, owner contributions, and distributions |
| Ending cash | Beginning cash plus receipts minus payments |
| Minimum cash target | The operating cushion you want to maintain |
| Surplus or shortfall | Ending cash compared with that target |
Keep financing and owner transactions identifiable. Otherwise, a loan deposit or owner contribution can make a difficult operating week appear healthier than it was.
Your minimum cash target should reflect the business’s actual exposure: payroll requirements, customer concentration, collection uncertainty, and access to financing. A business dependent on two large customers may need a different cushion from one collecting hundreds of smaller payments each day.
Cash Flow Projections for Small Business: A Weekly Example
The simplified example below shows why the lowest projected balance deserves attention, even when no week ends below zero.
| Cash movement | Week 1 | Week 2 | Week 3 |
| Beginning cash | $40,000 | $27,000 | $11,000 |
| Expected receipts | $25,000 | $18,000 | $42,000 |
| Expected payments | ($38,000) | ($34,000) | ($29,000) |
| Ending cash | $27,000 | $11,000 | $24,000 |
| Cash above or below a $15,000 minimum | $12,000 | ($4,000) | $9,000 |
Illustrative figures only. A complete model would continue through Week 13.
Week 2 leaves the business $4,000 below its chosen operating cushion. The recovery in Week 3 depends on collecting the expected $42,000 on time.
That information should prompt a review before Week 2 arrives. Confirm the larger receivables, assess whether discretionary spending can wait, and discuss any proposed changes to vendor payment terms in advance.
If cash is particularly tight, examine daily timing within the affected week. A positive Friday balance does not establish that Tuesday’s obligations can be paid.
Give Tax Payments Their Own Place in the Forecast
Tax planning and cash planning should inform each other, but they answer different questions. A tax projection estimates liability. The cash forecast shows whether funds will be available when payments are required.
Federal payroll tax deposits, for example, do not necessarily follow the quarterly return filing date. Employers generally have monthly or semiweekly deposit requirements, with additional rules that can accelerate deposits. Use the schedule that applies to your business and your payroll provider’s actual funding dates.
Income taxes require separate attention. Business owners may need estimated payments during the year, and the amount should be reviewed as income changes. A cash forecast does not replace that tax calculation.
For an owner who pays personal estimated taxes using business distributions, show the anticipated distribution as a business cash outflow. Keep its classification separate from operating expenses.
As filing season approaches, include any expected balance due in the appropriate payment week. An extension generally provides more time to file, not more time to pay.
It is also worth looking beyond the forecast’s final column. A significant tax payment just outside the 13-week window may still affect how much cash you can responsibly commit today.
Make It a Rolling Cash Flow Forecast
A forecast prepared once and left untouched loses value quickly.
A rolling cash flow forecast moves forward every week. Record the completed week’s actual results, compare them with the original estimates, revise future assumptions, and add another week at the end. This maintains a consistent view of the next 13 weeks.
Keep the original forecast available for comparison. If it is overwritten before anyone reviews the differences, the business loses an opportunity to improve its assumptions.
Pay attention to the reason behind a variance. Lower receipts might reflect a payment arriving several days late, a disputed invoice, or weaker sales. Those situations call for different responses.
The same applies to spending. Cash that looks better because a vendor payment was postponed is not necessarily an improvement. The obligation remains and needs to appear in a later week.
Assign someone to maintain the forecast and make the review part of the owner’s regular financial routine.
Use Short-Term Cash Flow Forecasting Before Committing Cash
The most useful time to consult the forecast is before approving a decision that changes it.
Before adding an employee, place the expected payroll and related costs into the coming weeks. Before buying equipment, include the deposit, financing payments, installation, and other cash requirements. Before taking an owner distribution, review the lowest projected balance across the full period.
Then test a less favorable collection scenario. Move a major receipt back two weeks or reduce expected sales using a reasonable assumption for your business. The purpose is to understand how much flexibility remains if the original plan slips.
A forecast that repeatedly shows borrowing needed to fund ordinary operating costs deserves a broader review. Payment timing may be part of the problem, but pricing, margins, overhead, or debt commitments may also need attention.
Frequently Asked Questions
Why use a 13-week cash flow forecast instead of a monthly forecast?
A 13-week forecast shows cash movements by week across roughly one quarter. That detail helps identify shortfalls between payroll, customer collections, and vendor payments that monthly totals can hide. Monthly forecasts remain useful for longer-range planning.
How do you calculate a cash flow forecast?
Start with the opening cash balance, add expected receipts, and subtract expected payments for the period. Carry the ending balance into the next period. For a weekly forecast, repeat the calculation across all 13 weeks using realistic collection and payment dates.
What is the difference between a cash flow forecast and a budget?
A budget establishes planned revenue and spending. A cash flow forecast estimates when money will enter and leave the business. An accrual-based budget may record a sale before the customer pays, while the cash forecast places the receipt in the expected collection period.
How often should a cash flow forecast be updated?
Update a 13-week forecast every week to keep the rolling window current. Review it more frequently when cash is tight, a major payment is uncertain, or a significant business change affects the assumptions. Weekly updates provide more immediate visibility than relying solely on a monthly budget.
Can you create a cash flow forecast in Excel or Google Sheets?
Yes. A spreadsheet can support a 13-week model with dated weekly columns, receipt and payment categories, and formulas linking each week’s closing balance to the next week’s opening balance. Its usefulness depends on accurate inputs, clear assumptions, and consistent updates.
What should you do if your cash flow forecast shows a shortfall?
Identify when the shortfall occurs, how large it is, and what causes it. Confirm expected collections, review discretionary commitments, and discuss payment arrangements or financing early where appropriate. If shortfalls keep returning, examine whether the underlying issue involves margins, spending, or debt rather than timing alone.
Plan the Next Quarter With Better Visibility
A useful 13-week cash flow forecast should help you decide which commitments the business can support and which deserve another look. Over time, comparing expectations with actual results also reveals where collections, spending, and tax planning need closer attention.
Prudent Accountants helps business owners connect their bookkeeping, cash flow planning, and tax obligations so financial decisions reflect the commitments ahead.
Contact Prudent Accountants to discuss building or improving a cash flow forecast for your business.
0 Comments