Bank CSV & Excel to QBO, QFX and OFX Converter

Convert bank and credit-card statements exported as CSV or Excel into files that accounting software imports directly:

• QBO: QuickBooks Web Connect (QuickBooks Desktop and QuickBooks Online "Upload from file")
• QFX: Quicken (Windows and Mac)
• OFX (1.x SGML or 2.x XML): Xero, GnuCash, Moneydance, MoneyMoney, Banktivity, YNAB-compatible tools, and most other personal-finance apps

The Actor uses the same conversion engine as the free Rowbridge web converter. It is built for bulk and automated work: point it at many statements at once, or call it from Make, Zapier, n8n, the Apify API, or an AI agent over MCP.

Why use this CSV to QBO converter?

• Detects columns automatically. Finds the date, payee, memo, amount, split debit/credit columns, Dr/Cr flag columns, check numbers and running balance in English, German, Spanish, French, Dutch, Italian and Portuguese headers.
• Handles real bank exports. Covers preamble rows above the header; , ; tab and | delimiters; 1.234,56 European decimals; (123.45) negatives; DD/MM vs MM/DD detection; Excel serial dates (including 1904 workbooks); and Windows-1252 encoding.
• Produces stable FITIDs. Re-importing an overlapping statement does not create duplicates in QuickBooks or Quicken.
• Fixes Quicken error CC-885. QBO/QFX files carry a configurable INTU.BID (3000 by default).
• Takes the ledger balance from the balance column when there is one, from your input, or from the net of the transactions.
• Has no row limit. Each input file produces one output file.

Input

Field	What it does
files	List of URLs to CSV/TSV/XLSX/XLS files (Dropbox/Drive direct links, S3 or any HTTPS URL)
csvText	Pasted CSV text instead of a URL
format	qbo (default), qfx or ofx
ofxSyntax	sgml (default) or xml, for OFX only
accountType	CHECKING, SAVINGS, CREDITCARD, MONEYMRKT, CREDITLINE
accountId, bankId, currency, intuBid	Header values the accounting app uses to match the account
dateOrder, decimal	auto by default; force them when a file is ambiguous
flipSigns	For card exports that list charges as positive numbers
endingBalance	Overrides the ledger balance
includeFileContent	Returns the QBO/OFX text inside the dataset item (useful for API and agent callers)

Example:

{
  "files": [{ "url": "https://example.com/statements/chase-september.csv" }],
  "format": "qbo",
  "accountType": "CHECKING",
  "accountId": "4321"
}

Output

Each converted file is saved to the run's key-value store (for example 001-chase-september.qbo). One dataset item per input file includes a download link and a reconciliation summary:

{
  "source": "us-signed-amount.csv", "status": "ok", "format": "qbo",
  "outputKey": "001-us-signed-amount.qbo", "outputUrl": "https://api.apify.com/v2/key-value-stores/…/records/001-us-signed-amount.qbo",
  "transactions": 45, "dateFrom": "2026-01-02", "dateTo": "2026-03-12", "netAmount": -44009.59,
  "ledgerBalance": -44009.59, "ledgerSource": "net of transactions", "rowErrors": 0,
  "dateOrder": "MDY", "dateOrderAmbiguous": false, "decimalSeparator": ".",
  "columnMapping": { "date": "Date", "payee": "Description", "amount": "Amount" }
}

A file that cannot be downloaded or parsed returns status: "error" with a message, and the run moves on to the next file.

Pricing

Pay per event. You are charged $0.05 per converted file (file-converted), and only after the output file is saved. Files that fail are not charged. A 500-row statement costs the same as a 5-row one.

Privacy

Files are processed in memory inside your own Apify run. Nothing is sent to third parties. Outputs stay in your run's storage under your account's data-retention settings.

FAQ

Will QuickBooks Online accept the QBO? Yes, through Banking → Upload transactions → "Upload from file". Can I convert PDF statements? No. This Actor takes CSV and Excel files only. Export CSV from your online banking first. Can I import Excel files with several sheets? Yes. Set sheetName; the first sheet is used by default.

QuickBooks and Quicken are trademarks of their owners. This Actor is not affiliated with Intuit or Quicken Inc.