There’s a reason why Apple rewrote the script on personal computers and IBM didn’t; or why Tesla revolutionized the electric car industry and GM didn’t; or why Facebook is monopolizing the media platform, and NBC isn’t.
Innovation often originates outside of the existing ecosystem, and account reconciliations is no different. Since 2011, Oracle Account Reconciliation Manager (ARM) and Account Reconciliation Cloud Service (ARCS as of 2016) have been beating the traditional industry incumbents out of the water.
Not only are companies switching from an offline Excel process to an integrated and automated solution, they are switching to Oracle from various other account reconciliation tools, including SaaS applications like BlackLine and Trintech.
We have recently converted several customers from either Excel or BlackLine to Oracle ARM/ARCS, so this post will focus on the key differences between these two technologies. Please note that I do not work for a BlackLine implementation firm, so the information presented here is based on BlackLine client interviews and knowledge from account reconciliation industry experts.
Life before the switch:
Prior to the implementation, customers (such as the case study below) were often struggling with the burden of increasing subscription costs and delays due to the disjointed data flow between Oracle EBS and BlackLine. As legal entities were evolving in HFM, account certification governance and accountability of those entities was cumbersome. Data was inaccurate, reviewers/approvers were misaligned, and technology was a distraction, rather than an enabler.
How to switch?
The #1 consideration in determining what factor most influenced a customer’s selection of account reconciliation software in a 2013 iPolling survey was the vendor’s technology.
How do you define the quality of “technology” for account reconciliation software? We came up with 7 key areas for comparison:
- Rules engine
- Ease of use
- Task management
The Real Questions
|1. Modules||What is included with a single license?|
|2. Rules Engine||What is the extent of automation intelligence?|
How many consultants am I going to have to pay to make this data flow? (this is the biggest pain point for account reconcillation software)
|4. Ease of Use||How much training is it going to require?|
|5. Workflow||How self-managed is the approval process? I don't want to be the Task Master...|
|6. Reporting||How accurately can I track compliance?|
|7. Task Management||How well can users manage their own open items?|
As of December 2016, ARCS includes transaction matching as part of a single module, whereas BlackLine separates this feature into a different product offering. In ARCS, you can treat the transaction matching workflow as part of the standard setup process prior to opening a period for users to begin certifying accounts. Administrators or Power Users may validate and confirm suggested matches, in the same way that they may check auto-reconciled accounts without leaving one tool.
#2 Rules Engine:
Surprisingly, my previous implementation of ARCS revealed that over 60% of the accounts could be auto reconciled, based on either threshold of immaterial balances and/or activity...wow! Every company’s reconciliation policy will differ, however in this case, more time could truly be allocated towards high risk accounts and investigating discrepancies, rather than ticking and tying spreadsheets.
While both tools offer this capability, the abundance of configurable options seem to be endless with Oracle. The below screenshot shows a simple example of how to automatically assign a low risk rating to an account before the profile is copied to a period based on source system and activity dollar amounts:
Just to give you a glimpse, the list of customizable attributes is quite extensive as well:
You can also configure auto submission, auto approval, and prevent reconciliation submission based on account balances or period activity as shown below:
|Auto Submit Reconcilliation||
Balance Exists equals No
Auto Approve Reconciliation
Balance Exists equals No
Prevent Reconcillation Submission
Unexplained Difference (Reporting) less than -1000 USD
Or Unexplained Difference (Reporting) greater than 1000 USD
BlackLine allows you to set risk ratings for account profiles when setting up the system, and these can be modified monthly. However, the auto-reconciliation rules in BlackLine are based on account risk ratings only, with limited flexibility. The difference in ARCS is being able to dynamically set the risk ratings based on the data in the source system and subledger, as well as other business-defined attributes. This is a progressive approach to compliance that is enabled by intelligent rule configuration in the system.
As far as auto-reconciliation capabilities, both tools are comparable, with slightly more flexibility available in Oracle to set specific auto-rec rules based on balances and/or activity as shown above.
The reconciliation process inherently requires that data from the source and subsystem is available for comparison to ensure balances tie to your subledger or are certified based on explained balance criteria.
The EPM Data Management console allows for automatic and scheduled data loads, batch processes, and automated updates through flat files using the EPM Automate utility. If on-premise FDMEE is available (version 220.127.116.11.000), drill-through to source and sub-system detail can be made available, such as being able to integrate with Oracle ERP Cloud, Oracle EBS, and SAP through.
This flexibility is the key difference between these two technologies, as BlackLine requires a specific data set format and file-based data loads, with no visibility into the source or sub-system detail. However, you can still connect to multiple ERP systems, banks, and credit processors.
We felt that the flexibility with ARCS took the prize since it allows for a phased and agile approach to implementing a reconciliation solution where new entities can be easily integrated as users get comfortable with the system and the reconciliation process stabilizes.
#4 Ease of Use
We found that the 20 (versus 8 in BlackLine) pre-built templates for different reconciliation formats available in Oracle ARCS, ranging from Accounts Payable, Receivable to Intercompany, Cash, etc. were very helpful as a starting point in the design/build process. We were able to work with the Administrators and Power Users to customize account analysis and balance comparison formats on the spot.
During the implementation, as well as post go-live, the training tools in both systems are extensive. The only difference being that BlackLine allows you to track training progress by user.
So, what’s the score? We still rated ARCS higher because of the user interface and the availability of pre-built templates that allows the admin team to easily develop additional reconciliation formats in the future.
In terms of workflow, there’s a tie. As a compliance tool, standardized controls, roles, and responsibilities are at the core of a reconciliation process. Both tools allow for sufficient collaboration, tracking, and reviewer/approver duration limits to fit a company’s reconciliation compliance policy. While team-based security is available in both tools, clients have mentioned that it’s not as easily accessible in BlackLine, when compared to ARCS.
This is a tricky one. First, from an implementation standpoint, it’s often easy to overlook the types of reporting that may be required, until Administrators and Power Users can visualize the reconciliations in the system. The current process is usually very manual in Excel, that reporting on compliance is a far stretch of the imagination. If BlackLine is already being used, then it’s not much of a paradigm shift.
Here’s the difference: ARCS includes 15 pre-built reports that often meet the customer’s needs to track reconciliation compliance by organization unit, reviewer/approver, status, aging, etc. Three standard dashboards are also available as shown below:
Additional custom reports may be configured; however, we have noticed that the reconciliation and transaction lists as shown below, provide the ability to add/remove columns as each user chooses. Before you spend time and money creating new reports, explore the flexibility in these flexible views as a potential option.
The list of attributes to choose as columns for reconciliation and/or balance detail goes on…
Oracle ARCS also provides the ability to create report binders for easy review of reconciliation data for external auditors or third parties without having to give them access to the system and without having to purchase additional tools. Whereas BlackLine can often make it difficult to extract this information, without more invasive access for non-users and may also require customers to purchase additional tools, such as the BlackLine Enhanced Reporting package for self-service reporting. However, BlackLine provides benchmarking data for other companies in your industry. While the latter feature is helpful, it’s not usually the deciding factor in what reconciliation tool to use.
#8 Task Management
And finally, how easily can users track their own day-to-day progress for the reconciliations in their queue? You can enable “Action Plans” at the transaction level with the ability to enter a description and a close date as shown below. These fields are reportable in the transaction list feature as well, so a user can track how many follow-up items are pending, such as a reimbursement on an invoice, or a correction to a journal entry, etc.
BlackLine offers configurable user checklists that assist in tracking open items by user at a detailed level. With the task management capabilities offered in other EPM tools (such as task lists in PBCS, FCCS), I wouldn’t doubt that this is on the horizon for future updates in Oracle ARCS.
In closing, our experience has proven that the flexibility around integrations and custom rules allow for Oracle ARCS to best fit the unique reconciliation compliance policies of most global organizations. Being able to leverage EPM Automate for multiple data load steps, such as copying profiles to periods and loading currency rates relieves the burden of administration tasks from the business. Custom rule configuration enables the business to truly evolve the application as their compliance and audit needs change. While BlackLine is a strong choice, these two features within Oracle ARCS are critical factors in maintaining internal controls and avoiding internal costs related to non-compliance.
A summary of the comparison between Oracle ARCS and Blackline is featured below. Feel free to contact me at firstname.lastname@example.org if you have questions regarding Oracle ARCS or other EPM products.