Internal Module
Payroll Portal
Payroll entry, Pasahod encoding, saved records, and ledger reference. Approvals and payments are handled in the central portals.
Payroll Trip Encoder
Payroll Header
Basic cutoff and truck details.
Payroll Trip Encoder
Encode truck trips and let the rate matrix auto-fill salary and expected expenses. Weng can adjust actual expenses before submission.
| Select | Date | Source | Destination | Reference No. | PO Number | Shipment Number | Container Number | Trip Type | Diesel | Per Liter | Driver Salary | Helper Salary | Toll | Passway | Parking | Lagay Loaded | Lagay Empty | Mano | Timbang | Luna | Vulcanize | Allowance Driver | Allowance Helper | Hugas Truck | Checkpoint | Other Expenses | Row Total | Rate Match Status | Status | Source File | Issues | Remarks | Actions |
|---|
Pasahod Summary
Salary, allowance, deductions, and net pay for driver and helper.
Shared Payroll Totals
Budget, expenses, bali, and salary payable for this payroll.
Pasahod
Driver Payroll Summary
Earnings
Total Salary₱0.00
Total Allowance₱0.00
Gross Pay₱0.00
Deductions
Result
Suggested Balance Deduction₱0.00
Total Deductions₱0.00
Net Pay / Salary to Deposit₱0.00
Pasahod
Helper Payroll Summary
Earnings
Total Salary₱0.00
Total Allowance₱0.00
Gross Pay₱0.00
Deductions
Result
Suggested Balance Deduction₱0.00
Total Deductions₱0.00
Net Pay / Salary to Deposit₱0.00
Trip Earnings
Route / Trip Breakdown
Grouped by route and trip type from the current payroll trip lines.
Balance Tracking
Balance / Bali Summary
Previous balance and new cash advance this cutoff. Loaded from approved cash requests in Supabase.
Driver Balance
Previous Balance₱0.00
New Bali / Cash Advance This Cutoff₱0.00
Suggested Balance Deduction₱0.00
Balance After Payroll₱0.00
Helper Balance
Previous Balance₱0.00
New Bali / Cash Advance This Cutoff₱0.00
Suggested Balance Deduction₱0.00
Balance After Payroll₱0.00
Truck Monitoring data source not connected yet. Trip data will be pulled from Google Sheets once connected.
Approval / Payment
Mother reviews payroll first. Sister marks approved payrolls as paid after payment.
For Mother Approval
Submitted payrolls waiting for approval, return, or rejection.
| Payroll ID | Payroll Date | Plate Number | Driver | Helper | Group | Total Expenses | Driver Net Pay | Helper Net Pay | Total Bali | Total Budget Released | Total Payable | Status | Approval Status | Payment Status |
|---|
For Sister Payment
Approved payrolls that are still unpaid.
| Payroll ID | Payroll Date | Plate Number | Driver | Helper | Group | Driver Net Pay | Helper Net Pay | Total Bali | Total Budget Released | Total Payable | Payment Status | Payment Date | Payment Reference |
|---|
For Approval
Liquidations waiting for review.
| Payroll Number | Plate Number | Group | Driver | Payroll Date / Cutoff Period | Total Expenses | Status | Actions |
|---|
Dev / Testing: Run supabase/payroll-sample-data.sql in the Supabase SQL Editor to load sample records for testing. Sample data will appear here after clicking Refresh Records.
Saved Payroll Records
Records saved to Supabase (falls back to local browser storage if not yet connected).
| Payroll Date | Plate | Driver | Helper | Status | Approval Status | Payment Status | Total Expenses | Driver Net Pay | Helper Net Pay |
|---|