Blog

Bank reconciliation is one thing that companies cannot function without nowadays, mainly because there is hardly a business that does not interact with financial institutions. While bank reconciliation is needed and wanted in order to assure control and healthy finances, it is also tedious to a level that often discourages and leaves you drowned in details that obscure the original intent of the whole process. It is a daily routine for thousands of companies and people around the world and a heavily regulated reality for a number of financial institutions and organizations. We, at ReconArt, have seen every bit and piece of the process and have worked hard to find a solution to the old and new problems faced by our clients when it comes to bank reconciliation. Bank reconciliation, by definition, is supposed to be straightforward. It is simply the process of matching the transactional data coming from a bank statement with the relevant internal company data (retrieved from the cash account). The aim is to verify that each transaction in the bank statement is consistent and comparable to the internal records as presented in the company’s accounts. So where are the problems coming from and why companies end up with a list of complicated, time-consuming activities to perform? The reasons are various but the main issue stems from the fact that they usually occur simultaneously to completely mess up the data and make the matching particularly complex and prone to errors. A number of banks, a number of accounts, a number of currencies – companies usually use more than one bank for different processes and transactions. Transaction Banking Survey 2016 shows that only 7% of corporates have chosen to work with only one banking partner. Sometimes the bank is the same but there is still a set of accounts to serve different purposes and provide for better visibility. Then come the different currencies used for the accounts and the number here can start from just a few and reach double digits. Finally, it turns out that the bank statements received for the purpose of reconciliation are numerous and certainly not easy to compare with the internal records.Different formats – living in a digital world and having a bunch of different systems and applications makes work much easier, however they produce output in various formats even when we look at internal data only. When external sources are added to the picture, the number of formats grows further and the comparability is immediately reduced. In bank reconciliation this is an issue faced by every business, no matter of the size and industry. For instance, probably the most common financial data communication standard globally is the SWIFT family, such as MT and MX messages. But depending on geography and industry specifics, a business may source banking information in ACH, FIRDS or BAI formats, among many others.Volumes and timely processing– in some cases the bank reconciliation itself is not that difficult to perform as the input data is of good quality and the principles are simple. Then another issue arises – the volumes to be matched. Hundreds and thousands of transactions pile up daily. These need to be reconciled timely and correctly and once this is completed, the resulting exceptions need further attention, processing and resolution. It takes a huge amount of effort if done manually and requires utmost attention and preciseness at every step. So far what is described depicts the actual situation for most companies but focuses mainly on the process limitations and the issues that emerge from the initial setup. Another huge area of challenges is the quality of the data and the reasons for having unmatched transactions. As ultimately the goal is no variance and no outstanding items, the fact that a big number of data entries cannot find a pair is even more bothersome and has to do with a whole new bunch of reasons. Time differences – it is not unusual that transactions are not reflected timely in the bank statements or in the internal systems, especially around period end. This certainly leads to unmatched items.Charges/fees that alter the amounts of the transactions – it is common that fees are applied to transactions either by the bank or other intermediaries along the way and are automatically added to the transaction amounts. That, however, hinders the matching process as the sum in the bank statement cannot be paired with the one in the internal records.Different currencies in the bank settlement and the internal system – when a company opens an account in one currency but receives payments in other currencies that immediately leads to mismatches between the bank documents and the internal systems. Getting to link those completely different figures is quite of a challenge.Bulk amounts in the bank statements – sometimes transactions are aggregated and presented in the bank statements as bulk amounts instead of individual records. Matching such transactions requires advanced analysis.Complex transaction relations – complicated internal processes and various data sources inevitably lead to intricate transaction relations of different kinds - one-to-one, one-to-many, many-to-many. Dealing with such cases involves sophisticated logic. Having in mind all these challenges, it is clear why bank reconciliation requires a good deal of attention and effort to do it correctly and get reliable results. After all, at period-end all transactions need to be reconciled and all exception items resolved. That is why most companies decide to use specialized tools for the purpose and to automate as much of the process as possible. The added value of choosing this option is huge and spreads across a number of different areas. ReconArt™ is a solution designed and developed to suit perfectly any reconciliation need, no matter of the industry, the company size or the volume of transactions. Bank reconciliation is one of the main areas where our clients require help and therefore we support the process for almost each of them. We have gained vast knowledge and experience in the field over the years and have the capacity to handle even the most complicated cases, not only because we provide the right technology but also because we offer expertise with the processes and best practices. A few particular features of ReconArt™ make a difference in the world of reconciliation tools and assert its suitability for bank reconciliation. The powerful matching engine – ReconArt™ is built around the matching engine so it offers close to endless capabilities to reconcile – huge volumes , complex relationships, any type of data (numeric or not) and tens of sources and formats are handled flawlessly by the tool. Our clients reconcile thousands of transactions daily and this is not a real challenge as ReconArt™ is designed exactly with these features in mind. In this way, naturally, most bank reconciliation issues are resolved.It is the users themselves who can easily create the matching rules and update or change them immediately when required. ReconArt™ is business user oriented and very intuitive so it eliminates the need for constant change requests and the whole change management process is owned solely by the users. This adds а good deal of speed, self-sufficiency and flexibility within every process to be handled and this is also valid for bank reconciliation.The automation – everything can be automated with ReconArt™– the import, the data enrichment, the reconciliation, the exceptions management and the export are scheduled as required and performed by the system. Nothing is left for manual handling apart from the items which require further investigation or particular actions. For most of our clients that makes the biggest difference. Rob Harley, Director of IT in Rain City Capital gives a good summary of what has changed with the implementation of ReconArt™: “Today, we come in in the morning and run an auto match, do a couple of manual operations, and we’re done with the reconciliation for the previous day. It takes us about 15 minutes. This used to be a 50-hour effort once a month before, so we’re in a great place.” ETL capabilities and integration– because of the advanced ETL features integrated in the tool, any transaction complexity can be overpassed. Moreover, it provides room for alternative options and flexibility. Bank reconciliation is exactly an area where problems and limitations can be overcome with solutions that offer freedom for data modifications and optimizations at basic level. ReconArt™ allows for extraction, intuitive data enrichment, transformation and further use and upload so that neither the input data, nor specific output requirements obstruct our client’s work. ReconArt™ can be integrated with existing ERPs or other legacy systems – with some of them full integration is already developed and with others it is based on file export and import.Complex analytics and auditability – when the reconciliation process is designed to comply with best practices and the data it produces is reliable, that leads to a number of other beneficial outcomes, audit readiness and visibility above all. The configurable workflows guarantee transparency at each step of the process. The reporting features that come with ReconArt™ provide an improved insight into the organization’s financial position and allow for further analysis and actions when risks are identified. Reports are preset or configurable and cover data from all modules, as well as at system level. Errors, dependencies, and deficiencies pop up at a glance. Having at hand a good statistical overview combined with granular audit trail is the final step that completes the bank reconciliation process. After all, any obstacle in bank reconciliation can get its relevant solution – provided you are equipped with the proper tools and knowledge. The extensive expertise and the constant feedback received from our clients serves for further product development. This empowers the ReconArt team to come up with a superior product with full-blown reconciliation functionalities catering for any need and every complexity. This proves to be very reassuring for both our clients and our experts. ...

