On 2/19/22 10:05 PM, Paul Kinzelman wrote:
Thank you. That's what I did, but there wasn't an obvious way to
export that account.
On 2/19/2022 6:35 PM, D. wrote:
Personally, I'd have a separate account for medical expenses, and
then a transaction report for that account would quickly give me
totals for any given period.
------------------------------------------------------------------------
*From:* Geoff
*Sent:* Sat Feb 19 18:32:43 EST 2022
*To:* p...@kinzelman.com, Gnucash Elist
*Subject:* Re: [GNC] exporting search?
Hi Paul
Your original request said you required a list of expenses. If you only
want the totals amount, there is no need to export at all. Just scroll
to the bottom of the Account Report, which shows the the total Debits,
Credits, and Balance.
As to your other useful suggestions, please excuse the editorial. I see
that the lead article on your web site is titled "The Importance of
Building a Strong Community".
The great thing about GnuCash is that it is built, maintained, and
supported by a wonderful volunteer open source community. Please feel
free to join us. I am sure that someone with your background and
experience could make and make a valuable contribution:
https://wiki.gnucash.org/wiki/Contributing_to_GnuCash
Regards
Geoff
=====
On 20/02/2022 10:03 am, Paul Kinzelman wrote:
Thank you! I see now how I can do that, but it's not all that
convenient to do, seems like it would be something that lots of
people would want to do. Copy/paste from HTML seems like not a
good way to expect people to do it as well. All I want is a total
of the columns of a search, seems like this ought to be a feature
built in already. I also looked for this kind of search/export in
the documentation and couldn't find it, it'd be nice to say
something about that too. I tried things like "export search
results" and nothing came up. Even "search results" didn't say
much. A section on common things people like to do would be good.
On 2/19/2022 3:40 PM, Geoff wrote:
Hi Paul From the Search Results tab, choose Reports / Account
Report. This opens a new tab with a variant of the Transaction
Report showing just the transactions in your Search Results.
The Report Options let you tweak which columns are displayed.
From there, you can either File / Export / Report, or just
select all and copy /paste. The export format is HTML, but it
pastes into Microsoft Excel in a usable format. Regards Geoff
===== On 20/02/2022 6:49 am, Paul Kinzelman wrote:
Is there some way to export search results? I was trying
to get a list of medical expenses for the past year and I
didn't see any easy way to do this, is there a good way to
do it? I tried search but I couldn't export it or total
the columns. It seems like I should be able to export this
list - this is a general question. I tried income expense
cash flow for the year, but it gave me just money-in and
money-out. I was looking for detail to export to a spread
sheet. I finally did File Export Transactions and got what
I wanted but it seems like there should be an easier way.
Suggestions? Thanks!
------------------------------------------------------------------------
gnucash-user mailing list gnucash-user@gnucash.org To
update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user If
you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more
information. ----- 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 If you are
using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
----- 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
If you are using Nabble or Gmane, please
seehttps://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-----
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
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
I have had trouble with this as well. Each medical expense can have 2
or more related transactions. Medical expense, mileage, travel expense
(ie. meals, fuel), lodging,etc. All are separate entries on U.S.
taxes. I know that you can assign tax values to individual accounts,
but a total dollar value in a specific search would be advantageous. It
would be nice to search for all transactions in a specific search and
give me the total dollars spent in that search.
I.E. search total dollars spent on lodging in the medical travel account
from 6/21/2002 to 8/21/2002.
I have yet to see where GNC gives me a total dollar amount spent in a
search. Add it to my wish list.
--
--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
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
