Basic Inventory Reports in Tally

Inventory Reports in Tally

Having entered the transaction vouchers (of Purchase & Sales Voucher, Invoice) with Inventory Details, you may get various inventory reports instantly. Such Inventory Reports range from various Maser Lists, Registers, Day Books to Summary Statements.

Inventory Masters Lists in Tally

The following reports belong to the first Category  : Lists of Inventory Masters.   

Stock Item Groups List : Select Display > List of Accounts. Click T:Stock Groups button at the vertical button at the right, to get the List of Stock Groups in hierarchical order . The list appears in alphabetical order of Primary Stock Groups. The  Stock Group list shows the  hierarchical  structure Stock  Groups & Sub Groups, as per  reporting needs and better Inventory management.

Stock Item Groups List in Tally

Stock Items List  : Select Display > List of Accounts. Click the button I: Stock Items to get the List of Stock Groups & Stock Items in hierarchical order . The list appears in alphabetical order of Primary Stock Groups with sub groups and stock items in hierarchical order.

Stock Item Groups List in Tally

Stock Item Units of Measure List : Select Display > List of Accounts. Click the button N:Units to get the List of  UoM in alphabetical order.

List of Units in Tally

Stock Item Master List Buttons in Tally

Stock Item Master List Button Bar in Tally

Apart from displaying Master records, you also get option to maintain Master records. Master list is the only report, where from you may also create new master records, apart from displaying. So, List of Masters is a report cum entry module for Masters.

At the bottom of the Master list, you get a number of buttons to maintain Masters records

• Creation of New Master Record : Click C:Create (or press Alt+C)  to create new Master records. The Master creation screen appears. Now enter the Master record as usual.
• Alteration of Master Record : Place the cursor on the desired Master record to be altered, and press <Enter> or click Enter : Alter button at the bottom line button bar. The Master record is displayed in Alteration mode. Now you may make alteration in the master as Usual
• Deletion of Master Record : Place the cursor on the desired Master record to be deleted and Click D:Delete button (or press Alt+D) The Deletion confirmation prompt appears (subject of rules of deletion). Type Y to confirm deletion.  

Inventory Accounting Voucher Registers in Tally

Inventory Accounting Voucher Registers comprise the collective set of  Reports containing Accounting Voucher with Inventory details.. These Reports constitute the lowest level of Inventory Reports and contain data of a voucher. On drill down from any voucher data in any type Inventory Voucher list, you get the selected Voucher in Alteration mode.

Inventory Accounting Voucher Register in Tally

Voucher Registers : These Reports show the Voucher Registers of a specific Voucher Type, with Inventory details

• Sales Register : Display> Account Books > Sales Register
• Purchase Register : Display> Account Books > Purchase Register
• PoS Register : Display> Account Books > PoS Register
• Journal Register : Display> Account Books > Journal Register
• Debit Note Register : Display> Account Books > Journal Register > Debit Note Register
• Credit Note Register : Display> Account Books > Journal Register > Credit Note Register
• Stock Journal Registers : Display> Inventory Books >Stock Transfers

Stock Item Voucher Register : The Stock Voucher Registers are obtained through successive drill down from any Summary Report, reaching upto a Stock Item / Month and then drill down through the Stock Item / Month to get voucher lists of the selected Item / Month, like :

• Display > Inventory Books > Stock Item
• Display > Inventory Books > Group Summary. Select a Stock Group
• Display > Inventory Books > Ageing Analysis. Select a Stock Group
• Stock Summary. Select a Stock Group

Stock Item  Voucher Register in Tally

Inventory Accounting Voucher Day Book in Tally

Inventory Accounting Voucher Day Book is a date wise list of all types of Voucher. Sales / Purchase Vouchers containing Inventory details.

Inventory Accounting Voucher Day Book in Tally

Select Display>Day Book to get Day Book for the current Date.

Contents of Report

