Add Report to show Taxes paid per Tax Group

Name of Feature/Request: Add Report to show Taxes paid per Tax Group

What financial, time savings, or quality of life improvements will occur from this: Keith would like a report to showed taxes paid per tax group - preferably broken down by each individual tax under the tax group. | Frequency: Every month to every quarter | Keith has to submit a report every month to three months to a specific county tax department. These reports need to show how much was paid during a period of time for a specific tax group as a whole.
Example:
FL Bay Tax Group = “Total amount of tax paid” - FL Discretionary 1.0% Sales Surtax “amount paid for this tax group” - FL Sales and Use “amount paid for this tax group”

Attempted Solutions So Far: Will recommended creating individual tax agencies for the different counties rather than just label the tax group as the county, but Keith has over 400 tax groups that would then need two custom tax agencies created to make this work on the current available reporting.

Digging deep - Any additional Why behind this request / How was this accomplished before Striven in what system or software: Previously accomplished: Keith is having to manually go through sales orders to calculate taxes per city/county

StrivenID: 3210976