Job Title: Contract Accounts Receivable Clerk (Advanced Excel Focus)
Position Type: Contract
Industry: Enterprise / Large-Scale Corporate Environment
Work Environment: High-volume, fast-paced, multi-entity organization

Position Overview

We are seeking a detail-oriented and highly analytical Contract Accounts Receivable Clerk to support financial operations within a large, multi-billion dollar enterprise. This role requires advanced Microsoft Excel expertise and the ability to manage high-volume transactional data across multiple business units. The ideal candidate will play a critical role in maintaining accurate financial records, supporting cash flow operations, and ensuring timely collections while partnering with internal stakeholders and external clients.

Key Responsibilities

• Process and reconcile high-volume accounts receivable transactions across multiple divisions and customer portfolios.

• Utilize advanced Excel functions to analyze payment trends, identify discrepancies, and maintain accurate financial reporting.

• Perform daily, weekly, and monthly cash application activities, including matching payments to invoices across various platforms.

• Maintain large data sets using pivot tables, VLOOKUP/XLOOKUP, SUMIFS, index matching, and advanced formula creation.

• Investigate and resolve billing discrepancies, short payments, unapplied cash, and customer disputes in a timely manner.

• Generate and maintain aging reports and assist with collection efforts to reduce outstanding balances and improve cash flow.

• Collaborate with billing, sales, customer service, and finance teams to ensure accurate invoice processing and customer account management.

• Assist with month-end close procedures including account reconciliations, reporting, and audit preparation.

• Support process improvement initiatives by identifying automation opportunities and improving reporting efficiencies.

• Maintain compliance with internal controls, corporate policies, and financial reporting standards.

Required Qualifications

• 2+ years of Accounts Receivable or related accounting experience in a high-volume corporate environment.

• Advanced Microsoft Excel skills (pivot tables, complex formulas, data validation, large dataset manipulation, and reporting automation).

• Strong understanding of AR processes including cash application, collections, reconciliations, and dispute resolution.

• Experience working with ERP systems such as SAP, Oracle, NetSuite, or similar enterprise accounting software.

• Exceptional attention to detail with strong analytical and problem-solving skills.

• Ability to manage multiple priorities and meet strict deadlines in a fast-paced environment.

• Strong written and verbal communication skills with the ability to interact with internal teams and external clients.

Preferred Qualifications

• Experience working in large, multi-entity or Fortune 500-style organizations.

• Exposure to shared services or centralized accounting environments.

• Intermediate to advanced experience with financial reporting tools or data visualization platforms.

• Associate’s or Bachelor’s degree in Accounting, Finance, Business Administration, or related field.

Key Competencies

• Data analysis and financial reporting

• Process efficiency and continuous improvement mindset

• Organizational and time management skills

• Strong customer service and relationship management

• High level of confidentiality and professionalism

Ascendo is a certified minority owned staffing firm, and we welcome and celebrate diversity. Ascendo is an Equal Opportunity Employer and does not discriminate on the basis of race, color, religion, sex (including pregnancy and gender identity), national origin, political affiliation, sexual orientation, marital status, disability, genetic information, age, parental status, military service or any other characteristic protected by federal, state or local law.

Contact information

Amber Kemp