BlackLine Home page BlackLine home page
Solutions
Solutions
Financial Close Management
Financial Close Management
Overview
Overview
Account Reconciliations
Account Reconciliations
Task Management
Task Management
Transaction Matching
Transaction Matching
Journal Entry
Journal Entry
Financial Reporting Analytics
Financial Reporting Analytics
Variance Analysis
Variance Analysis
Smart Close for SAP
Smart Close for SAP
Accounts Receivable Automation
Accounts Receivable Automation
Overview
Overview
Cash Application
Cash Application
Credit & Risk Management
Credit & Risk Management
Collections Management
Collections Management
Disputes & Deductions
Disputes & Deductions
Team & Task Management
Team & Task Management
AR Intelligence
AR Intelligence
Invoicing & Compliance
Invoicing & Compliance
Intercompany Financial Management
Intercompany Financial Management
Overview
Overview
Intercompany Non-Trade
Intercompany Non-Trade
Intercompany Balance & Resolve
Intercompany Balance & Resolve
Intercompany Net & Settle
Intercompany Net & Settle
By Organization Size
By Organization Size
Midsize Organizations
Midsize Organizations
Large Enterprises
Large Enterprises
By Industry
By Industry
Banking & Financial Services
Banking & Financial Services
Consumer Products & Services
Consumer Products & Services
Energy & Raw Materials
Energy & Raw Materials
Healthcare & Life Sciences
Healthcare & Life Sciences
Manufacturing
Manufacturing
Retail
Retail
Technology, Media & Communications
Technology, Media & Communications
See All Industries
By ERP
By ERP
SAP
SAP
Oracle
Oracle
Oracle NetSuite
Oracle NetSuite
Microsoft Dynamics
Microsoft Dynamics
See All ERPs
By Topic
By Topic
Environmental, Social, and Governance
Environmental, Social, and Governance
Recruiting & Retaining Top Talent
Recruiting & Retaining Top Talent
Enabling an ERP Transformation
Enabling an ERP Transformation
CFO & CIO Collaboration
CFO & CIO Collaboration
F&A Transformation
F&A Transformation
IPO Readiness
IPO Readiness
Mergers & Acquisitions
Mergers & Acquisitions
Revenue Cycle Optimization
Revenue Cycle Optimization
Regulatory Compliance
Regulatory Compliance
Customers
Customers
Customer Success
Success Stories
Success Stories
Community
Community
Services
Services
Overview
Overview
Professional Services
Professional Services
Training & Education
Training & Education
Customer Success
Customer Success
Transformation Services
Transformation Services
Global Support
Global Support
Resources
Resources
Events
Events
Upcoming Webinars
Upcoming Webinars
On-Demand Webinars
On-Demand Webinars
White Papers
White Papers
Blog
Blog
Accounting Glossary
Accounting Glossary
Developer Portal
Developer Portal
About
About
Company
Company
About BlackLine
About BlackLine
Leadership
Leadership
Diversity, Equity & Inclusion
Diversity, Equity & Inclusion
Environmental, Social & Governance
Environmental, Social & Governance
In the News
In the News
Press Releases
Press Releases
Investors
Investors
Awards & Recognition
Awards & Recognition
Careers
Careers
Partners
Partners
Consulting Alliances
Consulting Alliances
Solution Provider Partners
Solution Provider Partners
Software & Cloud Partners
Software & Cloud Partners
Business Process Outsourcers
Business Process Outsourcers

Is It Possible to Achieve Fully Automated Bank Reconciliations?

image

The vast majority of organizations, irrespective of their size, industry sector, or geographic location, spend significant amounts of time manually checking and matching transactions, and preparing and posting journals to complete their bank reconciliations.

Depending on the requirements of the business and the associated transaction volumes, these activities will be undertaken on a monthly, weekly, or even daily basis.

Many organizations have implemented spreadsheet-based solutions to assist with the transaction matching element of bank reconciliations. Others use built-in functionality and add-on modules available within their GL system to automate certain aspects of the matching process, and in some cases, associated journal creation.

