SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends June 27

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
AW-TORI
Level 1

Creating a new company file from existing file to make a new inventory.

Our inventory is a mess and all of the quantity on hand values/in stock are incorrect. This has been this way for years and we just adjust it on our balance sheet to the actual values for tax time and just create a journal entry. That being said, 

How can I create a new company file from our existing one with all of our data besides the inventory portion so that we can create an entirely new and true inventory system? 

3 Comments 3
jamespaul
Moderator

Creating a new company file from existing file to make a new inventory.

Hello, AW-TORI.

 

I'll explain the process of creating a new company file from your existing one, so you can create a new inventory system. 

 

The best way to handle this is to create a new company file, then import your current data to the new one. 

 

The general idea for this process is to export your lists (except inventory) for cleanup, then import them to the new file. 

 

Although, we can include the inventory portion. Ideally, we would want to check your correct inventory count, then enter the accurate data on the exported file. 

 

The first step is to check and take note of your vendor, customer, and account balances. We would want to get a copy of the figures before we proceed with the import process. 

 

To do this, we can run some reports. Go to the Reports menu, and open the following: 

 

  • Account balances: hover on Company & Financial, then select Balance Sheet Detail.
  • Customer balances: Go to Customers & Receivables, then select Customer Balance Detail.
  • Vendor balances: Go to Vendors & Payables, then select Vendor Balance Detail.

 

On the report screen, click the Print button if you want to keep a hard copy. We can also select Save as PDF if you want to get a digital copy. 

 

Next, let's export the data out of the existing company. 

 

After exporting, we would essentially want to clean up your lists, and if included, your items. When cleaning, enter the correct quantity on hand to ensure we'll have an accurate record on the new company file. 

 

A detailed guide for exporting and cleaning your lists can be found here: Export lists from the old company file into a new data file.

 

After exporting, let's create a new company file: 

 

  1. Go to File, then select Close company (if you're still viewing the existing company). We could also just open QuickBooks Desktop, then click on Create a new company
  2. Click on Create a new company
  3. Enter the details of the new company (based on the existing information). 

 

On the new company file, we can start importing your lists, then entering the beginning balances for the current period.

 

We'll want to use the reports we exported for the accurate current balance for accounts, vendors, and customers. 

 

Take a look at this guide if you want more details about the solution above: Start a new company file with data from your existing file

 

If you need help managing your items or inventory, take a look at this guide: Add, edit, and delete items

 

I'll also add this guide if you need to adjust your inventory quantities in the future: Adjust your inventory quantity or value in QuickBooks Desktop

 

Let me know if you have questions about managing your inventory in QuickBooks. If you need to take care of your balances, entries, or reports, add the details to your reply. I'm here to help. 

Fiat Lux - ASIA
Level 15

Creating a new company file from existing file to make a new inventory.

Prepare the inventory adjustment data with the following template to zero out your quantity.

RefNumberAccountTransaction DateMemoItemNew QtyNew ValueAdj QtyAdj ValueCustomerClass
1231-1Cost of Goods Sold31/12/2020Year End Inventory AdjustmentHardware10     
1231-1Cost of Goods Sold31/12/2020Year End Inventory AdjustmentDoor Frame10     
1231-1Cost of Goods Sold31/12/2020Year End Inventory AdjustmentCabinets  -1   
1231-2Cost of Goods Sold31/12/2020Year End Inventory AdjustmentWood Door 1000    
1231-2Cost of Goods Sold31/12/2020Year End Inventory AdjustmentInterior Door Kit   500 

 

 

 

then use one of the an importer tools

https://get.transactionpro.com/qbd

https://partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2

 

accounting-99119
Level 1

Creating a new company file from existing file to make a new inventory.

Did this end up fixing the inventory?

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

Need to get in touch?

Contact us