Reconciliation Manager

<p id="isPasted" fr-original-style="" style="font-size: 14px;">The Reconciliation Manager is responsible for executing periodic reconciliation and review activities across various internal general ledger (GL) accounts to ensure accuracy, completeness, and integrity of financial records. Operating under the Central Reconciliation Unit, the Manager plays a critical role in identifying discrepancies, resolving mismatches, and maintaining compliance with internal controls and regulatory standards. Each Reconciliation Manager will be assigned ownership for a portfolio of general ledgers, which is to be reconciled on defined intervals in compliance with Bank GL policy and CRU SOP.</p><p fr-original-style="" style="font-size: 14px;">The reconciliation Manager must be meticulous and have a strong eye for detail, and a solid understanding of reconciliation principles and banking products. The Recon Managers must be proficient in using automated reconciliation platforms. The Recon Manager must have advanced proficiency in Microsoft Excel (PivotTables, VLOOKUP and other Key Excel formulas from time to time) for data analysis.</p><p fr-original-style="" style="font-size: 14px;"><br></p><p id="isPasted" fr-original-style="" style="font-size: 14px;"><strong fr-original-style="" style="font-weight: 700;">Key Tasks &amp; Duties&nbsp;</strong></p><p fr-original-style="" style="font-size: 14px;"><strong fr-original-style="" style="font-weight: 700;">Daily Reconciliation Responsibilities:</strong></p><p fr-original-style="" style="font-size: 14px;">-<span style="white-space:pre;">&nbsp; &nbsp;&nbsp;</span>Reconcile transaction for those general ledger accounts assigned to each Recon Manager.</p><p fr-original-style="" style="font-size: 14px;">-<span style="white-space:pre;">&nbsp; &nbsp;&nbsp;</span>Extract datasets required for reconciliation from business objects or other system including download from portals or obtain from respective units.</p><p fr-original-style="" style="font-size: 14px;">-<span style="white-space:pre;">&nbsp; &nbsp;&nbsp;</span>Perform data preprocessing / formatting to prepare datasets for reconciliation / transaction matching.</p><p fr-original-style="" style="font-size: 14px;">-<span style="white-space:pre;">&nbsp; &nbsp;&nbsp;</span>Match and validate transactions based on established reconciliation methodology for each GL account including external statements / feeds (where relevant)</p><p fr-original-style="" style="font-size: 14px;">-<span style="white-space:pre;">&nbsp; &nbsp;&nbsp;</span>Identify and document all unmatched items in a timely and accurate manner.</p><p fr-original-style="" style="font-size: 14px;">-<span style="white-space:pre;">&nbsp; &nbsp;&nbsp;</span>Complete reconciliation template by including unmatched items within reconciliation top sheet with control that net differences is always Zero in recon template top sheet.&nbsp;</p><p fr-original-style="" style="font-size: 14px;">-<span style="white-space:pre;">&nbsp; &nbsp;&nbsp;</span>Submit the completed reconciliation template based on defined frequency and time (daily before 10/11am) to supervisor / CRU head for review and resolve the comments within same day.&nbsp;</p><p fr-original-style="" style="font-size: 14px;">-<span style="white-space:pre;">&nbsp; &nbsp;&nbsp;</span>Post approval share / save the reconciliation for respective unit to work / resolve on pending reconciling items.&nbsp;</p><p fr-original-style="" style="font-size: 14px;">-<span style="white-space:pre;">&nbsp; &nbsp;&nbsp;</span>Follow up with respective unit on the investigation to action unmatched exceptions.&nbsp;</p><p fr-original-style="" style="font-size: 14px;">-<span style="white-space:pre;">&nbsp; &nbsp;&nbsp;</span>Following day, review the comments provided by respective units for pending items and action / adjust the reconciliation based on comments provided.</p><p fr-original-style="" style="font-size: 14px;">-<span style="white-space:pre;">&nbsp; &nbsp;&nbsp;</span>Escalate unmatched exceptions beyond high-value or aging thresholds to supervisor / CRU head.</p><p fr-original-style="" style="font-size: 14px;">-<span style="white-space:pre;">&nbsp; &nbsp;&nbsp;</span>Prepare recon reports, highlighting the status of accounts and outstanding items.</p><p fr-original-style="" style="font-size: 14px;">-<span style="white-space:pre;">&nbsp; &nbsp;&nbsp;</span>Ensure all reconciliation tasks are completed within stipulated service levels.</p><p fr-original-style="" style="font-size: 14px;">-<span style="white-space:pre;">&nbsp; &nbsp;&nbsp;</span>Review the reconciliations done by other officers in the Team and rectify the discrepancies if any along with education /training in order not to repeat the same, mistake / discrepancy&nbsp;</p><p fr-original-style="" style="font-size: 14px;"><strong fr-original-style="" style="font-weight: 700;">Monthly &amp; Periodic Reconciliation Responsibilities:</strong></p><p fr-original-style="" style="font-size: 14px;">-<span style="white-space:pre;">&nbsp; &nbsp;&nbsp;</span>Prepare and document reconciliations as part of month-end closing procedures within timelines stipulated by finance group / respective units.&nbsp;</p><p fr-original-style="" style="font-size: 14px;">-<span style="white-space:pre;">&nbsp; &nbsp;&nbsp;</span>Respond to any queries raised by Finance regarding their GL Review activities.</p><p fr-original-style="" style="font-size: 14px;">-<span style="white-space:pre;">&nbsp; &nbsp;&nbsp;</span>Assist in the substantiation and certification of financial controls for the reconciled accounts.</p><p fr-original-style="" style="font-size: 14px;">-<span style="white-space:pre;">&nbsp; &nbsp;&nbsp;</span>Analyse exception trends and contribute to root cause analysis to prevent future occurrences.</p><p fr-original-style="" style="font-size: 14px;">-<span style="white-space:pre;">&nbsp; &nbsp;&nbsp;</span>Prepare Monthly MIS of ageing of Account balances under CRU in the prescribed format and discuss the same with Senior Manager &nbsp;</p><p fr-original-style="" style="font-size: 14px;"><strong fr-original-style="" style="font-weight: 700;">Other Responsibilities:</strong></p><p fr-original-style="" style="font-size: 14px;">-<span style="white-space:pre;">&nbsp; &nbsp;&nbsp;</span>Perform reconciliation of accumulated opening balances for prior years as assigned by head CRU.</p><p fr-original-style="" style="font-size: 14px;">-<span style="white-space:pre;">&nbsp; &nbsp;&nbsp;</span>Identify item / process improvements for the assigned GL accounts to update for system based recons.</p><p fr-original-style="" style="font-size: 14px;">-<span style="white-space:pre;">&nbsp; &nbsp;&nbsp;</span>Assist CRU unit in implementing the system based reconciliation including performing UAT.&nbsp;</p><p fr-original-style="" style="font-size: 14px;">-<span style="white-space:pre;">&nbsp; &nbsp;&nbsp;</span>Conceive, initiate and pursue enhancements to improve auto-match of transactions within excel templates.</p><p fr-original-style="" style="font-size: 14px;">-<span style="white-space:pre;">&nbsp; &nbsp;&nbsp;</span>Participate in projects relating to new products or process improvement requiring recon.</p><p fr-original-style="" style="font-size: 14px;">-<span style="white-space:pre;">&nbsp; &nbsp;&nbsp;</span>Investigate and resolve queries from internal stakeholders like Finance, Audit, etc.</p><p fr-original-style="" style="font-size: 14px;">-<span style="white-space:pre;">&nbsp; &nbsp;&nbsp;</span>Keep up to date the Standard Operating Procedures (SOPs) for the CRU.</p><p fr-original-style="" style="font-size: 14px;">-<span style="white-space:pre;">&nbsp; &nbsp;&nbsp;</span>Handle special investigations and management information (MI) reporting as required.</p><p fr-original-style="" style="font-size: 14px;"><br></p>