[GNC] How can I add statement balances to my accounts as

armanschwarz armanschwarz at gmail.com
Fri Nov 1 08:36:20 EDT 2019


I've written a command-line tool for my own personal use that implements
basic assertions.

For my part, I've found this incredibly useful. I've used GnuCash for only a
couple of months but this tool has already uncovered several errors that
crept in after reconciliation.

I've published this on github for anyone who is interested:
https://github.com/armanschwarz/gnucash_balance_assertions">https://github.com/armanschwarz/gnucash_balance_assertions

Usage is ./gnc_assert.py [path] [assertion regex] -d [digits]

So for example I've started adding zero-balance transactions with the format
"Balance Assertion: 123.45" at the date of each bank statement. Then I
provide the tool with the path to my gnucash accounts file, the regex that
digs the balance out of the balance assertion format that I use (in my case
this would be something like "(?<=Balance Assertion:)\d*\.\d\d" and provide
"2" as the number of decimal places to compare, so:

./gnc_assert.py path/to/account.gnucash "(?<=Balance Assertion: )\d*\.\d\d"
2

Output looks like this:

found 0 assertions in account 'Current Assets':
found 5 assertions in account 'Bank account A':
    2018-02-28: checking value 123.45 against balance of 123.45...OK
    2018-03-31: checking value 234.56 against balance of 230.56...ERROR
    2018-04-30: checking value 223.45 against balance of 223.45...OK
found 0 assertions in account 'Fixed Assets':
found 1 errors!



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html


More information about the gnucash-user mailing list