Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowI 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!
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.
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.
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.
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!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.