Is Payroll Difficult?

Discussion in 'Ask An Owner Operator' started by OTR King, 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!
     
  2. Truckers Report Jobs

    Trucking Jobs in 30 seconds

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

  3. Judge

    Judge Road Train Member

    4,603
    25,185
    Mar 19, 2014
    Newport, Ar
    0
    OTR King Thanks this.
  4. Six9GS

    Six9GS Heavy Load Member

    755
    1,533
    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.
     
  5. Midwest Trucker

    Midwest Trucker Road Train Member

    3,889
    10,723
    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.
     
  6. Dave_in_AZ

    Dave_in_AZ Road Train Member

    30,090
    124,334
    May 4, 2015
    0
    Pay by the trip. Problem solved.
     
  7. Ridgeline

    Ridgeline Road Train Member

    17,338
    73,090
    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,
     
  • Truckers Report Jobs

    Trucking Jobs in 30 seconds

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

  • Draft saved Draft deleted