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.
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.
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.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
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
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.
$ cv convert sheet.xlsx sheet.ofx$ cv convert sheet.xlsx sheet.ofxQuestions.What people ask about XLSX to OFX.
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.