However, very few organizations (if any) could say that they are able to achieve anywhere close to 100% automation of the entire bank reconciliation process.  There is always a degree of manual intervention required.

Robotic Process Automation

One of the hot topics that appeared in 2016 and is still dominating the headlines in the business and finance press today is Robotic Process Automation (RPA).  In summary, RPA refers to the use of computer software that controls and automates rules-based processes without the need for human supervision.

Based on this definition, the suggestion is that a solution that utilizes RPA functionality should be able to automate the complete end-to-end bank reconciliation process without the need for any manual intervention.

So is this really a possibility?

Over the years, we at Eclipse have worked with many different organizations, helping them to streamline and improve their business management and associated financial close processes. During this time, we have been unable to identify a single integrated solution that provided the capabilities to fully automate the reconciliation process—until now.

Financial Close Management

Recently, we have been working with a fast-growing international retail organization to implement the BlackLine Financial Close Management solution.  In addition to improving their overall balance sheet reconciliation and controls process, one specific objective was to significantly reduce the amount of time spent completing their daily bank reconciliation processes.

Key information and points to consider when planning how best to automate the bank reconciliation process and eliminate unnecessary manual intervention:

  • 400 stores (and growing) across multiple geographic regions in different time zones

  • Goods purchased using a combination of cash, check, credit and debit cards

  • Stores bank cash up to 3 times a day (directly to bank or via 3rd party collection agency)

  • Vendor payments made on a daily basis using various payment methods

  • EPOS system feeds GL overnight with summary values by store and payment method

  • Bank statements files available for download on daily basis

  • Daily bank reconciliations required

  • Journals created and posted manually to each entity/account and where required, analyzed to the individual store for items not present in the GL including:
    undefinedundefinedundefinedundefinedundefined

Using the latest release of BlackLine, we were able to configure the following five processes:

Upload unreconciled bank transactions from GL and daily bank statements into BlackLine

Automating the upload of bank transactions from the GL and bank statements to BlackLine was straightforward, and achieved by using a combination of standard operating system and BlackLine scheduling tools.

Reconcile 90% of transactions

Using the BlackLine Matching solution, we were able to configure a flexible set of rules which automatically reconciled 90% of transactions that were perfect matches.

The remaining 10% comprised a combination of partially matched transactions with variances (E.g. cash sale variances, commissions/charges deducted) and a group of unmatched transactions present in the bank statement, but not in the GL (E.g. bank charges, direct debits, standing orders).

Generate GL posting file

Creation of the journal adjustment file for upload to the GL was achieved using BlackLine's Automated Journal Definition (AJD) functionality.  The flexible filtering and grouping options available within the AJD enabled specific transactions and groups of transactions to be identified and used as the basis for generating journals for subsequent posting to the relevant entity accounts, and store within the GL.

Posting of journal adjustments to the GL

Once authorised, the Adjustments Journal is automatically moved to an SFTP site and subsequently uploaded to the GL using a combination of standard operating system and BlackLine scheduling tools.

Re-extract and upload unreconciled transactions from GL to BlackLine/rerun matching process

Once all journals generated in the above process are posted to the GL, the unreconciled transactions are re-extracted from the GL and uploaded into BlackLine as per step 1 above, and the Transaction Matching process is re-executed.

The only manual step in this process, to review and authorise the journal generated in step 4, could be removed if required, thereby making the reconciliation process fully automated.

Continuous Improvement: The First Step to Continuous Accounting

Over time, we would expect exceptions that require the creation of additional automatic journal definitions to be identified during the matching process. However, this would be part of the day-to-day system maintenance to ensure continuous process improvement.

Adopting an automated approach to bank reconciliations could be an easy first step to implementing a Continuous Accounting mindset across your organisation.

Read this ebook to learn how to take your organisation to the next level with a Continuous Accounting approach.