Can I set up a markup matrix in QuickBooks? I want to have different mark ups for different cost ranges.
Visit our webstore for huge savings on QuickBooks!
You can try using Price Levels, but I don’t think it’s going to do what you want.
You can set a markup in the inventory item itself by selecting the Edit Markup button. Or you can export your item list to Excel, add a calculation column, copy paste it into the Sales Price column and delete the calculation column.
In the long run, using Edit Markup will save you time because you can set it to automatically adjust the sales price based on a % of amount over cost.
This article is provided for informational purposes and is not intended to be construed as legal, accounting, or other professional advice. For further information, please consult appropriate professional advice from your attorney and certified public accountant.
Written by +Ruth Perryman, CMA, CFE, CFM, MBA
Ruth is the president of The QB Specialists, an Intuit Premier Reseller that offers huge savings and expert advice on QuickBooks POS and QuickBooks Enterprise. She is an Advanced Certified QuickBooks ProAdvisor and a member of Intuit’s Trainer/Writer Network. She is also certified in QuickBooks POS and QuickBooks Enterprise and has provided expert QuickBooks help to thousands of businesses all over the world since 1996.
Web Store | Price List | Free Trials | Newsletter