Common questions about Account Reconciliation and Reconciliation Software

• Why Is the Bank Reconciliation Process Difficult?

  First, it’s about time: Bank transaction matching, line by line, is a thankless time-consuming task to complete. Worse, when exceptions are found, the analyst (or other designated treasury authority) has to search and hunt down people, reports, payments and/or invoices—often desk by desk, spreadsheet by spreadsheet —to determine the cause of the discrepancy. Given the variability of scenarios and reporting —understanding which financial data is needed and with what kind of handling—it’s nearly impossible for even the most determined of analysts to find, remember, and apply, the appropriate exception rules and deliver what is needed to the business for automated account reconciliation.

  A company’s financial close is typically a very repetitive and overwhelming task with accounting teams spending hours each day reconciling the general ledger balances with information from the bank statement. Typically, there is a rush to close the books at the end of the month to begin all over again and get going on the next month. If the company is managing this process in spreadsheets, they are importing bank transactions data from their accounting system or ERP and pulling statements from bank portals manually. The analyst will take the list of transactions and begin to comb through the bank data one by one. This means that the process is prone to errors, like mistyping and accidentally adding extra digits, which are not easy to track.

  For companies with more automated solutions where general ledger entries are exported from the Enterprise Resource Planning (ERP) system, and import bank transactions from a separate solution to compare to the bank statement, this means that there are extra steps involved before the team can begin the bank reconciliation process. Most companies have multiple bank accounts across multiple financial institutions, further complicating the process.

  Automatic reconciliation software using advanced machine learning will help them make sure they have a documented review and approval process and help them address any discrepancies in real-time instead of waiting until it becomes a major problem.

• What Are the Current Bank Reconciliation Work-Arounds?

  Without bank reconciliation software, account reconciliation software, or accounting reconciliation software, analysts and/or accounting personnel must perform their work manually using archived emails, saved documents and binders of support references across multiple bank accounts, typically across multiple bank partners. Accuracy and consistency are compromised by variations in individual approaches and lack of an automated way to manage and apply exception rules.

  With embedded SAP applications one does not need to export any data out of the ERP and into a spreadsheet or any other third-party system in order to run the accounting reconciliation process. They will be working off the most up to date general ledger information. Since FinLync’s world class reconciliation software connects to the banks in real-time via APIs, that means that companies are able to do a reconciliation process throughout the day.

  They will be able to catch discrepancies as they happen. Since all the bank data is the most accurate, latest information, they will have ability to drill-down to the details. This is something they can’t do if exporting to a third-party vendor like another accounting reconciliation system or a TMS. This gives them full transparency/visibility to be able to address any data discrepancies more easily instead of going on a hunt to track where the error occurred.

• What Should You Look for in Reconciliation Software?

  For payment reconciliation and accounts receivable reconciliation among multiple banks and bank accounts, the software must be embedded in your ERP for maximum accuracy and efficiency, and minimal risk. Embedding the app minimizes the number of connections necessary for importing and exporting data, and allows teams to work simultaneously with the most up-to-date information across the enterprise, reducing delays. Direct ERP connectivity brings real-time data into play, allowing treasuries to work off the most up-to-date information available, whenever they need access to it.

  Look beyond the basics. Automation, including machine learning or a rules-based approach, allows your system to learn from past events. Over time, the quality of predictive analytics improves, allowing the system to make more bank transaction matches over time, and to make informed recommendations when an exact match is not found.  The iterative process improves the accuracy of the predictions by the solution, so that there are less discrepancies over time that treasury and accounting need to manage. With a user-friendly, and intuitive design, the accounting reconciliation process in FinLync’s world class reconciliation software creates automation and flexibility allowing users to focus on higher value functions instead of basic matching of transactions from your bank accounts. The labor-intensive function of manually matching bank transactions will no longer be a drain on human capital. Bank reconciliation will go from a big month-end event to a more manageable and palatable ongoing process.

• Do FinLync reconciliation tools work with credit card reconciliation?

  As the best bank reconciliation software, FinLync doesn’t just import bank transactions – FinLync’s reconciliation app also delivers data from customers or card and merchant acquirers like Visa, PayPal and Klarna – directly into your SAP. This credit card reconciliation and other 3rd parties makes collecting and applying settlement and remittance data easier and faster.

• How does FinLync handle bulk bank deposits?

  FinLync’s reconciliation tools automatically match bank transactions including bulk bank deposits with multiple billed items from retail and ecommerce channels. As the best bank reconciliation software, FinLync captures detailed remittance and settlement information that comes from with card and merchant acquirers.