Account Reconciliation: Example, Types, Process, Best Practices

For both internal and external sources, every balance must match its corresponding account in the GL. Intercompany transactions, currency exchange rates and various non-cash activities only generate more complexities in an already complicated, time-consuming process. The risks of not reconciling bank statements to general ledger cash accounts are that fraud or errors may not be detected and financial statements used for both internal and external financial reporting may be inaccurate. Cash flow may also be affected if general ledger account balances are inaccurate.

• An effective reconciliation tool is essential to avoid challenges that come with reconciling accounts manually.
• Due to this reliance on spreadsheets, organizations continually need more time to catch up on deadlines while spending an inordinate amount of time and resources to maintain the highly manual process.
• Any differences are investigated, and corrective action is taken when appropriate.
• Additionally, the materiality or the dollar amount of the reconciliation plays a critical role in determining how often the account should be reconciled.

BlackLine solutions address the traditional manual processes that are performed by accountants outside the ERP, often in spreadsheets. To sustain timely performance of daily activities, banking and financial services organizations are turning to modern accounting and finance practices. Bank account reconciliation is a great way to help reduce the risk of fraud. We can review the payee on every check and compare it against the payee in QuickBooks to make sure nothing funny is going on. If you don’t look at the payee on the bank statement, you won’t know if a bill that shows up in QuickBooks as paid to AT&T, was really paid to your office manager who had changed the payee.

Bank Reconciliation Process: Expert Tips for Success

These discrepancies happen when human error (like incorrectly keyed information) causes there to be differences between the general ledger and the subledgers. But, if they happen too often and can’t be explained, this may indicate something’s not right with your books. When all your information is correct, you’re less likely to miss deposits or mistakenly overdraft an account because of a lack of funds. You’ll know exactly how much money you can budget for vendors, operating expenses, and other payments. And each subsequent software implementation, instead of getting easier, requires more time, more money, and more effort. And what if a document is missing or incomplete—a control issue for auditors to feast on.

The same person cannot prepare and approve a reconciliation—an essential point of control. Stay up to date on the latest corporate and high-level product developments at BlackLine. Every executive is committed to ensuring transformational success for every customer.

What Does Reconciliation Mean in Accounting?

Here, a company will compare its outstanding customer balances to the accounts receivable captured in the general ledger to unveil any irregularities in customer-level accounting. Companies typically perform customer reconciliation before issuing their monthly financial statements. The customer reconciliation statement serves as proof that there’s no material inaccuracy in the accounts. Since the early 2000’s, purpose-built software applications for account reconciliations have become available. These software applications provide the ability to load account balances and transactions from GL/ERP systems, automate manual matching and comparison tasks, and support electronic workflow and approvals.

This may be done by comparing a spreadsheet calculation to the balance in the general ledger account. No matter how diligent the accounting team is, sometimes a transaction just slips through the cracks. Versapay integrates with your ERP to automatically apply payments made within the platform to their respective invoices. With our advanced cash application tools, we use optical character recognition (OCR) and AI to automate matching for payments outside the platform too. Even with an online payment portal, you’ll still get payments coming in from outside of the platform via checks or electronic payments.

Too Many Tools

Gone are the days when finance and accounting functions existed in silos; now, they feed each other to learn from past performance, optimize present performance and maximize performance in the future. An example of reconciliation is comparing a company’s bank statement to its own accounting records to ensure that all transactions are accurately recorded and any discrepancies are identified and resolved. Sometimes a deposit or a payment recorded in your accounting software isn’t on the monthly bank statement. When paper checks were the main way that vendors and employees were paid, this was a much bigger problem. But today, nearly instantaneous communication of financial transactions means the delay between the money leaving one account and reaching another one may be measured in minutes or hours, not days or weeks.

Finally, when correcting journal entries are required, the BlackLine Journal Entry product automates this portion of the process as well. Whether new to BlackLine or a longtime customer, we curate events to guide you along every step of your modern accounting journey. F&A teams have embraced their expanding roles, but unprecedented demand for their time coupled with traditional manual processes make it difficult for F&A to execute effectively. It’s time to embrace modern accounting technology to save time, reduce risk, and create capacity to focus your time on what matters most. Improve the prioritization of customer calls, reduce days sales outstanding, and watch productivity rise with more dynamic, accurate, and smarter collection management processes. GrowthForce accounting services provided through an alliance with SK CPA, PLLC.

What are common account reconciliation discrepancies and how to solve them?

Accounts receivable, accounts payable, inventory, and fixed assets may be tracked in separate subledgers or schedules. Some systems record all transactions involving cash in a ledger called a cashbook. Reconciling these accounts is usually a simple matter of making sure that the your bank statement balance in the relevant subledger or schedule matches the balance in the general ledger. It may seem obvious, but this is essential for making sure the accounting records are right. That’s how we know the financials are accurate — or at least materially correct — every month.

What’s more, it’s a process that’s ripe for automation—but frequently done in a manual, time-intensive and error-prone manner. The very basis of double-entry accounting is itself an internal reconciliation. Transactions that impact a company’s bottom line — net income — are split between accounts on the balance sheet and the income statement.

Many of these challenges revolve around technical expertise and the number of records to reconcile. If the records don’t match, finance experts can investigate to find the reason and make changes where necessary. Examples of unintentional reasons for differences are missing invoices or unrecorded transactions. For intentional discrepancies, you might find fake checks or misuse of funds. In fact, with the right tools and technology, it’s not uncommon to reduce the time to complete the financial close by 50% or more. This one doesn’t have to be a comparative trial balance, because you’re only interested in checking the new balances after all your journal entries have been completed.

If not, a common outcome is for many asset accounts to be overstated, requiring a business to charge off significant amounts at year-end to more accurately align these accounts with reality. Start comparing your statements to the external ones and note the records you don’t have. It might be helpful to perform a side-by-side comparison of your records to theirs, so you don’t miss anything. For example, you can analyze each transaction listed in the financial statements to corresponding ones on the bank statement by crossing them out.

Chart of Accounts – Chartfields

Doing this will help ensure that the process is not just being done quickly but also consistently and correctly. Automatic notifications, real-time status reports, routing tasks to the right roles, and posting transactions to the GL. These things, when complete, all go even further to make the account reconciliation process more accurate, efficient and rewarding for those involved. They also bolster the confidence of executives and external stakeholders in the numbers resulting from the process. The value of automation is even more apparent if your organization has subsidiary companies or separate but related corporate entities. As the number of these entities grows, so does the complexity of the account reconciliation process and the overall volume of data, accounts and sub-ledger systems involved.

• Bank Rec’s software can be purchased entirely upfront or via monthly subscription to include five users and carry out your reconciliation processes.
• This company-wide effort crosses multiple functional areas and is reinforced by critical project management and a strong technology infrastructure.
• You will need to check the bank and ledger balances to ensure that there are no short payments, deductions, disputes, and to stop credit facility for defaulting customers.
• It is prudent to reconcile credit card accounts and chequebooks on a regular basis, for example.