CSVQBO / Practical guide

Convert Excel bank transactions to OFX

Use a one-sheet XLSX containing bank transaction values and create a locally generated OFX statement.

Flatten the workbook

Keep one worksheet with a single account and currency. Use values, not formulas or merged transaction cells. Legacy .xls is unsupported: save as .xlsx first. The parser rejects formulas rather than substituting potentially stale cached results. Native spreadsheet dates and ISO YYYY-MM-DD dates are accepted.

Choose amount and date conventions

An Amount column takes precedence if both Amount and Debit/Credit exist. Remove unused columns or explicitly map the intended amount header. Select dot decimals for 1,234.56 and decimal commas for 1.234,56. Dates with two-digit years are rejected to avoid inventing a century.

Keep a real balance

The OFX statement includes a required ledger-balance block. Use the actual closing balance for the last included transaction date, even if negative. A sum of this file’s transactions is not the closing balance unless the opening balance was truly zero. The tool does not infer an opening balance.

Verify the result independently

Download the normalized CSV or XLSX report alongside OFX. Compare the signed sum and first and last dates with your workbook. The export is OFX 1.02 SGML; Quicken and other finance tools have their own bank-identity and file-acceptance policies. No live account connection or currency conversion is performed.

Try a real free conversion See one-time packs

Written by Zijian Xiao. Examples are synthetic. Review all extracted results against your original source file.