Get 50% OFF QuickBooks for 3 months*
Buy nowI’m happy to walk you through the steps on how to price increase from an excel sheet so you’ll be able to import it into your QuickBooks Desktop, @Jim-FVF.
Companies with large inventory lists that are provided by a small number of vendors can typically update these lists with an.IIF from your vendor. We can easily record the changes by simply importing the updated file into your company file. Thus, this will modify the existing fields that you didn't update.
To update the pricing of your items, we can use the Add/Edit Multiple List Entries option. Please know that we can also copy your data from Excel and paste it into the Add/Edit Multiple List Entries window to expedite the process.
Here’s how:
You can now import your data with an MS Excel file to update the items from there. Check out this article for further guidance: Import MS Excel files.
If you'll need to track where your company stands in terms of expenses and accounts payable, we can customize your vendor reports. For the detailed step-by-step process, here’s a handy article you can follow: Customize vendor reports.
I’m always ready to assist you if you have any other questions or concerns about managing your items in QBDT. Tag me in your reply, and I’ll sprint back into action. Have a good one, and keep safe.