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

Merged 2 accounts by mistake - possible to restore?

Hello! I'm hoping someone can provide guidance. The original goal was to change our sales tax mapping so that when invoices were created, the line item for sales tax was mapped to a liability account. In the past, the company didn't collect sales tax and was responsible for paying it, so there was an expense account on the P&L with past activity. When an employee went to make this change to the mapping, they instead merged the 2 accounts instead which has caused our historical transactions to now be incorrect. Is it possible to restore these 2 accounts? I have a backup file that I can get the historical data from but I'm not sure how best to proceed, I don't want to restore the whole file because it was from last month and I don't want to lose all the activity since. (If it helps, I'm using Enterprise 2019 on a hosted desktop).

 

Thanks in advance!

Solved
Best answer April 20, 2021

Best Answers
RenjolynC
QuickBooks Team

Merged 2 accounts by mistake - possible to restore?

Hi there, PE_CSA.

 

I appreciate your time visiting us here.

 

Currently, we're unable to undo the merge process. What you can do is record the new activities before restoring the old backup. Before doing so, make sure to create a backup copy of your current data to avoid any problems moving forward.

 

You also have the option to add a new account and create a journal entry to move the historical transactions from the old one. I'd still recommend consulting your accountant on the accounts affected to make sure your reports are accurate. 

 

I've got these articles that you can use as a guide:

 

 

Please let me know if you have any additional questions or other concerns. I'll be right here to answer them. Stay safe!

View solution in original post

5 Comments 5
RenjolynC
QuickBooks Team

Merged 2 accounts by mistake - possible to restore?

Hi there, PE_CSA.

 

I appreciate your time visiting us here.

 

Currently, we're unable to undo the merge process. What you can do is record the new activities before restoring the old backup. Before doing so, make sure to create a backup copy of your current data to avoid any problems moving forward.

 

You also have the option to add a new account and create a journal entry to move the historical transactions from the old one. I'd still recommend consulting your accountant on the accounts affected to make sure your reports are accurate. 

 

I've got these articles that you can use as a guide:

 

 

Please let me know if you have any additional questions or other concerns. I'll be right here to answer them. Stay safe!

PE_CSA
Level 1

Merged 2 accounts by mistake - possible to restore?

Thank you for your response! Originally I was under the wrong impression that I would overwrite my current file, but in reading through the article you provided for restoring a backup file, I was able to avoid that. Thanks again!

Candice C
QuickBooks Team

Merged 2 accounts by mistake - possible to restore?

Good afternoon, @PE_CSA

 

Thanks for getting back to us. Allow me to step and provide you with some insight to help fix this problem. 

 

The best way to resolve this is by restoring the backup and save it somewhere else to use as a "test file" and compare data. However, you'll want to ensure that the name of the backup is different, and you move it so nothing will override the current file and replace it.

 

Here's an article that will guide you on how to restore the backup

 

This should do the trick. If you're still having issues, I recommend contacting our Customer Support Team. They'll be able to use other tools to review your file. If you have any other questions, don't hesitate to ask. Have a good day! 

Doreen44
Level 1

Merged 2 accounts by mistake - possible to restore?

ok i still don't under stand why i cant  see the account

what about he tax code that was deleted in error it say you can restore that but it

not in the inactive list - and that tax code is still linked to some things

its very confusing -

If i want to change the tax codes for everything at once how do i do that?

Some things are showing the old tax code and some the new one

I need to fix this

SirielJeaB
QuickBooks Team

Merged 2 accounts by mistake - possible to restore?

Hello there, @Doreen44.

 

I understand the importance of tax codes in maintaining an accurate sales record by keeping track of taxable and non-taxable sales and customers in QuickBooks Desktop (QBDT). 

 

QBDT does not allow you to change tax codes all at once. You may run a Sales Tax Revenue Summary or Sales Tax Liability report that provides a summary of sales by tax agency and sales tax code. Here's how:

 

  1. Go to the Reports tab.
  2. Choose Vendors & Payables. 
  3. Select Sales Tax Liability or Sales Tax Revenue Summary.

 

Once done, review the reports to determine non-taxable and taxable codes in Quickbooks, and then manually edit the tax codes for those accounts you want to change. 

 

 To edit the non-taxable status of an item:

 

  1. Select Item List from the Lists menu.
  2. Choose Item from the Item List window, then click Edit Item.
  3. From the tax code drop-down, choose Non-Taxable Sales.

 

 To edit the non-taxable status of a customer:

 

  1. Select Customer Center from the Customers menu.
  2. Select Edit by right-clicking the customer name you want to set up as non-exempt.
  3. Go to the Sales Tax Settings tab.
  4. From the Tax Code drop-down, choose Non-Taxable Sales.
  5. Click OK.

 

Check out these articles for more detailed information:

 

 

If you need to adjust the sales tax amount you owe, you may read this article for reference: Process sales tax adjustment.

 

Click the Reply button if you need further assistance or have additional questions about managing your tax codes. Stay safe, Doreen. 

 

Need to get in touch?

Contact us