# 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.

- **30+** Total Drivers  
- **2** Sister Fleets  
- **Weekly** Pay Cycle  
- **U.S.** Interstate

## 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.

1. **Filtering trip records per driver**  Manually isolating individual driver trips from the master dispatch spreadsheet for each fleet.
2. **Calculating gross earnings & deductions**  Summing mileage, gross load rates, fuel deductions, and net payouts for 30+ drivers.
3. **Locating expense receipts**  Matching fuel and maintenance receipt photos to corresponding deduction lines.
4. **Document formatting & layout**  Arranging tables, driver metadata, and receipt attachments into document templates.
5. **Manual export & distribution**  Saving PDFs individually and emailing them to each respective driver.

### Operational Bottlenecks

- **14 Hours Every Week Combined**  7 hours/week at Imona and 7 hours/week at Avesto dedicated strictly to settlement files.
- **Data Entry Overhead**  Copy-pasting trip rows between tabs increased the chance of calculation errors.
- **Fleet Expansion Load**  Managing 30+ drivers across two companies created a recurring administrative bottleneck.
- **Administrative Strain**  Leadership spent considerable time on routine file assembly instead of dispatch coordination.

## 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.

**Tech Stack**
- Google Apps Script  
- Google Sheets  
- Google Drive API

## The Results

### 14 hours saved weekly across two trucking companies.

- **14h** Saved Weekly  
  7 hours/week saved at Imona Logistics + 7 hours/week saved at Avesto LLC (14h combined).
- **30+** Drivers Covered  
  15 drivers at Imona Logistics and 15 drivers at Avesto LLC receiving weekly itemized statements.
- **0** Manual Recalculations  
  Automated calculations prevent rate and deduction discrepancies across both fleets.
- **2 Fleets** Unified System  
  Identical Google Workspace workflow deployed across both sister trucking operations.

### Sibling Fleet Deployment

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.

**Umar Rabbimov**  
CEO, Imona Logistics

## Streamlining routine reporting in Google Workspace

We build custom Apps Script automations that eliminate repetitive data compilation and manual PDF generation.

[Work With Flowbetta →](/#contact)