Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
October 31, 2023
Question

Reconciling with a discrepancy...

  • October 31, 2023
  • 1 reply
  • 0 views

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.

1 reply

Moderator
October 31, 2023

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!

kelliek1Author
November 1, 2023

Thank you so much!