Home › Templates › 13-Week Cash Flow Forecast Template
13-Week Cash Flow Forecast Template
A rolling 13-week cash forecast. Enter expected receipts and disbursements by week to see closing cash, the lowest point in the quarter, and any week that falls below your minimum balance.
Free. Excel .xlsx format, no macros, no registration.
Contents
| Tab | Purpose |
|---|---|
| Instructions | Purpose, steps, a guide to each tab, the colour key and a list of every built-in check with its result. |
| Inputs | Start date, opening cash, minimum balance and a summary of the quarter. |
| Schedule | Receipts and disbursements by category for 13 weeks, with net cash flow, closing cash and status against the minimum. |
| Reconciliation | Opening cash agreed to the bank, and forecast compared with actual closing cash each week. |
| Lists | Receipt and disbursement categories. |
Features
- Eight receipt and sixteen disbursement categories, all renameable.
- Flags each week that closes below the minimum balance, and reports the largest shortfall.
- Reports the lowest closing balance and the week it occurs, with a chart of closing cash against the minimum.
- Tracks forecast accuracy as actual balances are entered.
Instructions
- On the Inputs tab, enter the week 1 start date, opening cash and minimum balance.
- On the Schedule tab, enter expected cash movements in the week the cash moves.
- Review the status row and the summary.
- Each week, enter actual closing cash on the Reconciliation tab and update the remaining weeks.
Notes
This template has no journal entry tab, because a forecast does not generate accounting entries.
Related calculators
- Burn Rate and Runway CalculatorCalculate gross burn, net burn and months of cash runway from your cash balance, monthly revenue and monthly expenses.
- Cash Conversion Cycle CalculatorCalculate the cash conversion cycle from inventory, receivables and payables: days inventory, days sales and days payable outstanding.
- Free Cash Flow CalculatorCalculate free cash flow from operating cash flow and capital expenditures, with free cash flow margin and conversion.
- Days Payable Outstanding (DPO) CalculatorCalculate days payable outstanding and payables turnover from accounts payable and cost of goods sold.
More accounting templates
- Depreciation Schedule TemplateFixed asset register with monthly depreciation, disposals, roll-forwards by class, journal entries and general ledger reconciliation.
- Loan Amortization Schedule TemplatePayment-by-payment amortization with extra principal, journal entries for payment, accrued interest and the current portion, and a lender reconciliation.
- Bank Reconciliation TemplateTwo-sided bank reconciliation with outstanding items, book adjustments and the adjusting journal entry.
- Month-End Close Checklist TemplateClose checklist with owners, business-day due dates and status, a recurring entry register and an account reconciliation tracker.
- Accounts Receivable Aging TemplateInvoice-level aging with customer totals, allowance calculation, journal entry and control account reconciliation.
- Prepaid Expense and Accrual Schedule TemplatePrepaid amortization and accrued expense schedules with both journal entries and ledger reconciliations.
Need a version built for your process? Request a custom template quote.
To report an error or request a calculator or template, send feedback.
Templates are provided for general information. They are not accounting, tax or legal advice. Review the formulas and results before relying on them.