[GNC] Report question

[davidcousens49 at gmail.com]

Paul

You can copy the report to a spreadsheet by selecting the report tab, selecting
all the content using Ctrl-A, copy it with Ctrl-C and paste it into your
favourite spreadsheet. Works into LibreOffice Calc and should work equally with
Excel. You can then save it either as CSV or in the spreadsheet format.

Works for GnuCash 4.9 on Linux Mint 20.2 

Alternatively the menu item File->Export->Export Report will export the report
as HTML and you can open it in a browser, Ctrl-A, Ctrl_C and then paste to a
spreadsheet. Save in desired format

These are fairly simple to do and avoid having to write a lot of code.

David Cousens

On Sat, 2022-02-26 at 09:56 -0700, Paul Kinzelman wrote:
> 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 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.