To convert PDF to QBO on a Mac, use a converter that runs in your web browser, or copy the statement out of Preview into Numbers or Excel and build the file yourself. Then upload the QBO file in QuickBooks Online through the browser, or import it into QuickBooks Desktop for Mac as a Web Connect file.
Do browser-based PDF to QBO converters work on a Mac?
A converter that runs in a web browser works the same on a Mac as on Windows, because the conversion happens on a website rather than in an installed program. You upload the PDF, check the rows and download the QBO file. Nothing has to be installed, so there is no question of whether a Windows-only tool will run.
This matters because much older conversion software was written for Windows. On a Mac, such a program only runs inside a Windows virtual machine, which is a lot of setup for a monthly bank file. A browser tool removes that problem.
What to look for is the same on either system. The converter should show you the rows before you download, let you fix a date or a sign, and tell you when it could not read part of the statement. It should also let you choose between CSV and QBO, since QuickBooks Online takes either. If you want the CSV route instead, converting a PDF bank statement to CSV for QuickBooks walks through it.
SimpleBankConvert is a website, so it will run in Safari or any other Mac browser, and it is being built to turn a digital PDF statement into a CSV or QBO file. It is in early access, and you can leave your email on the get started page to hear when accounts open.
What Preview can and can't copy from a bank statement PDF
Preview, the PDF app built into every Mac, can copy text from a digital statement, enough for a manual conversion. It cannot rebuild the statement's table for you, and a plain scan holds no text layer, so anything you get from one is recognised rather than copied. Expect to tidy the pasted lines by hand.
Apple's guide to selecting and copying text in Preview gives the steps: choose Tools, then Text Selection, drag over the text, then choose Edit, then Copy. The same guide says that holding the Option key as you select copies a column of a table. That second method is the useful one for statements, because you can copy the dates, then the descriptions, then the amounts, and paste each into its own spreadsheet column.
Here is the full route on a Mac, step by step:
- Open the statement in Preview and confirm the text selects. If nothing selects, the page may be a scan.
- Hold Option and drag down the date column on page one. Copy and paste it into column A in Numbers or Excel.
- Do the same for descriptions into column B and amounts into column C. Repeat for each page.
- Line the rows up, join any wrapped descriptions, and delete balance and subtotal lines.
- Give every date its year and make money going out negative.
- Check that the opening balance plus the amounts equals the closing balance.
- Export the sheet as CSV, then build the QBO file from it, or upload the CSV to QuickBooks Online directly.
If Preview refuses to select text at all, the PDF may be locked. Banks sometimes protect statements with a password, and opening a password-protected PDF bank statement covers what to do.
Opening the QBO file in QuickBooks Online or QuickBooks for Mac
Where the QBO file goes depends on which QuickBooks you use. QuickBooks Online runs in a browser, so on a Mac you upload the file on the bank transactions screen exactly as on any other computer. QuickBooks Desktop for Mac imports a QBO file as a Web Connect download and shows the lines for review first.
For QuickBooks Online, Intuit's page on uploading transactions to QuickBooks Online by hand lists QBO as the suggested file type, with a 350 KB size limit. Nothing about the steps changes on a Mac.
For QuickBooks Desktop for Mac, a QuickBooks Team answer on Intuit's community describes the import: under Banking, open Downloaded Transactions and choose the account, use Import File to select the QBO file, then review the lines in the Downloaded Transactions window. The same answer says a one-time Web Connect setup through Online Banking Setup comes first. Menu names can differ between versions, so check your own.
Does a Mac user need QFX instead of QBO?
You need QFX instead of QBO only if the software you are importing into is Quicken. QuickBooks on a Mac still takes QBO files, the same as on Windows. Quicken for Mac takes QFX files. The two formats look alike inside, but each program expects its own, so convert to the one that matches your software.
The mix-up is common on Macs because many people who use a Mac for home finances use Quicken, and many who run a small business use QuickBooks. If you use both, convert each statement to the format of the program it is going into. The comparison of QFX and QBO files from a PDF statement sets out which program reads which.
One more file type confuses Mac users moving from Quicken. A QDF file is Quicken's own data file, not a bank download. You can't turn it into a QFX or a QBO, and why a QDF can't be converted to QFX explains how to export the transactions you need instead.
Numbers and Mac region settings that spoil a statement file
Two Mac defaults cause most bad dates and amounts in a home-made statement file. Numbers formats dates and numbers to match your Mac's region settings, so an export can carry a different date order or a comma as the decimal mark. Check the exported CSV in a plain text editor before you build or upload anything.
The date problem is the more common one. If your Mac is set to a region that writes the day before the month, Numbers may show and export 03/04/2026 as 3 April when the statement meant 4 March. Every date after the 12th of a month will fail outright, and the ones before it will import into the wrong month without any warning. Format the date column as year, month and day before exporting to remove the doubt.
Amounts have their own trap. Regions that use a comma as the decimal mark export 148,60 instead of 148.60, which a CSV reads as two fields. Set the amount column to a plain number with a full stop as the decimal mark, or change the region setting while you export.
Finally, open the exported file in TextEdit before using it. A CSV should show plain lines of text with commas between fields. If you see stray quotation marks, currency symbols or extra blank lines, fix them in the spreadsheet and export again.