Skip to content
Berri
Sign in Try Berri
Sign inTry Berri

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 Berri

Tips

  • 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.
What Berri sends back
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:

TruckTripsFreightMargin
Truck 49Rs 3,96,000Rs 98,400
Truck 18Rs 3,52,000Rs 81,700
Truck 37Rs 3,15,000Rs 52,300
Truck 25Rs 2,10,000Rs 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.

Your own job, in your own words.

Try Berri