Bank of Scotland (United Kingdom) Statement to OFX — Convert PDF Statements

Bank of Scotland statements to OFX: what you get

Converting to OFX turns the Bank of Scotland PDF into a machine-readable statement file: the same transactions, in the tagged format that personal-finance and legacy accounting applications expect when a direct bank feed is not available.

Signed amounts with debit/credit typing preserved
Suitable for tools whose import lists OFX or QFX
Dates written in OFX datetime form
Descriptions carried in the memo/name fields as printed

The main use is moving an account between finance applications without retyping. Statements from United Kingdom banks print dates as day/month/year — 03/04/2026 means 3 April 2026 and amounts with a comma for thousands and a point for decimals (1,234.56) — the converter's locale-aware reader handles that layout, and then the reconciliation check proves the result: the extracted transactions must add up to the balances printed on the statement itself, or the conversion is flagged.

Reconciliation is what separates conversion from copying. Once the Bank of Scotland transactions are extracted, the converter replays them: opening balance plus each row in turn must reproduce every printed running balance and land exactly on the closing figure. A conversion only reports as reconciled when both tests agree to the cent — and when they do, the figures have been proven against the bank's own document, not merely read from it.

Before converting, spend thirty seconds on the Bank of Scotland document itself: confirm the period matches the month you are closing, note the opening and closing balances, and scan for the period's largest transactions. A reconciliation difference is most often one of those large items — a duplicate, a drop, or a digit misread — and knowing the candidates in advance shortens the search considerably.

In United Kingdom, bookkeepers commonly work in Xero, Sage, QuickBooks and FreeAgent; the Excel and CSV exports from this converter are the files those tools import, and the Xero export is laid out for direct import where the tool accepts it.

Working from Bank of Scotland statements as a bookkeeper

Ask clients for the issued PDFs rather than portal screenshots or spreadsheet exports. The PDF is the only version that carries the balances the check needs, and a folder of monthly PDFs plus their conversion results is an audit trail that assembles itself.

How to download a statement PDF from Bank of Scotland

Sign in and open the right account. Open the Bank of Scotland app or website and sign in. Statement PDFs sit behind the login — there is no public download.
Go to the account, then its documents. Statements usually live under the account menu, labelled Statements, Documents, or eStatements, depending on the bank.
Work month by month. Download each period as its own file. The reconciliation check proves one statement at a time, which is what makes a long catch-up provable.
Download or print to PDF. A downloaded PDF carries the text layer the converter reads. If the portal only offers a print view, print to PDF instead of taking a picture.
Upload and verify. Add the file to the converter on this page. You can add several statement PDFs at once for batch conversion.

These are the general steps most banks follow for statement downloads; exact menu labels vary by bank and change over time.

Questions and answers

How do I convert a Bank of Scotland statement to OFX?

Save the statement as a PDF from Bank of Scotland online banking, add it to the converter above, and take the an OFX-formatted export of the statement's transactions it produces. Extraction, column normalization and the reconciliation check all happen before the download is offered.

What date and number formats do Bank of Scotland statements use?

Expect day/month/year — 03/04/2026 means 3 April 2026 dates and amounts with a comma for thousands and a point for decimals (1,234.56) on a Bank of Scotland statement. The reader is locale-aware, so those conventions are handled rather than misread, and the output columns come out in the standard layout regardless.

What does the reconciliation check do?

Where the statement prints opening and closing (or running) balances, the converter adds up the extracted transactions and compares the result with the statement itself. If the numbers do not tie, the conversion is flagged and the mismatched rows are marked — a failed check is never shown as a success.

My Bank of Scotland statement has a running balance column. Is it used?

Yes — it is one of the strongest checks available. The converter walks the extracted amounts against the printed running balance row by row, so a single dropped or duplicated transaction is pinpointed instead of merely suspected.

What if two Bank of Scotland statements cover overlapping days?

Convert them separately and import only one version of the overlap. Banks occasionally reissue a corrected statement for a period; the later issue supersedes the earlier, and importing both would double the shared days.

Can I convert a full year of Bank of Scotland statements at once?

Yes. Download each month as its own PDF and upload them together — batch mode converts them in one run and, in Excel, adds a combined sheet. Each statement is still reconciled separately, because balances are per statement.

Does the converter work with Bank of Scotland credit-card statements?

Yes. Credit-card statements use a Previous Balance / New Balance layout, which the converter reads as well; purchases are positive and payments are negative, and the same totals check applies.

What columns does the converted file have?

Date, Description, Amount, Debit, Credit and Balance — the same normalized columns for every bank, so a Bank of Scotland file and a file from any other bank in United Kingdom can be imported and reviewed the same way.

Are my statement files kept?

No. Uploaded files and generated exports are stored only briefly to complete the download and are automatically deleted within 15 minutes.

Convert your Bank of Scotland statement to OFX