After much research and tons of trial and error, I landed on the following
solution. It's simple and elegant and seems to achieve my goal, even if
there appears to be a minor bug (see below). Ironically, I was led down
this path by a post I found elsewhere concerning hledger. I figured I
would document my findings for those looking for a solution to this problem
in the future.
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
{$26.725424031} @ $44.373095625
Assets:Investing:ABC Securities:Cash $238.54
Income:Capital Gains:Realized
After making these entries, my ABC Securities:Cash balance is correct, and
the balance report balances to $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
--------------------
0
If I run the same report with the --unrealized flag, I still see the $94.87
show up in the unrealized gain category, and I see a balance for the same
amount. This seems like a bug to me. If this report result is correct
based on my journal entries above, I could use some help with understanding
the logic.
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
--------------------
$-94.87
Thanks!
JL
On Sunday, October 3, 2021 at 9:18:40 PM UTC-5 Jasel17212 wrote:
> It seems that the order of the transactions matter. If I swap the entries
> I get the following:
>
> 2019/03/19 * Sell xx
> Assets:Investing:ABC Securities:xx -5.37578 xx @
> $26.725424031
> Expenses:Investing:ABC Securities:Cost of Sale $143.67
> Income:Investing:ABC Securities:Sales -5.37578 xx @
> $44.373095625
> Assets:Investing:ABC Securities:Cash $238.54
>
> 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
> --------------------
> 0
>
> 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
> --------------------
> $-94.87
>
> That seems right to me.
>
> I would appreciate any other perspectives on this topic.
>
> Thanks!
> JL
>
> On Sunday, October 3, 2021 at 8:52:52 PM UTC-5 Jasel17212 wrote:
>
>> 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/1b5a6fb9-e4af-4a3b-ab68-625cdea38b35n%40googlegroups.com.
