The Work Order Management System Web App runs a facility maintenance or field service business in one browser application: service requests, work orders with SLA due times, the dispatch board, preventive maintenance plans, customers, sites, the asset register, technicians, labor, parts and stock, invoices, payments and receivables, and 16 ready-made reports, with 6 logins across 5 roles. It is built on Google Apps Script and keeps every record in a Google Sheet in your own Drive, so it works as work order software you own outright.
From the first call to the paid invoice, every step updates the same live database, so the dashboard, the dispatch board and the receivables always agree. Think of it as a maintenance management system, a field service tool and a work order tracker in one download.
✅ Instant download · One-time payment · No subscription · No per-user fees
🌍 Join 10,000+ customers in 180+ countries using NextGenTemplates to replace paid SaaS tools with one-time-purchase Excel, Google Sheets, Power BI and HTML templates.
Watch the Work Order Management System Web App walkthrough
🚀 Try the Live Demo: Login Details
Open the working Work Order Management System Web App in your browser right now: no download, no sign-up, nothing to install. Sign in as any role below and see exactly which screens that person can and cannot reach.
Demo sign-in details: 6 logins across 5 roles
| Role | Username | Password | What this role can reach |
|---|---|---|---|
| Administrator | admin | Admin@123 | Everything, including users and roles, settings, the audit log, the database archive and backups |
| Operations Manager | manager | Manager@123 | Requests, all work orders, dispatch, PM plans, customers, sites, assets, technicians, labor, parts and stock, invoices, reports, lists, audit log, import, export and email |
| Dispatcher | dispatch | Dispatch@123 | Requests, all work orders, the dispatch board, PM plans and generation, sites and assets, labor, parts issue, reports, export and email |
| Technician | tech | Tech@123 | Only the work orders assigned to them: start, hold, log time, issue parts, complete with resolution and sign-off |
| Technician | tech2 | Tech@123 | Only the work orders assigned to them: start, hold, log time, issue parts, complete with resolution and sign-off |
| Billing Clerk | billing | Billing@123 | Customers, work orders (read only), invoices and payments, reports, audit log, import, export and email |
These credentials are public on purpose. The demo is a shared instance seeded with a fictional facility services company in Central Ohio and it may be reset at any time. It is not anybody’s live business data. Your own copy gets its own database, its own users and its own passwords, and the setup notes ask you to change every seeded password before anyone else signs in.
🔑 Key Features of the Work Order Management System Web App
📌 Service requests to work orders. Log requests from phone, email and the portal, then approve and convert them into work orders or reject them.
📌 SLA due times by priority. Work orders move from New to Invoiced with an SLA due time from the priority and the customer’s SLA plan, plus labor, parts and sign-off.
📌 A weekly dispatch board. See every technician and day on one screen.
📌 Preventive maintenance that generates its own jobs. PM plans create scheduled work orders and the dashboard tracks PM compliance.
📌 Customers, sites and assets. Contract type, SLA plan, labor rate and parts markup per customer, access notes per site and a register of equipment with make, model, condition and next PM.
📌 Technicians, labor and parts. Cost and bill rates, hours and utilization, a labor log with regular, overtime and after-hours rates, and parts with stock value and reorder alerts.
📌 Invoices and receivables. Invoice completed work, send it, record a payment or void it, and watch receivables ageing.
📌 16 reports. Print them or export to CSV.
📌 6 logins across 5 roles. Administrator, Operations Manager, Dispatcher, Technician and Billing Clerk, with an audit log. Technicians see only their own work orders.
🖥️ What’s Inside: Screen by Screen
The sidebar groups the screens as Overview, Service Desk, Customers and Assets, Resources, Billing, Insight, Administration and Support. These are the main ones.
Sign-in page
Username and password sign-in with the feature list beside it. Passwords are never shown on this screen.
Dashboard
Open work orders, SLA met rate, billed in the last 30 days, PM compliance and open receivables across the top, with more KPI cards, a work orders created vs completed chart, an open backlog by status and today’s schedule below.
Service requests
Requests logged from phone, email or the portal, with category, priority and status. Approve a request and convert it into a work order, or reject it as a duplicate.
Work orders
Every work order from New to Invoiced with priority, type, technician, SLA due time and amount, searchable and filterable, with labor, parts and sign-off on the detail screen.
Dispatch schedule
A board by technician and day for the whole week, so the dispatcher sees who is booked, who is free and which jobs are waiting for a time.
Preventive maintenance
PM plans with frequency, assigned technician, next due date and status. Generate the scheduled work orders with one button and track PM compliance.
Assets and equipment
The asset register with make and model, location, criticality, condition, next PM date and service cost to date.
Invoices
Ready to invoice by customer, open receivables with ageing buckets, and the invoice list. Create an invoice from completed work, send it, record a payment or void it.
Reports
A library of 16 reports for operations, SLA, technicians, preventive maintenance, assets, parts and billing, each with print and CSV export.
Users and roles
Application users with their role and status, plus the permission matrix that shows what each role can do. The same map drives the sidebar and the server checks.
📊 Work Order Management System Web App vs. Spreadsheet vs. Paid Work Order Software
| Feature | This web app | Spreadsheet | Paid work order software |
|---|---|---|---|
| Cost | ✅ One-time payment | Free, but you build it | Monthly subscription, often per user |
| Data location | ✅ A Google Sheet in your own Drive | Your file | Vendor cloud |
| Service requests to work orders with SLA due times | ✅ Yes | Manual | ✅ Yes |
| Dispatch board by technician and day | ✅ Yes | No | ✅ Yes |
| Preventive maintenance plans that create jobs | ✅ Yes | Manual | ✅ Yes |
| Role-based logins and audit log | ✅ 5 roles | Sheet sharing only | ✅ Yes |
| Mobile app, GPS tracking, online payments | No | No | Often ✅ |
For a maintenance or service team that wants requests, jobs, dispatch, PM and billing in one system without a per-user subscription, this web app sits in the sweet spot.
👥 Who This Web App Is For, and Who It’s Not For
✅ This web app is built for:
- Facility maintenance and field service companies with a small office team and technicians in the field
- Maintenance departments that need preventive maintenance schedules and an asset history
- Service businesses that invoice customers for labor and parts after each job
❌ This web app is NOT for:
- Teams that need a native mobile app, GPS tracking or route optimisation
- Businesses that need online payment collection or accounting software
⚙️ How to Set Up the Work Order Management System Web App
- Try the live demo above first, and sign in as two or three different roles.
- Download the ZIP: it holds Code.cs.txt, Index.txt and the PDF user manual.
- Create a new Google Apps Script project, paste Code.cs.txt into Code.gs and add an HTML file named exactly Index with the contents of Index.txt.
- Deploy it as a web app and accept the Google permission prompt.
- Open the web app and press Run setup now, or run the setup function from the editor, and wait for Setup complete.
- Sign in with the administrator account from the manual and change every seeded password.
- Open Settings to enter your company details, then delete or replace the sample data.
💼 Real-World Use Cases
An HVAC and refrigeration contractor logs a walk-in freezer call as a service request, converts it to an emergency work order and drops it on the dispatch board for the nearest technician.
A facilities manager sets quarterly rooftop unit plans, generates the scheduled work orders and watches PM compliance on the dashboard.
A billing clerk opens Ready to invoice, creates the invoices for completed jobs and follows receivables ageing.
❓ Frequently Asked Questions
Can I try the Work Order Management System Web App before buying?
Yes. The live demo above runs the full system with fictional data. Sign in with any of the 6 demo accounts to see the dashboard, the screens each role can reach and the reports before you spend anything.
What do I need to run it?
A Google account and an internet connection. The web app runs on Google Apps Script and creates its own Google Sheet database in your Drive during setup. Your team signs in with the usernames you create.
How do SLA due times work?
Each work order gets an SLA due time from its priority and the customer’s SLA plan, and the dashboard shows the SLA met rate.
Can technicians see everyone’s jobs?
No. A technician sees only the work orders assigned to them and can start, hold, log time, issue parts and complete them with a resolution and sign-off.
Does it collect payments?
No. It records payments against invoices and shows receivables ageing. Your bank or payment processor collects the money.
Is there sample data?
Yes. Setup loads 15 months of history for a facility services company: 24 customers, 51 sites, 502 assets, 358 PM plans, 9 technicians, 77 parts, about 3,300 work orders and 620 invoices. Delete it or import your own once you know the system.
How long does setup take?
You paste two files into a new Apps Script project, deploy it as a web app and press Run setup now. The first run loads the starter data in a few minutes, and the manual in the ZIP walks through each step.
👤 About the Author
Built by PK, Microsoft Certified Professional with 15+ years of Excel, Google Sheets, Apps Script and Power BI experience, founder of NextGenTemplates and the YouTube channels @PKAnExcelExpert and @NextGenTemplates. Every template is hand-built and tested before release.
🔗 Explore Related Templates
🎧 Helpdesk Ticketing Management System Web App: tickets and SLAs for support teams.
🧯 Fire & Safety Audit Management System Web App: audits and corrective actions.
💻 IT Asset Management System Web App: a register for IT equipment.
🏠 Rental Property Management System Web App: rent, leases and maintenance for landlords.
Browse every system in Web Apps.
🎥 Visit our YouTube channel for step-by-step video tutorials
👉 YouTube.com/@NextGenTemplates
📅 Last updated: November 2026
Reviews
There are no reviews yet.