cancel
Showing results for 
Search instead for 
Did you mean: 
ATestaPBC
Level 2

Fixing Deleted Transaction to Begin a Reconcilation

After I had reconciled my accounts for 2023, I realized that two transactions were entered incorrectly. The first was a refund from an overpayment from a customer, the second was a mis-categorization of a check written for a partner. Once I changed these, the original reconciled transactions were deleted and now before I can do the January 24 reconciliation, I have an error in the amount of those two deleted transactions. How can get back to the $0 amount? I've tried to follow the examples, but none seem to match what I did and how I can't fix it to get a difference of $0. HELP!

Solved
Best answer January 30, 2024

Best Answers
ChristineJoieR
QuickBooks Team

Fixing Deleted Transaction to Begin a Reconcilation

It sounds like you're facing a reconciliation issue in your accounting records, ATestaPBC. When you modify or delete reconciled transactions, it can indeed cause discrepancies in your reconciliation. Let me help you fix this. 

 

First, review the changes you made to the transactions. Ensure that the modifications accurately reflect the actual transactions and that they are now correctly categorized. You can also refer to your bank statement so you can identify duplicate transactions.

 

If you want to make corrections, review each transaction in the report one at a time by running the reconciliation discrepancy report. Use it to decide if and how to make changes by selecting the View and then Change Type.

 

Nonetheless, if you need to remove duplicate transactions, we can undo reconciled transactions at a time, by clicking the status. through this, the transaction will be removed from the reconciliation page. Once done, you need to reconcile your account again.

 

Follow the steps below:

 

  1. Go to the Gear menu and click Chart Of Accounts.
  2. Choose the bank account you want to un-reconcile and click the blue View Register hyperlink on that row.
  3. Find and select the transaction you need to unreconciled.
  4. Look in the column just to the right of the Deposit column. This column is the Reconciliation Status column.
  5. To undo the reconciliation of this transaction, click the R (for reconciled) until the field is blank.
  6. Click the green Save button.
  7. Now find and select the transaction.
  8. Click the blank or (for Cleared) to (Reconcile).
  9. Click the green Save button.

 

Moreover, if you will need an easy way to undo the reconciliation and change the year date if you have already concluded the process, only QuickBooks Online Accountant has the Undo feature. I would advise bringing your accountant in to undo the whole reconciliation period.

 

Here's how:

 

  1. Click the Gear icon in the upper right corner, and select Manage Users.
  2. Go to the Accounting Firms tab, enter the accountant's email, and click the Invite button.
  3. Hit Save.
  4. Once invited, have your accountant undo the whole reconciliation.

 

If you run into any mistakes when reconciling your accounts, the article will show you how to repair them: Fix issues at the end of a reconciliation in QuickBooks Online.

 

 If you're still unable to resolve the issue, it may be beneficial to seek assistance from a professional accountant or bookkeeper who is familiar with QuickBooks Online. They can provide personalized guidance based on the specific details of your situation.

 

Remember to keep a record of all the changes you make to your accounts for future reference and auditing purposes. If you have specific questions or need further assistance, feel free to provide more details, and I can offer more tailored advice.

 

View solution in original post

3 Comments 3
ChristineJoieR
QuickBooks Team

Fixing Deleted Transaction to Begin a Reconcilation

It sounds like you're facing a reconciliation issue in your accounting records, ATestaPBC. When you modify or delete reconciled transactions, it can indeed cause discrepancies in your reconciliation. Let me help you fix this. 

 

First, review the changes you made to the transactions. Ensure that the modifications accurately reflect the actual transactions and that they are now correctly categorized. You can also refer to your bank statement so you can identify duplicate transactions.

 

If you want to make corrections, review each transaction in the report one at a time by running the reconciliation discrepancy report. Use it to decide if and how to make changes by selecting the View and then Change Type.

 

Nonetheless, if you need to remove duplicate transactions, we can undo reconciled transactions at a time, by clicking the status. through this, the transaction will be removed from the reconciliation page. Once done, you need to reconcile your account again.

 

Follow the steps below:

 

  1. Go to the Gear menu and click Chart Of Accounts.
  2. Choose the bank account you want to un-reconcile and click the blue View Register hyperlink on that row.
  3. Find and select the transaction you need to unreconciled.
  4. Look in the column just to the right of the Deposit column. This column is the Reconciliation Status column.
  5. To undo the reconciliation of this transaction, click the R (for reconciled) until the field is blank.
  6. Click the green Save button.
  7. Now find and select the transaction.
  8. Click the blank or (for Cleared) to (Reconcile).
  9. Click the green Save button.

 

Moreover, if you will need an easy way to undo the reconciliation and change the year date if you have already concluded the process, only QuickBooks Online Accountant has the Undo feature. I would advise bringing your accountant in to undo the whole reconciliation period.

 

Here's how:

 

  1. Click the Gear icon in the upper right corner, and select Manage Users.
  2. Go to the Accounting Firms tab, enter the accountant's email, and click the Invite button.
  3. Hit Save.
  4. Once invited, have your accountant undo the whole reconciliation.

 

If you run into any mistakes when reconciling your accounts, the article will show you how to repair them: Fix issues at the end of a reconciliation in QuickBooks Online.

 

 If you're still unable to resolve the issue, it may be beneficial to seek assistance from a professional accountant or bookkeeper who is familiar with QuickBooks Online. They can provide personalized guidance based on the specific details of your situation.

 

Remember to keep a record of all the changes you make to your accounts for future reference and auditing purposes. If you have specific questions or need further assistance, feel free to provide more details, and I can offer more tailored advice.

 

ATestaPBC
Level 2

Fixing Deleted Transaction to Begin a Reconcilation

Thank you I was able to correct the deleted transactions.

AbegailS_
QuickBooks Team

Fixing Deleted Transaction to Begin a Reconcilation

Thanks for getting back, @ATestaPBC.

 

I'm glad to hear that the steps provided by the previous representative helped correct the deleted transactions. Thank you for acknowledging their assistance. If you have any further questions or need any more help, please don't hesitate to reach out. We're here to support you!

Need to get in touch?

Contact us