How to Convert a Bank of Scotland PDF Statement to CSV or Excel
Bank of Scotland will hand you a CSV for recent activity. The statements that fall outside it are where most year-end work happens.
A real CSV export, for recent transactions
Bank of Scotland is part of Lloyds Banking Group, alongside Lloyds and Halifax, and its business banking gives you a proper export. In Business Internet Banking, select View statement next to the account, then Statement options, then Export transactions, and choose CSV or QIF.
For this month's transactions on a live business account, that is the quickest route and you should use it.
Where it runs out: the export works from the transactions the statement view holds. Archived statements, earlier years and anything a client has sent you are PDFs, and that is the format a year-end, a mortgage application or an HMRC enquiry tends to arrive in.
Larger businesses on Commercial Banking Online have a separate platform with its own export tools. The steps here are for Business Internet Banking, which is what most sole traders and small companies use.
Quick answer: Bank of Scotland Business Internet Banking exports recent transactions as CSV or QIF from View statement, Statement options, Export transactions. For archived statements, earlier years, or PDFs a client has sent you, convert the PDF statements to CSV instead.
Why the PDFs still matter
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. The years a bookkeeper or accountant gets asked about are rarely the current one, which is why so much Bank of Scotland data turns up as PDF statements rather than as an export.
Personal Bank of Scotland accounts follow the Lloyds Banking Group layout. If you cannot see an export option for the account, or the period you need is older than it reaches, the PDF statements are the route.
Where each route stops
| Route | Formats | How far back |
|---|---|---|
| Business Internet Banking export | CSV, QIF | Transactions in the statement view |
| Statements | Archived statements and earlier years | |
| Commercial Banking Online | Separate platform | Its own export tools |
Bank of Scotland documents the CSV and QIF export for Business Internet Banking. It does not publish a single cut-off date for it, so check the range on screen before relying on an export for a full year.
Converting the statements (4 steps)
- Download the PDF statements from Bank of Scotland
Sign in to Internet Banking, open the account and download the PDF statements for the months you need. Each statement period is one PDF. - 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 Bank of Scotland 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
A Bank of Scotland statement turns into date, description, one signed amount and the running balance, with paid-out and paid-in columns merged and descriptions that wrap onto a second line rejoined. The output imports into Xero, QuickBooks, Sage, FreeAgent, Pandle or a spreadsheet without a tidy-up step.
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 Bank of Scotland 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
Yes, for business accounts. In Business Internet Banking select View statement, then Statement options, then Export transactions, and choose CSV or QIF.
The export covers the transactions in the statement view. Archived statements, earlier years and statements a client has emailed are PDFs, and converting them is quicker than asking for a fresh export.
Yes. Bank of Scotland, Lloyds and Halifax are all part of Lloyds Banking Group and their statements all convert. The converter works with statements from any bank, including scans and photos.
Yes. Personal and business current accounts, savings and credit card statements all convert.
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.