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.
Collinm
Level 1

Reconciliation

We are working to fix a reconciliation issue caused by a deleted reconciled transaction and I would like to confirm the best approach. 

 

A payment from Feb was deleted yesterday because it was identified as a duplicate, this payment had already been reconciled. All months from Feb to July have been reconciled correctly, until that payment was deleted yesterday and now Feb shows a negative balance because of that deleted payment. I originally noticed because I was working on reconciling August, and despite every transaction matching the bank register, Augusts balance was showing a negative and not zeroing out. That is when I noticed Feb was messed up because of that duplicate payment that was deleted. 

 

However, in the bank register, In Feb I can see the payment (I assume the original payment and not the duplicate) and it shows an R as if its reconciled. But as mentioned, when I view the February report, it shows that payments balance as "-xyz". Its almost as if the duplicate and the original were both reconciled originally. 

 

I've done some research, and the best solution I have found is to undo the February reconciliation and redo it so that the chain is restored and not affecting ending and beginning balances of future months. However, I cant undo February without first undoing July, June, May, April and March in order. Before I go down that route, which I know is not preferred, is there a way to Fix February without having to undo it and all those other months? 

 

If you have questions about the situation, please ask and I will respond with an answer as soon as possible. 

1 Comment 1
ZackE
Moderator

Reconciliation

Thanks for reaching out to the Community, Collinm.

 

When you reconcile an account, you're comparing specific transactions in QuickBooks to your bank statement. If everything's in place, the difference between your ending balances should be zero. If they don't match, you'll need to find and fix the issues, then finish reconciling.

 

Before moving forward, I'd recommend reviewing our Reconciliation Guide to learn more about reconciling accounts.

 

Here's some common causes of ending balance issues:
 

  • There are missing or duplicate transactions in QuickBooks.
  • Someone entered an incorrect ending balance at the start of the reconciliation.
  • Someone entered transactions into QuickBooks that haven't cleared your bank yet.

 

If you need to fix issues at the end of a reconciliation, review your opening and beginning balances, in QuickBooks and on the bank statement to confirm you're starting with accurate numbers.

 

Next, check your entered ending balance:
 

  1. In the Reconciliation window, click Edit info.
  2. Review your Ending balance and Ending date.
  3. Check them against your bank statement.
  4. Make any necessary edits.
  5. Select Save.

 

In the event your balances still don't match, try some of our additional troubleshooting steps.

 

If you need to unreconciled a transaction, you can review the steps in our Undo or remove transactions from reconciliations article. It's recommended that you make sure you've entered the correct opening, beginning, and ending balances before continuing.

 

You may want to talk with an accountant before unreconciling transactions. If you're unsure of what you need to do next, there's an awesome tool on our website called Find a ProAdvisor. All ProAdvisors listed there are QuickBooks-certified and able to provide helpful insights for driving your business's success.

 

Please don't hesitate to send a reply if there's any questions. Have a great Thursday!

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

Need to get in touch?

Contact us