Level 2

Reconciled bank statement but some of the transactions were deleted and recreated for that month

Hi, each month, I reconcile the bank statement for the balance to zero out. However, some of the reconciled transactions were deleted and recreated. Now when I go to the previous reconciled statements, it tells me the transactions that were deleted and shows a negative number. I did manually change the deleted and recreated trnsactions to “R” ... is that good enough? Or im i missing a step here. Thank you.

QuickBooks Team

Reports and accounting

Hi there, @MohamedRashid.  


Thank you for reaching out to the Community. Yes, you're doing it correctly. After recreate the transaction, we can go back to your register and change it's status to Reconciled (R) manually. You can use this article for the detailed steps: How to undo and remove transactions from reconciliations in QuickBooks Online.  


You can also review the Audit Log to see the details and recreate it manually. Here's how:


  1. Click the Gear icon in the upper-right corner and tap Audit Log.
  2. Look for the deleted transaction and click View.
  3. Press the arrow on when it was created and deleted.
  4. Take note of the transaction details.
  5. Recreate the transaction manually by clicking the Create menu (+).






Stay in touch if you have additional questions about this. I'm always around in the Community to help you out.

View solution in original post

Level 2

Reports and accounting

Hi, thanks so much for the information. 


I went in and made sure all transactions that were deleted and recreated were reconciled "R." Please see screenshot. However, when I go to the reconciled report for that month, it still shows negative/deleted transactions (see screenshot). Is this fine?


Screen Shot 2020-05-09 at 12.49.44 PM.pngScreen Shot 2020-05-09 at 12.49.32 PM.png


Reports and accounting

I appreciate the steps you performed to resolve your issue, @MohamedRashid.


Let me add some information about reconciling the recreated transaction. Since you've already deleted this reconciled transaction once, this will show changes in the reconciliation history.


The purpose of recreating and manually marking it as reconciled is to amend the opening balance for the current reconciliation. However, the Reconciliation Change report will still show the changes made on your previous reconciliation.


Let me know if you have follow-up questions regarding the reconciliation process or anything related to QuickBooks. I'm glad to help.

Level 2

Reports and accounting

Ah okay got it. So basically it will still show the changes made in previous reconciliation but as long as I have manually done the recreated transaction, I should be good to go right? No further steps I need to do?

QuickBooks Team

Reports and accounting

That is correct, MohamedRashid.


Just make sure to manually mark the recreated transaction as reconciled. 


You'll also want to keep this article just in case you might need them in your future reconciliations: How do I view, print, or export a reconciliation report?.


As always, you can add another reply or visit us again if you need anything else.