Key takeaways
- Quarry cost follows the source, not a guess.
- Fuel is tied to the trip that burned it.
- Delivery progress is measured per order.
- Each truck has its own net contribution.
Hauling looks like a volume business and behaves like a margin business. The price per cubic metre is set by the market, the quarry price is set by somebody else, and the only things a hauler controls are how many cubic metres each trip actually carries and how much fuel and repair each truck consumes. GravelDesk PH records the trip as the unit of both.
The trip is the unit
Each trip records the order, the truck, the quarry, the cubic hauled and the delivery receipt number. Quarry cost follows the source's own price per cubic.
Trip revenue is the cubic hauled at the order's agreed price, so a part load is valued for what it carried rather than what was ordered.
Fuel belongs to a trip
Fuel is logged per truck and per trip. That makes trip cost the quarry price plus the diesel plus the tolls and fees actually paid.
Haulers who record fuel only as a weekly total can never tell a long haul from a short one, which is exactly the comparison that decides which jobs to take.
Orders finish, or they do not
Delivered cubic adds every trip against the order, and the status reads Not started, Partial or Complete.
A forty-eight cubic order delivered in four twelve-cubic trips is visible as it progresses, which matters when a site calls asking where the rest of the base course is.
Trucks earn or they do not
Each truck's performance row gathers its trips, cubic, revenue, fuel and maintenance into a net contribution, labelled Earning, Losing or No trips.
A truck with a turbo replacement and eighteen days of downtime is easy to forgive in conversation and hard to forgive in a column.
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.
GravelDesk PH Private Google Sheets Web App is designed for use with a Google account, Google Sheets, and Apps Script, using owner-only deployment by default.
No MGB or DENR permit filing, no weighbridge or truck scale integration, no GPS tracking, no LTO registration renewal, and no computation of the excise or sand and gravel tax owed to a province.
Frequently asked questions
Can one order use several trucks?
Yes. Every trip names its own truck, and the order's delivered cubic adds them all up.
How do I handle a different quarry price?
Set the cost per cubic on the quarry. A trip sourced there costs at that rate, so switching sources reprices the trip.
Does it compute the sand and gravel tax?
No. It records your own quarry costs, permits and delivery receipts. Provincial tax computation stays outside.
Does this replace official records?
No. No MGB or DENR permit filing, no weighbridge or truck scale integration, no GPS tracking, no LTO registration renewal, and no computation of the excise or sand and gravel tax owed to a province.
