Skip to main content
ConvertBank to Excel Logo

Choose your OFX workflow

Start with the file you have and how its transaction amounts are recorded. These two workflows prepare spreadsheet transactions for OFX export; they do not extract PDF transactions.

Prefer a native export from your bank: use OFX or QFX when your destination accepts it, or a bank CSV export when it offers a suitable direct import. Convert only when needed.

Which amount layout do you have?

XLS, XLSX or CSV to OFX — signed amounts

Use a single signed amount column: negative amounts for withdrawals and positive amounts for deposits. For XLS and XLSX, put transactions in the first worksheet with headers in the first row.

Map the date, description and amount columns, and choose the date format that matches your file.

Bank CSV to OFX — Withdrawal and Deposit columns

Use separate unsigned Withdrawal and Deposit columns. Amounts must be nonnegative; leave the unused side blank or zero, with only one nonzero amount per transaction.

Keep headers in the first row. Map both amount columns and confirm the date format before exporting.

Starting with a PDF or scan?

PDFs and scans are not supported by these widgets. Use the separate extraction workflow, then check the extracted dates, descriptions and amounts against the statement before preparing OFX.

Before exporting or importing

  • Have your actual bank ID, account ID, account type and currency ready, plus the statement's closing ledger balance and its as-of date. Do not use sample values or defaults in place of your actual details.
  • The preview shows the first five transactions only. Check every transaction in the downloaded OFX against the source, including dates, amount signs, row count, totals, duplicates and the closing balance.
  • Imports into external accounting software have not been tested. Test with a copy of your accounts before importing into live records, and check the destination's import requirements and duplicate handling.