Table of Contents

 

 PDF

Record Job Work In Orders in TallyPrime – Job Worker

Once you set up TallyPrime for Job Work Orders, as a job worker, you can record:

TallyPrime also provides you with a wide range of job work order reports to stay informed about job work in TallyPrime.

Record Job Work In Order

In TallyPrime, you can record Job Work In Order for:

Record Job Work In Order for Stock Items without BoM

  1. Press Alt+G (Go To) > Create Voucher > press F10 (Other Vouchers) > type or select Job Work In Order and press Enter.
    Alternatively, Gateway of Tally > Vouchers > press F10 (Other Vouchers) > type or select Job Work In Order and press Enter.
  2. Party A/c name: Select the ledger created for the Principal Manufacturer, and press Enter.
    The Dispatch Details screen appears.
  3. Provide the dispatch details.
    1. Dispatched through: Enter the mode of transportation or the type of vehicle. For instance, truck.
    2. Destination: Enter the address of the job worker.
    3. Carrier Name/Agent: Enter the name of the carrier or the logistic agency through which the raw materials are to be sent to the job worker.
    4. Bill of Lading/LR-RR No.: Enter the Bill of Lading/LR-RR No.
    5. Date: Enter the date of dispatch.
    6. Motor Vehicle No.: Enter the registration number of the vehicle through which the raw materials are to be sent to the job worker.
    7. Mode/Terms of Payment: Enter the mode of payment. For example, cheque or cash.
    8. Duration of Process: Enter the duration (number of days or weeks) required to complete the job work.
    9. Nature of Processing: Enter the nature of work to be done on the raw materials. 
      For instance, when you send rods for painting, the nature of processing is application of paint on the rod.
      Dispatch Details while Recording Job Work In Order in TallyPrime
    10. Press Ctrl+A to save the dispatch details.
      The Party Details screen appears.
  4. Provide the party details, or validate the details provided in the party ledger, and press Ctrl+A to save.
    Buyer Details while Recording Job Work In Order in TallyPrime
  5. Enter the Order No.
  6. Select the Stock Item.
    The Item Allocations screen appears.
  7. Specify the Item Allocations.
    1. Track ComponentsNo, for an item without Bill of Materials. 
    2. Due on: Enter the date of completion of the job work.
    3. Godown: Select the appropriate Godown.
    4. Quantity: Enter the quantity of the stock item.
    5. Enter the Rate, and the Amount gets calculated.
    6. Press Ctrl+A to save to save Item Allocations details.
  8. Enter other necessary details in the voucher, as needed.
    Job Work in Order in TallyPrime
  9. Press Ctrl+A to save the voucher.

Record Job Work In Order for Stock Items with BoM

You just need to follow the procedure to record Job Work Out Order for Stock Items without BoM with the following following changes.

  1. Press Alt+G (Go To) > Create Voucher > press F10 (Other Vouchers) > type or select Job Work Out Order and press Enter.
    Alternatively, Gateway of Tally > Vouchers > press F10 (Other Vouchers) > type or select Job Work Out Order and press Enter.
  2. Specify the Item Allocations.
    1. Track ComponentsYes, for an item with Bill of Materials. 
    2. Due on: Enter the date of completion of the job work.
    3. Godown: Select the appropriate Godown.
    4. Quantity: Enter the quantity of the stock item.
      The Component Allocations screen appears.
    5. Specify the Component Allocations.
      1. Specify the Component Allocations for the stock item or validate the same based on the Bill of Materials.
        To know how to specify Bill of Materials for a specific Stock Item, refer to the Create/Alter Stock Item – Finished Goods With Bill of Materials section in the Set Up TallyPrime for Job Work Orders topic.
        Component Allocations for Job Work In Voucher in TallyPrime
      2. Press Ctrl+A to save the Component Allocations details.
        The Item Allocations screen appears.
    6. Enter the Rate, and the Amount gets calculated.
      Item Allocations While Recording Job Work In Voucher in TallyPrime
    7. Press Ctrl+A to save the Item Allocations details.
  3. Enter other necessary details in the voucher, as needed.
    Job Work In Voucher in TallyPrime
  4. Press Ctrl+A to save the voucher.

For instances such as job work delivery failure and incomplete delivery, you can pre-close job work orders in TallyPrime.

