Freight Accounts Payable/Excel Specialist

POSITION SUMMARY 

*Excel - vlookups and pivot tables (required).

The A/P Specialist performs a variety of accounting clerical tasks related to the maintenance/processing of 

Freight Carrier and Agent records/ invoices for Company’s various clients and vendors.

ESSENTIAL DUTIES AND RESPONSIBILITIES

The essential functions include, but are not limited to the following:

• Data -entering invoices for payment

• Making sure all vendors insurance is up to date

• Working with Ops to resolve discrepancies on invoices

• Processing backup reports after data entry

• Managing weekly checks and recording all checks into computerized software programs

• Preparing vendor checks for mailing and listing all vendor checks in a log tracking book

• Maintaining inventory files and financial documents using an organized filing system as instructed 

electronically or non-electronically

• Entering Carrier and Agent profiles as well as updating Agent Tariffs.

• Updating weekly Fuel Surcharge for the vendors

• Requesting Bi-Monthly Statements from Vendors to compare with Aging – able to do SOA reconciliation.

• Upholding professionalism by providing courteous customer service to visitors, clients, and vendors

• Performing other duties as assigned

MINIMUM QUALIFICATIONS (KNOWLEDGE, SKILLS, AND ABILITIES)

• High school diploma or G.E.D. equivalent required

• Two or more years Accounts Payable (A/P) and/or payroll experience required

• Equivalent combination of education and/or experience will be considered

• General understanding of accounting practices and principles

• Experience with automated accounting programs and systems

• Working knowledge of the Microsoft Office (e.g., Word, Excel, Outlook) – able to do vlookups and pivot tables (required).

• Excellent computer skills using 10-Key by touch and ability to type 40 WPM

• Must possess proficient ability to communicate in English in oral and written format

• Ability to apply discretion and trust with confidential material

• Ability to maintain a high level of accuracy in preparing and entering financial data

• Ability to effectively apply analytical and problem-solving skills

• Excellent time managing skills with the ability to multi-task, prioritize, and meet deadlines

PHYSICAL DEMANDS AND WORK ENVIRONMENT 

The physical demands described here are representative of those that must be met by an employee to 

successfully perform the essential functions of this position. Reasonable accommodations may be made 

to enable individuals with disabilities to perform the functions. While performing the duties of this 

position, the employee is regularly required to talk or hear. The employee frequently is required to use 

hands or fingers, handle or feel objects, tools, or controls. The employee is occasionally required to 

stand; walk; sit; and reach with hands and arms. The employee must occasionally lift and/or move up to 

25 pounds. Specific vision abilities required by this position include close vision, distance vision, and the 

ability to adjust focus. The noise level in the work environment