Find a Dealer
Menu Close

The Ultimate Guide to Reconciliation & How to Do It on Quickbooks Online

Posted on: December 26, 2022 by in Bookkeeping
No Comments

If a transaction appears in QuickBooks Online but not on your statement, do not mark it. For any discrepancies, like a slight mismatch in payee details, simply edit the transaction in QuickBooks Online to align it with your bank statement. The goal is to have a zero difference between your statement and QuickBooks Online by the end of the process, at which point you can select Finish now. When you have your bank statement in hand, you’ll compare each transaction with the ones entered into QuickBooks. We recommend reconciling your checking, savings, and credit card accounts every month.

You are also required to have this information when it is tax time. It is convenient to perform the reconciliation in QuickBooks accounting software on monthly basis than to try to recreate the financial information when the taxes are due. Reconciliation in accounting is a critical process, serving as a check-and-balance for financial accuracy. It involves comparing two sets of records to ensure they are in agreement and accurate. In the context of QuickBooks, reconciliation typically refers to matching the transactions recorded in the software with external financial statements, such as bank and credit card statements. This process is vital in verifying that the records in QuickBooks accurately reflect a business’s financial transactions.

Step 3: Read Over the Reconciliation Report

You are required to enter the date in the Calendar of QuickBooks accounting software. Post that, you can begin mentioning the other required information. After that, you can make the comparison between the transactions in the bank with the ones listed in QuickBooks accounting software to do the reconciliation of the account. One of the more important ways that a reconciliation of accounts receivable helps any large or small business is that it ensures that financial statements are clean and ready to audit. If the IRS comes calling, they’ll want to see that there are no discrepancies in a company’s receivable reports. To run a reconciliation report, navigate to Settings, choose Reconcile, and then select History by account.

  • There are times, they don’t include transactions that were still pending when you created the account.
  • Reconciliation is an essential accounting process that ensures two different financial records are correctly matched up.
  • The journal entry goes into a special expense account called Reconciliation Discrepancies.
  • Go through your transactions and compare your charges and payments, which are summarized at the top of the screen next to the “Difference” statement.

You enter the balance of your real-life bank account for whatever day you choose. We recommend setting the opening balance at the beginning of a bank statement. Just like balancing your checkbook, you need to review your accounts in QuickBooks to make sure they match your real-life bank and credit card statements. NSKT Global being one of the top certified Quickbooks ProAdvisor helps in the reconciliation of accounts payable,  accounts receivable, and bank. We help all kinds of businesses deal with reconciliation as it is inevitable for any business. Quickbooks is very important cloud software to do account reconciliation without any hassle.

Probable causes of mistakes in payable Reconciliation:

Once you get your bank statements, compare the list of transactions with what you entered into QuickBooks. If everything matches, you know your accounts are balanced and accurate. If a transaction prepaid insurance complete guide on prepaid insurance matches, mark it as reconciled by placing a checkmark next to its amount in QuickBooks Online. Transactions added or matched from online banking are usually pre-selected for convenience.

How to Perform the Reconciliation in Account Receivable in QuickBooks Accounting Software?

With the help of this software, you can import, export, as well as erase lists and transactions from the Company files. Also, you can simplify and automate the process using Dancing Numbers which will help in saving time and increasing efficiency and productivity. Just fill in the data in the relevant fields and apply the appropriate features and it’s done. Once you are done with these steps, the accounts you have selected from the list will be marked as reconciled in QuickBooks Online. Once it’s done the accounts are accurate and updated with the required details. Make sure you enter all transactions for the bank statement period you plan to reconcile.


This website is using a security service to protect itself from online attacks. The action you just performed triggered the security solution. There are several actions that could trigger this block including submitting a certain word or phrase, a SQL command or malformed data.

The subsidiary ledger is a detailed listing of customer transactions and payment history. Customer account balances are then reconciled with the general ledger accounts receivable balance. General ledger transactions summarize transactions made as journal entries to sub-ledger accounts. The trial balance allows the bookkeepers to make the company’s financial statements. These include the balance sheet, income statement, statement of cash flows, and other similar financial reports. By regularly reconciling your accounts with your bank and credit card statements, you ensure the integrity of your financial data, enabling informed decision-making for your business.

Doing the reconciliation of the accounts in QuickBooks accounting software required to happen at least once in a month when you receive the statements. So, it is important to make sure that you are not missing anything which could cause the accounts to get out of balance. This process will help you to get the accurate data without any discrepancies.

Comments are closed.