Setting up depreciation – stock value reduction

Setting up depreciation – stock value reduction

In this guide, you will find the steps to set up stock value reduction.


Info
The purchase price on the product page will always remain the price at which the product was booked in. The purchase value after depreciation is visible in the Excel export via Assortment (see the steps below under Viewing depreciation in separate columns in Excel).


Activate the stock value reduction feature

  1. In the menu, click Shop settings.

  2. Click the Advanced tab.

  3. Enable the toggle Activate stock depreciation.

  4. Click the Submit button.



Set up depreciation rules

  1. In the menu, click Item groups.

  2. Click the button with the three dots in the top right.

  3. Choose the option Stock depreciation settings.

  4. Click Add new setting.

  5. Enter the required details for this depreciation rule:

    • Name: A name for your own reference

    • Depreciation up to this maximum percentage of the purchase value: Enter the percentage to which you want to depreciate the stock in total.

  6. Click Add new depreciation year to add the total number of years over which you want to depreciate.

  7. Enter the percentage for each year showing how much you want to depreciate the stock, e.g. 10 or 20 (for 10% or 20%).


AlertNote: This percentage is calculated based on the purchase price of the previous period, not the original purchase price. For example, if last year the purchase value was depreciated from 10 to 8, this year the percentage will be calculated on 8.


  1. Click Save.


Assign a depreciation rule per item group

  1. In the menu, click Item groups.

  2. Click the pencil icon for the relevant item group.

  3. Select the desired depreciation rule in the field Depreciation of items in this item group.

  4. Click Update.


View depreciation in separate columns in Excel

  1. In the menu, click Assortment.

  2. Click the button with the three dots in the top right.

  3. Click Export old stock list.

  4. A new screen will appear. Find the date for which you want to create an export.

  5. If desired, change the depreciation period to Yearly or Quarterly.

  6. Click the download button next to the desired export.


Perform a manual depreciation per product

  1. In the menu, click Assortment.

  2. Click View next to the relevant product.

  3. Click the eye icon above the Purchase and sales history button (on the right).

  4. Enter the purchase price you wish to use after depreciation.

  5. Click the tick icon next to the input field.


The depreciation per product is applied immediately. If you reload the page, the date of the last depreciation will be visible. Export the stock list (see above) to view the depreciation.


    • Related Articles

    • Export stock list

      How can I export my entire stock? 1. Click on 'Assortiment' in the menu 2. Under filter 'Locations' select the option 'With stock' 3. Click the button with the 3 dots at the top right. 4. Click on the 'Export products' option 5. A new screen appears. ...
    • Export historical stock list

      Do you want to download a stock list from a date in the past? This can only be done as Excel file. 1. Click on 'Assortiment' in the menu 2. Click the button with the 3 dots at the top right. 3. Click on the option 'Export old stock list. 4. Please ...
    • Inventory / Balance sheets - Stock counting

      For convenience, use a laptop and barcode scanner to scan the products through the search bar. You can also search for the product number. To count the stock, take the following steps: 1 In the menu, click on 'Inventory / Stock count' 2. Find or scan ...
    • Mutation - View stock of changes

      Do you want to know what happened to the stock of a specific product? Take the following steps. You can also export a complete mutation list of all productswith these steps. 1. Click on 'Assortiment' in the menu 2. Find the product in question ...
    • View and export products with minimal stock

      Do you want to know which products you have in minimum stock? 1. Click on 'Assortiment' in the menu 2. Under filter 'Locations' select the option 'Minimal stock' 3. Click the button with the 3 dots at the top right. 4. Click on the 'Export products' ...