On Wed, Apr 17, 2019 at 5:53 AM Alen Šiljak <[email protected]> wrote: > > I have a few errors in my data file, which prevent me from running any > reports. The data has been exported from GnuCash. > The issue is with two types of transactions: > - return of capital > - realized gain/loss > > Let's take Return of Capital entry, which comes from GnuCash. I'm using > Trading accounts there, hence they are inserted automatically. > > 2018/04/09 return of capital > Assets:Investments:Broker:Cash 79.61 AUD > Trading:ASX:IPE 0.0000 IPE @@ 79.61 AUD > Assets:Investments:Broker:Shares:IPE 0.0000 IPE @@ 79.61 AUD > Trading:CURRENCY:AUD -79.61 AUD > > > The transaction is reported as non-balancing. What exactly is the issue and > how to resolve it? > I see three positive transactions (+) and one negative (-). The two positive > transactions involve the accounts which use IPE commodity and the quantity is > 0, but they use @@, meaning both have deposits of 79.61? > The problem, however, is that I can't put -79.61 in any of those (why?) to > balance them out. "Posting's cost can't be negative". > > So, the question would be - how do you do Return of Capital transactions when > Trading Accounts are used? > > Are there solutions that could be implemented in the export process (GnuCash > -> ledger)? Are there solutions I could use when recording these > transactions? Any ideas welcome. >
There is a, at least imo, fairly simple and elegant way to make this work. Treat this as 2 (two) transactions. One transaction is for the change in the brokerage account and the other then reflects the first but delineates the change in 'your' cash (or equity - better) account. A more complicated way would be to put what's happening internally in the brokerage account into a 'notes' field ( ; followed by a space after your line 'date + item description'). I use the second to account for currency conversions giving myself all the detail necessary. Regards -- --- 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/d/optout.