Industry Overview Payment services and their evolving online and mobile cash transfer channels have emerged as a flourishing industry. People across borders connect and engage in trade exchange with increased convenience. The payment platforms facilitate B2B, C2B and increasingly so P2P transfers, both domestic and international. The latter represent a significant portion of the world capital transfer volumes.  Foreign remittances stand out as a particularly important part of the national current account of labor exporting destinations. In some developing countries, remittances even outpace foreign direct investment (FDI) inflows. Global remittance flows in 2014 amounted to $583 billion. In 2017, they reached $613 billion and are expected to inch up to $642 billion in 2018, the World Bank reckons. The role of each of the payment industry players requires overcoming infrastructure obstacles, penetrating diverse environments and tackling challenges concerning service speed and security. On top of technological problems to be solved, there are F&A as well as legal & compliance aspects of this high-friction business. All-time present risk can manifest itself in plenty of circumstances such as short transaction lifecycle, high volumes, cross-border jurisdictions & regulations, currency risks, pressure to slash service fees, a long chain of collaborating stakeholders and the accompanying mutual dependence. A BI Intelligence report shows that 94% of the remittance transfers are cash-based. However, a distinct tendency towards money wire service diversification and expansion is observed – both in terms of volumes and digital adoption. In the domestic US market alone, mobile P2P payments started off modestly with $5.6 billion compared to the general P2P segment worth $540 billion in 2014. However, it is forecasted to reach the $174 billion mark in 2019 and to contribute a third to the US P2P turnover. Online and mobile P2P transactions are driven by social commerce at national level, but will increasingly witness adoption in cross-border money wires. In the past several years, a transition to digitalization of the remittance sub-sector is observed. While the legacy platforms involve physical presence of the remitter in front of a kiosk and deposit in cash to be wired, technology now opens payment services to security, mobile and e-commerce innovations. Start-ups are springing to address this rising demand. The majority of them report intensive growth, which subsequently puts control over operational adequacy higher on the agenda. As a result, reconciliation in this industry is a major aspect of sustained accountability and regulatory consistency. With some modifications, the general mechanism of remitting abroad involves four parties: The payment operator interfaces with the remitter via an online application – desktop and/or mobile. The client (remitter) can choose from pay out options with a bank card, bank account, his account with a third party online payment platform, digital wallets (aka mobile money), etc. The payment operator then takes the transaction to the local correspondent - a resident bank within the location of origin. The local correspondent liaise with a money transfer operator, which has the responsibility to procure cash in the destination location. The local distributor is the point of contact for the beneficent, and here the latter can opt for bank account deposit, mobile money or airtime top-up, etc., in addition to the conventional cash pick up. Obviously, a cross border money wire, big or small, calls for the collective effort of a multi-party cohort and generates a series of transactions in the backend. The remittance platform handles data from numerous data sources and is liable to growing in number and complexity reconciliation tasks. As the global network coverage of payment operators expands and their foreign partnership interactions intensify, bank statements reflecting these partnerships multiply in the queue. The settlement is performed in batches. Apart from the net sum wired, several service fees and commissions are deducted by the intermediaries down the line. Also, currency differences are incurred. All these items need to be reconciled in a swift and accurate manner, in order to avoid month-end close bottlenecks. ReconArt’s Experience ReconArt has the opportunity to work with clients well established in the remittance space and has gained valuable expertise in the field. WorldRemit has coverage in 145 countries worldwide with 0.5 million cash transfers handled monthly. InstaReM operates in 55 countries in the burgeoning Asia-Pacific market with a special focus on India. The company also manages bulk payments to multiple beneficiaries in multiple currencies and its network encompasses 8000 banks. TransferGo has footprint in 47 countries serving both consumers and business reaching 1 million transfers per year worth about half a billion GBP. The company is bracing for expansion in China. The different players have specifics in their reconciliation processes. In the traditional mechanism, service fees are generally higher and the whole process – more sluggish. Online payments mean lower fees and faster delivery but also implies a more complex reconciliation process. Formats inevitably vary and the file import itself requires a lot of manual work in the absence of an automated method. Further, files enrichment and transformation prior to the matching itself is laborious and error prone, compromising the integrity of the input data. Cash in transit needs to be accurately reflected in the accounting systems and consequently verified against the bank statements. In addition, reconciliation requirements in the remittance industry may also pertain to non-financial data such as personal identification data. Our clients are among the top 10 global providers in the online remittance ecosystem and demanded technological solution that would address the challenges of a fast paced, highly competitive environment, and skyrocketing transaction volumes. The spreadsheet framework used as a legacy method of reconciliation was not nearly sufficient for their needs. They were scouting for an agile, scalable, ERP agnostic tool that would seamlessly and painlessly integrate with their current systems. Scalability and room to grow are cited among the primary drivers to leverage the ReconArt solution. The matching engine and its critical mission to bolster internal control of incoming and outgoing transactions was the second major requirement. User friendly interface and rule based end-to-end reconciliation are among the immediate benefits observed by the clients. Automated journal entries following the matching stage provided an agile interlock with the incumbent accounting system. Another high priority product capability is period-end balance sheet reconciliation and certification. We pride ourselves at listening closely to our clients’ needs and embarked on ReconArt™ product augmentation – the bridge between the matching engine and the certification panel saw dramatic improvements as a result of client recommendations. Another desired client benefits that ReconArt™ successfully implemented was analytics dashboards visualizations with cross sections of outstanding items, planned versus actual balances, and historic data at the users’ fingertips. Our clients welcomed the cloud deployment of the ReconArt product because it enabled them to integrate the reconciliation process at company level with multiple user locations at hand – a feature with direct contribution to consolidated reporting, compliance and enhanced visibility appreciated by the management team. The implementation time frame varied depending on the complexity of the reconciliation process each company had embraced. Together, we successfully tackled challenges such as calibration of ReconArt™ for huge inventory of data formats. User training was carried out with no disruption of the day-to day business. Just the opposite – clients reported substantial time savings. Clients moved up the learning curve pretty quickly, with implementation of new processes and the incorporation of new matching rules in the existing framework. In cooperation with the implementation team, clients managed to clear the backlog of outstanding reconciliation tasks from previous years, and upgrade import templates, thus utilizing the full potential of the system with increased confidence and independence. Flexibility, striving to perfection and adaptability to evolving client business requirements are our primary objectives. Our ethos is solving problems with mutual understanding and ambition to perform with zero compromise. ...

