Visit Profit Margin Report

The SingleOps Visit Profit Margin Report provides a Visit-level breakdown of profit metrics. The report compiles all Visits within the filtered parameters & breaks them down by Visit & Client information, along with financial metrics such as Sales, Cost of Goods Sold (COGS), Expenses, Profit (in dollars), Profit (as a percentage), Payments & Balances.

Visit Profit Margin Report Columns

Search Visit Profit Margin Report

Totals/Average

Visit Profit margin Report Filters

 

Navigation: mceclip0.png Reports > Expenses & Job Costing > Visit Profit Margin Report

Filters

Date Range Choose between Today, Yesterday, Tomorrow, Last 7 Days, Last 30 Days, This Month, Last Month, Year To Date, or Custom Range.
Date Filter Used to determine if the Date Range is based on Visit Start Date or Visit Created Date
Visit Stages Select one or multiple Stage(s) (e.g. Scheduled, Completed, Approved, etc.) If none are selected, all will be included in the report.
Assignees Select one or multiple Assignee(s) associated to a Visit. If none are selected, all will be included in the Report.
Sales Reps Select one or more Sales Rep(s) associated to a Visit. If none are selected, all will be included in the Report.

 

Search

Search this report based on Visit's Reference Number, the name of the Visit, Operation, Client, or Job Category.

Columns

Click Columns and select one or multiple column types. To add and remove columns, the columns in blue will display in the report. The Columns section is dynamic. 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.

Columns

Ref # Visit’s reference number that links to the job's information page.
Visit Name The Visit’s name that links to the job's information page.
Visit Stage The current Visit stage (e.g. Scheduled, Completed, Approved, etc.)
Operation The Job-level Operation or service name that links to Operation information page (e.g. maintenance, design/build, tree service, etc.)
Client The Clients name that links to the Client's information page.
Created The date the Visit was created (yyyy-mm-dd)
Work Start The date that the Visit is scheduled to start.
*Note: if a cell is blank that means a start date has not yet been assigned.
Sales The revenue for each visit
*Note: If the visit is on a job using Fixed Invoicing, this column will be blank.
COGS The cost of goods (materials) that you've sold to your customer.
Expense Any Expense, including the cost of Service, Labor, & Equipment associated with the Visit
Profit $ Calculated by subtracting COGS & Expenses from Sales
Expressed algebraically: (Sales - [COGS + Expenses]) = Profit
Profit % Calculated by dividing Profit $ by Sales
Expressed algebraically: ([Profit / Sales] x 100) = Profit %
Payments The sum of the payments the customer has made for each visit.
*Note: The Visit's invoice is part of a CMB or RUP, a link to that invoice will be shown in the Payments & Balance columns.
Balances The dollar amount sum of how much the customer still owes.
Sales Rep The assigned Sales Rep on the Job-level

 

Total / Average

At the bottom of the page, totaled amounts for six columns - Sales, COGS, Expenses, Profit, Profit %, Payments - can be found.
*Note: These Totals reflect the sum of the displayed on this page only (<10), not the entirety of search results. Additional results can be accessed by clicking through the additional pages at the bottom right of the screen.

 

Was this article helpful?
0 out of 1 found this helpful

Comments

0 comments

Please sign in to leave a comment.