The reconciled flow of goods at each location is available in Tally.ERP 9.
● Select F12: Configure while in the Godown/Location Summary screen, as shown below:
The Godown Summary statement displays the flow of stock: Opening Stock, Goods Inwards, Goods Outward and Closing Stock, at each location.
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.
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. |
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.
You can view the particular godown report daily, weekly, fortnightly, monthly and so on. To view the report of all the godowns with Total column, Set the option Show Total Column? to Yes, as shown below:
'Godown Location Stock Flow Reconciliation' has been shared with
