เทมเพลต Excel / Google Sheets

School Van Routes & Fare Collection

Students by route and pick-up point, pick-up order, distance-based monthly fares, paid/unpaid check, fuel and service log, profit per route
Routes tab: Route, driver, plate, rate per km
Riders tab: Name, grade, route, stop, distance, fare
Fare status tab: Monthly payment check ✔ = paid
Fuel & service tab: Fuel, repairs, odometer, cost by route
Dashboard with key numbers and charts that update automatically
Formulas, drop-downs and colour highlights are ready. Works in Excel and Google Sheets (copy link included)

฿99Lifetime

About this template

Students by route and pick-up point, pick-up order, distance-based monthly fares, paid/unpaid check, fuel and service log, profit per route

Screenshots from the real file

Who it is for

School van owners
Staff shuttles
Schools

What you get out of it

Collect every fare
Profit per route
Never miss vehicle service
One file for both Excel and Google Sheets

What is inside the file

How to useGetting-started steps, list of tabs and what the colors mean

DashboardKey numbers and charts that update as you enter data

RoutesRoute, driver, plate, rate per km

RidersName, grade, route, stop, distance, fare

Fare statusMonthly payment check ✔ = paid

Fuel & serviceFuel, repairs, odometer, cost by route

How to use it

Open "วิธีใช้" (How to use) to see the tabs and colour legend
In "Routes", clear the sample rows and enter: route, driver, plate, rate per km
In "Riders", clear the sample rows and enter: name, grade, route, stop, distance, fare
In "Fare status", clear the sample rows and enter: monthly payment check ✔ = paid
In "Fuel & service", clear the sample rows and enter: fuel, repairs, odometer, cost by route
Open "Dashboard" for the overview and charts, calculated instantly

What you receive

Excel file (.xlsx), 51 KB, ready to download right after payment
A Google Sheets link that makes your own copy in Google Drive, usable on mobile
Sample data on every tab so you can see how to fill it in, then replace it with yours
Built-in formulas, drop-downs and color alerts

Frequently asked questions

Which programs does this template work with?

It works in both Microsoft Excel and Google Sheets. You get the .xlsx file to download plus a link to copy it into your own Google Drive.

Who is School Van Routes & Fare Collection for?

School van owners; Staff shuttles; Schools

What's inside the file?

5 tabs: Dashboard, Routes, Riders, Fare status, Fuel & service, with all formulas built in.

Do I need to be good at Excel?

No. Just type into the marked cells; the file calculates and summarises everything, and includes a how-to sheet.

How do I get the file, and how much is it?

It costs ฿99. Once payment is confirmed, download the file and the Google Sheets link right away from your account page.

Product reviews

No reviews yet