Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
kelliek1
Level 1

Reconciling with a discrepancy...

I am trying to reconcile September, but there is a $1,000.00 discrepancy from August leading to the beginning balance being off, it is saying that there was a transaction that was deleted. How do I fix this in order to correct the account to get everything adjusted to reconcile correctly.

2 Comments 2
CamelleT
Moderator

Reconciling with a discrepancy...

Let me guide you in fixing your reconciliation discrepancy, @kelliek1.

 

Deleted transactions change the ending balance of your last reconciliation, which affects the beginning balance of the next one.

 

Since you already checked the discrepancy report and found out that there's a deleted transaction, then we can use this to recreate it exactly as how it is reflected on the report. Here's how:

 

  1. Click +New.
  2. Select Expenses.
  3. Fill out the form and click Save and close.
  4. Hit the Gear icon, choose Chart of Accounts.
  5. Find the account that you placed the transaction into and click View register.
  6. Look for the expense transaction and click it, then hit the box under the checkmark column until an "R" shows up. This will manually reconcile it. 
  7. Hit Save

 

Additionally, if you are still prompted when you reconcile, open the discrepancy report and check. The deleted transaction may still show up, but the difference should be $0.00 already. Click Resume reconciling to continue your reconciliation. 

 

If your beginning balance is already accurate, start reconciling


You can also undo or remove transactions from reconciliations in QuickBooks Online. This will help you whenever you make a mistake when reconciling. However, keep in mind that this will unbalance your accounts, so you can only do this one transaction at a time. 

Let us know if you have further questions about fixing the discrepancy in your reconciliation. We are always here to help. Take care!

kelliek1
Level 1

Reconciling with a discrepancy...

Thank you so much!

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us