[GNC] Report question

[William Prescott]

I found the same thing recently. I also would find it helpful to be able to export a transaction report as csv. If I had some free time, I would consider looking into adding that, but right now, I don't have the time.

Will

On 2022 Feb 26, at 02-26 10:56:27, Paul Kinzelman <paul at kinzelman.com> 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.