Job Work Challan Register and ITC-04 Worksheet
When a manufacturer sends material to job workers such as heat treaters, platers or tool rooms, GST expects the principal to track the goods and report movements in Form ITC-04. This worksheet keeps the register in one place, shows balance quantity and flags lines that have crossed the allowed time.
| Challan no | Job worker | Item | Goods type | Qty sent | Qty received back | Balance at job worker | Days since sent | Allowed days | Overdue balance qty | Unit value | Value of overdue balance | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
400 | 0 | Rs 0 | ||||||||||
400 | 400 | Rs 58,000 | ||||||||||
2 | 0 | Rs 0 | ||||||||||
0 | 0 | Rs 0 |
Edit the days since sent column from your challan dates. Time limits shown follow the usual one year for inputs and three years for capital goods under section 143 of the CGST Act; confirm the current rule with your adviser. This is a working sheet for ITC-04 preparation, not a filed return.
Link job work to ERP stock
Optional: a review of how job work issues and receipts are recorded and how to age open balances automatically.
Optional. The tool and every export work without this. No spam.
How to use the register
Add one row per challan and item. Enter quantity sent, quantity received back and the days since the challan date. Set the allowed days to 365 for inputs and 1095 for capital goods. The worksheet calculates the balance still with the job worker, the overdue quantity and the value of the overdue balance. Export to Excel before each quarter end and use it to prepare ITC-04 entries.
- Update received quantity at every goods receipt
- Review rows with more than 300 days out every month
- Keep scrap and waste returned by the job worker in notes
What section 143 and ITC-04 require
Section 143 of the CGST Act lets a principal send inputs or capital goods to a job worker without paying tax, provided they come back within one year for inputs or three years for capital goods, or are supplied from the job worker place. Otherwise the movement is treated as a supply on the date of sending. ITC-04 reports the challans issued and goods received back, and is filed on the frequency applicable to your turnover.
Common mistakes
Common mistakes include losing track of partial returns, counting scrap as a return, using different item names in the challan and in the stock ledger, and forgetting that the clock runs from the date of the challan. Another is leaving the register with the stores team only, while finance needs it for return filing. Agree one owner and a monthly reconciliation to the job worker ledger in your accounting software.
Frequently Asked Questions
Is this the ITC-04 form?
No. It is a working register that gives you the data to fill ITC-04 on the GST portal. The statutory form has its own table structure and must be filed on the portal.
What happens if goods are not returned in time?
The movement can be treated as a supply by the principal on the date the goods were sent, with tax and interest liability. Confirm treatment and any relief with your GST practitioner.
Does this work with Tally?
You can mirror your Tally job work in and out vouchers into this sheet. It does not import or write to Tally. Use it to cross-check the job work register your accounting package produces.
Can I track value as well as quantity?
Yes. Enter a unit value per line and the sheet computes the value of overdue balance. Use a consistent basis such as cost or taxable value, and state it in your notes.
If job work movements live in spreadsheets, we can look at pulling issues and receipts directly from your ERP stock transactions.
Related Tools
Delivery Challan Format Template for Goods Movement in India
Fill in a delivery challan for goods moving without a tax invoice: job work, samples, sale on approval or line sales.
Country & TaxGSTR-2B ITC Reconciliation Worksheet (Books vs Portal)
A line-by-line reconciliation sheet that compares ITC booked in your accounts with ITC shown in GSTR-2B and shows the difference.
Country & TaxGST Tax Invoice Format Template for Indian Manufacturers
A fill-in GST tax invoice with the mandatory fields for a manufacturer: GSTIN, HSN, place of supply, taxable value and CGST/SGST/IGST lines.
Country & TaxPurchase Order Format Template for Indian Manufacturers
A purchase order format with GSTIN, HSN, delivery schedule, payment terms and an MSME payment clause, ready to export.
More Country & Tax tools
See all- TDS Deduction Tracker Worksheet for Vendor Payments
- MSME Vendor Payment Due Date Tracker (45 Day Rule)
- GST Inclusive and Exclusive Price Calculator
- GST Bill of Supply Format Template India
- GST Export Invoice Under LUT Template India
- GST Reverse Charge Self Invoice and Payment Voucher Template
- GST Show Cause Notice Reply Template (DRC-06 Style)
- GST Rule 37 180-Day ITC Reversal and Interest Worksheet
- GST E-Invoice IRN Tracking Log Worksheet