[GNC] Report question

Paul Kinzelman paul at kinzelman.com
Fri Feb 25 10:26:31 EST 2022


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?

Here's one line example:
02/23/2022 	ff8275d221f24ecfa82aaf8f6e4c9852 	
	Home Depot 	weed block 	CURRENCY::USD 	
	
	
	Expenses:House:Garden 	Garden 	$102.11 	102.11 	n 	
	1

	
	
	
	
	
	
	
	
	Liabilities:Credit Card:DCUvisa
	DCUvisa joint
	$(102.11) 	(102.11) 	n 	
	1



On 2/24/2022 1:09 PM, David Carlson wrote:
> That procedure generates a mess, in my opinion. Wouldn't it be simpler 
> to just run a register report?
>
> On Thu, Feb 24, 2022 at 12:57 PM Paul Kinzelman <paul at kinzelman.com> 
> wrote:
>
>     If I do a Search for the transactions I want, and then Export
>     Active Register, I can look at the CSV in a spreadsheet, but
>     both accounts of the transaction appear in the same column
>     so the sum of the amount column is always zero.
>
>     How do I export just one account's amount of each transaction
>     without the other side of the transaction being there so that
>     the sum of the column actually represents the sum of the
>     expenses of that Search?
>
>     TIA!
>
>
>
>
>     _______________________________________________
>     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.
>
>
>
> -- 
> David Carlson


More information about the gnucash-user mailing list