UK
Upload a Bank of Scotland statement PDF and every transaction comes back as clean rows — date, description, money out, money in and the running balance — with the closing figure checked before you download. Export to Excel, CSV, or an import file for Xero, QuickBooks or Zoho.
Bank of Scotland traces back to 1695, which makes it one of the oldest banks still trading anywhere — and it still issues its own Scottish banknotes. Behind that heritage, though, it runs on the modern Lloyds Banking Group platform, and its statements carry the short payment codes that come with it. Those codes are the thing a plain copy-paste can't handle.
Reading the payment codes
On a Bank of Scotland statement, every line opens with a two- or three-letter code that says how the money moved, before the payee. The ones you'll see most:
- DEB — a debit-card payment
- DD — a Direct Debit
- SO — a standing order
- FPI / FPO — a Faster Payment received or sent
- BGC — a bank giro credit, often wages or a refund paid in
They're useful once the statement is a spreadsheet, because you can filter every card payment or Direct Debit at once. The trouble is they sit inside the description, so exporting the PDF straight to Excel drags them into the payee text or the money column. The converter keeps each code attached to its own transaction.
The columns, and a date quirk
Column | What's in it |
|---|---|
Date | Printed once per day, so several rows can share it |
Payment type and details | The code, then the payee |
Money out | Debits |
Money in | Credits |
Balance | Running balance after the transaction |
The date-once-a-day habit is worth flagging: because the date isn't repeated for every line, a careless export can leave rows dated blank. The converter carries the correct date down to each transaction under it.
Where to download your statement
- Online Banking: log in at bankofscotland.co.uk, choose the account, open Statements, pick the period and download the PDF.
- Bank of Scotland app: tap the account, go to Statements, choose a month and save the PDF.
A statement pulled this way is a digital PDF with selectable text, so conversion is exact. A scan or photo of a paper statement works too, through OCR — it just takes a little longer.
Getting the numbers where you need them
- Excel or Google Sheets — a clean `.xlsx` or CSV, one row per transaction, ready to total and filter.
- Xero or QuickBooks — an import-ready bank file so the lines arrive as statement entries to reconcile.
- Tally, Zoho and others — the same data in each one's format.
Before download, the arithmetic is checked: opening balance, plus money in, minus money out, must equal the closing balance. On a statement where dates print once a day, that check is what catches a row that drifted onto the wrong day.
Common snags with Bank of Scotland statements
- Codes swallowed into the payee. DEB, DD, SO and the rest are kept in their own place on each line.
- Blank-looking dates. Every transaction is given its correct date rather than an empty cell.
- Same platform as Halifax and Lloyds. All three sit in Lloyds Banking Group, so the same conversion works — though each is its own brand and account.
Frequently asked questions
Can I convert a Bank of Scotland statement to Excel for free?keyboard_arrow_down
Yes. Upload the PDF and get a clean Excel or CSV back free to start, with the running balance checked so the import lines up.
What do codes like DEB, FPO and BGC mean?keyboard_arrow_down
They record how the money moved — DEB a debit-card payment, FPI and FPO Faster Payments in and out, DD a Direct Debit, SO a standing order, and BGC a bank giro credit such as wages. Each stays with its transaction.
It shares a platform with Halifax — does that matter?keyboard_arrow_down
Only that the statement layout is the same, so the conversion behaves identically. Your Bank of Scotland account is still its own account; this page is simply written for the Bank of Scotland version.
Will it read a scanned Bank of Scotland statement?keyboard_arrow_down
Yes, with OCR. A PDF from Online Banking will convert faster and cleaner than a scan.
