Hi Chary and all,
I don't have time for a long reply but here are some quick thoughts:
Chary Chary <chary...@gmail.com> writes:
> The approach is quite simple
>
> 1.
>
> Expenses are tracked at the historical exchange rate (e.i. at the
> exchange rate, available during transaction). When exchange rate changes,
> Expenses and Income do not get re-calculated.
> This is believed to be inline with conventional wisdom , that if you have
> consumed pizza for 10 USD, there is no reason to re-calculate how much this
> pizza is worth now in EUR, when USD/EUR exchange rate changed. It only
> makes sense to know how much that pizza was worth in EUR, when you consumed
> it.
This sounds like ledger's -H/--historical flag.
> 1.
>
> Assets and Liabilities on the other side are recalculated with every
> event of exchange rate change.
>
> This is also inline with conventional wisdom. If you own 1000 of Currency /
> stock XYZ and all of a sudden this currency became more expensive (just
> think of Bitcoin), this means you actually got reacher and you want to see
> it.
This sounds like ledger's -X/--exchange flag, in combination with price
declarations.
> 1.
>
> The exchange rate changes are taken care in the following way:
>
> A special Commodity Revaluation transaction is logged. Following the
> principle of double-entry accounting
>
> -
>
> one shoulder of transaction is logged to corresponding Asset and / or
> Liability accounts to adjust these accounts to new exchange rate.
> -
>
> another shoulder is logged to special Gain due to commodity price change
> (trading
> account, using Peter Selinger’s terminology).
I *think* these commodity revaluation transactions are the same as those
generated automatically (which you can see in the register report) when
you run with -X. (If not, you may need to do something to model these
transactions in your journal file the way you want them, perhaps with
some combination of costs ('@' syntax), lot prices ('{ }' syntax), and
(real or virtual) accounts to track the gains and losses.)
So do the following commands show you the answers to the questions that
you're looking for?
1) ledger reg -H Expenses Income
2) ledger reg Assets Liabilities -X 'USD' # or whatever currency
I realize that these are not balance reports where the totals are
grouped by account (but then again, neither is your spreadsheet). But
do they give you all the information you need to see how you got from
one balance sheet to a later one?
It would be helpful if you could enter the data in your spreadsheet into
a ledger journal file and then see if/how these reports from ledger
differ from what you expect, based on your own spreadsheet.
--
Best,
Richard
--
---
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 ledger-cli+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
