How do I insert all the product and service information?

If you have found the information on my blog to be useful, please consider donating a few bucks today; click Donate icon button. Thank you!





Question:

US QuickBooks Online Edition

I will like to insert all the product and service information. and it is alot of them I will like to insert them all together

Answer:

Here’s how to import your products and services from an Excel file. If you’d like, you can download spreadsheet sample file to start from:

  1. Choose Company > Import Data.
  2. Click Products and Services List.
  3. Click Choose File to find your file, then click Open.
  4. Click Continue.
  5. The QuickBooks Online fields and your fields will be shown. Click the drop-down lists to change how your information is mapped. You can also check the box under I sell this or I buy this, but be aware that inventory won’t be imported.
  6. If you’re missing critical data, we’ll alert you with a warning icon.
  7. Click Continue.
  8. Adjust your data if necessary.
  9. When you’re ready, click Import [number] Records.
  10. If we perceive an error, such as a duplicate item already in QuickBooks Online, or an invalid field, we’ll give you an opportunity to correct the data and re-import the modified records; you can also choose to ignore the records.

Additional information:

  • You’ll have to select a parent income and expense account for each line item (sub-accounts and COGS can’t be used). Make sure you select the proper accounts here or it will affect your reporting,
  • Importing a Products and Services list is additive. In other words, it ammends the existing list by adding the new items, not erasing the ones that are already there. So if you’ve already got a list with Boots, Sales and Service on it, and you import a list from Excel with Shoes, the new Products and Services list will have all four items: Boots, Sales, Service and Shoes.
  • You can’t undo this import.

 

If you have found the information on my blog to be useful, please consider donating a few bucks today; click Donate icon button. Thank you!