Turn a trip sheet into per-truck earnings
Freight, diesel and tolls rolled up truck by truck.
- ForFleet owners and transport offices that keep trips in Excel.
- HelperTrip Ledger
- ModeBerri Strawberry 1
- AttachExcel sheet
Copy the prompt
This trip sheet has truck number, route, freight, diesel, toll and other expenses. Give me the total trips, freight, costs and margin for each truck for [period], best first.
Change the words in [brackets] to your own.
What to attach
An Excel sheet (.xlsx). Berri reads the first sheet, so keep the data there.
Run it
Berri opens with the prompt filled in and the Trip Ledger helper picked. Nothing is sent until you press send.
Run this in BerriTips
- Add a column for loaded or empty on the return leg to see where money leaks.
- Ask for the same summary every fortnight with a reminder.
Turn a trip sheet into per-truck earningsTrip Ledger
XLStrips-nov.xlsx
This trip sheet has truck number, route, freight, diesel, toll and other expenses. Give me the total trips, freight, costs and margin for each truck for 1 to 15 Nov, best first.
Reading trips-nov.xlsx
Four trucks, 1 to 15 Nov:
| Truck | Trips | Freight | Margin |
|---|---|---|---|
| Truck 4 | 9 | Rs 3,96,000 | Rs 98,400 |
| Truck 1 | 8 | Rs 3,52,000 | Rs 81,700 |
| Truck 3 | 7 | Rs 3,15,000 | Rs 52,300 |
| Truck 2 | 5 | Rs 2,10,000 | Rs 18,900 |
Truck 2 ran empty on 3 return legs. That is most of its gap.
Figures here are made up to show the shape of the answer. Yours come from your own file and words.