[GNC-dev] tb, gnc or me? my trial balance is wrong and I think it is gnc not me
wm_o_o_o at yahoo.co.uk
Sat Feb 9 02:00:24 EST 2019
Background: My gnc TB has been wrong for years. This hasn't been a
problem for me because I can do my own TB in sql and satisfy myself all
is relatively well with my accounts. Over the last week or so I decided
to try again and I think the gnc TB report is b0rked.
Looking at the bug list, I'm not making a new observation, the gnc TB is
not a feature of which to be proud but I think I can help.
The problems seem to be centered around two things:
1. using currency other than your home currency
2. related to that, using trading accounts
Guess what? If it was that simple it would have been solved by now, right?
I have loads of tx in a number of currencies using trading accounts that
don't make the gnc TB throw a wobbly but have identified the first that
makes it go wrong.
So, let's look at a tx that does make it go wrong, maybe someone will
help me to think, it is possible I've looked at this for too long and am
missing something really obvious.
Liabilities:Loans:T:T ZAR Dr 7,963.46
Liabilities:Loans:T:T USD Cr 771.22
The numbers are real, I've changed the account names slightly, I've
separated this particular tx as the first that makes the gnc TB go wrong
and does actually balance by my understanding of accounting and mathematics.
The prices look right, the actual exchange rate is real, what is wrong?
Things to consider:
If the price to be used is the issue, is the gnc TB using the right
price? My answer may be "yes, usually it does use the right price, I
can't work out why it sometimes doesn't"
Does this raise an accounting honesty issue?
I think it does.
If you need to roll your own to get a TB from a transaction stream
something isn't right.
Alternatively, please help me to see what is wrong with my tx.
have a joke: Trump wants to be the Dutch boy, first he needs a dyke,
then he realises his fingers are tiny :)
More information about the gnucash-devel