Standard Report - Gross Profit

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.

• Gross Profit setup.

Purpose: This report calculates the company's gross profit and provides detailed insights into the components that contribute to it, such as bill amounts, wages, taxes, and additional costs.

Why It Matters: Understanding gross profit is crucial for assessing financial performance and making informed business decisions regarding pricing, cost management, and profitability.

Efficiency Drivers:

• Customizable Parameters: Allows filtering by customer, date type, order type, and grouping by different categories (e.g., branch, user, customer) for tailored analysis.
• Roll-up Option: Consolidates data for a holistic view or detailed department-level insights.

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

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	Total amount payable either to the sub-contracting agency or the individual contractor excluding any deductions.
Employer Taxes	Sum of all Employer Taxes.
Worker Comp	Sum of Worker Comp Cost. 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)

Actionable Insights:

• Assess Profitability by Segments: Identifies which customers, branches, or user types contribute most to gross profit.
• Monitor Cost Elements: Tracks wages, taxes, and agency costs to optimize profit margins.

Leveraging the Gross Profit Report helps businesses optimize costs, enhance profitability, and strategically manage financial resources for growth