Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesFinanceCash Flow Management13-Week Cash Flow Forecast

SpreadsheetCash Flow ManagementFree

13-Week Cash Flow Forecast

Week-by-week cash in and out for the next quarter, with your lowest point, shortfalls and runway.

Shown with sample data

Colour

13-Week Cash Flow Forecast

Week-by-week cash in and out for the next quarter, with your lowest point, shortfalls and runway.

Cash today
$48,000
Cash in 13 weeks
$16,750
Lowest balance
$16,750
The tightest week of the quarter
Weeks below buffer
2
Runway
2.8
Weeks of costs covered by cash today
Closing cash by week
W1W13

Latest: $16,750

Net cash flow by week
  • W1-$6,600
  • W2$3,300
  • W3$1,000
  • W4$2,250
  • W5-$17,300
  • W6$5,000
  • W7$350
  • W8$3,700
  • W9-$15,700
  • W10$5,900
  • W11-$2,850
  • W12$6,800

How to use it

  1. 1On the Settings sheet, enter today's bank balance and your minimum cash buffer.
  2. 2Fill in expected customer receipts and other money in for each week.
  3. 3Enter payroll, rent and overheads, suppliers, tax and loan payments as money out.
  4. 4Act on any week flagged Below buffer or Overdrawn: chase receipts, delay payments or arrange funding early.
  5. 5Every Monday, replace last week with actuals and add a new week 13.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

The 13-week cash flow forecast is the tool lenders, CFOs and turnaround advisers rely on to manage liquidity. Enter expected receipts and payments for each week; the forecast rolls the balance forward, flags any week below your minimum cash buffer or overdrawn, finds the lowest point in the quarter and when it happens, and shows how many weeks of costs your cash covers.

Who it’s for

  • Small businesses managing tight cash
  • Founders tracking runway week by week
  • Preparing for a lender or investor conversation

What’s included

  • Forecast sheet: Weekly money in and out with the rolling cash balance.
  • Settings sheet: Starting cash and your safety buffer.

How to use it

  1. 1On the Settings sheet, enter today's bank balance and your minimum cash buffer.
  2. 2Fill in expected customer receipts and other money in for each week.
  3. 3Enter payroll, rent and overheads, suppliers, tax and loan payments as money out.
  4. 4Act on any week flagged Below buffer or Overdrawn: chase receipts, delay payments or arrange funding early.
  5. 5Every Monday, replace last week with actuals and add a new week 13.

Tips

  • Be conservative on receipts and realistic on payments; late customers are the usual surprise.
  • Payroll and tax dates are fixed; plan everything else around them.
  • A buffer of two to four weeks of fixed costs gives you room to react.

Questions

Why 13 weeks?

Thirteen weeks is one quarter: long enough to see problems coming and short enough to forecast accurately week by week.

What is the minimum buffer?

The cash you never want to drop below, often two to four weeks of fixed costs.

How is runway worked out?

Today's cash divided by average weekly money out across the 13 weeks.

Related searchescash flow forecast13 week cash flowliquiditysmall business financecash runwaycash management

Details

Format
Spreadsheet
Category
Cash Flow Management
Sheets
2
Setup
10 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetCash Flow ManagementFree

13-Week Cash Flow Forecast

Week-by-week cash in and out for the next quarter, with your lowest point, shortfalls and runway.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Cash Flow Management
Sheets
2
Setup
10 min
Level
Intermediate
Price
Free

Your copy is private to you.

More cash flow management templates

View all
12-Month Cash Flow Forecast2 sheets

Closing cash, December

$112,700

Lowest cash balance

$28,800

Months below minimum

0

Net cash flow by month
$11k
$12k
-$900
$9,900
$16k
JanFebMarAprMay
SpreadsheetCash Flow Management

12-Month Cash Flow Forecast

Monthly receipts and payments with opening and closing cash, the lowest point and how many months it covers.

10 min setupPreview
Daily Cash Position Report2 sheets

Total cash

$178,550

Available to spend

$168,450

Net movement today

-$45,090

Projected close by type
$120k
$53k
$32k
$9,050
-$35k
SavingsOperatingTax reserveMerchant / PayPalPayroll
SpreadsheetCash Flow & Treasury

Daily Cash Position Report

Balances across every account with today’s expected receipts and payments and the projected close.

10 min setupPreview
Working Capital and Cash Conversion Cycle3 sheets

Cash conversion cycle (latest)

66.2

DSO (latest)

43.6

DIO (latest)

61.8

ABCD
1PeriodRevenueCost of salesAccounts receivable
2Jun 2026$820,000$557,600$1,312,000
3Jul 2026$865,000$588,200$1,358,000
4Aug 2026$798,000$542,600$1,330,000
5Sep 2026$902,000$613,400$1,390,000
Periods
SpreadsheetCash Flow Management

Working Capital and Cash Conversion Cycle

Track DSO, DIO, DPO and the cash conversion cycle each month, and see how much cash each improvement would release.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