How to Convert AIB Bank Statements to Excel

There are two ways to get your AIB transactions into a spreadsheet, and which one you use comes down to a single question: do you still have the statement in online banking, or only as a PDF?

If the account is open and the transactions are recent, you can skip a conversion step entirely. AIB Internet Banking and the Mobile Banking app let you export recent transactions to Excel and historical transactions to CSV. That export is the right first move whenever it works — but it works only while the account is open and only within a limited date range.

The moment you are holding a PDF instead, that route closes. A formal or archived statement that AIB issued as a PDF, a statement from an account that has since been closed, or a client's PDF that you have no online-banking access to — none of these can be reached through the export. To convert AIB bank statement to Excel in those cases, you upload the PDF to a data-extraction tool, specify the columns you need (date, description, debit, credit, balance), and download a structured Excel or CSV file.

So the decision is straightforward. Live account with recent data inside the export window: use AIB's native export. A PDF, an out-of-range period, or a closed account: convert the PDF. The rest of this guide covers both — the native export and its honest limits first, then the PDF conversion that takes over where the export stops, and finally how the finished spreadsheet feeds your Irish books.

Export Recent and Historical Transactions From AIB Online Banking

Before reaching for any converter, check whether AIB will hand you the data directly. Through AIB Internet Banking and the Mobile Banking app, you can export recent transactions to Excel and historical transactions to CSV. For a live account where you simply need the figures in a sheet, this is the fastest route and worth trying first.

The reason most guides stop here is that they never tell you where it stops working. Two limits matter. The export is range-bound: it covers a defined window of transactions, not any arbitrary historical period you choose. And it is available only while the account is open. Close the account and the door to the export closes with it. There is no way to reach a historical period that has aged out of the window, and no way to export anything at all once the account no longer exists in online banking.

There is a second, quieter distinction. The native export gives you transaction data, not the formal statement document. When you need the official statement exactly as AIB issued it — for an accountant, a lender, or your own records — the exported sheet is not the same artefact. The formal statement arrives as a PDF, and a CSV of transactions does not replace it.

So the native export is the correct, complete answer in one specific situation: the account is open, the data you want sits inside the available range, and a spreadsheet of the figures is all you need. Step outside any of those conditions — a period that has aged past the export window, an account that has been closed, or a statement that only ever existed as a PDF — and the export cannot help you.

When a PDF Statement Is the Only Thing You Have

Three situations come up again and again, and in each one the PDF is the only source you have to work from.

The first is the formal or archived statement. AIB issues its official statements as PDFs, and an older one pulled from your records is exactly that — a document, not a live feed you can re-export. The data inside it has often aged past the export window, so even with the account open, online banking will not reproduce it.

The second is the closed account. Once an account is closed, it leaves online banking, and with it goes any ability to export. If a PDF statement is all you kept, that PDF is now the complete record of what happened on the account.

The third is the one bookkeepers and accountants meet most often: a client hands over PDF statements and you have no online-banking access to that client's account. You cannot export what you cannot log into. The client may not have the data in range either, or may simply have sent the formal statements because that is what they had to hand.

Each of these blocks the native export for a specific reason — the dates are out of range, the account is gone, or the access was never yours to begin with. Converting the PDF is not a workaround for these cases; it is the standard route. An AIB statement converter takes the PDF you were actually given and produces the spreadsheet the export cannot. And the pressure is usually real: these statements tend to need turning into clean data right before a filing deadline or a handoff to an accountant, which is precisely when re-keying rows by hand is the last thing you want to be doing.

How an AIB Statement Is Laid Out

Knowing the shape of the source document tells you exactly what a clean conversion has to capture, and how to check it once it is done.

An AIB statement is organised into columns: the transaction date, a description or narrative, separate columns for debits (money out) and credits (money in), and a running balance. The detail worth noting is that AIB keeps debits and credits in two distinct columns rather than collapsing them into a single signed amount. That gives you a choice when you convert. You can preserve the paired debit and credit columns as AIB presents them, which mirrors the statement most closely, or derive a single signed amount column — positive for credits, negative for debits — which many bookkeeping imports prefer. Neither is more correct; it depends on what the downstream system expects.

The narrative field is where AIB labels each transaction: the descriptive text that identifies a card payment, a direct debit, a standing order, a SEPA transfer, or a lodgement. Preserve it in full. It is the only thing that tells you what a line actually was, and it is what you will lean on later when categorising transactions or matching them during reconciliation. A converted sheet that truncates or drops the narrative loses the information that makes the data usable.

Dates on an AIB statement follow the Irish convention, DD/MM/YYYY. When you convert, the dates need to land in the spreadsheet as real date values, not as text that merely looks like a date. The difference is not cosmetic: text dates will not sort chronologically, will not filter by period, and will break any formula that does date arithmetic. Correct date typing is what lets you pull a single month or quarter out of a year's transactions cleanly.

