Convert Tangerine CSV to QBO / QFX / OFX
Drop your Tangerine CSV or Excel export below and get a Tangerine → QuickBooks/Quicken/Xero file in seconds. Private — nothing leaves your browser.
Advanced — bank identifiers (for "file not recognized" issues)
QuickBooks/Quicken use INTU.BID to recognize the file. Pick your bank above to autofill, or paste your own.
Free: up to 25 transactions per file. Pro (one-time $29): unlimited.
How to export your transactions from Tangerine
Tangerine is a Canadian digital bank (Scotiabank subsidiary; formerly ING Direct Canada) and is effectively CSV-only for our purposes. It is ABSENT from the authoritative Intuit fidir.txt (no QuickBooks/Quicken Web Connect BID), and its OFX has been broken for years: SSL validation of Tangerine's OFX servers fails consistently from ~Aug 2022 and OFX validation failed completely by ~Apr 2023; only flaky Express Web Connect lingered in Canadian Quicken. There is NO published, verifiable INTU.BID/ORG/FID, so ORG='', FID='0', intuBid='', confidence=none - do NOT fabricate. Classic neobank CSV-pain case: the bank reliably gives only CSV, and our page's value is 'here's how to get it into QuickBooks/Quicken anyway' via CSV -> QBO/QFX conversion. EXPORT (Tangerine web; export is on the website, not fully in-app): Log in > select the account (Chequing/Savings or Credit Card) > 'Download Transactions' > choose a date range > for Download format pick CSV (Tangerine also lists QFX/Quicken and OFX/Microsoft Money, but those rely on the broken OFX path - CSV is the dependable one). CSV layout HAS a header row; columns are Date, Transaction (type, e.g. credit/debit/transfer), Name (payee/description), Memo (extra detail), Amount. Amount is a SINGLE SIGNED column (deposits positive, withdrawals negative) - no separate debit/credit columns. Date format in Tangerine exports is commonly M/D/YYYY (US-style MDY) despite being Canadian - set MDY and let users override to DMY/ISO. Mapping: Date->date, Name (+Memo)->payee/memo, Amount->signed OFX amount.
Once you have the file, drop it into the converter above. LedgerBridge auto-detects the date, amount and description columns — adjust the mapping if needed, choose QBO for QuickBooks (or QFX for Quicken, OFX for Xero), and download.
Tips for Tangerine files
- Choose DD/MM/YYYY as the date format if auto-detect guesses wrong.
- If withdrawals come in as positive numbers, tick “Flip amount sign”.
- For credit-card exports, set the account type to Credit card.
- If QuickBooks rejects the file, open Advanced and confirm the INTU.BID — selecting “Tangerine” in the bank dropdown autofills it.
FAQ
How do I export a CSV from Tangerine?
Tangerine is a Canadian digital bank (Scotiabank subsidiary; formerly ING Direct Canada) and is effectively CSV-only for our purposes. It is ABSENT from the authoritative Intuit fidir.txt (no QuickBooks/Quicken Web Connect BID), and its OFX has been broken for years: SSL validation of Tangerine's OFX servers fails consistently from ~Aug 2022 and OFX validation failed completely by ~Apr 2023; only flaky Express Web Connect lingered in Canadian Quicken. There is NO published, verifiable INTU.BID/ORG/FID, so ORG='', FID='0', intuBid='', confidence=none - do NOT fabricate. Classic neobank CSV-pain case: the bank reliably gives only CSV, and our page's value is 'here's how to get it into QuickBooks/Quicken anyway' via CSV -> QBO/QFX conversion. EXPORT (Tangerine web; export is on the website, not fully in-app): Log in > select the account (Chequing/Savings or Credit Card) > 'Download Transactions' > choose a date range > for Download format pick CSV (Tangerine also lists QFX/Quicken and OFX/Microsoft Money, but those rely on the broken OFX path - CSV is the dependable one). CSV layout HAS a header row; columns are Date, Transaction (type, e.g. credit/debit/transfer), Name (payee/description), Memo (extra detail), Amount. Amount is a SINGLE SIGNED column (deposits positive, withdrawals negative) - no separate debit/credit columns. Date format in Tangerine exports is commonly M/D/YYYY (US-style MDY) despite being Canadian - set MDY and let users override to DMY/ISO. Mapping: Date->date, Name (+Memo)->payee/memo, Amount->signed OFX amount.
Is my Tangerine data uploaded anywhere?
No. The conversion happens entirely in your browser. Your statement and account number never leave your device — safe even for client confidentiality requirements.
Will the file import into QuickBooks?
Yes. We generate a valid OFX 1.0.2 (SGML) document with the correct header and identifiers. Convert a small file free first to confirm it imports cleanly, then unlock unlimited.