Logistics Operations & Workforce Tracking System for a US-Based Logistics Startup

Business context

A logistics startup had no formal operational backend: payroll, dispatch tracking, invoicing, financial reporting and employee management had no supporting systems, and there was no structured way to track drivers, dispatchers, vendors and their documents.

Scope of work

• Payroll tracking and per-load payroll processing for more than 30 personnel — drivers, operators, vendors and dispatchers
• Dispatch tracking, invoicing, financial reporting and employee management
• Load administration, rate-confirmation and bill-of-lading organization
• Billing workflows: invoice generation, dispute resolution, expense tracking and overdue receivables follow-up
• Driver assistance and dispatch coordination
• Standard operating procedures and onboarding materials

Approach

The project team connected the tracking and payroll workflows using advanced Google Sheets logic for payroll calculations; built a custom AppSheet application for employee profiles, documents, absences, PTO, income and expenses, with a live map view; ran load administration through Alvys, SuperDispatch and Central Dispatch and billing through RTS Pro; and set up SOPs and onboarding materials in Google Classroom. Structured tracking and accountability supported document compliance and Hours of Service adherence.

Deliverables

• Per-load payroll records and calculations
• Custom AppSheet workforce and document tracking application
• Organized load records, rate confirmations and bills of lading
• Invoices, dispute resolution and receivables follow-up
• SOPs and onboarding materials in Google Classroom

Tools and systems

• Google Sheets
• AppSheet
• Google Classroom
• Alvys
• SuperDispatch
• Central Dispatch
• RTS Pro