Convert AIB Bank Statement to Excel
An AIB current account statement opens with a BALANCE FORWARD line, then runs Date, Details, Debit €, Credit € and Balance € across the page, marking overdrawn positions with a small dr suffix. Faithful as that layout is, transcribing it by hand is miserable: the balance appears at the end of each day rather than on every line, abbreviations like *INET, POS, DD and S/O need decoding, and one misread dr turns a negative into a positive in your accounts. SheetMyBank understands AIB’s exact column structure, so debits and credits land in separate columns, overdrawn figures keep their correct sign, and euro amounts arrive in Excel as real numbers rather than text that refuses to sum.
Download eStatements by logging in to AIB Internet Banking and going to Accounts, then Statements and Fees, then Statements; in the AIB Mobile app, tap an account’s three dots, choose Statements, then Account statements, and use the download icon in the top-right corner. Statements issued after 30 November 2011 stay available for up to seven years. Everything SheetMyBank does happens locally in your browser — the PDF is never transmitted — and the converter reconciles each day’s Balance € figure against the summed debits and credits, catching extraction faults before they ever reach your spreadsheet.
Drop your AIB statement here (PDF or photo)
Processed entirely on this device — nothing is uploaded. Scans and photos are read with on-device OCR (beta).
Free for your first 5 pages each month · Processed on your device · Balance-verified output
AIB statement FAQ
How are overdrawn amounts marked with the dr suffix handled?
The parser recognises AIB’s dr notation and records those balances as negative numbers in the output, so an overdraft of 189.50dr appears as -189.50 and your running totals stay mathematically honest.
What happens to the BALANCE FORWARD line?
That line is the closing balance from your previous statement, and SheetMyBank uses it as the anchor for its reconciliation — every subsequent balance on the statement must flow logically from it, or you get a warning.
AIB only sends me one statement a year — can I get more frequent ones?
By default AIB issues current account statements annually on your account anniversary, but you can request them free of charge as often as monthly. Whatever period you choose, the converter handles it — a twelve-month statement just makes a longer spreadsheet.