Convert AIB bank statements to Excel or CSV

AIB customers can export a CSV from Historical Transactions, but only for the previous two years. eStatements stay available for up to seven, so anything older, such as an earlier tax year or a mortgage application asking for history, comes from the PDF. If you'd rather have those statements as rows in Excel or CSV than pages to retype, start here.

Page 1 free, no sign-up to see it; just an email to download. The whole document is one payment: $9 up to 25 pages, priced by page count above that. No subscription.

Several statements? Drop up to 100 at once: one payment for all of them, priced by their total pages.

See pricing

98% of numbers correct on 82 hand-checked pages How we measure

How to get your AIB statement into Excel

  1. Download the PDF statement from AIB online banking

    • Log in to AIB Internet Banking.
    • Click on Accounts, select Statements and Fees, and click on Statements.
    • Choose the account and statement date; AIB presents the eStatement in Adobe PDF format (in the app, tap the download icon).
    • Save the statement for the period you need as a PDF.
    Go to AIB Online Banking
  2. Upload it here

    Scans and phone photos work too.

  3. Download Excel, CSV, or QuickBooks and Xero CSV

    Check the rows against the statement, then export.

Sample result

Your AIB statement in Excel

Made-up sample rows, not a real statement.

sample-statement-2026-01.xlsx Jan 2026 · EUR
Sample bank statement rows with made-up data, amounts in EUR
Date Debit Credit Balance
2026-01-02 Salary - Example Employer Ltd 2,500.00 3,500.00
2026-01-05 Card payment - Sample Grocery Co 120.00 3,380.00
2026-01-09 Rent - Placeholder Properties 1,200.00 2,180.00
2026-01-14 Transfer from savings 300.00 2,480.00
2026-01-20 Utility bill - Demo Energy Co 80.00 2,400.00
2026-01-27 Card payment - Fictional Coffee Co 15.00 2,385.00

Statement notes

What to know about AIB statements

Two years of CSV, seven of PDFs

Historical Transactions goes back two years and exports a CSV for a current account or credit card. eStatements cover up to seven years. When the period you need falls between those two limits, the eStatement is the only digital record, and converting it gives you the same kind of rows the export would have.

SEPA and card details on extra lines

Card and SEPA transfer details on AIB statements often wrap onto extra lines under the transaction. Pasted into a spreadsheet, one payment becomes two or three rows. The conversion joins those lines into a single description, so each payment keeps its date and amount on one row.

Euro amounts Excel can add up

Amounts printed with a euro sign or comma thousands separators often paste into Excel as text that won't sum. In the output they are plain numbers. Debits and credits, which AIB prints in separate columns beside the balance, become one signed amount per transaction.

Visa debit codes in the narrative

The statement narrative uses short codes for card activity: VDP for a Visa debit purchase at a point of sale, VDC for a contactless payment and VDA for a withdrawal at a non-AIB ATM. They stay in the description after conversion, so a filter in Excel separates card spending from transfers and direct debits.

Output and review

From AIB PDF to your books

Accounting tip

Xero takes the Xero-ready CSV through its manual bank statement import, where Date and Amount are the only required columns and money out is a negative amount. After the first import Xero remembers how you mapped the columns, which saves time when you're loading several years of statements.

  • Checked before export

    Opening balance plus transactions is checked against the closing balance. Duplicate or missing periods are flagged.

  • Export formats

    Excel, CSV, JSON, or QuickBooks and Xero CSV.

    Files for QuickBooks Online

    Files for Xero

  • Private workspace

    HTTPS uploads, kept private until you ask support to delete them.

FAQ

AIB statement questions

How do I get AIB transactions older than two years into Excel?
Historical Transactions only reaches back two years, so use the eStatements, which are kept for up to seven. Save the PDFs for the months you need and upload them together. Each eStatement is reconciled from its opening to its closing balance, and missing or overlapping months are flagged before you export.
Does AIB's export include credit card transactions?
Yes. In Historical Transactions you can choose a current account or a credit card before you click Export, so the last two years of either can be exported directly. For older credit card or current account periods, convert the eStatement PDFs here instead.
Can I import converted AIB rows into QuickBooks or Xero?
Yes. Review the rows, then export a QuickBooks or Xero CSV.

Convert your AIB statement to Excel

Page 1 free, no sign-up to see it; just an email to download.

pdf2text is independent and not affiliated with or endorsed by AIB.