Profitable but Cash-Tight? How to Build a 13-Week Cash Flow Forecast in 5 Steps
Your books show a profit. Your bank account tells a different story.
That contradiction is common in growing service and trade businesses. Revenue is increasing. The profit and loss statement looks healthy. Yet payroll is approaching, vendor payments are due, and available cash feels uncomfortably low.
The problem is not always revenue.
Often, the problem is visibility.
Profit is measured over a period of time. Cash is about what enters and leaves your bank account, and exactly when it happens. A profitable business can still experience a cash crunch when customer payments arrive late, payroll lands before collections, or several large expenses hit the same week.
That is why cash flow forecasting for small business matters. A reliable forecast helps you move from guessing to knowing, from reacting to preparing, and from short-term fixes to durable control.
A rolling 13-week cash flow forecast, updated weekly, is a practical way to monitor short-term liquidity and identify cash pressure before it becomes urgent. It gives you a week-by-week view of the next quarter without pretending you can predict every detail a year from now.
Here is how to build one.
Step 1: Start with clean, reliable numbers
A forecast is only as useful as the information behind it.
If your books are several months behind, bank accounts are unreconciled, or accounts receivable is not current, your forecast will be built on assumptions instead of facts. That creates false confidence: the most dangerous kind.
Before forecasting, establish a dependable financial foundation:
- Reconcile every bank and credit card account.
- Confirm your current cash balance.
- Review open customer invoices.
- Review unpaid vendor bills.
- Identify recurring expenses and upcoming one-time payments.
- Confirm payroll and tax payment dates.
This is where disciplined bookkeeping and month-end close processes matter. Your monthly financials should explain what happened, while your forecast shows what is likely to happen next.
At MASCPA, we treat clean books as the operating system for better decisions. Reliable reconciliations and timely reporting give you numbers you can actually use.
Learn more about MASCPA bookkeeping and month-end services.
Step 2: Build a rolling 13-week view
An annual budget has value. It can help you set goals, plan hiring, and evaluate expected profitability.
But it is not designed to answer a more immediate question:
Will there be enough cash in the bank when payroll is due?
A rolling 13-week forecast gives you that near-term view. Set up 13 weekly columns and include:
- Opening cash balance
- Expected cash inflows
- Expected cash outflows
- Net cash flow
- Ending cash balance
- Minimum cash target
The model is simple:
Ending cash = Opening cash + Cash inflows − Cash outflows
At the end of each week, replace the forecast for the completed week with actual results. Then remove that week, shift the remaining weeks forward, and add a new Week 13.
That is what makes the forecast “rolling.” You are not creating a new budget once a year. You are maintaining a forward-looking view every week.
A 13-week timeframe is useful because it creates a near-term, week-by-week view of liquidity while still looking far enough ahead to spot developing pressure. A monthly forecast can hide a difficult week. A 13-week forecast brings that week into focus.
Step 3: Forecast cash inflows based on when money will arrive
Do not forecast revenue as if it were cash.
Revenue may be recorded when you complete a job or issue an invoice. Cash arrives when the customer actually pays. Those may be very different dates.
For each expected inflow, estimate when the cash will clear your bank account. Include:
- Open accounts receivable by expected collection week
- Credit card and payment processor deposits
- Customer deposits
- Recurring contracts or retainers
- Contracted or otherwise supportable future receipts
- Owner contributions or financing
- Tax refunds or other expected receipts
Be realistic about customer payment behavior. If a customer regularly pays 10 days late, do not place the collection on the invoice due date simply because the terms say “Net 30.”
Separate your assumptions into categories:
- Committed: An invoice is approved and the customer has confirmed payment.
- Expected: Payment is likely based on past behavior.
- Possible: The opportunity exists, but the sale or collection is uncertain.
Your base forecast should rely primarily on committed and expected cash. Possible revenue belongs in a separate scenario: not in the number you use to decide whether payroll is safe.
This is one of the most important principles in cash flow management for small business:
Hope is not a cash-flow assumption.
Step 4: Map every cash outflow, especially payroll
Payroll should be modeled based on when cash is expected to leave the business, not simply by the period in which employees earn their wages.
Include separate lines for:
- Employee payroll
- Employer payroll costs
- Federal and state payroll tax deposits
- Benefits and retirement contributions
- Rent and utilities
- Vendor payments
- Insurance
- Loan and lease payments
- Estimated and other tax payments
- Owner draws or distributions
- Equipment purchases and other capital expenditures
Payroll deserves special attention because the timing is not always as simple as one payday.
Federal employment-tax deposits, for example, generally follow either a monthly or semiweekly deposit schedule based on the employer's applicable IRS lookback period. The required deposit schedule is not determined simply by how often employees are paid. Employers should confirm the schedule that applies to their specific facts and obligations. See IRS Publication 15 (2026), Employer’s Tax Guide.
That means your forecast may need to account separately for the paycheck date and the related tax-deposit date.
Also look for timing traps:
- A third biweekly payroll in one month
- Federal or state payroll tax deposits
- Quarterly estimated tax payments
- Annual insurance renewals
- Large equipment purchases
- Seasonal labor
- Bonuses or commissions
- A planned hire
- Debt payments that fall in the same week as payroll
Set a minimum cash target based on the obligations and volatility of your own business.
There is no universal cash buffer that works for every company. The appropriate threshold depends on payroll, fixed expenses, customer payment timing, seasonality, access to capital, and other business-specific risks.
The point is not to invent a perfect number.
The point is to establish a threshold that tells you when leadership needs to pay attention and make a decision.
Step 5: Review the forecast every week and connect it to decisions
A cash flow forecast is not a spreadsheet you build once and file away.
Its value comes from the weekly operating rhythm:
- Replace the prior week’s estimates with actual bank activity.
- Compare actual cash inflows and outflows to the forecast.
- Identify whether differences came from timing, amount, or a flawed assumption.
- Update the next 12 weeks.
- Add a new Week 13.
- Decide what action the forecast requires.
That final step matters most.
At MASCPA, we do not view the forecast as the answer. The forecast surfaces the question. The founder and advisors still have to decide what happens next.
A forecast should help you make decisions such as:
- Should you follow up on specific invoices this week?
- Does the forecast support the planned hiring date, or does the decision need further review?
- Does the forecast support the timing of a planned vehicle or equipment purchase?
- Should you adjust pricing before taking on more work?
- What does the forecast show before considering an increase in owner distributions?
- Should you negotiate vendor timing?
- Is upcoming liquidity pressure significant enough to discuss financing options with your lender or advisor?
This is where financial forecasting for small business becomes more than a finance exercise. It becomes part of how you operate.
Your numbers should support decisions about payroll, hiring, pricing, purchases, and growth: not just describe what happened last month.
When you need help with cash flow forecasting
You can build a basic 13-week model in a spreadsheet. For a simple business with one entity, predictable collections, and limited transactions, that may be enough to get started.
The process becomes harder when:
- Customer payment timing is inconsistent.
- Multiple bank accounts or entities are involved.
- Payroll and tax obligations are growing.
- You are considering hiring or expansion.
- Your books are not closed on schedule.
- You have reports but do not trust them.
- The weekly forecast keeps getting postponed.
That is when cash flow forecasting services can provide practical value. The goal is not to hand you another report. The goal is to establish a reliable process that connects accurate books, weekly forecasting, and decision support.
MASCPA can help build that structure in stages:
- Clean books and month-end close create a reliable starting point.
- Cash flow forecasting shows what is likely to happen over the next 13 weeks.
- Fractional CFO support connects the forecast to hiring, pricing, purchasing, financing, and growth decisions.
Our approach is teachers first, technicians second. We translate the numbers into plain English and help you understand what the forecast is telling you and what to do next.
Profitability is important. Visibility protects it.
A profitable business can still run short of cash. That does not mean the business is broken. It usually means the timing, reporting, and planning systems have not caught up with the complexity of the business.
A rolling 13-week forecast gives you a clearer operating view:
Cash in. Cash out. Cash remaining.
You see the tight weeks before they become emergencies. You can prepare for payroll, prioritize collections, control discretionary spending, and make growth decisions with better financial context.
If your books look profitable but your bank account feels tight, the next step may not be selling more.
It may be seeing more clearly.
Contact MASCPA to discuss your cash flow and forecasting needs.
FAQ
What is a 13-week cash flow forecast?
It is a rolling weekly forecast that maps expected cash in, cash out, and ending cash balance over the next quarter. It is designed to help you monitor short-term liquidity and see pressure points before they become urgent.
Why can a profitable business still run out of cash?
Profit and cash are not the same. A business can show a profit on the income statement while still running short of cash if collections are delayed, payroll hits before customer payments arrive, or several large obligations land at the same time.
How often should a 13-week cash flow forecast be updated?
Weekly. At the end of each week, replace estimates with actual results, shift the forecast forward, and add a new week so the view stays current.
What is the difference between a cash flow forecast and a budget?
A budget is usually built to set targets for revenue, expenses, and profitability over a longer period. A cash flow forecast focuses on timing. It helps you see when money is expected to come in, when it is expected to go out, and whether cash will be available when obligations are due.