Listen to this articleQuickBooks reconciliation discrepancy arises when your bank account and QuickBooks transactions don’t match.
For instance, you reconciled the last month, verified its ending balance, and found a small amount left over. QuickBooks allows you to fix it by entering an adjustment amount. This is handy when balancing the books and closing the reconciliation.
However, you must first ensure that the transactions in QuickBooks match those in the bank account. Moreover, you should be confident that everything is correctly entered.
There are different kinds of QuickBooks reconciliation discrepancies; we will discuss some common ones here. Additionally, we will explain how to fix reconciliation discrepancies in QuickBooks. Before we dive into that, let’s brief you on how to reconcile in QuickBooks Desktop.
 | Although this blog will thoroughly discuss methods to fix QuickBooks reconciliation discrepancies, nothing compares to expert help. Dial 1855-546-5024 and allow the QuickBooks ProAdvisor to handle the issue for you. |
How to Reconcile in QuickBooks Desktop?
In layman’s terms, QuickBooks reconciliation matches the transactions recorded in QuickBooks to those in your bank or credit card statement. Bookkeeping and accounting must be reconciled to ensure the books stay accurate and balanced.
Reconciling in QuickBooks is not difficult. However, it is a comprehensive process that requires you to back up the company file before you do so to avoid data loss in unforeseen circumstances. For a stepwise tutorial, keep reading this QuickBooks reconciliation guide.
How to Check the Validity of QuickBooks Reconciliation Discrepancy
Perhaps you checked and found out that the ending balance on the bank statement and QuickBooks are different. However, do you know whether this QuickBooks reconciliation discrepancy is valid, or can you ignore it?
Sometimes, these discrepancies are a sign of a mistake in your transactions or the bookkeeping. However, after thoroughly checking every transaction and ensuring everything is correctly entered, you can know whether this discrepancy is valid.
Reasons for a QuickBooks Reconciliation Discrepancy
By now, we have a clear idea of what a QuickBooks reconciliation discrepancy is. Now, let us explore some common reasons that give way to QB reconciliation discrepancies. When you carry out the reconciliation, you should check for these mistakes.
1. Incorrect or Missing Transactions
Anything incorrectly entered in QuickBooks can lead to a discrepancy between the book and the bank statement. For instance, if you enter the transaction incorrectly, fail to enter the amount, or enter it twice, there will be a difference between the books and bank statements.
If you enter the amount inaccurately, such as entering USD 51 for a bank transaction instead of USD 50, you will get an outstanding item in the reconciliation.
Moreover, you should ensure that a credit is entered as credit, not debit, and the same goes for debit.
2. Wrong Time-Period
Sometimes, the transaction occurs in a different month and will show up in that month in the bank statement. However, the user may input it incorrectly in another month in QuickBooks.
This mistake in recording transactions often leads to a QuickBooks reconciliation discrepancy. The transaction appears as an outstanding item in the QuickBooks reconciliation window.
Moreover, sometimes users might not record the deposit or payment made for long. They may record it in a later month or not record it at all. This amount will add to the difference between the bank statement and QuickBooks.
3. Incorrect Adjustments
Let’s say that when you balanced the books, you or someone else entered an adjustment amount as a journal entry.
However, this transaction might show as an outstanding item in the reconciliation window, giving way to QuickBooks reconciliation discrepancies.
4. Frauds and Scam
Although it is not common and QuickBooks is pretty safe, no software or business is immune to fraud and similar thefts.
Someone might create fake customers, vendors, or clients and write checks to them or deposit money in an account. These extra transactions will throw the book off and appear as an outstanding item in the reconciliation window.
For this reason, you can use reconciliation to find invalid or fraudulent journal entries. For example, if a transaction shows up in the QuickBooks reconciliation window but you cannot find its equivalent in the bank statement, it might be fake or incorrect.
How to Fix a QuickBooks Reconciliation Discrepancy
You might have checked and cross-checked QB transactions with the bank statement, yet you see some items left in the reconciliation window. Do not worry; QuickBooks offers ways to fix a QuickBooks reconciliation discrepancy.
Carry out these solutions individually and check if the issue is resolved.
1. Check the Beginning Balances
Before you go ahead and find solutions to fix the QuickBooks reconciliation discrepancy, you must check and ensure the cause is not hidden at the root of the issue. Every financial period begins with a beginning balance.
Moreover, when you first connect QuickBooks with a bank or credit card account and start recording journal entries, it notes the bank balance at the moment as the opening balance. QuickBooks also allows you to edit that opening balance.
Therefore, first, ensure that the original opening balance at the very beginning is entered correctly. Now check the beginning balance of the financial period or month you want to reconcile for and match it with the ending balance of the last reconciliation.
Once you verify the opening and beginning balances, you can move ahead.
If you find out that the opening balance or beginning balance was wrong, you might have to undo some reconciliations and do it again.
2. Utilize the Reconciliation Discrepancy Report
The reconciliation discrepancy report allows you to check for the changes in transactions after the last reconciliation. Here’s how to run the reconciliation discrepancy report.
- Navigate to Reports and move your cursor over Banking.
- Choose Reconciliation Discrepancy.
- Now, choose the account you wish to reconcile.
- Tap on OK when prompted.
- You will see the report and the changes that have been made.
- Evaluate the discrepancies in the report and verify these changes.
- If you come to know that a transaction was incorrectly made, edit it accordingly.
However, if you find that the change was in a transaction you already reconciled, you might need to redo the reconciliation. Therefore, consult your accountant before undoing these changes.
Now check for the reconciliation discrepancies in QuickBooks and if everything has been fixed. If the discrepancy persists, continue to the next step.
3. Utilize the Missing Checks Report
The missing checks report, as the name might suggest, shows any checks that might be missing and are not part of your ending balance. These missing checks can be the reason for the QuickBooks bank reconciliation discrepancy.
Here’s how you can run the missing checks report.
- Navigate to Reports and move your cursor over Banking.
- Choose Missing Checks from the list.
- Now, pick the account you wish to reconcile for.
- See the report and find out the transactions that are different in banks and QuickBooks.
Edit these transactions to resolve QuickBooks reconciliation discrepancies.
4. Utilize Transaction Detail Report
If the above few methods didn’t resolve the issue, a transaction detail report might be your best bet. This report elaborates on any transaction that was changed.
- Navigate to Reports and move your cursor over Custom Reports.
- Choose Transaction Detail from the list.
- Click on Display.
- Choose the Date From as the earliest available or leave it blank.
- Choose the Date as the date of your last reconciliation.
- Now open the Filters.
- Choose the account you wish to reconcile in the accounts field.
- There will be an Entered/Last Modified field. Here, choose the date of your last reconciliation.
- The Date To should be today’s date.
- Once done, click on OK and run the report.
- Now, study the transaction changes that show up on your screen.
- If these don’t match your bank statements, try to find out why they were changed or ask the person who changed them.
- If required, edit the transactions as required.
5. Verify Reconciliation Adjustments
In the reasons section, we saw that the reconciliation adjustments can lead to a QuickBooks reconciliation discrepancy. Therefore, you must check the adjustments if you still have discrepancies in QuickBooks and bank statements.
Users often make reconciliation adjustments to force-balance the books. However, when they do so, the adjustment is recorded separately in a Reconciliation Discrepancies account. That’s what we are investigating now.
So, let’s review the adjustments.
- Navigate to Lists.
- Click on Charts of Accounts.
- Now, you might see an option to choose the date.
- Choose the date for your reconciliation.
- You will be able to see all the adjustments.
- Evaluate these adjustments, and if you find an incorrect one, edit it as required.
- Ensure that your correction doesn’t conflict with other transactions and doesn’t imbalance the book.
Check if the discrepancies in QuickBooks reconciliation are resolved.
6. Undo the Last Reconciliation and Do it Again
If you haven’t been able to find the culprit for the QuickBooks reconciliation discrepancy and fix it, the problem might stem from the last reconciliation.
Therefore, you might need to undo the last reconciliation and do it again. However, we advise you to consult your accountant once before that.
Conclusion
This was all about what causes QuickBooks reconciliation discrepancy and how to fix it. However, if you find the troubleshooting methods difficult to follow or feel stuck anywhere, call us anytime. We provide 24/7 support for accountants, bookkeepers, self-employed individuals, and business professionals.
Also, get a QB ProAdvisor to fix your QB issues and ensure it runs like water. Take a free trial of our services at 1855-546-5024 today!
FAQs
If you notice a minor discrepancy in QuickBooks, such as a few cents difference, you can run a reconciliation discrepancy report. In this report, you can find the specific transactions that caused the discrepancy.
To get this report, go to the Reports menu and select Reconciliation Discrepancy under the Banking menu. Select the account you want to reconcile, click OK, and check the report for discrepancies.
To enter an adjusting entry, go to the Transactions menu, select Reconcile, review your account, and select Start Reconciling. Click Finish Now from the drop-down and click Done. Once you get a message notifying you that your account is now balanced, click the Add Adjusting entry link. QuickBooks will create an income transaction if the difference is positive or an expense transaction if the difference is negative, forcing the account to balance.
To print a reconciliation discrepancy report in QuickBooks, click the Print icon in the top-right corner. Alternatively, you can press Ctrl + P keys to print the report.
To delete duplicate transactions in QuickBooks, go to the Banking menu, select Bank Feeds, then Bank Feeds Center, and select the account having duplicate transactions under the Items Reviewed section. Select Items to Delete and choose the transactions you want to eliminate. Finally, click Delete Selected and Yes to delete the selected transactions.
