Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 5 Next »

You can update mark up for a certain supply category let's say from 40% mark up you need to change it to 50% mark up.


1. Go to Inventory → Supplies → Import/Export then select Export Supplies.

Note: It's best to save a back up copy of your supply list prior to making changes so you'll have something to go back to if need to revert some changes.


2. Depending on your computer settings, the file will either open automatically or you need to manually open it.


3. With the Excel file opened, click on Data → Filter → and select the category of supplies with mark up you need to update.

In this example, we are selecting the category "backflow."


4. Copy the data to a new Excel file and name the worksheet "Supplies".

Note: Do not change the header names as it will affect the importing process.


5. With the data pasted in a new Excel sheet, edit the Sell Price in column J.

For example, if you want to change the mark up from 40% to 50% then you need to calculate and input the new price in column J.

In this example, our fist item has a sell price of $10.2 which is 40% mark up. To update it to 50% mark up, we can calculate by $10.00 X 60% + Cost Ex tax = $16.32. If you're using formulas to calcuate the new markup, make sure to paste the data as values prior to importing.


6. Save the updated file and go back to Inventory → Supplies → but this time, select Import.


(info) Process complete. Your mark up for the selected supply category should update accordingly.



  • No labels