Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Simplify payday and set payroll to run automatically on QuickBooks.Explore QuickBooks Payroll
EC_22
Level 1

Help with recreating a deleted transaction

I am trying to fix the error message I am receiving under the reconciliation window.  Looks like 4 transactions that were marked R in the previous month were deleted .  How do I fix this?  I looked at the Fix the beginning balance issues video, and did the steps to recreate the deleted transactions, but when I go into the accounts payable through the COA, and find the transaction, I am not able to put an R to show it was reconciled. 

1 Comment 1
JessT
Moderator

Help with recreating a deleted transaction

Hi EC_22,

 

Accounts Payable transactions are basically bills and are not for reconciliation. Therefore, your deleted transactions are likely bill payments which are also reflected in the bank register. You can recreate them by paying the bills and putting an R mark on each payment to indicate that they have been reconciled.

 

mark as reconciled.PNG

 

On the other hand, when the reconciled transactions are deleted, the reconciliation report of that period will reflect that change. In addition, the closing account balance during that period will become incorrect due to these missing transactions.

 

 

Recreating the deleted transactions and marking them as reconciled (R) will correct the closing account balance, but the reconciliation report will remain to show that they've been deleted. This is because QuickBooks uses transaction IDs in reconciliation reports. Although you recreate them, still the original transactions (based on their IDs) are being reported. Some users are okay with having a discrepancy in the report as long as the account balance is corrected. However, most users would choose to redo the reconciliation to have a new and perfect reconciliation report.

 

If you wish to redo your reconciliation, you need to unreconcile (remove the R marks) all transactions of the affected period first. Then, reconcile them the usual way.

 

  1. Go to Bookkeeping or Accounting, then select Chart of accounts.
  2. Select View register on the account in concern.
  3. Click each transaction of the affected period, and click their R marks until it changes to C (Cleared) or blank. Do this one at a time.
  4. Select Save and select Yes to confirm.

 

Here's an article with a video tutorial that explains how to fix issues like this:  Fix issues for accounts you've reconciled in the past in QuickBooks Online.

 

You can always go back to this thread if you have any other questions about correcting your reconciliation. Take care and have a good one!

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us