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

SpreadsheetCash Flow ManagementFree

12-Month Cash Flow Forecast

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

Shown with sample data

Colour

12-Month Cash Flow Forecast

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

Closing cash, December
$112,700
Lowest cash balance
$28,800
Your tightest month
Months below minimum
0
Net cash for the year
$94,700
Closing cash by month
JanDec

Latest: $112,700

Net cash flow by month
  • Jan$10,800
  • Feb$12,200
  • Mar-$900
  • Apr$9,900
  • May$15,900
  • Jun-$3,900
  • Jul$600
  • Aug-$2,200
  • Sep-$300
  • Oct$17,400
  • Nov$19,400
  • Dec$15,800

How to use it

  1. 1Type your opening bank balance and minimum cash on the Settings sheet.
  2. 2Enter receipts and each group of payments for every month.
  3. 3Look for months marked Below minimum and plan around them.
  4. 4Update with actuals each month and re-read the low point.

In this workbook

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

About this template

See a cash shortfall months before it arrives. Enter expected receipts and payments by month; the forecast carries the closing balance forward, highlights months where cash goes below your minimum and shows the lowest balance of the year, which is the number a lender or investor will ask about.

Who it’s for

  • Annual planning
  • Loan and overdraft applications
  • Seasonal businesses

What’s included

  • Forecast sheet: Receipts and payments for each month.
  • Settings sheet: Starting point and safety level.

How to use it

  1. 1Type your opening bank balance and minimum cash on the Settings sheet.
  2. 2Enter receipts and each group of payments for every month.
  3. 3Look for months marked Below minimum and plan around them.
  4. 4Update with actuals each month and re-read the low point.
Related searchescash flow forecast12 month cash flowcash projectioncash runwaybusiness planning

Details

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

Download a copy

Downloads need a free account.

SpreadsheetCash Flow ManagementFree

12-Month Cash Flow Forecast

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

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
Beginner
Price
Free

Your copy is private to you.

More cash flow management templates

View all
13-Week Cash Flow Forecast2 sheets

Cash today

$48,000

Cash in 13 weeks

$16,750

Lowest balance

$16,750

Net cash flow by week
$6,800
$5,900
$5,000
$3,700
$3,300
W12W10W6W8W2
SpreadsheetCash Flow Management

13-Week Cash Flow Forecast

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

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