Job Work Reports in Tally

Job Work Reports show the various reports of Job Work In Orders, Materials In  & Materials  Out Vouchers, Outstanding Items to be received and delivered against Job Work Order Stock Lying with Jobber.

Job Work Reports in Tally

Having entered voucher data relating to Job Work In (by Principal) or Job Work Out (by Jobber), you may get various reports related to Job Work. At GoT>Display>Statement of Inventory :

Job Work In Reports Menu in Tally

Select Job Work In Reports to get Job Work In report Menu

Job Work In Reports Menu in Tally

Job Work Out Reports Menu in Tally

 Select Job Work Out Reports to get Job Work Out Report Menu

Job Work Out Reports Menu in Tally

Job Work Order Outstanding Reports in Tally

Order Outstanding Menu contains following Reports relating to Outstanding Job Orders :

Job Work In Order Outstanding Report Menu in Tally

At Job Work In Reports Menu, select Order Outstanding to get Job Work In Order Outstanding Report Menu

Job Work In Order Outstanding Reports Menu in Tally

Job Work Out Order Outstanding Reports Menu in Tally

At Job Work Out Reports Menu, select Order Outstanding to get Job Work Out Order Outstanding Report Menu

Job Work In Order Outstanding Reports Menu in Tally

Job Work Order Outstanding Summary Display in Tally

The following Reports show the list of Outstanding Job Orders.

Job Work In Order Outstanding Summary in Tally

At Job Work In Orders Outstanding Reports Menu, select Order  to get Job Order In Summary Report. Job Order In Summary report displays Summary of all  Outstanding Job work In orders (Job Order In raised on Principal Manufacturer towards which the raw materials are pending to receive from Principals & Finished Materials to be issued to Principals).

Job Work Order In Outstanding Summary Display in Tally

Job Work Out Order Outstanding Summary in Tally

At Job Work Out Orders Outstanding Reports Menu, select Order  to get Job Order Out Outstanding Summary Report . Job Order Out Summary report displays Summary of all  Outstanding Job work Out orders (Job Order Out raised on Job Workers towards which the raw materials are pending for Issue to Jobbers and Finished Materials to be received from Jobbers).

Job Work Order Out Outstanding Summary display in Tally

Report Contents : Job Order Outstanding Summary Reports display the summary of all the Job work orders which are outstanding. The contents and format of both the Job Order Outstanding Summary reports referred above are similar, as described below :

  • Stock Item : At Particulars, the Stock Item Name is displayed
  • Order Quantity : At Ordered Quantity, the Order Quantity is shown
  • Balance Quantity : At Balance Quantity, the Order Balance Quantity as on the Report end date (by default, the Current Balance Quality as) is shown

Job Work Order Out Outstanding Summary Configuration in Tally

AtJob Order Outstanding Summary Reports, click F12:Configure to get Job Order Outstanding Summary Configuration screen, to set the Configuration Options as follows

  • Outstanding Orders : At Show Outstanding Orders, set:
  • Yes to show only Balance Outstanding Order details
  • No. to show Order & Balance Outstanding Order details
  • Cleared Orders : At Show Cleared Orders, set:
  • Yes to show the details of Cleared Order  (orders which have been fully executed and here is no Balance are also shown)
  • No. to show Outstanding Orders only (orders which have been fully executed and here is no Balance are NOT shown)

Job Work Order Out Outstanding Summary Configuration in Tally

Job Work Order Out Outstanding Summary Buttons in Tally

AtJob Order Outstanding Summary Reports, you get following buttons:

  • F1:Detailed / Condensed : Click F1: Detailed toggle button to get the Report in Detailed Format (complete details with Due / Overdue Days)
  • F5:Partywise  / Itemwise : Click F5:partywise  / Itemwise toggle button to get the Report in Partywise / Item wise sequence (default)
  • C:Components : Click C:Components button to get Components Order Summary

Job Work Order Out Outstanding Summary Button Bar in Tally

Job Work Components Outstanding Summary in Tally

 The Reports display the Components Outstanding (for issue) for Job Orders raised.

Job Work Order In Components Outstanding Summary in Tally

At Job Work In Orders Outstanding Reports Menu , select Componentsto get Job Work Order In Components  Summary Report . This Report displays Summary of all Components of Job Work Order In (Components pending to receive from Principals).

Job Work Order In Components Outstanding Summary display in Tally

