The Line Item Report in SingleOps displays all individual Line Items on all Jobs within the selected date range & filters. It is best used for viewing specific details of Item usage & includes functionality for Summary Data for Business Insights. Depending on Job volume within an account, narrowing the date range search to one quarter is recommended due to the extensive amount of content generated by the report.
Items for On-Demand Jobs will not appear on the Line Item Report until they are assigned to a Visit.
Navigate to: Reports > Items > Line Item 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. The Date Range filter pertains to the Invoice Date or the Converted to Active Date to display Line Item results. |
Item | Select one or more Items |
Visit Stages | Select one or multiple Stage(s) associated to an Item. This will display Visits within these stages. Approved is the most popular visit stage because this will update the margin and the completed actual quantity |
Operation | Operation (e.g. maintenance, design/build, tree service, etc.) If none are selected, all will be included in the Report. |
Assignee | Select one or multiple Assignee(s) associated to an Item. If None are selected, all will be included in the Report. |
Sales Rep | Select one or multiple Sales Rep(s) associated to an Item. If None are selected, all will be included in the Report. |
Tags | Select one or multiple Tag(s) to include Tags associated to an Item. If None are selected, all will be included in the Report. |
Client | Type in one or more existing Client name(s). If none are selected, all will be included in the Report. |
Line Item | Choose to show Jobs with Actual and/or Billable checked. |
Bill Type | Check and uncheck Bill Types to display Fixed, Per Visit, and Fixed Combined Jobs. |
Columns | Add and remove columns. The columns in blue will display in the report. Click to add or remove. |
Save for All Users | This will save for all Users that have access to Reports in SingleOps. |
Save Report | Allows you to save and name as a new report with current filters, date range, columns, etc. This Saved Report can be found under your Saved Reports tab in SingleOps. |
Export CSV | To download and view the entire data set, click the Export CSV button at the top right of the page. This file can be opened using Excel or Google Sheets with all columns or as import. |
Summary Data For Business Insights | Summary Data for Business Insights enables you to take all of the information in a report and summarize it to develop powerful insights into your business. |
⚠️ Fixed and Fixed Combined invoice line items are not tied to a specific visit. Because of this, they are not affected by the Visit Stage, Tags, or Assignee filters and will still appear even when those filters are applied (their Visit Stage will show as blank). To exclude them from the report, uncheck Fixed and Fixed Combined in the Bill Type filter.
Search
The search matches any of the item, category and subcategory names as well as the abbreviated name of any units of measure you have set up (e.g. lbs, hrs, etc).
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.