The Man Hour Report provides users with a visit-level breakdown of, not only profit metrics, but many other financial performance metrics as well. This report compiles all visits within the parameters of the filters (which will be covered later) and breaks them down by invoice date, visit and client information, along with financial metrics such as Cost of Goods Sold (COGS cost), Expenses, Gross margin, Total labor hours, and margin per hour.
Navigate to: Reports > Expenses and Job Costing > Man Hour Report
Man Hour Report Features
Filters
To begin using the report to its fullest potential, we recommend utilizing the filters such as: Date Range, Operations, & Sales Rep.
Date Range is based on the Invoice Date. If a visit does not have an Invoice Date, the report uses the Approved Date.
For Margin/Hour and Revenue/Hour to populate, the visit must have labor hours recorded. Depending on your workflow, this may require adding a labor line on the Visit Completion Page or enabling the labor reporting setting for timesheet or labor resource entries.
Field | Description |
Date Range | Date Range allows you to select a timeframe of your choosing *based on the invoice date. |
Operations | Operations allow you to analyze margin per man hour by designated business operation (or Quickbooks classification). |
Sales Rep | Sales Rep filter allows you to drill down into the report by sales rep. |
These filters can be used one at a time or not at all. Filtering by both operation and sales rep will give you more precise information.
If there is not an Invoice Date available on the visit, the data will use the Approved Date.
Example: For instance, if you wanted to look at the Margin Per Man Hour on my Residential Installation Operation for the first half of the year:
Set the Date Range from 1/1/2020 - 6/30/2020
Select Operation
Once you've set those parameters, you can get a grasp of your sales numbers, COGS, expenses, margins, and your margins per man hour.
Columns
Click Columns and select one or multiple column types. To add and remove columns, the columns in blue will display in the report.
Rearrange Columns by clicking and holding the column header, move to the left or right and drop. Sort rows by clicking the up & down sort arrows icon, click once to sort from low to high, and again to sort from high to low.
Approved at | This is the date that the visit was moved to the Approved stage in the SingleOps workflow |
REF # | This is the reference number for the visit (or Visit number) |
COGS COST | This is the cost of the goods that you've sold to your customer. (To find out how your COGS formula is currently calculated, as an admin user: navigate to Account Settings > Scroll to the COGS Formula tab) |
Expense | Visit expenses, including labor and other expense categories included by the account's reporting settings. Labor and non-labor expenses are not separated into distinct columns in this report. |
Gross Margin | This is calculated by subtracting COGS and Expenses from Sales . |
Total Hours | The total hours shown for the visit. The source of these hours depends on the account's labor reporting configuration. |
Margin/Hour | The margin/hour is calculated as the gross margin divided by the number of hours, this shows the margin generated per labor hour, including non-labor margins. |
Revenue Per Man Hour | Invoice Total divided by Total Hours. This shows the revenue associated with each reported labor hour. (Invoice Total ÷ Total Hours = Revenue Per Man Hour) Example: If the Invoice Total is $100,000 and Total Hours is 5,000, Revenue Per Man Hour is $20. |