Bank Statements for a Mortgage Application (Ireland) — Convert to Excel

What the lender is looking for

Irish mortgage lending works within the Central Bank's rules — loan-to-income and loan-to-value limits — and underwriters assess repayment capacity from your actual banking. In practice they look for:

• Steady income. Salary or drawings landing regularly, matching your stated income.
• Repayment capacity. Your regular outgoings, and evidence you already save or pay rent at a level near the future mortgage.
• Red flags. Unarranged overdrafts, missed direct debits, or heavy discretionary spending.

Having six months as sortable rows lets you see what they'll see, and present it clearly, before you hand it over.

From PDF to a clear spreadsheet

1. Download six months of statements as PDFs — AIB Internet Banking, Bank of Ireland's 365 Online, Permanent TSB's Open24 and the others keep them online.
2. Convert each to Excel or CSV. Every transaction returns as a row — date, description, debit, credit and running balance in euro — with the closing figure checked.
3. Combine the months into one sheet so the full picture is in one place.
4. Total the important lines. Sum your monthly income, your regular commitments, and your saving or rent, so the numbers a lender cares about are right there.

Why a clean version helps your application

A mortgage assessor forms an impression fast. If your statements are hard to read — payments running onto second lines, a mix of accounts — that impression is worse, and questions come back to you. A converted spreadsheet lets you show regular income and steady outgoings at a glance, and it's the same underlying data the lender has, just legible. It doesn't change what's there, but it removes friction from the read.

What the converter handles that a copy-paste won't

An AIB or Bank of Ireland statement often runs a payment's reference onto a second line. A plain copy-paste turns that into a phantom row and shifts the euro columns, which is exactly the kind of mess that makes a lender's job harder. The converter joins each reference back to its payment, so every transaction is one clean line and the balance ties out — the figures stand up to scrutiny rather than nearly matching.

Tidying the picture before you submit

Converting your statements early does more than make them legible — it lets you see your own application the way an underwriter will, in time to explain anything. Once six months are in one sheet, a few things are worth checking. Large or irregular deposits often need a source (a gift, a bonus, a transfer between your own accounts) and it's easier to have that ready than to be asked. Regular gambling transactions, frequent unarranged overdrafts, or missed direct debits stand out, and if they're there, you'd rather know before the lender points them out. And your genuine savings — the standing order to a savings account, the rent you already pay — are the strongest evidence of repayment capacity, so make sure they're clearly totaled rather than lost among everyday spending.

None of this changes what's in the account. It just means you go in understanding your own figures, which is the difference between answering a lender's questions confidently and being caught out by them.