Job Work Components Out Outstanding Summary in Tally

 At Job Work Out Orders Outstanding Reports Menu, select Components  to get Job Work Order Out Outstanding Summary Report . This Report displays Summary of all Components of Job work Out orders (Components pending for Issue to Jobbers).

You may also get the Components Report when you Click C:Components button at Job Order Outstanding Summary Reports.

Job Work Out Components Summary Display in Tally

Job Work Order Components Summary Configuration in Tally

At Components Order Summary, click F12:Configure to get Components Configuration screen, similar to Outstanding Summary Reports Configuration, to set  the Configuration options

Job Work Order Components Summary Buttons in Tally

At Components Order Summary, you get Buttons, similar to Outstanding Summary Reports Buttons.

Job Work Registers in Tally

These Reposts show the details of Job Work Orders, Materials In & Out against the Job Work and Materials Movement.

Job Work In Registers Menu in Tally

At Job Work In Reports Menu, select Job Work Register to get Job Works In Registers menu, containing various reports of Job Work In Registers.

Job Work In Register Menu in Tally

Job Work Out Registers Menu in Tally

At  Job Work Out Reports Menu , select Job Work Register to get Job Works Out Registers menu, containing various reports of Job Work Out Registers.

Job Work Out Register Menu in Tally

Job Work Order Books in tally

These Reports gives lists of Job Work Orders.

Job Work In Orders Book in Tally

At Job Woks In Registers Menu, select Job Work In Order Book to get  Job Work In Orders Book Display screen .

Job Work In Order Book in Tallya

Job Work Out Orders Book in Tally

At Job Woks Out Registers Menu , select Job Work Out Orders Book  to get to get  Job Work Out Order Book Display screen .

Job Work Out Order Book in Tally

Job Work Order Books Configuration in Tally

At Job Work In Orders Book / Job Work Out Orders Book , click F12:Configure to get Job Work Order Books Configuration screen , similar to Registers Configuration screen, described earlier.

Job Work Order Books Buttons in Tally

At Job Work In Orders Book / Job Work Out Orders Book, you get Buttons similar to Registers, described earlier.

Job Work Materials Out Registers in Tally

These Reports show lists of Materials Out Vouchers for transfer of Consumption stock to Jobbers and the Finished goods transferred to the Principal Manufacturer

Job Work In Materials Out Register in Tally

At Job Woks In Registers Menu , select Materials In Register  to get  Materials Out Registers (for Job Work In) Display screen .

Job Work In Material Out Register in Tally

Job Work Out Materials Out Register in Tally

 At Job Woks Out Registers Menu , select Materials Out Registers to get to get  Materials Out Registers (for Job Work Out) Display screen .

Job Work Out Material Out Register in Tally

Job Work Materials In Registers in Tally

These Report show lists of Materials In Vouchers, for receipt of Raw Materials/Components from the Principal / Manufacturer.

Job Work In Materials In Register in Tally

At Job Woks In Registers Menu, select Materials In Register  to get  Materials In Registers (for Job Work In) Display screen .

Job Work In – Material In  Register in Tally

Job Work Out Materials In Register in Tally

At Job Woks Out Registers Menu, select Materials In Registers to get to get  Materials In Registers (for Job Work Out) Display screen .

Job Work Out – Material In Register in Tally

Job Work Materials Registers Configuration in Tally

 At Job Work Materials Registers click F12:Configure to get  Materials Out Registers Configuration screen.

Job Work Material Register Configuration in Tally

Job Work Materials Registers Buttons

At Materials Registers  you get Buttons to select respective report related options

Material Register Buttons in Tally

Job Work Material Movement Registers  : These Reports show the details of Movement of Material (Raw Materials and Finished Goods) of  Orders.

  • Materials Movement Register for Job Work In : At Job Woks In Registers Menu , select Materials Movement Register  to get  Materials Movement Register (for Job Work In) Display screen .
  • Materials Movement Register for Job Work Out : At Job Woks Out Registers Menu , select Materials Movement Registers to get to get  Materials Movement Register (for Job Work Out) Display screen.

Job Work InMaterials Movement Register in Tally

