Quick Answer
A 13-week cash flow forecast is a week-by-week projection of the cash coming into and going out of your business over the next quarter. To build one, start with your current bank balance, list expected receipts by the week you will actually collect them, list every payment by the week it leaves your account, then calculate net cash flow and ending cash for each week. Update it every week and compare forecast to actual.
What Is a 13-Week Cash Flow Forecast?
A 13-week cash flow forecast is a rolling, short-term model that tracks cash on a weekly basis rather than monthly. It uses the direct method: real dollars received and real dollars paid, not accounting profit.
Why 13 Weeks?
Thirteen weeks equals one full quarter. That window is long enough to catch problems like a big tax payment, a seasonal slowdown, or a customer that pays in 60 days, yet short enough that your numbers stay accurate. Beyond about three months, weekly estimates become guesses.
Why Weekly Instead of Monthly?
Monthly forecasts hide timing. A business can look healthy for the month and still be unable to cover payroll on the 15th because a large customer payment lands on the 28th. Weekly buckets show exactly when cash dips below what you need.
Cash Flow Forecast vs. Budget vs. P&L
| Tool | What it measures | Time unit | Main question it answers |
| 13-week cash flow forecast | Actual cash in and out | Week | Will we have enough cash to pay our bills each week? |
| Annual budget | Planned revenue and expenses | Month or year | What do we plan to earn and spend? |
| Profit and loss statement | Revenue and expenses as earned (accrual) | Month, quarter, year | Were we profitable? |
Who Needs a 13-Week Cash Flow Forecast?
Any business that pays bills before customers pay invoices benefits from one. It is especially useful if you:
- Sell on net 30, net 60, or net 90 terms and wait weeks to get paid
- Run weekly or biweekly payroll, such as staffing, trucking, manufacturing, or construction firms
- Have seasonal swings in sales or large one-time payments like insurance premiums or quarterly taxes
- Are growing fast and need to fund inventory, labor, or materials before revenue arrives
- Are working with a lender, factoring company, or turnaround advisor who asks for one
- Have had a close call making payroll or paying a key vendor
How to Build a 13-Week Cash Flow Forecast in 7 Steps
Step 1: Set up your 13 weekly columns
Create one column per week, labeled with the week-ending date (for example, the Friday of each week). Add a final column for the 13-week total. Pick a consistent week end, since most banks and payroll cycles align with Friday.
Step 2: Enter your beginning cash balance
Use your actual bank balance on the first day of Week 1, not the balance in your accounting software. Include all operating accounts. Do not count money that is unavailable, such as uncleared deposits or restricted funds.
Step 3: Forecast cash receipts by week
List every source of incoming cash, then place each amount in the week you expect the money to land in your account.
- Customer collections: Start with your accounts receivable aging report. Assign each open invoice to a week based on how that customer actually pays, not the invoice terms. If a customer on net 30 usually pays in 45 days, forecast 45.
- New sales: Estimate invoices you will issue during the 13 weeks, then push them out by your average days to collect.
- Cash sales and deposits: Include card settlements, retainers, and upfront deposits.
- Other receipts: Tax refunds, asset sales, loan draws, factoring advances, or owner contributions.
Step 4: Forecast cash disbursements by week
List every payment by the week it will clear your account.
- Payroll and payroll taxes: Map these to your exact pay dates. These are usually your largest and least flexible payments.
- Vendors and suppliers: Use your accounts payable aging and the terms you actually pay on.
- Rent, utilities, insurance, and subscriptions: Place each in its due week.
- Debt service: Loan, line of credit, equipment lease, and credit card payments.
- Taxes: Sales tax, estimated income tax, and property tax.
- Capital spending and one-time items: Equipment, repairs, owner draws, or legal fees.
Step 5: Calculate net cash flow and ending cash
For each week, use these two formulas:
- Net cash flow = Total receipts minus total disbursements
- Ending cash = Beginning cash plus net cash flow
Each week’s ending cash becomes the next week’s beginning cash.
Step 6: Set a minimum cash threshold and flag gaps
Decide the lowest balance you are comfortable holding. A common rule is at least one full payroll cycle plus one week of fixed costs. Add a row that compares ending cash to this minimum. Any week that falls below it is a cash gap you need to plan for now.
Step 7: Update weekly and roll it forward
Every week, replace the forecast for the week just ended with actual numbers, note the variance, and add a new Week 13 at the end. Tracking forecast versus actual shows where your assumptions are off, such as a customer paying slower than expected, so each forecast gets more accurate than the last.
Free 13-Week Cash Flow Forecast Template
Use this template as your starting point. Fill in the week-ending dates, enter your beginning cash in Week 1, and add your receipts and disbursements line by line.
How the template works: Each week’s ending cash carries forward as the next week’s beginning cash. Any negative number in the Surplus (shortfall) row is a week where cash falls below your minimum target.
Example: A 13-Week Forecast in Action
Here are the first four weeks of a forecast for a hypothetical staffing company. It runs biweekly payroll of $58,000, bills clients on net 30 terms, and wants to keep at least $40,000 in the bank.
| Line item | Week 1 | Week 2 | Week 3 | Week 4 |
| Beginning cash | $85,000 | $53,000 | $72,000 | $33,000 |
| Customer collections | $60,000 | $45,000 | $38,000 | $72,000 |
| Payroll and payroll taxes | $58,000 | $0 | $58,000 | $0 |
| Vendors and suppliers | $18,000 | $22,000 | $15,000 | $20,000 |
| Rent | $12,000 | $0 | $0 | $0 |
| Loan payment | $0 | $0 | $0 | $6,000 |
| Other operating costs | $4,000 | $4,000 | $4,000 | $4,000 |
| Net cash flow | ($32,000) | $19,000 | ($39,000) | $42,000 |
| Ending cash | $53,000 | $72,000 | $33,000 | $75,000 |
| Surplus (shortfall) vs. $40,000 minimum | $13,000 | $32,000 | ($7,000) | $35,000 |
What the forecast reveals: The company is profitable and collects $72,000 in Week 4, but a payroll week in Week 3 coincides with slow collections. Ending cash drops to $33,000, which is $7,000 below its safety cushion. A monthly forecast would show a healthy month and miss this gap entirely.
Because the owner sees the gap three weeks early, there is time to act: ask a client to pay sooner, delay a vendor payment, or turn open invoices into cash now.
A business can be profitable for the month and still miss payroll on the 15th.”
6 Common 13-Week Forecasting Mistakes
- Using invoice terms instead of real payment behavior. If customers pay in 52 days on net 30 terms, forecast 52 days.
- Mixing profit with cash. Depreciation and accrued expenses do not belong in a cash forecast. Loan principal payments and owner draws do.
- Forgetting irregular payments. Quarterly taxes, annual insurance premiums, and software renewals cause many surprise shortfalls.
- Being too optimistic. Forecast collections conservatively and expenses fully. A pleasant surprise is easier to handle than a short bank account.
- Building it once and never updating it. A 13-week forecast only works if you roll it forward every week with actual numbers.
- Ignoring customer concentration. If one client is 30% of your receivables, model what happens if they pay two weeks late.
What to Do When Your Forecast Shows a Cash Gap
A forecast is only valuable if you act on it. When a week turns red, you have a few levers:
- Speed up collections. Send invoices the same day work is done, follow up before the due date, and offer a small early payment discount.
- Adjust payment timing. Ask key vendors for extended terms or split a large payment across two weeks.
- Trim or delay discretionary spending. Push nonessential purchases until after the gap.
- Convert receivables into cash. If the gap exists because customers owe you money that has not arrived yet, invoice factoring can close it without adding debt.
How Invoice Factoring Fits Into Your 13-week Forecast
With invoice factoring, you sell open invoices to a factoring company and receive most of their value upfront, often within a day or two of approval. The factoring company then collects from your customer. In your forecast, factoring moves a receipt from Week 6 or Week 8 into the week you need it, which is exactly the kind of timing fix a 13-week forecast exposes.
Since 1998, Universal Funding has helped businesses in staffing, transportation, manufacturing, distribution, and other industries turn unpaid invoices into working capital. We offer invoice factoring, accounts receivable financing, and purchase order financing, plus confidential (non-notification) factoring for businesses that want to keep the arrangement private from customers.
Built your forecast and found a gap? Contact Universal Funding for a free consultation and see how much working capital your open invoices could unlock this week.
Frequently Asked Questions
What is a 13-week cash flow forecast?
A 13-week cash flow forecast is a weekly projection of cash receipts and cash payments over the next quarter. It shows your expected bank balance at the end of each week so you can spot shortfalls before they happen.
Why is a cash flow forecast 13 weeks long?
Thirteen weeks equals one fiscal quarter. It is long enough to capture monthly and quarterly obligations like rent, taxes, and insurance, yet short enough that weekly estimates stay reliable.
What is the difference between the direct and indirect cash flow method?
The direct method, used in a 13-week forecast, lists actual cash received and paid. The indirect method starts with net income and adjusts for noncash items. The direct method is better for short-term planning because it shows timing.
How often should I update a 13-week cash flow forecast?
Update it every week. Replace the past week’s forecast with actual results, review the variance, and add a new week at the end so you always look 13 weeks ahead.
Can I build a 13-week cash flow forecast in Excel or Google Sheets?
Yes. Most businesses use a spreadsheet. Download the free template into Excel or Google Sheets, enter your beginning cash, receipts, and payments, and the formulas calculate ending cash each week.
Who uses 13-week cash flow forecasts?
Business owners, CFOs, controllers, lenders, factoring companies, and turnaround consultants use them. Lenders often request one when a business applies for financing or is going through a restructuring.
How much cash should a business keep as a minimum balance?
A common guideline is enough to cover at least one full payroll cycle plus one week of fixed operating costs. Businesses with uneven collections or seasonal sales often hold more.
What should I do if my forecast shows negative cash?
Act early. Speed up collections, negotiate vendor terms, delay nonessential spending, or use financing such as invoice factoring to turn unpaid invoices into immediate working capital.
