Truckers Report Jobs

Find Trucking Jobs

Company Driver Company Driver Dry Van Dry Van Flatbed Flatbed Refrigerated Refrigerated Specialized Specialized Owner Operator Owner Operator
More Trucking Job Searches ⌄ Fewer Trucking Job Searches
⌃

Is Payroll Difficult?

Discussion in 'Ask An Owner Operator' started by OTR King, Jun 15, 2021.

  1. Jun 15, 2021 #1
    OTR King

    OTR King Bobtail Member

    1
    0
    Jun 15, 2021
    0
    Hey everyone, I'm not sure if this is the right place for this question so forgive me of this is the wrong audience.

    I've been working with a FedEx contractor recently as a tech guy and one of our biggest problems is processing the weekly settlement in a way that is timely and accurate. Our goal is to get mileage totals for each driver separated by truck and route. The settlement that gets released each week has this information but it's not necessarily in a format that's easy to process programmatically (ex. Truck numbers are not in the same row as the driver IDs). I attempted to create an Excel Macro that grabs the totals but that was a nightmare. Eventually I had to create an entirely new program in an actual programming language to get the right output.

    Has anyone else encountered the same type of issues? Do you manually count miles for payroll? Do you track total miles per truck or driver? Overall I'm interested in any sort of thoughts you have on the topic of payroll or your company's method for processing the weekly settlement.

    If you have a technical need in this area I'd like to hear about it too. The program I made is pretty fast and flexible and I'd love to chat about features that would help you out. Thanks!
     
    OTR King, Jun 15, 2021
    OTR King, Jun 15, 2021
    #1
  2. Truckers Report Jobs

    Trucking Jobs in 30 seconds

    Every month 400 people find a job with the help of TruckersReport.

  3. Jun 15, 2021 #2
    Judge

    Judge Road Train Member

    11,173
    71,440
    Mar 19, 2014
    Arkansas
    0
    Judge, Jun 15, 2021
    Judge, Jun 15, 2021
    #2
    OTR King Thanks this.
  4. Jun 17, 2021 #3
    Six9GS

    Six9GS Road Train Member

    1,473
    3,693
    Dec 3, 2012
    Yuma, AZ
    0
    I don't know what programming language you used. But, I used to fairly proficient in MSSQL and this problem sounds like something that could have been done with it. Unsure what database program the other information is in, but if you were able to access it with Excel, you could access it with MSSQL.
    Since I'm only a driver these days, I don't have any dealings with pay issues except for getting it!!!
    Good Luck to you!
    PS. I was a cartographer and dealt with geographic data, mostly water resource related. We had over 100 years of groundwater observation data and used MSSQL to set up a database structure that stored it and made it usable with different numeric groundwater models and cartographic programs. It was fun work, but most of the heavy lifting was done by ESRI for their ArcGIS program. They had alot of specialized MSSQL structures, scripts, programs and templates that could be easily used and adapted to specific needs for varying geographic and water resource purposes. Allowed me to do alot of stuff without having to be a master SQL programmer and reinvent the wheel from scratch. Sorry to ramble, I worked with this stuff for over 20 years and kinda proud of what I was able to do and accomplish.
     
    Six9GS, Jun 17, 2021
    Six9GS, Jun 17, 2021
    #3
  5. Jun 17, 2021 #4
    Midwest Trucker

    Midwest Trucker Road Train Member

    5,771
    20,598
    Aug 31, 2018
    0
    Your ELD can give you data input. Also, it seems archaic but we still use time cards. The driver puts their hrs, odometer start and end, and total miles for that day figured.
    So, as long as you pay hub miles then that’s an affective cross reference that’s accurate.
     
    Midwest Trucker, Jun 17, 2021
    Midwest Trucker, Jun 17, 2021
    #4
  7. Jun 17, 2021 #5
    Dave_in_AZ

    Dave_in_AZ Road Train Member

    49,823
    315,709
    May 4, 2015
    0
    Pay by the trip. Problem solved.
     
    Dave_in_AZ, Jun 17, 2021
    Dave_in_AZ, Jun 17, 2021
    #5
  8. Jun 18, 2021 #6
    Ridgeline

    Ridgeline Road Train Member

    20,732
    101,022
    Dec 18, 2011
    Michigan
    0
    I didn’t reinvent the wheel, I took the data from the log scanning software and the drivers work sheets and created a little application to take that data and convert it to the data flat file that is imported to quick books (we are using an older version that doesn’t need cloud computing crap) and that gets processed, exported and sent off to the payroll company. Now two changes, the interface to the eld and other data sources have changed how we handle the data, only have three trucks on paper logs. This made me decide to bring payroll in-house because of the changes,
     
    Ridgeline, Jun 18, 2021
    Ridgeline, Jun 18, 2021
    #6
  • Truckers Report Jobs

    Trucking Jobs in 30 seconds

    Every month 400 people find a job with the help of TruckersReport.