When most people hear “reconciliation” they usually think of the direct meaning of the word i.e. “to bring together again” or “to make friendly again”. Even when you open a dictionary, the first explanation is “to find a way in which two situations or beliefs that are opposed to each other can agree and exist together“. Indeed, this is the initial meaning that originates from mid-14c. Some half a century later, the word is already used also for “making consistent” and these two notions cover the wide understanding about reconciliation. However, mention “reconciliation” to someone in finance, and it would evoke a completely different picture and flow of thoughts. Spreadsheets, financial statements, accounts, balances, general ledger, exceptions, rows and rows of data will immediately pop up and replace any other interpretations. No wonder, as reconciliation in Finance is a whole different world to care and worry about. So what is reconciliation in the world of F&A? This is the process of comparing different sets of data in order to check and confirm that they have the same totals or pair in a specific, predefined way. In other words, the process ensures that records from two or more sources are correct, comparable, matching. This reassures the validity of the transactions and the accuracy of the company records. When reconciliation is performed, balances are confirmed for separate accounts and further transferred to the General Ledger. If discrepancies are found, these are noted and investigated. Reconciliation can be done daily or at period end but should be always consistent in order to produce reliable results. Whether the definition sounds clear or not, the best way to understand reconciliation is by taking a closer look at what is really reconciled. The most typical types of reconciliation provide good examples of how companies actually do it and why. Let’s explore each of these in more detail. What is account reconciliation? Account reconciliation is where it all starts from and nearly all other types of reconciliation refer to it in some way. This is a process of verifying that account balances are correct by comparing two sets of records at the end of a particular accounting period. Discrepancies are identified and adjustments made to the account as required in order to report the correct values in the General Ledger. What is bank reconciliation? Bank reconciliation (or bank statement reconciliation) is the process of matching the transactional data coming from a bank statement with the relevant internal company data (coming from the cash account). The aim is to verify that each transaction in the bank statement is consistent and comparable to the internal records as presented in the company’s accounts. This process can get very complicated because of the difference in time when a particular transaction is recorded in the bank and in the company. Often adjustments are needed. Other complications can arise from differences in currencies and data formats, as well as potentially huge transaction volumes. What is credit card reconciliation? The process is very similar to bank reconciliation and carries much of its challenges, but with an additional twist. It refers to matching transactions in a credit card statement with an associated transaction within various internal financial records. Very often there are multiple steps involved (e.g. match card statement to POS, and then aggregate results to the bank). It is usually the volumes and the variety of sources that cumbers the process and causes anxiety among accountants and financial controllers. What is positions reconciliation? Positions reconciliation is the process of verifying that a company is holding the same number of securities that a counterparty states they are holding for that company. The balances of the two sources are reconciled in order to make the verification. This is also known as Holding Positions or Balance of Holdings. A main challenge in this activity is usually the lack of universal security identification. A variety of security IDs depending on geography, stock exchange, and type of instrument makes the comparisons between two or more sources very difficult and time consuming. What is custodial accounts reconciliation? Reconciling of each custodial account (i.e. P&I and T&I) means matching amounts paid and received on instruments held electronically with custodians to any internal statement. It is a process done regularly by banks to verify the accurate reporting of any operation with financial instruments. Again, a number of complications arise constantly starting from the increased trade volume and the various custodian banks and sub-custodians to be handled. Moreover, this is an area heavy with administrative requirements and regulations. What is POS (Point of Sale)/Merchant/Gateway reconciliation? This type of reconciliation is done to confirm a company’s internal records correspond to what is being recorded by the POS, Merchant, or Gateway system. In addition to ensuring that internal records are correct, these reconciliations also provide evidence that customer orders and payments are recorded correctly. Again, the main challenges come from the multiple systems that process the sales information (for example from online sales vs physical locations) and the different file and data formats used by each source. What is balance sheet reconciliation? Balance sheet reconciliation and attestation is probably the most important part of the period-end close for a company, especially those that are public, multi-national, or in heavily-regulated industries. It consists of confirming the accuracy and integrity of all key account trial balances by explaining each balance and if required, substantiating it with additional entries, document attachments, and explanation notes. Often times, there are sub-ledgers involved (containing a sub-set of transactions that explain the trial balance) which may be available in completely different data formats. The whole process can get very painful with multiple sources of data, hundreds or thousands of accounts, and dozens of people with interdependent tasks coming into play. Usually this is accompanied by time pressure and the need of full consistency and auditability of the records and operations performed, as the balance sheet reconciliation of public companies is subject to government regulations. What is suspense account reconciliation? A suspense account is an account that supports the reconciliation process. It is used to temporary store transactions that need further investigation before they can be classified correctly in the corresponding account in the GL. Suspense accounts are useful as repositories where transactions can be posted in the books as quickly as they occur but can remain there until sufficient information is available to confirm the correct further destination of the record. Ideally, suspense accounts should be cleared as quickly as possible by reviewing each individual transaction. Just like all other accounts, the suspense account needs to be reconciled at the end of each accounting period and if not balanced, the discrepancy requires further investigation. This may all sound complicated, unnecessary or bothersome but actually reconciliation is a natural process that takes place in every company and in any industry. It used to be time-consuming and error-prone but this has changed tremendously in the last decade. Now, there are specialized tools that handle reconciliations quickly and easily, and moreover, automatically, leaving nothing more to the manual effort but the exceptions investigation. One such tool is ReconArt, a modern, flexible, web-based and rich in functionality software that is directed towards the business user. By using such a tool all reconciliation needs are covered and it is no more a pain to do the matching but an efficient process to support compliance, auditability and cost optimization. After all, from the Latin “reconciliare” (bring together) to the modern “reconcile”, if something is reconciled, this means it has been settled. No matter if we are talking about good family relations or cleared bank transactions....

