Bank Statement Analysis: From PDF to a Number You Can Defend
Extraction gives you rows. Analysis is what turns those rows into a decision — and every metric below is only as good as the reconciliation underneath it.
Convert one file free — see the table land in Excel
Free daily conversions · running-balance verification · CSV and Excel export.
Where statement analysis goes wrong
Unreconciled inputs
If the running balance was never checked, a misread digit quietly distorts every average, ratio, and trend you compute from it.
Deposits counted as revenue
Transfers between the owner’s own accounts, loan proceeds, and refunds inflate revenue if they are not filtered out.
Average balance computed on closing balances
Month-end balances hide intra-month dips — exactly the dips that matter for daily-balance lenders.
NSF and overdraft activity missed
These appear as small fees in an unlabeled block, not as a flag, unless you look for them explicitly.
Too short a window
Three months of statements cannot show seasonality; twelve can. Comparing a peak quarter to a trough quarter is not analysis.
Account mix ignored
One operating account tells a very different story from an operating account plus a payroll account plus a merchant processor feed.
The metrics that carry weight
- Average daily balance — computed from daily closing balances, not month-end snapshots.
- Deposit consistency — number of months with deposits, coefficient of variation across months.
- Revenue concentration — how much of total deposits comes from the top one or two sources.
- Negative days — days the account closed below zero, and how deep.
- NSF/overdraft count — frequency matters more than the dollar amount of fees.
- Debt service coverage — recurring loan and lease payments against average monthly deposits.
Building the workbook
Reconcile each statement first
Opening balance plus credits minus debits must equal the closing balance. Do this before any analysis; a broken statement invalidates everything downstream.
Normalize into one ledger
One sheet per account, consistent columns, plus a source file column. Multi-month files should not create duplicate header rows.
Tag non-revenue deposits
Owner transfers, loan proceeds, refunds, and inter-account moves. This single step changes most revenue figures materially.
Compute by month, then aggregate
Monthly totals make seasonality and consistency visible; the aggregate alone hides both.
What lenders are actually testing
Most short-term lenders are looking for evidence that deposits recur, that the business can absorb a payment, and that nothing is collapsing. Consistency beats size: a modest but steady deposit stream supports more debt than a volatile larger one.
That is why statement analysis is a verification exercise. The number is not interesting; the ability to trace it to a page — and to show the arithmetic holds — is what makes the file usable.
Frequently asked questions
How many months of statements are needed?+
Three months is the floor for most short-term lending; six to twelve shows seasonality and trend. With fewer than three, most patterns are indistinguishable from noise.
Can I analyze scanned statements?+
Yes, with OCR plus reconciliation. Any row the reconciliation flags should be checked against the page image before being used in a metric.
What is the most misleading metric?+
Average balance computed from month-end balances. It hides intra-month lows, which are precisely what a daily-balance product is exposed to.
How do I handle accounts with no running balance?+
Verify against the statement summary: opening plus total credits minus total debits equals closing. If the statement does not print both, treat the analysis as unverified.
Is this financial advice?+
No. This is a description of common analysis practice and the checks that keep it honest; credit decisions and their regulatory responsibilities stay with the lender.
Keep reading
Done reading? Convert a document and check the output yourself.
Convert a statement first