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

[Murugan Muruganandam]

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> on behalf of Jeff <beastmaster126 at hotmail.com>
Sent: Thursday, March 30, 2023 3:43 AM
To: Gnucash userlist <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
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.