With this help, you can perform a stock inventory in Rackbeat, i.e. set the desired quantity and price in stock. The inventory can be done either directly in the system or with a CSV file.
On the Reporting > Valuation report you can see the quantity and value of the product/products in stock on a desired date. If these need correction, you must make an inventory entry to correct the situation.
Resetting stock for the desired product
You can reset the stock by going to Stock > Stock transactions.
Correction in the system
Select "Create new stock transaction".
Select the desired product and edit the quantity. Through the extended product search you can search for a product and retrieve the products of a specific stock. The modification date will be the date when the change is saved to stock. This can be done retroactively.
Select the stock where the product is, if this is not filled in automatically when selecting the product.
The In stock field shows the current stock quantity.
Enter a zero value in the Actual quantity field to reset the stock quantity.
Select "inventory" as the stock transaction type and enter a description of the change in the Reason field.
Finally, save by clicking the Edit quantity/value button.
To save the change permanently, go to the stock transaction screen and click "Post" for the respective change row.
New inventory entry
After resetting the stock, make a new stock entry for the same product.
Enter the correct quantity in the Actual quantity field, i.e. how many units of the product are in stock.
Click "Edit quantity/value" to save the change.
In this case the correct quantity is 10 pcs, and when entering the information you can also enter a new purchase price, so that the stock value will be purchase price * quantity. In this case 10*20 = 200 €.
Finally, acknowledge the change row in the stock transactions view by clicking "Post".
On the Reporting > Valuation report, by searching for transactions of the previously selected stock, you can verify that there are 10 pcs of the product in stock and the value is 200.
Inventory entry using a CSV file
You can perform an inventory using a CSV file by going to Stock > Stock transactions.
Select "Import data / Download data".
3. Download the template file to your computer via this function.
If the initial inventory has been imported and later this is used to correct the balance, then the columns also need "balance adjustment" so that the quantity is handled correctly. 1 = added to the existing quantity, 0 = the existing quantity is overwritten by the quantity in the file. If left empty, the effect is the same as 0. Mandatory fields: Date, Product code, Stock (numeric), Quantity, Balance adjustment, Cost price (means purchase price).
First enter the date in Excel; it is recommended to initially format the field as text so that a possible leading zero in the date is not lost. The date is entered in the format dd.mm.yyyy, e.g. 26.06.2026.
For the product, enter the product code. This is found on the product card in the Number field.
In the Stock field, enter the numeric value of the stock, which can be found under Stock > Locations.
Enter a zero value in the Quantity field to reset the stock quantity.
In this case, the value in the Cost price field does not matter.
Enter the desired reason in the Reason field, e.g. "stock correction".
Enter Inventory as the stock transaction type.
Inventory example
1. Save the data in Excel and import the data by going to Stock > Stock transactions > Import data / download data.
2. Under Select files, browse to the file saved in Excel.
3. The view below opens, where you can omit fields if necessary. In this example, there is no need to omit any fields.
4. Click the Import button.
5. Post the stock transaction row.
6. The stock for the respective product is now zero.
7. Then import a new file from Excel with the new correct quantity and purchase price (Cost price). For example: quantity 15, purchase price 10.
8. Import the file.
9. Note! The row must be remembered to be acknowledged. That is, from the Post button in the stock transactions view so that the change is saved to stock.
10. Finally, there are 10 products in stock, at a price of 15 € each, and the stock value is 10*15 = 150 €.
Inventory where the product is transferred from one stock to another
If you want to inventory a product into a new stock, you can do it for example so that the product appears twice in Excel. On the first row, the product is reset from the old stock. That is, quantity zero and in the balance adjustment field zero, so that the quantity is overwritten by the quantity in the file.
Then add a new row for the new stock with the new correct quantity and purchase price, and set the balance adjustment field to zero, so that the value will be transferred to the new stock based on the imported file.
Keywords: Rackbeat stock, stock inventory, inventory, stock transactions, stock value, stock reset
This article has been translated using an AI-based translation tool. The contents or wording of these instructions may differ from those in other instructions or in the software.