Cash Flow Statement Reconciliation Template
Reconcile cash flow statement to GL ending cash balance. Tie operating, investing, and financing activities to supporting detail.
How to use this template
Pull GL cash balances
Extract beginning cash, ending cash, and all cash-related GL accounts from trial balance.
Build operating activities section
Start with net income and adjust for: depreciation, amortization, deferred taxes, changes in working capital accounts.
Build investing activities section
Detail capital expenditures, asset disposals, acquisitions, and other non-operating investments made during the period.
Build financing activities section
Document debt borrowed and repaid, equity issued or repurchased, and dividends paid.
Reconcile and tie to GL
Verify: Beginning cash + operating + investing + financing = ending cash. Tie ending cash to GL balance.
Why use this template
- Explains how business generated or used cash during period
- Identifies quality of earnings and sustainability of results
- Shows liquidity and capital allocation decisions
- Critical for understanding true financial health beyond accrual results
Related templates
Monthly Financial Reporting Pack
Assemble a complete monthly financial report including balance sheet, income statement, cash flow, and key metrics. Standardize format for consistency.
Financial ReportingVariance Analysis Report
Document the drivers behind variance between actual and budgeted performance. Identify root causes and quantify impact of key variances.
Financial ReportingGAAP Reconciliation Schedule
Reconcile non-GAAP measures to GAAP financials. Document adjustments for stock-based compensation, acquisition costs, and other significant items.
Ready to streamline your close?
Vergo turns templates into automated workflows with real-time collaboration, integrations, and AI built in.