Standard Report - Gross Profit

Overview

Updated 10/21/2021

Required Setup

• In Order to pull correct DH Fee, the category for Direct Hire should be “DirectHire”.
• User is pulled from Transaction Extra, so any user type that you are planning to run this report for, should be setup with Property CopyToTransaction = True & user needs to be updated/added before the transaction is generated and processed in Time Entry.

***Once New Report is deployed, need to fix ER Contributions.

• Click here for more information about the Gross Profit setup.

Report Description

See how much gross profit your company is making and see the information that makes up the gross profit.

Parameters

Parameter Name	Options	Explanation
Roll up to Parent Customer	True/False	Based on this parameter, result will either displayed per individual customer department or rolled into Root Customer.
Customer Name		Filters results by Customer Name.
Date Type	Accounting Period Date, Week Worked	Transaction’s Accounting Period or Week Worked.
Order Type	All Temp & DH Order types
Start Date
End Date
Group By	Branch, User, Customer, OrderType, WcCode, Employee
Branch	All available branches
User Level	Assignment, Customer, Order
User Type	All Available user types based on User Level selected.
Show Legend	True/False	This will show/hide legends of columns description & calculation in 1st page of the report.
Include burden Factor	True/False	Pulls number based on Admin Tools >> Burden Factor.
User	All Active and Visible users

Back to Top

Report Fields

Field Name	Explanation
Branch	Transaction Branch. Will be visible when Branch is selected under Group By Parameter.
User	Pulls User Description from Transaction Extra based on User Level and User type parameter selected. System copies User when each transaction is generated only if Copy To Transaction Property is set to be True. Will be visible when User is selected under Group By Parameter.
Customer	Customer Name from Transaction. Will be visible when Customer is selected under Group By Parameter.
Order Type	Order type from Transaction. Will be visible when Order type is selected under Group By Parameter.
Wc Code	Worker comp code from Transaction Will be visible when Wc Code is selected under Group By Parameter.
Employee Name	Employee Name from Transaction Will be visible when Employee Name is selected under Group By Parameter.
Pay/Bill Hrs	Pay and Bill Total hours. If Pay and Bill hours are same, it will only show the hours only one time. Like 40.00 else it will show them in Pay/Bill format 40.00/35.00 Hours in Avionté is calculated as SUM of Reg, OT, DT plus any pay code that is setup with Property “IncludeInOtherhours” = True.
Bill Amount	Sum of Item Bill of all Transaction type which is taxable i.e. Is Adjustment = 0
DH Fee	Sum of Item Bill for Transaction Type that is under Category “DirectHire”
GP Adj Bill	Sum of Item Bill for Transaction types that is nontaxable and has property GPCalculation set to True.
Discount	Discount Amount, if used.
Gross Wages	Sum of Item pay for transaction types that is taxable. i.e. Is Adjustment = False
GP Adj Pay	Sum of Item Pay for Transaction types that is nontaxable and has property GPCalculation set to True.
Agency Cost	Sum of Item pay is transaction is linked to Agency or Non W2 Employee (Sub contractors)
Employer Taxes	Sum of all Employer Taxes.
Worker Comp	Sum of Worker Comp Cost. Click here for more information on calculating Workers Comp costs
Non Adj Cost
GP Adj Cost	Sum of Item Cost for Transaction types that is nontaxable and has property GPCalculation set to True.
Burden	Sum of Additional Burden, if used (Admin tools >> Burden)
Gross Profit	(BillAmount + GPAdjBill – DiscountAmount) – (GrossWages + AgencyCost + EmployerTaxes + WorkerComp + GPAdjPay + GPAdjCost + Burden)
GP/Billed Hour	Gross Profit divided by Bill Hours
GP(%)	Gross Profit divided by (BillAmount + GPAdjBill – DiscountAmount)

Back to Top