Convert XLSX to OFX

Turn XLSX workbooks into OFX. The first worksheet must have the header row a bank statement converted to xlsx here has, naming only the columns account, date, amount, currency, payee, memo, reference, balance, type, category and id, in any order, with dates as date cells or YYYY-MM-DD text and amounts as numbers in every row; any other sheet fails with unsupported_elements.

Converted in an isolated sandbox on our serversDeleted after 24 hours

Drop XLSX files on the dialor turn it to pick what to do

A bank statement your money app can import.Each account and currency becomes its own statement in one OFX file.

  1. What you get

    One OFX 2.1.1 file with a statement for each account and currency. Credit card accounts become credit card statements, so Quicken, GnuCash and other money apps can import them.

    Each transaction keeps its posting date and amount. Its type is kept when it is an OFX type. Otherwise the type is CREDIT or DEBIT, set by the sign of the amount.

  2. What the sheet needs

    Only the first worksheet is read, and it needs a header row. The header names only these columns, in any order: account, date, amount, currency, payee, memo, reference, balance, type, category and id.

    Dates are date cells or YYYY-MM-DD text. Amounts are numbers in every row. Any other sheet in the workbook makes the conversion stop with unsupported_elements.

  3. How fields are written

    The id becomes the FITID. When a row has no id, one is made from the row. The payee becomes NAME, cut to 32 characters, with up to 100 characters in EXTDNAME. The memo is kept up to 255 characters. A numeric reference becomes CHECKNUM.

    The ledger balance is the closing balance the sheet gives, or 0.00 when it gives none. A statement without a currency gets XXX. A statement without a bank number gets 000000000.

    To combine several workbooks first, use merge XLSX. For other outputs, see every XLSX conversion.

XLSX and OFX.What each format is.

The formats

From · XLSX

Excel Workbook

Excel's workbook format since 2007. Sheets, formulas, formats and charts in zipped XML.

Extensions
.xlsx
MIME type
application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Kind
Documents
To · OFX

OFX Bank Statement

Open Financial Exchange, the statement download of North American banks and card issuers that Quicken, GnuCash and most money apps import; QFX is Quicken's flavor of it.

Extensions
.ofx .qfx
MIME type
application/x-ofx
Kind
Text and data

In your code.The same XLSX to OFX conversion through the API, for your app or your agent.

terminal
$ cv convert sheet.xlsx sheet.ofx
$ cv convert sheet.xlsx sheet.ofx

Questions.What people ask about XLSX to OFX.

01OF 04

Only the first worksheet. Any other sheet makes the conversion stop with unsupported_elements.

Account, date, amount, currency, payee, memo, reference, balance, type, category and id, in any order. The header names only these columns.

NAME holds the first 32 characters. EXTDNAME holds up to 100 characters.

Yes. The output is an OFX file that Quicken, GnuCash and most money apps import.

More conversions.Other ways in and out of XLSX and OFX.