Before this system, businesses spent hours manually making paychecks from spreadsheets. Every week, administrators had to pull the loads for each driver, calculate miles or load amounts, remember every deduction, format a payslip, and export a PDF. A single missed deduction usually resulted in a costly dispute.
Now, the entire workflow is fully automated and scheduled. I built Fleet, a trucking operations dashboard, with a Python FastAPI backend engine that handles the heavy computational lifting and scheduling of payroll creation entirely in the background.
How It Works
Once a driver’s pay rate and deductions are set, the FastAPI background scheduler takes over at the end of the designated pay cycle. Without requiring a human to click a single button, the system:
- Pulls load data: Automatically aggregates every load completed by the driver during the scheduled period.
- Calculates gross pay: Computes totals based on individual per-mile or per-load rates.
- Applies rules-based deductions: Automatically subtracts fixed costs (insurance, ELD, company charges) based on pre-set driver rules.
- Generates the final PDF: Saves the finalized paycheck and compiles a clean, dispute-free PDF document ready for distribution or review.
In a recent automated run, an owner-operator’s week totaling $5,588.00 gross was processed with three deductions applied automatically, resulting in a $4,955.96 net pay. There was no manual triggering, no calculator required, and no spreadsheet formulas to maintain.
Business Impact
- Time Savings: Reduces hours of manual payroll processing to a zero-touch, scheduled background task. What used to take a 10-truck fleet 5–7 hours of weekly administrative work now happens automatically behind the scenes.
- Accuracy: Deductions are applied by systemic rules on a strict schedule, eliminating human memory from the equation and drastically reducing driver disputes.
- Record Keeping: Every system-generated paycheck is securely stored, fully searchable, and easily accessible for audits.
- Data Privacy: Role-based access control ensures only Admin, Manager, and Finance roles can view sensitive pay data. Standard employees are strictly blocked from accessing the payroll records.
Tech Stack
- Backend / Automation Engine: Python (FastAPI, Background Tasks/Scheduler)
- Database: MySQL
- Frontend: Vue.js
- Styling: Tailwind CSS