QuickBooks for Mac 2014 User’s Guide 70
6 Press Command + v to paste the column in.
7 Repeat steps 4-6 for all the columns in the QuickBooks spreadsheet.
8 Add an Income Account to every item now listed in the QuickBooks window if you didn't have this
info in your original spreadsheet. It's a required field.
9 (Inventory Items only) Add a COGS Account and an Asset Account for every item now listed in the
QuickBooks window if you didn't have this info in your original spreadsheet. They are required fields.
10 Make sure the Import box is checked for every item row.
11 Click Import.
12 Click OK when QuickBooks finishes importing your items.
13 You're done! All your items are now in QuickBooks. Go to Lists > Items to see the items you just
imported.
Troubleshooting when the import fails
Did you get a message in the Import status window that says you have errors in some of your items? We can help
you fix them.
1 Close the Import status window by clicking OK.
2 On the spreadsheet, look for the items that have red Xes on the far left side.
3 Click on the item with the red X. A message pops up to the right of the item's row describing what
went wrong.
4 Fix the items with the red Xes and click Import again.
5 Click OK when QuickBooks finishes importing your items.
Other things to know about items
Now that you know all about creating different types of items, I’m going to tell you how to change the price of
items and create subitems.
Changing the price of items
Got something selling like fans in a heat wave? Maybe you should apply a little supply and demand theory and
change the prices. Here’s how.
To change prices to a specific amount:
1 Choose Lists > Items.
2 Control-click the item name and choose Change Prices from the shortcut menu.
To Next Page
Loading...