QuickBooks POS Pro update

You can add new inventory items into QuickBooks via a correctly formatted spreadsheet.

Jupiterimages/Comstock/Getty Images

Businesses of all size rely on QuickBooks to manage their finances. Advanced functions of QuickBooks include inventory tracking. If you need to add items to your company’s QuickBooks database, it is a simple process if you import data from a spreadsheet. As long as your data is in the right format, you can seamlessly add new inventory items to QuickBooks.

Create an Excel or a comma-separated values spreadsheet that includes the inventory items you want to import in columns with header titles that correspond to the column headers in your inventory list within QuickBooks. The column headers titles include: Item Name, Inventory Item Type, Description of the Item, Name of the Income Account, Name of the Asset Account, Name of the COGS Account, On Hand Quantity, Cost of Item, Sales Price, Total Value, As Of Date and Is Passed Thru. Intuit provides a detailed description of these items on its support website.

Open QuickBooks. Open the company file for the business you want to update with new inventory from the dialog that appears that appears on the screen.

Click "File" from the program menu. Select "Utilities. Click "Import, " select "Excel files." An "Add Your Excel Data to QuickBooks" dialog appears.

Click "Advanced Import." Click "Browse" to locate the file that you want to import on your computer. You can choose from Excel and .csv files.

Double-click the filename or select it and click "Open." If the spreadsheet is an Excel file with multiple sheets, select the sheet you want to import data from in the "Choose a sheet in this Excel workbook" drop-down menu. Deselect the "This data file has header rows" box.

Choose "Add New" from the drop-down menu next to "Choose a mapping." If you set up your columns correctly in your spreadsheet, you will have no problems with data mapping, matching the columns in the Quicken inventory data with your imported spreadsheet. A "Mappings" window appears with a list of Quicken inventory column header titles on one side and the column header titles of your spreadsheet on the other side.