Hi there, @rc68nyc.
I'm stepping into the thread to share with you some insights about updating item prices in QuickBooks Desktop (QBDT).
Please keep in mind that the Price/Amount or %Rate mapping option is intended for the sales price. It's also best if try to see if there's any problem with your Excel, and a few updates often fix this issue. We wanted to ensure that the latest release you have with QuickBooks is compatible with your updated Microsoft Office. We can try updating the existing Excel worksheet within QuickBooks Desktop.
Here's how:
- Open your QuickBooks and open a specific report.
- Go to the Excel button.
- Select Update Existing Worksheet.
- Click the Browse button to look for your existing worksheet.
- Select Export.
Moreover, aside from modifying the prices of an existing item via the Add/Edit Multiple List Entries or by opening each item manually, you can also use the IIF file to move your updated item list to QuickBooks.
- Prepare your file.
- Back up your company file before you import IIF files. This way, you can use your backup to restore your data if you ever run into problems.
- Sign in to your company file as an admin. If you’re in Multi-user mode, go to the File menu, then select Switch to Single-user Mode.
- Go to the File menu, then select Utilities.
- Click on Import, then select Import IIF.
- Select the IIF file you want to import, then select Open.
- Hit OK to confirm the import.
For more hints, while working with your inventory items in the future, you can also check out the resources from these links:
Let me know if you have any other questions while updating items' prices in QBDT. I'm just a post away to help. Keep safe!
