When planning out services, revenue, and products needed, it is helpful to have a place to see what has already been done and what you still have to complete. Our "Available Work Report" makes it easy to see these things. Just choose which service(s) and program(s) you want to see, and Spraye will show you how many services you started with, how many you have already completed, and how many you have left. We'll also show you information on square footage and revenue for these services.
Here's how it works:
Start by choosing Reports from the main navigation panel on the left side of your screen. Then, click Available Work Report.
From here, you can choose which services and programs you'd like to search.
Simply choose from the list, then click Search and Spraye will show you info on your chosen services broken down by service area.
Let us know if you have any questions about the "Available Work Report".
Standalone Services and the Available Work Report
When reviewing square footage totals and job volume within the Available Work Report, it is important to note how the system tracks standalone services versus standard program rounds.
The Behavior
Because Standalone services exist entirely outside of programs, the Available Work Report will not automatically account for them in its default square footage totals when running a broad, program-based search.
How to Pull Standalone Service Data
If you need the Available Work Report to pull and accurately display square footage or work volume for a standalone service, use the following filtering method:
- Navigate to the Available Work Report filter options.
- Leave the Programs selection fields entirely blank (do not select any programs).
- Go directly to the Services filter dropdown and select only the specific standalone service you want to review.
- Run the report.
System Rule: Filtering exclusively by the individual service while keeping all program filters cleared forces the report to isolate and display the standalone service data and its corresponding square footage totals.
Below is a detailed breakdown of all filters and columns in this report:
Filters:
Services - Only shows totals for any services chosen. If multiple services are chosen, it will add all #’s together.
Programs - Only shows totals for any services in chosen program(s). If multiple programs are chosen, it will add all #’s together.
Date Range - If a date range is selected, it will only show services that were added to properties within that date range.
Property Type - Will only show totals for the property type chosen.
Billing Type - Will only show totals for the billing type(s) selected. You can select more than one.
Columns:
Service area:
Lists each service area a property is a part of. All of these metrics are broken down by service area with a totals line at the bottom that gives a total for all service areas. The “NONE” service area means these are properties without a service area.
Total Services Assigned:
Total number of services originally assigned to properties
Total Services Scheduled:
Total number of services currently scheduled
Total Services Completed:
Total number of services completed
Total Service Outstanding:
Total number of services not scheduled or completed
% Services Completed:
(Total completed/total assigned) * 100
Total Sq. Feet
Total square footage originally assigned to properties
Total Sq. Feet Scheduled
Total square footage currently scheduled
Total Sq Feet Completed
Total square footage completed
Total Sq Feet Outstanding
Total square footage not scheduled or completed
% Sq Feet Completed
(Total sq ft completed/total sq ft assigned) * 100
Total Revenue Scheduled
Total revenue (pre-discount, without sales tax) currently scheduled
Total Revenue Produced
Total revenue (pre-discount, without sales tax) completed
Total Revenue Outstanding
Total revenue (pre-discount, without sales tax) not produced or scheduled
% Revenue Produced
(Total revenue completed/total revenue assigned) * 100
Total Discount Scheduled
Total of all discounted amounts currently scheduled
Total Discount Produced
Total of all discounted amounts completed
Total Discount Outstanding
Total of all discounted amounts not produced or scheduled
Total Net Revenue Scheduled
Total revenue (less discounts) currently scheduled
Total Net Revenue Produced
Total revenue (less discounts) completed
Total Net Revenue Outstanding
Total revenue (less discounts) not completed or scheduled