Summary
The Gross Profit Detail Report provides a clear, transaction-level view of revenue, labor costs, and gross profit, helping users quickly understand where margins are gained or lost.
Its standout feature is the flexible Group By capability, allowing the report to be instantly organized by Office, User, Customer, Job Type, WC Code, Employee. This makes it easy to analyze performance from different perspectives without running multiple reports.
By combining detailed financial data with dynamic grouping, the report enables faster reconciliation, clearer margin visibility, and more confident business decisions — all in one place.
This report is essential for:
Finance & Accounting: validating billing vs. payroll before financial close.
Payroll & Billing Teams: reconciling payroll, billing, and gross profit totals.
Branch Managers: identify profitable vs. unprofitable clients, jobs, or placements.
By using this report, staffing companies gain transparency into margins, enabling smarter decisions about pricing, client relationships, and resource allocation.
Report Overview
Attribute | Details |
Purpose | Provides a detailed breakdown of gross profit and its components. Users can group results by Office, User, Customer, Job Type, WC Code, or Employee to view both summary and detailed profitability information. |
Classification | Business-Critical Report |
Who Should Use This Report | Finance and Accounting, Payroll and Billing Teams, Branch Manager |
Business Problem Solved | Help us to understand where profit is earned or lost by clearly showing the relationship between billed revenue and all associated labor and burden costs. |
Run Frequency | Weekly, Biweekly, monthly as needed for audits or financial review |
Related Reports | Gross Profit Summary, Gross Profit |
Business Value
Category | Description |
Profitability Analysis | Analyze profitability by Office, User, Customer, Job Type, WC Code or Employee |
Client & Job Insights | Identifies low-margin or loss-making customers and assignments. |
Operational Control | Supports pricing, rate negotiation, and cost-control decisions. |
Audit Support | Provides detailed reconciliation for payroll, billing, and gross profit totals. |
Known Issues or Limitations
Issues | Description |
No data displayed when only User is selected without User Level and User Type | Selecting only User without User Level/User Type may return no data. |
Data mismatch when viewing user-wise data at the Assignment level | The system currently does not track User Type at the Assignment Schedule level. As a result, the report displays data based on the User assigned at the assignment level, which may differ from user-type expectations. |
Troubleshooting Guide
Issues | Problem Reason | Solution |
No data displayed | Only User parameter selected | Include User Level and User Type |
Data not appearing | Transaction Batch not closed | Verify whether the transaction batch has been fully processed and closed |
Missing customers/data | Filters are too restrictive or access limited | Adjust filters and confirm access |
Pay code amounts missing | Bill-only transactions not tied to Job Type | Avoid selecting Job Type filter |
No Burden | Burden rate is not configured at the Office level in ATM | Ensure the burden rate is properly set up at the Office level in ATM, as burden is calculated only at the office level |
GP% incorrect after edits | Batch reopened, bill rate updated | Post Invoice Batch to trigger recalculation |
FAQ
Questions | Answers |
How can I determine why a negative gross profit appears in the system before closing payroll for the week? | Use the Gross Profit Detail Report to review transaction-level billing, pay, and burden costs, or refer to the Gross Profit Summary Report for a high-level view to identify the cause of the negative gross profit. |
Is there a report by user for GP and hours? | Yes, the Gross Profit Detail Report. |
Why does Bill Hours differ between reports? | Transaction Batch Detail shows hours before calculations; GP Detail shows calculations. |
Reference Video/Screenshot
https://www.youtube.com/watch?v=XF31Yn3uztQ
Report Details
Category | Value |
Parent Category | BackOffice |
Category | Gross Profit/ Transaction |
Report Type | Paginated Report |
Report runs from Application | RMS |
Report Category | Shareable |
Report Level | Transaction |
Report Parameters
Report Parameter | Description | Parameter Options | Default | Required |
Date Type | Filters record by the type selected | Accounting Period Date/ Pay Period End Date/ Check Date | Accounting Period Date | Yes |
Start Date | Filters records by the Date Type parameter | Yes | ||
End Date | Filters records by the Date Type parameter | Yes | ||
Company | Filters records by companies selected | List of companies that the users have access to | No | |
Office | Filters records by offices selected | List of offices for the company selected | No | |
Group By | Groups records by the option selected | Office/ User/ Customer/ Job Type/ WC Code/Employee | Office | Yes |
Job Type | Filters records by job type selected. | Temp/ Temp to Hire | No | |
User Level | Filters user type by User Level selected | Assignment/ Customer/Job/Transaction | No | |
User Type | Filters records by User Type selected | List of User Type for the User Level selected | No | |
User | Filters records under the User selected | List of all the office staff that the user has access to | No | |
Roll up to Parent Customer | Filters recorded by customer department or rolled into root customer | False | Yes | |
Customer | Filters records by customer name | % | No |
Report Grouping
Company
Office
The report will be grouped as per the Group by parameter value selected. Depending on the value selected in the group order, it will be defined.