Took a bit of manipulating outside of gnucash, but that did the trick thank you! I dumped the data table into excel, aggregated by month and by account using some lookups and a pivot table, and got exactly what I needed, thank you! I earn different cash back amounts on my credit cards based on the category of spend, so wanted to match the gnucash data up against the credit card summaries to see how closely they match.
On Fri, Nov 3, 2017 at 1:06 PM, Maf. King <m...@chilwell.net> wrote: > On Friday, 3 November 2017 19:09:22 GMT Tj Junior wrote: > > I always seem to have a difficult time figuring out which report to use. > > For this instance, I'm looking to see what I've spent by category, but > > restricted to just what's paid by a credit card. For instance, I want > > groceries purchased on Visa rather than just all grocery purchases. So > all > > expenses that are in a specific liability account. > > > > Current month > > Visa: > > * Groceries total spend > > * Clothing total spend > > * Restaurants total spend > > etc > > Mastercard: > > * Groceries total spend > > * Clothing total spend > > * Restaurants total spend > > > > Any suggestions? I've tried 10 different report options so far with no > > luck. Thanks! > > Without looking at specific options, how about the Transaction report, run > on > the CCard account and sorted using "Other Account" as the primary key? > > might get close to waht you are after? > > HTH, > Maf. > > > > > _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org 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.
