How Mortgage Brokers Analyse Bank Statements

This is the broker's side of the desk. If you want the underwriter's lens — how a lender scores affordability and cash flow once the file arrives — read the cash flow analysis for lending guide instead.

What a broker is actually looking for

An underwriter has a checklist. A good broker has the same checklist, run earlier, so nothing on it is a surprise when the case is keyed. Here's what we're reading the statements for, roughly in the order it tends to matter.

• Affordability evidence that matches the application. Regular income landing on regular dates, and enough left after the fixed outgoings to carry the new payment. If the client's account empties every month before salary lands, no amount of presentation hides it — better to know now and adjust the loan size than have it bounced at underwriting.
• Deposit source and provenance. This is the broker-specific one. A lender will ask where the deposit came from, and "savings" is not an answer they accept on faith. Every large credit into the account needs a clean, evidenced story: a property sale, a documented gift, a bonus that shows on a payslip, an ISA transfer. Anything unexplained holds the whole case up.
• Undisclosed debt. Payments to other lenders, car finance, payday firms or buy-now-pay-later providers that never reached the fact-find. This sinks more applications than anything else, because it changes the affordability sum and the trust at the same time. Find it before the lender does and you can declare it; find it after and the case looks dishonest.
• Conduct signals. Bounced direct debits, unpaid-item fees, a balance living below zero, frequent transfers to betting accounts. Underwriters price these as risk, not morality — but they price them.
• Anything that contradicts the rest of the file. Rent of 900 a month on the application but 1,200 leaving the account; a "single" applicant with a regular transfer to a joint account. The statements are the one document the client can't easily dress up, which is exactly why they get read closely.

Every signal on that list inherits whatever is wrong in the data underneath it. That's the part most reviews rush.

Why the file has to reconcile before you read it

Almost every statement a broker handles is a PDF — emailed by the client, downloaded from online banking, or scanned from paper. Two things go wrong with that, and both land on the broker.

PDFs are easy to alter. A figure changed in a free editor looks completely convincing, and a screenshot of a balance proves nothing on its own. A client under deposit pressure has a motive. You don't want to be the broker who packaged an edited statement and didn't notice.

And turning a PDF into something you can sort and total slips in predictable spots. A row drops in the join between two pages. A 1,290.00 debit reads as 1,920.00 when the digits flip. A credit lands in the debit column. None of those announce themselves — the spreadsheet looks tidy and is quietly wrong.

The honest defence against both is arithmetic, not eyesight. A complete, genuine statement reconciles down its own column: opening balance, add every credit, subtract every debit, and you land on the closing balance the bank printed. If it doesn't tie out, a line is missing, a figure was misread, or the statement was altered. You can't always tell which from the number alone, but you know not to build a case on it yet.

Doing that by hand across six months and several hundred lines is slow, dull and easy to get wrong — so it gets skipped, and the gap is where altered statements and conversion errors both hide. This is what Export Bank Statement is built to close. When it converts a statement PDF — or a scanned or photographed one, using OCR — to Excel or CSV, it walks the running balance from opening to closing and flags any statement that doesn't reconcile, rather than handing back tidy-looking numbers that are short a line. So before you start tracing deposits or totalling outgoings, you already know the figures underneath are internally consistent. Most converters just extract and hope. For a file you're putting your name to, that isn't enough.

Evidencing the deposit source

This is where broker analysis goes beyond what an underwriter does, because it's the broker's job to have the answer ready before the question is asked. Lenders treat the deposit as a fraud and money-laundering checkpoint, so every chunk of it needs a traceable origin.

Work backwards from the deposit figure. Sort the converted statements by amount and look at the large credits. Each one falls into a category, and each category needs its own paper: a gift needs a signed gifted-deposit letter and the giver's own evidence; proceeds of a sale need the completion statement; an ISA or savings transfer needs the source account shown; a bonus needs the matching payslip. A credit you can't place — a round-number transfer from an unnamed account, cash paid in over a few weeks — is the one that stalls the case, so you chase it now, not after submission.

The reason this only works on reconciled data: if a credit was misread or a line dropped in conversion, the deposit you're evidencing might not match the deposit the lender's own systems reconstruct. Tie the file out first, then trace.

How a mortgage broker analyses bank statements, step by step

This is the workflow we'd actually follow before packaging a residential case. Adjust the months and documents to the lender's policy.

1. Collect the full period. Three months for straightforward employed income, six to twelve for self-employed, contractor or anyone with a complex deposit. Full statements, every page, including the ones with no transactions — the running balance has to be unbroken for any check to mean anything.
2. Convert to a working format. Turn each PDF into a single Excel or CSV at /convert so you can sort, filter and total across the period. Copy-pasting from a PDF reorders columns and drops minus signs; a proper conversion keeps money in, money out and balance aligned.
3. Confirm every statement reconciles. Check the totals tie out before reading a thing into them. A flagged statement means a gap a skim would have missed — go back to the client or the source before you go further.
4. Trace the deposit. Match every large credit to an evidenced source and note what document covers it. Flag any credit you can't place and chase it before submission.
5. Verify the income. Match regular credits to payslips or invoices, strip out internal transfers and refunds, and for self-employed clients judge the trend across the period rather than any single month.
6. Total the debt. Sort by description, add up existing repayments and short-term credit, and cross-check against the fact-find. Anything found here that isn't declared gets declared.
7. Pressure-test affordability. Set genuine fixed outgoings against verified income, look at the lowest point the balance reaches each month, and compare the surplus to the proposed payment. If it's tight, you've found it before the underwriter did.
8. Write the notes. Package the file with a short explanation of anything that would otherwise draw a query — the one-off credit, the gambling that stopped four months ago, the lumpy self-employed month. Pre-empting questions is most of what good packaging is.

Steps four to seven take minutes once the data sits in a clean spreadsheet. That speed is the entire point of step two.

A worked example

A self-employed first-time buyer, six months of statements, a 40,000 deposit, around 150 transactions a month. On a quick read the income looked comfortably above the stated figure and the deposit was sitting in the account. But footing the third month, page five didn't tie out — two lines had collapsed onto one during a copy-paste, hiding a 1,290.00 finance payment. The reconciliation check caught it in seconds.

With the file reconciled, the real picture showed. Around a third of the "income" was transfers between the applicant's own accounts, so the genuine figure was lower and the loan needed resizing. The finance payment was undisclosed and went straight onto the declaration. And the deposit wasn't one clean lump — 12,000 of it had arrived as a transfer from a family member three weeks earlier, which meant a gifted-deposit letter and the giver's evidence, not "savings". None of that was visible in the closing balance. All of it was obvious once the statement reconciled and the credits were sorted. Submitted as first read, the case would have come back with three queries and a slower decision; packaged properly, it went through clean.

The built-in analyser, and what the tool doesn't do

Once a statement reconciles, the built-in analyser does the grouping for you: cash flow across the period, income verification, expenses by category, and recurring or merchant detection that surfaces standing commitments and subscriptions quickly. Because it runs on data you've already proved complete, every figure inherits that completeness. The judgement still belongs to the broker — the tool gives clean figures and a clearer view of the client's file; it doesn't decide affordability, and it isn't a bookkeeping service.

To be precise about importing: Export Bank Statement can export CSV in the native bank-import format Xero, QuickBooks and Zoho Books expect, so if you keep client records in accounting software the lines drop in as reconcilable statement entries. That's a file import — you convert, then import the CSV. It does not push transactions into a ledger through a live bank-feed API; that needs partner certification this tool doesn't claim. For most mortgage packaging a reconciled Excel file is all you need.