Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowI'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! Go to Solution.
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:
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!
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:
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!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.