Bank Statement Analysis: A Practical Framework
A practical framework for bank statement analysis — sort income vs expenses, spot recurring charges, track cash flow, and flag red flags.
Check a transactions CSV for months with no activity between your first and last transaction — a possible sign of a missing statement. Runs entirely in your browser.
Upload a transactions CSV and this tool groups it by calendar month, then lists any month between your earliest and latest transaction that has zero parsed transactions. A gap can be a sign that a statement is missing — useful when you're gathering a continuous run of statements for a loan, rental, or visa application.
Dates are grouped by year and month with exact integer arithmetic. Rows whose date can't be read are counted as ambiguous or unrecognized and shown separately, so you can tell when the result is reliable.
Once you've confirmed the months you have, the bank reconciliation matcher and cash-flow summary help you check the figures within them.
A practical framework for bank statement analysis — sort income vs expenses, spot recurring charges, track cash flow, and flag red flags.
A plain-English explanation of bank reconciliation — what it is, why it matters, and a simple worked example matching your books to your bank statement.