You can calculate the value of your equipment stock by exporting your equipment and making the calculations in Excel or Google Sheets. We advise setting up the current book value of each serial number for more valuable equipment (like mixers or speakers) and the purchase price/list price for cheaper equipment like cables.
Set up the current book value or purchase 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 "Purchase price" for sale items, and "List price" for rental items.
Export your equipment
Once the "Book value", "Purchase price", and "List price" of your equipment are correctly set up, select and export all your equipment in an .xlsx file.
Make sure to include the columns "Subrent-/Purchase cost" and "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 "Book values" of your serial numbers, and the "Purchase price" / "Subrental cost" of your items that don't have serial numbers.
The "Purchase 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.