Shared operations ledger

Trip Ticket Dashboard

Centralized trip encoding, payroll calculation, and export for a shared MySQL-backed register.

Operations tools

Export follows the current filters and sort order for the trip register.

Trip form

Update record

Move from trip reference to route, pay, and timing in one clean flow.

Editing

Identity

Ticket and trip reference

Start with the short trip reference, the assigned truck, and the trip type.

Assignment

Truck, driver, and destination

Choose the truck and crew first, then complete the route and load details.

Pay details

Driver and helper computation

Driver pay can auto-fill from the route. Helper base is only needed for long-distance trips.

Long distance helper

PHP 800.00

Excess weight

PHP 0.00

Excess weight follows the stored truck threshold formula.

Timing

Harvest and demurrage clock

Harvest date stays separate. Arrival and departure drive total hours and demurrage.

Live totals

Review before saving

Driver

PHP 950.00

Helper

PHP 800.00

Allowance

200 x 2

PHP 400.00

Grand total

PHP 2,150.00

Cancel

Driver salary

PHP 1,370,700.00

Total driver payout for the current filtered register.

Helper salary

PHP 1,498,202.04

Total helper payout for the current filtered register.

Total allowance

PHP 845,600.00

Combined allowance for the current search and filters.

Grand total

PHP 3,714,502.04

Allowance and salary totals combined for the current view.

Trip register

Encoded trips

1,895 results 7 rows per page Sort: Created date ยท DESC

Showing 344-350 of 1,895 results.

Date of Harvest Driver's Name Truck / Plate # Province / Municipality Kilos / Helpers Trip Ticket / Trip Driver Salary Helper Salary Allowance Total Amount Status Arrival / Departure / Total Hours / Demurrage Actions
Apr 4, 2026 CRISANTO TENEZA
Forward
CBS3827
Pangasinan
MANGALDAN
Kg10,089.28
Helpers3
262319
Local
PHP 800.00 PHP 1,009.00 PHP 600.00 PHP 2,409.00 Settled
ArrApr 5, 2026 11:40 PM
DepApr 6, 2026 10:04 AM
Hrs10H24M
DemPHP 0.00
Edit
Mar 31, 2026 CRISANTO TENEZA
Forward
CBS3827
La Union
BALAOAN
Kg11,939.02
Helpers2
261285
Long Distance
PHP 1,000.00 PHP 1,493.00 PHP 600.00 PHP 3,093.00 Settled
ArrApr 2, 2026 1:00 AM
DepApr 2, 2026 7:56 AM
Hrs6H56M
DemPHP 0.00
Edit
Mar 30, 2026 CRISANTO TENEZA
Forward
CBS3827
Pangasinan
MANAOAG
Kg10,472.60
Helpers2
262317
Local
PHP 800.00 PHP 1,047.00 PHP 450.00 PHP 2,297.00 Settled
ArrMar 31, 2026 10:09 PM
DepApr 1, 2026 2:43 AM
Hrs4H34M
DemPHP 0.00
Edit
Mar 30, 2026 JOKER BANDARLIPE
Elf
NBF4767
Ilocos Sur
ILOCOS SUR
Kg6,028.20
Helpers1
262054
Long Distance
PHP 950.00 PHP 802.00 PHP 400.00 PHP 2,152.00 Settled
ArrMar 30, 2026 11:00 AM
DepApr 1, 2026 12:14 PM
Hrs49H14M
DemPHP 1,000.00
Edit
Mar 28, 2026 JOKER BANDARLIPE
Elf
NBF4767
Ilocos Sur
ILOCOS SUR
Kg5,345.20
Helpers1
261888
Long Distance
PHP 950.00 PHP 800.00 PHP 400.00 PHP 2,150.00 Settled
ArrMar 30, 2026 8:21 AM
DepMar 30, 2026 1:50 PM
Hrs5H29M
DemPHP 0.00
Edit
Mar 26, 2026 JOKER BANDARLIPE
Elf
NBF4767
La Union
BANGAR
Kg5,143.50
Helpers2
261973
Long Distance
PHP 800.00 PHP 800.00 PHP 600.00 PHP 2,200.00 Settled
ArrMar 28, 2026 4:14 AM
DepMar 28, 2026 10:15 PM
Hrs18H1M
DemPHP 0.00
Edit
Mar 26, 2026 JOKER BANDARLIPE
Single Tire
NQC490
La Union
ROSARIO
Kg1,219.60
Helpers1
262000
Local
PHP 600.00 PHP 600.00 PHP 300.00 PHP 1,500.00 Settled
ArrMar 28, 2026 9:45 PM
DepMar 29, 2026 9:10 PM
Hrs23H25M
DemPHP 0.00
Edit