Utilities for batch editing a KMyMoney's XML file
This script processes transactions listed in a KMyMoney's XML file and modifies certains attributes in a batch mode.
Features:
- fixing mismatching splits in transactions of KMyMoney's XML file,
- erasing/setting "number" inside a split in a transaction in batch mode,
- overwrite reconcile flag in all splits in all transactions.
Read the article "Structure of a KMyMoney XML File" to better understand the file format.
Use
Decompress gzipped *.kmy file first and then run the script:
cat [inputfile].kmy | gunzip > [inputfile].xml
python3 kmymoney_utils.py [-enh] [-s <count>] [-r <flag>] [-o <outputfile>] <inputfile>.xml
Detailed help:
python3 kmymoney_utils.py [-enh] [-s <count>] [-r <flag>] [-o <outputfile>] <inputfile>.xml
Input arguments:
-o --output Output file, if not specified, output file is set to
"<input file>_fixed.xml". Input file should always be a KMyMoney XML file.
-e --erase-txn-numbers Erase all transaction numbers (i.e. "number" attribute in a split).
-n --assign-txn-numbers Assign integer values to all transactions in an account
sorted in chronological order by "post date". The earliest transaction
is assigned number 1, the ones following it will have numbers incremented
by one. Iterate over all asset accounts.
-s --fix-splits-with-count <count> If <count> is 2, then fix empty payee for the second split in a transaction
with 2 splits by assigning the payee from the first split.
If <count> is 1, then display transactions with a single split.
In a double-entry accounting system, there have to be two splits in a
transaction for the consistency purpose.
Usually, payees in a transaction with 2 splits should be identical.
Transactions with 1 split should be checked manually, because
even for opening balances the money is transferred from an equity account,
which means the 2nd split must exist and contain equity account information.
-r --reconcile-flag <flag> Assign reconcile <flag> to all splits in all transactions.
<flag> can be equal to -1 (unknown), 0 (not reconciled), 1 (cleared),
2 (reconciled) or 3 (frozen).
-c --set-expenses-currency <curr> Set all expense accounts' currency to <curr>.
-h --help Print this help message.