cancel
Showing results for 
Search instead for 
Did you mean: 
goodsoul611
Level 1

Fixing a reconciliation

I use a feed to put transactions in my bank statement.  I use QB payroll so I already have some of these transactions so it puts duplicates in there.  When I reconcile, I sometimes, accidentally, clear the transaction from the feed instead of the payroll entry.  (E.g. I can't and shouldn't delete the payroll entry since it has the right accounts in the transaction.)  So, anyway, after I finish the reconciliation, it's reconciled to the penny but when I go back through the bank register, I find the payroll record and I realize I need to change which transaction is cleared.  Is there a way to do that without messing up the reconciliation?  If there's not, is there another way to deal with it without having to undo the reconciliation and start over?

 

Thanks!

3 Comments 3
Rubielyn_J
QuickBooks Team

Fixing a reconciliation

Let me help you fix reconciliation in QuickBooks Desktop, @goodsoul611.

 

To start, let's run the Reconciliation Discrepancy report. This shows any transactions that were changed since your last reconciliation. 

  1. Go to the Reports menu. 
  2. Choose Banking and then select Reconciliation Discrepancy.
  3. Select the account you're reconciling and then click OK.
  4. Review the report and look for any discrepancies.
  5. Then, edit the transaction as needed.

 If you need to add or modify transactions you already reconciled, you may need to do a mini-reconciliation. I suggest reaching out to your accountant to assist you with this. 

 

Once everything is fixed, you can finish reconciling.

 

You may also consider checking out this article: Fix beginning balance issues in QuickBooks Desktop.

 

Let me know if you have other queries with reconciliation. I'll be around to help. Have a nice day.

goodsoul611
Level 1

Fixing a reconciliation

Hi @Rubielyn_J

 

Thanks for responding.  I *could* edit the transaction that I reconciled but I couldn't delete the other transaction since it is a payroll record.  QB doesn't allow that.  Ideally, I would "Unclear" the transaction (record 1) I chose and "Clear" the payroll record(record 2) then delete record 1.  But doing that just messes up the reconciliation.  Both records are for the exact same amount.

Jessica_young
Moderator

Fixing a reconciliation

Good morning, @goodsoul611.

 

So in this case, the payroll entered in QB should be the one that is reconciled and not the one that is manually entered or added from the online banking. 

 

If you're using the banking transactions as you do your reconciliation instead of the manually entered payroll on the QuickBooks side, which in this case is incorrect. You should be matching it or excluding the banking transactions and manually set the status to clear on the manually entered payroll transaction.

 

You may find this article helpful: Add and match Bank Feed transactions in QuickBooks Desktop.

 

Let me know if you have additional questions on this, I'm here to help! 

Need to get in touch?

Contact us