Job Details

Title: Cash Application Specialist - Excel Test
Contract: 1-2 Months and Possibility of Extension
Location: Mason OH - onsite 3 days per week, usually Tuesday, Wednesday, and Thursday

Note:
MUST HAVE EXCEL SKILLS - MUST KNOW PIVOT TABELS AND V-LOOKUP
BEFORE THE INTERVIEW IS SCHEDULED / EXCEL TEST MUST BE GIVEN

MAJOR DUTIES AND RESPONSIBILITIES
• Daily processing of cash receipts and postings to customer accounts, including charging payments made by credit card, other adjustments to customer accounts for credits/debits and account write-offs
• Identify daily unapplied amounts, post to customer accounts, call on back-up and provide A.R
• Maintenance of records for auditing purposes (filing remittances, bank statements, approved write offs )
• Maintenance of records for auditing purposes (filing remittances, bank statements, approved write offs )
• Receiving and recording of US trade, export and intercompany payments received from lockbox, EFTs, wire transfers, credit cards
• Support center management and the A/R Manager with respect to any relevant

Reason for request: Client Finance Ops Cash Applied team has lost two employees and are utilizing a temp to assist team with staying within their turnaround time.