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…
Display Stock Summary
Display Stock Items
Stock Ageing Analysis
Sales and Purchase Orders
Display Batchwise Reports
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
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.
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).
You can also use the Stock Summary to view Stock Items. Place the cursor on the item, and press Enter .
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:
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:
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.
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.
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 .
Movement Analysis of a selected stock group displays the total Inward and Outward movement of all the items in a selected Stock Group .
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:
3. Select the Supplier, Buyer or Stock Journal Name and press Enter . The transaction level details of the item appears as shown below:
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
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.
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
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.
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:
Press F12: Configure towards configuration of Transfer Analysis Report….
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.
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 ).
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 .
The different ageing styles that are provided in Tally.ERP 9 include the purchase date, expiry date, manufacturing date, and so on.
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 Outstandings > choose the report to view.
Purchase Order Book
A 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 .
Bill of Materials (BoM) in TallyERP9
e-Way Bill using Tally.ERP9
Price Levels and Price List in TallyERP9
Purchase of Capital Goods with GST in Purchase Voucher (F9) in Tally.ERP9
Purchase of ‘Nil-Rated’ , ‘Exempted’, Items & Goods using Tally.ERP9
Purchase Order Processing in TallyERP9
Record Expenses with GST in Purchase Voucher (F9) in Tally.ERP9
Sale of Goods and Services in a Single Invoice with multiple GST Rate in Tally.ERP9
Sale of Items and Goods with Inclusive of Tax Rate in Tally.ERP9
Sale of Items and Goods with Separate Actual and Billed Quantity Columns in Tally.ERP9
Sale of Items and Goods with Zero Valued Entries (Free Products) in Tally.ERP9
Sale of Nil-Rated, Exempted Supplies of Items and Goods using Tally.ERP9
Sales Order Processing in TallyERP9
TDS (Tax Deducted At Source) using TallyERP9
Cost Centre and Cost Category in TallyERP9
You may also like....
GST on Advance Received from Customer in TallyERP9
GST on Reverse Charge Mechanism -RCM (Purchase from Unregistered Dealer) using TallyERP9
GST Sale of a Composite Supply (Sale of Items & Goods with Expenses Apportioning) in Tally.ERP9
Setting MRP details in Stock Items with GST using Tally.ERP9
Setting Nil-Rated, Exempted, Zero-Rated & Non-GST Items & Goods using Tally.ERP9
Splitting Company Data in TallyERP9 based on Financial Year
Stock Units of Measure (Simple / Compound) in TallyERP9
Year-end Processing with Data Transfer to Next Financial Year in TallyERP9
Shortcut Keys in TallyERP9
GSTR-1 Report to File GST Return using Tally.Erp9
GSTR-2 Report to File GST Return using Tally.Erp9
GSTR-3B Report to File GST Return using Tally.Erp9
© 2021 : www.tallyerp9book.com