You can view all the Job Work Out Orders in the Job Work In report. Moreover, you can also refer to Job Work In Orders Book to view all the vouchers recorded for job work in.

Account for Raw Material Received from Principal Manufacturer with Material In Voucher

    1. Press Alt+G (Go To) > Create Voucher > press F10 (Other Vouchers) > type or select Material In, and press Enter.
      Alternatively, Gateway of Tally > Vouchers > press F10 (Other Vouchers) > type or select Material In and press Enter.
    2. Party A/c name: Select the ledger created for the Principal Manufacturer and press Enter.
      The Order Details screen appears.
    3. Specify the order details.
      1. Order No(s): Select the job work out order(s) against which you are recording the Material Out voucher.
        As you enter the Order No., the other details get prefilled based on the details entered in the Job Worker In Order.
      2. Specify Other References and Terms of Delivery, if needed and applicable.
      3. Dispatch Doc No.: Enter the appropriate document number.
        Job Work Order Details while Recording in Material Voucher in TallyPrime
      4. Press Ctrl+A to save the Order Details.
        The Party Details screen appears.
    4. Provide the party details, or validate the details provided in the party ledger.
      Party Details while Recording Material In Voucher as a Job Worker in TallyPrime
      The Stock Items appear based on the Bill of Materials specified in the Stock Item master.
    5. Specify the Destination Godown.
    6. Press Enter on a stock item.
      The Item Allocations screen appears.
    7. In the Item Allocations for each stock item, specify the Godown and press Ctrl+A to save.
      Item Allocations for Material In Voucher in TallyPrime
    8. Enter other necessary details in the voucher, as needed.
      Material In Voucher in TallyPrime
    9. Press Ctrl+A to save the voucher.

Once you record the Material Out Voucher, you can view the entry in the Material Out Register and check the Stock from principal manufacturer.

Account for Manufacturing of Finished Goods to Keep Track of Raw Materials Consumed

  1. Press Alt+G (Go To) > Create Voucher > press Alt+F7 (Stock Journal).
    Alternatively, Gateway of Tally > Vouchers > press Alt+F7 (Stock Journal).
  2. Press Ctrl+H (Change Mode) and select Manufacturing Journal.
  3. Select the product, BOM and enter the quantity.
    1. Name of product: Select the product that is to be manufactured.
    2. Select the bill of material in the Name of BOM field.
      If there are multiple BOMs created for the product, then the BoM List will appear.
    3. Enter the quantity to be manufactured.
      The components used to manufacture the finished goods appear automatically.
      Since there are no Co-Products/By-Products/Scrap produced then the % of Cost allocation will be 100%.
  4. Under the Type of Additional Cost select the additional cost ledger, if any, and enter the Percentage.
    The total Cost of components and Type of Additional Cost incurred to manufacture the finished goods is displayed in the Effective Cost field.
    The per-piece cost of the primary item manufactured (finished item) is displayed in Effective rate of primary item field.
    The manufacturing journal appears as shown below:
    Manufacturing Journal for Job Worker in TallyPrime
  5. Enter Narration, if required. As always, press Ctrl+A to save the journal.

Once you record the Manufacturing Journal Voucher for the job work, you can refer to the Item Estimates report, which shows the total cost of the item including all the expenses.

Account for Finished Goods Delivered to Principal Manufacturer with Material Out Voucher

  1. Press Alt+G (Go To) > Create Voucher > press F10 (Other Vouchers) > type or select Material Out and press Enter.
    Alternatively, Gateway of Tally > Vouchers > press F10 (Other Vouchers) > type or select Material Out and press Enter.
  2. Party A/c name: Select the ledger created for the Principal Manufacturer and press Enter.
  3. The Order Details screen appears.
  4. Specify the order details.
    1. Order No(s): Select the job work out order(s) against which you are recording the Material Out voucher.
      As you enter the Order No., the other details get prefilled based on the details entered in the Job Worker In Order.
    2. Specify Other References and Terms of Delivery, if needed and applicable.
    3. Dispatch Doc No.: Enter the appropriate Dispatch Doc No.
      Order Details while Recording Material Out Voucher in TallyPrime
    4. Press Ctrl+A to save the Order Details.
      The Party Details screen appears.
  5. Provide the party details, or validate the details provided in the party ledger.
    Party Details while Recording Material Out Voucher in TallyPrime
    The Stock Items appear based on the Bill of Materials specified in the Stock Item master.
  6. Specify the Destination Godown.
  7. Press Enter on a stock item.
    The Item Allocations screen appears.
  8. Specify the Godown and press Ctrl+A to save.
    Item Allocations while Recording Material Out Voucher as a Job Worker in TallyPrime
  9. Enter other necessary details in the voucher, as needed.
    Material Out Voucher in TallyPrime
  10. Press Ctrl+A to save the voucher.

