Use cases
Cash-flow analysis from statements
Build monthly cash-flow analysis from PDF bank statements: inflows, outflows, net cash flow and balance trends, in Excel.
Convert a statement free 20 free pages / month · no card
Last updated
Quick answer
Convert statements to reconciled Excel data, then pivot by month to see inflows, outflows, net cash flow and closing balances — the foundation for forecasting, lending and advisory work.
The usual problems
- No accounting system or out-of-date books
- Need for a quick view of liquidity
- Multiple accounts to combine
What changes
- Monthly inflow/outflow tables
- Balance trend charts
- Largest payees and payers
Excel recipe
- Add a Month column: =TEXT(A2,"yyyy-mm").
- Pivot Month by sum of Credit and sum of Debit.
- Net cash flow = credits − debits.
- Chart the Balance column by date for liquidity trends.
Frequently asked questions
Can I combine several accounts?
Yes, convert each account and append the Excel sheets with an Account column.
Convert your first statement in under a minute
20 free pages every month. No credit card. Every export format included.