How to display Godown / Location Summary and Stock Flow / Value Reconciliation? @ Tally.ERP9

Query

How to display Godown / Location Summary and Stock Flow / Value Reconciliation?

Answer

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

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

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.

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 etc. To view the report of all the godowns with ‘Total’ column, Set ‘Yes’ to ‘Show Total Column ?’