Reconcile Accounts in QuickBooks


Reconciling accounts is vital for all organizations. Across the globe, reconciliation is used as the chief method of ensuring accuracy. The account balance is tallied with documents in order to discover any discrepancy with the data. Also, reconciliation takes bank statements into account which provide details about each and every transaction. Reconciliation can be done both manually and through the use of a program. If you are using software like QuickBooks then here is “how to reconcile accounts in QuickBooks” and Reconcile in QuickBooks Desktop.

Reconciling Accounts in QuickBooks:

Books are usually reconciled at the end of the financial period. Also, before closing the books it is essential for all organizations to create a reconciliation statement and check the income and expense accounts.

Organizations can also create reconcile statements on daily, weekly or on a month to month basis. The biggest benefit of creating reconciliation statement is that it helps you in finding discrepancies in your accounting data. Through this document, accountants can easily ascertain inaccuracy of fraudulent use of money. Not only does this statement help you in avoiding inaccuracy but also penalties from state and federal agencies. Also, wrong information about company’s books can seriously damage the goodwill of any organization.

Process and How to Reconcile Accounts in QuickBooks:

reconcile accounts

You need to be careful while creating a reconciliation statement. With QuickBooks users can easily reconcile accounts. QuickBooks works with income and expenses as different accounts. All of the assets and liabilities accounts are linked to Chart of Accounts. Through chart of accounts, users can view and edit all the different accounts present in a particular company file.

Total Time: 15 minutes

Step 1:

🔹 Select the Gear Icon present on the top right side of your window.

Step 2:

🔹 Select Reconcile under Tools tab.

Step 3:

🔹 Click on the drop-down menu and select the account. Please note that this would be the same accounting that will be reconciled.

Step 4:

🔹 Click on “Reconcile Now”

Step 5:

🔹 From the bank statement for the account that is to be reconciled, enter the Statement End Date.

Step 6:

🔹 QuickBooks has an inbuilt calendar through which you can easily select the statement end date.

Step 7:

🔹 Enter the Beginning and Ending Balance

Step 8:

🔹 Click Ok

Match the Expenses:

Upon completion, users need to match all expenses in order to ascertain accuracy. Make sure to follow the steps given below in order to match expenses after reconciling an account in QB:

  • Match the transactions provided on your bank statement with the one reconciled in the report.
  • Check the boxes against all the transactions that are mentioned in your bank statement.
  • Below the reconciliation statement, you can check the difference between the account and bank statement. Until this difference comes down to 0, keep adjusting the transactions.
  • Click Finish now when done

Users can check the reconciliation statements on a later date for fixing inaccuracies. For doing so, follow the steps given below:

  • Reopen the reconciliation page by going to the gear icon.
  • Select the Reconciliation statement that you want to edit
  • Now edit the report by following the steps given above.

Analyzing reconciliation reports with QuickBooks is quite simple. Users can select the reconciliation statement and hit run the report. QB will provide a summary as well as a detailed analysis of reconciliation statement. Summary section of this report provides useful details such as statement beginning balance, checks, and payments cleared, deposits and other credits cleared and so on.

In order to print out the reconcile report, click on the print button above the report. Select the number of copies you want to print. You can also save it as a pdf and on attack it to the back statement on a later date.

You can even give us a call QuickBooks support talk to our Proadvisor now to know accounts receivable and how to reconcile accounts receivable in QuickBooks.