Recommended Reports for Snow

Prev Next
This content is currently unavailable in Spanish. You are viewing the default (English) version.

These lists help you run snow season from Aspire: what's waiting for approval after a storm, which tickets have stray costs, how each storm performed, and what you owe your subcontractors. Each one is a saved list you build once in the Work Tickets, Activities, or Purchasing module, or in Reports, and reuse all season.

Things to know

  • These lists are recommendations, not requirements. Use them as a starting point and adjust the filters and columns for your team.

  • Every work ticket list filters on the Snow division. If your snow services aren't in a division named exactly "Snow," these lists won't find them.

  • One list matches tickets on either of two filters. To set this up, enter a condition in the Filter window, such as "1 AND 2 AND 3 AND (4 OR 5)". For more information, visit Organizing Your Lists.

  • Each of the following lists shows the filters to set, the columns to display, and how to group the results. For help building and saving a list, visit Building Snow Lists.

  • For a printable view of the services on each route, use the Route Snow Planner report in Reports > Standard Reports > Production. For more information, visit Using the Route Snow Planner Report.

Snow lists at a glance

List

Module

When to use it

Who uses it

T&M Pending Approval

Work Tickets

After each storm

Production Manager

Per Service Occurrence Pricing Pending Approval

Work Tickets

After each storm

Production Manager

Range Billing Switch List Pending Approval

Work Tickets

After each storm

Production Manager

Open or Scheduled Tickets with Costs and Revenue

Work Tickets

After each storm

Production Manager

Open or Scheduled Tickets with Zero Costs and Revenue

Work Tickets

After each storm

Production Manager

Completed Snow Tickets by Date

Work Tickets

After each storm and at month end

Production Manager

Fixed Payment Contract Ticket Review

Work Tickets

Monthly and at season end

Executive, Branch Manager, or Operations Manager

Seasonal Visit Count

Reports

Monthly and as you near a cap

Branch Manager or Operations Manager

Open Snow Issues

Activities

Daily during the season

Executive, Branch Manager, or Operations Manager

Event Sub Expense

Purchasing

After each storm

Purchaser

Fixed Payment Snow Subs

Purchasing

Monthly and at season end

Purchaser

After each storm: approval lists

Use these lists during your post-storm review to find tickets that need your attention before they're approved and invoiced. For the full review process, visit Reviewing Snow Work Tickets Pending Approval.

T&M Pending Approval

Review T&M snow tickets waiting for approval. Check hours and materials, and override the price on any ticket where more time was logged than you can justify.

Module

Work Tickets

Filters

Invoice Type: Contract | T&M
Status: Pending Approval
Division: Snow

Columns

Property Name, Work Ticket Number, Service Lookup, Act Hrs, Material Cost Actual, Sub Cost Actual, Earned Revenue, Completed Date

Group by

Service Lookup, Completed Date

For more information, visit Overriding a T&M Price at Approval.

Per Service Occurrence Pricing Pending Approval

Review Per Service snow tickets waiting for approval. Look for missing materials and for storms that ended early, where you may want to bill a partial occurrence.

Module

Work Tickets

Filters

Invoice Type: Contract | Per Service
Status: Pending Approval
Division: Snow

Columns

Property Name, Work Ticket Number, Service Lookup, Act Hrs, Material Cost Actual, Sub Cost Actual, Revenue, Earned Revenue, Completed Date

Group by

Service Lookup, Completed Date

Tip: Add the Sub Partial % column to see the partial occurrence percentage your subcontractors entered.

Range Billing Switch List Pending Approval

Find range billing tickets that need to be swapped to the depth that actually fell. Grouping by service puts every ticket at the same depth range together, so you can swap them in one bulk action.

Module

Work Tickets

Filters

Division: Snow
Invoice Type: Contract | Per Service
Status: Pending Approval

Columns

Property Name, Work Ticket Number, Service Lookup, Act Hrs, Material Cost Actual, Sub Cost Actual, Revenue, Earned Revenue

Group by

Service Lookup

For more information, visit Swapping As Needed Opportunity Services.

After each storm: cleanup lists

Use these lists right after a storm to find tickets that were worked but not completed, and tickets that were created but never worked.

Open or Scheduled Tickets with Costs and Revenue

Find T&M and Per Service tickets that have time or materials on them but weren't completed. Review the costs, then complete the tickets or move the costs to the right ticket.

Module

Work Tickets

Filters

Invoice Type: Contract | T&M and Contract | Per Service
Status: Open and Scheduled
Division: Snow
Total Cost Actual: greater than 0, or Earned Revenue: greater than 0

Columns

Property Name, Work Ticket Number, Service Lookup, Act Hrs, Material Cost Actual, Sub Cost Actual, Earned Revenue

Group by

None

Open or Scheduled Tickets with Zero Costs and Revenue

Find T&M and Per Service tickets that were created or scheduled for a storm but never worked. If a ticket wasn't needed, delete it so it doesn't clutter future storms.

Module

Work Tickets

Filters

Invoice Type: Contract | T&M and Contract | Per Service
Status: Open and Scheduled
Division: Snow
Total Cost Actual: equals 0
Earned Revenue: equals 0

