The Item Cost Tracking can be established from transactions having Inventory Movements or have an intent to create inventory movement in future, for a specific item, such as Sales Order, Purchase Order, Job Orders, Sales, Purchase, Receipt Note, Delivery Note, etc.
Item Cost Tracking in Sales Order
Item Cost Tracking in Purchase Voucher
Item Cost Tracking in Manufacturing Journal
Item Cost Tracking in Payment Voucher
To track Item Cost in Sales Order,
Go to Gateway of Tally > Order Vouchers > F5: Sales Order
● The Order Voucher creation screen appears
● Party's A/c Name: Select the Customer from the List of Ledgers.
● Party Details: Provide the Buyer, Order and Despatch Details in the Party Details screen.
● Order No.: Type the Order No in the field provided.
● Sales A/c: Select the required Sales Ledger.
● Name of Item: Select the Stock Item (E.g. CPU-i-5)
● Item Allocation: Enter the Order Quantity, Rate and Amount.
● Due on: Enter the due date/ days of the order.
● Cost Tracking To: Select New Number from the List of Cost Tracking Numbers.
● Enter the Cost Tracking Number (E.g. CT-01-CPUi5).
● Similarly, specify the Due on Day/Date for next order and press Enter to return to Order Voucher Creation screen as shown:
● Similarly, select other required items and generate Cost Tracking numbers based on the requirement.
● Save the Voucher.
The List of Cost Tracking Numbers is updated as follows:
On tracking the cost to an Item, the information in the List of Cost Tracking Numbers is displayed as follows:
Name: Displays the New Cost Tracking number created.
Doc Type: Displays the Voucher Type from which the Cost Tracking was created.
Stock Name: Displays the Stock Item Name for which Cost Tracking is generated.
Party Name: Display the Name of the Party to whom the order is raised/received.
Qty: Displays the Quantity of the Stock Item for which Cost Tracking is generated.
Note: The user can track all the transactions involving Purchase, Sales, Expenses, Incomes and other consumption entries to the Cost Tracking Number (CT-01-CPUi5)generated in the Sales Order.
To track Item Cost to a Purchase Voucher,
Go to Gateway of Tally > Accounting Vouchers > F9: Purchase
● Supplier Invoice No. & Date: Enter the Supplier's invoice number and date.
● Party's A/c Name: Select the Supplier from the List of Ledgers.
● Party Details: Provide the Receipt, Order and Supplier's Details in the Party Details screen.
● Order No.: Type the Order No in the field provided.
● Purchase Ledger: Select the required Purchase Ledger.
● Name of Item: Select the Stock Item (E.g. 17" Monitor)
● Item Allocation: Enter the Quantity, Rate and Amount.
● Enter the Tracking No. and Order No. details, if any.
● Cost Tracking To: Select the appropriate Cost Tracking Number from the List of Cost Tracking Numbers, as shown:.
● Similarly, track the costing for other items selected.
● Save the Voucher
To track Item Cost to a Manufacturing Journal Voucher,
Go to Gateway of Tally > Inventory Vouchers > F7: Manufacturing Journal
● Select the Stock Item, enter the required Quantity.
● Under Cost Tracking select the appropriate Cost Tracking Number from the List of Cost Tracking Numbers, as shown:
● Complete the voucher and Save.
To track Item Cost to a Payment Voucher,
Go to Gateway of Tally > Accounting Vouchers > F5: Payment
Select Cash under Account.
Select the Expense Ledger (E.g. Assembling Charges) and enter the amount.
The Stock Item Cost Allocation screen appears with the List of Cost Tracking Numbers.
Select the appropriate Cost Tracking Number, as shown:
Complete the voucher and Save.
Note: Similarly track cost allocation in other vouchers such Sales, Receipts etc.