What I have observed is that the trial balance report is based on some sort of "averaging," and not debits/credits. There are a few reports on this.
Quoting John Ralls: ""Average Cost" in this case doesn't mean what normal people would think. The function finds all of the splits in all of the non-trading accounts that involve currencies other than the parent transaction's currency and creates the scheme equivalent of a table that looks something like comm1 comm2 quantity value where comm1 is the transaction currency, comm2 is the split commodity, quantity is the total number of split-commodity units and value the total number of transaction-currency units. Note that the transaction currency is determined by the account-register you start out in, so one would expect that if all of the transactions are initiated from the Checking Account register the table will look like USD EUR 19999/100 21000/100 Fiddling around with the numbers shows that the resulting exchange rate is the trading gain divided by the residual amount in the EUR account, so that the value balance in the EUR account is always the trading gain. Unfortunately figuring out what gnc:get-exchange-cost-totals (https://github.com/Gnucash/gnucash/blob/master/src/report/report-system/commodity-utilities.scm#L624) is really doing exceeds my limited Scheme ability." > On 11/06/2024 2:06 PM PST Dr. Timothy B. Jones <t...@timothybjones.net> wrote: > > > Greetings: > > I am on the 5.9 version of GCUCash for Windows. I have been doing stock > trades since 2016 on the software without this issue. However today I made > the following STOCK PURCHASE and entered it just as I have for years. > (Bought 250 shares of GCI for $667.50) The transaction looks like this: > > DEBIT GCI STOCK $667.50 > DEBIT TRADING CURRENCY $667.50 > > CREDIT CASH $667.50 > CREDIT TRADING:GCI $667.50 > > This is consistent with how hundreds of other purchases have posted. > HOWEVER, this particular post is putting my Trial Balance off by $667.50 (the > debit side $667.50 lower than the credit side). I have done everything I > know how to do to figure out why this particular buy transaction would throw > it off when it is obviously balanced. If I delete it, the Trial Balance goes > back to balanced, so there is no doubt this transaction is causing the issue. > > Thoughts? Am I missing something obvious? > > Thank you!! Timothy > > Timothy B. Jones, Ed.D. > Author, International Speaker & Consultant > (214) 252-0489 > http://www.timothybjones.net > > > _______________________________________________ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > ----- > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
