Job work · 6 min read

How to track job work and prepare ITC-04 without Excel

A practical way to know what’s lying with every job worker, and why short quantity matters more than you think.

If you send parts out for plating, heat treatment, powder coating or machining, you already know the problem. Material goes out on a challan. Some of it comes back. Weeks later, someone tries to work out what’s still with the vendor, usually when ITC-04 is due.

Why job work leaks money

Most losses aren’t dramatic. They’re 150 pieces short on a lot of 5,000, a few kilos missing after heat treatment, or rejected parts that never get sent back. Each one is small. Across a year and several vendors, they add up to real money, and they also make your stock figures wrong.

The three numbers to track for every vendor

  1. Sent: quantity and weight on each challan, linked to the production order.
  2. Received: what actually came back, including partial receipts.
  3. Pending: the difference, and how many days it has been out.

If you only track these three, you’ll catch most problems the same week instead of at the end of the quarter.

Weight in, pieces out

Many processes are charged by weight but returned by count. Agree a loss allowance with each vendor and record both weight and count on every challan and receipt. Anything outside the allowance should be flagged immediately, not discussed at month end.

ITC-04 becomes a by-product

When every challan and receipt is recorded properly, the ITC-04 report is simply a summary of data you already have. The quarterly scramble disappears.

In Onexis, challans and receipts are matched automatically, short quantity is flagged against the vendor, and the ITC-04 report comes from the same records.

See it with one of your own parts

Send us one product or drawing. In 30 minutes we show it inside Onexis, from raw material to invoice.

Book a demo