Cash Application Coordinator

Summary

As a Cash Application Coordinator, you will play a key role in supporting the Accounts Receivable function within the Accounting Department. Reporting to the Cash Application Team Lead, you will be responsible for the timely and accurate posting, reconciliation, and deposit of incoming client payments. You will work with multiple systems and use your strong analytical and Excel skills to ensure accuracy, keen attention to detail to troubleshoot and resolve errors, while ensuring adherence to standard operating procedures and meeting team performance targets.

Key Responsibilities

Cash Application

• Perform timely and accurate application and posting of client payments (EFT, ACH, Wire, Cheque, EDI)

• Reconcile and deposit cheques in a timely manner

• Maintain control sheets and bank reports for all incoming payments

• Create Journal Entries to record transactions where necessary

• Investigate and resolve payment application discrepancies

• Escalate non-standard issues to the Team Lead or Accounts Receivable Manager

• Review unapplied payments and collaborate with Collections/Reconciliation teams to allocate funds correctly

Payment Reconciliation & Reporting

• Perform payment reconciliations using Excel (sorting, formatting, VLOOKUP, formulas, pivot tables, data import)

• Identify and investigate discrepancies, reporting findings to internal teams

• Maintain proper record keeping of remittance advices, reconciliation reports, and customer correspondence

• Generate cash and unapplied cash reports as required

Support & Administration

• Perform special projects and administrative tasks as assigned

• Provide backup and support to team members during peak periods or absences

• General filing and correspondence as required

Qualifications

• 2 –5 years of experience in cash application or accounts receivable
• High school diploma or associate degree in accounting (minimum)
• Very good knowledge of Microsoft Excel, including advanced functions (VLOOKUP, Pivot tables, large data handling)
• Strong attention to detail
• Proven ability to analyze data, reconcile balances, and resolve errors
• Knowledge of vendor management systems (external vendor portals) an asset
• Experience with ERP systems and Accounting Software, NetSuite experience an asset
• Excellent communication skills, both verbal and written
• Quick learner and team player with the ability to work independently as needed

Qualifications

Experience in cash application or accounts receivable : 2 - 5 years (Required)

Very good knowledge of Microsoft Excel: 2 - 5 years (Required)

Experience with ERP systems and Accounting Software, NetSuite experience an asset: 1 - 5 years (Desired)