Convert Bank of Scotland Bank Statement to Excel

A Bank of Scotland statement records everything flowing through the account over the period — deposits, cheques paid in, refunds and interest earned on one side; card spending, cash machine withdrawals, automatic payments and fees on the other — bracketed by the balance at the start and the end. Many entries carry short payment codes rather than full descriptions, which the bank explains are simply compact labels for the payment type. Typing that lot into a workbook invites two classic errors: a receipt entered as a payment, and a code mis-read as part of the payee name. SheetMyBank sidesteps both, splitting inflows from outflows automatically and preserving codes verbatim.

Log on to Internet Banking, select the account, and use the download icon that sits above your most recent transactions to save the statement as a PDF or print it — Internet Banking reaches statements up to seven years old, while the mobile app goes back at least ten. Your statement is then handled offline in the browser rather than posted to any cloud service, and SheetMyBank reconciles the period’s start and end balances against every extracted row before releasing the workbook.

Drop your Bank of Scotland statement here (PDF or photo)

Processed entirely on this device — nothing is uploaded. Scans and photos are read with on-device OCR (beta).

Free for your first 5 pages each month · Processed on your device · Balance-verified output

Bank of Scotland statement FAQ

Should I use the app or Internet Banking for older statements?

The app: Bank of Scotland’s mobile app gives immediate access to at least ten years of statements, whereas Internet Banking reaches back around seven. For recent months either works — select the account and use the download icon above the transaction list.

How do I get a Bank of Scotland credit card statement as a PDF?

Credit cards work differently from current accounts here: you can download a PDF statement within the app, or request one through the bank’s online chat. Once you have the file, it converts to Excel the same way a current account statement does.

Can I convert a scanned or photographed paper statement?

Results will be unreliable. Statements downloaded from Internet Banking or the app contain a genuine text layer that parses cleanly; a scan or photo is only an image of the page. Wherever possible, fetch the original PDF from your banking instead of scanning paper.