• The Item details are shown under the Sales Purchase Ledger Account (net of Item Discount, if any), the Item Level Discount % & Discount amount is not shown in Day Book, as Item level Discount is reduced from the Sales Value. 
• For Accounting Vouchers (Sales / Purchase, D/N & C/N), the Dr / Cr against the Ledger Account indicates whether the amount is added /reduced in the Voucher.
• In Sales Voucher,Cr indicates the amount is added, while Dr indicates the amount is reduced in the voucher.
• In Purchase Voucher,  Dr indicates the amount is added, while Cr in Purchase  Voucher indicates the amount is reduced.
• In Debit Note, Cr indicates the amount is added, while Dr  indicates the amount is reduced in the voucher (like Sales Voucher).
• In Credit  Note, Dr indicates the amount is added, while Cr  indicates the amount is reduced (like Purchase Voucher)
• For Stock Journal vouchers, the Ledger Accounts are not applicable, only Stock Item details are shown. The first Stock Item is shown in Outwards or Inwards column, as the case may be. However, other Item details are shown in inner column, Outwards is shown as negative figure, while Inwards is shown as positive figure.

Inventory Accounting Voucher Day Book Display Configuration in Tally

Click F12:Configure to get Configuration screen. At Show Inventory details, set Yes to get Inventory Details in the report.

Inventory Accounting Voucher Day Book Display Configuration in Tally

Inventory Accounting Voucher Day Book Display Buttons in Tally

• Voucher Type : Click F4: Chg Vch , and select the Voucher Type (Sales, Purchase, Debit Note & Credit Note), to get a report like Voucher Register for the selected Voucher Type.
• Report Period : Click F2:Period to set the period to see the report for the specified period

Inventory Accounting Voucher Day Book Display Button Bar in Tally

Stock Item Voucher Lists in Tally

Stock Item Voucher Lists are linked Reports to various Inventory Monthly summary statements, for a selected Item, as described below.  Drill Down from Monthly summary to get the Voucher List for the selected Month.

• Select Display > Inventory Books > Stock Item and then select an Item to get Item Monthly Summary. Now select a month to get Stock Vouchers for the selected Month.
• Select Display > Inventory Books > Group Summary. Select a Stock Group / Stock Item to get Stock Item Monthly Summary. Now select a month to get Stock Vouchers for the selected Period .
• Select Display > Inventory Books > Ageing Analysis. Select a Stock Group / Stock Item to get Stock Item Monthly Summary. Now select a month to get Stock Vouchers for the selected Period
• Select Display > Inventory Books > Exception Report > Negative Stock. Select an Item to get Item Monthly Summary. Now select a month to get Stock Vouchers for the selected Period.
• Select Stock Summary. Select a Stock Group / Stock Item to get Item Monthly Summary. Now select a month to get Stock Vouchers for the selected Period.

Stock Item Vouchers List display in Tally

Contents of Report

• Detailed Format : The Stock Voucher list in Detail format  shows the details of all Items transacted in a voucher, but the Inward /Outward & Stock column shows the quantity in respect of the selected Item. Other complementary Items are shown in Inner column. The sign Cr against the Item in inner column indicates Outwards, Sign Dr against the Item in inner column indicates Inwards So, it is  like a composite Journal & Ledger of all the Items in the voucher in which the selected Item is transacted.
• Condensed Format : The Stock Voucher list in Condensed format shows the Inward /Outward & Stock column in respect of the selected Item . So, it is like a columnar Stock  Ledger of  the selected Stock Item.

Stock Item Voucher Lists Configuration in Tally

Click F12:Configure to get Configuration screen. Set Yes at options to include respective numerical columns

Stock Item Vouchers List display Configuration in Tally

Stock Item Voucher Lists Buttons in Tally

• Report Period : Click F2:Period to set the period to see the report for the specified period
• Stock Item  Selection: Click F4:Item to select the Item for which you like to get Report
• S:Stock Alter : Click S:Stock Alter button to get the Stock Item Master alteration screen to make modification in Stock Master, from within the Report

Stock Item Voucher List display Button Bar in Tally

Inventory Accounting  Voucher Register Display in Tally

Inventory Accounting Voucher Registers are list of Vouchers with Inventory details. Select the desired Register as described below. Select a month to get Monthly Register for the selected Month.

