Automating weekly driver settlement statements and PDF generation for Imona Logistics and Avesto LLC, saving 14 hours/week.
How a custom Google Apps Script automation in Google Sheets helps two sibling freight companies—Imona Logistics and Avesto LLC—generate weekly driver settlement statements, calculate deductions, and attach receipt PDFs across 30+ drivers.
01: The Clients
Imona Logistics & Avesto LLC
Imona Logistics and Avesto LLC are two U.S.-based freight and trucking operations founded by brothers. Each company operates an active fleet of 15 professional drivers (30+ drivers combined) handling interstate freight movement.
At the end of each weekly pay period, dispatch management compiles itemized settlement statements for every driver detailing completed loads, gross revenue, fuel deductions, maintenance expenses, and expense receipts.
Following the successful deployment of the settlement automation at Imona Logistics, the identical system was configured and deployed for Avesto LLC, doubling the total operational time saved across the two businesses.
02: The Challenge
Manual settlement calculations across two trucking fleets.
Every week, management had to manually compile individual PDF settlement statements for all 30+ drivers across both companies. Each statement required filtering trip rows, calculating deductions, attaching receipt images, and exporting individual documents.
Operational Bottlenecks
03: The Solution
Automated statement generation across both fleets.
Flowbetta built a custom Google Apps Script automation integrated directly into the Google Sheets workflows of both Imona Logistics and Avesto LLC, eliminating manual copy-pasting and formatting steps.
Standardized Template
A structured statement layout built into Google Sheets, organized with clear trip breakdowns, earnings totals, and expense summaries.
Driver & Period Dropdowns
Select driver name and week range from dropdown menus to target specific driver records instantly.
Automated Data Pull
The script automatically queries completed trips from the master sheet, computes net pay, and populates the settlement sheet.
Receipt Embedding
Enables inserting receipt images directly alongside corresponding fuel or maintenance expense entries.
Direct PDF Generation
Generates formatted PDF settlement files and automatically saves them into organized Google Drive folders.
Centralized Hyperlinks
Generated PDF drive links are recorded in the master sheet for convenient reference and record-keeping.
04: The Results
14 hours saved weekly across two trucking companies.
Saved Weekly
7 hours/week saved at Imona Logistics + 7 hours/week saved at Avesto LLC (14h combined).
Drivers Covered
15 drivers at Imona Logistics and 15 drivers at Avesto LLC receiving weekly itemized statements.
Manual Recalculations
Automated calculations prevent rate and deduction discrepancies across both fleets.
Unified System
Identical Google Workspace workflow deployed across both sister trucking operations.
After Imona Logistics eliminated 7 hours of weekly manual statement work for its 15 drivers, the CEO recommended the identical solution to his brother's company, Avesto LLC. Avesto operates an equivalent fleet of 15 drivers, doubling the combined time savings to 14 hours per week (approx. 60 hours/month) across both operations.
Joseph Asinyo truly sets the bar high in data processing! His work was not only PROFESSIONAL and detailed, but he also exceeded every expectation. Working with him was a breeze due to his courtesy and cooperation, making every interaction pleasant and productive.