Stock Ageing Analysis for Job Work Out in TallyPrime: 2 Easy Steps

You can effectively analyze the age of materials sent to job workers by combining different reports and applying some manual calculations.

Table of Contents

1. Steps to Perform Stock Ageing Analysis for Job Work Out:

1. Create a Stock Group:

Group all raw materials or components sent for job work under a specific stock group named “Job Work Out Materials” or something similar.

2. Run Ageing Analysis Report:

Go to Gateway of Tally > Display More Reports > Statements of Accounts > Outstandings > Group.
Select the created stock group “Job Work Out Materials”.
Press F6 (Ageing Method) and choose the desired ageing method (e.g., Bill Date, Due Date).
Set the required ageing periods (e.g., 0-30 days, 31-60 days, etc.).

3. Analyze the Report:

The report will display the quantity and value of stock items within the specified ageing periods.
Focus on the items that have been with the job worker for a longer duration.

2. Limitations and Considerations:

This method provides an overall picture of the stock age but doesn’t directly link it to specific job work orders.
The report doesn’t differentiate between materials sent to different job workers.

3. Additional Tips for Stock Ageing Analysis for Job Work Out in TallyPrime:

1. Create a Custom Report:

If your TallyPrime version allows, you can create a custom report to include additional details like job worker name and job work order number.

2. Manual Reconciliation:

Manually correlate the ageing analysis results with Job Work Out Orders for a more accurate picture.

3. Regular Review:

Regularly review the ageing analysis to identify slow-moving or obsolete items.

4. Example: Job Work Materials

You have a stock group named “Job Work Materials” containing fabric, buttons, zippers, etc.

You run the Ageing Analysis report for this group. The report shows a significant quantity of buttons has been in stock for more than 90 days.

This might indicate an issue with job work orders consuming buttons or potential overstocking.

By combining the Ageing Analysis report with manual analysis and potentially custom reports, you can gain valuable insights into the age of materials sent for job work, helping you identify potential issues, optimize inventory management, and improve overall job work efficiency.