You can calculate the value of your equipment stock by exporting your equipment and making the calculations in Excel or Google Sheets. We advice setting up the Current book value of each serial number for more valuable equipment (like mixers or speakers) and the New price (the price of purchase) for cheaper equipment like cables.
Set up the Current book value or New price of your equipment
When you add or edit a serial number, you can set up its Purchase price and the Depreciation per month. Rentman will use these data to calculate the Current book value for each serial number.
If you don't want to calculate the Current book value of your serial numbers, uncheck the "Calculate book value automatically" checkbox and add a fixed Book value.
When you add or edit an item, kit, or case, you can set up its New price.
Export your equipment
Once the (Current) Book value and New price of your equipment are correctly set up, select and export all your equipment in an .xlsx file.
Make sure to include the columns "New price" and "(Current) Book value" when you export the equipment.
To avoid calculating the value of an item multiple times (both as a single item and inside kits or cases) you can add the filter "Is item" before exporting the file.
Calculate the value of your stock
Now you can calculate the value of your stock by summing the Current book values of your serial numbers, and the New price of your items that don't have serial numbers.
The New price is not automatically multiplied by the quantity of an item. You can do this manually in Excel or Google Sheets:
- in an empty column type: =product ( )
- insert in the brackets, separated by a comma, the Quantity and the New price you want to multiply.
You can do this by clicking on the cells.
- Press enter
You can now extend this formula to all the couples in the column by copy-pasting it.
Rentman tip: When you have all your equipment in the .xlsx file, sort it by the Current book value column. By doing this, the rows with serial numbers will be separated by the others, and it will be easier for you to do the calculations.