Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends June 27
Buy nowOur 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?
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:
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:
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.
Prepare the inventory adjustment data with the following template to zero out your quantity.
RefNumber | Account | Transaction Date | Memo | Item | New Qty | New Value | Adj Qty | Adj Value | Customer | Class |
1231-1 | Cost of Goods Sold | 31/12/2020 | Year End Inventory Adjustment | Hardware | 10 | |||||
1231-1 | Cost of Goods Sold | 31/12/2020 | Year End Inventory Adjustment | Door Frame | 10 | |||||
1231-1 | Cost of Goods Sold | 31/12/2020 | Year End Inventory Adjustment | Cabinets | -1 | |||||
1231-2 | Cost of Goods Sold | 31/12/2020 | Year End Inventory Adjustment | Wood Door | 1000 | |||||
1231-2 | Cost of Goods Sold | 31/12/2020 | Year End Inventory Adjustment | Interior 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
Did this end up fixing the inventory?
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here