In a world of infinitely deepening specialization, terminology develops in pace with evolution of technologies and inevitably requires special attention. One needs to familiarize himself with the modern industry slang first, in order to get a meaningful insight into the professional field about to be examined. The finance & accounting business is no exception. New vocabulary is introduced continually to reflect process innovations that come to life. Professionals certainly need to keep up to speed with the most recent developments, but the first step is catching up on the terminology. Here are the most frequently used phrases in the blooming reconciliation software space. You will notice it’s common to come across familiar words in unusual combinations. Often terminology is tied to the software platform employed by a respective company and varies from system to system, although the processes referred to are essentially identical for all companies. At ReconArt we know that words convey ideas, and ideas spark innovations, so let’s develop a baseline for key terminology and basic understanding: 1. Transaction Matching – Comparing transactions from different data sources and bundling them together based on predefined criteria. The primary objective is to identify transaction discrepancy or to discard the possibility thereof. Ticking them out as related to each other means that the internal record and the counterpart record of the same logical event are in agreement. That is often done manually or in a spreadsheet framework which is time-consuming and likely to produce errors. ReconArt™ features a state-of-the-art matching engine with wide ranging capabilities to automate fast, reliable, rule-based sorting out of millions of transactions. Potential inconsistencies are classified accordingly allowing users to focus on their further investigation and resolution. 2. Outstanding Items – These are unauthorized or erroneous transactions or unsettled items which have not found their rightful match yet. Identified excessive variance between two matched items could also be the case. These types of situations are important. Records that failed to be matched based on the listed rules could possibly expose fraudulent or neglectful activities. It might also indicate a benign occurrence such as a delay in the booking of the payment for a certain open invoice. Keeping a good inventory of outstanding items, their origins, their expiration period, their urgency, as well as their destination once a resolution has been found – it is an essential part of the robust reconciliation process. 3. Exception Management – A set of measures to organize the handling of outstanding transactions (exceptions) based on their origin or impact. Reconciliation tools, and ReconArt™ in particular, enable items to be addressed as single exceptions or managed as groups of similar type of transactions. The resolution of exceptions must be accompanied by a granular audit trail in order to justify its legitimacy following a diligent investigation. 4. Transaction aging – Understanding how transactions flow and settle over time is important. Transaction age and status are key components in this understanding. Modern reconciliation solutions should provide a capability that allows calculation of the transaction age depending on a configurable formula and set determinants – origination date, resolution date, current date, or the period end date. An outstanding transaction which dates back past accounting periods should be red-flagged, in order to be monitored and properly investigated prior to resolution. 5. Breaks – Breaks are exceptions or outstanding items resulting from comparison between broker data and internal accounting data. Breaks are encountered in position reconciliation, too, where the comparable balances originate from more than two independent sources. 6. Certification – The certification of accounts is a Balance Sheet or Financial Close related process. It comprises a set of procedures executed by users with designated certification roles. At the final tally, the line items of two balances pertaining to the same reporting period have to be compared and agree with each other to be duly substantiated. With ReconArt™, adherence to certification policy is guaranteed with documentation of applicable outstanding items, explanatory notes, and any supporting documentation attached. 7. Workflow – One of the great features of reconciliation tools is their ability to facilitate team collaboration. Configurable workflows arrange user tasks in line with predefined principles, schedule, access levels, approval hierarchy and target outcomes. For instance, the certification procedures checklist within the ReconArt™ is automatically distributed among the authorized users, thus prompting them to take action in compliance with financial regulations. Period-end close campaigns also run on a sequence of recurring action items. ReconArt™ provides templates for their completion in a timely manner and with strict separation of duties. 8. Audit Trail –ReconArt™ maintains a fully transparent record of activities allowing transaction detail drill down with exquisite granularity. Manual and tech-challenged approaches to reconciliation do not provide the level of transparency and detail needed to maintain a proper audit trail. With ReconArt™ every single operation from source to resolution, every user involved, every related accounting record are duly mapped, well visible and accounted for. This transparent set-up is particularly convenient in times of audits, when solid evidence for process consistency and detail must be produced swiftly. 9. Variance Analysis – Variance analysis concentrates on the differences between expected and actual values. Counterintuitively, apart from the ideal zero variance, reconciliation software systems can be calibrated to accept greater variance tolerances, without arbitrariness or contradiction to sound business logic. Moreover, the quantitative analysis can encompass consecutive periods, establish patterns, and enclose supporting documentation. Follow-up can be thus automated. 10. ETL functionalities in reconciliation - ETL stands for Extract, Transform & Load and involves on-boarding source data. In the ETL process data can be extracted from numerous databases and applications, transformed into the appropriate form and then loaded/sent it to another system to support a business process. ETL functionality is widely applicable in reconciliation systems and is part of ReconArt’s™ DNA. Of particular benefit, recurring processes can be automated. Tasks can be scheduled in the right sequence via an intuitive scheduler. This process can be configured to create journal entries that can be transferred automatically to the General Ledger following approval flow. ETL also plays an integral role in analytics. 11. ERP or GL-agnostic – A generalized software which is in position to exchange information with different systems and can seamlessly integrate with other platforms, including third party ERP and GL software and subsidiary systems. The ERP/GL agnostic system is flexible enough to function in a variety of environments. Regarding data reconciliation, this property translates into added value for both the ERP vendor and its adopters. ReconArt™ is designed with technological synergy in mind, all geared towards advancing client success. Certainly, the terminology list above is by no means exhaustive. In upcoming publications we will continue discussion on the subject, revealing other aspects of reconciliation and the groundbreaking process improvements introduced by ReconArt™. Stay tuned for: what data reconciliation is in its essence, what types of reconciliation you should be aware of, and what application our solution has in different business domains. ...

