How to categorise a client's bank statement for a mortgage application
Published 11 October 2026 · ClearStatement
The short answer
Put every transaction from every account into one list, sort each one into income, committed outgoings or other spending, leave out transfers between the client's own accounts, then total each category and divide by the number of months covered. Finish by flagging anything a lender is likely to ask about.
Why it matters
Lenders compare what a client declares on the application with what their bank statements show. When the figures don't line up, or a regular payment isn't explained, the usual result is a query from the underwriter and a slower case. A clear, categorised summary lets you spot those gaps before the lender does.
Step 1: Gather every statement for the period
Collect statements for every current account the client uses, plus any credit cards if the lender asks for them. Most lenders want the most recent few months, commonly three, but requirements vary by lender and by case type (self-employed and complex income cases often need more), so check the lender's criteria first. See our note on statement periods.
Step 2: Put the transactions in one list
For each transaction you need four things: the date, the description as the bank shows it, the amount, and whether money went in or out. If you are working from PDFs, this is the slow part: retyping or copying lines out of the statement.
Step 3: Sort each transaction into a category
Use a consistent set of categories so every case reads the same way. This is the set ClearStatement starts with, grouped the way most income and expenditure summaries are laid out:
| Group | Categories |
|---|---|
| Income | Income / salary, Benefits & other income |
| Committed outgoings | Mortgage / rent, Ground rent & service charge, Council tax, Utilities, Phone, broadband & TV, Credit commitments, Debt solutions (DMP, IVA, DRO), Life & protection insurance, Other insurance, Child maintenance, Childcare & education, Adult care |
| Living costs | Groceries, Transport & travel, Clothing & personal care, Household & furnishings |
| Discretionary spending | Eating out & takeaways, Leisure, subscriptions & holidays, Gambling & crypto |
| Money moving | Pensions & investments, Savings, Transfers, Cash withdrawals, Refunds |
Card payments are where the time goes. A description such as CARD 4471 GROCER 0231 has to be read, recognised and placed, line by line.
Step 4: Take out transfers between the client's own accounts
Money moved from a current account to the client's own savings, or between two of their accounts, is not income or spending. If you count it, you count the same money twice. Keep these in a separate category and leave them out of the totals.
Step 5: Total each category and work out monthly averages
Add up each category, then divide by the number of months the statements cover. Use months covered, not the number of statement files: two accounts over three months is still three months. Where income or spending is irregular, note it rather than letting one large month skew the average.
Step 6: Check the items a lender is likely to ask about
Before the summary goes anywhere, look for transactions that commonly prompt questions:
- Gambling or betting transactions
- Payday or short-term loans, and buy now, pay later repayments
- Returned or unpaid direct debits, and unarranged overdraft fees
- Regular payments to credit providers that are not on the application
- Regular payments to or from individuals that need explaining (for example maintenance or family support)
- Large or unusual deposits, which may need their source explained
Whether any of these matters depends on the lender and the case. The point is to know about them before the underwriter asks.
Step 7: Keep a note of what you changed
Record anything you excluded or recategorised, and why. It makes the figures easy to defend if the case is queried, and it gives your compliance file a clear audit trail.
Doing it in seconds with ClearStatement
ClearStatement does the slow parts, steps 2, 3 and 5, for you. Drop in a client's PDF or CSV statements and every transaction is read in your browser, matched against your category template and totalled, with monthly averages across all the statements you add. Anything the template can't place can be sorted with optional AI categorisation, after you confirm what is sent, or assigned yourself in one click. You then export an Excel workbook or a print-ready PDF summary for the case file.
The statement files are never uploaded, and we don't store client data on our servers. Always review the results before relying on them.
More guides
ClearStatement is a productivity tool for mortgage professionals. This guide is general information, not financial or legal advice; always follow the lender's own criteria.