That seems to get me a step closer, but I still see a balance of $94.87
when I run my balance reports.
ledger -f register.ldg --price-db price_db.txt -V --strict --explicit bal
--depth=1 -e 2019-03-20
$xxx,xxx.xx Assets
$-xxx,xxx.xx Equity
$xxx,xxx.xx Expenses
$-xxx,xxx.xx Income
$-xxx,xxx.xx Liabilities
--------------------
$94.87
The same report with the --unrealized flag also shows the same balance, but
the unrealized category is now gone.
ledger -f register.ldg --price-db price_db.txt -V --strict --explicit bal
--depth=2 -e 2019-03-20 --unrealized
$xxx,xxx.xx Assets
$-xxx,xxx.xx Equity
$-xxx,xxx.xx Opening Balances
$xxx,xxx.xx Expenses
$-xxx,xxx.xx Income
$-xxx,xxx.xx Liabilities
--------------------
$94.87
I'm missing something here. How do I record the $94.87 as a capital gain
and make the report balance to zero?
Thanks
JL
On Sunday, October 3, 2021 at 8:23:20 PM UTC-5 [email protected] wrote:
> Your asset sale is actually an income category and should be recorded as
> such. In the same transaction you record the cost of the asset sold as an
> expense:
>
> 2019/03/18 * Buy xx
> Assets:Investing:ABC Securities:xx 5.37578 xx @
> $26.725424031
> Equity:Opening Balances
>
> 2019/03/19 * Sell xx
> Income:Investing:ABC Securities:Sales -5.37578 xx @
> $44.373095625
> Assets:Investing:ABC Securities:Cash $238.54
> Assets:Investing:ABC Securities:xx -5.37578 xx @
> $26.725424031
> Expenses:Investing:ABC Securities:Cost of Sale $143.67
>
>
> On Monday, October 4, 2021 at 8:53:07 AM UTC+8 Jasel17212 wrote:
>
>> I've run into an issue that I just can't find an answer to in either the
>> manual or archived conversations from this group, so I thought I would post
>> to see if you guys can help me out.
>>
>> Following is an example of a stock transaction:
>>
>> 2019/03/18 * Buy xx
>> Assets:Investing:ABC Securities:xx 5.37578 xx @
>> $26.725424031
>> Equity:Opening Balances
>>
>> 2019/03/19 * Sell xx
>> Assets:Investing:ABC Securities:xx -5.37578 xx @
>> $44.373095625
>> Assets:Investing:ABC Securities:Cash
>>
>> After completing the transaction, all of my ABC Securities:Cash balance
>> is correct, and all is good. If I run a balance report, however, I see a
>> $94.87 balance when I expected to see $0.00.
>>
>> ledger -f register.ldg --price-db price_db.txt -V --strict --explicit bal
>> --depth=1 -e 2019-03-20
>>
>> $xxx,xxx.xx Assets
>> $-xxx,xxx.xx Equity
>> $xxx,xxx.xx Expenses
>> $-xxx,xxx.xx Income
>> $-xxx,xxx.xx Liabilities
>> --------------------
>> $94.87
>>
>> If I run the same report with the --unrealized flag, I can see the $94.87
>> show up in the unrealized gain category.
>>
>> ledger -f register.ldg --price-db price_db.txt -V --strict --explicit bal
>> --depth=2 -e 2019-03-20 --unrealized
>>
>> $xxx,xxx.xx Assets
>> $-xxx,xxx.xx Equity
>> $-xxx,xxx.xx Opening Balances
>> $-94.87 Unrealized Gains
>> $xxx,xxx.xx Expenses
>> $-xxx,xxx.xx Income
>> $-xxx,xxx.xx Liabilities
>> --------------------
>> 0
>>
>> In this example, I have realized the gain, so how do I record it as
>> such? I have many more examples of this where the transaction has occurred
>> exactly as above, but the accounts have a tax-deferred status, so how do I
>> handle those accounts as well?
>>
>> Thanks
>> JL
>>
>
--
---
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/83d50c4b-655e-4d51-a76a-be96a4b66b3an%40googlegroups.com.
