TallyERP9 Tutorial Part-30: Inventory Reports and Statements

The transactions entered in Tally.ERP 9 are immediately posted to the respective ledgers, books and registers. The inventory reports are generated based on these transactions. This facilitates instant reporting and faster decision making.

The appearance of reports can be changed according to your requirements.

From a report, you can drill down to the next level of details by highlighting the item and pressing Enter . You can keep drilling down until you reach an individual voucher. Similarly, you can move back to higher levels by pressing [Esc] key.

The special features available for the currently displayed report are indicated on the button bar. You can activate these features with a single click. You can modify and print reports according to your requirements.

Following Reports can be Displayed…

  1. Display Stock Summary
  2. Display Stock Items
  3. Location/Godown Summary
  4. Movement Analysis
  5. Stock Ageing Analysis
  6. Sales and Purchase Orders
  7. Reorder Status
  8. Display Batchwise Reports
Tally.ERP9 Book (Advanced Usage) @ Rs.550
Tally.ERP9 Book (Advanced Usage) @ Rs.550

1. Stock Summary Report in Tally.ERP9

Stock Summery is a Statement of Stock in hand on a particular date. The statement is updated with every transaction to provide Stock Position at any given time.

Tally.ERP treats Stock Summary as one of the Primary Statements and makes it accessible directly from the Gateway of Tally.ERP. As with all Tally.ERP Reports, it can be drilled down and configured to view different details, as well as total Flow of Stock.

To view Stock Summary :

Go to Gateway of Tally.ERP > Stock Summary

Inventory Reports and Statement in TallyERP9
Inventory Reports and Statement in TallyERP9

Stock Flow (Opening–Inward–Outward–Closing)-Reconciliation

The Stock Summary Statement can be configured to display the flow of goods.

Select  F12:Configure while in the Stock Summary Screen

This statement shows the flow of stock: Opening Stock, Goods Inwards, Goods Outward and Closing Stock.

Inventory Reports and Statement in TallyERP9
Inventory Reports and Statement in TallyERP9
Inventory Reports and Statement in TallyERP9
Inventory Reports and Statement in TallyERP9

2. Stock Items Report in Tally.ERP9

You can view stock items in based on the configuration you need for effective analysis of your stocks.

To view stock items

1.            Go to Gateway of Tally Display Inventory Books Stock Item .

2.            Select an item from the List of Items .

3.            Click F12: Configure to open the Configuration screen .

4.            Set Show Graph by Values (not Qty)? to Yes and press Enter. This will display a graph showing goods inwards and outwards (red for inwards, blue for outwards).

Inventory Reports and Statement in TallyERP9
Inventory Reports and Statement in TallyERP9

You can also use the Stock Summary to view Stock Items. Place the cursor on the item, and press Enter .

Viewing Stock Item Vouchers

You can view stock item vouchers with additional details such as daily breakup and dates for inwards or outwards balance.

To view stock item vouchers

1.            Go to Gateway of Tally > Display > Inventory Books > Stock Items

2.            Select a stock item from the List of Items.

3.            Drill down from any month to display Stock Vouchers.

The Stock Vouchers screen with the list of stock vouchers for the current month appears as shown below:

Inventory Reports and Statement in TallyERP9
Inventory Reports and Statement in TallyERP9

3. Godown / Location Summary Report in Tally.ERP9

Tally.ERP 9 summarises the details of stock items available in each godown in the Godown/Location Summary report. If you have created godowns in a hierarchy, the report gives you a consolidated view of the stock available. You can view the closing and opening balances of your stock, inward and outward stock details, and all corresponding transactions. 

Gateway of Tally Display Statements of Inventory Godown , and select the Godown 

The Godown/Location Summary report shows the summary of the stock for each godown with closing balance

Press Shift Enter on the selected godown to see the next level of data for that godown on the same screen.  The report will display the stock item as shown below:

 Inventory Reports and Statement in TallyERP9
Inventory Reports and Statement in TallyERP9

