<< QuickBooks for Contractors Tip: How to Filter Reports by Job Start Date/End Date | QuickBooks Tip: How to Export an Estimate Template to Another Company File >>

QuickBooks Tip: How to Enter a Price Increases for Multiple Parts

by Ruth Perryman 16. January 2010 14:52

Question: I am looking at doing a price increase for a large number of parts in our system. We are not currently using price levels so there comes the problem. Unless there is a way to do this within QuickBooks (Enterprise 2009) I would like to export to Excel, do the update to the prices and then import the information back into QuickBooks. Is there a utility or way to do this and what would the cost be? I am on a very tight time so the sooner you can let me know the better. Thank you for your assistance with this!

Answer:
Go to Lists > Items List, click on the Activities and select Change Item Prices. You can also export your item list to Excel by going to File > Utilities > Export > Lists to IIF Files and select Item List. You can make your changes and then import it back the same way. QuickBooks Enterprise 2010 also has a nifty Add/Edit Multiple List Item Entries feature that we just love, love, love - but it’s not available in 2009.

If we helped solve your problem, please consider spending a minute or two posting a review for us. ____________________________________________________________

Ruth Perryman - QuickBooks Specialist Written by Ruth Perryman, CMA, CFE, CFM, MBA, DPA (ABD)

Ruth is the president of The QB Specialists, an Intuit Solutions Provider that has helped thousands of businesses throughout the United States, Canada and even the Caribbean get the most out of QuickBooks since 1996. Ruth has over 20 years of industry experience, including 5 years as a Chief Financial Officer. She is an Advanced Certified QuickBooks ProAdvisor and a member of Intuit’s Trainer/Writer Network. She is also certified in QuickBooks Point of Sale and Enterprise.

For more QuickBooks Tips & Tricks, subscribe to her monthly newslettter.