Receipt Variance Report (Job Work Out) in TallyPrime: 6 Steps

TallyPrime doesn’t have a dedicated “Receipt Variance Report” for Job Work Out specifically.

However, you can effectively analyze receipt variances by combining information from different reports and performing manual calculations.

Table of Contents

1. Steps to Analyze Receipt Variance in TallyPrime:

1. Job Work Out Orders Summary Report:

This report provides details of the expected finished goods as per the Job Work Out Order (JWOO).

2. Material In (FG) Register:

This report provides details of finished goods received from the job worker.

2. Analyzing the Variance in TallyPrime:

1. Compare Expected and Received Quantities:

Compare the “Ordered Qty” from the Job Work Out Orders Summary with the “Quantity Received from Job Worker” in the Material In (FG) Register for each finished good.
Calculate the difference between the two to determine the quantity variance.

2. Calculate Variance Percentage:

Calculate the percentage variance by dividing the quantity variance by the ordered quantity and multiplying by 100.

3. Example: Job Work Out Order for 100 shirts

A Job Work Out Order for 100 shirts was placed.
The Material In (FG) Register shows 95 shirts received.

1. Variance Analysis in TallyPrime:

Expected quantity: 100 shirts
Received quantity: 95 shirts
Quantity variance: 5 shirts (shortage)
Percentage variance: (5/100) * 100 = 5% shortage

4. Additional Considerations:

1. Scrap and By-products:

If the job work involves scrap or by-products, consider their impact on the final output when analyzing the variance.

2. Job Work Charges:

Analyze the job work charges in relation to the received quantity to assess cost efficiency.

3. Custom Reports:

While TallyPrime doesn’t offer a dedicated report, you might consider creating a custom report or using a spreadsheet for detailed variance analysis.

5. Limitations of Receipt Variance Report (Job Work Out) in TallyPrime:

TallyPrime doesn’t provide a direct comparison of expected and received quantities for finished goods.
Manual calculations and analysis are required to determine the variance.

6. Workarounds of Receipt Variance Report in TallyPrime:

Export the data from the Job Work Out Orders Summary and Material In (FG) Register to a spreadsheet for easier analysis.
Create a custom report or use a third-party tool for more advanced variance analysis.

By combining the information from different reports and performing manual calculations, you can effectively analyze receipt variances for your job work orders in TallyPrime.