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