Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
B
Books21
January 6, 2024
Question

Reconciliation Discrepancies

  • January 6, 2024
  • 1 reply
  • 10 views

I reconciled an account a few months ago and am trying to reconcile the rest of the year. I'm getting an error with a discrepancy that says a transaction was deleted so there is a discrepancy for the amount of that transaction. However, this transaction is still showing in my categorized transactions for this account. 

1 reply

R
ReymondOModerator
Moderator
January 6, 2024

Hi there, @Books21. Thanks for sharing your concern on the QuickBooks Community page. 

 

Let me help you fix the discrepancies in your account. 

 

Once a reconciled downloaded transaction is deleted, this will automatically go back to the For review tab on the Banking page. The deleted transaction may have the same amount as the one showing in the Categorized tab. 


To track the actual deleted transaction, let's review your discrepancy reports. Here's how:

 

  1. Go to the Reports menu and run the Reconciliation report.
  2. Choose the reconciled account in the Account drop-down list.
  3. Click View report to review the transaction.

 

You can also click the We can help you fix it link to open your discrepancy report on the Reconcile window of your account. You can review its details and use it to decide if and how to make changes. Before editing anything, talk with whoever made the changes - they may be intentional.

 

Once you know you need to make corrections, review each transaction in the report one at a time:

 

  1. Select View to see the history of changes to the transaction.
  2. Review the Change Type column. This tells you what changed.
  3. Make edits based on the message in the Change Type column:

 

For complete guidance in fixing the discrepancy, go to Step Four of this article: Fix issues for accounts you've reconciled in the past in QuickBooks Online.

 

Once you know your beginning balance is correct, you can start reconciling again.

 

If you’ve followed everything in our reconciliation guide but still have questions, connect with your accountant. They can help you get back on track.


Please add your details to this thread if you need further clarification about fixing discrepancies in your account. I'm always here to help. Have a good one.

B
Books21Author
January 6, 2024

Thanks for the response. I've looked at the log and it just says it was deleted. I've reimported the transaction and categorized again (so there are now two identical transactions categorized), but it's still showing up as the error when trying to do the reconciliation. I'm confused on what I need to do with the categorized transaction and how I need to redo it to clear this all up.

R
RCVQuickBooks Team
QuickBooks Team
January 7, 2024

I can see how hard you tried here. No worries, I'll make it up to you to ensure you never have to deal with this again, Books21.

 

We appreciate you for performing the steps provided by colleagues. For the duplicate transactions, we can access the Categorized tab and undo any duplicate entries that aren't part of your reconciliation. Here's how:

 

  1. Go to the Transactions menu.
  2. In the Bank transactions, go to the Categorized tab.
  3. Find the duplicate transaction and select Undo.

 

Then, start reconciling again and make sure all the transactions are within the reconciliation period. If the same thing happens, we can review the opening and beginning balances. When you know they're accurate, you move on and check the ending balance you entered from your bank. QuickBooks Online uses this to check for accuracy and make sure you entered the correct amount. Here's how:

 

  1. While you're reconciling an account, in the Reconciliation window, select Edit info.
  2. Review the Ending balance and Ending date.
  3. Check your bank statement. Make edits as needed.
  4. When you're done, press Save.

 

You can see the detailed steps in this article: Fix issues at the end of a reconciliation in QuickBooks Online. After that, you'll know if the discrepancy is a valid error. You can enter an adjusting entry to force your accounts to balance so you can finish your reconciliation. Just read this article for more details: Enter an adjusting entry for reconciliation in QuickBooks Online.

 

If everything is accurate and intact, try to open your account in an incognito or other supported browser to sort this out. If the balance is correct, get back to your regular browser and clear its cache. Doing this helps your program run smoothly.

 

You might want to learn to unreconcile an individual transaction for a completed reconciliation. Check out this article: Undo or remove transactions from reconciliations in QuickBooks Online.

 

You can use these resources to get more insights on how to manage your accounts, reconciliation, and discrepancies properly:

 

 

You can always get back to this thread and add comments if you need further assistance with your reconciliation. I’m ready to lend a hand to ensure all concerns are covered.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement