How to Convert an Ulster Bank PDF Statement to CSV or Excel
Anytime Internet Banking will export to Excel. The statements that need converting are the ones it cannot reach any more.
Northern Ireland, one platform, seven years
Ulster Bank in Northern Ireland is part of NatWest Group and shares its online banking platform with NatWest and RBS. In Anytime Internet Banking, choose Statements & transactions, then View transactions, pick the account and the dates, and select Export to Excel or Download PDF. You can search up to seven years of history, provided the account was open throughout.
Northern Ireland is part of the UK for tax, so everything here runs on HMRC rules: a company in Belfast files with HMRC and Companies House exactly as one in Leeds does.
Republic of Ireland accounts have closed. Ulster Bank has withdrawn from the Republic and its accounts there no longer exist, so there is no online banking to export from. If you kept the PDF statements, they are now the record, and they convert the same way as any other statement.
That second group is where the converter matters most: a business, a landlord or an accountant holding years of PDF statements from an account that has gone, with no export button anywhere to press.
Quick answer: Ulster Bank Northern Ireland exports transactions from Anytime Internet Banking to Excel or PDF, with up to seven years of history. Ulster Bank accounts in the Republic of Ireland have closed, so their saved PDF statements are the only record. Convert those, and any statements a client has sent you, to CSV.
Which statements actually need converting
For a live Northern Ireland account, Export to Excel is often the quickest route. Convert the PDF instead when:
- The account has closed, including any Ulster Bank account in the Republic of Ireland.
- A client has sent PDFs rather than giving you access, which is how most year-end work arrives.
- The statements are paper, scanned or photographed. The converter reads those as well as native PDFs.
HMRC sets the floor for how long the records have to survive. A sole trader keeps them for at least five years after the 31 January filing deadline for the tax year, so a year's records can need keeping for nearly seven years. A limited company keeps them for six years from the end of the financial year they relate to. Where the account has closed, those records have to come from the PDFs you kept.
Where each route stops
| Route | Formats | How far back |
|---|---|---|
| Anytime Internet Banking: transactions | Excel, PDF | Up to 7 years, if the account was open throughout |
| Statements | Up to 7 years | |
| Closed Republic of Ireland accounts | Saved PDFs only | No online access |
Ulster Bank publishes the seven-year figure for Anytime Internet Banking. Card accounts can show a shorter range, so check the dates the interface offers before relying on an export for a full year of card spending.
Converting the statements (4 steps)
- Download the PDF statements from Ulster Bank
Sign in to Anytime Internet Banking, open Statements & transactions and download the PDF statements for the period. For a closed account, gather the PDFs you saved at the time. - Open the converter
Register free at reconcileiq.com/bank-statement-converter, then open Bank Reconciler and the PDF converter inside it. - Upload the statements together
Drag in several months at once. Each statement is read on its own and the transactions come back as one continuous set, so there is no stitching files together afterwards. - Check the output, then download
The extracted transactions appear on screen before you download anything. Check the first and last rows against each statement's opening and closing balance, then export as CSV.
Always check the balances: every Ulster Bank statement prints an opening and a closing balance. If the converted rows carry you from one to the other, nothing was missed. It takes ten seconds and it is the only real proof of completeness, from any tool, including this one.
What comes out
Each Ulster Bank statement becomes rows of date, description, a single signed amount and the running balance, with money out and money in merged into one column and multi-line descriptions joined back together. Dates come out in one consistent order, and the page headers, footers and summary boxes are left behind.
Page furniture is discarded: repeated column headers, page numbers, summary boxes and the small print on the last page. What you get is transactions and nothing else.
Convert Your Ulster Bank Statement
Upload the PDF, check the numbers on screen, download clean CSV. Your first statement of up to 10 pages converts free on a new account.
Convert your PDF now for freeFrequently Asked Questions
Anytime Internet Banking exports transactions to Excel or PDF from Statements and transactions, then View transactions. The Excel file can be saved as CSV from any spreadsheet.
Up to seven years in Anytime Internet Banking, provided the account was open throughout that period.
Yes. Those accounts have closed, so there is no online export, but any PDF statements you saved convert to CSV in the same way, including scans of paper statements.
Yes. Northern Ireland businesses deal with HMRC and Companies House, so UK record-keeping rules apply: five years after the 31 January deadline for sole traders, six years from the end of the financial year for companies.
Your first statement of up to 10 pages converts free on a new account. Beyond that it runs on credits, and the cost per conversion is shown before anything is processed. Files are processed on our servers rather than in your browser, which is what lets scanned and photographed statements work as well as native PDFs.