Account Reconciliation Manager

With high volumes of activity in many corporations today, financial systems such as HFM are essential to facilitate data management in a highly scalable software solution. Sourced from the company’s General Ledger system, these business activities are consolidated in order to produce financial statements such as a Balance Sheet, Income or Cash Flow Statement.  The final step in the business process is to reconcile all the data to provide accuracy to the reports, frequently a lengthy and manual process accomplished through excel spreadsheets.

Account Reconciliation Manager, or ARM, serves as a part of Oracle Hyperion’s Financial Close Manager’s Suite to reconcile finalized data to source data. The value of this tool relies mostly with large accounts where balances become highly integrated from various sources causing an outstanding balance difficult to trace.

Account Reconciliation Manager provides the following key features:

  • Delivers “real time visibility,” by reconciling final and source data and providing a status of all account reconciliations involved in the close process, reducing control risks and supporting statutory reporting
  • Streamlines processes by centralizing and automating reconciliation tasks, allowing users to spend less time on manual steps and excel spreadsheets and more time on data analysis
  • Integrates with HFM to map and integrate from various GLs, ensuring data quality

WEBINAR

Building to the ‘Top’ with OneStream: HFM Replacement Story

How does it work?

ARM provides an efficient workflow to manage the reconciliation process. To provide an organized and risk reduced procedure, Preparers and Reviewers are assigned to perform reconciliations defined by the frequency and duration. After the reconciliation is executed, the preparer forwards to the reviewer.

Once users and optional procedures such as currencies are created, several requirements are needed to create the primary foundation of the application: data maps, formats and profiles. Data maps, which are further defined through formats and profiles, associate the detail accounts to the total balance and also summarize low-level balances to the level appropriate for reconciliation. Through the use of these detailed maps, data can be loaded into ARM through Oracle Hyperion financial Data Quality Management Integration Adapter or a file.

In relation, formats dictate the method of reconciliation in two supported methods: Account Analysis and Balance Comparison, which requires preparers to justify balances provided in the system via an explanation or comparison of transactions for review. Lastly, before reconciliations can take place, profiles dictate how and when reconciliations are made. All of the steps discussed arrange for a streamlined process, delivering real time visibility for corporations today.

Customized features to increase workflow include:

  • Customized dashboards to provide status, aging and performance metrics
  • Flexible auto reconciliation routines, including mass updates and import capabilities
  • System generated email notifications and end user notifications
  • Drill back to source system
  • Preparation and review workflow
  • Offline access to account reconciliation details

Share this

About the author

Philip Parker

The Pre-Transformation Checklist for Finance

An 11-Step Risk Reduction Tool for CFOs and CAOs Who Aren’t Sure Where to Start

By following this checklist, organizations can systematically approach their finance technology transformation, ensuring that all critical aspects are addressed and that the transition is smooth and successful.

Related posts you might like

Transformation program leaders guide

THE TRANSFORMATION PROGRAM LEADER’S GUIDE TO FINANCE ROADMAPS

View Post
BUILDING A SCALABLE FINANCE STACK: WHAT HIGH-GROWTH CFOS NEED TO KNOW

BUILDING A SCALABLE FINANCE STACK: WHAT HIGH-GROWTH CFOS NEED TO KNOW

View Post
Why CFOs Should Lead the Finance Transformation Agenda

Why CFOs Must Lead the Finance Transformation Agenda

View Post

Privacy Policy

Introduction

Welcome to Holland Parker. We are committed to protecting your personal information and your right to privacy. If you have any questions or concerns about our policy or our practices with regard to your personal information, please contact us at [email protected].

Information We Collect

We collect personal information that you provide to us when expressing an interest in obtaining information about us or our products and services, when participating in activities on the website, or otherwise contacting us.

The personal information that we collect depends on the context of your interactions with us and the website, the choices you make, and the products and features you use. The personal information we collect can include the following:

  • Name and Contact Data: We collect your first and last name, email address, postal address, phone number, and other similar contact data.
  • Payment Data: We collect data necessary to process your payment if you make purchases, such as your payment instrument number (e.g., a credit card number), and the security code associated with your payment instrument.
  • Login Credentials: We collect passwords, password hints, and similar security information used for authentication and account access.
  • Other Information: We collect any other information you directly provide to us through our website.

How We Use Your Information

We use personal information collected via our website for a variety of business purposes described below. We process your personal information for these purposes in reliance on our legitimate business interests, in order to enter into or perform a contract with you, with your consent, and/or for compliance with our legal obligations.

We use the information we collect or receive:

  • To send administrative information to you.
  • To fulfill and manage your orders.
  • To post testimonials.
  • To request feedback.
  • To send you marketing and promotional communications.
  • To deliver targeted advertising to you.
  • For other business purposes.

Sharing Your Information

We may process or share your data that we hold based on the following legal basis:

  • Consent: We may process your data if you have given us specific consent to use your personal information for a specific purpose.
  • Legitimate Interests: We may process your data when it is reasonably necessary to achieve our legitimate business interests.
  • Performance of a Contract: Where we have entered into a contract with you, we may process your personal information to fulfill the terms of our contract.
  • Legal Obligations: We may disclose your information where we are legally required to do so in order to comply with applicable law, governmental requests, a judicial proceeding, court order, or legal process.
  • Vital Interests: We may disclose your information where we believe it is necessary to investigate, prevent, or take action regarding potential violations of our policies, suspected fraud, situations involving potential threats to the safety of any person, and illegal activities.

Cookies and Other Tracking Technologies

We may use cookies and similar tracking technologies to access or store information. Specific information about how we use such technologies and how you can refuse certain cookies is set out in our Cookie Policy.

Data Security

We aim to protect your personal information through a system of organizational and technical security measures. We have implemented appropriate technical and organizational security measures designed to protect the security of any personal information we process.

Retention of Data

We will only keep your personal information for as long as it is necessary for the purposes set out in this privacy policy unless a longer retention period is required or permitted by law.

Your Privacy Rights

In some regions, such as the European Economic Area (EEA), you have certain rights under applicable data protection laws. These may include the right to (i) request access and obtain a copy of your personal information, (ii) request rectification or erasure; (iii) restrict the processing of your personal information; and (iv) if applicable, to data portability.

Updates to This Policy

We may update this privacy policy from time to time in order to reflect changes to our practices or for other operational, legal, or regulatory reasons.

Contact Us

If you have questions or comments about this policy, you may contact us by email at [email protected].

The Pre-Transformation Checklist for Finance

Tap into wisdom gained through 300+ finance transformations to uncover answers to questions you have and those you should.

This field is for validation purposes and should be left unchanged.