Management Reporting Analyst

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.

---

Qualifications

Education

• Bachelor's degree in:

  • Business Administration
  • Information Systems
  • Data Analytics

---

Experience

• 3–5 years of experience in(preferred):

  • Order-to-Cash (OTC)
  • Accounts Receivable
  • Collections
  • Financial Reporting
  • Business Analytics
  • Shared Services / Global Business Services (preferred)

---

Technical Skills

• Advanced Microsoft Excel

  • VBA/Macros (preferred)

• Artificial Intelligence(AI)-ChatGPT, COPILPT

• SAP ECC / SAP S/4HANA

• Power Automate (preferred)

• Microsoft Office Suite

---

Core Competencies

• Financial Analysis
• Data Analytics
• Business Intelligence
• Critical Thinking
• Attention to Detail
• Problem Solving
• Process Improvement
• Project Management
• Communication Skills
• Stakeholder Management
• Time Management
• Continuous Improvement
• Customer Focus

---

Key Performance Indicators (KPIs)

• Report accuracy
• On-time report delivery
• Dashboard availability
• Report automation rate
• Reduction in manual reporting effort
• DSO improvement support
• Collection performance visibility
• Aging accuracy
• Executive reporting quality
• User satisfaction