Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I know exactly how you can add the deleted transaction back to QuickBooks Online, @UniIlo.
When a reconciled transaction is deleted, you'll have to first review the Audit Trail page, then locate and take note of the transaction detail. Once done, you can proceed in recreating it:
After that, manually reconcile the transaction by going to your account register.
Here are helpful modules you can read about handling bank reconciliation in QuickBooks Online:
The Community is always available 24/7. Fill me in if you need extra help with banking or QuickBooks in general. Your efforts are much appreciated, stay safe!
I have recreated and marked reconciled any transactions I deleted or changed from the previous reconciliation.....but it still won't let me reconcile. Any other ideas? I've checked that all entries are correct for the 2022 year I'm working in. It says my beginning balance is off my a certain amount but all past entries have been reconciled from the previous year.??
okay so I deleted a reconciled entry in qbo as it was incorrect. I added in the correct entry from open uncollected deposits. this was done multiple times as the accountant wanted the uncollected deposits cleared up. They are now cleared up; however I cannot reconcile because now my beginning balance is off and it's because of all the deleted reconcile transactions. please help!
Let's ensure that this is resolved, so you can proceed with your reconciliation smoothly, bookkeeper_99.
If a reconciled transaction is deleted, edited, or moved to a different bank account, it will impact the ending balance of your last reconciliation. Consequently, the beginning balance of the next reconciliation will also be affected.
Since you have already recreated the transaction, you can manually change its status to "reconciled" to restore the correct balance.
Allow me to guide you through the entire process:
Just in case you still see an alert the next time you reconcile, open the discrepancy report. The deleted transaction may still appear on the list, but the difference should be $0.00.
Once you've thoroughly reviewed the discrepancy report and ensured everything is accurate, the Total Discrepancy Difference on the report should display US $0.00. Double-check the beginning balance again in QuickBooks to ensure that it matches the beginning balance on your bank statement.
Once you know your beginning balance is correct, you can now start reconciling.
Please feel free to save these articles for additional guidance or references whenever you are working with reconciliation in QBO:
The Community and the entire QuickBooks Team are always available and eager to assist whenever you need help.
You stated Jenop2:
"Just in case you still see an alert the next time you reconcile, open the
discrepancy report. The deleted transaction may still appear on the list,
but the difference should be $0.00"
I corrected a deleted reconciled transaction in the manner you outlined. However I do not have a difference of $0.00 in the Discrepany Report for both accounts. Just one. Both accounts have been successfully reconciled after re-entering the deleted transaction. I have restarted QB Desktop as well.
How to I fix the Discrepancy Report?
Hello, ARbooks.
Form your description, you're on the right track in correcting a deleted reconciled transaction in QuickBooks Desktop (QBDT). You'll have to do the same process to your other account, so its discrepancy report will also show a difference of $0.00. I'll elaborate this in detail below.
Once your other account also has a deleted reconciled transaction, re-enter it and manually change its status to "reconciled" to correct its discrepancy. Follow the steps shared by my colleague above to complete the process.
Furthermore, I'd still recommend consulting your accountant to further guide you in keeping your accounts and financial data accurate.
You can learn more about fixing reconciliation discrepancies in QBDT by seeing this article: Fix beginning balance issues in QuickBooks Desktop.
Additionally, I encourage you to reconcile your accounts in QBDT regularly (every month). This helps monitor your income and expense transactions and detect possible errors accordingly. You may want to check out this article as your guide in doing and fixing reconciliations in QBO: Learn the reconcile workflow in QuickBooks.
I'm always ready to back you up if you need more help with bank reconciliation in QBDT. I'll keep the thread open so you can comment back.
Hello,
I deleted and re-entered payments received but the beginning balance is still off and the deleted payments are still listed on discrepancy report. I'm afraid if I enter the deleted payments, they will show up as a double payment. Should I just enter a general journal entry to clear up the discrepancy for the beginning balance?
I understand your concern regarding the deleted payments and the persistent discrepancy in your QuickBooks beginning balance, @skennedy9907.
Thank you for bringing this to our attention, and I'm here to help you navigate this issue.
Entering a general journal entry can be a solution, but it's a step we should approach with caution to avoid any unintended complications. Before proceeding, let's explore an alternative avenue to address this problem.
The beginning balance will still be off because it was a deleted reconciled transaction. Let's make sure that by the time you recreate the transaction, you manually reconciled this on your account.
Here's how:
Moreover, I'll be sharing the following articles to help manage your transactions in QBO:
Please feel free to reach out to us at any time if you have further questions. We're committed to providing you with the best possible support, and your satisfaction is our top priority.
I am so sorry. I am not a Quickbooks person - but am willing to learn. Some how I deleted a transaction on a reconciled report for the end of May 2023. June report was approved as everything was still good at that point. Now I'm trying to reconcile and it won't let me and gives me the error. I know exactly what item I inadvertently deleted. How can I get it back? I show it. Have tried changing the "Not Cleared" to reconciled. Nothing seems to work. Please help.......................... Thank you!
I've come to help ensure your accounting data are accurately reconciled, jills83.
When a reconciled transaction is deleted from your account, you may need to recreate it manually to resolve any discrepancies in your accounts. To help you track and review the deleted entries, you can view them from the Audit log page. To do this:
Once ready, you can manually reconcile the transaction from your bank register. Here's how:
Then, you may run discrepancy reports to make sure the difference between the ending balance in QuickBooks and your bank statements is $0.00.
Once everything looks good, you can start reconciling these entries in the future to ensure your books are balanced.
We'll always be available in this forum if you require additional assistance managing your accounts. Please don't hesitate to leave them in the comments below. Keep safe!
I deleted 2 deposits by mistake (Quickbooks desktop) and both customer payments are still there, but do not show up in the register. They both show up in the Undeposited funds report as being received. How do I re-enter them into the register?
I've also undone all the previous bank reconciliations so that I may go back through again once they show up in the register.
Welcome to the Community, @22551. Let me help re-enter the deleted deposits in QuickBooks Desktop (QBDT).
Leaving it as Undeposited Funds is fine. However, you’ll want to delete the payment you deposited to the bank to avoid the fund overstating in your bank. Moving forward, I recommend manually receiving the invoice payment in QuickBooks Desktop (QBDT).
Once you’ve received the payment manually, you can now deposit the funds to your bank account. All payments in the Undeposited Funds account automatically show in the Bank Deposit window. Let me show you how in your QBDT software:
You can also check this article for more details about the process: Record and make bank deposits in QuickBooks Desktop.
I’ve also added this article that you can use for future guidance in effectively reconciling your accounts in QBDT: Reconcile an account in QuickBooks Desktop.
Let me know if you have other concerns about making deposits in QBDT, It's always my pleasure to help you out. Have a wonderful day ahead!
I have several transfers from checking to savings that were reconciled in checking, but not savings. When I reconciled savings, I noticed manually entered transactions that were duplicated. I deleted those and successfully reconciled savings. Apparently.. the ones I deleted were already reconciled in checking. SO now checking is not reconcilable. I've tried both creating the transaction again, and creating a journal entry as suggested, including marking the re-created transaction as (R) reconciled in the register. This does not get seen as a resolution to the reconcile, but adds another discrepancy to the beginning balance issue. I'm totally confused as to how to fix this.
I figured out my confusion. Recreating the new entry does not remove the discrepancy from the report. You just need the balance to match again. So if you had more than one issue, like I did, don't try to reconcile again until you've fixed all the issues. I do wish Quickbooks made it easier to see the linked transactions, or tells you that the transaction you are about to delete is reconciled in another account. I'm not an accountant and I can get seriously confused.
I cannot find the place where i can mark the transaction to R.
please help
Thanks for joining the thread, @lhill. I'm here to help you find where to mark a transaction as reconciled.
It's important to note that even small adjustments can throw off your accounts, so it's best to consult your accountant for advice.
Once you've identified the entry to reconcile, go to the chart of accounts and access the account's register to make the necessary changes. Here's how:
For more detailed information, visit this article: Undo or remove transactions from reconciliations in QuickBooks Online.
Additionally, you can close your books to prevent unwanted modifications to past transactions.
Shoot me a reply if you need further assistance with reconciling your transactions. Our priority is to make sure everything is in balance. Hope you have a great day ahead!
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.
For more information visit our Security Center or to report suspicious websites you can contact us here