• Sales Voucher Register: Select Display > Account Books > Sales Register.
• Purchase Voucher Register: Select Display > Account Books > Purchase Register.
• Debit Note  Register: Select Display > Account Books > Journal Register > Debit Note Register. 
• Credit Note  Register: Select Display > Account Books > Journal Register > Credit Note Register .
• Journal Register: Select Display > Account Books > Journal Register > Journal Register .

Inventory Accounting Voucher Register Display in Tally

Inventory Accounting  Voucher Register Configuration in Tally: At Voucher Register, click F12: Configure to get Voucher Register Configuration screen. Set Yes at Show Inventory Details to get the Inventory details in the report.

Inventory Accounting Voucher Register Display Configuration in Tally

Inventory Accounting Voucher Register Buttons in Tally : Click F2:Period and set the desired period to get the Voucher Register for selected Period.

Inventory Accounting Voucher Register Display Button Bar in Tally

Inventory Voucher Register Extract Display in Tally

At Voucher Register Configuration screen, set Yes at Show Extract of Vouchers to show only the summarised figures of Items and the respective Stock Groups, in hierarchical structure

Inventory Voucher Register Extract Display in Tally

Stock Journal Voucher Register Display in Tally

Stock Journal Voucher Register is Date wise list of Stock Journal Vouchers.

Select Display > Inventory Books > Stock Transfer to get a list showing the number of Stock Journal vouchers in each month.

Drill down through a month to get Stock Journal Voucher List.

Stock Journal Voucher Register Display in Tally

Stock Journal Voucher Register shows the Quantity of the first Item in the voucher in  respective Inward & Outward column, while the Quantity of other Items are shown in inner column. In inner column, Outward Quantity (which reduces stock) is shown as negative figure, while Inward Quantity is shown as positive figure.

Stock Journal Voucher Register Display Configuration in Tally : Click F12:Config to get Voucher Register Configuration screen. Set the options as required

Stock Journal Voucher Register Display Configuration in Tally

Stock Journal Voucher Register Buttons in Tally

Click F2:Period and set the desired period to get the Stock Journal Voucher Register for selected Period .

Click F4:Chg Vch to select a voucher type to get Voucher Register of the selected  Voucher Type

Stock Journal Voucher Register Display Button Bar in Tally

Closing Stock value manual entry in Tally

The Closing Stock Value is shown in P L Statement as well as in Balance Sheet. When Accounts & Inventory are Integrated Computed value of Closing Stock value from the Inventory System as per specified Valuation Method.

However, When Accounts & Inventory are  NOT Integrated, you have to manually enter the Closing Stock Value  in Closing Stock Ledger Account.

Accounts & Inventory Integration in Tally

You may set the option for Accounts at any time to get the Accounts as per Integrated (as per Inventory System Closing Stock Value) or Non Integrated (as per Book Stock Value) system, for comparison.

Click F11:Features > Inventory Features and set Yes at Integrate Accounts with Inventory  to Integrate the Inventory with Accounts System. Consequently, Closing Stock Value as per Inventory System, as shown in Stock Summary, is automatically posted  in Accounts (i.e in P L Statement and in Balance Sheet).

Accounts & Inventory Integration in Tally

Closing Stock Value Manual Entry in Tally

At Gateway of Tally, select Accounts Info>Ledger>Alter & select the Stock Account (under Stock-in Hand group). Now enter Date & Value for Closing Stock for respective Date.

Closing Stock Value entry  in Stock Ledger  Account in Tally

Drill Down

• Integrated mode : When you drill down for the Closing Stock  from Balance Sheet  (under Current Assets) or Profit & Loss Account, (at Credit Side), you get the Stock Summary  Report as per Inventory System.
• Non-integrated mode:  When you drill down for the Closing Stock  from Balance Sheet  (under Current Assets) or Profit & Loss Account, (at Credit Side), you get the Stock Ledger Account (under Stock-in-Hand Group under Current Assets) Account, showing the Stock  Values as entered at Closing Stock Ledger..

For more info on Inventory Reports in Tally, visit :