Columns

Property Name, Work Ticket Number, Service Lookup, Act Hrs, Material Cost Actual, Sub Cost Actual, Earned Revenue

Group by

None

Tip: To delete unworked As Needed tickets in bulk, select them, then select Bulk Actions > Delete As Needed Tickets. You need the Delete Work Ticket permission and Full Access to Schedule Board or Read Only Access to Schedule Board.

Storm and season performance

Completed Snow Tickets by Date

Compare estimated hours and costs to actuals for each storm. Grouping by completed date keeps each storm's tickets together, so you can spot variances and track profitability by event.

Module

Work Tickets

Filters

Status: Complete
Division: Snow
Completed Date: the dates of the storm or month

Columns

Property Name, Work Ticket Number, Service Lookup, Est Hrs, Act Hrs, Material Cost Estimated, Material Cost Actual, Sub Cost Estimated, Sub Cost Actual, Revenue, Earned Revenue, Gross Margin

Group by

Completed Date

Fixed Payment Contract Ticket Review

Track cost against revenue on your seasonal snow contracts as the season goes on. Grouping by property shows which sites are running over, which helps you price them for next season.

Module

Work Tickets

Filters

Invoice Type: Contract | Fixed Payment
Opportunity Type: Contract
Division: Snow

Columns

Property Name, Work Ticket Number, Service Lookup, Act Hrs, Material Cost Actual, Sub Cost Actual, Revenue, Earned Revenue, Gross Margin, Status

Group by

Property Name

Note: Seasonal tickets should stay open until the season ends. If one shows a Complete or Pending Approval status mid-season, it was completed too early. Uncomplete it so it can take visits from later storms.

Seasonal Visit Count

Track how many visits each capped seasonal ticket has used. The Remaining Visits column shows the visits left only when Enable Limiting Fixed Price Services is on. Otherwise, compare the visit count to the limit on the estimate.

Module

Reports > Work Ticket Visits

Filters

Invoice Type: Contract | Fixed Payment
Division Name: Snow
Work Ticket Scheduled Date: the season's dates

Columns

Property Name, Service Name, Work Ticket #, Work Ticket Scheduled Date, Visit Sequence Number, Remaining Visits, Route

Group by

Work Ticket #

Issues

Open Snow Issues

Track unresolved issues your crews and office report this month, such as property damage or a missed site.

Module

Activities

Filters

Activity Type: Issue
Status: Open
Start Date: This Month
Activity Category: Snow (optional)

Columns

Start Date, Subject, Regarding, Activity Category, Priority, Property Name, Created by User

Group by

None

Note: Activities don't have a division, so this list shows all open issues. To see only snow issues, create a "Snow" activity category in Administration > Application > Lists and use it on snow issues.

Subcontractor costs

Use these lists in the Purchasing Assistant to see what you owe your snow subcontractors. For the full payment process, visit Paying Snow Subcontractors.

Event Sub Expense

See the subcontractor costs from a storm, so you can create purchase receipts.

Module

Purchasing

Filters

Auto Expense: Yes
Service Division: Snow
Scheduled Start Date: custom, from the first to the last day of the storm
Item Quantity Remaining: greater than 0
Item Quantity Allocated: equals 0
Branch Name: your branch, if you run more than one

Columns

Property Name, Item Name, Estimated Item Unit Cost, Unit Type, Estimated Qty to Order, Quantity to Order

Group by

Property Name

Fixed Payment Snow Subs

See subcontractor costs on seasonal snow contracts that still have quantities left to purchase. The Purchasing Assistant can't filter by invoice type, so this list also shows Per Service and T&M expenses. If your seasonal service names include "FP," add an Item Name filter that contains "FP" to show only those.

Module

Purchasing

Filters

Auto Expense: Yes
Item Type: Sub
Service Division: Snow
Item Quantity Remaining: greater than 0

Columns

Property Name, Item Name, Estimated Item Unit Cost, Unit Type, Estimated Qty to Order, Quantity to Order

Group by

Property Name

Note: Seasonal subcontractor expenses don't reach the Purchasing Assistant until you trigger them. Select Work Tickets > Bulk Actions > Trigger Auto Expense Creation first.

Standard snow reports

Aspire also includes standard reports you don't need to build. Open each one from the location listed.

  • Auto Expense (Reports > Standard Reports > Sales): every auto expense in one place, with the vendor, item, fee type, and amount. Use it to check subcontractor setup before the season, or to add auto expenses to many services at once. Requires View Drill Down Reports and View Drill Down Reports - Auto Expense Report.

  • Sub Ticket/Expense Exception (Reports > Standard Reports > Production): auto expense services without actual costs. Use it after a storm to find subcontracted work that hasn't generated an expense. Requires View Drill Down Reports - Sub Ticket/Expense Exception.

  • As Needed Exceptions (Scheduling module, three-dot icon): As Needed services with no work tickets in a date range. Use it after a storm to find services that weren't worked. Requires As Needed Exception Report.

  • Weather Events (Reports > Standard Reports > Production): the properties and ZIP codes each storm affected. For more information, visit Logging Weather Events.