Cash Flow Forecast Template Excel: 13-Week Cash Flow with 12-Month Projection

13-Week Cash Flow Forecast is a cashflow forecast template for owners and finance managers who need to know where cash is heading week by week. Enter today's bank balance, the minimum cash you want to keep and any credit line, then list what customers owe, what you owe suppliers and your regular commitments. The forecast shows opening balance, receipts and payments by category, net cash flow and closing balance for each of the next 13 weeks, with a status for every week: OK, below minimum, using the credit line, or short.

Each source is timed the way cash really moves. Open customer invoices are expected on the due date plus the collection delay you set, or on a date you type, and anything already overdue lands in week 1. Supplier bills go out on the due date or a planned pay date. Recurring items such as payroll, rent, loan repayments, subscriptions and regular card sales repeat weekly, every 2 or 4 weeks, monthly, quarterly, twice a year or annually from a first date, with an optional end date. One-off items such as equipment, tax bills, loan drawdowns and asset sales go in on their date.

Keep it rolling. When a week is over, enter what actually came in and went out by category on the Actuals tab. That week switches to actuals and the balance rolls forward from real figures. The Variance tab compares actual with forecast by category over the completed weeks and for any single week, marking each line favourable or adverse.

The 12-Month View carries the same model by month for a year, so it doubles as a 12 month cash flow projection template, with completed weeks adjusted to actuals. The Dashboard shows opening cash, the lowest balance and the week it happens, the week-13 closing balance, weeks below minimum, a chart of closing balance against minimum cash, receipts against payments, receivables and payables totals with overdue amounts, the biggest payments and the 12-month closing balance.

Rename the receipt and payment categories to suit any business, including construction, services, retail and wholesale. Capacity covers 500 receivables, 500 payables, 100 recurring items and 300 one-off items. Calculated cells are locked and sheet protection has no password. Sample data from a fictional distributor is included. Built for Microsoft Excel 2016 or later (desktop or Excel for the web) and contains no macros.