What does ReconArt for NetSuite mean? The simple answer would be: Managing and Automating your Reconciliations while NetSuite is your ERP system. A more elaborate answer would be: NetSuite works the way your business works, built from the ground up to the cloud. NetSuite manages your business process and integrates your company’s financials, supply chain, operations, reporting, manufacturing, and human resource activities. However, no ERP can do it all – and Reconciliation is an integral part of contemporary accounting and finance that needs special attention. Whether bogged down with millions of transactions, having difficulties processing specific bank formats, experiencing deficiency in digesting common ERP financial data, struggling to reconcile the accounts, or not being able to demonstrate an auditable balance sheet reconciliation process, the common thought among finance professionals using ERP systems is “There has to be a better way”. NetSuite clients do not have to miss the reconciliation mark. This “Better Way” for NetSuite clients is ReconArt for NetSuite - combining all the benefits of #1 Enterprise Resource Planning Cloud Business Software – NetSuite, with #1 Fully Web-based Cloud Reconciliation Platform – ReconArt.   How it works? The best of both worlds, integrated into one, is achieved as part of SuiteCloud Developer Network (SDN) Partners – the “Built for NetSuite” program. ReconArt team designed and developed a communication bridge integrating ReconArt and NetSuite Systems. ReconArt for NetSuite allows NetSuite customers to establish the highest degree of automation, best practice, control and consolidation of some or all reconciliation processes, like any type of transactional matching, positions & holdings reconciliation, balance sheet account reconciliation and even non-financial data recons. The integration incorporates all stages of the reconciliation lifecycle: data import, transformation and enrichment matching and exception resolution, reporting and analytics, period end reconciliation, attestation and certification, task management and journal entries back to the GL. ReconArt for NetSuite is a 100% web deployed across every function: set up, administration, daily and period end activities and reporting - everything performed in the user’s browser of choice with no plug-in software installed. The Total Reconciliation Lifecycle solution is immediately available as a cloud-delivered Software-as-a-Service.   What are the ReconArt for NetSuite key benefits? NetSuite customers are entitled to a long list of benefits being equipped with ReconArt for NetSuite Reconciliation platform Reduce operational costs and minimize potential for errors by automation of manual and semi-manual reconciliation tasks: Matching of transactional data Exceptions investigation management Journaling of bank fees, currency rate differences and other types of outstanding exceptions left after the reconciliation is completed. Journals can be automatically created in NetSuite replacing the traditional manual journal-entry process Mitigate operational risk through automation Automate error and exceptions identification Automatically classify risk situations Automate exceptions follow-up processes Enhance compliance and audit readiness Comply with all audit, regulatory and statutory requirements associated with the proper data reconciliation Auditor role is easy to set up Streamline reconciliation activities and relinquish manual and disparate processes involving paper reports and spreadsheets Speed up period and quarter end cycles by dealing with issues on the spot, reinforcing a structured, automated workflow geared towards closing the books quickly   Which are the common reconciliation types supported by ReconArt for NetSuite? Bank Reconciliation Automate daily reconciliation statements with enterprise class ETL functionalities - configurable by business users, to be always on top of bank rec status Support for multiple matching relationships - accounts can be reconciled on one-to-one, one-to-many, many-to-many basis FTP/SFTP Push Support from most major banks – accommodates automated data transfer to avoid manual downloads and attachments Journaling of the exceptions in NetSuite with multilevel approval process, configurable in ReconArt, based on the currency and the amount of the journaled transactions Merchant/PSP Reconciliation Multi-way match support - reconcile POS to Merchant/PSP (Payment Service Provider) as a first step, and then to the corresponding bank to ensure accurate transfer of all funds Grouping and update rules facilitate the identification and reconciliation of transaction fees, batch payments, and other misc. transaction types Payables and Receivables Reconciliation Three way matching of orders to receipts to payments Cash allocation for incoming payments from customers Integration of scanned documents via third party OCR solutions Investments Reconciliation Track daily positions with ease and intuitive Position View Drill down to matching of underlying trades and their associated cash settlements Auto-matching using CUSIP, ISIN, SEDOL, and more Monitor trends and risks with user assigned exception/break codes Suspense Account Reconciliation Single sided reconciliation Auto match debits and credits one-to-one, one-to-many or many-to-many Immediately flag and categorize risk situations GL Account Reconciliation Direct NetSuite integration for GL periods and balances Certify account balances as often as needed with multi-calendar support (monthly, quarterly, yearly) Automatically certify zero-balance or zero-change accounts to speed up financial close Powerful, intuitive, and collaborative certification hierarchical workflow, adaptable to any account volumes And More! Expense account reconciliation Inter and intra-company Even non-financial data   ReconArt for NetSuite suitability ReconArt for NetSuite covers all NetSuite customer industries and reconciliation subject specifics. Finance, Payment Services, eCommerce, Travel and Hospitality, Education, Food Services, Healthcare, Insurance, Manufacturing, Online Services, Internet & Telco, Retail, are all examples of supported industry domains. Want to learn more, see how it works or get a detailed description? We are happy to get in touch - request a system Demo today:  https://www.reconart.com/about/contact/   Bringing success to NetSuite Clients: some recent implementations of ReconArt for NetSuite By adopting ReconArt for NetSuite, clients across all industries globally promote both efficiency and reconciliation practice maturity. ReconArt allows organizations to establish the highest degree of automation, best practice, control and consolidation of their account reconciliation, reporting, and audit processes within a single Total Reconciliation Lifecycle solution. WorldRemit, United Kingdom Financial Services WorldRemit is an online service that lets people send money to friends and family living abroad, using a computer, smartphone or tablet, available to senders in more than 140 countries and the number is growing all the time. WorldRemit adopted ReconArt to allow a fully automated daily reconciliation of incoming and outgoing online FX transactions across many different currencies and correspondent banks. In addition to high-volume transaction matching, the team leverages ReconArt for journal entry approvals and balance sheet reconciliation at period-end. Fullerton Health, Singapore Hospital & Health Care Fullerton Health is a leading provider of corporate healthcare solutions across Asia Pacific with more than 225 fully-owned medical centers and a network of more than 8,000 medical providers. As a fully integrated healthcare organization, Fullerton Health provides enterprise healthcare services, such as occupational health services, primary care services, executive health screening and medical benefits management services. FHG is currently using ReconArt to perform bank reconciliation for their Australian entity. Тhe reconciliation is ran on a daily basis, with automatic upload & matching processes, where journals are sent via weblink to NetSuite. The company is also looking to implement benefits & payments reconciliation across multiple countries, including China, Singapore, Indonesia in the near future. TransferGo, London, United Kingdom Financial Services TransferGo is the most convenient way to send money abroad for migrants and businesses. TransferGo is a 'pure-play digital' international money transfer service that is regulated by the UK Financial Conduct Authority (FCA) as an authorized payment institution, enabling international money transfers across Europe and other global destinations. After successful Nolan replacement, today TransferGo uses ReconArt for its daily bank reconciliation activities. TransferGo’s reconciliation is a high volume, daily process, which leads to automatic journaling and import into NetSuite. ReconArt allows for clear auditing of past transactions and follow-through of existing records. Deliveroo, London, United Kingdom Food & Beverages Deliveroo is on a mission to bring you meals from high-quality restaurants with a transparent, speedy delivery service, courteous, friendly drivers and unparalleled customer service. Founded in 2012, Deliveroo is bringing great food to customers in 12 countries and over 200 cities. Deliveroo reconciles all cash and bank transactions through ReconArt on a daily basis in GBP. They use the automatic upload and reconciliation functionality of ReconArt, allowing for them to focus only on reconciled items. InstaReM, Singapore Financial Services Founded in 2014, InstaReM has created a unique payment mesh in Asia, which is being leveraged by financial institutions, SMEs and individuals to make fast and low-cost cross-border payments to more than 60 countries across the globe. InstaReM reconciles worldwide transactions from all vendors through ReconArt, with more than 60 different data sources. The company is able to synchronize their data into a uniform and coherent format, which allows for easy statistics and comparison between the various vendors. Texture, CA, United States Online Media Texture is a completely new way for readers to experience the world’s best magazines, reimagined for how people consume content today. Texture combines everything readers know and love about the print magazine experience and layers onto it the power of digital—giving people a curated reading experience that's available anytime, anywhere. ReconArt was initially referred to Texture by an existing Bay Area customer from the Hospitality space. Today they use ReconArt to reconcile hundreds of thousands credit card transactions between their sales records and multiple payment provider records including PayPal. Pepperstone, Melbourne, Australia Capital Markets Pepperstone Financial is an execution only forex brokerage firm. The company provides access to fair, competitive and transparent pricing across all major currency pairs by equipping traders with best-in-class trading technology and customer service. Pepperstone leverages ReconArt to reconcile accounts for several payment processors, as well as multiple bank accounts, all in multiple currencies. ReconArt is utilized for matching purchase orders and withdrawals against bank settlements and processor data in various data formats. ReconArt also assists the team in tracking and booking journal entries coming out of the reconciliation into NetSuite. Smiles Inclusive Limited, Queensland, Australia Health, Wellness and Fitness In an increasingly collaborative economy, Smiles Inclusive was established to leverage the best parts of owning your own practice with the greatest aspects of joining a corporate business. Smiles Inclusive offers interested practice owners the ability to retain a vested interest in their business, while alleviating themselves of routine business functions which can diminish the very reason the core business exits - to perform dentistry. Smiles Inclusive leverages ReconArt to automate and control the transactional reconciliation of their multiple dental practices in one centralized and auditable solution. ReconArt reconciles income and journals revenue, through the process of matching receipts of payments to invoices of services rendered. The solution sits between NetSuite, their practice management software, and multiple external payment sources and Medicare, Veterans Affairs, and other insurance providers. Become a partner and spread the benefits to your clients Partnerships in ReconArt matter a lot. We understand, appreciate and respect our partners. ReconArt has forged different kinds of partnership models to fit any need and delivers flexibility to accommodate specific requirements. It all comes with transparent pricing and clear terms. At the same time, we solve a number of potential challenges that partners usually face – it is easy and convenient to cooperate with ReconArt: We take care of hosting our solutions and supporting the required environment We take full care of the application’s support We provide optional implementation services in case you do not have the capacity to handle it Our solution works equally well with any industry and any company size We are not afraid to stay flexible and confront unique cases and problems We invest constantly and heavily to align our solution with client requirements while helping our partners understand and meet their ever-changing needs. It is a process of continuous improvement that differentiates ReconArt from similar solutions on the market. Learn more about the Partnership Program at ReconArt: https://www.reconart.com/partners/...

