Logistics Billing & Payroll Coordinator (Colombia)

This is a remote position.

Logistics Billing & Payroll Coordinator

Type: Full-Time
Salary: $1,400 USD
English Proficiency Required: C1/C2 

The company is a transportation and logistics company headquartered in Columbus, Ohio. Its operations involve coordinating shipments, supporting drivers and owner-operators, and maintaining accurate delivery, billing, and payment records across multiple customer accounts.

About the Role

We are looking for an organized, analytical Logistics Billing & Payroll Coordinator to support driver pay verification, shipment billing accuracy, and transportation record management.

You will work primarily in Google Sheets, customer portals, and the company’s in-house transportation management system (TMS). Your responsibilities will include checking shipment rates, calculating driver pay according to established pay sheets, identifying discrepancies, and keeping supporting documentation complete and organized.

This role is ideal for someone who enjoys working with numbers, investigating inconsistencies, and managing detailed administrative processes. Previous logistics or accounting experience is helpful, but candidates with customer service or administrative experience and strong spreadsheet skills are encouraged to apply.

Key Responsibilities

Driver Pay Verification

• Review driver and owner-operator activity using reports exported from the company’s TMS.
  

• Verify that completed routes and deliveries are recorded accurately.
  

• Calculate and allocate driver pay using established pay sheets and market-specific payment rules.
  

• Check applicable mileage, zone, stop, extra-delivery, white-glove, and assembly payments.
  

• Enter or update driver pay information in the system and prepare accurate records for payment scheduling.
  

• Investigate missing or inconsistent information and coordinate corrections with the operations team.
  

• Maintain daily updates to support timely and accurate settlement cycles.
  

Shipment Billing and Rate Reconciliation

• Review shipment records and customer portals to verify amounts against agreed quotes, rate tables, and tariff sheets.
  

• Use shipment details, ZIP codes, mileage, and service zones to determine the applicable rates.
  

• Compare expected amounts with recorded charges and flag underbilling, missing charges, or other discrepancies.
  

• Update shipment and billing information in company systems.
  

• Coordinate with Jose and the operations team to resolve exceptions and maintain consistent records.
  

Google Sheets and Data Management

• Build and maintain organized spreadsheets using company-provided data and templates.
  

• Use formulas, sorting, filtering, and lookups to calculate amounts and reconcile records.
  

• Organize data by customer, shipment, driver, market, or payment status as needed.
  

• Prepare summaries that make completed work, outstanding items, and discrepancies easy to review.
  

• Improve spreadsheet organization and repeatable processes while checking the accuracy of results.
  

Shipment Documentation

• Verify delivery completion using shipment reference numbers, including PRO numbers.
  

• Upload or attach proof of delivery and other supporting documents to the correct shipment records.
  

• Maintain complete records in the company’s back office and customer portals.
  

• Follow up on missing documentation and track unresolved items through completion.
  

Requirements and Qualifications

• Previous experience in customer service, administrative support, billing support, data entry, or a related role.
  

• Working proficiency in Google Sheets, including formulas, sorting, filtering, and organizing data.
  

• Strong numerical accuracy and attention to detail.
  

• Ability to compare information across spreadsheets, portals, and internal systems and identify inconsistencies.
  

• Strong organizational skills and consistent follow-through on deadlines and outstanding items.
  

• Clear written and spoken English for communicating with a U.S.-based team.
  

• Ability to learn new systems and apply detailed rate and payment instructions accurately.
  

• Good judgment when handling confidential financial and driver information.
  

Preferred Qualifications

• Experience with logistics, transportation billing, driver settlements, or payroll support.
  

• Familiarity with TMS platforms, customer shipping portals, rate tables, or proof-of-delivery documentation.
  

• Experience using lookup functions, conditional formulas, or pivot tables.
  

• Familiarity with AI tools that help organize data or improve spreadsheet workflows, with the ability to independently verify their output.