Hi all,

I am working on some tax returns, and am seeing something which, to my amateur eyes, seems strange. When I run a balance report for my entire ledger that covers multiple years, I come to one amount. However, when I then run balances for the individual years, the balances don't add up together.

Please see below an example of what I did for the "income" account which consists of several sub accounts and I also have multiple currencies. In order to not reveal confidential information, I have introduced a random currency 'RND' with a single fixed exchange rate to my normal reporting currency.

$ ledger bal -f balance-question.ledger income -e 2017-01-01 -X RND | head -1; 
ledger bal -f balance-question.ledger income -b 2017-01-01 -e 2018-01-01 -X RND 
| head -1; ledger bal -f balance-question.ledger income -b 2018-01-01 -e 
2019-01-01 -X RND | head -1; echo; ledger bal -f balance-question.ledger income 
-e 2019-01-01 -X RND | head -1
     RND -261127,97  income
     RND -174407,32  income
     RND -226957,44  income

     RND -661750,74  income

Adding these numbers up, I would expect a total balance of RND -662492,73 instead of the total balance of -661750,74 I find now. This poses an issue for me as I determine my profit by subtracting my yearly expenses from my yearly income and I expect the profit of year 1, plus year 2, plus year 3, to be equal to my total profit over the years.

Can someone else see a similar issue with their own balances? Or am I misunderstanding something as to how balances should align with each other? When I run a register report for these 3 periods and for the 1 total period instead of a balance report, I get the same numbers for both.

I wonder if it can somehow be explained by the exchange rates / commodity values that are selected when including date criteria?

Any ideas?

Kind regards,

Remco Rijnders

--

--- You received this message because you are subscribed to the Google Groups "Ledger" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To view this discussion on the web visit 
https://groups.google.com/d/msgid/ledger-cli/20191009223000.GT2603%40settler.webconquest.com.

Reply via email to