Once you record the Material Out voucher, you can view the entry in the Material Out Register report.

Record Sales of Job Work Service to a Principal Manufacturer

You need to ensure the following:

  • Record the sales invoice based on the finished goods delivered to the principal manufacturer.
  • For partial delivery of finished goods, record the sales invoice for the quantity delivered to the principal manufacturer.
  1. Press Alt+(Go To) > Create Voucher > press F8 (Sales).
    Alternatively, Gateway of Tally Vouchers > press F8 (Sales)..
  2. Specify the buyer details.
    1. Party A/c name: Select Cash or Bank for cash sales and the party name for credit sales and press Enter.
      The Dispatch Details screen appears.
    2. Dispatch Details: Enter the Dispatch Details, as needed and press Enter.
      You can choose to enable the option for Order Details by pressing F12 (Configure).
      The Party Details screen appears.
    3. Party Details: You can update the buyer details while recording the transaction and print the same in the invoice.
    4. As always, you can press Ctrl+A to save and proceed.
  3. Sales ledger: Select the common sales ledger.
  4. Provide the stock item details.
    1. Name of Item: Select the stock item.
    2. Specify Quantity and Rate.
      Sales Invoice for Job Work in TallyPrime
  5. Provide Narration, if needed, and press Ctrl+A to save the sales voucher.

Record Receipt of Payment from Principal Manufacturer

  1. Press Alt+G (Go To) Create Voucher > press F6 (Receipt).
    Alternatively, Gateway of Tally Vouchers > press F6 (Receipt).
  2. Account: Select the ledger.
  3. Particulars: Select the party ledger, and enter the corresponding amount.
    Receipt of Payment from a Principal Manufacturer Against Job Worker In Voucher in TallyPrime
  4. Press Ctrl+A to save the receipt voucher.

Job Work Order Reports

TallyPrime provides you with the following reports to refer to at various stages in the job work cycle:

Job Work In Orders

  1. Press Alt+G (Go To) > Create Voucher > press F10 (Other Vouchers) > type or select Job Work Out Order and press Enter.
    Alternatively, Gateway of Tally > Vouchers > press F10 (Other Vouchers) > type or select Job Work Out Order and press Enter.
    Job Work In Orders in TallyPrime
  2. Select a row and press Shift+Enter to view more information such as Narration and Stock Items.

You can configure the report, based on the values you want to view.

  • Press F12 (Configure).

You can also view the Columnar report.

  • Press F8 (Columnar) and then configure it to view values such as Voucher No., Quantity and Value for each Job Work Out Order recorded during the Period.

The Job Work In Orders report does not have any impact on the inventory or books of accounts and is meant only to gain the information on your Job Work Out Orders.

Job Order Summary

You can identify job work in orders for which you haven’t received the raw materials.

  1. Press Alt+G (Go To) > type or select Job Work Order Summary, and press Enter.
    Alternatively, Gateway of Tally > Display More Reports > Job Work Reports > Orders, and press Enter.
    You can view the Ordered Quantity and Balance Quantity and also identify if an order is completely or partially fulfilled for the job work.
    Job Orders Summary in TallyPrime
  2. Press F5 (Party-wise) to view the report based on vouchers recorded for job workers.
    Job Orders Summary in TallyPrime - Party-wise

Once you know the job orders that are on hold, you can communicate with your principal manufacturer about the balance quantity of raw materials.

Components Order Summary

The Components Order Summary report shows:

  • Quantity of components for which job work in orders are recorded.
  • Quantity of raw materials pending to be received from the principal manufacturer for the job work. 
    With the Balance quantity column, you can also identify the partial receipt of components.
  1. Press Alt+G (Go To) type or select  Job Work Components Order Summary and press Enter.
    Alternatively, Gateway of Tally > Display More ReportsJob Work Reports > Components and press Enter.
    Components Order Summary for Job Work In Orders in TallyPrime
  2. Press F5 (Party-wise) to view the report based on vouchers recorded for job workers.
    Components Order Summary in TallyPrime - Party-wise

