[GNC] exporting search?

[Jeff]

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:* paul at 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 at 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 at 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 at 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 at 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.