4. Movement Analysis Report in Tally.ERP9

Movement analysis shows the analysis of only those inventory transactions which are integrated with the accounts, i.e. inventories which are also recorded in the books of accounts. Inventory vouchers which affect the stock only in quantitative terms are not considered.

Movement analysis report is used for comparative studies. They give an insight into the flow characteristics of the stock in an organization. It also helps in finding out the slow moving items which cause blockages in the flow of the working capital of the organization.

  • Go to Gateway of Tally Display Inventory Books Movement Analysis .
Inventory Reports and Statement in TallyERP9

Movement Analysis Reports show only those inventory transactions for which accounting transactions have also been recorded. You can analyze stock movements by stock groups, categories, financial group or ledger.

4.1. Movement Analysis (Stock Group Analysis)

This report shows the details of inward and outward transactions carried out for all the stock items in that group.

Go to Gateway of Tally Display Inventory Books Movement Analysis Stock Group Analysis > select a Stock Group .

Inventory Reports and Statement in TallyERP9
Inventory Reports and Statement in TallyERP9

Movement Analysis of a selected stock group displays the total Inward and Outward movement of all the items in a selected Stock Group 

4.2. Stock Item Movement Analysis

Stock item movement analysis report provides supplier wise, buyer wise and consumption wise details of stock item movement. Purchase cost comparison for the item across suppliers and sale value comparison across buyers can be viewed here.

To view Item Movement Analysis report

1.            Go to Gateway of Tally Display Inventory Books Movement Analysis Stock Item Analysis .

2.            Select the item from the List of Stock Items . The Item Movement Analysis screen appears as shown below:

Inventory Reports and Statement in TallyERP9
Inventory Reports and Statement in TallyERP9

3.            Select the Supplier, Buyer or Stock Journal Name and press Enter . The transaction level details of the item appears as shown below:

Inventory Reports and Statement in TallyERP9

4.3. Accounts Group Movement Analysis

Group Analysis report contains information about Items transacted in Vouchers for the Ledgers created under the selected Group.

To view the movement analysis for any particular Account Group

  • Go to Gateway of Tally > Display > Inventory Books > Group Analysis (Sundry Creditor).
Inventory Reports and Statement in TallyERP9
Inventory Reports and Statement in TallyERP9

After selecting an Account Group from List of Groups, information relating to Quantity, Effective Rate and Value under separate columns for Sales and Purchase is displayed.

4.4. Ledger Movement Analysis

Ledger Analysis is similar to Group Movement Analysis, where sales and purchases of stock items involving the selected ledger can be viewed. The next level of information brings up the transaction-level details.

To view the movement analysis for any particular account ledger

  • Go to Gateway of Tally Display Inventory Books Movement Analysis > Ledger Analysis. Select the Ledger Cash, the Ledger Analysis report appears as shown below:
Inventory Reports and Statement in TallyERP9
Inventory Reports and Statement in TallyERP9

This report contains information about the items which are transacted in sales and purchase vouchers for the selected ledgers.

When you select an account ledger (Debtor/Creditor/Cash/Bank) for the Ledger Analysis report, the sale and purchase of all the items, affecting the selected ledger, will be displayed in this report.

4.5. Transfer (Movement) Analysis

When using different stock journals for each transaction, Transfer Analysis gives the movement details for each type of stock journal.

This report displays information about the items which are transacted in the stock journal voucher. Generally, in stock journal voucher, movement of goods, manufacture of goods or inter-godown transfer is recorded.

This is a very useful costing and waste analysis tool. In non-manufacturing set ups, which have multiple godowns, this report is a quick check to verify that all transfer entries have been entered correctly.

To view the Transfer Analysis screen for any stock journal voucher type:

  • Go to Gateway of Tally Display Inventory Books Movement Analysis Transfer Analysis ( Select Manufacturing Journal)
Inventory Reports and Statement in TallyERP9
Inventory Reports and Statement in TallyERP9

Press F12: Configure towards configuration of Transfer Analysis Report….

