View Single Post
  #2   Report Post  
Roger Govier
 
Posts: n/a
Default

Hi

In Quickbooks, FileImportExcel Enter Excel File Name, Enter Sheet name in
dialogue box, check the Data File has header rows (assuming you have set up
column Names)

In Choose a Mapping, use the dropdown to Create New
Give it a Name e.g. Inventory
Select the Import type Customer, Supplier, Item or Account
You need Item, then map your column headings in the Excel file to the
headings in Quickbooks for as many columns as you wish to import.

Regards

Roger Govier


grampski wrote:
I have an Excel inventory spreadsheet and would like to import the data into
Quickbooks 2004 as items.