UK
About Bank of Scotland statements
Bank of Scotland is part of Lloyds Banking Group, so its statement layout closely matches Lloyds and Halifax. For a high-street account like this, the statement is a normal monthly PDF you pull from Online Banking or the app, under Statements.
Bank of Scotland shares the Lloyds Banking Group format — DEB, DD, SO, FPO and BGC codes at the start of each line, and the date shown once per day. That's exactly the detail that gets scrambled when you paste a PDF into a spreadsheet, and exactly what the converter preserves, column by column.
The figures stay in GBP (pounds) and dates read DD/MM/YYYY, the same as on the original statement. If your only copy is a scan or a phone photo, that's fine — OCR handles it, and the totals still get reconciled.
After that you're just reconciling in Zoho Books; the awkward part of getting the data out of the PDF is handled.
Why people convert Bank of Scotland to Zoho Books
Zoho Books reconciles from imported statements, and a Bank of Scotland feed isn't always available or current. Converting the PDF to a clean CSV gives Zoho exactly what its Import Statement screen wants, for any month you need.
The common case is a bookkeeper handed a folder of Bank of Scotland PDFs and told to "get these into Zoho Books." Converting each one is far quicker than retyping, and the balance check means you trust the totals before they land in the books.
Import a Bank of Scotland statement into Zoho Books
Zoho Books imports a CSV — there's no separate Zoho file, so you use the clean CSV.
- Convert the PDF above and download the CSV.
- In Zoho Books: Banking → pick the account → Import Statement.
- Upload the CSV and map Date / Description / Amount.
- Import, then categorise the lines.
The totals are checked first
The converter checks the maths before handing you the file — so if a transaction dropped out of the PDF, you know about it now, not when the Zoho Books balance is off.
Frequently asked questions
How does the Bank of Scotland statement go into Zoho Books?expand_more
No special file — Zoho Books imports a plain CSV, so you use the clean CSV from here. Go to Banking → your account → Import Statement, then map Date, Description and Amount. There's a preview before it commits, so you can check the columns matched before the lines post.
What does a Bank of Scotland statement look like?expand_more
Bank of Scotland shares the Lloyds Banking Group format — DEB, DD, SO, FPO and BGC codes at the start of each line, and the date shown once per day. The converter reads each of those into its own column, so the Zoho-ready CSV imports into Zoho Books cleanly.
Where do I download the Bank of Scotland statement?expand_more
From Online Banking or the app, under Statements. Save the PDF, then drop it into the converter above — multi-page and multi-month statements are read in one go.
Can I use a photo of my Bank of Scotland statement?expand_more
Yes. Scanned or photographed PDFs are read with OCR into the same columns, and the balance check still runs, so a scan converts the same as a digital download.
Is it free?expand_more
Yes — the CSV downloads with no login and no charge to start.