Inventory Reports and Statement in TallyERP9

5. Stock Ageing Analysis Report in Tally.ERP9

Stock Ageing Analysis Report in Tally.ERP 9 displays the age of the stock-in-hand. This report lists the age-wise break-up of inventory to demarcate old stock. Tally.ERP 9 gives its users the flexibility to define their own ageing slabs.

Ageing Analysis lists out items batch wise, that have already expired or may expire in the near future. This information will help you keep track of the age of stock and also quick moving inventory, as older stock may depreciate in value or become obsolete, and result in a loss.

You can view the Ageing Analysis report and also change the Appearance of Stock Item Names.

Go to Gateway of Tally Display Inventory Books Ageing Analysis > Select the group for which Ageing Analysis is required.

Inventory Reports and Statement in TallyERP9
Inventory Reports and Statement in TallyERP9

This report is displayed in a columnar format showing item details, quantity, value and age-wise break-up.

To get a report for all the stock items, select Primary from List of Groups .

If you want to view only the quantity of the item, press the Hide Amount button from the button bar or press Alt+A .

By default, all the stock items in the ageing analysis report are displayed according to the stock item name. This is defined in the General Configuration screen ( Gateway of Tally F12: Configuration General ).

5.1. Changing the Default Ageing Period

The Ageing Analysis report produces a default ageing period of <45 days, 45-90 days, 90-180 days, and >180 days. You can define the ageing slabs, depending on the requirement.

By default, the age of the items is ascertained from the date of purchase. You can change this by altering the configuration options. To define the ageing slab press F6 .

Inventory Reports and Statement in TallyERP9

Ageing Style

The different ageing styles that are provided in Tally.ERP 9 include the purchase date, expiry date, manufacturing date, and so on.

  • Press Alt+S to see the Ageing Styles .
Inventory Reports and Statement in TallyERP9
Inventory Reports and Statement in TallyERP9

6. Sales and Purchase Order Report in Tally.ERP9

In Tally.ERP 9, various features of sales and purchase order such as sales order book, sales order summary, purchase order book, purchase order summary, sales and purchase bills pending details are supported.

  • Sales Order Book
    • This report displays all the sales orders for each month. You can view and configure this : 

Gateway of Tally Display Inventory Books Sales Orders Book

  • Sales Order Summary
    •  There are different reports that show the sales orders outstanding. The outstanding orders can be viewed Stock Group-wise, Stock Category-wise, Stock Item-wise, account Group-wise, ledger-wise or from All Orders.

Gateway of Tally Display Statement of Inventory Sales Order Outstanding > choose the report to view.

  • Purchase Order Book
    • Purchase Order is raised when there is a request for material. Purchase Order Book displays  the list of all purchase orders. You can view a summary  of all the purchase  orders till the date of last order entered. You can view this

Go to Gateway  of Tally> Display Inventory Books Purchase Order Book . The Purchase Order Book is displayed

  • Purchase Order Summary
    • Purchase Order Summary statement gives detailed information on outstanding purchase orders. The outstanding orders can be viewed Stock Group wise, Stock Category wise, Stock Item wise, account Group wise,  , Ledger wise or All Orders .

Go to Gateway of Tally Display Statements of Inventory Purchase Order Outstandings

  • Purchase Bills Pending
    • The list of bills for which inventory transactions are completed, but where the accounting transactions are pending are displayed in the Purchase Bills Pending report.

Go to Gateway of Tally Display Statements of Inventory Purchase Bills Pending . The Purchase Bills Pending report appears

  • Sales Bills Pending
    • Sales Bills Pending report lists all instances of incomplete sales, where goods may have been delivered but not invoiced. It also lists instances of invoices raised, but against which goods have not been delivered.

This report lists transactions of Goods Delivered but bills not Made, and Sales bills to make.

Gateway of Tally Display Statements of Inventory Sales Bills Pending .

Leave a Comment

Your email address will not be published.

error: Content is protected !!