Skip to content

Analyze gross profit by company or location

The Gross Profit Analyzer (GP Analyzer) breaks down cost, sales and gross profit margin by department. It lists the folders delivered and invoiced (or completed and invoiced) in a date range, with all sales and costs for those folders.

How the GP Analyzer differs from financial reports

Section titled “How the GP Analyzer differs from financial reports”

The GP Analyzer is an operations and management tool, not a financial statement. It won’t match the P&L or other sales reports.

  • It shows gross profit for the selected folders as of today, no matter which financial period the sales or costs were posted in. Financial statements show sales and costs in the period they were recorded.
  • It includes estimated costs. Everything in the Charges section is an estimated cost, and pending credits are estimated costs or credits.
  • It includes only folders that have a work order. Sales or costs on a folder without a work order show on other sales and cost reports, but not here.

Common timing differences between the GP Analyzer and the financial statements:

  • A supplement written after a month was closed. The sales difference falls into the first open financial period for Sales.
  • Costs (AP invoices) added to a folder after a month was closed. The difference falls into the first open financial period for Cost of Sales.
  • Costs for a vehicle return are recorded in the month they happen, for example warranty work on a vehicle repaired three months earlier.
  1. On the Operations tab, in the Analytics group, select GP Analyzer.

    GP Analyzer in the Analytics group

  2. Choose the Market, Location and other filters, and the Invoiced/Completed Date range (Period, or From and Thru).

  3. Select Refresh.

    The Gross Profit Analyzer filters and the Refresh button

The results are split into Purchases, Labor and Charges. Hover over the chart to see the totals for each group.

The chart with cost and GP totals for Labor

  1. Double-click a sales code on the left. The folders for that sales code load on the right.

    Sublet Labor selected, with the folders included in Sublet Labor

  2. Double-click a folder, or filter the grid by folder, to see the estimate lines for that folder.

    The estimate lines for one folder

  3. To go back to all folders, select the x next to the folder filter.

    The x next to the folder filter

For example, to show Parts - OEM for Ford with a GP % above 30%:

  1. Double-click the sales code, for example Parts - OEM.

  2. Use the grid filter on the Veh Make column to choose the make.

    Filtering the Veh Make column to Ford

  3. Select Edit Filter.

    The Edit Filter button

  4. In the Filter Editor, choose the column, the operation and the value, for example [GP %] Is greater than 30.0, then select OK.

    The Filter Editor with Veh Make equals Ford and GP % is greater than 30.0

The grid shows the folders in Parts - OEM for Ford with a GP % above 30%.

Folders included in Parts - OEM filtered by make and GP %

Labor cost doesn’t show until technicians have been flagged and paid. Labor costs come from the weekly approved flag batches. When a flag batch is approved, Nexsyis calculates the cost as the hours flagged times the pay rate in effect on that date for the person or team. The flags become cost transactions, like an AP invoice.

When you look at a single folder, the GP Analyzer also estimates the cost of hours not yet flagged, using the current pay rate. See Analyze gross profit for a folder.

Sales Class: Charges with Storage, Shop Supplies and Paint Materials lines

  • Non-paint material charges (such as Storage and Shop Supplies): the GP % always equals the expected GP % set for the location. The GP amount and cost are calculated from that percentage.
  • Paint Materials - Liquid: for folders with mixing machine data, the cost comes from the mixing machine, and the GP % is the GP amount divided by sales.
  • Paint Materials - NonLiquid: for folders with mixing machine data, the GP % always equals the expected GP % for the location.
  • Paint Materials: for folders without mixing machine data, the GP % always equals the expected GP % for the location.

For more about paint materials, see Paint materials and mixing machine data.

  1. Open Settings › Setup › Company › Locations, and select a location.

  2. Select the Profile tab.

  3. In the GP Analyzer % Display for Charges grid at the bottom right, click in the GP% column and change the value.

    The GP Analyzer % Display for Charges grid on the location Profile tab

  4. Select Save. Changes aren’t kept until you save.

The new percentages apply in the GP Analyzer for folders at that location.