Taxes Summary AQ
The Taxes Summary AQ is a summary of all company taxes
Parameters
Start Date, End Date, Date Type (Accounting Period, Check Date), Supplier, Branch, Group 1 (Staffing Company, Branch, Tax State, Taxing Juris, Check Date), Group 2 (same + None), Group 3 (same + None), Group 4 (same + None), Tax Name
Results Fields
Taxing Juris, Gross Wages, Subject Wages, Taxable Wages, Tax Amount, Summary
Logic
Tax rates are pulled from the Avionté Tax Table and can be found in Admin Tools.
Who would use this report?
Back Office Personnel
Why is this report so awesome?
The Taxes Summary AQ shows a great breakdown of the amount owed for each tax type. Also, the parameters of the report offer you several grouping choices to better format the data to your personal needs. Many of our clients find this report useful for quarterly and year-end tax calculations. As with all of our advanced queries, you can simply get rid of any of the data columns that you do not want to include in your final report, and export it to Excel for further formatting and manipulation.
|