Which report am I looking for?

[dadinva]

Tracy-2 wrote
> What I am trying to do is to produce a report against a single expense 
> account, subtotaled by "Description" and broken down by month over the 
> selected period.
> 
> For example, let's say we are looking at Expense.Dining, for 
> transactions over the last year. I would like to have a monthly 
> breakdown on each Description entry (for example, a total for each month 
> for all the transactions with Description "McDonalds", "Burger King", 
> etc... Something like:
> 
> January:
> 
>      McDonalds      $274.52
> 
>      Burger King     $192.33
> 
>      
> <etc>
> February:
> 
>      McDonalds    $192.17
> 
>      Burger King   $62.81
> 
>      
> <etc>
> March:
> 
> 
> And so on....
> 
> So which of the reports should I look at, and what suggestions can you 
> offer for customizing it to produce a report of this nature?
> 
> Any help would be appreciated.
> 
> _______________________________________________
> gnucash-user mailing list

> gnucash-user@

> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

I think the transaction by payee summary report I posted today does what you
want, it will combine all of the entries that have the same description such
as Burger King into one entry.  To use it, under options, on the display tab
select consolidate transactions,  then uncheck all of the other entries
except description.  On the sort tab set Primary as date and for Secondary
sort select account.  Then for the primary date period select monthly. 
Another possibility is Primary date and secondary amount in descending
order.  You can either select all expense accounts or just run it on one
account at a time as you originally asked about.



--
View this message in context: http://gnucash.1415818.n4.nabble.com/Which-report-am-I-looking-for-tp4688925p4690242.html
Sent from the GnuCash - User mailing list archive at Nabble.com.