Changing Seasons, Changing Prices
Changing the prices of your company’s services and inventory items can solve one of two problems, depending on why you’re looking for a solution. Say your materials suppliers have upped their prices. You may choose to increase your affected products to maintain your profit margin. Or maybe an item or service has not been moving well. A drop in price might trigger improved sales.
Those examples, of course, are simplifications of what needs to be a thoughtful, studied process. They’re critical business decisions that should be made with the guidance from your trusted ProAdvisor. We are experts that don’t just know QuickBooks: We understand the flow of profit and loss, and we can be valuable allies in your march towards continued growth.
We’ll explore the tools that QuickBooks offers to help simplify price changes once your decisions have been made. They’re not overly difficult to use, but we can help ensure that your intentions are carried out accurately. And there are related inventory issues that may be impacted by your modifications.
First, you must make sure that QuickBooks is set up to accommodate price levels. Click Edit | Preferences and select Sales & Customers in the left vertical pane. Then click the Company Preferences tab. You’ll see the window shown in Figure 1.
Figure 1: Before attempting price level changes, be sure the Use price levels box is checked.
If it’s not already checked, click on the box next to Use price levels. Then click OK.
There are two ways to get to the price-changing window. You can click the Customers menu, then Change Item Prices. Or you can select the Items & Services icon from the home page. If you do the latter, simply open the Activities menu at the bottom of the screen and select Change Item Prices to see a window similar to the one shown in Figure 2.
Figure 2: The Change Item Prices
Targeting Your Changes
Once you’ve selected the right type, click in the column next to the item(s) you want to change. A check mark will appear. If you want to increase or decrease the prices of all of them, click next to Mark All at the bottom of the screen, as pictured in Figure 3.
Figure 3: Click the box next to Mark All
Based on your discussions with us, you should now know how you want to adjust the selected price(s). You may have just decided on a new price, in which case you can simply enter it in the New Price column.
Here’s an alternative. In the box to the right of Adjust price of marked items by (amount or %), enter either an individual number to increase by that amount, or a number with a % sign after it to up it by that percentage. To decrease the cost, enter a negative number.
The next step is a little trickier. If you simply want to alter the price of an entry based on its current sales price, leave the Current Price option showing in the next box. But if you want to change it based on its Unit Cost, you’ll have to consult us or do some digging to learn what that is.
If you want the resulting numbers to be rounded up, click the arrow next to Round up to nearest. When you’re satisfied with your work, click Adjust to see your changes reflected in the New Price column. Make any desired modifications, then click OK.
Don’t know where all of those items occur? Go to Edit | Find to locate them .
Making price changes in QuickBooks—even global ones—isn’t terribly difficult, but it involves a business decision that’s best made in conjunction with us. It can lead to increased profitability no matter which direction you go, as long as you take into account the issues and potential outcomes involved.