What OFX export file format does this tool accept?

This tool accepts OFX Bank File files. Export from OFX and upload the File file directly.

Can I convert OFX CSV to QuickBooks Online?

Yes, this tool converts OFX Bank File exports directly to QuickBooks Online CSV format compatible with QuickBooks Online.

How do I import OFX bank to QuickBooks Online?

Export your bank from OFX, upload the CSV file to this converter, then import the converted file to QuickBooks Online.

Convert OFX to QuickBooks Online CSV | OFX to QBO

🥦

QuickBooks Online CSV Format

valid rows

Transform OFX/QBO bank transaction files into QuickBooks Online's 3-column CSV format for manual upload. Your data never leaves your browser.

Free preview — then from $5. Save with bundles.

Free preview before you pay

Files never leave your browser

No account needed to start

Download Sample OFX

Valid OFX file with sample transactions

Sample OFX File

How to Convert Your File

Export from Banking

Accounts → Transaction History → Export

Upload and Configure

Upload OFX/QFX/QBO Bank Transactions CSV and choose Bank Transaction CSV (3-Column) format

Preview and Download

Review converted data, download Quickbooks Online-ready file

Import to QuickBooks Online

Banking → Select Account → Upload from Computer → Import CSV

Output is in QuickBooks Online CSV format — ready to import directly, no manual reformatting needed.

How People Use This

Several of my clients' banks only provide OFX downloads, but QuickBooks Online won't accept them through manual upload. I convert the OFX files to the 3-column CSV format QBO expects, then import through the Banking section. The automatic date reformatting from YYYYMMDD to MM/DD/YYYY prevents import errors every time.

We migrated from QuickBooks Desktop to QuickBooks Online and needed to import 18 months of historical bank data. Our banks had OFX files going back that far, but QBO bank feeds only sync recent transactions. Converting the OFX files to CSV let us fill in the 90-day gap with the full transaction history.

Our credit union provides statements in OFX format only. I convert them to QuickBooks Online CSV monthly for our accounts payable reconciliation. The smart description builder that combines payee and memo into one field matches exactly what QBO needs for the import.

During cleanup engagements, clients give me old bank OFX files to reconstruct their books in QuickBooks Online. I convert each OFX file to the QBO CSV format and import by account. The amount sign preservation keeps debits and credits correct without manual adjustment.

Our firm's trust accounts at Wells Fargo provide QFX downloads. QuickBooks Online wouldn't accept the direct upload, so I convert the QFX to CSV first. The conversion handles our trust account transactions properly and I can review everything in the CSV before importing into QBO.

I took over a client whose bank connection to QuickBooks Online had been broken for four months. The bank provided OFX files for the missing period. I converted each month's OFX to CSV and imported them into QBO sequentially. The duplicate prevention feature gave me confidence that nothing would be double-counted.

Common Conversion Questions

Why can't I directly import OFX into QuickBooks Online?

QuickBooks Online only accepts OFX files through automatic bank connections, not manual upload. For manual imports (90+ day history, closed accounts, disconnected banks), you must use CSV format. This tool converts OFX to the exact CSV format QBO requires.

Is this tool free?

First transactions are free to preview. Full conversions use credits based on transaction count (0.5 credits per 1,000 rows, minimum 5 credits).

Is my financial data safe?

Absolutely. All conversion happens entirely in your browser using client-side JavaScript. Your OFX file is never uploaded to our servers. Your bank transactions never leave your computer.

Why Convert OFX to CSV for QuickBooks Online?

QuickBooks Online Doesn't Always Accept OFX

QBO supports bank connections, but many situations require manual CSV import: - 90+ day gaps: Bank connections only sync recent transactions - Disconnected or closed accounts with historical data - Bulk importing from multiple accounts at once - Migration from QuickBooks Desktop or other software OFX files from your bank can't be directly uploaded to QBO - they must be converted to CSV first.

What This Tool Does

Converts OFX XML bank files to QBO's 3-column CSV (Date, Description, Amount). Reformats dates from YYYYMMDD to MM/DD/YYYY, combines payee and memo into a single description field, and preserves amount signs (negative = debit, positive = credit). Works with OFX files from any bank.

Your Conversion is Secure

Browser-Only Processing

All conversion runs in your browser. Files are never uploaded to any server.

No Data Retention

Nothing is stored after conversion. Close the tab and your data is gone.

GDPR Compliant

Full EU data protection compliance. Your privacy rights are fully protected.

More credits - more savings

Buy bundles and get up to 60% off. Perfect for recurring monthly conversions.

Field Mapping

How Banking Ofx fields map to Quickbooks Online Bank Transaction

