TALLY - HOW TO ENTER CLOSING STOCK VALUE
This query is : Resolved
09 April 2009
Dear Experts,
I m activated feature in Tally INTEGRATE ACCOUNT WITH INVENTORY.
I want to change value of closing stock.
How can i do this. please advice
I m activated feature in Tally INTEGRATE ACCOUNT WITH INVENTORY.
I want to change value of closing stock.
How can i do this. please advice
09 April 2009
Deactivate the feature. Then you shall be able to change the value of closing stock. If you want to maintain itemwise stock then remain that feature activated.
10 April 2009
Dear Expert,
Yes i want to maintaine ITEM WISE stock and want to change value of closing as on 31.03.2009 for all stock how cai do this please advice.
Yes i want to maintaine ITEM WISE stock and want to change value of closing as on 31.03.2009 for all stock how cai do this please advice.
10 April 2009
Dear Niraj
U may chenge value of closing stock by chenging the metod of valuation by cenging individual stock item valuation method. The valuation method may be FIFO or Av Cost method and market Rate which ever is less.
U may chenge value of closing stock by chenging the metod of valuation by cenging individual stock item valuation method. The valuation method may be FIFO or Av Cost method and market Rate which ever is less.
10 April 2009
Dear Expert,
Yes i want to maintaine ITEM WISE stock and want to change value of closing as on 31.03.2009 for all stock how cai do this please advice.
Yes i want to maintaine ITEM WISE stock and want to change value of closing as on 31.03.2009 for all stock how cai do this please advice.
10 April 2009
Dear Prakash,
I have moved stock 1 location to other location and its affect some addl. cost i want to add this cost on purchase cost. i m not activated feature addl cost of purchase (and its not possible because data is very huge). but i want to change Item Wise Value of closing stock.
From where i can do this ?
I have moved stock 1 location to other location and its affect some addl. cost i want to add this cost on purchase cost. i m not activated feature addl cost of purchase (and its not possible because data is very huge). but i want to change Item Wise Value of closing stock.
From where i can do this ?
26 July 2025
Here's how you can **adjust the closing stock value item-wise in Tally ERP 9** while maintaining inventory (i.e., with **"Integrate Accounts with Inventory"** feature ON):
---
### Problem Recap:
* You want to maintain item-wise stock.
* You want to change the **closing stock value as on 31.03.2009** for all items.
* You do **not** want to deactivate "Integrate Accounts with Inventory."
* You want to adjust stock value (like adding additional costs to purchase cost).
* Data is huge, so you want a practical way.
---
### How to change the **closing stock value item-wise** in Tally:
#### Option 1: Adjust Stock Rate through **Physical Stock Voucher** (stock journal)
1. Go to **Inventory Vouchers** > Press **F7 (Stock Journal)**.
2. Select the **From Location** and **To Location** (you can transfer stock within same location by selecting the same).
3. Select the **Stock Item** and enter the **Qty** as existing stock.
4. In the **Rate** field, enter the new adjusted value you want for closing stock (i.e., cost including additional expenses).
5. Pass the voucher.
> This changes the stock rate for the item without affecting quantities.
#### Option 2: Use **Adjustment Entry** with Stock Journal
* Create a **stock journal** voucher and adjust the stock rate for the items.
* This will update the value of the stock as per your input.
* Make sure the quantity remains the same; only the rate changes.
---
### Important Notes:
* You **cannot directly change the closing stock value** in Tally when inventory integration is enabled because Tally calculates stock value automatically based on stock item rates.
* You **cannot deactivate "Integrate Accounts with Inventory"** if you want to maintain item-wise stock.
* Adjustments to closing stock value can be done only via adjusting **stock item rates** using stock journal vouchers.
* Avoid manual journal entries to adjust stock value as it may lead to mismatches.
---
### Summary:
| Scenario | Solution |
| ---------------------------------------------------------------- | ----------------------------------------------------------------------------------------------------- |
| Want to adjust closing stock value with inventory integration ON | Use Stock Journal Voucher (F7) to change item-wise stock rate |
| Want to change closing stock value by direct journal entries | Deactivate "Integrate Accounts with Inventory" feature (not recommended if item-wise tracking needed) |
---
If you want, I can help you with **step-by-step screenshots** or a detailed example voucher entry. Would you like that?
---
### Problem Recap:
* You want to maintain item-wise stock.
* You want to change the **closing stock value as on 31.03.2009** for all items.
* You do **not** want to deactivate "Integrate Accounts with Inventory."
* You want to adjust stock value (like adding additional costs to purchase cost).
* Data is huge, so you want a practical way.
---
### How to change the **closing stock value item-wise** in Tally:
#### Option 1: Adjust Stock Rate through **Physical Stock Voucher** (stock journal)
1. Go to **Inventory Vouchers** > Press **F7 (Stock Journal)**.
2. Select the **From Location** and **To Location** (you can transfer stock within same location by selecting the same).
3. Select the **Stock Item** and enter the **Qty** as existing stock.
4. In the **Rate** field, enter the new adjusted value you want for closing stock (i.e., cost including additional expenses).
5. Pass the voucher.
> This changes the stock rate for the item without affecting quantities.
#### Option 2: Use **Adjustment Entry** with Stock Journal
* Create a **stock journal** voucher and adjust the stock rate for the items.
* This will update the value of the stock as per your input.
* Make sure the quantity remains the same; only the rate changes.
---
### Important Notes:
* You **cannot directly change the closing stock value** in Tally when inventory integration is enabled because Tally calculates stock value automatically based on stock item rates.
* You **cannot deactivate "Integrate Accounts with Inventory"** if you want to maintain item-wise stock.
* Adjustments to closing stock value can be done only via adjusting **stock item rates** using stock journal vouchers.
* Avoid manual journal entries to adjust stock value as it may lead to mismatches.
---
### Summary:
| Scenario | Solution |
| ---------------------------------------------------------------- | ----------------------------------------------------------------------------------------------------- |
| Want to adjust closing stock value with inventory integration ON | Use Stock Journal Voucher (F7) to change item-wise stock rate |
| Want to change closing stock value by direct journal entries | Deactivate "Integrate Accounts with Inventory" feature (not recommended if item-wise tracking needed) |
---
If you want, I can help you with **step-by-step screenshots** or a detailed example voucher entry. Would you like that?
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now
Click here to login now
Similar Resolved Queries
Unanswered Queries
OR add as source on Google news
- Acquisition of a society by a company
- EPF withdrawal before 5 years and Disclosure in ITR-2
- Rebate Under 87A Issue
- GST Applicability on Fair Price Shop Commission Income
- HRA in ITR 2 FY 2024-25
- 2.25 CRORE TRADER, NO CASH TRANSACTIONS,3CD APPLICABLE?
- Gratuity not yet paid shown in form 16
- FORM 115BAC
- Clarification on ITR 3: Is Sl. No. 64 required for 44ADA income?
- Transfer of immovable property without consideration
- LTCG carry forward query
- Mis report in excel format of hospital
- Updation Required
- Tax invoice in special case
- GST OFFICER WRONG NOTICE
- "Please ensure that the Total of the Deductions u/s 54F match the same in Table D in Sch CG"
- Composition Dealer GST Annual Return Filing process
- GST on Restaurant service
- Revision under Section 264 in The Income Tax Act, 1961
- TDS under section 195.
Trending Online Classes
-
Input Tax Credit, GST refunds and Recovery of refunds- Roadblocks and way outs
CA Nipun Arora03 September 2025 -
GST LIVE Certification Course - 43rd Weekdays Batch(With Govt Certificate)
Industry Expert15 September 2025
OR add as source on Google news
CAclubindia
