This report helps to compare gross profit and hours of a company in two different date range.
Note: This report is part of the INSIGHTS product, please contact your Account Manager to learn more.
|
Click on the links below for more information:
If you don't have access to INSIGHTS/Analyze, please reach out to your Account Manager. |
CHAPTERSLegend |
Legend
Filter Panel
Locating the Analyze Report
- Click on Analyze Tab
The Reports Sub Tab will automatically be selected - In the Search Reports field, type GROSS
- Click on the Gross Profit and Hours Comparison Report
Logic
This report helps to compare gross profit and hours of a company in two different date range.
Filter Options
| Parameter Name | Options | Description | |
| Division | All available Employers | Use this filter to refine Employer of Transaction | |
| Region | All available Regions | Use this filter to refine Region of Transaction | |
| Office | All available Offices | Use this filter to refine Office of Transaction | |
| Company | All available Companys | Use this filter to refine the Company of Transaction | |
| Job Type | All available Job Types | User this filter to refine the Job Type of Transaction | |
| Roll Up To Parent Company | Yes/No | Use this filter to display the data per individual Company Department or Rolled into Parent Company | |
| Include Burden Factor | Yes/No | Use this filter to pull amounts based on the Admin Tools >> Burden Factor | |
| User Type | Lists User Types of different User Level (Talent, Placement, and Job's Entered By and Recruiter User Type) | Use this filter to refine the User Type of the Transaction | |
| User | All available HCM Users | Use this filter to refine the User of the Transaction as per the User Type selected | |
| Date Type | Accounting Period Date, Week Worked | Use this filter to refine the Date Type of the Transaction | |
| First Start Date | Start Date for the First Date Range | Use this filter to refine Transaction falling under the date range as per the date type selected | |
| First End Date | End Date for the First Date Range | ||
| Second Start Date | Start Date for the Second Date Range | ||
| Second End Date | End Date for the Second Date Range |
Graphs/Widgets
Field Details
- Click here to go to the Time Category (list of Analyze Reports)
- Click here for more information on Terms and Filters (Analyze Reports)
- Click here for more information on System Terms (Glossary)
| Field Name | Description | Notes |
| Transaction Employer | Transaction Employer | |
| Transaction Region | Transaction Region | The field is hidden but it can be selected from top to display in the report |
| Transaction Office | Transaction Office | |
| Company | Transaction Company Name | |
| Department | Company Department | |
| Job Type | Transaction Job Type | |
| Wc Code | Transaction Worker Comp Code | |
| User | Transaction User as per the User Type parameter | |
| First - Bill Hrs | Transaction Bill Total Hours for transactions falling under first date range . Hours in Avionté is calculated as SUM of Reg, OT, DT plus any pay code that is setup with Property IncludeInOtherhours = True. | Displays the data for the First Date Range. |
| First - Bill Amnt | Transaction Bill Amount for transactions falling under first date range. Sum of Item Bill of all Transaction type which is taxable i.e. Is Adjustment = 0 | |
| First - GP Adj Bill | Transaction Non taxable Bill Amount for transactions falling under first date range parameter. Sum of Item Bill for Transaction types that is nontaxable and has property GPCalculation set to True. | |
| First - Gross Profit | Transaction Gross Profit Amount for transactions falling under first date range parameter. (BillAmount + GPAdjBill – DiscountAmount) – (GrossWages + AgencyCost + EmployerTaxes + WorkerComp + GPAdjPay + GPAdjCost + Burden) | |
| First - GP (%) | Transaction Gross Profit Percent for transactions falling under first date range parameter. Gross Profit divided by (BillAmount + GPAdjBill – DiscountAmount) |
|
| Second - Bill Hrs | Transaction Bill Total Hours for transactions falling under second date range parameter. Hours in Avionté is calculated as SUM of Reg, OT, DT plus any pay code that is setup with Property IncludeInOtherhours = True. | Displays the data for the Second Date Range. |
| Second - Bill Amnt | Transaction Bill AmountTransaction Bill Total Hours for transactions falling under second date range parameter. Sum of Item Bill of all Transaction type which is taxable i.e. Is Adjustment = 0 | |
| Second - GP Adj Bill | Transaction Non taxable Bill AmountTransaction Bill Total Hours for transactions falling under second date range parameter. Sum of Item Bill for Transaction types that is nontaxable and has property GPCalculation set to True. | |
| Second - Gross Profit | Transaction Gross Profit Amount for transactions falling under second date range parameter. (BillAmount + GPAdjBill – DiscountAmount) – (GrossWages + AgencyCost + EmployerTaxes + WorkerComp + GPAdjPay + GPAdjCost + Burden) | |
| Second - GP (%) | Transaction Gross Profit Percent for transactions falling under second date range parameter. Gross Profit divided by (BillAmount + GPAdjBill – DiscountAmount) | |
| Difference - Bill Hrs | Second Bill Hrs - First Bill Hrs | Displays the difference of the First and Second Date Range. |
| Difference - Bill Amnt | Second Bill Amnt - First Bill Amnt | |
| Difference - GP Adj Bill | Second GP Adj Bill - First GP Adj Bill | |
| Difference - Gross Profit | Second Gross Profit - First Gross Profit | |
| Difference - GP (%) | Second GP % - First GP % |
Comments
0 commentsPlease sign in to leave a comment.