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

QB Online Fixing Deleted Transactions

Hello,

 

I inadvertently deleted some reconciled transactions, and now I'm getting the message saying I can't reconcile until I fix those transactions.  I've followed the directions I've been able to find online, but so far nothing has worked.  Recreating the transactions and manually marking them as reconciled just adds more lines that it says need to be fixed.

6 Comments 6
MaryJoyD
QuickBooks Team

QB Online Fixing Deleted Transactions

Let's fix the error you have with your reconciliation, @mikeyontsfilm.

 

You can fix those deleted reconciled transactions by manually adding them back and making sure to add an R in the checkmark column. 

 

I also suggest running a past reconciliation report, then review your bank statements. For transactions that were on the previous bank statement but weren't on the reconciliation for those dates, you can add it manually.

 

Here's how to run the report:

  1. Go to Reports menu and enter Reconciliation Reports in the Find report by name search bar.
  2. Select Reconciliation Reports.
  3. Select the Account for the reconciliation report you want to view.
  4. From the Report period drop-down arrow, choose the reconcile period.
  5. Select View Report.

After manually adding those transaction, you can now mark them as reconciled:

  1. Go to the Accounting menu and proceed to Chart of Accounts.
  2. Find the account you’re reconciling and select View register.
  3. Click the transaction to expand the view.
  4. Select the box in the checkmark column until you see the letter R.
  5. Click Save once you're done.

You can read through this article for more details in troubleshooting reconciliations: 

Reach out to me if you have other questions in reconciling your accounts. I'm always here to help. Have a great rest of the day!

mikeyontsfilm
Level 2

QB Online Fixing Deleted Transactions

I've followed these directions and it still doesn't seem to be working.  For example, there's a $120 deposit in checking, in March of this year.  I enter the transaction, click until there's an R, and go back to the reconciliation report to see the deposit still listed as deleted.

 

When I look in the register, the deposit is there, and it matches my bank statement.

MaryLandT
QuickBooks Team

QB Online Fixing Deleted Transactions

Let me clear things out for you, mikeyontsfilm.

 

You don't have to worry about the deleted entry on your reconciliation report.

 

QuickBooks Online will record all deleted entries you've made from the previous reconciliation. Hence, they'll remain on the report even if you re-enter them.

 

I'm adding this link for your reference on your next reconciliation process: Reconcile an account in QuickBooks Online.

 

Stay in touch with me if you need assistance when reconciling your bank accounts. I'm always glad to help you.

mikeyontsfilm
Level 2

QB Online Fixing Deleted Transactions

OK, I see--looks like I'm back to reconciling normally.  Thanks!

KBurlingame
Level 1

QB Online Fixing Deleted Transactions

I had to rerun ADP entries and deleted the previously reconciled ones.  My balance matches the bank but when I try to reconcile, it says my beginning balance is off and will not let me.  The detail shows the deleted items as the problem.  How do I fix this so that I can reconcile?

katherinejoyceO
QuickBooks Team

QB Online Fixing Deleted Transactions

Welcome and thanks for joining in this thread, @KBurlingame. When previously cleared and reconciled transactions are voided or deleted, that will cause the beginning balance issue. 

 

Let's run the Reconcile Discrepancy report to find the transactions causing the issue. Here's how:

 

  1. Go to the Reports menu, then select Banking
  2. Select Reconciliation Discrepancy, then select the appropriate Account
  3. Click OK

 

You now have a list of transactions that were changed since the last reconciliation. Use this report to identify the transaction/s causing the issue. Once you found a discrepancy, note the transaction date and the Entered/Last Modified.

 

Then, re-enter the transaction by creating a journal entry using the info you've found in the report. Here's how: 

 

  1. In the Company menu select Make General Journal Entries.
  2. Change the date to the correct statement date of your beginning balance.
  3. On the first line, select the appropriate account from the Account drop-down.
  4. Enter the correct opening balance in the Debit column.
  5. On the second line, select Opening Balance Equity, then Save.

 

Once done, do a mini-reconciliation. I'd recommend consulting your accountant to guide you with this.

 

Here's the link that contains additional insights in fixing the beginning balance issue in QBDT. 

 

You can also watch a quick video tutorial as your visual guide in correcting your beginning balance in QuickBooks. 

 

Get back to this thread if you have additional concerns. We're always around to answer your next posts. 

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us