Thanks Murugan, I used pivot tables at one time but too long ago to remember how. Thankfully, I don't need them in my retirement. They are certainly valuable tools.
On Thu, Mar 30, 2023 at 5:01 PM Murugan Muruganandam < m.muruganan...@hotmail.com> wrote: > 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 <pobruc...@gmail.com> > *Sent:* Thursday, March 30, 2023 6:44 PM > *To:* Murugan Muruganandam <m.muruganan...@hotmail.com> > *Cc:* Jeff <beastmaster...@hotmail.com>; Gnucash userlist < > gnucash-user@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.muruganan...@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....@gnucash.org> on behalf of Jeff <beastmaster...@hotmail.com> > Sent: Thursday, March 30, 2023 3:43 AM > To: Gnucash userlist <gnucash-user@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@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@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@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.
