Start by checking the import options in your QuickBooks account. A bank feed or a file downloaded directly from your bank may be the simplest route. Intuit also documents direct statement uploads in supported workflows, so a separate converter is not always necessary.
When a converted file is useful
If the available import options do not handle your PDF, convert it and review the Excel output first. Obtain the original document using our PDF download guide. Keep a copy of the reviewed data so you can compare it with the import preview.
Convert PDF to QBO in four steps
- Open the PDF bank statement to QBO tool and upload an unlocked PDF of up to 25 MB.
- Choose Convert My Statement, then download Excel to check the account details, dates, amounts, and totals.
- Open More formats and select QBO to download the transaction file.
- In QuickBooks Online, locate Bank transactions and Upload from file, select the destination account, and review the import before accepting rows. Menu labels and options can vary.
Check the receiving account's current file and size requirements. If a batch is too large, prepare a smaller statement period from the source rather than repeatedly uploading the same rejected file.
See Intuit's manual upload instructions for the current workflow and available file types.
What our QBO export contains
The QBO export includes transaction dates, signed amounts, descriptions, and generated transaction identifiers called FITIDs. It uses the detected account details and a statement-level currency.
These identifiers are generated from the extracted values and the row position. They are not the original identifiers supplied by your bank. A changed description or row order can change them, so they do not guarantee duplicate prevention across overlapping uploads.
Inspect a sample QBO file
Compare the fictional sample PDF, Excel review workbook, and QBO export. These demonstration files contain no real customer data. The QBO is an example of the exporter, not a file to import into a live account.
| QBO field | Example | Meaning |
|---|---|---|
| CURDEF | USD | Statement currency |
| DTPOSTED | 20260905120000 | Posted date for the example supplies payment |
| TRNAMT | -125.00 | Money leaving the deposit account |
| TRNTYPE | DEBIT | Outgoing transaction |
| FITID | Generated for each row | Helps the receiving system identify transactions |
The 500.00 deposit is positive and the 125.00 supplies payment is negative. Check these signs against your own statement and the import preview. Renaming a PDF or CSV with a .qbo extension does not create these fields.
Review before you import
- Confirm the destination account and its currency.
- Compare the date range with transactions already in QuickBooks.
- Check one incoming and one outgoing transaction in the preview.
- Review any matching suggestions before accepting the imported rows.
- Reconcile the result against the original statement.
Our current QBO exporter labels the account as checking. It is not a dedicated credit card or investment-account exporter. Use your bank's own download, or a CSV workflow that lets you select the appropriate account, when those distinctions matter.
If QuickBooks rejects the file
Acceptance can depend on the account type, financial institution information, region, and QuickBooks product. The current exporter uses a placeholder institution identifier of 00000, which may be rejected. Prefer a bank-issued QBO when possible. Keep the exact error message and consult our import troubleshooting guide before retrying.
For a CSV fallback, compare CSV vs QBO and follow the CSV preparation guide. The general CSV includes Balance as a fifth column; prepare a working copy that matches the fields QuickBooks requests instead of importing Balance as an amount.