Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

Image RemovedImage Added


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

Image RemovedImage Added


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

Image RemovedImage Added


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.

Image RemovedImage Added


5. With the data pasted in a new Excel sheet, edit the Sell 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.

Image RemovedImage Added


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

Image Modified


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

...