Add to Favourites

Use Stock Item Cost Analysis Report in TallyPrime

When you enable cost tracking for stock items, you would want to know the profitability of the stock item. In TallyPrime, you can:

• View the Stock Item Cost Analysis report: Know the cost, revenue, balance at cost, and profit & loss across various transactions in which the stock item is used.
• View the Item Cost Track Breakup: Along with profitability, you get to know Item Movement Summary, which contains the details of Item Movement Inward/Outwards, such as Order Placed/Received, Material Received/Delivered, Materials Billed, and Materials Manufactured.
• Close Cost Tracking for stock items: Choose to close cost track if you no longer wish to track the costs of an item. Once you close cost tracking, the cost tracking number will no longer be available under the list of cost tracking numbers while recording transactions.

Analyse Stock Item/Group Cost

1. Press Alt+G (Go To) > type or select Stock Item Cost Analysis and press Enter.
2. Select the Stock Item from the List of Stock Items.
   
3. View items for which cost tracking is closed or open, as needed.
   1. Press Ctrl+B (Basis of Values).
   2. Type of Cost Track: Select from the Types of Track.
      1. All Tracks: View stock items with both Close and Open Tracks.
      2. Close Tracks: View stock items for which cost tracking is closed.
      3. Open Tracks: View stock items for which cost tracking is still going on.
         

Similarly, you can view the Stock Group Cost Analysis report.

1. Press Alt+G (Go To) > type or select Stock Group Cost Analysis and press Enter.
2. Select the Stock Group from the List of Stock Groups.

View Item Cost Track Breakup

1. Press Alt+G (Go To) > type Cost Track Breakup and press Enter.
2. Select the Cost Track from the List of Cost Tracks.
   
   You can view the Item Cost Track Breakup report with the Tracking Details, Cost (Expense), Revenue (Income), Nett Profit, and Item Movement (Inwards and Outwards).
   
3. To view the report Ledger-wise, press F5 (Ledger).

Close Cost Tracking for a Stock Item

1. In the Stock Item Cost Analysis report, press Alt+S (Close Cost Track).
   
2. In the Cost Track Closure Details screen, press Spacebar and select the required rows.
   
3. To view all the items irrespective of status, press F8 (Show All).
4. Press Alt+S (Close Cost Track) to close the selected tracks.

Questions & Answers

1. How can I analyse the expenses and revenue for a specific cost track of a stock item?
   Use Cost Track Break-up to select a specific Cost Track and view its Tracking Details, Cost, Revenue, Nett Profit, and Item Movement. To analyse the expense or revenue further, press F5 to switch to the Ledger view and analyse the details Group-wise or Ledger-wise.
   
   
2. How can I identify open and closed cost tracks before closing cost tracking?
   Use Stock Item Cost Analysis and select Type of Cost Track to view Open Tracks and Close Tracks separately. For open tracks, use Cost Track Break-up to review the Item Movement, Cost, and Revenue, and identify tracks that still have inward or outward activity.