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
- Savings$120,000
- Operating$53,400
- Tax reserve$31,500
- Merchant / PayPal$9,050
- Payroll-$35,400
- Savings$120,00056%
- Operating$53,40025%
- Tax reserve$31,50015%
- Merchant / PayPal$9,0504%
How to use it
- 1Update each account’s opening balance from online banking.
- 2Enter receipts and payments expected today.
- 3Record restricted amounts such as deposits held.
- 4Move cash into any account flagged Top up.
In this workbook
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
- 1Update each account’s opening balance from online banking.
- 2Enter receipts and payments expected today.
- 3Record restricted amounts such as deposits held.
- 4Move cash into any account flagged Top up.
Details
- Format
- Spreadsheet
- Category
- Cash Flow & Treasury
- Sheets
- 2
- Setup
- 10 min
- Level
- Beginner
- Price
- Free
Download a copy
Downloads need a free account.