[GNC] easy way to total number of transactions and USD ammounts

[Murugan Muruganandam]

thanks phyllis, my explanations was little rusty, i did not use the function you have noted, instead i have used the same field twice and chosen the count and sum , i have attached a excel file sample.

Jeff,  generate the transaction report, copy the content and paste it into the sheet named transaction.
go to pivot sheet and refresh it, you should be able to see the amount and number of transactions account wise




Saludos Cordiales


Murugan

________________________________
From: Phyllis Bruce <pobruce46 at gmail.com>
Sent: Thursday, March 30, 2023 6:44 PM
To: Murugan Muruganandam <m.muruganandam at hotmail.com>
Cc: Jeff <beastmaster126 at hotmail.com>; Gnucash userlist <gnucash-user at gnucash.org>
Subject: Re: [GNC] easy way to total number of transactions and USD ammounts

Jeff, I couldn't tie my response to what Murugan suggested.

You can use the sum and count on the same spreadsheet.  The Excel command for count is   =COUNTA(first cell:last cell)   Just put that command in the cell beneath the sum.

On Thu, Mar 30, 2023 at 3:29 PM Murugan Muruganandam <m.muruganandam at hotmail.com<mailto:m.muruganandam at hotmail.com>> wrote:
hi Jeff

I would suggest the best will be to generate the transaction report
in options

Account:select all account
Display: select account name , unselect full name
Display: Amount as single column
General: date range and check table for export

export the report to .xls format and open it in the excel
from the data make a pivot table at account level as row label and the amount as value field (you can make it two times, one for sum and one for count)

after the same you can pick the details for reporting what you need





Saludos Cordiales


Murugan

________________________________
From: gnucash-user <gnucash-user-bounces+m.muruganandam=hotmail.com at gnucash.org<mailto:hotmail.com at gnucash.org>> on behalf of Jeff <beastmaster126 at hotmail.com<mailto:beastmaster126 at hotmail.com>>
Sent: Thursday, March 30, 2023 3:43 AM
To: Gnucash userlist <gnucash-user at gnucash.org<mailto:gnucash-user at gnucash.org>>
Subject: [GNC] easy way to total number of transactions and USD ammounts

The IRS threw me a curve ball this year (imagine that).  One of their
tax forms went from $600 minimum to you, to $20,000 "AND" more than 200
transactions in 2022.  Is there someone out there that can hold my hand
and show me how to export those transactions to a spreadsheet to see if
we fall into that level at the federal level, since there are no
reporting features in GNC that total $ and number of transactions, at
least that I am aware of?  I have not used spreadsheets for much of
anything since my college days, shall we say decades ago, so rusty is an
understatement.

The real kicker is my state sets the minimum at $1,200, period.

The company involved, has so far refused to provide me with a copy of
the 1099 involved.  It may or may not meet the federal level but I know
for a fact that it passes my states $ level of $1,200.

Don't you just love our tax system in the U.S.A.? NOT!!!!!

--
--JEffrey Black M.B.A.

_______________________________________________
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.
_______________________________________________
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.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: transaction.xls
Type: application/vnd.ms-excel
Size: 129536 bytes
Desc: transaction.xls
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20230330/e1fcb229/attachment-0001.xls>