cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
franky5
Level 1

Seeing a deleted transactions previous categorization

Hi,

I was in the process of reconciling an account and noticed that five transactions from a previous period have been accidentally deleted.

Is there a way to retrieve the details of these transactions and see how they were previously categorized?

Thank you.

5 REPLIES 5
GebelAlainaM
QuickBooks Team

Seeing a deleted transactions previous categorization

You can use the Audit log to recover the details of the deleted transactions so you can re-enter them, @franky5. I'll be happy to guide you with the steps below.

Beforehand, make sure to sign in as an admin to access the Audit log.

Here's how to locate and re-enter deleted transactions:
 

  1. Go to the Gear icon and select Audit Log.
  2. From the Filter dropdown menu, select the appropriate user, date, and event(s).
  3. Select Apply.
  4. Find the deleted transaction.
  5. Once you've located the deleted item, select View under the History column
  6. You'll see all the information needed for the transaction under the Event column.
  7. Use that details to re-enter the transaction with its original date.
     

After that, manually reconcile the transaction by going to your account register.
 

  1. Go to Transactions and select Chart of accounts.
  2. Locate the account that you put the transaction into and select Account history.
  3. Find the transaction and select it to expand the view.
  4. Select the box in the tick column until you see an R to manually reconciles the transaction.
  5. Click Save.
     

Additionally, you can check out these articles for more details in managing audit log and how to fix issues for accounts you've reconcile in the past:
 

Furthermore, once you've successfully reconciled you transactions in QuickBooks, you can check out these links for future reference in managing a reconciliation report: View, print, or export a reconciliation report in QuickBooks Online.

Feel free to click the Reply button if you have questions in handling your bank transactions or any other banking concerns. I'm always here to help you.

franky5
Level 1

Seeing a deleted transactions previous categorization

So QB is saying these five transactions have been deleted, which has thrown off the beginning balance by over -$50,000 when reconciling. 

 

When reviewing these transactions figures, I can still see the exact amounts in the account reconciled — they haven't been deleted?... It appears these transactions were transfers between two accounts in QuickBooks, and I’m wondering if that might be the issue. Perhaps they were marked incorrectly or removed from one side of the transfer?

I’m unsure whether I should re-upload them or leave them as-is, since I can already see those exact totals of the 5 transactions still reconciled in the account? 


I am confused on what I should do?

JorgetteG
QuickBooks Team

Seeing a deleted transactions previous categorization

The transactions in question have not been deleted but may have been changed or recorded differently due to account transfers.

 

To address and clarify this situation, please follow these steps:

 

  1. Verify Transfer Details: Check the Account Register for both accounts involved to ensure that each debit entry in one account corresponds with a credit entry in the other and vice versa, confirming the accurate recording of transactions.
  2. Reconcile with Bank Statements: Cross-reference your QuickBooks data with the relevant bank statements. This step will help confirm whether the transfer entries accurately reflect bank activities.
  3. Hold Off Re-Uploading Transactions: Let's refrain from re-uploading transactions without confirming their current status to avoid duplicates.

 

If the transactions went to the wrong account, you can undo the reconciliation and transfer them to the correct account. Once you have made the necessary adjustments, you can reconcile the account again.

 

It might be beneficial to consult with an accountant. They can provide a more in-depth analysis and guide you through the correction process.

 

Additionally, you can run and print a reconciliation report for the affected accounts to compare the initial balance with the current balance in QuickBooks, helping you identify any discrepancies.

 

Furthermore, explore these articles to learn how to organize your downloaded transactions in QuickBooks Online:

 

 

We appreciate your time revisiting this thread and cooperation, Franky5. Please let us know if you need more help with your reconciliation, deposits, invoices, or anything else. We are here to help you.

franky5
Level 1

Seeing a deleted transactions previous categorization

Hi QB,

 

Thanks so much for this.

 

So I have worked out what's happened, after reconciliation happened these transactions were re-categorised to a different account...

 

Therefore they are not missing, just re-categorised after reconciliation happened. How am I meant to fix this issue now that i do not need to reupload anything?

Thanks so much :)

JorgetteG
QuickBooks Team

Seeing a deleted transactions previous categorization

I'm glad you have made significant progress in understanding what happened with your transactions after reconciliation, Franky5. Let's manually edit these transactions to ensure they are categorized correctly.

 

Here's how:

 

  1. Go to the Gear icon and select Reconcile.
  2. Choose the account you want to reconcile. You may see a message stating, "Your account isn't ready to reconcile yet." Click the hyperlink "We can help you fix it."
  3. In the reconciliation discrepancy report, select the miscategorized transaction and click Edit.
  4. Select the correct account in the Deposit to section, then click Save and Close.
  5. Repeat this process for any other miscategorized transactions. They should now be reflected correctly in the register.

 

Once you’ve made these changes, let's manually reconcile the transactions by going to your account register:

 

  1. Go back to the Gear icon and choose Chart of Accounts.
  2. Find the account with the recorded transactions and click on Account History.
  3. Look for each transaction, and click the box in the checkmark column until you see an "R" for reconciled.
  4. Finally, click Save.

 

After completing these steps, the error message "Your account isn't ready to reconcile yet" should no longer appear, and you should be ready to reconcile your account again. Ensure that the beginning and ending balances match your relevant statement.

 

 

Additionally, you can refer to this article after reconciling your account to avoid discrepancies and ensure your account remains accurate: View, print, or export a reconciliation report in QuickBooks Online.

 

We appreciate you for keeping us informed. Please feel free to reach out if you have any updates or need help as you continue reconciling your account. We are here to assist you.

Need to get in touch?

Contact us