This help describes how to manually record stock value in Rackbeat and transfer it to Netvisor.
Rackbeat does not have automatic stock value recording, so this must be done manually with a journal voucher in Netvisor on the last day of the fiscal year or at the end of the desired period.
CONTENTS
Inventory value in Rackbeat
In Rackbeat, the stock value can be obtained from the valuation report (Reporting > Valuation).
If there is already a value from the previous fiscal year or the desired older period, the value can be obtained by retrieving the situation at the end of the previous fiscal year/the end of the desired period. It is also the starting value for the new fiscal year or the new desired period.
If it is the first stock value recording, leave the starting date empty and select the ending date from which you want the stock value.
If you want the stock value on a specific day, retrieve the valuation report without a starting date with the desired ending date.
When you want the change, first retrieve the valuation from the last day of the previous period (e.g., 30.4.) and then from the desired ending date (e.g., 31.5.) and examine the difference.
When you scroll to the end of the valuation report view, it shows the total stock value at the end of the desired search period. This also shows the quantity of products.
The hide zero rows button on the report means that it only looks at the purchase price at the end of the row and whether it is zero. The selection does not affect the stock value, but the quantity of products may vary with this selection if there is quantity on the row but the purchase price is zero.
Show negative values also brings up products that have been sold to a negative, meaning the quantity is negative.
Inventory recording voucher
- If the stock value increases: a debit entry is made to the balance sheet and a credit entry to the profit and loss statement.
- If the stock value decreases: a credit entry is made to the balance sheet and a debit entry to the profit and loss statement. The balance sheet account used is the product's stock account, which is by default 1521 in Netvisor.
- If other accounts have been used in the company such as 1501, 1511, 1531, or 1533, the change is also recorded to these accounts. On the profit and loss statement side, the account is between accounts 4400 - 4440.
Keywords: Rackbeat stock value, stock, valuation report
Did you find it helpful? Yes No
Send feedback