[GNC] Transaction Report

[Derek Atkins]

HI,
Are you willing to share your data file?   Or create a small data file
that shows the issue?
If neither is possible, could you create screen shots of all the registers
and the report, along with the account settings, report settings, and user
preferences?
-derek

On Thu, December 8, 2022 8:10 pm, rovero at comcast.net wrote:
> Accounts are set up identical in ver 2.2.6 and 4.1.2. The "reverse sign"
> preference is set as credit in both versions.
> The transaction report is identical in both versions other than the Total
> dollars being positive in the expense section in ver 4.1.2 vs dollars
> being negative in 2.6.6
>
> Thanks
> Joe
>
> -----Original Message-----
> From: Derek Atkins <derek at ihtfp.com>
> Sent: Thursday, December 8, 2022 4:56 PM
> To: rovero at comcast.net
> Cc: gnucash-user at gnucash.org
> Subject: Re: [GNC] Transaction Report
>
> HI,
>
>
> On Thu, December 8, 2022 7:32 pm, rovero at comcast.net wrote:
>> Hope this explains it better
>>
>>
>>
>>
>>
>> There are two accounts in the transaction report
>>
>>
>>
>> Expense  Type A/Payable
>
> An A/Payable account is not an expense.  It is a liability.
>
>>
>> Income    Type  Bank
>
> Similarly, a Bank account is not an income.
>
>>
>>
>>
>> In the expense account register transactions show as a positive number
>> in the payment/debit column and the balance column is a negative
>> number that augments negative as transaction are added.
>
> It sounds like your accounts are not set up correctly.
>
>>
>>
>>
>> In the Income account register transactions show as a positive number
>> in the deposit/debit column  and the balance column is a positive
>> number that augments positive as transaction are added.
>
> Yes, because it's not Income, it is a Bank that you "labeled" Income.  And
> yes, in a Bank account, a debit increases the account value/total.
>
>>
>>
>>
>> The report is a simple one that shows all expense transactions form
>> the Expense Account as a debit/payment negative dollar amount and all
>> transactions from the Income Account as a debit/deposit positive
>> dollar amount. So in the end my grand total should be the negative sum
>> of all transactions in the Expense account minus the sum of all
>> positive transaction in the income account.
>>
>>
>>
>> Again, in ver 2.6.6 I get the desired results. In ver 4.1.2 the
>> expense account Totals show as a positive number so Instead of
>> subtracting expense from income they add together in the grand total.ie.
>>
>>
>>
>> Ver 2.6.1    Expense Total ($-1200)     Income Total $2400    Grand
>> total
>> $1200
>>
>> Ver 4.1.2    Expense Total $1200          Income Total $2400    Grand
>> total
>> $3600
>
>
> You might want to check the value of your "reverse sign" preference.
> I suspect it's not the same.
>
>>
>>
>>
>> Thanks
>>
>> Joe
>
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>
> -derek
>
> --
>        Derek Atkins                 617-623-3745
>        derek at ihtfp.com             www.ihtfp.com
>        Computer and Internet Security Consultant
>
>
>


-- 
       Derek Atkins                 617-623-3745
       derek at ihtfp.com             www.ihtfp.com
       Computer and Internet Security Consultant