AIB Bank Statement to Excel Converter

Converting AIB Statements to Excel

AIB statements are built to be printed and filed, not analysed. Transactions are laid out in a table with separate debit and credit columns and a running balance, and long descriptions such as card purchases or standing orders can run across the column. Copying a few pages into a spreadsheet usually merges those columns, and spreadsheet software set to US dates can swap the day and month. Finlyzers reads the table as it is printed and gives you one clean row per transaction.

What an AIB Statement Usually Contains

The exact layout depends on the account and when the statement was produced, but most AIB current account statements include:

• Header: account name, statement date range, your IBAN and AIB's BIC, and the branch National Sort Code (NSC).
• Transaction table: columns typically labelled Date, Details, Debit, Credit and Balance, with amounts in euro.
• Balance forward lines: the balance carried from the previous statement or page appears as its own line. It is a balance, not a transaction, so it is left out of the transaction list.
• Interest and charges: fees, overdraft interest or account charges appear as their own debit lines, so they can be totalled separately in Excel.

Descriptions often begin with short codes such as D/D for a direct debit or S/O for a standing order, followed by the payee. Keeping that text intact in the Details column makes it easy to filter by payment type later.

When You Still Need the PDF

AIB Internet Banking shows your recent transactions, and depending on the account and channel you may be able to export them. That is handy for this month's activity, but it does not help when:

• You need an earlier period that is only available as a statement PDF.
• The account has been closed.
• Someone else sent you their statement, for example a bookkeeping client, a tenant or a family member you help with paperwork.
• You need figures that match the official statement line for line, with the balance agreeing at the end.

In each of these cases, converting the PDF gives you the same data as the statement itself.

Common Uses in Ireland

• Self-assessed income tax: if you file a Form 11 with Revenue as a sole trader or company director, a year of transactions in Excel makes it much quicker to separate business income and expenses.
• Landlords: rental income and deductible costs such as repairs, insurance and mortgage interest can be filtered from a single spreadsheet rather than picked out of a stack of PDFs.
• Mortgage applications: lenders commonly ask for several months of current account statements. A spreadsheet helps you check regular outgoings and savings before you apply.
• Bookkeeping: small businesses and accountants can backfill Xero, Sage or QuickBooks when the bank feed does not reach far enough back.

Getting AIB Data Into Your Software

The same upload can be downloaded in several formats:

• OFX for Xero and other software that imports bank statement files.
• QBO for QuickBooks Online or Desktop.
• CSV for Sage, Google Sheets or any tool where you map the columns yourself.

Statements that run over many pages are processed in one go, and password-protected PDFs can be opened with the password before conversion. If you also bank with Bank of Ireland, the Bank of Ireland statement converter covers its layout.

Converting an AIB credit card statement? Use the credit card converter, which keeps purchases and payments in separate columns. For older paper statements you have scanned or photographed, try the scanned statement converter.