Hi all, I am trying to get a saved search that shows the total transactions posted to an account for each accounting period, by location. We have 20+ locations so I am hoping to get 1 search that shows me each GL account total posted for the month, for each location. We've been running P&L by location reports but I'd rather have 1 search vs having to the P&L by location each month Location #1, Month 1, Rent expense, $xxx Location #1, Month 2, Rent expense, $xxx Location #1, Month 3, Rent expense, $xxx Location #2, Month 1, Rent expense, $xxx Location #2, Month 2, Rent expense, $xxx Location #2, Month 3, Rent expense, $xxx

You should be able to create 1 search then use "group by" summary type in your results

Thank you!