Formatters & Code
Bank Statement CSV to OFX QBO Converter and OFX Import
Convert CSV or supported OFX bank statements to QBO locally. Select an account, preserve original OFX IDs and balances, and review transactions before export.
Convert an existing OFX statement to QBO or OFX
Select a bank or credit-card statement, review one account at a time, then export without regenerating its transaction IDs, dates or closing balance. All processing stays on this device.
1. Choose an existing statement
Choose a file instead of pasting
OFX 1 or OFX 2 bank and credit-card statements, up to 20,000 transactions per account. Unsupported financial records block conversion rather than being discarded.
Supported records and limits
Investment records, correction instructions, unsupported tags, duplicate transaction IDs, malformed statements and missing ledger balances block conversion. Amounts with more than two decimal places are rejected. The file limit is 10 MB.
Select or paste an existing statement.
2. Review one account
3. Approve and download
Only the selected statement is exported. Financial transaction fields and balances are retained; the response envelope is normalised and session credentials are omitted. Back up your accounting data and test the intended QuickBooks edition before importing real transactions.
Convert CSV or inspect a statement
Results
What the result means
The existing-OFX workflow parses a supported banking and credit-card subset, keeps account statements separate and retains source transaction IDs, timestamps and balances for one selected account. The separate CSV workflow maps dates, descriptions and amounts, and generates deterministic IDs; it requires an actual closing balance and balance as-of date, separately from calculated net movement. It does not import a closing-balance column automatically. The quick viewer is a limited transaction reader, not a multi-account or closing-balance validator. Review the receiving application's requirements separately: syntax, presets and generated IDs do not guarantee acceptance or duplicate prevention.
What is the difference between CSV and OFX?
CSV stores rows and columns, with field names and date or amount conventions that depend on the exporter. OFX describes financial accounts and transactions using named fields, including currency, transaction dates, amounts and transaction identifiers. Converting a CSV requires checking what each source column means; changing the filename does not create an OFX file.
| Detail | Bank CSV | OFX / QBO output |
|---|---|---|
| Structure | Delimited rows with exporter-specific columns | Named account and transaction fields |
| Dates and amounts | Must interpret the source format and debit/credit signs | Mapped to transaction dates and signed amounts |
| Transaction identity | May omit a stable identifier | Includes a FITID for each transaction |
| Import compatibility | Depends on the receiving app's CSV template | Depends on the receiving app's supported OFX/QBO version and account requirements |
How to convert CSV file to OFX format?
- Load your bank CSV and map its date, description and amount columns.
- For example, map a row with date
2026-10-01, descriptionCoffee shopand amount-4.50to an outgoing transaction dated 1 October 2026. Check the source bank's sign convention before applying this mapping to the whole file. - Choose the OFX version your finance app accepts, or QBO for a supported Web Connect workflow. Review the account identifiers, currency, preview rows and money-in/money-out totals before downloading.
- Compare the imported transactions with your original statement. A correctly structured file alone does not guarantee the receiving app will accept its institution or account details.
Read the bank CSV to OFX / QBO conversion guide for mapping and import checks.
Related tools
Guides
Questions
Can I convert an existing OFX file to QBO?
Yes. Use Convert an existing OFX statement to QBO or OFX, inspect the accounts and review one selected statement. The supported banking and credit-card subset retains transaction IDs, full timestamps, currencies and actual balances. Unknown structures and corrections block conversion. QBO export requires real institution metadata and does not guarantee QuickBooks acceptance.
What is the difference between CSV and OFX?
CSV is a table whose columns and formatting depend on the exporter. OFX is a financial exchange format with named account and transaction fields. The converter maps your CSV columns into those fields; you still need to check date formats, debit/credit signs, currency and account details before importing.
How to convert CSV file to OFX format?
Load the CSV, map its date, description and amount columns, choose the supported OFX output version, and inspect the preview and totals. Confirm the account settings and debit/credit direction before downloading. Check the imported rows against your original statement in the receiving finance app.
Does my financial data or bank statement leave my browser?
No. All CSV parsing, column mapping, and OFX/QBO container generation take place completely inside your local browser memory using JavaScript. No files, payees, or amounts are ever uploaded to any server.
Why does QuickBooks reject some CSV files but accept QBO files?
QBO is an OFX-derived Web Connect format with named account fields and transaction IDs. CSV is a table whose columns must be mapped. Neither format guarantees acceptance, correct account identity or reconciliation in the receiving application.
What is an INTU.BID and why is it needed for QuickBooks?
INTU.BID identifies an institution in Intuit's Web Connect integration. Use your actual institution's metadata. A preset or a correctly structured file does not guarantee acceptance by your QuickBooks edition or account.
Can I inspect an existing OFX or QBO file without QuickBooks?
The lower quick viewer displays transaction rows and basic metadata, with a 100-row preview. It does not verify closing balances or separate multiple accounts reliably. Use Inspect OFX accounts in the existing-OFX workflow for supported account-separated review and supplied ledger balances.