Type search words and press enter
Experience seamless e-Way Bill enhancements with TallyPrime 5.1. Auto-update distances, generate EWB for Material In/Out, validate State/PIN for exports, bulk convert B2B to B2C, and control GST updates effortlessly. Download TallyPrime 5.1 now!
https://help.tallysolutions.com/docs/te9rel66/Advanced_Features/Advanced_Inventory_Features/Item_Cost_Analysis_Reports.htm

Item Cost Analysis Report

You can track the overall profitability or cost of the stock item without affecting stock values during  the entire process.

The Item Cost Analysis Reports helps the user in tracking the overall profitability or cost for the Stock Item, without affecting the stock values during the entire process. I The Item Cost Analysis reports provide the detailed information as per Stock Group , Stock Item and Item Cost Track breakup via various transactions.

On this page

Stock Group Cost Analysis

Stock Item Cost Analysis

Item Cost Track Break-up

G o to Gateway of Tally > Display > Statements of Inventory > Item Cost Analysis .

Stock Group Cost Analysis

The Stock Group Cost Analysis report displays the cost tracking for the selected stock group of items. The report displays details of the cost, revenue, the  balance cost and profit/loss.

1. Select Stock Group from the Item Cost Analysis menu.

2. Select the required Stock Group .

The Stock Group Cost Analysis screen is displayed as shown below:

Note: By Default, the report displays the period till the date of last entry .

Cost Analysis Column Details

A. Cost (Expense) : This column displays the total cost incurred for the selected Stock Group, such as  Purchases, Expenses (Direct and Indirect) and Consumption Cost.

B. Revenue (Income) : This column displays the total revenue earned for the selected Stock Group, such as Sales, Incomes (Direct and Indirect).

C. Balance at Cost : This column displays the balance cost (closing stock) available for the selected Stock Group (A - B)

Profit/Loss (B-(A-C)) : This column displays Profit earned or Loss incurred for the selected Stock Group.

1. Click F1 : Detailed .

The Stock Group Analysis report in detailed mode appears as shown below:

2. Click F12: Configure and change the default settings as required.

The Stock Group Analysis report in detailed format with stock groups, sub-groups/stock items, and cost tracking numbers appears as shown below:

Stock Item Cost Analysis

1. Select Stock Item from the Item Cost Analysis menu.

2. Select the required Stock Item

The Stock tem Cost Analysis report appears  as shown below:

3. Select the required Cost Tracking Number and press Enter to drill down to Item Cost Track Break-up .

4. Click F12: Configure to change the default settings.

Note: This report can be viewed from Stock Group Cost Analysis through drill down or by viewing the report Item-wise (F5) .

Item Cost Track Breakup

The Item Cost Track Break-up report displays the details of Tracking , Cost , Revenue , Balance at Cost , Net Profit/Loss for the selected Item Cost Track (Cost Tracking Number). It also displays the 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 .

This report can also be viewed from Stock Group/Item Cost Analysis through drill down.

1. Click Cost Track Break-up from the Item Cost Analysis menu.

2. Select the required Item Cost Tracking Number from the Name of Item Cost Track , as shown below:

The Item Cost Track Breakup report of the selected Cost Track (E.g.CT-01-CPUi5) appears as shown:

Ctrl+C: Close Cost Track

This button allows the user to Close/Open the Cost Track. The user may operate this button from Stock Group and Stock Item Cost Analysis report screens.

Close Cost Track

1. Go to Gateway of Tally > Display > Statements of Inventory > Item Cost Analysis > Stock Group.

2. Select the required Stock Group . The Stock Item Cost Analysis report appears.

3. Press Ctrl+C to Close Cost Track . The Cost Track Closure Details screen appears.

4. Press Spacebar and select the required rows.

5. Press Ctrl+A to close the selected tracks.

6. Click F5: Show All to list all the cost tracked items.

Note: The button Ctrl+A: Open/Close Track will be active only on selecting one or more rows.