Making Sense of Transaction Matching: How SAP Financial Close Solutions by BlackLine Enhance SAP Innovations
Elizabeth Milne, Accounting and Financial Close Expert, SAP
Molly Boyle, SAP Solutions Expert, BlackLine
I hope you’ve enjoyed our series so far discussing how SAP Solution Extensions by BlackLine complement SAP solutions. See the end of this blog for a link to our other blogs in this series. In this blog, we’ll discuss scenarios involving matching and reconciling high volumes of transactions and highlight how SAP Financial Close Solutions by BlackLine complement and extend other SAP solutions.
What Is Transaction Matching, Anyway?
Balance sheet substantiation, manual journal entries, and task management tend to get a lot of attention when it comes to the month-end close. One challenge not as commonly discussed is the substantiation of high volumes of transactions. Specifically, how balances in certain general ledger accounts are made up of hundreds of thousands of individual line items that must be reconciled against other data sources to be substantiated. Note, as per our earlier blog, Understanding the many applications of “Reconciliation,” many non-accountants will equate “account reconciliation” with “transaction matching.” There’s some serious semantics going on here, so note the nuances.
Despite the other critical tasks on their plate, accountants often spend a significant amount of time downloading data from disparate sources, aggregating millions of rows of detail in spreadsheets, and attempting to reconcile items using complex formulas, v-lookups, or color coding (often called rainbow spreadsheets), and other error-prone processes to identify errors, exceptions, or reconciling (unmatched) items that require follow-ups or adjusting entries. This is the challenge of transaction matching.
SAP ERPs and SAP Financial Close Solutions by BlackLine have functionalities to automate and de-risk the traditionally manual methodologies. Let’s explore them.
SAP Matching Solutions
As we discussed in our earlier blog, one of the benefits of SAP S/4HANA’s Universal Journal architecture is its elimination of some basic reconciliation, or matching, scenarios like reconciling sub ledger details to the general ledger. For those organizations not yet running SAP S/4HANA, SAP ECC offers standard reports to help facilitate the reconciliation of data within the ERP. Subsequent steps, which are typically manual, are then required to identify errors or make adjustments.
Beyond standard sub ledger to GL reconciliations, SAP has robust transaction matching capabilities for some specific and complex use cases. First, using machine learning capabilities, SAP Cash Application solution learns from accountants’ past manual actions to apply payments to open invoices.
This intelligent receivable matching helps companies lower days sales outstanding and free accountants from manual work. In addition, SAP Goods and Invoice Receipt Reconciliation provides transaction matching functionality to optimize and clarify the SAP open items derived from the purchasing process.
A Flexible Extension of the SAP ERP
While the ERP is the system of record and the general ledger and related sub ledgers contain important financial data, critical information for reconciliation and substantiation lives outside the ERP. Other data sources might include bank detail, point-of-sale systems, credit card detail, payroll or HR systems and more. And disparate ERP landscapes pose additional reconciliation challenges.
To extend SAP’s intra-ERP functionality, SAP Financial Close Solutions by BlackLine have robust, flexible transaction matching that support a variety of use cases and allow for reconciliation of information from any data source – including those outside of SAP. These solutions can handle robust logic, complex data relationships (e.g. one-to-many and many-to-many), and fields outside the ERP.
The transaction matching functionality in SAP Financial Close Solutions by BlackLine is flexible, business owned, and fully integrated with other processes such as balance sheet substantiation and journal entry management. When needed, users can easily create reconciling items within an account reconciliation or create an adjusting journal entry for posting, allowing for end-to-end automation and auditability across a variety of business processes.
More Time to Focus on What Matters
With the advanced rules-engine provided by SAP Financial Close Solutions by BlackLine, organizations have matched millions of transactions in seconds or minutes. The solutions identify exceptions and suggest matches, which help focus accountants’ attention on potential risks and adjustments, freeing them up from the manual “rainbow spreadsheets” to which they’re often accustomed. Adjusting journal entries and clearing documents can also be automated and posted directly to SAP and non-SAP ERPs, and reconciling items are automatically incorporated into the balance sheet substantiation process.
Want to learn more about SAP Solution Extensions by BlackLine? Check out:
A Blog Series to Answer Your Questions
There are a number of common questions about BlackLine and SAP and how our solutions work together. We’ll be writing blogs over the next few weeks to cover them, here’s what we have so far:
- SAP & BlackLine: Improving the End-To-End Financial Close Process, Together
- Understanding the many applications of “Reconciliation” – How SAP Financial Close Solutions by BlackLine Complement SAP S/4HANA | SAP Blogs
- How SAP Financial Close Solutions by BlackLine Complement an SAP Central Finance Deployment | SAP Blogs
- The Universal Journal and Journal Entry Functionality in SAP Financial Close Solutions by BlackLine Explained | SAP Blogs
- Making Sense of Transaction Matching: How SAP Financial Close Solutions by BlackLine Enhance SAP Innovations | SAP Blogs
- Managing Financial Close Tasks: An Ideal Combination of SAP Solutions | SAP Blogs
- How SAP Solutions Enable Stronger Controls and Compliance for Finance | SAP Blogs