XXLFormula AI
Pro TemplateFinanceIntermediate

13-Week Cash Flow Forecast

4.8· Updated Jun 2026

The 13-week cash flow is the operating heartbeat of any small business. This template gives you a rolling forecast with categorised receipts and payments, opening/closing balances, and variance vs. forecast — everything a founder or CFO needs before a payroll run.

Excel compatibleGoogle Sheets compatible
13-Week Cash Flow Forecast — XLFormula AIHomeInsertFormulasDataViewfx =SUM(B2:B13)ABCDEFGHI12345678910111213141516Revenue$48,290+12.4%Expenses$22,140-3.1%Net Income$26,150+18.9%Runway14 mo+1 moCash PositionDashboardDataSettings+

Screenshots

Key features

  • Rolling 13-week window with auto week headers
  • Receipts / payments broken down by category
  • Opening + closing bank balance per week
  • Variance vs. forecast tracking
  • Chart of net cash position

What's included

  • Excel .xlsx workbook
  • Google Sheets version
  • Category taxonomy examples
  • Quick-start video walkthrough (link)
Included with Pro

Get this template — and every other one

Every download, every category, every future release for $5.00/month.

  • Unlimited Template Downloads
  • Excel Templates
  • Google Sheets Templates
  • AI Formula Generator
  • AI VBA Generator
  • Premium Formula Library
  • Future Template Updates

Frequently asked questions

Can I extend to 26 weeks?
Yes — duplicate the week-column block and the summary chart auto-extends.
Is it suitable for VAT/GST?
Yes. There's a dedicated tax line in both receipts and payments.

Related templates