Job Work Materials Movement Registers Contents

  • Order Number: Job Order numbertowards which the material movement (Out/In) Voucher is recorded.
  • Delivery Challan Number: Voucher number of the Material out voucher through which the materials are transferred against the Job Order.
  • Date of Dispatch: Date of materials movement voucher.
  • Description of Goods dispatched: Name of the stock items in the movement voucher
  • Quantity Dispatched to Job Worker: Quantity of each goods transferred
  • Name and Address of Job Worker: Jobworker Name on whom the order is raised.
  • Nature of Processing Required: Nature of Processing required, as entered in Party Details of Material In / Out voucher.
  • Goods Received from Job Worker: Finished Goods/Scrap/By-Products/Co- Products) received from the Job Worker
  • Quantity Received form Job Worker: This column displays the Quantity of Finished Goods received.
  • Job Worker’s Delivery Challan No. and Date: Job worker’s Delivery Challan Number and Date entered in the Material In Voucher.
  • Factory GRN/GRRNo. and Date: Shows the Voucher Number and Date of Material In / Out voucher.
  • Shortages if any: Shows the details of Shortages recorded in Voucher
  • Wastage/Scrap at the end of Job worker: Quantity of wastage and scrap produced during the manufacture of Finished Goods.
  • Duty Paid on Shortages/Scrap/Wastage: Displays the details of Excise Duty paid (on Excisable Goods, if any) on the Shortage/ scrap/Wastage
  • Remarks: Remark as the Job Order is closed.

Job Work Materials Stock Reports in Tally

These Reports show the Materials lying with Jobbers / Principals and the period since when the Stock is lying

Job Work In Materials Stock Reports Menu in Tally

At  Job Work In Reports Menu , select Stock to get Stock Against Materials In Menu  containing various reports of  Stock against Job In Orders

Job Work In Materials Stock Reports Menu in Tally

Job Work Out Materials Stock Reports Menu in Tally

At  Job Work Out Reports Menu, select Stock to get Stock Against Materials Out Menu containing various reports of  Stock against Job Out Orders

Job Work Out Materials Stock Reports Menu in Tally

The Job Work Out Materials Stock Reports Menu contain following Reports :

  • Job Work Party Stock Report in Tally : This Report displays the details of stock received from different Principal Manufacturer. At Stock (Job Work In) Menu , select From Party to get Stock From Party Report. It shows the details of stock received from different Principal Manufacturer.
  • Job Work Jobber Stock Report in Tally Stock: This Report displays the details of stock lying with different Jobbers. At Stock Against (Job Work Out) Menu , select With Job Worker to get Stock With Jobber Report

Job Work Jobber Stock Report in Tally

Configuration: At Stock From Party / Stock With Jobber Reports , click F12:Configure to get Configuration screen , to set the following Options :

  • Quantity : At Show Quantities, set Yes to show Quantity column, else set No (Quantity column is not shown)
  • Rate : At Show Rates, set Yes to show Rate column, else set No (Rate column is not shown)
  • Value : At Show Value, set Yes to show Value column, else set No (Value column is not shown)

You must set Yes at least one of the above options

Job Work Jobber Stock Report Configuration in Tally

Job Work Stock Report Configuration in Tally Buttons in Tally

At Job Work Stock Reports, you get following Buttons

  • F5:Paty Wise / Itemwise : To get the Stock Report in Partywise / Stock Itemwise sequence
  • F4:Group : To select Account Group (Sundry Debtor / Sundry Creditor). Th Parties under the selected Group will be listed (this option is available for when F5:Partywise option is selected)

Job Work Stock report Button Bar in Tally

Job Work Stock Report Age Analysis in Tally

These Reports show the Age of Stock (period of stock lying)

  • Job Work In Age Analysis : This Report shows the time period of each Stock Item of Principals lying with the Jobber. At At Stock (Job Work In) Menu, select Ageing Analysis to get Ageing Analysis of Stock Against Job Work In.
  • Job Work Out Ageing Analysis : This Report shows the time period of each Stock Item lying with Jobber. At At Stock (Job Work Out) Menu , select Ageing Analysis to get Ageing Analysis of Stock Against Job Work Out.

On selecting the option, select the Stock Group from the list of Stock Group (select All Items for all Stock Items). The Age Analysis Report for the Stock Items under the selected Stock Group will be displayed, as per Ageing period set.

Job Work Stock Report Age Analysis format in Tally

Job Work Age Analysis Stock Report Buttons in Tally

At Age Analysis Reports , you get following Buttons

  • F4:Group : To select Account Group (Sundry Debtor / Sundry Creditor). The Age Analysis Report for  Parties under the selected Group will be listed
  • F5:Paty Wise / Itemwise : To get the Stock Report in Partywise / Stock Itemwise sequence
  • F6: Ageing Periods : To set the Ageing Slabs as discussed earlier
  • A:Hide Amounts / Show Amounts : Toggle button to Hide / Show Amount columns

