Driver pay formula

To Create a driver Pay Formula

Edit the driver and open the "More information" menu.
To add this formula please select driver pay Custom and create the formula

R - revenue

"REVENUE" minus "Broker Fee" and multiplied by 27%

It will look like that:

(R - ({10})) * 0.27

1. Deducting Expenses:

To deduct expenses added to the Trip Planner, you need to include the expense codes in the formula based on what you want to deduct.

Your formula will look like this:
(R - ({10,14,27,30})) * 0.27

This setup calculates the driver’s pay after deducting these specific categories of expenses. At the bottom of this email, you can find a full list of expense categories with their respective codes for reference.

2. Adding Bonuses or Reimbursements:

To include bonuses or reimbursements in the driver’s pay while still deducting expenses, simply add + [34] (Driver Adjustment) to your existing formula.

Updated Formula Example:

Using the same example above, the updated formula would be:
(R*.27 - ({10,14,27,30}) + ({34}))
 

This adjustment allows both deductions and additional bonuses or reimbursements to be calculated automatically.

Expense Categories:

1    Fuel

2    Meals

3    Repairs

4    Tolls/Parking

5    Other

6    Scales

7    Storage/Gate

8    Damages

9    Violations

10    Broker Fee

11    Driver Pay

12    Towing

13    Maintenance

14    Supplies

15    Accounting 

16    Communication 

17    Fees 

18    Interest 

19    Office 

20    Physicals 

21    Rent/Lease 

22    Tax/License 

23    Truck/Trailer Payment 

24    IFTA 

25    Small Tools and Equipment 

26    Parts 

27    Tires 

28    Business Insurance 

29    Utilities 

30    Insurance 

31    Lodging 

32    Factoring/COD Fee
34    Driver Adjustment