[GNC] Report question
Paul Kinzelman
paul at kinzelman.com
Sat Feb 26 15:33:35 EST 2022
Thanks for the suggestion, but I'm not trying anything huge.
I just tried to get a quick spreadsheet out of it and stumbled.
I thought there would be some easy way to get quick reports
like there was in Quicken, but GC requires more user assembly.
It's the Ikea of financial software. :-)
The suggestions you made helped.
Thanks very much!
On 2/26/2022 1:30 PM, D. wrote:
> If you took the report data and pasted it directly into your favorite
> spreadsheet, you could save the result as CSV, no problem.
>
> At this point, it might be more useful if you explained more
> completely what it is you're trying to accomplish. Then people on the
> list could help you solve the problem, rather than half answer your
> half-stated question.
>
> David
> ------------------------------------------------------------------------
> *From:* Paul Kinzelman
> *Sent:* Sat Feb 26 11:56:27 EST 2022
> *To:* Tommy Trussell
> *Cc:* Gnucash Elist
> *Subject:* Re: [GNC] Report question
>
> Thank you for the detailed instructions.
> I found that 'Transaction Report' will do what I want, but then
> I can't export to CSV.
>
> I can export to HTML by Export Report
> I can 'Export as PDF' but not CSV. That's what I'm missing.
> This would be really nice to add.
>
> I can Export Transactions, but that does not export the transactions
> of the transaction report which is what I wanted to do.
>
> On 2/25/2022 6:08 PM, Tommy Trussell wrote:
>
> On Fri, Feb 25, 2022 at 9:27 AM Paul Kinzelman
> <paul at kinzelman.com> wrote: Do you mean Account Report? But when I
> go to File | Export, it asks me which accounts again, it doesn't
> export the actual report. When I export the transactions I want,
> it exports both sides of the transaction, so the column sum is
> always zero whereas I want the sum of the transactions. In other
> words, each transaction takes two lines, the line I want (the
> expense of what I bought), and the next line which is the account
> that paid it (like a charge card). How do I get rid of the
> double-lines on the export? We're apparently not seeing the same
> thing you are. Here's a way to get an Account Report for your
> credit card transactions. (This is using GnuCash 4.9.) 1) Open the
> account Accounts tab --> open Liabilities : Credit Cards :
> BigBankTwo VISA (yours will differ) 2) Use Filter By to select the
> transactions you want [while the register is active] View -->
> Filter By (choose parameters such as date, number of days,
> reconciled, etc.) 3) Open Account Report [while the filtered
> register is active] Reports --> Account Report 4) Adjust the
> options on the report Edit --> Report Options (here you can
> adjust specific columns, single or double amount columns, totals
> or running total, style, report name, etc.) 5) Export the report
> You can copy what's on your screen and paste it into a word
> processor or spreadsheet OR File --> Export --> Export
> Report (give it a name -- it will save an .html file you can open
> with a web browser or a spreadsheet program) ----- 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.
More information about the gnucash-user
mailing list