cancel
Showing results for 
Search instead for 
Did you mean: 
AccountingGF
Level 2

Non-Inventory item import

I've imported an excel file to our item list.  The sales prices came into QuickBooks with 4 decimal places (50.4900), even though they were formatted in excel prior to the import as a number with 2 decimal places (50.49).

Is there an excel format I should have used to get the sales price to display as 50.49?

Solved
Best answer June 09, 2020

Best Answers
MJoy_D
Moderator

Non-Inventory item import

Hello, @AccountingGF

 

You can edit those imported items one by one to update the sale price. However, when you create those transactions, the amount that will show is up to two decimal places. 

 

To update the sale price per item:

  1. Go to List and click Item List.
  2. Double-click the item.
  3. Update the Sales Price.
  4. Click OK once you’re done. 

You can check out this article to know more about editing items in QuickBooks: Add, edit, and delete items.

 

Let me know if there's anything that I can further assist. Have a great rest of the day!

View solution in original post

1 Comment 1
MJoy_D
Moderator

Non-Inventory item import

Hello, @AccountingGF

 

You can edit those imported items one by one to update the sale price. However, when you create those transactions, the amount that will show is up to two decimal places. 

 

To update the sale price per item:

  1. Go to List and click Item List.
  2. Double-click the item.
  3. Update the Sales Price.
  4. Click OK once you’re done. 

You can check out this article to know more about editing items in QuickBooks: Add, edit, and delete items.

 

Let me know if there's anything that I can further assist. Have a great rest of the day!

Need to get in touch?

Contact us