Convert a PDF to QFX only if you use Quicken, because QFX is Quicken's bank file. QuickBooks users want a QBO file from the same PDF, and Xero users want a CSV. The two bank formats look almost the same inside, which is why the names get mixed up.
QFX for Quicken, QBO for QuickBooks: why the split?
QFX and QBO are two names for nearly the same kind of file, each tied to one product. Quicken reads QFX, and QuickBooks reads QBO. Both are built on the Open Financial Exchange format, and both carry a list of dated transactions, so the split is about branding and software support, not about the data.
Each product recognises its own file type by the extension. A bank that supports direct downloads often offers both buttons, often worded "Quicken" and "QuickBooks". They hand you the same transactions in two wrappers.
A short way to remember it:
- QFX is Quicken's Web Connect file. It is for personal and home finance in Quicken.
- QBO is QuickBooks' Web Connect file. It is for business books in QuickBooks.
- OFX is the general format underneath. Some tools accept it directly, without either brand's wrapper.
What a PDF changes
Neither format starts as a PDF. A PDF statement is a printout, so a converter has to read the table of transactions and write them into the tagged structure. The target format changes only the wrapper. The reading, the date fixing and the sign rules are the same whichever you pick. The step-by-step version of that work is in converting a PDF to QBO, and almost every step transfers to QFX.
Why people ask about QFX at all
Most searches for a PDF to QFX converter come from one of three situations. Some people use Quicken at home and hold a PDF from a bank that has stopped offering downloads. Some use QuickBooks and saw "QFX" on a bank's download menu next to "QBO", then guessed. Others run a small business from Quicken and want to keep it that way. Only the first and third need QFX. The second group should read the decision table below and ask for QBO.
A useful habit is to say your software's name before you say the file type. "I use QuickBooks Online" leads to a better answer than "I need a bank file", because the software decides the format and the format does not decide the software.
The decision table
Use this table to choose. The software on the left is yours; the file on the right is what to ask a converter for.
| Your software | File to ask for | Notes |
|---|---|---|
| Quicken | QFX | The file Quicken calls its own. |
| QuickBooks Online | QBO, or CSV | A CSV upload works too and needs you to match the columns. |
| QuickBooks Desktop | QBO | Desktop opens Web Connect files. |
| Xero | CSV | Laid out the way Xero's statement import expects. |
SimpleBankConvert makes CSV and QBO files, not QFX. That covers QuickBooks Online, QuickBooks Desktop and Xero, and it does not cover Quicken. The service is in early access and accounts are not open yet. If Quicken is your software, CSV to QFX conversion explains the route from a spreadsheet.
Before you convert anything, write down three facts: your software and edition, the account type on the statement (checking, savings or card) and the statement period. These three facts decide the file type, the sign rules and the year on every short date. They take a minute to collect, and they stop most wrong-format conversions at the start.
Which PDF statements convert well to QFX?
Digital PDFs that you download from your bank's website convert well, and scans do not. A downloaded PDF contains real text, so the table can be read exactly. A photo or a scan of a paper page is an image, and every character has to be recognised before it can be used.
Not every digital statement is equally easy either. These are the features that decide how well a conversion goes.
Easy statements
- One account on the PDF, with a clear table of dated lines.
- A single date format throughout.
- One column of signed amounts, or two clearly labelled columns.
- Descriptions that stay on one line.
Harder statements
- Two money columns. Paid out and paid in must be merged into one signed amount, with money out negative.
- Short dates with no year. The year has to come from the statement period.
- Wrapped descriptions. A second printed line must be joined to the line above.
- Summary pages and balance rows. These must be left out, or the totals will not tie.
- Several accounts on one PDF. Each account becomes its own file.
Statements that need caution
Scans, photographs, pages with handwriting, and statements that have been cut or merged are poor inputs. If you only have paper, read scanning paper statements into QuickBooks before you spend time on a converter. Whatever the source, finish with the same check: opening balance plus every movement should equal the closing balance printed on the statement.
Credit cards
Card statements convert as well as bank statements, with one extra decision, which is the direction of the sign. A purchase increases what you owe. If your charge amounts import with the wrong sign, every line will look reversed. The post on importing an American Express statement into QuickBooks shows how to handle a card in practice.
Picking the wrong file type when converting a PDF statement
Giving QuickBooks a QFX file costs less than people fear. In QuickBooks Online a QFX upload is allowed, so it may go in without trouble. Desktop is a different story: Web Connect opens .qbo files only, and the QFX is turned away. Either way the data is fine; only the wrapper needs changing.
Here is what tends to happen in each mix-up.
A QFX file offered to QuickBooks
The answer depends on the edition. In QuickBooks Online the upload screen takes QFX alongside QBO and CSV, according to Intuit's QuickBooks Online upload help. In QuickBooks Desktop, Intuit's Web Connect troubleshooting article tells you to make sure the bank file is a .qbo, because Web Connect reads no other type. So a refused QFX in Desktop means converting again to QBO; do not try to rename the extension. A file with a changed name but the original contents can confuse the import and is not a reliable fix. The comparison of QFX, OFX and QBO and how close the three formats are goes into what is different inside.
A QBO file offered to Quicken
The same applies the other way. Quicken expects QFX and may not recognise a QBO file. Convert to QFX instead.
Nothing wrong with the numbers
In both cases, your transactions did not become corrupt. The conversion from PDF produced correct rows. Only the final wrapper is wrong. That is why it is worth settling the file type before you start, and why you should keep your clean table of rows: it lets you produce a different format without redoing the reading.
How to avoid the mistake
- Open the software you will import into, and note its name and edition.
- Look up the file type in the decision table above.
- Convert one statement and import it into a test period or a spare account first.
- Compare the imported balance with the closing balance on the PDF.
If the balance matches, repeat for the other statements. If you are not sure which version of QuickBooks you run, check the product name at the top of the screen: "QuickBooks Online" is the web version, and Desktop is the installed one.
Can one PDF statement produce both QFX and QBO files?
Yes. One PDF statement can produce a QFX file and a QBO file, because both are built from the same list of transactions. Read the table once, fix the dates and signs once, then write the rows into whichever wrapper each program needs.
This matters for a small number of people. A freelancer might keep personal finances in Quicken and business books in QuickBooks, or an accountant might serve clients on both. The point is that the expensive part of the work, getting the rows right, is shared. The output format is a last step.
What stays the same and what changes
| Element | Same for QFX and QBO? |
|---|---|
| Transaction dates | Yes |
| Amounts and signs | Yes |
| Descriptions | Yes |
| Account and bank identifiers | Roughly, but each program has its own expectations |
| File extension | No |
| Which program opens it | No |
Don't import the same statement twice
If you produce both files, import each into its own program once. Do not load the same statement into one program twice. Each transaction carries a unique ID so a program can skip lines it has already seen, but IDs created by two separate conversions may not match, and then every line arrives twice.
Where SimpleBankConvert fits
SimpleBankConvert reads a PDF statement and gives you a CSV or QBO file, with the dates tidied and the money columns merged, for QuickBooks or Xero; details are on the SimpleBankConvert home page. It does not make QFX, so for Quicken you need a tool that writes QFX, or the CSV route in the linked post above.