[GNC] Transaction Report
rovero at comcast.net
rovero at comcast.net
Thu Dec 8 19:32:06 EST 2022
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 <gnucash-user-bounces+rovero=comcast.net at gnucash.org
<mailto:gnucash-user-bounces+rovero=comcast.net at gnucash.org> > On Behalf Of
Michael or Penny Novack
Sent: Thursday, December 8, 2022 1:51 PM
To: gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org>
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, rovero at comcast.net <mailto:rovero at comcast.net> 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
> gnucash-user at gnucash.org <mailto:gnucash-user at 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.
--
There is no possibility of social justice on a dead planet except the
equality of the grave.
_______________________________________________
gnucash-user mailing list
gnucash-user at gnucash.org <mailto:gnucash-user at 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.
More information about the gnucash-user
mailing list