Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesFinanceCash Flow ManagementCash Flow & TreasuryDaily Cash Position Report

SpreadsheetCash Flow & TreasuryFree

Daily Cash Position Report

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

Shown with sample data

Colour

Daily Cash Position Report

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

Total cash
$178,550
Projected close
Available to spend
$168,450
Net movement today
-$45,090
Accounts to top up
1
Projected close by type
  • Savings$120,000
  • Operating$53,400
  • Tax reserve$31,500
  • Merchant / PayPal$9,050
  • Payroll-$35,400
Share of projected close by type
  • Savings$120,00056%
  • Operating$53,40025%
  • Tax reserve$31,50015%
  • Merchant / PayPal$9,0504%

How to use it

  1. 1Update each account’s opening balance from online banking.
  2. 2Enter receipts and payments expected today.
  3. 3Record restricted amounts such as deposits held.
  4. 4Move cash into any account flagged Top up.

In this workbook

  • About
  • What’s included
  • How to use

About this template

Start each day knowing how much cash you can use. List every bank and cash account with its opening balance, what is expected in and out today and any amount you cannot touch; the report shows projected closing balances, total available cash and accounts that need a transfer.

Who it’s for

  • Businesses with several accounts
  • Tight-cash periods
  • Daily finance stand-ups

What’s included

  • Position sheet: One row per account.
  • Summary by Type sheet: Projected close and Available and the number of entries for each type, calculated from the Position sheet.

How to use it

  1. 1Update each account’s opening balance from online banking.
  2. 2Enter receipts and payments expected today.
  3. 3Record restricted amounts such as deposits held.
  4. 4Move cash into any account flagged Top up.
Related searchesdaily cash positioncash reportbank balancestreasuryliquidity

Details

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

Download a copy

Downloads need a free account.

SpreadsheetCash Flow & TreasuryFree

Daily Cash Position Report

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

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 & Treasury
Sheets
2
Setup
10 min
Level
Beginner
Price
Free

Your copy is private to you.

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