[GNC] Report question

[William Prescott]

I just looked at the html code for the transaction reports exported in html format. It would be trivial to write a converter to convert them to csv. And they are simple enough that probably all the existing html-to-csv converters would do a good job on them.

Will


On 2022 Feb 26, at 02-26 11:00:54, William Prescott <will at theprescotts.com> wrote:

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.

_______________________________________________
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.