You can also configure the Job Orders Summary and Component Orders Summary reports, based on the values you want to view.

  1. Press F12 (Configure).
  2. Show Outstanding Job Orders: This option enables you to view the job work in orders that are not cleared yet.
  3. Show Cleared Job Orders: This option enables you to view the job work in orders against which you have delivered the finished goods and are cleared.
    Components Order Summary in TallyPrime - Configuration

Knowing the outstanding and cleared job orders along with the balance quantity helps you take actions on clearing the job work in orders, as per the need.

Job Work In Orders Book

When a principal manufacturer assign a job work to you, you record a Job Work In Order. Job Work In Orders Book essentially displays all the Job Work In Orders recorded in a specific month or any period. You just need to drill down from a specific month, and you get to know all the Job Work In Orders. Moreover, you have an option to view a Columnar report and configure it to view details such as Quantity and Value of stock item, as needed.

  • Press Alt+G (Go To) > type or select  > Job Work Out Orders Book and press Enter.
    Alternatively, Gateway of Tally > Display More ReportsJob Work Reports > Job Work Out Orders Book and press Enter.
    Job Work In Orders Book in TallyPrime

You can configure the report, based on the values you want to view.

  • Press F12 (Configure).

You can also view Columnar report.

  • Press F8 (Columnar) and then configure it to view values such as Voucher No., Quantity and Value for each Job Work Out Order recorded during the Period.

With all the essential information such as Voucher No. and Order No., the Job Work In Orders Book is a go-to report to refer to all the Job Work In Orders recorded during a specific period.

Material In Register displaying the raw material received from the principal manufacturer

  1. Press Alt+G (Go To) > type or select  > Material In Register and press Enter.
    Alternatively, Gateway of Tally > Display More ReportsJob Work Reports > Material In Register and press Enter.
  2. Drill down from the required month.
    For example, March.
    Material In Register for Job Worker in TallyPrime
  3. Select a row and press Shift+Enter to view more information.
    Material In Register with Exploded Row in TallyPrime

You can also view Columnar and Extract reports:

  • Press F8 (Columnar) and then configure it to view values such as Voucher No., Quantity and Value for each Job Work Out Order recorded during the Period.
  • Press Alt+F8 (Extract), if you want to view the Inwards and Outwards Quantity.

Based on the quantity of raw materials availed from the principal manufacturer, you can plan to manufacture the finished goods, and address discrepancies in the quantity received, if any.

Material Out Register displaying finished goods delivered to the principal manufacturer

  1. Press Alt+G (Go To) > type or select  > Material Out Register and press Enter.
    Alternatively, Gateway of Tally > Display More ReportsJob Work Reports > Material Out Register and press Enter.
  2. Drill down from the required month.
    For example, March.
    Material Out Register in TallyPrime
  3. Select a row and press Shift+Enter to view more information.
    Material Out Register with Exploded Row in TallyPrime

You can configure the report, based on the values you want to view.

  • Press F12 (Configure).

You can also view Columnar and Extract reports:

  • Press F8 (Columnar) and then configure it to view values such as Voucher No., Quantity and Value for each Job Work Out Order recorded during the Period.
  • Press Alt+F8 (Extract), if you want to view the Inwards and Outwards Quantity.

Based on the quantity of finished goods delivered to the principal manufacturer, you can create the sales invoice.

Material Movement Register

  • Press Alt+G (Go To) > type or select  > Material Movement Register and press Enter.
    Alternatively, Gateway of Tally > Display More Reports Job Work Reports > Material Movement Register and press Enter.
    Material Movement Register in TallyPrime

You get a holistic view of the job work in order with details such as Delivery Challan NumberDate of DispatchDescription of Goods DispatchedQuantity Dispatched to Job Worker and others related to the Job Worker Out Orders.

Column Description of Material Movement Register

The following table describes the entities in the columns of Material Movement Register:

Column Title Meaning
Order Number Job Work In Order Number.
Date of Receipt The date on which the components were received form the Principal manufacturer.
Customers Delivery Challan The voucher number of the material In voucher through which the components for Job work was received.
Description of Goods Received The description of the components received.
Quantity Received The quantity of components received towards a Job Work In Order.

Process Loss

The loss of stock during manufacture of Finished goods.

