A 13-week cash flow template is a rolling weekly forecast of the cash coming in and going out of your business over the next quarter. Download the free Excel template below. Enter your opening cash and expected receipts and payments for each week; it calculates net cash flow and ending cash, rolls each week's balance forward, includes a line for credit-line draws and repayments, and flags any week that falls below your minimum cash balance.
- 13 weekly columns plus a 13-week total, with week start dates filled in automatically
- Receipts: customer collections, cash sales and other receipts
- Disbursements: payroll, suppliers, rent, freight and duties, debt service, taxes and other expenses
- Line of credit draw or repayment row
- Ending cash rolled into the next week's beginning cash
- Minimum cash balance alert that marks weeks BELOW MIN in red
- A filled-in example sheet
What Is a 13-Week Cash Flow Forecast?
A 13-week cash flow forecast is a short-term planning tool that projects your cash position week by week for the next quarter. Unlike a cash flow statement, which looks back, a 13-week forecast looks forward. It uses the direct method: actual expected receipts and payments, not accounting adjustments.
It is widely used by finance teams and lenders because it shows exactly when cash will be tight, not just whether the year will be profitable. Learn the basics in our guide to cash flow forecasting.
How the 13-Week Cash Flow Template Works
For each week, the template calculates:
Beginning cash + total receipts − total disbursements = ending cash before financing
Ending cash before financing + line of credit draw (or − repayment) = ending cash balance
Each week's ending cash becomes the next week's beginning cash. If ending cash drops below the minimum balance you set, the status row shows BELOW MIN.
How to Build Your 13-Week Forecast
- Enter the first week's start date (usually a Monday). The other 12 dates fill in automatically.
- Set a minimum cash balance, the cushion you never want to go below, such as two weeks of payroll and rent.
- Enter opening cash from your bank balance at the start of week 1.
- Forecast collections from your accounts receivable aging report: put each invoice in the week you realistically expect payment, not the due date.
- Schedule disbursements from your accounts payable tracker, payroll calendar, rent, loan payments and tax dates. Importers should include freight, duties and tariffs in the week they are paid.
- Look for BELOW MIN weeks and plan a response: speed up collections, delay discretionary spending, negotiate supplier terms or draw on a credit line.
- Update every week. Replace the past week with actuals, review the variance and add a new week 13.
13-Week Cash Flow Example
Highlights from the template's Example sheet, with $120,000 opening cash and a $90,000 minimum balance:
| Week | Receipts | Disbursements | Net cash flow | Credit line | Ending cash | Status |
|---|---|---|---|---|---|---|
| 1 | $58,000 | $61,500 | ($3,500) | – | $116,500 | OK |
| 2 | $54,000 | $63,000 | ($9,000) | – | $107,500 | OK |
| 3 | $61,000 | $100,000 | ($39,000) | +$40,000 | $108,500 | OK |
| 6 | $52,000 | $66,000 | ($14,000) | – | $108,800 | OK |
| 7 | $64,000 | $84,000 | ($20,000) | – | $88,800 | BELOW MIN |
| 12 | $76,000 | $66,200 | $9,800 | ($20,000) | $93,900 | OK |
| 13 | $72,000 | $52,500 | $19,500 | ($20,000) | $93,400 | OK |
A large supplier payment in week 3 would have pushed cash down to $68,500, so the forecast plans a $40,000 credit-line draw. Week 7 still dips below the $90,000 minimum, which gives the business six weeks' notice to adjust, for example by collecting a large invoice earlier or moving a supplier payment.
Tips for an Accurate 13-Week Forecast
- Forecast collections conservatively. Use each customer's actual payment history, not invoice terms.
- Separate lumpy payments, such as quarterly taxes, insurance renewals and large inventory orders.
- Track forecast vs actual. A variance column for last week shows where your assumptions are off.
- Keep it cash-only. Don't include depreciation or other non-cash items.
- Include financing. Show loan payments, credit-line draws and repayments explicitly so the forecast matches your bank balance.
When the Forecast Shows a Gap
A 13-week forecast is most useful when it shows a shortfall weeks in advance. Common fixes include tightening payment terms, chasing overdue receivables with a collection letter, stretching supplier terms through vendor financing, or using a business line of credit to cover the gap.
Forecast showing a cash gap in the next few weeks? Drip Capital offers collateral-free working capital of up to $3M, with funds in 24–48 hours and 30–90 day repayment terms. Check your eligibility
Frequently Asked Questions
What is a 13-week cash flow forecast?
It is a rolling weekly projection of cash receipts and disbursements for the next 13 weeks, about one quarter. It shows your expected cash balance at the end of each week so you can see shortfalls before they happen.
Why 13 weeks?
Thirteen weeks covers a full quarter, which is long enough to capture payroll cycles, monthly rent, quarterly taxes and seasonal swings, but short enough to forecast accurately week by week.
How often should I update a 13-week cash flow?
Weekly. Replace last week's forecast with actual figures, compare the two, add a new week at the end and adjust the remaining weeks for anything you have learned.
Who uses a 13-week cash flow model?
Small and mid-sized businesses managing tight cash, CFOs and controllers, lenders monitoring a credit line, and turnaround advisers. Lenders often ask for one when a business requests working capital.
Is a 13-week cash flow the same as a cash flow statement?
No. A cash flow statement reports past results, usually using the indirect method. A 13-week forecast looks forward and uses the direct method: actual expected receipts and payments.
