Key takeaways
- Set one fare per route and one boundary rate per driver.
- One trip row gives gross fare, costs, share, and net remittance.
- Only Completed trips feed remittances and vehicle income.
- Read VEHICLE REPORT before deciding which unit to keep.
A van on a fixed route earns in small, fast pieces. Sixteen passengers at a set fare, minus a tank of diesel, minus the toll, minus whatever the driver keeps, and the operator finds out at the end of the week whether any of it was worth the day. BiyaheDesk PH puts the whole computation on the trip row, so gross fare, trip costs, driver share, and net remittance are known before the driver leaves the terminal.
Price the route, not the trip
A route carries an origin, destination, distance, and one fare per passenger. Every trip on that route pulls the fare automatically, so a fare change is edited in one place instead of being renegotiated per run.
Vehicles carry a body type, plate number, and seat count, which keeps the passenger figure honest when a trip is reviewed later.
Let the trip row do the arithmetic
A trip records the vehicle, route, driver, passengers carried, fuel cost, and toll and parking. Gross fare is passengers times fare, trip costs are fuel plus toll, and the driver share is a percentage of gross taken from the driver's own boundary rate.
Net remittance is what is left, and it is the number the driver hands over. Nobody has to argue about it at the terminal because both sides can read the same row.
Count only the runs that happened
Status runs from Scheduled to Completed or Cancelled. Only Completed trips feed the driver and vehicle reports, so a run that was pulled at the terminal never becomes a phantom collection.
DRIVER REPORT totals trips, gross fare, driver share, net to remit, amounts remitted, and the balance still in hand, which is the settlement sheet at the end of the day.
Find out which unit actually earns
VEHICLE REPORT totals passengers, gross fare, trip costs, driver shares, and maintenance per vehicle, then subtracts to a net income. A busy unit with heavy repairs stops looking busy once that column is filled in.
A pass through CHECKS before settlement catches trips pointing at unknown vehicles or drivers and drivers who remitted more than they collected.
Review exceptions every week
Resolve duplicate IDs, missing links, overdue balances, negative amounts, and open operational items in CHECKS before using the dashboard for decisions.
BiyaheDesk PH Google Sheets Edition is designed for use with a Google account and current desktop Google Sheets.
No LTFRB or LTO franchise and registration compliance, GPS or telematics tracking, fare matrix approval, ticketing hardware, statutory payroll or contribution computation, official receipts, or tax filing.
Frequently asked questions
What if the driver is on a fixed boundary instead of a percentage?
Enter a rate that produces your usual amount, or record the fixed figure in the notes and adjust the rate per driver. The share column always follows the rate on the driver record.
Can one vehicle run different routes in a day?
Yes. Each trip picks its own route, so a van can do Toledo in the morning and Danao in the afternoon with the correct fare on each row.
Does it watch the vehicle on a map?
No. It is a records system for trips and money; live tracking and franchise paperwork stay outside it.
Does this replace official records?
No. No LTFRB or LTO franchise and registration compliance, GPS or telematics tracking, fare matrix approval, ticketing hardware, statutory payroll or contribution computation, official receipts, or tax filing.