The running balance column carries its own quiet usefulness. Because each row's balance is the previous balance adjusted by that row's debit or credit, the balance line is a built-in check on the conversion. Carry it through, and you can confirm row by row that nothing was missed, duplicated, or misread: the converted balance should track the statement's own balance down the page. If the two ever diverge, you have found the exact line where something went wrong.

Above the transaction table, the statement header carries fields that matter once the data moves on — the account's IBAN and BIC, the account identification, and the statement period. You do not need them in every row, but they identify whose account and which window the figures belong to, which becomes important the moment a statement is handed to an accountant or filed against a return.

Converting an AIB PDF Statement to Excel or CSV

The goal is a spreadsheet that mirrors the statement and can be checked against it. Start with the AIB PDF — a single statement or several monthly statements together — and produce a sheet with one column for each field you need: date, description or narrative, debit, credit, and balance. Each column carries the right type, so the dates are real dates and the amounts are numbers you can total, and the running balance comes across intact so you can reconcile it against the statement line by line.

That last point is what separates a conversion you can trust from one you have to second-guess. Every row in the output should reference the page of the original PDF it came from, so any figure can be traced straight back to the statement it was read from. Combined with the running balance, this gives you two independent checks: the balance should track down the page exactly as it does on the statement, and any row you want to confirm points you to the source page to confirm it against. A conversion without that traceability asks you to take the numbers on faith.

Real statements are rarely a single page, and accountants rarely have just one. An AIB PDF statement can run to several pages of transactions, and a year-end might mean twelve monthly PDFs that all need to land in one consistent layout. The method has to handle both without re-keying anything — read every page of a multi-page statement, and process a stack of monthly statements into the same column structure so the whole year reads as one continuous sheet.

You also decide the columns rather than accepting a fixed template. Keep AIB's paired debit and credit columns if that is what your books expect, or consolidate them into a single signed amount if your accounting import wants it that way. The same applies to the narrative, the balance, and any header fields you want carried through.

This is where a purpose-built tool earns its place. With Invoice Data Extraction, you upload the AIB PDF and describe the columns you want in plain language — there are no templates to configure — then convert a batch of AIB statement PDFs to Excel in one job and download the result as Excel, CSV, or JSON. It reads natively typed values into the sheet, so dates arrive as dates and amounts as numbers ready for formulas and pivot tables, and it writes a source-file-and-page reference onto every row for the verification described above. The same job handles scale: a single PDF up to 5,000 pages, and batches of up to 6,000 files, which is what makes processing a client's full year of monthly statements a single pass rather than twelve separate ones.

None of this is specific to AIB. What you are doing here is the general method for converting any bank statement PDF to Excel, applied to AIB's particular layout — the same approach will convert a NAB business account statement to Excel or any other bank's. Whether you are converting a personal current account statement or an AIB business account statement to Excel, the steps are identical: read the PDF, set the columns, verify against the balance, export.

From Spreadsheet to Your Irish Books, VAT3 and Form 11

The converted spreadsheet is the start of a chain, not the end of one. Clean transaction data feeds bank reconciliation; reconciliation feeds the books; and the books feed the filings every Irish business knows by their deadlines — the bi-monthly VAT3, the annual Return of Trading Details, and the Form 11 self-assessment submitted through ROS.

Each stage leans on the quality of that first spreadsheet. To reconcile the converted transactions against your books, you need the running balance and amounts that match the statement to the cent, which is why carrying the balance through and verifying it earns its keep. To prepare figures for your Irish VAT3 return, and the RTD and Form 11 that follow, you need figures that are reliable and traceable back to the source statement, because a return is only as defensible as the records behind it. If your books live in accounting software, the same clean export lets you import the converted statement into QuickBooks rather than typing transactions in by hand.

The header fields carried over from the statement do their work here. The IBAN and BIC identify which account the figures belong to, and the SEPA references that appear in the narrative — on direct debits, standing orders, and transfers — give each payment a reference you can match against an invoice or a counterparty. For anyone reconciling supplier payments, those references are often what tie a bank line to the bill it settled.

For accountants and bookkeepers, the real gain is consistency. Processing every client's AIB PDFs at month or quarter-end into one standard layout means each client's data arrives in the same shape, the same columns in the same order, ready for the same workflow.

There is a compliance reason to keep all of this in order as well. In Ireland, a business must keep the records used to calculate its tax — including accounts, invoices, and supporting bank documents — for six years, under Revenue's record-keeping rules for businesses. The original AIB PDF and the spreadsheet you derive from it both fall inside that obligation, so a converted statement that traces cleanly back to its source is not just easier to work with now; it is the form those records should be kept in for years after the return is filed.