Convert AIB (Allied Irish Banks) CSV to QBO / QFX / OFX
Drop your AIB (Allied Irish Banks) CSV or Excel export below and get a AIB (Allied Irish Banks) → QuickBooks/Quicken/Xero file in seconds. Private — nothing leaves your browser.
Advanced — bank identifiers (for "file not recognized" issues)
QuickBooks/Quicken use INTU.BID to recognize the file. Pick your bank above to autofill, or paste your own.
Free: up to 25 transactions per file. Pro (one-time $29): unlimited.
How to export your transactions from AIB (Allied Irish Banks)
Export via AIB Internet Banking (web) using 'Historical Transactions', available for current accounts and credit cards. Steps: log in > select the account from the dropdown at top > open Historical Transactions / Recent Transactions (defaults to 1st of previous month up to yesterday) > optionally re-filter the date range > click 'Export' > open or save the file. For AIB iBusiness Banking (iBB): Account Information > Export Transactions > choose account > 'Export Now' (max 3 months per export). The AIB mobile app shows transactions but CSV export is via Internet Banking. Format offered is CSV (opens in Excel); PDF statements are separate. AIB does NOT offer OFX/QFX/QBO and has NO INTU.BID; QuickBooks/Xero link to AIB via Open Banking / supported direct feeds (AIB customers had to re-validate after the Open Banking upgrade), not OFX file import. Page value: 'AIB only gives you CSV; here is how to make a QBO/OFX QuickBooks will accept.' CSV has a HEADER ROW. AIB ROI column order: Posted Account, Posted Transactions Date, Description1, Description2, Description3, Debit Amount, Credit Amount, Balance, Posted Currency, Transaction Type, Local Currency Amount, Local Currency. Quirks: (1) SEPARATE Debit Amount and Credit Amount columns (NOT one signed column) - combine into a signed amount (credit positive, debit negative). (2) Date format DD/MM/YYYY. (3) Description split across THREE columns (Description1/2/3) - concatenate for the OFX payee/memo. (4) Posted Currency is usually EUR for AIB ROI; AIB GB / AIB (NI) / First Trust accounts (aibni.co.uk / aibgb) are in GBP. (5) Balance is a running ledger balance.
Once you have the file, drop it into the converter above. LedgerBridge auto-detects the date, amount and description columns — adjust the mapping if needed, choose QBO for QuickBooks (or QFX for Quicken, OFX for Xero), and download.
Tips for AIB (Allied Irish Banks) files
- Choose DD/MM/YYYY as the date format if auto-detect guesses wrong.
- If withdrawals come in as positive numbers, tick “Flip amount sign”.
- For credit-card exports, set the account type to Credit card.
- If QuickBooks rejects the file, open Advanced and confirm the INTU.BID — selecting “AIB (Allied Irish Banks)” in the bank dropdown autofills it.
FAQ
How do I export a CSV from AIB (Allied Irish Banks)?
Export via AIB Internet Banking (web) using 'Historical Transactions', available for current accounts and credit cards. Steps: log in > select the account from the dropdown at top > open Historical Transactions / Recent Transactions (defaults to 1st of previous month up to yesterday) > optionally re-filter the date range > click 'Export' > open or save the file. For AIB iBusiness Banking (iBB): Account Information > Export Transactions > choose account > 'Export Now' (max 3 months per export). The AIB mobile app shows transactions but CSV export is via Internet Banking. Format offered is CSV (opens in Excel); PDF statements are separate. AIB does NOT offer OFX/QFX/QBO and has NO INTU.BID; QuickBooks/Xero link to AIB via Open Banking / supported direct feeds (AIB customers had to re-validate after the Open Banking upgrade), not OFX file import. Page value: 'AIB only gives you CSV; here is how to make a QBO/OFX QuickBooks will accept.' CSV has a HEADER ROW. AIB ROI column order: Posted Account, Posted Transactions Date, Description1, Description2, Description3, Debit Amount, Credit Amount, Balance, Posted Currency, Transaction Type, Local Currency Amount, Local Currency. Quirks: (1) SEPARATE Debit Amount and Credit Amount columns (NOT one signed column) - combine into a signed amount (credit positive, debit negative). (2) Date format DD/MM/YYYY. (3) Description split across THREE columns (Description1/2/3) - concatenate for the OFX payee/memo. (4) Posted Currency is usually EUR for AIB ROI; AIB GB / AIB (NI) / First Trust accounts (aibni.co.uk / aibgb) are in GBP. (5) Balance is a running ledger balance.
Is my AIB (Allied Irish Banks) data uploaded anywhere?
No. The conversion happens entirely in your browser. Your statement and account number never leave your device — safe even for client confidentiality requirements.
Will the file import into QuickBooks?
Yes. We generate a valid OFX 1.0.2 (SGML) document with the correct header and identifiers. Convert a small file free first to confirm it imports cleanly, then unlock unlimited.