www.TallyERP9Help.Com

Godown Location Stock Flow Reconciliation  in Tally.ERP 9

The reconciled flow of goods at each location is available in Tally.ERP 9

Select F12: Configure while in the Godown/Location Summary Screen.

 
[Img-29]

The Godown Summary statement displays the flow of stock: Opening Stock, Goods Inwards, Goods Outward and Closing Stock, at each location.

 
[Img-30]

The statement is quantitatively reconciled, not monetarily, i.e., Opening quantity + Inward Quantity – Outward Quantity = Closing Stock Quantity.

However, this is not true of values because values do not add up in this manner. The Outwards value displays Sale Values, not Cost. The Closing Stock Value is, however, based on Cost and the Cost Method adopted for each item.

Value reconciliation is possible using Consumption figures, instead of Outward Values.

Press F7: Show Profits to expand the Outwards Column for Consumption and Profit figures. Value Reconciliation is now possible using: Opening Value + Inward Value – Consumption Value = Closing Stock Value.

 
[Img-31]

F7: Show Profits:

By default this option will be set to No. Pressing F7:Show Profit or enabling this option displays the same report.

Columns

Details

Inwards

All the goods Inward item are captured here.

Outwards

All the goods Outward item are captured here.

Consumption

Cost of Goods Sold of respective outward entry. Cost of Goods Sold derived as per valuation method specified in item master.

Gross Profit

Outward Value – Cost of Goods Sold.

Perc %

Gross Profit / Outward Value x 100

Closing Quantity

Outward Quantity – Inward Quantity

Closing Rate

Closing Value / Closing Rate

Closing Value

Stock item closing value. This value is derived as per valuation method specified in item master. If Transaction value is enabled in F12 then Closing value = Opening value + Inward Value – Outward Value. This transaction value is only for reporting purpose to compare with default valuation. It will not show it in Profit and Loss account.

Total Inward

Opening + Total Inward entries

Total Outward

Total Outward entries

Total Consumption

Total Inward Value – Total Closing Value

Total Gross profit

Total consumption – Total Outward Value

Total Closing

Closing value derived as per valuation method specified in item master. If Transaction value is enabled in F12 then Closing value = Opening value + Inward Value – Outward Value.


C: New Column

New Column is used to compare the stock balances or stock item quantities, rate and value with other godown(s)/location(s) in columns at one screen for the different periods.

 
[Img-32]

N: Auto Column

You can view the particular godown report daily, weekly, fortnightly, monthly etc. To view the report of all the godowns with ‘Total’ column, Set ‘Yes’ to ‘Show Total Column ?’

 
[Img-33]

 
 
 
 
Tally.ERP 9 Reference Manual LIBRARY
1.
Installation of Tally.ERP9
2.
Site Licensing of Tally.ERP9
3.
Shortcut Keys in Tally.ERP9
4.
Maintaining Company Data
5.
Creating Masters
5a. Accounts Information [Creating Masters]
5b. Inventory Information [Creating Masters]
6.
Voucher Entry
7.
Reports in Tally.ERP9
8.
Excise for Dealer
9.
Excise for Manufacturer
10.
Reports [ Excise for Manufacturer]
11.
Excise for Importer
12.
Service Tax in Tally.ERP9
13.
Tax Collected at Source (TCS) in Tally.ERP9
14.
Tax Deducted at Source (TDS) in Tally.ERP9
15.
Value Added Tax (VAT) in Tally.ERP9
16.
Central Sales Tax (CST) in Tally.ERP9
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
Our Portal : www.TallyERP9Book.Com www.IncomeTaxManagement.Com www.Tally9Book.com www.TallyERP9Help.Com
Disclaimer :
Tally, Tally 9, Tally9, Tally.ERP, Tally.ERP 9, Tally.Server 9, Tally.NET & Power of Simplicity are either registered trademarks or trademarks of Tally Solutions Pvt. Ltd. in India and/or other countries. All other trademarks are properties of their respective owners.
The visitors may click here to visit the web site of Tally Solutions Pvt. Ltd. for resolving their doubts or for clarifications