The Transportation Services Dashboard in Google Sheets turns a flat trip log into a six-page operations view. The sample file ships with 500 trips worth $215,597 across 8 depots, 9 service lines and 8 vehicle types, and every figure on screen is driven by native Google Sheets pivot tables and slicers rather than a wall of helper formulas. Sixteen slicers across four analysis pages cut revenue, distance and delay rate by month, depot, service type, vehicle, driver, route zone, contract tier and payment method. It joins a catalogue of 300+ hand-built NextGenTemplates spreadsheets. There is nothing to install and no subscription – open the PDF in your download, click the copy link, and the whole dashboard lands in your own Google Drive in about a minute. If it is not what the screenshots show, tell us and we will make it right.
Key Features of the Transportation Services Dashboard in Google Sheets
- Pivot-table architecture. Every chart reads a real pivot table parked to the right of its page. Scroll past the spacer column and you can inspect the exact numbers behind any visual – useful when a depot manager questions a figure.
- Page-scoped slicers. Four slicers sit in a FILTERS strip at the top of Overview, Fleet, Services and Clients. Clicking one redraws all four charts, the sidebar Top 5 table and the share bars on that page. Each page keeps its own filter state.
- Unfiltered KPI cards by design. The KPI strip and the AT A GLANCE list use SUMIFS and COUNTIFS against the Data sheet, so they always show the network total. That gives you a fixed reference point while the charts move under a slicer.
- Trip-level search. The Search page takes any Trip ID from a dropdown and returns 16 fields for that trip – date, depot, service type, vehicle, client, contract tier, revenue, passengers, distance, driver, payment method, status, route zone, month and quarter.
- Auto-expanding ranges. Pivots, slicers and formulas already cover 1,000 data rows. Paste new trips anywhere up to row 1001 and nothing needs rewiring. Need more? Raise DATA_ROWS in the bundled Apps Script and re-run.
- One-block theme. The palette is a single constant at the top of the script – ink #0B3954, accent #FF7043, cyan #4DD0E1. Change three hex codes and the banner, tabs, cards and every chart series follow.
What’s Inside the Transportation Services Dashboard in Google Sheets
Overview – network-wide performance
The landing page reports the whole network: Total Revenue $215,597, Total Trips 500, Distance Covered 54,301 km and Avg Trip Value $431. Monthly Revenue Trend and Revenue by Service Type sit above Revenue by Contract Tier and Depot Revenue vs Trips. The right rail carries a Performance Snapshot (completion rate 73.8%, revenue per km $3.97, average trip distance 109 km), a Top 5 Depots by Revenue table led by Central Depot at $54,039, and a Trip Status Mix bar set. Slicers: Month, Depot, Service Type, Status.
Fleet – depot and vehicle utilisation
Fleet answers where the assets are earning. KPI cards read Completed Trips 369, Distance Covered 54,301 km, Central Depot Rev $54,039 and Avg Trip Distance 109 km. Revenue vs Distance plots both measures per depot on twin axes; Revenue by Depot & Vehicle stacks eight vehicle types inside each depot; Monthly Distance Covered tracks the kilometre curve; Trips by Status splits the 73.8% completed share from delayed and cancelled work. The rail ranks vehicle types – Luxury Coach $67,987 ahead of Semi-Trailer $61,025 – and shows depot revenue share. Slicers: Depot, Vehicle Type, Month, Contract Tier.
Services – service line, driver and route coverage
This page separates the nine service lines. Freight Haulage Rev $78,684, Courier Deliveries 62, Airport Transfer Rev $10,849 and Largest Trip Value $4,186 head the strip. Revenue by Vehicle Type and Service Revenue vs Trips sit above Revenue by Driver and Distance by Route Zone, so you can see that Zone A – City Core carries 28.7% of distance while Zone E – Rural carries 13.5%. Top 5 Drivers by Revenue puts Priya Nair at $29,924. Slicers: Service Type, Vehicle Type, Driver, Route Zone.
Clients – contract tiers, zones and payment behaviour
Clients covers who is buying and how they pay. Enterprise Revenue $29,760, Corporate Trips 114, Active Clients 218 and Delay Rate 7.8% sit on the cards. Trips by Contract Tier counts all six tiers (Corporate 114, Ad-Hoc 99, Retail 91, Standard 89, Enterprise 61, Government 46); Zone Revenue vs Passengers pairs money with headcount; Revenue by Payment Method shows Corporate Account at 25.3% against Cash at 7.8%; Monthly Trip Volume tracks booking rhythm. Slicers: Contract Tier, Route Zone, Payment Method, Month.
Search – single trip lookup
Pick a Trip ID and the Trip Details panel returns the full record. It is the page you open when a client calls about one job: which depot ran it, which driver, what the client was billed, whether it completed or was cancelled, and which route zone it fell in.
Instructions – a 10-point user guide
The last tab explains the build in plain language: where the pivots live, how to clear a slicer, why the KPI cards stay unfiltered, how the 1,000-row auto-expand works, and how to change the colour theme. Hand this page to whoever inherits the file.
Google Sheets vs. Excel vs. Paid Fleet Telematics Software – Where This Fits
| This template (Google Sheets) | Excel dashboard | Fleet telematics SaaS | |
|---|---|---|---|
| Cost | One-time, under $20 | One-time, plus a Microsoft 365 seat | Per-vehicle monthly fee |
| Platform | Any browser, Android, iOS | Desktop Excel; mobile is limited | Web plus vendor app |
| Setup time | About a minute – copy and paste your trips | Download, open, replace data | Hardware fitting and onboarding, often weeks |
| Real-time team collaboration | Yes, native multi-user editing | Only via OneDrive co-authoring | Yes |
| Mobile access | Full read and edit | Read-mostly | Yes |
| Customisable fields | Yes – edit the Data sheet headers and the script | Yes | Usually fixed to the vendor schema |
| Share with a link | Yes | File attachment or cloud link | Seat-based logins |
| Year-1 cost at 5 users | The purchase price, once | Purchase price plus five subscriptions | Typically four figures and up |
| GPS and telematics hardware | Not included – this reads your trip log | Not included | Included, and required |
| Who owns the data | You, in your own Drive | You, in your own file | The vendor’s platform |
The honest summary: telematics software tells you where a vehicle is right now. This dashboard tells you what your trips earned, which depots and service lines carry the business, and where delays cluster. They answer different questions, and plenty of operators need only the second one.
Who This Template Is For – and Who It’s Not For
A good fit if you run a multi-depot transport, coach, courier or freight operation with somewhere between a handful and a few hundred trips a month; already keep trip records in a sheet or can export them from a booking system; want revenue, distance, driver and contract-tier analysis without paying per vehicle; or need something a dispatcher can open on a phone at a depot.
Not a good fit if you need live GPS tracking, geofencing or ELD compliance – those need telematics hardware this cannot replace. It is also the wrong tool if you are logging more than a few thousand trips a month (a database will serve you better), if you need automated invoicing rather than revenue reporting, or if your finance team requires an audited accounting ledger. Say so and we will point you at something closer.
How to Use the Transportation Services Dashboard in Google Sheets
- Open the PDF in your download and click the copy link. Google creates your own editable copy in your Drive.
- Open the Data sheet and read the 16 column headers. Keep them exactly as they are – the pivots, slicers and formulas all reference them by name.
- Replace the sample trips with your own, starting at row 2. Paste up to row 1001 and nothing needs adjusting.
- Update the list values that matter to you: depot names, service types, vehicle types, drivers, contract tiers, route zones and payment methods.Transportation Services Dashboard in Google Sheets
- Go back to Overview and click a slicer. Every chart, pivot and Top 5 panel on that page redraws. Use Select all to clear it.
- Recolour if you want to. Open the Apps Script file, edit the three palette hex codes, re-run main().
- Share the file with your dispatch and finance teams. Give viewers read access and editors edit access.Transportation Services Dashboard in Google Sheets
Real-World Use Cases
Marcus runs a 40-vehicle regional coach and shuttle operator. He exports last month’s jobs from his booking system into the Data sheet every Monday. The Fleet page tells him Luxury Coach revenue is running ahead of Semi-Trailer work, so he shifts two drivers onto charter hire. The unfiltered KPI strip lets him quote the month-to-date network total in the same glance.
Priya coordinates dispatch for a last-mile courier network across five zones. She lives on the Services page, filtering by Route Zone and Driver to see where distance is being burned without matching revenue. When a client queries a delivery, she switches to Search, types the Trip ID and reads the record back.
Elif handles billing for a corporate shuttle contractor. The Clients page is her whole month-end: trips by contract tier, revenue by payment method, and the account-billing share that tells her how much of the month is sitting on 30-day invoices rather than card payments.
Frequently Asked Questions
How do I get the file after buying?
Your download is a PDF containing the Google Sheets copy link. Click it, choose Make a copy, and the dashboard appears in your own Drive with every pivot, slicer and chart intact.Transportation Services Dashboard in Google Sheets
Do I need a paid Google Workspace account?
No. A free personal Google account opens and edits the file. Workspace only matters if your organisation already requires it.
Can I add more than 1,000 trips?
Yes. Everything is pre-wired to row 1001 out of the box. Beyond that, open the bundled Apps Script, raise the DATA_ROWS constant and re-run main() to extend the ranges.Transportation Services Dashboard in Google Sheets
Why do the KPI cards ignore my slicer?
That is deliberate. The cards and the AT A GLANCE list use SUMIFS and COUNTIFS on the Data sheet so they report the network total at all times. The charts, pivots and Top 5 panels are the slicer-aware parts.
Can I change the depots, service types and vehicle types?
Yes. They are ordinary values in the Data sheet columns. Edit them, refresh the pivots, and the slicer lists and charts pick up your own names.
Does this track vehicles by GPS?
No. It analyses the trip records you enter or import. For live location you need telematics hardware, which is a separate class of product.
Can I use it in Excel instead?
This build is written for Google Sheets pivot tables and slicers. If you want the same analysis in Excel, look at the Excel dashboards in the catalogue rather than converting this file.Transportation Services Dashboard in Google Sheets
About the Author
Built by PK – Microsoft Certified Professional with 15+ years of Excel, Google Sheets, and Power BI experience. Founder of NextGenTemplates, reaching 300K+ subscribers across YouTube channels. Every template is hand-built and tested before release.Transportation Services Dashboard in Google Sheets
Explore Related Templates
- Logistics Dashboard in Google Sheets – the warehouse-and-freight companion to this trip-level view.
- Shipping Dashboard in Google Sheets – carrier, lane and consignment analysis in the same pivot-and-slicer style.
- EV Fleet Dashboard in Google Sheets – charging, range and energy cost for an electric fleet.
- School Transportation Services Dashboard in Excel – the same problem for route-based school transport, on the Excel side.
- Browse the full Google Sheets Dashboard category or the wider Google Sheets collection.
Ready to see your trip log as a dashboard? Add the Transportation Services Dashboard in Google Sheets to your cart, open the PDF, click the copy link, and paste your own trips in. A full walkthrough is on the NeoTechNavigators blog, and more tutorials live at youtube.com/@PKAnExcelExpert.
Watch the step-by-step video Demo:
Last updated: 14 August 2026.
Reviews
There are no reviews yet.