Tally Accounting
Posted by Asok K Nadhani on

Inventory Reports Summaries in Tally

Stock Value in Final Accounts in Tally

Inventory reports show closing value of Stock in hand. Closing Stock Value is computed using

Various methods of valuation (§07/02-01). So, the value of Closing Stock  would depend on the methods adopted. Apart from that, there are other considerations for valuation of stock depending on types of materials (devaluation due to obsolescence, quality defects, market fluctuations etc, technological changes etc).

Accounts & Inventory System Integration in Tally

In normal trade, the stock value is usually taken on Cost Basis. In such case, the Accounts & Inventory are  Integrated and the stock value as per Inventory System is automatically carried to Accounts System. So, there is no need to enter Stock Value in the Accounts System. 

  • Integrated System : If Inventory System is maintained and if it the Accounting & Inventory System is integrated (at F11:Features>Accounting Features or F11:Features>Inventory Features , set Yes at Integrate Accounts with Inventory) , the Closing Stock Value may is carried to the Accounting System and the Final Accounts Statements show the Stock Value based on the value computed in the Inventory System,  In such case, when you drill down through Stock Value from Accounts Reports, you get Stock Summary (F-3B)
  • Non-Integrated System : If Inventory System is not integrated with Accounts (at F11:Features>Accounting Features or F11:Features>Inventory Features , set No at Integrate Accounts with Inventory)or the Inventory System is not maintained in Tally, the value of Closing Stock as at the end of the accounting period, is to be entered manually to prepare the Final Accounts Statements (§03/01-10, F-1/01-10), In such case, when you drill down through Stock Value from Accounts Reports, you get Group / Ledger details  under the Group Stock-in-Hand.

We have discussed various Inventory Reports (§01/04-06). Here we discuss about Stock Reports, which depict the effect of all transactions and Stock-in-Hand

Stock Summary in Tally

Stock Summary is the most comprehensive Report of Stock movement, giving the summarized position of Opening Stock, Movement of Stock (Stock Inwards & Stock Outwards) and Closing Stock, for the specified period.

Movement Analysis shows data in respect of Accounts Voucher (Sales, Purchase, Debit Note, Credit Note & Journal Voucher). Figures of Pure Inventory Voucher, i.e, the transactions of Receipt Note, Delivery Note & Stock Transfer Vouchers which have no been linked with corresponding Accounts vouchers, are not considered in the report.

Stock Summary Display in Tally

At Gateway of Tally, select Stock Summary, to get Stock Summary Display

Stock Summary Display in Tally

Stock Summary Configuration in Tally

At Stock Summary Display , click F12:Configure to get Configuration screen .

Stock Summary Configuration in Tally

The Configuration options of Stock Summary are described below :

i) Multi Column Options

Set   Yes / No to the following options as required. Each option affects multiple set of columns (Opening / Inward / Outwards/ Closing)

–Quantity / Rate / Value : The following  columns appear for  Opening Balance, Goods Inwards,  Goods outwards & Closing Balance . The option is applicable for all these columns, if activated (e.g if Yes is set at Show Quantity, Quantity column will appear  in the activated columns (Goods Inwards, Goods outwards &  Closing balance, and like that for  Rate & Value column) 

  • Quantity : At Show Quantities, set Yes to show the Quantity column (and the base unit) , Set No to suppress the Quantity column.
  • Rate : At Show Rates, set Yes to show the Rate column (as per the base UoM displayed with Quantity figure) , Set No to suppress the Rate column.
  • Values : At Show Values, set Yes to show the Value column , Set No to suppress the Value column

–Opening/  Inwards / Outwards / Closing:  Set Yes to show the figures for the respective 3 columns activated (Quantity, Rate, Value)

  • Opening : At Show  Opening  Balance, set Yes to show the figures of Opening Balance for the respective columns activated ( Quantity, Rate, Value).
  • Inwards : At Show Goods Inwards, set Yes to show the figures of Goods Inwards for the respective column activated ( Quantity, Rate, Value)
  • Outwards:  At Show Goods Outwards, set Yes to show the figures of Goods Outwards for the respective column activated ( Quantity,  Rate, Value)
  • Closing : At Show Closing Balance, set Yes to show the figures of Closing balance  for the respective column activated ( Quantity, Rate, Value)

The values  (Quantity, Rate, Amount) of  each of the column (Opening, Inwards, Outwards, Closing) are displayed according to the current period (referred as Report Period – set  through F2: period button) for the respective columns:

ii) Set   Yes / No to the following options to show / suppress the columns as required

  • Items Types : At Show All Items:
    • Set Yes to show the Item even if all the displayed  figures for the Item is  zero.
    • Set No  to suppress  the Items where the values of all the displayed column are zero. (if value of any of the displayed column for the Item is non zero, the Item will be displayed).

