Stock With Job Worker Report in TallyPrime: 5 Easy Steps

Unfortunately, TallyPrime doesn’t have a dedicated report titled “Stock With Job Worker.”

However, you can effectively track stock with job workers using a combination of reports and manual calculations.

Table of Contents

1. Tracking Stock with Job Worker

Here’s a step-by-step approach to monitor stock with job workers:

1. Material Out (FG) Register:

This report shows the raw materials or components sent to the job worker.
Analyze this report to identify the quantity and value of materials dispatched to each job worker.

2. Job Work Out Orders Summary:

This report provides an overview of outstanding Job Work Out Orders (JWOOs), including the expected quantity of finished goods.
Compare the expected finished goods quantity with the materials sent to estimate the stock value with the job worker.

3. Manual Calculation:

Calculate the estimated value of stock with the job worker by subtracting the value of finished goods received from the value of materials sent.

2. Example: Stock With Job Worker Report in TallyPrime

You sent 100 meters of fabric worth Rs. 5,000 to a tailor for stitching shirts.

The expected output is 50 shirts.

Material Out (FG) Register: Shows fabric worth Rs. 5,000 sent to the tailor.
Job Work Out Orders Summary: Shows an outstanding order for 50 shirts.

Estimated Stock with Tailor: Rs. 5,000 (value of fabric)

Note: This is an estimated value as it doesn’t consider factors like processing charges or any additional materials provided by the job worker.

3. Additional Considerations:

1. Job Work In Process (WIP):

If your job work process involves multiple stages or long processing times, consider tracking WIP to get a more accurate picture of stock with the job worker.

2. Stock Valuation Method:

The valuation method used for inventory (FIFO, LIFO, Weighted Average) will impact the calculated value of stock with the job worker.

3. Regular Reconciliation:

Periodically reconcile the estimated stock value with the job worker to ensure accuracy.

4. Limitations:

TallyPrime doesn’t provide a direct report for stock with job workers.
Manual calculations and reconciliations are necessary for accurate tracking.

5. Workarounds:

Consider using custom reports or third-party tools if available for more detailed tracking.
Implement a spreadsheet-based tracking system to supplement TallyPrime data.

By combining the information from different reports and manual calculations, you can effectively monitor the stock with job workers in TallyPrime.