Nature of Process Required

The Natures of Processing instructed by the Manufacturer.

Quantity Processed Goods Returned

The details of stock (Finished Goods/Scrap/By-Products/Co-Products) manufactured.

Quantity Issued

The Quantity of goods manufactured and delivered to the principal Manufacturer.

Wastage Scrap at end of Job Work

The quantity of Wastage or Scrap produced during the manufacture of Finished goods.

Job Worker’s Challan No. & Date

The Job workers challan number and Date. These details will be captured from the Material out voucher recorded to deliver the goods to the manufacturer.

Remarks

To enter the information of closure of stock.

Stock from Party displaying the raw materials received from the principal manufacturer

  • Press Alt+G (Go To) > type or select  Stock From Party and press Enter.
    Alternatively, Gateway of Tally > Display More ReportsJob Work Reports > From Party and press Enter.
    Stock from Party in TallyPrime

When you know the total quantity of raw materials available with you, you can plan the process of manufacturing the finished product accordingly.

Receipt Variance

When you receive raw materials from a principal manufacturer, you deliver finished goods accordingly. However, the quantity of raw materials received might differ. Receipt Variance Analysis helps identify these discrepancies.

The table below explains the concept of Variance Quantity in the Receipt Variance Analysis report.

Sl No. Variance Quantity Description
1

0

The raw materials received are exactly as per the finished goods expected by the principal manufacturer.
2

Negative

The raw materials received are lesser than that expected as per the finished goods delivered to the principal manufacturer.
3 Positive

The raw materials received are greater than that expected as per the finished goods delivered to the principal manufacturer.

  1. Press Alt+G (Go To) > type or select  > Receipt Variance Analysis and press Enter.
    Alternatively, Gateway of Tally > Display More ReportsJob Work Reports > Receipt Variance and press Enter.
  2. Select a row and press Shift+Enter to view more information.

You can further configure the report:

  • Press F5 (Party-wise) to view vouchers recorded for job workers.
  • Press Ctrl+B (Basis of Value) and set Show Goods delivered but orders not raised as Yes.
    You can know if there are goods delivered but orders not raised.

Once you know the variance in quantity received from the principal manufacturer, you can take actions to avail the necessary raw materials or adjust your sales invoice accordingly.

Issue Variance

When you receive raw materials from a principal manufacturer, you are expected to deliver finished goods accordingly. However, the quantity of finished goods delivered might differ. Issue Variance Analysis helps identify these discrepancies. 

The table below explains the concept of Variance Quantity in the Issue Variance Analysis report.

Sl No. Variance Quantity Description
1

0

The finished goods received are exactly as per the raw material received from the principal manufacturer.
2

Negative

The finished goods delivered are greater than that expected as per the raw material received from the principal manufacturer.
3 Positive

The finished goods delivered are lesser than that expected as per the raw material received from the principal manufacturer.

  1. Press Alt+G (Go To) > type or select  > Issue Variance Analysis and press Enter.
    Alternatively, Gateway of Tally > Display More ReportsJob Work Reports > Issue Variance and press Enter.
  2. Press F8 (Job Work Out).
  3. Select a row and press Shift+Enter to view more information.
    Issue Variance for Job Worker in TallyPrime

You can further configure the report:

  • Press F5 (Party-wise) to view vouchers recorded for job workers.
  • Press Ctrl+B (Basis of Value) and set Show Goods delivered but orders not raised as Yes.
    You can know if there are goods delivered but orders not raised.

Once you know the variance in quantity issued to you, you can communicate with your principal manufacturer to avail the raw materials or make adjustments in your sales invoice accordingly.

Stock Ageing Analysis

The information about the age of the stock helps you plan the usage of raw materials, based on first in and first out (FIFO) or any other business practices that you follow.

  1. Press Alt+G (Go To) > type or select  > Stock Ageing Analysis and press Enter.
    Alternatively, Gateway of Tally > Display More ReportsJob Work Reports > Ageing Analysis and press Enter.
  2. Change the Ageing Period.
    1. Press F6 (Ageing Period).
    2. Alter the ageing period, as needed.
      Stock Ageing Analysis - Altering Ageing in TallyPrime
    3. Press Ctrl+A to save.
      Stock Ageing Analysis in TallyPrime
TallyHelpwhatsAppbanner
Is this information useful?
YesNo
Helpful?