Hope this explains it better
There are two accounts in the transaction report Expense Type A/Payable Income Type Bank 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. 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. 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 Thanks Joe -----Original Message----- From: gnucash-user <[email protected] <mailto:[email protected]> > On Behalf Of Michael or Penny Novack Sent: Thursday, December 8, 2022 1:51 PM To: [email protected] <mailto:[email protected]> Subject: Re: [GNC] Transaction Report I am not sure what you are asking or what your expectations might be. This is a "transaction report" against what account? What is the "type" of that account? What is the normal state of the balance of that account in terms of the formal terms :debit" and "credit" -- in other words, if you were thinking of those in terms of positive and negative numbers, how would those match up? I'm not asking you to answer those questions for us as to think about them for a moment and answer for yourself. Thus, I am thinking that the account is a bank account (type asset, normal balance debit) against which these are transactions are purchases made by "debit card". In which case they would be CREDITS to that account, reducing the DEBIT balance of that account Or if you insist on positive and negative numbers, if the normal balance of that account is positive, these would be negative. Michael D Novack. On 12/8/2022 2:31 PM, [email protected] <mailto:[email protected]> wrote: > I updated from ver 2.6.6 to ver 4.1.2. I used the same data file > created in > 2.6.6 and opened it in 4.1.2. All the data looks good and accounts > transactions all match. The problem is when I create a Transaction > report in ver 4.1.2 and use totals. The total shows up as a positive > numbers although all the transactions show up as negative numbers. Example shown below: > > > > July 2022 > > 07/02/2022 DIRECT DEBIT PAYPALL Amazon Labels > (Supplies) $(28.25) > > 07/02/2022 DIRECT DEBIT PAYPALL Safeway Water, > Snacks for 7/4 Parade (Events) $(15.57) > > 07/03/2022 DIRECT DEBIT PAYPALL All In One Google Ad > Grant Management (Administrative Fees) $(499.00) > > 07/08/2022 1009 Check Paid BHOA Cabana Fee for YA Summer > Gathering (Events) $(20.00) > > 07/14/2022 DIRECT DEBIT PAYPALL Costco Plastic > Containers (Supplies) $(29.64) > > 07/17/2022 DIRECT DEBIT PAYPALL Antioch Recreation > City of Antioch Application Fee Antioch IOAD (Events) > $(140.00) > > 07/17/2022 DIRECT DEBIT PAYPALL Safeway Gift Cards > and Supplies for Youth Ambassdor Gathering (Events) > $(320.62) > > 07/18/2022 DIRECT DEBIT PAYPALL Safeway Beverages > and Food for Youth Ambassdor Gathering (Events) > $(40.77) > > 07/19/2022 1011 Check Paid Monica Kamran, food reimbursement > for YA Gathering (Events) $(56.30) > > 07/25/2022 DIRECT DEBIT PAYPALL Safeway Candy For > Oakland Health Fair Tabling (Events) $(28.98) > > 07/26/2022 DIRECT DEBIT PAYPALL Quickship Ink > Printer (Printing) $(38.29) > > 07/27/2022 DIRECT DEBIT PAYPALL Amazon Flameless > Candles Raleigh IOAD (Events) $(149.40) > > 07/27/2022 DIRECT DEBIT PAYPALL Amazon Luminary Bags > & Candles Raleigh IOAD (Events) $(127.60) > > Total For July 2022 $1,494.42 > > > > I have tried all the different report options and can not get this to > change. In ver 2.6.6 the Total showed as negative. The other > difference is that the account register of one of the accounts in the > report also shows positive values in the register balance column in > ver 4.1.2, but negative values in 2.6.6, > > The account in question is type A/Payable in both versions. In the > accounts view the account in question also shows Total as positive > number in ver > 4.1.2 and Total as a negative number in ver 2.6.6 > > Any help would be appreciated. > > > > Thanks > > Joe > > > > _______________________________________________ > gnucash-user mailing list > [email protected] <mailto:[email protected]> > 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. -- There is no possibility of social justice on a dead planet except the equality of the grave. _______________________________________________ gnucash-user mailing list [email protected] <mailto:[email protected]> 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 [email protected] 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.