Items Movement : Having set Yes at Show All Items, at Exclude Items with No Transaction, further set  :

  • Yes. The Items which are not transacted (No In / Out) are not shown(excluded)
  • No. Al Items are shown (even if there is no In / Out).
  • Cost / Contribution : At Show Consumption & Gross Profit,
    • Set Yes to show the Consumption Value (Cost) & Gross Profit (Contribution)for  Sales / Outwards column . Gross is computed as (Sales Value – Cost),
    • Set No, the Consumption  Value & Gross Profit column is not shown.
  • Alternate Unit : This is relevant only when Alternate Unit is activated. At Show using Alternate units:
    • Set Yes to show the quantity in Alternate units also (for Items having Dual Units) at the Alternate Unit column,
    • Set No, only the Base Unit is shown.
  • Tail Unit : This is relevant only for Items with Compound Unit. At Show Tail units of Compound Units,
    • Set Yes to show the tail units of compound unit,
    • Set No. the base unit is shown (with fraction values, where applicable),
  • Format:  At Expand all levels in Detailed Format,
    • Set Yes to show the Items upto the lowest level details (in detail mode- i.e, when F1: Detail button is clicked : ,
    • Set No. Only next level detail (Item Group / Stock Items) are shown in detail mode.

At Stock Summary, drill down through :

  • Any Stock Group  to get the Stock Group Summary for the next level (showing next level Stock Group / Stock Items)
  • Any Stock Item  to get the Stock Item Monthly Summary

Stock Summary Button Bar in Tally

At Stock Summary Display, you get following buttons :

Stock Summary Button Bar in Tally

ButtonDescription
F1 : Detailed / CondensedF1 : Detailed : To show next level Stock Groups / Stock Item detailsF1 : Condensed : To show only top level Stock Groups.
F4: GroupTo select a Stock Group to get Stock Group Report of a selected Stock Group (select Primary to get Report of Top Level Stock Groups)
F5:Itemwise / GroupedF5:Itemwise : To show Stock Item wise report. F5:Gouped : To show Stock Group wise report
F7: Show Profit / Hide Profit F7: Show Profit : To show the details of Consumption, Gross Profit & % of Outwards F7: Hide Profit : Monthly figures for a specific selected Group Note : You may also set Yes / No at Show Consumption & Gross Profit at Configuration .
G:Godown typeTo select the Godown,. Relevant only when Multiple Godown is activated
Columnar Report ButtonsColumn specification to get columnar  Reports

Stock Summary Reports with different Configuration Options

Stock Summary in Tally (Quantity only)

Stock Summary – Opening  Balance only

Stock Summary with all columns

Stock Summary Detail (with all columns

Stock Summary with Profit Loss details of Outwards in Tally

Stock Summary Quantity with Compound & Alternate Units

Stock Summary Printing in Tally

At Stock Summary Display , click P:Print to get Stock Summary Printing screen .

Stock Summary Printing options in Tally

Set the print options to get Stock Summary in Print .

Stock Summary in Print in Tally

Negative Stock Report in Tally

Ideally, there should be no Negative Stock as an Item. Sometimes Negative Stock may appear due to mistake in entry, wrong measurements etc.

To see the list of Negative Stock, at Stock Item Master creation / Alteration, at Behaviour section,  at Ignore Negative Balances, set:

  • No to see the list of Negative Stock Item, as on the report date
  • Yes, to omit the Stock Item from the list of Negative Stock (Negative Stock will not e reported)

To get the list of Negative Stock, as on the specified date, select Display > Exception Report > Negative Stock. The Stock Items whose stock (or its value) has gone negative on the reported date (however the Item will not be listed in Negative Stock if Yes is set at Ignore Negative Balances

Negative Stock Report in Tally

Sales / Purchase Register with Inventory Details

At Sales / Purchase / Debit / Credit Note Register Configuration (§02/03-04/ S1, F-1A to F-1C/03-04/S1), set Yes at Show Inventory Details also to get Sales Register / Purchase Register / Debit Note / Credit Note Register with Item details.

Sales Register with Inventory details in Tally

Purchase Register with Inventory details in Tally

Debit Note Register with Inventory details in Tally

Credit Note Register with Inventory details in Tally

Voucher Register with Inventory Details in Tally

In Voucher Register (Sales, Purchase, Debit & Credit Notes), the Inventory details show  Item Name, Billed Quantity (in Base UoM) and Item value for each Stock Item

Ledger Account with Inventory Details in Tally

Ledger Voucher Display has been discussed earlier (§01/08-16). At Ledger Account Configuration (§08/02-16), set Yes at Show Inventory Details also to get Ledger Account (of Inventory Linked Ledger Accounts – like Sales, Purchase etc) with Item details .

Sales Ledger with Inventory details in Tally

In Ledger Voucher, the Inventory details of Inventory Linked Leger Accounts,  show  Item Name, Billed Quantity (in Base UoM) and Item value for each Stock Item.

Stock Item Periodic Summary in Tally

You get Stock Item Monthly Summary when you drill down though any Stock Item in a report showing Stock Item details.

Stock Item Monthly Summary in Tally

Stock Item Periodic Summary Configuration in Tally

AtStock Item Monthly Summary, click F12:Configure to get  Stock Item Monthly Summary Configuration

Stock Item Periodic Summary Configuration in Tally

Set the Configuration options as follows :

i) Multi Column Options

 Set   Yes / No to the following options as required. Each option affects multiple set of columns (Opening / Inward / Outwards/ Closing)

–Quantity / Value : The following  columns appear for  Opening Balance, Goods Inwards,  Goods outwards & Closing Balance . The option is applicable for all these columns, if activated (e.g if Yes is set at Show Quantity, Quantity column will appear  in the activated columns (Goods Inwards, Goods outwards &  Closing balance, and like that for Value column) 

  • Quantity : At Show Quantities, set Yes to show the Quantity column (and the base unit) , Set No to suppress the Quantity column.
  • Values : At Show Values, set Yes to show the Value column , Set No to suppress the Value column

–Inwards / Outwards / Closing:  Set Yes to show the figures for the respective 3 columns activated (Quantity, Rate, Value)

  • Inwards : At Show Goods Inwards, set Yes to show the figures of Goods Inwards for the respective column activated ( Quantity, Rate, Value)
  • Outwards:  At Show Goods Outwards, set Yes to show the figures of Goods Outwards for the respective column activated ( Quantity,  Rate, Value)
  • Closing : At Show Closing Balance, set Yes to show the figures of Closing balance  for the respective column activated ( Quantity, Rate, Value)

The values (Quantity, Rate, Amount) of  each of the column (Opening, Inwards, Outwards, Closing) are displayed according to the current period (referred as Report Period – set  through F2: Period button) for the respective columns:

ii) Set   Yes / No to the following options to show / suppress the columns as required

  • Cost / Contribution : At Show Consumption & Gross Profit,
    • Set Yes to show the Consumption Value (Cost) & Gross Profit (Contribution) for  Sales / Outwards column . Gross is computed as (Sales Value – Cost).
    • Set No, the Consumption  Value & Gross Profit column is not shown.
  • Alternate Unit : This is relevant only when Alternate Unit is activated. At Show using Alternate units:
    • Set Yes to show the quantity in Alternate units also (for Items having Dual Units),
    • Set No, only the Base Unit is shown.
  • Tail Unit : This is relevant only for Items with Compound Unit. At Show Tail units of Compound Units,
    • Set Yes to show the tail units of compound unit
    • Set No. the base unit is shown (with fraction values, where applicable),
  • Average : At Show Average Details:
    ○ Set Yes, to show the Periodicity Average for the selected Period, at the respective column
    ○ Set No, the Periodicity Average details are not shown.
  • High / Low : At High / Low Details:
    ○ Set Yes to show the High / Low figures for the selected Period, at the respective column
    ○ Set No. the  High / Low figures are not shown.

Stock Summary Button Bar in Tally

At Stock Item Summary , drill down through  any Period record to get the Stock Vouchers report for the Stock Item for the selected Period.

Stock Item Periodic  Summary in Tally (with Compound Units, High, Low & Average values

The Highest & Lowest Figures shows the Highest & Lowest Stock during the specified period (among the non-zero stock figures)

The average Inwards / Outwards show the Average figures of Inwards / Outwards for the selected period. For example, if the total for 6 months is 12, then the average would be 2, even if there are no transactions in some months.

Stock Item Periodic  Summary in Tally (with Alternate Units)

Stock Item Periodic  Summary in Tally (with Gross Profit details)

Stock Journal Register

At Gateway, select Display>Inventory Books > Stock Transfers to get monthly break up of Stock Journal Vouchers. Select a month to get the Stock Journal Voucher Register for the selected Month. Click F2:Period button and set the period to get  Stock Journal Voucher Register for the specified period .

Stock Journal Register in Tally

Stock Journal Voucher Register Configuration

At Stock Journal Voucher Register, click F12:Configure to get Stock Journal Voucher Register Configuration screen , similar to Bill Register Display Configuration (§02.02/03-04/S1).   

Stock Journal Register Configuration in Tally

Here, we discuss about Configuration Options relating to Inventory

  • Extract : At Show Extract of Register :
    • Set Yes to get Stock Group / Stock Item summary of Inwards / Outwards of the Stock Items for the selected Period
    • Set No to get Voucher list of Stock Journals for the selected Period
  • Format : At Format :
    • Select Condensed to show top level Stock Group only
    • Select Detailed to show next level Stock Group / Stock Items

Stock Journal Register Extract Summary in Tally

Stock Journal Register Detailed  Extract in Tally

Stock Journal Voucher Register Buttons in Tally

At Stock Journal Voucher Register, you get Buttons, similar to Bill Register (§02.03/03-04)

Stock Journal Register Buttons in Tally

Stock Movement Analysis in Tally

At Gateway of Tally, select Display>Inventory Books > Movement Analysis to get  Movement Analysis Menu .

Stock Movement Analysis Menu in Tally

Stock Group Movement Analysis in Tally

 At Movement Analysis Menu, select Stock Group Analysis to get  Stock Group Movement Analysis .

Stock Movement Analysis Menu in Tally

Stock Group Movement Analysis in Tally (Detailed)

In Stock Group / Stock Category Movement Analysis, the Effective Rate (Rate including other costs) are shown, while in Stock Item Analysis, both Basic & Effective Rates are shown separately.

In Stock Item Movement Analysis, the Basic Rate for Outwards is not shown (only Effective Rate is shown), even though the figure is available for Basic Rate (you get Basic Rate when you drill down through any Stock Item to get Item Voucher Analysis).

Stock Group Movement Analysis Configuration in Tally

 At Stock Group Movement Analysis, click F12:Configure to get  Stock Group Movement Analysis Configuration

Stock Group / Category Movement Analysis Configuration in Tally

Now set the Configuration options as follows :

  • Format : At Format :
    • Select Condensed to show top level Stock Group only (F-19A)
    • Select Detailed to show top level Stock Group / Stock Items (F-19B)
  • Form:  Having set Detailed at Format, At Expand all levels in Detailed Format, you may further set :
    • Set Yes to show the Items upto the lowest level details (in detail mode- i.e, when F1: Detail button is clicked : F-19C),
    • Set No. Only next level detail (Item Group / Stock Items) are shown in detail mode.
  • Quantity : At Show Quantities :
    • Set Yes to show the Quantity column (and the base unit) , if the Base Unit of all the Items under the Stock Group is same
    • Set No to suppress the Quantity column.
  • Rate : At Show Rates,
    • Set Yes to show the Rate column (and the base unit) ,
    • Set No to suppress the Rate column.
  • Values : At Show Values, :
    • Set Yes to show the Value column ,
    • Set No to suppress the Value column

ii) Set   Yes / No to the following options to show / suppress the columns as required

  • Alternate Unit : This is relevant only when Alternate Unit is activated. At Show using Alternate units:
    • Set Yes to show the quantity in Alternate units also (for Items having Dual Units :  F-19F)
    • Set No, only the Base Unit is shown.
  • Tail Unit : This is relevant only for Items with Compound Unit. At Show Tail units of Compound Units,
    • Set Yes to show the tail units of compound unit (F-19D)
    • Set No. the base unit is shown (with fraction values, where applicable)

At Stock Group Movement Analysis, drill down through  :

  • Any Stock Group to get next level details of Stock Group / Stock Items
  • Any Stock Item to get Stock Item Movement Analysis

Stock Group Movement Analysis (with all level details)

Stock Group / Category Movement Analysis Buttons

At Stock Group Movement Analysis, you get following Buttons :

ButtonDescription
F1 : Detailed / CondensedF1 : Detailed : To show next level Stock Groups / Stock Item details F1 : Condensed : To show only top level Stock Groups
F4: GroupTo select a Stock Group to get Stock Group Report of a selected Stock Group (select Primary to get Report of Top Level Stock Groups)
F5:Itemwise / GroupedF5:Itemwise : To show Stock Item wise report.F5:Gouped : To show Stock Group wise report
F6: By Ledgers / ItemsF6: By Ledgers : To get Account Group  Movement Analysis F6: By Items: To get Stock Group  Movement Analysis
Columnar Report ButtonsColumn specification to get columnar  Reports

Stock Group Movement Analysis Button Bar

Stock Category Movement Analysis Button Bar

Stock Group Movement Analysis in Tally (with Godown, Compound & Alternate Units)

Stock Item Movement Analysis in Tally

At Movement Analysis Menu , select Stock Item Analysis and select a Stock Item from the list to get to get Stock Item Movement Analysis .

The Stock Item Movement Analysis shows the Supplier & Buyer wise summary figures of Sales & Purchase of the selected Stock Item. The Report shows average Basic Rate and Effective Rate of the Stock Item in respect of each Party. This is a valuable comparative statement to compare the Basic & Effective Rate of sales realization & purchase cost of the Item.

Stock Item Movement Analysis in Tally

Account Ledger  Stock Item  Inwards Movement Analysis in Tally

Account Ledger Stock Item  Outwards Movement Analysis in Tally

Stock Item Inwards Movement Analysis in Tally

Stock Item Movement Analysis of a Stock Group in Tally (with Alternate Unit)

Stock Item Outwards  Movement Analysis in Tally

Stock Item Movement Configuration in Tally

At Stock Item Movement Analysis , click F12:Configure to get Stock Item Movement Configuration, to set Configuration options as follows :

Stock Item Movement Analysis Configuration in Tally

  • Supplier Section : At Show Supplier Section, set :
    • Yes to show the Supplier section showing the Purchases details from each Supplier under Movement Inward section
    • No. The Supplier section is not shown
  • Buyer Section : At Show Buyer Section, set :
    ○ Yes to show the Buyer section showing the Sales details to each Buyer under Movement Outward section
    ○ No. The Buyer section is not shown
  • Quantity : At Show Quantities :
    • Set Yes to show the Quantity column (and the base unit) , if the Base Unit of all the Items under the Stock Group is same
    • Set No to suppress the Quantity column.
  • Rate : At Show Rates,
    • Set Yes to show the Rate column (and the base unit) ,
    • Set No to suppress the Rate column.
  • Values : At Show Values, :
    • Set Yes to show the Value column ,
    • Set No to suppress the Value column
  • Alternate Unit : This is relevant only when Alternate Unit is activated. At Show using Alternate units:
    • Set Yes to show the quantity in Alternate units also (for Items having Dual Units),
    • Set No, only the Base Unit is shown.
  • Tail Unit : This is relevant only for Items with Compound Unit. At Show Tail units of Compound Units,
    • Set Yes to show the tail units of compound unit,
    • Set No. the base unit is shown (with fraction values, where applicable)

Stock Item Movement Analysis Button Bar in Tally

At Stock Item Movement Analysis , you get the  following buttons

Stock Item Movement Analysis Button Bar  in Tally

Stock Item Movement Analysis Columnar Report Button Bar  in Tally

Account Group Stock Item Movement Analysis in Tally

Account Group Stock Item Movement Analysis in Tally

At Movement Analysis Menu , select Group Analysis and then select  any  Account Group as follows :

  • Sundry Debtor : To get Stock Item Transaction Analysis of Sales (& Purchase) with all Parties under Sundry Debtor Account Group
  • Sundry Creditor : To get Stock Item Transaction Analysis of Purchase (& Sales) with all Parties under Sundry  Creditor Account Group
  • Cash  Bank :  To get Stock Item Transaction Analysis of  Cash Purchase & Cash Sales  through all Cash Bank transaction  of Sales / Purchase Voucher
  • Branch: To get Stock Item Transaction Analysis of  transaction with Ledger Accounts under Branch / Divisions through all Cash Bank transaction  of Sales / Purchase Voucher.

Account Group Stock Item  Movement Analysis in Tally

Stock Item / Account Group Voucher  Analysis in Tally

Stock Item / Account Group  Movement Analysis Buttons in Tally

At Account Group Movement Analysis, you get following buttons :

Stock Item / Account Group  Movement Analysis Button Bar in Tally

ButtonDescription
F4: GroupTo select an Account Group to get Account Group Movement Analysis Report of the selected Account Group
Columnar Report ButtonsColumn specification to get columnar  Reports

Account Ledger Stock Item Movement Analysis in Tally

At Movement Analysis Menu, select Ledger  Analysis and then select  any Account Ledger as follows :

  • Customer Ledger  : To get Stock Item Transaction Analysis of Sales (& Purchase) with the selected Ledger Account .
  • Supplier Ledger  : To get Stock Item Transaction Analysis of Purchase ( &Sales) with the selected Ledger Account .
  • Cash  Bank Account :  To get Stock Item Transaction Analysis of  Cash Purchase & Cash Sales  through the selected Cash / Bank Ledger Account of all transaction  through Sales / Purchase Voucher
  • Branch Account : To get Stock Item Transaction Analysis of  transaction with the selected Ledger Accounts under Branch / Divisions through all Cash Bank transaction  of Sales / Purchase Voucher.

Stock Item / Account Ledger Movement Analysis in Tally

Account Ledger  Stock Item Movement Analysis Buttons in Tally

At Account Ledger Movement Analysis , you get following buttons :

Account Ledger / Stock Item  Movement Analysis Button Bar  in Tally

ButtonDescription
F4: LedgerTo select an Account Ledger to get Account Ledger Movement Analysis Report of the selected Account Ledger.
Columnar Report ButtonsColumn specification to get columnar  Reports

Account Group / Ledger Stock Item Movement Analysis Configuration in Tally

At Account Group Movement Analysis / Account Ledger Movement Analysis, click F12:Configure to get Account Movement Analysis Configuration to set the  following  options :

  • Purchases : At Show Purchases Column :
    • Set Yes to show the Purchases section columns (Quantity, Rate, Value etc)
    • Set No to suppress the Purchases section columns
  • Sales : At Show Sales Column :
    • Set Yes to show the Sales section columns (Quantity, Rate, Value etc)
    • Set No to suppress the Sales section columns
  • Quantity : At Show Quantities :
    • Set Yes to show the Quantity column (at Purchase / Sales section)
    • Set No to suppress the Quantity column (at Purchase / Sales section)
  • Alternate Unit : This is relevant only when Alternate Unit is activated. At Show using Alternate units:
    • Set Yes to show the quantity in Alternate units also (for Items having Dual Units),
    • Set No, only the Base Unit is shown.
  • Tail Unit : This is relevant only for Items with Compound Unit. At Show Tail units of Compound Units,
    • Set Yes to show the tail units of compound unit,
    • Set No. the base unit is shown (with fraction values, where applicable)
  • Rate : At Show Rates,
    • Set Yes to show the Rate column (at Purchase / Sales section)
    • Set No to suppress the Rate column (at Purchase / Sales section)
  • Value : At Show Values:
    • Set Yes to show the Value column (at Purchase / Sales section)
    • Set No to suppress the Value column (at Purchase / Sales section)

Account Group  / Ledger Stock Item Movement Analysis Configuration in Tally

In Account Ledger  / Account Group Movement Analysis, you get Basic & Effective Rates both for Outwards (Sales) and Inwards (Purchase), for each Stock Item.

Stock Journal Movement Analysis in Tally

At Movement Analysis Menu , select Transfer Analysis and then select  any Stock Journal Type to get Stock Journal  Movement  Analysis.

Stock Journal Movement Analysis in Tally

Stock Journal Movement Analysis Configuration in Tally

At  Stock Journal  Movement Analysis, click F12:Configure to get Stock Journal Movement Analysis Configuration

Stock Journal Movement Analysis Configuration in Tally

Now set the  following  options :

 Goods In : At Show Goods In (Production) Column :

  • Set Yes to show the Goods In (Production) section columns (Quantity, Rate, Value etc)
    • Set No to suppress the Goods In (Production) section columns
  • Goods Out : At Show Goods In (Consumption) Column :
    • Set Yes to show the Goods In (Consumption) section columns (Quantity, Rate, Value etc)
    • Set No to suppress the Goods In (Consumption) section columns
  • Quantity : At Show Quantities :
    • Set Yes to show the Quantity column (at Purchase / Sales section)
    • Set No to suppress the Quantity column (at Purchase / Sales section)
  • Alternate Unit : This is relevant only when Alternate Unit is activated. At Show using Alternate units:
    • Set Yes to show the quantity in Alternate units also (for Items having Dual Units),
    • Set No, only the Base Unit is shown.
  • Tail Unit : This is relevant only for Items with Compound Unit. At Show Tail units of Compound Units,
    • Set Yes to show the tail units of compound unit,
    • Set No. the base unit is shown (with fraction values, where applicable),
  • Rate : At Show Rates,
    • Set Yes to show the Rate column (at Purchase / Sales section)
    • Set No to suppress the Rate column (at Purchase / Sales section)
  • Value : At Show Values:
    • Set Yes to show the Value column (at Purchase / Sales section)
    • Set No to suppress the Value column (at Purchase / Sales section)

Stock Journal Movement Analysis Buttons in Tally

At Stock Journal Movement Analysis , you get following buttons :

Stock Journal Movement Analysis Button Bar in Tally

ButtonDescription
F4: Voucher TypeTo select a Stock Journal Voucher Type to get Stock Journal Movement Analysis Report of the selected Voucher Type .
Columnar Report ButtonsColumn specification to get columnar  Reports

Stock Item Voucher Movement Analysis

Stock Item Voucher Analsyis is a class of Reports showing the Itemwise Sumary of Transactions of a selected  Stock Group, Account Group, Account Ledger or StockJounal Voucher Type, obtained on drill down of any record inany of the Movement Analyss Reports discussed above.

You get the resepctive Stock Item Voucher Movement  Analysis as follows:

Stock Item / Account Ledger Voucher Movement Analysis in Tally

At Stock Item Movement Analysis,  drill down through any Party record under Buyer / Supplier section to get Item Voucher Analysis Report ( showing the details of Purchase / Sale transactions of the selected Item with the selected Party

Stock Item / Account Ledger  Voucher Inwards Movement Analysis in Tally

Stock Item / Account Ledger  Voucher Outwards Movement Analysis in Tally

Stock Item / Account Group Voucher Analysis in Tally

At Account Group Movement Analysis ,  drill down through any Stock Item  record under  to get Item Voucher Analysis showing the details of Purchase / Sale transactions of the selected Item with the Parties under the selected Group.

Stock Item / Account Group Item Voucher Movement Analysis in Tally

Stock Item / Account Ledger Movement Analysis in Tally

At Account Ledger Movement Analysis,  drill down through any Stock Item  record under  to get Item Voucher Analysist showing the details of Purchase / Sale transactions of the selected Item with the selected Ledger Account.

Stock Item / Account Ledger Movement Analysis in Tally

Stock Item / Stock Journal Voucher Analysis in Tally

At Stock Journal Movement Analysis ,  drill down through any Stock Item  record  to get Item Voucher Analysis Report showing the details of Goods In (Production) / Goods Out (Consumption) of the Stock Journal transactions of the selected Item through the selected Stock Journal Voucher Type

Stock Item  Stock Journal Movement Analysis Configuration in Tally

At any Stock Item Voucher Analysis report described above, click F12:Configure to get  Stock Voucher Analysis Configuration,

Stock Item / Stock Journal  Movement Analysis Configuration in Tally

Now set following options :

  • Additional Cost : At Show Addl. Cost Column:
    • Set Yes to get the ‘Addl Cost’ column for Additional Cost (Apportioned / Allocated Other per Unit, apart from the Item Basic Cost
    • Set No. The Addl Cost’ column is not shown
  • Full Additional Cost : Having set Yes at  Show Addl. Cost Column, at  Show Full Additional Cost, :
    • Set Yes to get the column ‘Others’ in place of  Addl Cost’ to show full Additional Cost apart from the Item Basic Cost
    • Set No. The ‘Others’ column is not shown
  • Format : At Format :
    • Select Condensed to show Party Total figures
    • Select Detailed to show Voucher details (Voucher Number) in next line. You may further drill down through selected Voucher
  • Quantity : At Show Billed Qty Column :
    • Set Yes to show the Quantity column (and the base unit) , if the Base Unit of all the Items under the Stock Group is same
    • Set No to suppress the Quantity column.
  • Alternate Unit : This is relevant only when Alternate Unit is activated. At Show using Alternate units:
    • Set Yes to show the quantity in Alternate units also (for Items having Dual Units),
    • Set No, only the Base Unit is shown.
  • Tail Unit : This is relevant only for Items with Compound Unit. At Show Tail units of Compound Units,
    • Set Yes to show the tail units of compound unit,
    • Set No. the base unit is shown (with fraction values, where applicable)
  • Rate : At Show Base Rate Column,
    • Set Yes to show the Base Rate column (and the base unit) ,
    • Set No to suppress the Base Rate column.
  • Base Value : At Show Base ValueColumn:
    • Set Yes to show the Base Value column
    • Set No to suppress the Base Value column
  • Total Value : At Show Total ValueColumn:
    • Set Yes to show the Total Value column  (Base Value + Other Charges)
    • Set No to suppress the Total Value column
  • Effective Rate : At Show Eff. RateColumn:
    • Set Yes to show Effective Rate column  (Rate per unit on Total Value)
    • Set No to suppress the Eff. Rate column

Stock Item  Stock Journal Movement Analysis Buttons in Tally

At Stock  Voucher Analysis Report of  Customer / Supplier Ledger , you get following Buttons :

Stock Item  Stock Journal Movement Analysis Button Bar in Tally

ButtonDescription
F1 : Detailed / CondensedF1 : Detailed : To show next level Stock Groups / Stock Item detailsF1 : Condensed : To show only top level Stock Groups.
F4: ItemTo select a Stock Item to get Stock Voucher Analysis  of transactions of the selected Stock Item with the currently selected Party.
F5:LedgerTo select a Party Ledger to get Stock Voucher Analysis  of transactions of the selected  Party Ledger with the currently selected Stock Item.

At Stock  Voucher Analysis Report of  Account  Ledger , you get following Buttons:

Stock Item / Account Ledger Stock Journal Movement Analysis Button Bar in Tally

ButtonDescription
F4:LedgerTo select a Account Ledger to get Stock Voucher Analysis  of transactions of the selected  Account Ledger with the currently selected Stock Item.

At Stock  Voucher Analysis Report of  Account  Group , you get following Buttons:

Stock Item / Account Group Stock Journal Movement Analysis Button Bar in Tally

ButtonDescription
F1 : Detailed / CondensedF1 : Detailed : To show next level Stock Groups / Stock Item detailsF1 : Condensed : To show only top level Stock Groups.
F4: ItemTo select a Stock Item to get Stock Voucher Analysis  of transactions of the selected Stock Item with the currently selected Party.
F5:GroupTo select an Account Group to get Stock Voucher Analysis  of transactions of the selected  Account Group with the currently selected Stock Item.

Account  Ledger Stock Journal Voucher Movement Analysis Button Bar in Tally

Click here to see PDF