Hi,
I'm trying to produce a simplified balance sheet and income/expense
statement for a set of accounts. I can produce the opening balance with:
ledger -f ledger.dat -V -X £ --end $begin -n bal Assets Liabilities
the income/expense report with
ledger -f ledger.dat -B -X £ --begin $begin --end $end bal Income Expenses
and the final balance sheet with
ledger -f ledger.dat -V -X £ --end $end bal Assets Liabilities
and this makes me generally happy.
However, in the presence of fluctuating non-£ commodities, the sum of
balances from report (1) and report (2) will not add to the balance of
report (3); there will be an unaccounted for gain/loss in the balance
from the change in valuations. That's fine, but I'd love to get at that
value to be able to display it, ideally on a per-account basis.
My first try:
ledger -f ledger.dat -G -X £ --begin $begin bal Assets Liabilities
does not work, as it does not capture any changes in accounts with
commodities from transactions earlier than $begin. It does produce a
useful-looking per-account set of balances that are right for the
changes that it has captured; it just doesn't get everything.
My second try:
ledger -f ledger.dat -G -X £ -d "d>=[$begin]" bal Assets Liabilities
gives me an error
While evaluating value expression:
(d >= [2012/01/01])
^^^^^^^^^^^^^^^^^^^
While comparing if 2013/03/09 22:31:02 is less than 2012/01/01:
Error: Cannot compare a date/time to a date
which seems to be trying and failing to compare now to the date I gave.
My third try:
ledger -f ledger.dat -G -X £ -d "d>=[$begin]" reg Assets Liabilities
does actually display all the expected revaluation transactions, but
doesn't give me a handy by-account summary (or indeed enough information
to reconstruct the accounts to which each revaluation would pertain).
Really I'd want my second try to work, to match my mental model of how
to drive ledger... but maybe that's just me.
Any help on this would be appreciated.
Thanks,
Christophe
--
---
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].
For more options, visit https://groups.google.com/groups/opt_out.