Job Work Stock Report Age Analysis format in Tally

Job Work Analysis Reports in Tally

Job Work In Analysis : At Job Work In Reports Menu , select Job Work Analysis  to get Job Work In Analysis  Menu

Job Work In Analysis Report Menu in Tally

Job Work Out Analysis : At Job Work Out Reports Menu, select Job Work Analysis to get Job Work Out Analysis Menu

Job Work Out Analysis Menu in Tally

Job Work Analysis  Issue Variance Reports Display in Tally

These Reports give details of issues and variance (in %) of Issue Quantity with Order Quantity :

  • Job Work In Issue Variance Analysis Report : At Job Work In Analysis  Menu , select Issue Variance to get Job Work In Issue Variance Report . This Report shows the Issues against Job Work In Orders, Ordered Quantity, Issue Quantity, Variance %, separately for Primary Items, Bye Products & Scrap
  • Job Work Out Issue Variance Analysis Report : At Job Work Out Analysis  Menu , select Issue Variance to get Job Work Out Issue Variance Report. This Report shows the Issues against Job Work Out Orders, Ordered Quantity, Issue Quantity, Variance %, separately for Primary Items, Bye Products & Scrap

Job Work Analysis Issue Variance Report Display format in Tally

Job Work Analysis Issue Variance Analysis Configuration in Tally

At Issue Variance Report , click F12:Configure to get Configuration , screen to set options as follows:

  • Deliveries without Orders : At Show Delivered but Orders not raised, set Yes to show Goods delivered which were not originally included in Order (extra items, replacement / substitute items issued). Set No, such issues (without Orders) are not listed.
  • Excess Variance : At Highlight Variance Greater than %, enter the higher limit of %, to highlight issues having higher Variance.

Job Work Analysis Issue Variance Report Display Configuration in Tally

Job Work Receipt Variance Analysis Display in Tally

These Reports give details of Receipts and variance (in %) of Receipts Quantity with Order Quantity :

  • Job Work In Receipt Variance Analysis Report : At Job Work In Analysis  Menu, select Receipt Variance to get Job Work In Receipt Variance Report . This Report shows the Receipts against Job Work In Orders, Ordered Quantity, Receipt Quantity, Variance %, separately for Primary Items, Bye Products & Scrap
  • Job Work Out Receipt Variance Analysis Report : At Job Work Out Analysis  Menu, select Receipt Variance to get Job Work Out Receipt Variance Report. This Report shows the Receipt against Job Work Out Orders, Ordered Quantity, Receipt Quantity, Variance %, separately for Primary Items, Bye Products & Scrap

Job Work Receipt Variance Analysis in Tally

Job Work Receipt Variance Analysis Configuration in Tally

At Receipt Variance Report, click F12:Configure to get Configuration screen to set options as follows:

  • Deliveries without Orders : At Show Received but Orders not raised, set Yes to show Goods delivered which were not originally included in Order (extra items, replacement / substitute items issued). Set No, such issues (without orders) are not listed.
  • Excess Variance : At Highlight Variance Greater than %, enter the higher limit of %, to highlight issues having higher Variance.

 Job Work Variance Analysis Buttons in Tally

 At Variance Analysis Reports, you get following buttons

  • F5:Party Wise / Item wise : To get the Stock Report in Party wise / Stock Item wise sequence

View PDF

Mastering Tally PRIME

Hand book for Training, Certification & Job

Mastering Tally PRIME, by Asok K Nadhani, published by BPB Publications (ISBN 978-93-5551-272-7) contains the Blog series on Tally Prime, with QR Code links to individual topic, Audio, Video links, of Tutorials and details about FREE Learning and Internship for Work from Home Jobs.

The Book is available at Book Stores, Amazon, Flip Cart and Publishers site

About the Author

Asok K Nadhani (AKN Profile in dvidya site), is author of more than 30 Books on Business Accounting Software. His Business Software consultancy firm INFOSOFT, provides consultancy services on implementation of Business Accounting System to Business Enterprises.

Internship & Work-From-Home Job

INFOSOFT trains Interns to provide support service to business organisations for Accounting System implementation, and  work-from-home Project work on Accounting Systems.

For any query, email to dvidyamail@gmail.com

Click here for Book Preview