Reconciliation Analyst Job Description
Reconciliation analyst
provides input to and support of the GL account reconciliation process, working closely with the Accounting department.
Reconciliation Analyst Duties & Responsibilities
To write an effective reconciliation analyst job description, begin by listing detailed duties, responsibilities and expectations. We have included reconciliation analyst job description templates that you can modify and use.
Sample responsibilities for this position include:
Create & distribute weekly Excel spreadsheets to the NASSC Accounts Receivable team to enable accurate & timely adjustments of chargeback debits and credits
Proficient technical skills in MS Excel
Review and sign-off of daily and monthly controls and checks
Reconciliations for the company intragroup (IG) account categories (Funding, Derivatives, Brokerage, Repos, Nostro/Vostro, AR/AP, Accrued Interest, Branch Equity, Positions, Clearings, Controls, NII, NIE, Other Income, MTM P&L)
Assist to prepare monthly / quarterly scorecards and reports for senior management and external auditors
Prepare reporting of the status of the IG reconciliations including monthly / quarterly scorecards and issue logs for Wholesale Finance
Participate in projects relating to the enhancement of reconciliation capabilities / processes for all monthly intragroup reconciliations
Assist the company to implement control and governance programs from enterprise perspective
Lead coordination and communication of reconciliation results
Provide onshore supervisory oversight to Reconciliations, Brokerage & Audit Confirm team in the Global Service Center
Reconciliation Analyst Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for Reconciliation Analyst
List any licenses or certifications required by the position: IAQ/IOC, II, PRINCE, PMP, CHFP, CPA, ACCA
Education for Reconciliation Analyst
Typically a job would require a certain level of education.
Employers hiring for the reconciliation analyst job most commonly would prefer for their future employee to have a relevant degree such as Bachelor's and University Degree in Accounting, Finance, Business, Education, Economics, Business/Administration, Financial Services, Communication, Technical, Guidance
Skills for Reconciliation Analyst
Desired skills for reconciliation analyst include:
Excel
GFAS /GTA an advantage
Account reconciliation processes
MS-Excel
Modern securities reconciliation practices
Securities instruments/settlements and banking process
Accounting principles and bank account reconciliation concepts
Reconciliation and thorough understanding of financial controls
Pivot Tables
SUMIF
Desired experience for reconciliation analyst includes:
Checking to ensure accuracy and timeliness of rate setting to counterparty
Checking to ensure the accuracy of settlement notices to counterparties
Providing timely, reliable and full back office support to traders enquiries and handling investigations promptly
Handling on a priority basis and providing excellent customer service to clients enquiries
Responsible for co-coordinating the settlement/delivery of financial instruments in the completion of deals or the maintenance of deals on an on-going basis
Monitor credit exceptions against approved credit limits and report same to the appropriate Credit Unit
Reconciliation Analyst Examples
1
Reconciliation Analyst Job Description
Job Description Example
Our company is looking for a reconciliation analyst. Thank you in advance for taking a look at the list of responsibilities and qualifications. We look forward to reviewing your resume.
Responsibilities for reconciliation analyst
- Prepares documentation to adequately document variances and analysis for all findings
- Coordinate entry of subscription/redemption activity, where necessary, and publish cash to PMG within established account deadlines
- Provide support to all consumers of cash data, including PMG and GCG
- Obtaining and exchanging information, providing direction for required adjustments
- Prepare and analyze monthly General Ledger account reconciliations for various accounts, ranging from low to
- Ensure that all cash is reconciled accurately, efficiently and on a timely basis
- Assist the team leaders with the review of the Analysts’ deliverables and ensure that daily responsibilities are completed
- Responsible for the analysis of financial transactions
- Completes monthly reconciliations through Recon-Net Reconciliation system
- Reconciles daily credit cards on a transactional level in Recon-Net
Qualifications for reconciliation analyst
- Of balance sheet and income statement relationships, knowledge of basic auditing standards)
- Candidates will have the opportunity to participate in projects that will push them to think outside the box in order to solve numerous complex issues
- Completes daily process surrounding store’s chargebacks while meeting required deadlines
- Works with retail locations to ensure the utmost customer satisfaction is upheld in regards to settlement inquiries
- Partners with the Store Operations and Loss Prevention groups to ensure store procedures are clear and up to date relative to transactions, special receipts, and overages/shortages
- Assists with development and compilation of periodic reporting to accommodate changes in the business environment and/or requests from internal or external departments
2
Reconciliation Analyst Job Description
Job Description Example
Our growing company is hiring for a reconciliation analyst. We appreciate you taking the time to review the list of qualifications and to apply for the position. If you don’t fill all of the qualifications, you may still be considered depending on your level of experience.
Responsibilities for reconciliation analyst
- Performs journal entries as necessary
- Analyse payment exceptions to determine cause of discrepancy while coordinating with custodians, broker/dealers and internal departments to communicate discrepancies and complete correcting actions
- Responsible to reconcile daily operational clearing accounts
- Priority focus given to outstanding reconciliation items across various risk categories ensuring the case files are created and maintained with relevant and up to date information
- Delivery of reconciliations to internal departments within set timeframes
- Regular monitoring with internal teams to ensure reconciliation items is being actioned
- Respond to all internal clients queries within a timely manner
- Provide support to other members in team in resolving issues
- Provide technical knowledge support to the team
- Daily cash adjustments
Qualifications for reconciliation analyst
- Ability to manage high volume of transactions in a fast-paced environment
- Able to work with high degree of accuracy and integrity
- Can effectively communicate with upper level management and external customers in both a written and verbal manner
- Multi-Currency experience a plus
- Certifications from NSE/BSE/AIMR/CFA Institute/Others
- Knowledge of Intellimatch 8.1 or 9.1 R2
3
Reconciliation Analyst Job Description
Job Description Example
Our company is searching for experienced candidates for the position of reconciliation analyst. If you are looking for an exciting place to work, please take a look at the list of qualifications below.
Responsibilities for reconciliation analyst
- Process improvements and proposition of IS enhancements
- Responsible to reconcile mortgage loan and pool level data within Private Investor and Agency Investor Custodial bank accounts
- Perform daily and monthly reconciliation and analysis of the escrow and corporate advance funding facility
- Investigate out-of-balance situations wherein individual balances, positions, prices and transactions are either missing or different between AMPF systems (Thomson, DTCC etc) and Albridge
- Audit manual processing performed by Albridge (Corp Actions)
- Identify and implement process improvement, including quality inspection with process improvement specialists
- Monitor new tran codes / entries introduced by Clearing to ensure they work correctly from a performance perspective
- Evaluate efficiencies of existing policies, procedures, and processes to harmonize and improve all aspects of Accounts Receivable as it relates to Chargebacks
- Maintain related training material and updated desktop procedures in order ensure standard team practices that adhere to best practice efficiency and accuracy
- Document any identified gaps in reconciliation procedures and work with the team leaders and managers to find resolution
Qualifications for reconciliation analyst
- Capable of navigating through financial systems
- SQL (requests (insert, update, delete), joins, stored procedures, indexes)
- Knowledge of software development lifecycle (SDLC) activities
- Certified Public Accountant is an advantage
- Excellent analytical, problem solving skills and detail-oriented
- Proactive and able to work independently and meet tight reporting deadlines
4
Reconciliation Analyst Job Description
Job Description Example
Our growing company is hiring for a reconciliation analyst. Thank you in advance for taking a look at the list of responsibilities and qualifications. We look forward to reviewing your resume.
Responsibilities for reconciliation analyst
- Performs client specific program gross profitability analysis and makes recommendations to improve program performance
- Performs reconciliations on a quarterly basis (at a minimum) for clients in accordance with the contracts
- Analyzes exception reporting using various systems, including EDI, CORPED, WEBSDL, other internal adjudication platforms
- Develops and fosters working relationships with internal working counterparts (IT, Internal Audit, Results, Accounting, ) to facilitate productive exchanges of information
- Develops thorough understanding of the 340B program
- Sign offs to internal departments within set timeframes
- Provide daily status of the breaks including assignment and aging, context related to major patterns identified and progress in long-term resolution
- Perform system configurations/customizations to onboard/maintain reconciliations/
- Responsible for preparing timely reconciliations & review of all B2P related accounts such as GR/IR, AP Liability and other related accounts
- Management of open items and clearing with stakeholder involvement
Qualifications for reconciliation analyst
- Initiate possible improvements to the processes
- Creation of process documentations of transferred tasks to ensure that everything is captured during the knowledge transfer
- Proficiency in computer skills, particularly in the use of MS Office Pack, knowledge of VBA & SWIFT messages are a plus
- Expertise in Microsoft office products with an emphasis on Exc
- Sound knowledge on Reconciliation process from an Asset Manager perspective
- Understanding of Swift messages (MT940, MT950, MT535 and FX Swifts MT300)
5
Reconciliation Analyst Job Description
Job Description Example
Our innovative and growing company is hiring for a reconciliation analyst. Thank you in advance for taking a look at the list of responsibilities and qualifications. We look forward to reviewing your resume.
Responsibilities for reconciliation analyst
- Participation in migrations and system implementations, create and maintain DTP’s and other process documentation
- Identification, analysis and resolution of exceptions in a timely manner
- Liaise with stakeholders and counterparties both verbally and by other means to resolve exceptions
- Post entries to the accounting system which have not been automatically generated
- Collaborate with the UK-based Reconciliation Services team to manage workflows and complete tasks
- Generate management and control reports and perform analysis of the same
- Perform periodic general administrative tasks
- Participation in projects as directed
- Reconciles the CMS transaction reply reports against the membership files of the health plan in accordance with department standards, policies and procedures
- Maintain documentation supporting the reconciliation status and dispositions of reconciling items in order to ensure compliance with Custodial bank reconciliation policy and procedures
Qualifications for reconciliation analyst
- 5 years plus of proven and solid Business Analysis experience
- Banking experience a must have
- Ability to quickly understand complex environments
- 2 to 3 years Trust, Banking, or Financial Services experience related to Reconciliation or Accounting
- Knowledge of Securities preferred
- Coaching and mentoring possibility