trial balance - how to find mismatch question

[John Ralls]

> On Feb 16, 2018, at 5:58 AM, Deva - <pobox.deva at outlook.in> wrote:
> 
> I am seeing huge imbalances in my trial balance report as well. This is one report I have not been sending to my tax professional until I understand how to interpret it.
> 
> This behaviour is seen in 2.6.19 currently, but I am sure I have seen it in previous versions as well (I have been on GC since 2.6.6).
> 
> Though I started using GC only since 2015, I actually entered past 18 years of my transaction history from annual spreadsheets I used to maintain before. After reading this thread, I went back year after year change the end date until I hit the first mismatch between credits and debits - just over INR 70 as of Mar 2009. Progressively after that, this report now shows a difference of over INR 600,000!
> 
> There’s nothing in imbalance or orphan accounts and my entire datafile is in single currency (INR).
> 
> Only thing I can see from the time this first mismatch popped up in 2009 till now is that I have had capital gains from sale of shares since 2009. Though I recorded these gains carefully each year manually from statements, etc., the difference still shows up.
> 
> One reason I can think of is this -
> 
> When I run the trial balance report (or balance sheet report), the options given for commodity pricing are: average cost, weightage average, nearest in time and most recent. However, when computing capital gains, Indian tax authorities will only accept gains/losses computed on a FIFO basis (FIFO option can be selected when running Advanced Portfolio Report).
> 
> Since FIFO is not one of the options I can select for commodity pricing in trial balance and balance sheet reports, I am guessing the difference in credits and debits  is coming from cost basis determined by FIFO and average cost basis methods?

Deva,

See https://bugzilla.gnome.org/show_bug.cgi?id=775368 <https://bugzilla.gnome.org/show_bug.cgi?id=775368>.

“Average Cost” as a price source isn’t the same as “Average Cost” as a capital gains recognition policy. In GnuCash reports it means that the price used for converting one commodity to another is derived from the actual transactions, not from prices recorded in the price database. Read the bug for lots of gory details.

Regards,
John Ralls