Looking for a Template to Show Monthly Expenses by Category

Is there a template that would show monthly expenses by category for say, 12 months?

Hi @bltcfo, is this what you’re looking for?

1 Like

The Monthly Analysis sheet is also a good one. The Foundation Template has the Yearly Budget sheet that comes out of the box. Lastly, a good ol’ pivot table can do this too :slight_smile:

1 Like

Thank you both! Will play with these two. One other question, is there a way to have these sheets only present expenses (i.e. exclude income items)?

I think I did it, I added the “Type” option to filter for only positive or only negative transactions. Let me know if it works! I threw it together pretty quickly so I wouldn’t be surprised if there are bugs

https://docs.google.com/spreadsheets/d/1U7_0hx3G_BiHFaK2U6_0xLoOrMeUIkAnFTmiqZj8P7w/copy

1 Like