Daily Cash Position Report Template
Prepare a daily summary of cash balances across all accounts and locations for liquidity monitoring.
How to use this template
Collect account balances
Gather cash balances from all bank accounts including checking, savings, and sweep accounts.
Include outstanding items
Add outstanding checks, wire transfers in process, and pending deposits.
Calculate net position
Summarize total available cash and identify any cash shortage or excess position.
Compare to forecast
Analyze actual cash against daily forecast to identify variances.
Distribute report
Share the daily cash position with treasury, finance leadership, and operations as needed.
Why use this template
- Provides daily visibility into cash availability for operational and strategic decisions
- Enables proactive cash management and borrowing decisions
- Identifies timing mismatches between payables and receivables
- Supports accurate short-term liquidity forecasting
Related templates
Liquidity Forecast Model
Build a rolling cash flow forecast model to project cash position over the next 13 weeks.
Cash & TreasuryCash Flow Variance Analysis
Compare actual cash flows to forecast and analyze significant variances to improve forecasting.
Cash & TreasuryMoney Market Fund Tracking
Maintain records of money market investments including purchases, maturities, and returns.
Ready to streamline your close?
Vergo turns templates into automated workflows with real-time collaboration, integrations, and AI built in.