Management Reporting Analyst

Concepcion Business Services, Inc.; Muntinlupa; On-site; PHP 600,000 - 1,000,000; Full time

Job summary

Concepcion Business Services, Inc. is seeking a professional to lead management reporting and AR analytics, delivering daily to quarterly OTC reports and executive dashboards. The role will develop AR aging analyses, monitor DSO, and provide actionable insights to senior leadership.

Strong data validation, ERP proficiency (Excel, SAP), and process-improvement mindset are essential. On-site in Metro Manila. Responsibilities include building dashboards, automating recurring reports, and

Qualifications

• 3–5 years of experience in Order-to-Cash, Accounts Receivable, Collections, and Financial Reporting.
• Experience in Shared Services / Global Business Services preferred.
• Knowledge of data analytics and process improvement.

Responsibilities

• 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.
• 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.
• 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.
• Build interactive dashboards using AI, Microsoft Excel.
• Automate recurring reports.
• Standardize reporting templates.
• Develop executive-level visualizations and infographics.
• 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.
• Collaborate with: Collections Team, Credit Management, Sales, Finance, Business Controllers, IT / Data Analytics.
• 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.

Skills

Advanced Excel

VBA/Macros

AI tools (ChatGPT Copilot)

SAP ECC / SAP S/4HANA

Power Automate

Microsoft Office Suite

Education

Bachelor's degree in Business Administration

Information Systems

Data Analytics

Tools

SAP ECC / SAP S/4HANA

Job description

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