What Is a QBO File? (And How to Create One from a PDF)
A QBO file is the file format QuickBooks uses for importing bank transaction data. It is XML-based, supports duplicate detection, and is the only format QuickBooks Desktop accepts for bank imports. Here is what it contains and how to create one from a PDF bank statement.
What a QBO file is
A QBO file is an XML-based file format for importing bank transaction data into QuickBooks. The name comes from QuickBooks Online, but QBO files work with both QuickBooks Online and QuickBooks Desktop.
QBO is a variant of the OFX (Open Financial Exchange) standard. Most major US banks offer QBO downloads alongside CSV and OFX. When you download transactions from Chase, Bank of America, or Wells Fargo, the QBO option is typically labeled as "QuickBooks" in the download format list.
What is inside a QBO file
A QBO file is plain XML you can open in any text editor. The key sections are:
- OFX header: specifies the file format version and encoding.
- SIGNONMSGSRQV1: authentication block (often left as placeholder values for manually created files).
- BANKMSGSRSV1: the main data block containing account information and transactions.
- STMTRS: the statement block with currency, account ID, and the transaction list.
- STMTTRN: one block per transaction, containing TRNTYPE (debit or credit), DTPOSTED (date in YYYYMMDD format), TRNAMT (amount), FITID (unique transaction ID), and NAME (description).
The FITID (financial transaction ID) is the most important field for QuickBooks. It is what QuickBooks uses to detect and skip duplicate transactions when you import overlapping date ranges.
QBO vs CSV vs OFX: what is the difference
- QBO: XML-based, includes transaction IDs for duplicate detection, required by QuickBooks Desktop, accepted by QuickBooks Online.
- CSV: plain text, columns separated by commas, no transaction IDs, accepted by QuickBooks Online only (not Desktop), requires column mapping on import.
- OFX: same standard as QBO, functionally identical for bank import purposes, accepted by QuickBooks and many other accounting platforms.
- QFX: Quicken's format, same structure as QBO, works with Quicken but not QuickBooks (renaming QFX to QBO usually works).
How to create a QBO file from a PDF bank statement
You cannot convert a PDF to QBO manually without writing XML by hand, which is impractical. The reliable method is an AI-powered conversion tool:
- Upload your PDF bank statement to the conversion tool.
- The AI extracts all transactions from the PDF.
- Select QBO as the output format.
- The tool generates valid QBO XML with correct YYYYMMDD dates, signed amounts, and unique FITIDs for each transaction.
- Download and import into QuickBooks.
Documentric handles this process end to end, including scanned PDFs, and outputs QBO files that import without errors into both QuickBooks Online and Desktop.
Convert your first bank statement free
No account needed. Upload a PDF and get clean, structured data in under 60 seconds.
Try Documentric FreeHow to create a QBO file from a CSV
If you already have transaction data in CSV format, you can convert it to QBO using a CSV-to-QBO converter. The converter wraps your spreadsheet data in the required XML structure, assigns FITIDs to each row, and outputs a valid QBO file. See our CSV to QBO converter guide for the full process.
How to import a QBO file into QuickBooks
For a complete step-by-step walkthrough of QBO file import into both QuickBooks Online and QuickBooks Desktop, including common error fixes, see our QBO file import guide.
FAQ
Can I open a QBO file in Excel?
Not directly. QBO is XML, not a spreadsheet format. You can open it in a text editor to inspect the contents. If you need the data in Excel, convert your source PDF to CSV instead of QBO.
Why does QuickBooks Desktop not accept CSV?
QuickBooks Desktop requires the structured metadata in QBO or OFX files, specifically the financial institution ID and transaction IDs, to manage accounts and detect duplicates. CSV does not contain this metadata.
Is a QBO file the same as a bank statement?
No. A bank statement is a document showing your account activity for a period. A QBO file is a structured data file containing the transaction records from that statement, formatted for software import. The QBO file has no headers, addresses, or formatting, only transaction data.
What happens if a QBO file has duplicate FITIDs?
QuickBooks uses FITIDs to skip transactions it has already imported. If two transactions share the same FITID, QuickBooks will treat the second as a duplicate and skip it. This is why conversion tools generate unique FITIDs for each row, even if the source CSV had no ID column.