OFX, QFX & QBO to CSV / JSON Converter
Pricing
from $30.00 / 1,000 statement parseds
OFX, QFX & QBO to CSV / JSON Converter
Turn OFX, Quicken QFX and QuickBooks QBO bank or credit-card files into clean CSV and JSON: date, amount, payee, memo, check number, FITID and balances. SGML and XML OFX supported.
Pricing
from $30.00 / 1,000 statement parseds
Rating
0.0
(0)
Developer
oqen
Maintained by CommunityActor stats
0
Bookmarked
2
Total users
1
Monthly active users
a day ago
Last modified
Categories
Share
OFX, QFX and QBO to CSV / JSON Converter
Turn OFX, Quicken QFX and QuickBooks QBO bank and credit-card files into clean CSV and JSON, ready for Excel, Google Sheets, a database, a BI tool or an LLM pipeline.
The Actor reads both OFX 1.x (SGML, including files with no closing tags and minified one-line files) and OFX 2.x (XML). It handles multiple accounts in one file, covering both bank (STMTRS) and credit-card (CCSTMTRS) statements.
What you get for each statement
- One CSV with the columns
date, amount, payee, memo, type, checkNumber, referenceNumber, fitId, currency, dateUser, accountId, accountType - A JSON file with the full statement
- A dataset item with the account number and type, currency, statement period, ledger and available balances, transaction count and net amount. It also includes the transaction array unless you turn
includeTransactionsoff.
HTML entities (&, é …) are decoded. Text in Windows-1252 encoding is detected. Commas and quotes are escaped correctly in the CSV. The CSV delimiter can be a comma, semicolon or tab, so files open correctly in European Excel.
Common uses
- Move years of downloaded QFX/QBO history into a spreadsheet or data warehouse
- Feed bank transactions to an AI agent (the Actor is callable over Apify MCP) for categorisation or audit
- Check a QBO file before importing it: dates, totals and duplicate FITIDs
- Migrate away from Quicken or QuickBooks Desktop
Input
You can also paste the file content into ofxText.
Output example
Pricing
Pay per event: $0.03 per parsed account statement (statement-parsed). Files that are not OFX, or that fail to download, are not charged.
Related
To go the other way, from CSV/Excel to QBO, QFX or OFX, use the Rowbridge CSV to QBO/QFX/OFX Converter Actor.
