Created with Sketch.Learn about PPP and Loan Forgiveness, stay informed with the latest changes.
Created with Sketch.Questions about how to close your books for 2020? Visit our Year End Resources page.
Created with Sketch.New to QuickBooks or using a new product? Visit our Get Started resource page to help you get going.
Created with Sketch.Need to make changes to your account? Visit the Account Manager Portal.
cancel
Showing results for 
Search instead for 
Did you mean: 
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.

Solved
Best answer May 08, 2020

Best Answers
QuickBooks Team

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

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 (+).

aud.PNG

aud1.PNG

 

aud2.PNG

 

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

5 Comments
QuickBooks Team

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

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 (+).

aud.PNG

aud1.PNG

 

aud2.PNG

 

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

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

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.png Screen Shot 2020-05-09 at 12.49.32 PM.png

Moderator

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

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

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

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

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

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.

Need to get in touch?

Contact us