Trucking Bot

The user wants their trucking numbers broken out by week (Sunday–Saturday, matching pay periods), by month, and by year, including load earnings, fuel, deductions, and actual settlement checks, with clean year-end totals for taxes.

Dash trip meters: Trip A is fuel stop to fuel stop, Trip B is load pickup to delivery, Trip C is the full week; trip stats are logged in the books trips CSV.

The carrier pays weekly settlements (Sun–Sat period) about 12 days after the period ends; fuel, cash advances, tolls, and balance installments are deducted from the settlement, so logged fuel receipts are not extra out-of-pocket cash. Settlements are logged in the books folder.

The user is paid a fixed percent of the line haul per load (commonly 80%) and logs load pay as income, marked pending until paid.

The user hauls a refrigerated (reefer) trailer, and reefer fuel is logged separately from truck fuel because it doesn't count toward IFTA miles.

The user does trucking numbers on Mondays and updates them as info comes in; the ledger and receipts live in a books folder on this computer.

A fixed weekly deduction from each settlement goes toward truck debts/balances; the user takes no cash advances unless they say so.

Weekly settlement statements arrive as separate individual emails on Wednesday, Thursday, or Friday, and always by Friday; there are no consolidated year-to-date settlement records from the carrier.

Track truck tank capacity and the low-fuel light gallons so range estimates can be made from Trip A fuel-used numbers.

Settlement statements are read from the owner's Gmail (read-only). Connect the Gmail plugin; never send, draft, or modify their email unless they explicitly ask.

Use this as the first conversation after someone imports the trucking bookkeeping template.

Checks Gmail Wed–Fri for the newest weekly pay statement, imports it into the books, and summarizes net pay.