Banking Ofx	Source Value		Quickbooks Online Bank Transaction	Target Value	Note
`DTPOSTED`	`2025-01-15 12:00:00`	→	`Date`	`01/15 12:00:00/2025`	OFX date (YYYYMMDD) → MM/DD/YYYY
`TRNAMT`	`-50.00`	→	`Amount`	`-50.00`	Signed amount (negative for debits, positive for credits)

Why Use This Converter?

Automatic Date Formatting

Converts OFX dates (YYYYMMDD) to QuickBooks Online format (MM/DD/YYYY)

Smart Description Builder

Combines payee, memo, and check number into a single description field

Amount Sign Preservation

Maintains correct signs (negative for debits, positive for credits)

Duplicate Prevention

Generates unique transaction IDs if missing to prevent duplicate imports

Browser-Based Security

All processing happens in your browser - your financial data never leaves your computer

Works with All Banks

Supports OFX files from Chase, Bank of America, Wells Fargo, Citi, and 1000+ banks

Data Transformation

Each OFX transaction becomes one CSV row

XML-based bank transaction

Key columns: FITID, DTPOSTED, TRNAMT, NAME, MEMO

1:1 — One input row creates one output row

Simple CSV format with 3 columns

Transaction Convert OFX date to MM/DD/YYYY

Description Combine payee and memo

Amount Keep signed amount as-is

Amounts must be numeric; dates must be valid

Common Bank Transaction CSV (3-Column) Import Errors

Issues you might encounter when importing OFX/QFX/QBO Bank Transactions data to Bank Transaction CSV (3-Column) - and how we solve them

Invalid OFX File

File is not a valid OFX/QFX format

CSV file or corrupted OFX

Valid OFX file from bank download

Ensure you're uploading an OFX/QFX file directly from your bank

Download the OFX file again from your bank's website

No Transactions Found

OFX file contains no transaction data

OFX file with empty BANKTRANLIST

OFX file with at least one STMTTRN

Ensure the date range in your bank download includes transactions

Download a different date range with transaction activity

Duplicate Transaction IDs

Multiple transactions with same FITID (will cause import issues)

Same FITID used for different transactions

Unique FITID for each transaction

The tool generates unique IDs if FITID is missing or duplicated

Allow the tool to auto-generate unique transaction IDs

Frequently Asked Questions

Your data never leaves your device. All files are processed entirely in your browser using client-side JavaScript - no data is stored on our servers or sent anywhere. There's no account to hack, no database storing your files, and no API connections to your bank or accounting software. You upload, convert, download, and we forget it immediately.

No payment or signup required. You can upload your file, see a free preview of the conversion results, and verify everything looks correct before paying anything. If it doesn't work for your files, you haven't wasted any money. We only charge when you're satisfied and ready to download the final converted file.

You can, but free scripts and AI often miss edge cases that break real-world data: missing SKUs, currency formatting quirks, tax calculation errors, or date format mismatches. We have battle-tested validators specifically designed for accounting software imports that catch these issues before they corrupt your books. Plus, you get instant browser-based conversion without installing Python or managing dependencies.

OFX (Open Financial Exchange) is the base format. QFX is Quicken's variant with Intuit-specific headers. QBO is QuickBooks Desktop's variant. All three are XML-based and use the same transaction structure, so this tool converts all of them to QuickBooks Online CSV.

QuickBooks Online will attempt to match transactions based on date, amount, and description. Review the import carefully and use QBO's 'Match' feature to link duplicates. We recommend importing transactions outside your existing feed range to avoid duplicates.

Check numbers are preserved in the description (e.g., 'Check #1234'). The original bank transaction ID (FITID) is not imported to QBO CSV (CSV format doesn't support it), but it's used during conversion to prevent processing duplicates.

Currently, you need to convert files one at a time. However, you can combine the resulting CSV files in Excel before uploading to QuickBooks Online. Just ensure you don't duplicate the header row.

Yes! Credit card transactions from OFX files are converted the same way. Just make sure to upload the CSV to the correct credit card account in QuickBooks Online (not your bank account).

OFX files typically don't include category information (that's added by accounting software). QuickBooks Online's CSV import doesn't support categories either - you'll need to categorize transactions using bank rules or manually after import.

First transactions are free to preview. Full conversions use credits based on transaction count (0.5 credits per 1,000 rows, minimum 5 credits).

Absolutely. All conversion happens entirely in your browser using client-side JavaScript. Your OFX file is never uploaded to our servers. Your bank transactions never leave your computer.

Yes, QuickBooks Online supports OFX file uploads through the Banking section. Use the File Upload button and select your OFX file to import transactions.