Most businesses of different types have built their trust in QuickBooks Accounting Software to manage their business accounts. Out of many, one significant function of QuickBooks is the Inventory Tracking. If you have set up your data in the correct format, you can easily add new inventory items to your QuickBooks. The process of importing and updating inventory can be achieved by successfully completing two different procedures, they are; enabling inventory tracking and importing the list of inventory with the updated quantities. Inventory Tracking enables you to automatically update any change in inventory when you purchase inventory items. By turning on Inventory Tracking, you can easily “update and import your inventory with an Excel spreadsheet“.
- 1 keep in Mind when you Import and Export Data: Backup QuickBooks Data
- 2 How to Import and Update Inventory in QuickBooks?
- 2.1 Step 1: Create an Excel spreadsheet
- 2.2 Step 2: Update Company File
- 2.3 Step 3: Add Your Data to QuickBooks
- 2.4 Step 4: Select the Advance Import
- 2.5 Step 5: Select the Particular Sheet that you want to Import
- 2.6 Step 6: Choose a Mapping
- 2.7 Step 7: Select the Appropriate Quicken Header Title
- 2.8 Step 8: Verify and see the Imported Item
- 2.9 Step 9: Completed Mapping or Re-mapping
keep in Mind when you Import and Export Data: Backup QuickBooks Data
How to Import and Update Inventory in QuickBooks?
Below are the steps that show you “How to Import and Update Inventory in QuickBooks.” Follow each instruction carefully so that you are successful in importing and updating your QuickBooks inventory.
Total Time: 35 minutes
Step 1: Create an Excel spreadsheet
🔹 Create an Excel spreadsheet. This should include the inventory items in columns that you like to import along with header titles that match the column headers in the inventory list within your QuickBooks.
Step 2: Update Company File
🔹 Open your QuickBooks and then go to the company file that you want to update.
Step 3: Add Your Data to QuickBooks
🔹 View the Program Menu and then click on File.
🔹 Now, click on Utilities, then select Excel Files.
🔹 A dialogue box will appear to you, click on Add Your Data to QuickBooks option.
Step 4: Select the Advance Import
🔹 Next step, select the Advance Import and then click on Browse in order to locate the file, which you aim to import to your computer.
🔹 You may select from Excel and CSV files.
Step 5: Select the Particular Sheet that you want to Import
🔹 Select the filename by double-clicking on it and then select Open.
🔹 If you see that the spreadsheets are an Excel file which has a number of different sheets, then drop-down the Excel workbook
🔹 Select the particular sheet that you want to import.
🔹 See that you don’t select those files that contain header rows.
Step 6: Choose a Mapping
🔹 From the drop-down menu beside Choose a Mapping, click on Add New.
🔹 A Mappings Window will be displayed to you.
Step 7: Select the Appropriate Quicken Header Title
🔹 Select the name of the header titles in the spreadsheet in order to view a drop-down menu
🔹 Select the appropriate Quicken Header Title
Step 8: Verify and see the Imported Item
🔹 After you have completed mapping the header titles, click on Save.
🔹 Also, press on Preview to verify and see the imported item.
🔹 If it is incorrect, click on Cancel and re-map the columns again.
Step 9: Completed Mapping or Re-mapping
🔹 If you have completed mapping or re-mapping click on OK and then select Import.
🔹 A dialogue appears to you and presents the summary of your records.
🔹 To end, select Save.
🔹 The create inventory list will be seen on the screen with the new items.
If you are still unsuccessful in importing and updating your inventory by following the step given above or if you want more information about “How to Import and Update Inventory in QuickBooks?,” kindly call us or send your mail to email@example.com. You can also reach us through QuickBooks Support available on our Website. We will be delighted to hear from you.