Doing a reconciliation between two pieces of data is always a wearisome job, and also time consuming especially when we are attempting to reconcile Materials sent to Job work and received back as final product. Because we generally send many parts (Ie. Child Parts) in lots and receiving back Final product (Ie. Parent Parts) from the Job worker in pieces. Section 143(1)(a) of CGST Act, 2017, we must receive back the parts send to job worker within one year from the date of dispatch of goods, failing which which will be considered as supply. So it is very important to do the reconciliation on First IN First OUT basis to minimize tax payment. We have designed this excel utility to make this reconciliation very easy and accurate.

STEP 1.

We have to enter our Bill of Material (BOM) details in sheet name “BOM Master Data”. Where we to enter Child Part numbers and Parent Part Numbers and How many child part is required to produce one Parent Part

Automatic Jobwork Reconciliation Excel Utility

STEP 2.

We have to enter our Dispatch details in Sheet name “DISPATCH 541-542”.

STEP 3.

we have to enter our Receipt Details from Job worker in Sheet name “RECEIPT 101-102”.

STEP 4.

We have to enter Job worker details in Sheet name “DISPATCH 541-542” Line No.3, and Column P to Y

STEP 5.

Click the tab “Click here to do Reconciliation” in Sheet name “DISPATCH 541-542”.

STEP 6.

Click the tab “Click here to do ITC04” in Sheet name “DISPATCH 541-542”.

That’s all your reconciliation will be ready in Sheet Name “FINAL RECON” and ITC 04 will be ready in Sheet Name “ITC 04” and “ITC05A”

Author Bio

Qualification: Post Graduate
Company: CHETTINAD
Location: Chennai, Tamil Nadu, India
Member Since: 21 Feb 2020 | Total Posts: 1
Completed my Master Degree in Finance and accounts having experience in Finance in Indirect taxes more than 17 years. View Full Profile

Join Taxguru’s Network for Latest updates on Income Tax, GST, Company Law, Corporate Laws and other related subjects.

Join us on Whatsapp

taxguru on whatsapp GROUP LINK

Join us on Whatsapp

taxguru on whatsapp GROUP LINK

Join us on Whatsapp

taxguru on whatsapp GROUP LINK

Join us on Whatsapp

taxguru on whatsapp GROUP LINK

Join us on Whatsapp

taxguru on whatsapp GROUP LINK

Join us on Whatsapp

taxguru on whatsapp GROUP LINK

Join us on Whatsapp

taxguru on whatsapp GROUP LINK

Join us on Whatsapp

taxguru on whatsapp GROUP LINK

Join us on Whatsapp

taxguru on whatsapp GROUP LINK

Join us on Whatsapp

taxguru on whatsapp GROUP LINK

Join us on Telegram

taxguru on telegram GROUP LINK

Review us on Google

More Under Goods and Services Tax

Leave a Comment

Your email address will not be published. Required fields are marked *

Search Posts by Date

January 2023
M T W T F S S
 1
2345678
9101112131415
16171819202122
23242526272829
3031