|
Look Back Data Comparison AQ
The Look Back Data Comparison AQ compares specific column totals for two different specified time periods (week, month, quarter, year).
Parameters
Date Type (Accounting Period Date, Week Worked), Start Date, End Date, Column to Compare (Gross Wages, Bill Amount, Total Pay, Total Bill, WC Cost, Gross Profit, WC Wage, Bill Total Hours, Pay Total Hours, Agency Cost, Payment Cost, Burden, Employer Taxes, Total Adjustment Cost, Discount Amount), Compare By (Week, Month, Quarter, Year)
Fields
Staffing Company, Branch Name, Customer Name, Department Name, Order Type, Label, Year Week (for each week in search parameter)
Who should use this report?
Back Office Personnel
Why is this report so awesome?
This is a great report to run to track how the company is doing on various metrics over time and it is also a useful sales analysis tool. Like 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.
| 
