Free Google Sheets Work Order Template by Smarfle
Work order template designed for small service businesses, facilitating job tracking and technician management. It includes tabs for work orders, materials, and a dashboard summarizing key metrics like overdue orders and revenue. Users can input business details, technician information, and service catalogs, while tracking job statuses and completion records. The template is suitable for various services such as HVAC maintenance, cleaning, and pest control, providing a structured format for managing customer interactions and job execution.
Content article
Overview of Work Orders
The Smarfle Work Order Template provides a comprehensive solution for managing service jobs, featuring detailed records for various tasks, with a total of seven work orders documented in the system.
Work Orders
Among the recorded work orders, WO-1001 was created on November 1, 2026, for Morgan Ellis, who resides at 10 Example Lane, Orlando, FL 32803. This order involved HVAC maintenance and filter replacement, scheduled for November 5, 2026. The technician assigned was Sam Carter, and the job was marked as completed on the same day. The total amount for this order came to $277.00, which included $170.00 for labor (2 hours at $85.00 per hour) and $100.00 for materials, with a tax of $7.00 applied.
Another work order, WO-1002, was created for Jamie Reed on November 2, 2026, for deep cleaning services at 20 Example Lane, also in Orlando. This job was completed on November 6, 2026, and although it incurred a total of $190.68, it remains unpaid. The labor for this job was billed at $55.00 per hour for 3 hours.
WO-1003, assigned to Casey Brooks, involved pest control services at 30 Example Lane, created on October 25, 2026. This order was completed on November 1, 2026, with a total amount of $157.45, including $120.00 for labor and a tax of $7.00.
The system also includes scheduled orders like WO-1004, which is for Drew Bennett at 40 Example Lane, set for November 9, 2026, and currently unpaid. In contrast, WO-1005 for Alex West, scheduled for November 10, 2026, is still in progress, with no total recorded yet.
Materials
The materials used in these work orders include HVAC filters and coil cleaners. For instance, in WO-1001, two HVAC filters were supplied and fitted, totaling $90.00, while one coil cleaner was used, costing $10.00. WO-1002 included cleaning supplies, which amounted to $24.00, and WO-1003 utilized a pest control kit priced at $35.00.
Interestingly, WO-1005 features a custom material that requires a price to be entered before printing, indicating a need for further input before the order can be finalized.
Price List
The price list provides a clear breakdown of costs associated with various services and materials. HVAC filters are listed at $45.00 each, while coil cleaners are priced at $10.00 each. Cleaning supplies cost $12.00 each, and pest control kits are available for $35.00 each. Additionally, labor services are charged at $85.00 per hour, and HVAC maintenance visits are priced at $125.00 per visit.
Settings
In the settings tab, the report date is set to November 10, 2026. The business name is recorded as Sample Service Co., located at 100 Sample Street, Orlando, FL 32803, with a contact number of 202-555-0199 and an email address of office@example.com. The default labor rate is established at $85.00, and the tax rate is set at 7.000%.
The template is designed to facilitate tracking and managing service jobs efficiently, ensuring that all necessary details are documented and accessible for both technicians and administrative staff.