Bank statement analysis for lenders and brokers: from PDF to a verified spreadsheet

How mortgage brokers, non-QM lenders and MCA underwriters turn 12 to 24 months of borrower statements into analysable spreadsheets, with balances verified and the documents kept in-house.

Income verification from bank statements, whether for self-employed borrowers, bank-statement mortgage programs or merchant cash advance underwriting, means extracting deposits, identifying transfers and NSF events, and computing average balances across a year or two of statements. Done by hand it takes hours per file; done with an unverified converter it produces spreadsheets nobody trusts.

What underwriters need from the conversion

• Every deposit with date, description and amount, so transfers between the borrower's own accounts can be excluded.
• Running balances to compute average daily balance and count negative-balance days.
• NSF/overdraft fee lines, which most programs treat as red flags.
• A verifiable link back to the statement: page number and the printed balance next to each row.

Rowledger's Excel-friendly export includes the page number and printed balance on every row, and the Summary sheet states whether the rows reconcile to the statement's own opening and closing balances.

Workflow for a 12- or 24-month file

1. Batch-convert all statements (Pro). Each file shows its own reconciliation badge; statements with a mismatch are obvious before analysis begins.
2. Export a merged workbook covering the entire period, sorted by date.
3. In Excel, add a Type column (deposit / transfer / NSF) using filters on the description, then pivot by month.
4. Keep the individual QBO/CSV exports with the loan file for audit.

Security posture

Borrower statements are non-public personal information. Because Rowledger runs in the browser on the underwriter's machine, the documents never leave your environment, nothing is retained by a third party, and no additional vendor due diligence is required for the conversion step.

Limitations to know

• Rowledger extracts and verifies; it doesn't classify deposits as income. That judgement stays with the underwriter.
• Photographed statements can contain OCR errors; the balance check flags them, but someone must fix them.
• Fabricated statements are not detected by arithmetic alone. Reconciliation confirms internal consistency, not authenticity.