Reconciliation Specialist

Magic Payment Inc.; Manila; Sur place; PHP 380 000 - 720 000; Plein temps

Résumé du poste

Magic Payment Inc. in Manila seeks a detail‑oriented Reconciliation Specialist to perform daily, weekly, and monthly reconciliations for cash‑in and cash‑out transactions and to collaborate with Finance, Operations and IT to resolve variances.

The role emphasizes advanced Excel skills, data analysis, and creating reliable templates and dashboards; familiarity with payment gateways and SQL is a plus for automating processes.

Qualifications

• Bachelor’s degree in Finance, Accounting, Business, or related field.
• Strong understanding of payment flows, settlement cycles, and upstream provider transactions.
• Advanced Excel skills (pivot tables, VLOOKUP/XLOOKUP, SUMIFS, INDEX-MATCH, macros a plus).
• High attention to detail with excellent problem-solving and analytical abilities.
• Strong communication and collaboration skills to work effectively across teams.

Responsabilités

• Perform daily, weekly, and monthly reconciliation for cash-in and cash-out transactions.
• Investigate and resolve reconciliation variances promptly to ensure accurate, complete data.
• Collaborate with Finance, Operations, and IT to identify, report, and rectify discrepancies.
• Maintain and improve reconciliation templates and dashboards using Excel or other analytical tools.
• Prepare reconciliation summaries and exception reports for management review.
• Support audit and compliance requirements by maintaining organized and traceable reconciliation records.
• Continuously identify opportunities to automate or streamline the reconciliation process for efficiency.

Connaissances

Attention to detail

Analytical thinking

Team collaboration

Problem solving

Formation

Bachelor’s degree in Finance, Accounting, Business, or related field

Outils

Excel

SQL

Power Query

Power Pivot

VBA

Description du poste

Key Responsibilities:

• -Perform daily, weekly, and monthly reconciliation for cash-in and cash-out transactions between internal records and upstream provider reports.
• -Investigate and resolve reconciliation variances promptly to ensure accurate, complete financial data.
• -Collaborate closely with Finance, Operations, and IT teams to identify, report, and rectify discrepancies.
• -Maintain and improve reconciliation templates and dashboards using Excel or other analytical tools.
• -Prepare reconciliation summaries and exception reports for management review.
• -Support audit and compliance requirements by maintaining organized and traceable reconciliation records.
• -Continuously identify opportunities to automate or streamline the reconciliation process for efficiency.

Qualifications

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

Strong understanding of payment flows, settlement cycles, and upstream provider transactions.

Advanced Excel skills (pivot tables, VLOOKUP/XLOOKUP, SUMIFS, INDEX-MATCH, conditional formatting, macros a plus).

High attention to detail with excellent problem-solving and analytical abilities.

Strong communication and collaboration skills to work effectively across teams.

Preferred Qualifications

• -Experience working with payment gateways, e-wallets, or bank integrations.
• -Familiarity with SQL or reconciliation automation tools.
• -Proven track record of handling large transaction volumes and complex datasets.
• -Demonstrated initiative in improving reconciliation processes or controls.
• -Advanced Excel skills, including Power Query and Power Pivot/Data Model, to import, clean, and match large datasets from multiple sources (e.g., bank statements, ledgers, sub-systems)
• -Experience using Excel VBA to build or maintain macros that automate recurring reconciliation tasks, reduce manual effort, and improve accuracy