Reporting Analyst

Reporting Analyst

Avid makes technology and collaborative tools so creators can entertain, inform, educate and enlighten the world. Our customers are the visionaries behind the most inspiring feature films, television programs, news broadcasts, televised sporting events, music recording and live concerts.

POSITION SUMMARY

We are seeking a versatile and detail-oriented Reporting Analyst to join our finance team. In this role, you will be responsible for preparing and analyzing accounts receivable and other reports, supporting daily operations, and ensuring accuracy and integrity of financial data. The ideal candidate has strong analytical skills, a solid understanding of AR processes, and the ability to thrive in a collaborative, fast-paced environment.

Key Responsibilities

Reporting & Analytics

• Prepare and review AR reports, including aging reports, cash collection summaries, reconciliation files, and variance reports.
• Conduct weekly variance analysis between AR and Treasury records.
• Support bad debt analysis and the preparation of bad debt provision reports.
• Create and distribute daily and weekly reports on customer interaction history and promises to pay.
• Support reporting needs for AP across other finance and operational areas as required.

Management and Lender Reporting Support

• Perform periodic reconciliations of general ledger accounts.
• Reconcile credit card GL accounts to ensure accuracy and completeness.
• Assist with internal and external audit requests and ensure compliance with audit standards.

Operational Support

• Generate and review dunning reports for overdue accounts.
• Process manual payments and journal entries as needed.
• Handle manual credit card payment processing in cases of authorization errors.
• Post customer payments and prepare daily cash posting summaries.
• Clear unapplied payments to maintain accurate customer accounts.
• Prepare quarterly final cash collections file for management.
• Monitor and report on pending credit/debit memo requests in Salesforce.

Qualifications & Skills

• Bachelor's degree in Accounting, Finance, Business or other related field.
• Proven experience in financial reporting, preferably with exposure to AR processes.
• Strong proficiency in Microsoft Excel (pivot tables, lookups, formulas).
• Experience with ERP systems, specifically NetSuite is preferred.
• Prior experience in a shared services or high-volume AR environment.
• Strong analytical mindset with keen attention to detail and organizational skills.
• Effective communicator with the ability to collaborate across functions and present data clearly.

Avid is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.