Rounding Robin

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.

Download the Excel template

Free. Excel .xlsx format, no macros, no registration.

Contents

TabPurpose
InstructionsPurpose, steps, a guide to each tab, the colour key and a list of every built-in check with its result.
InputsStart date, opening cash, minimum balance and a summary of the quarter.
ScheduleReceipts and disbursements by category for 13 weeks, with net cash flow, closing cash and status against the minimum.
ReconciliationOpening cash agreed to the bank, and forecast compared with actual closing cash each week.
ListsReceipt and disbursement categories.

Features

Instructions

  1. On the Inputs tab, enter the week 1 start date, opening cash and minimum balance.
  2. On the Schedule tab, enter expected cash movements in the week the cash moves.
  3. Review the status row and the summary.
  4. 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

More accounting templates

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.