Godown or Location Stock Flow or Reconciliation

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.

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.

N: Auto Column

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: