mmex2json
v1.0.0
Published
Converts QIF data exported from Money Manager EX to JSON format
Downloads
4
Readme
mmex2json
Converts QIF data exported from Money Manager EX to JSON format.
A thin wrapper around qif2json to handle multiple accounts, account metadata, and some MMEX-specific attributes.
Usage
This is a command line utility. It reads from a specified file, and outputs to standard output - which you can pipe to a file.
With npx
(most convenient):
npx mmex2json <qif-file> > <output-file>
e.g.
npx mmex2json exported.qif > converted.json
By installing globally:
npm install -g mmex2json
mmex2json <qif-file> > <output-file>
Exporting a QIF file from Money Manager EX
- File > Export > QIF Files
- Categories - leave unticked
- Accounts - choose one or many
- Date Format - leave as DD/MM/YY
Note that unselected accounts are included in the export if there are transfers between them and an account that is selected. Only the transactions for those transfers are included.
QIF is the only export format available that supports split transactions (across multiple categories).
Tested with Money Manager EX version 1.3.3.
Output format
The root is an array of accounts, each of which has information and transactions:
[
{
"info": {
"currency": "GBP",
"initialBalance": 0,
"name": "ACME Current Account",
"type": "Bank",
"finalBalance": 100
},
"transactions": []
}
]
Transaction attributes are as per qif2json, with the addition of isTransfer
to denote transfers. This includes all transaction attributes from MMEX, including split transactions.