Operations dashboard examples: 6 for small businesses
Operations dashboard examples for field service, property, rental, stock and multi-location businesses: the KPIs on each, who checks them, and Excel formulas.
An operations dashboard is one screen that shows how today’s work is going, counted from the records your team already keeps. A field service company watches open and overdue work orders. A rental yard tracks trailers out and due back. A supply house sees items below reorder point, and an owner sees money owed.
This guide is for owners, office managers and operations leads at trades, property, rental and supply businesses whose numbers live in Excel or Google Sheets. It shows six example dashboards: the numbers on each, where they come from and who checks them. Then it covers how to build one in a spreadsheet, and when to turn it into an app.
How we researched this: Excel and Google Sheets steps checked October 2026 against Microsoft’s and Google’s own help pages, and GoodTaco’s prices against our pricing page.
What is an operations dashboard?
An operations dashboard answers one question: what needs attention right now? It counts the records that need action, such as open work orders, trailers due back or unpaid invoices, and flags the ones past a limit you set. People check it several times a day, so it has to update as the records change.
That makes it different from the three other kinds of dashboard:
| Type | Question it answers | Who checks it, how often |
|---|---|---|
| Operational | What needs doing today? | Dispatch and crew leads, all day |
| Tactical | Is each team on track this week? | Managers, weekly |
| Strategic | Are we on track for the year? | Owners, weekly or monthly |
| Analytical | Why did that number change? | The owner, when asked |
Operations dashboard examples by type of business
Six examples: field service, property maintenance, a rental yard, a shop or distributor, a business with several locations, and the owner’s weekly KPIs. Each shows the dashboard, where its numbers come from and who checks it.
1. Field service: open and overdue work orders
For HVAC, plumbing, electrical, pest control and cleaning companies. The dispatcher’s question all day: what’s late, and who can take the next job?
- Open work orders: every job not marked done, split by technician to show who has room.
- Overdue: open jobs past their due date. Chase these first.
- Not scheduled: jobs with no date or technician yet.
- Waiting on parts: jobs on hold, so nobody rolls a truck before the part arrives.
- Done this week, against the same point last week, so a slow week shows by Wednesday.
- Callbacks this month: return visits for the same problem, a simple check on quality.
HVAC and plumbing shops often add no-heat and no-cool calls, maintenance agreement visits due this month (the spring and fall tune-ups), and jobs done but not yet invoiced.
The numbers come from one work order log, with a record per job: status, technician, due date, date done and a Callback column (yes or no). The dispatcher checks it several times a day; the owner looks on Monday.
GoodTaco’s work order template opens on a board much like this one: requests to review, open and unassigned work orders, overdue, done this week, and the jobs that need attention. Its sample is a property maintenance team, so a service company would use its sites for customer locations. Our guide to what a work order is ends with a button that opens it.
2. Property maintenance: open requests by property
For property managers, HOAs and facilities teams. The question: is anything urgent waiting, and is anything being forgotten?
- Open requests, split by property.
- Urgent: no heat, no water, an active leak. Zero by the end of the day.
- Open over 7 days: the requests tenants end up calling about twice.
- Days to close, averaged over the last 30 days. Tenants notice when it creeps up.
- Repair spend this month against the budget.
The numbers come from a log of maintenance requests, one record per request, however it arrived. Each has the property, unit, priority, date opened and date closed, and spend comes from vendor bills tagged by property. The maintenance coordinator checks it every morning, the property manager weekly, and owners get the monthly totals.
3. Rental yard: units out, due back and in the shop
For trailer, equipment and tool rental businesses. The question at the counter: what’s going out, what’s coming back, and what can’t go out?
- Out on rent, and what share of the fleet that is. Rental businesses call it utilization.
- Due back today, so the yard is ready to check them in.
- Overdue returns: call these customers before lunch.
- In the shop: units waiting on repairs, which can’t go out.
- Out on rent by type: which units are always out (buy more) and which sit in the yard (sell some).
The numbers come from bookings, each with an out date, a back date and a status. The list of units gives each one’s type and whether it’s available, out or in the shop. Counter staff check it every morning and before closing; the owner looks weekly at use by type.
4. Shop or distributor: stock and orders
For parts counters, supply houses, hardware stores and small wholesalers. The question: what do we need to order, and what have we promised customers?
- Below reorder point: items with less on hand than the level you reorder at.
- Out of stock: nothing left on the shelf.
- Orders to ship, and how many are past the date you promised.
- Purchase orders due in this week, so someone’s ready to receive them.
- Reorder next: the items furthest below their reorder point.
The numbers come from a list of items with on-hand quantity and reorder point, kept current by every sale, delivery and stock count. Customer orders and purchase orders add their dates. The buyer or warehouse lead checks it every morning; the owner looks weekly at stock-outs and late orders.
5. Several locations: sales against target
For businesses with two or more shops, branches or service areas. The owner’s question: is every location on track this month, and who hasn’t paid?
- Revenue this month against the month’s target.
- Jobs and the average job.
- Not paid yet: money owed, with how many invoices are overdue.
- Month to date by location, with a line for where each should be by today. Here Riverside is behind and the other two are ahead.
The numbers come from sales or invoices from each location, such as a till export or a sales report from your accounting software. Each location also needs a monthly target. Location managers check their own numbers daily; the owner compares them weekly. GoodTaco’s dashboard template, below, is built on this layout: revenue by location against a monthly target, and who still owes you.
6. Owner’s weekly KPI dashboard: money and the week ahead
For any owner who wants one page on Monday morning. It’s the simplest KPI dashboard for a small business.
- Sales last week against the week before.
- Money owed, and how much is over 30 days late.
- Bills due this week, so payday is never a surprise.
- Jobs booked for next week: a thin schedule shows up before it becomes a quiet week.
- Money owed by how late it is. Bookkeepers call this an aging report.
The numbers come from invoices and bills in your accounting software, and from the job schedule. The owner checks it once a week, so whoever keeps the books enters invoices and payments by Friday.
How do you choose the KPIs for an operations dashboard?
Start from the questions your team asks, not the data you happen to have:
- Write down the questions people ask you. “Where’s trailer 14?”, “Did the Hendersons pay?”, “Who can take a job at 2?” Each one that comes up every week is a number.
- Pick the count that answers it. Count things someone can act on. “Overdue work orders: 4” sends someone to the phone; “work orders this year: 3,412” doesn’t.
- Set the limit that turns it red, or the comparison beside it. Overdue means past the due date, low stock means below the reorder point, late money means over 30 days. Other numbers sit next to a target or last week.
- Name who looks, and how often. If nobody owns a number, drop it. How often they look sets how fresh it must be: a dispatcher needs it current all day, the owner’s weekly numbers only by Monday morning.
- Make sure every number opens a list. Click “Overdue: 4” and you should see the four jobs, so nobody argues about what the number means.
Start with four. Add a fifth when someone asks for it twice.
How to build an operations dashboard in Excel
Records go on one sheet, the formulas that count them on a second, and the dashboard on a third:
- Turn each list into a table. Select the records, choose Home > Format as Table, and name the table, such as Jobs. Formulas that use the name, like
Jobs[Status], adjust as records are added. - Count with COUNTIFS and SUMIFS, one formula per number. COUNTIFS counts records that meet several conditions; SUMIFS adds up the amounts on them.
- Add PivotTables, charts and slicers for the breakdowns, such as open work orders by technician. Microsoft’s guide to building a dashboard in Excel walks through each one.
- Color the limits with conditional formatting, so an overdue count above zero turns red.
- Refresh before you read it. Formulas recalculate on their own, but in most versions of Excel a PivotTable updates only when someone clicks Refresh, or when the file opens if you turn that on. Automatic refresh is only for Microsoft 365 Insider program members so far (refreshing PivotTable data).
Formulas for some of the numbers above, with tables named Jobs, Bookings, Items and Invoices:
| Number | Formula |
|---|---|
| Open work orders | =COUNTIFS(Jobs[Status],"<>Done",Jobs[Status],"<>") |
| Overdue work orders | =COUNTIFS(Jobs[Status],"<>Done",Jobs[Due date],"<"&TODAY()) |
| Jobs done this week, from Monday | =COUNTIFS(Jobs[Done on],">="&TODAY()-WEEKDAY(TODAY(),2)+1) |
| Trailers due back today | =COUNTIFS(Bookings[Back date],">="&TODAY(),Bookings[Back date],"<"&TODAY()+1,Bookings[Status],"Out") |
| Items below reorder point | =SUMPRODUCT(--(Items[On hand]<Items[Reorder point])) |
| Money owed over 30 days late | =SUMIFS(Invoices[Balance],Invoices[Due date],"<"&TODAY()-30) |
The open count skips records with an empty Status, and the due-back count still works when you enter return times. COUNTIFS can’t compare two columns, so the reorder count uses SUMPRODUCT: it counts the items whose On hand is less than their Reorder point.
In Google Sheets, the same formulas carry over: Sheets has the same functions and the same Jobs[Status] table references once each list is converted with Format > Convert to table and given the same name. Sheets recalculates as people edit. For QUERY, slicers and pulling each location’s file in with IMPORTRANGE, follow our step-by-step Google Sheets dashboard guide.
When should an operations dashboard move out of a spreadsheet?
A spreadsheet dashboard works while one or two people keep the records and everyone may see everything. Signs it’s time for an app:
- Someone updates it by hand, pasting in yesterday’s jobs or a till export, or clicking Refresh. A dashboard that’s stale by 10 am stops getting opened.
- People need to act from it. The dispatcher marks a job done, the counter checks a trailer in, the office marks an invoice paid. In a spreadsheet, each of those means giving them edit access to the file.
- The crew works from phones. A sheet with 15 columns is hard to use from a truck.
- Not everyone should see everything. Microsoft says worksheet protection “is not intended as a security feature”. Anyone who can open the file can see every record, pay rates and margins included.
- Each location keeps its own file, and rolling them up means links between files that can break when someone renames a tab.
An app keeps the records in one place that people update as they work, and the dashboard counts what’s there right now. That’s what dashboard software built on your spreadsheet does. If customers are the ones who need a view, see our guide to client dashboards.
Build an operations dashboard that updates itself with GoodTaco
GoodTaco (our product) is an AI app builder for business teams. You describe the dashboard in plain words, and it builds a working app around your records: the numbers at the top, the list behind each one, and the screens your team uses to update them. Technicians close jobs and the counter checks trailers in from a phone’s browser, so the counts are current without anyone pasting or refreshing.
Start from whichever is closest to the dashboard you want:
- The job log, stock list or rental sheet you keep today. Turn your spreadsheet into an app: upload an .xlsx or .xlsm workbook or a CSV or TSV file, with no account needed to try. GoodTaco imports your records into a built-in database and rebuilds the formulas it can reproduce exactly. Charts and pivot tables aren’t imported, so the app builds its own dashboard from your records.
- A Google Sheet your team already works in. With the Google Sheets app builder, the app reads and writes that same sheet.
- The dashboard template, for a business with several locations. It shows revenue, sales and average sale against the period before, and whether you’re on pace for this month’s target, for the business and for each location you set a target for. It lists who still owes you, longest owed first, with a Mark paid button. Paste in past sales from Google Sheets, Excel, your till’s export or QuickBooks’ Sales by Customer Detail report, or pick a CSV file. The sample records come from a plumbing and heating company with three branches; clear them and rename the locations and services when you’re ready.
A first prompt like this is enough:
Build an operations dashboard from my Jobs sheet. Show open and overdue work orders, jobs not scheduled yet, jobs waiting on parts, jobs done this week and open work orders by technician. Tapping a number opens its list, and a technician can mark a job done from a phone.
To add a number or a screen later, describe it. Every version is saved so you can roll back, and you can make the app private so only the people you choose can sign in and see it. GoodTaco is free to start. Paid plans start at $9 a month, and Pro at $49 a month includes 10 users; bigger teams talk to us about Enterprise.
Put the numbers your team acts on in one place that keeps itself current. Start free, no credit card needed.
Frequently asked questions
What is an operations dashboard?
An operations dashboard is one screen that shows how today's work is going: what's open, what's late, what's running low and what's owed. It reads from the records a team already keeps, such as work orders, rentals, stock and invoices, and shows the few numbers someone acts on that day.
What KPIs should an operations dashboard include?
Four to six KPIs that someone acts on, each with a limit or a comparison and a list behind it. A field service company shows open and overdue work orders, jobs not scheduled, jobs waiting on parts, jobs done this week and callbacks. A rental yard shows units out on rent, due back today, overdue returns and units in the shop.
What is the difference between an operational and a strategic dashboard?
An operational dashboard shows what needs doing today, such as overdue jobs or trailers due back, and people check it several times a day. A strategic dashboard tracks longer goals, such as revenue against the year's target, and owners check it weekly or monthly.
How do I make an operations dashboard in Excel or Google Sheets?
Keep each list of records as a table on its own sheet, count what matters with COUNTIFS and SUMIFS on a second sheet, and lay out the numbers and charts on a third. Color the limits with conditional formatting. In Excel, refresh PivotTables after new records come in; Google Sheets recalculates as people edit.
Can I build an operations dashboard without code?
Yes. A spreadsheet dashboard needs formulas such as COUNTIFS, but no code. An AI app builder such as GoodTaco builds the dashboard from a description or from the spreadsheet you upload, and it updates as people add and change records.
How often should an operations dashboard update?
As often as the decisions it drives. A dispatcher's or rental counter's dashboard should update as records change, because people act on it all day. An owner's weekly numbers only need to be current by Monday morning.
What is a KPI dashboard for a small business?
It's one page with the handful of numbers the owner checks every week, such as sales against last week, money owed and how late it is, bills due this week and jobs booked for next week. The numbers come from the accounting software and the job schedule.
Start from the dashboard template
Get your own copy of a working dashboard app with sample data, ready to make yours. Free to start.
Use the dashboard template, free