Key Responsibilities

Management Reporting

• Prepare daily, weekly, monthly, and quarterly OTC management reports.

• Develop executive dashboards and scorecards for senior leadership.

• Prepare Accounts Receivable Aging reports and portfolio analysis.

• Monitor customer payment behavior and collection performance.

• Analyze trends affecting Days Sales Outstanding (DSO) and overdue balances.

• Present actionable insights and recommendations to management.

Accounts Receivable Analytics

• Analyze customer accounts by aging buckets

• Identify high-risk accounts.

• Monitor unapplied cash and credit balances.

• Perform FIFO offsetting analysis when applicable.

• Prepare customer exposure reports.

KPI Reporting

Monitor and report KPIs such as:

• Total Accounts Receivable

• Current vs Overdue AR

• Days Sales Outstanding (DSO)

• Past Due Percentage

• 60 Days Exposure

• Collection Productivity

• Cash Collection Performance

• Promise-to-Pay Performance

• Dispute Resolution Cycle Time

• Bad Debt Trends

Data Analysis

• Analyze large datasets using Excel, Power Query, SAP, or similar ERP systems.

• Validate data integrity across multiple systems.

• Perform root-cause analysis of aging fluctuations.

• Identify collection opportunities and process gaps.

• Provide financial insights supporting strategic decisions.

Dashboard Development

• Build interactive dashboards using: AI, Microsoft Excel

• Automate recurring reports.

• Standardize reporting templates.

• Develop executive-level visualizations and infographics.

Process Improvement

• Identify opportunities to automate manual reporting.

• Develop VBA macros and reporting automation.

• Improve reporting efficiency and accuracy.

• Support OTC transformation initiatives.

• Document reporting processes and standard operating procedures.

Stakeholder Management

Collaborate with:

• Collections Team

• Credit Management

• Sales

• Finance

• Business Controllers

• IT / Data Analytics

Compliance & Governance

• Ensure reporting complies with company policies and financial controls.

• Maintain confidentiality of financial information.

• Support internal and external audit requests.

• Ensure data accuracy and consistency across reports.