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
- EXEMPTION UNDER SECTION 54 FOR UNDER CONSTRUCTION FLAT
- ITR-3 ignores Section 211 (1) (b) for Professionals u/s 44ADA
- How to add NRE account to income tax profile?
- Deduction for HUF
- Upload Level Validation Error
- Nill TDS Return FY 2025-26
- Salary u/s 194C
- Filing ITR U
- AY2025-26- Bug in ITR2 Online Filing - TDS Section related to Property Sale
- Sale of foreign shares by Indian resident
- ERROR IN ITR3
- Rejection of Rectification by CPC
- GST ITC in ECL and GST PURCHASES DATA IN AIS
- GST rate on monthly hiring of commercial vehicle given for transportation.
- TAXABILITY OF STATE INSURANCE MATURITY RECEIPTS BY RAJASTHAN GOVERNMENT EMPLOYEE ON RETIREMENT ?
- Document to add trade name
- GST Partners addition
- Non-disclosure of Foreign Shares & Dividend in Past ITRs – How to Rectify & Report Now?
- ICWAI-Final best coaching center for online by English
- "Please ensure that the Total of the Deductions u/s 54F match the same in Table D in Sch CG"
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
CAclubindia
