How do you convert a scanned bank statement to CSV on a Mac?

By Kayabyte · Last updated 4 November 2026

A scanned statement is a picture of text, so it has to be read with text recognition (OCR) before it can become rows. On a Mac you can copy text out of an image with Live Text in Preview, which is free, but you get text, not a table, and you must rebuild the columns yourself (Apple Support, Preview User Guide, checked 4 November 2026). A converter such as Balanced reads the scan with Apple’s on-device text recognition, builds the transaction table and checks the totals. If your bank offers a CSV or a text PDF download, use that instead: it is more reliable than any scan.

First, check whether you really have a scan

Open the PDF in Preview and try to select a line of text. If you can, it is a text PDF and you do not need OCR; see how to convert a PDF bank statement to CSV. If you cannot, it is an image inside a PDF. Apple has a page on what to do when text in a PDF cannot be selected or copied (Preview User Guide, “If you can’t select or copy text in a PDF”).

The free route: Live Text in Preview

Apple’s Preview guide says Live Text lets you copy the text that appears in a photo: hold the pointer over the text, drag to select, Control-click and choose Copy Text. If you cannot select text, choose Tools, then Text Selection. For a scanned page, open the page as an image or PDF and try the same. Paste the result into a text editor or a spreadsheet.

What this gives you is text. Date, description and amount may land in one cell or on separate lines, and a transaction that wraps onto two lines becomes two lines. For one short statement this can be enough. For twelve months it is slow, and every number was typed by recognition, so mistakes can hide.

What goes wrong with scans

Recognition errors. 8 read as 3, a comma read as a full stop, a minus sign lost. One wrong digit changes the total.
Skew and low resolution. A tilted or blurry photo reads badly. A flat, sharp, high-contrast scan is the single biggest help.
Wrapped lines. A long description on two lines must be merged into one transaction.
Signs. Debits and credits may be in separate columns, or a single column with minus signs or “CR” marks.

Because of the first problem, always compare the result with the statement: opening balance plus credits minus debits should equal the closing balance. If it does not, something was misread or missed.

With Balanced

Balanced is a Mac app we make. Open the scanned PDF or image; it reads the page on your Mac with Apple’s text recognition, finds the transaction table, shows it in a preview and lets you set what each column means, the date order and the sign handling. It then checks that the opening balance plus the transactions equals the closing balance, and the running balance on each row when the statement shows one. If the check fails you see the difference and the rows involved. Export as CSV, Excel and other formats. Nothing is uploaded and there is no account.

Limits, stated plainly: a very skewed or low-quality scan may not be readable, and a password-protected PDF has to be unlocked first with the password from your bank. Always look at the preview before exporting.

Steps with Balanced

Scan flat and sharp if you can, or use the bank’s own PDF.
Open the file in Balanced with Add Files or by dragging it in.
Check the table in the preview and the totals check at the top; change any column that was misread.
Export CSV or Excel to the folder you choose.

The free version reads and checks everything and exports the first 10 transactions per file, so you can test it on your own scan. Balanced Pro is USD 59 per year or USD 7.99 per month. Download Balanced · Pricing

Questions

Is a free route enough? For one short statement, copying with Live Text and fixing the columns by hand can be. For many pages or months, the manual work and the risk of unseen misreads grow.

Does my statement leave my Mac? Not in Balanced. Recognition runs on your Mac.

What if the scan is bad? Rescan it flat and sharp, or ask your bank for a digital copy. Balanced says when nothing readable was found.