ReconArt is a single-solution technology company providing a modern, enterprise-class, fully web-based reconciliation platform to a diverse, global client base of all industries and sizes. Our firm is headquartered in the United States just outside of Washington DC and also has offices in Europe. We have been serving our clients and the market since 2011. ReconArt is created as a web-based solution that comprehensively caters to all reconciliation needs while also being scalable and modern – not just in the sense of latest technology but also in the way it is priced, implemented, supported, and enhanced over time. Why is ReconArt different from other similar solutions? It is a full scale reconciliation tool – it originates from its matching engine and can perform any type of reconciliation – for financial, non-financial and industry specific data We constantly reinvest and make the tool better – 2 major new releases per year based on market trends and client feedback and multiple small releases in-between Total reconciliation lifecycle in just one integrated solution – data import, transformation and enrichment, matching, exception management, reporting and analytics, period end reconciliation, certification, compliance and auditability, journal entries back to the GL You can rely on very strong ETL and automation capabilities, configurable by business users Enhanced compliance is a focus– super granular audit trail, configurable workflow, total visibility, separation of duties Self-sufficient and business user oriented Why being a ReconArt partner is so different to other partnerships a great experience easy and beneficial? Successful partnerships have always been a hot topic and main concern for both companies and analysts who strive to find the perfect recipe for joining forces. We also put great effort in developing our program – we aim to provide maximum value for our partners, to utilize our competencies, both technical and industry specific, and to leverage all strategic advantages of the solution. Partnerships in ReconArt matter a lot. We understand, appreciate and respect our partners and seek to provide mutually beneficial and successful relations that create added value, foster development and inspire market innovations. ReconArt offers different kinds of partnership models to fit any need and is flexible to accommodate specific requirements. It all comes with transparent pricing and clear terms. At the same time we solve a number of potential challenges that partners usually face. It is easy and convenient to cooperate with ReconArt: We take care of hosting our solutions and supporting the required environment We take full care of the application’s support We can take care of the implementation in case you do not have the capacity to handle it Our solution works equally well with any industry and any company size We are not afraid to stay flexible and confront unique cases and problems We invest constantly and heavily to align our solution with client requirements while helping our partners understand and meet their ever-changing needs. It is a process of continuous improvement that differentiates ReconArt from similar solutions on the market. At the end, our ultimate goal is to respond fully to both customer and partner challenges in the most efficient way. Learn more about the Partnership Program at ReconArt: https://www.reconart.com/become-partner/...