Set up depreciation - inventory value reduction
This guide provides the steps to set up inventory reduction.
Tip
The purchase price on the product page always remains the price at which the product was booked. The purchase value after depreciation is visible in the Excel export via assortment (see the steps below under View depreciations in separate columns in Excel).
Activate inventory reduction function
1. In the menu, click on Shop Settings
2. Click on the Advanced tab
3. Activate the switch: Enable inventory write-down.
4. Click on the Submit button.
Set up depreciation rules
5. In the menu, click on Item Groups
6. Click on the button with 3 dots in the top right
7. Choose the Inventory Depreciation Setting option
8. Click on the Add new setting button
9. Fill in the desired data for this depreciation rule:
Name: Name for internal use
Depreciation up to a maximum of this percentage of the purchase value: Enter the number up to what percentage you want to depreciate the total inventory
10. Click on the New year of depreciation button to add the total number of years over which you want to depreciate.
11. Enter the percentage by which you want to depreciate the inventory after each year. For example, 10 or 20 (if you want to depreciate by 10% or 20%).
Please note: this percentage refers to the purchase price of the previous period and not the initial purchase value. So, if last year the purchase value depreciated from 10 to 8, this year the percentage will be calculated on the 8.
12. Click on the Save button.
Depreciation rule per item group
13. In the menu, click on Item Groups
14. Click on the pen icon for the relevant item group.
15. Select the desired depreciation rule in the 'Depreciation of items in this item group' field
16. Click on the Update button.
View depreciations in separate columns in Excel
17. In the menu, click on Assortment
18. Click on the button with 3 dots in the top right.
19. Click on the Export old stock list option
20. A new screen will appear. Find the desired date for which you want to create an export.
21. If desired, change the depreciation period to Annually or Quarterly.
22. Click on the download button next to the desired export.
Manually depreciate a product
1. In the menu, click on Assortment.
2. Click on the View button next to the relevant product.
3. Click on the eye icon above the Purchase and Sales History button (on the right).
4. Enter the desired purchase price you use after depreciation.
5. Click on the V icon next to the input field.
Depreciation per product is carried out immediately. If you reload the page, the date on which you last depreciated will be visible. Export the stock list (see above) to view the depreciation.
Was this article helpful?
Another question?
Ask Linde — answers come with sources.