Delivery Challan Format in Excel and Word for Job Work (2024)

The supply of products or services requires the production of the tax invoice as per section 31 of the CGST Act, 2017. Yet, certain transactions are not treated as supplies even if they need transportation from one place to the next. In these cases, you need a delivery challan.

For Example:

  • Goods transported to one place and then returned to their origin once the work completes.
  • Sending items from one branch to another within the same state

What is a Delivery Challan?

It is a document used to transport products from one location to another. The transportation may or may not result in sales. Thisdelivery challanis sent along with the goods for delivery.

It contains:

  • Details of the item shipped
  • Quantity of the products delivered
  • Delivery Address
  • Buyer's Address

Delivery Challan Format in Excel and Word for Job Work (1)

Difference between Tax invoice and Delivery Challan

Tax Invoice

Delivery Challan

A Tax invoice indicates the value of a particular product.

A delivery challan usually does not include such value but sometimes may include product worth.

It is a legal proof of ownership of goods and services.

It presents that a customer has acknowledged the receipt of goods, however shows no legal ownership.

A document provided when a sale occurs

It is most commonly used to move items from one location to another while noting the products' description, condition, and amount, although it does not always end in a sale.

Displays the real worth of the commodities

It will not display the items' true worth. The delivery challan may include the value of the products indicated on the delivery challan, but it will not include the tax payable.

Delivery Challan Format

Delivery Challan Format in Excel and Word for Job Work (2)

The documents are all serially numbered and exceed sixteen characters. Every delivery challan format includes the following information:

  • The delivery challan's date and number.
  • If the consignor, who is an individual or party who brings goods for selling on behalf of another party, is registered, his or her name, address, and GSTIN.
  • If the consignee, the party to whom the goods are sold by the consignor is registered, include his or her name, address, and GSTIN or Unique Identity Number. Name, address, and point of supply if unregistered.
  • The item's HSN code.
  • Details of the goods
  • The number of products delivered (when the precise quantity to be delivered is known).
  • The supply's taxable value.
  • Where the transportation is for supply to the consignee, the GST tax rate and the amount should be broken down as CGST, SGST, IGST, and GST Cess.
  • The location of supply is important in the case of interstate transport of commodities.
  • Signature

When Do You Need ADelivery Challan?

Section 55(1) of the CGST Rules outlines instances when a supplier can issue a delivery challan rather than invoices. They are as follows:

  • When the number of items delivered is unknown: Consider the case of delivering liquid gas when the quantity of gas withdrawn from the supplier's location is unknown.
  • When products are transported for job work, the delivery challan is required in any of the following situations:
    • Principal sends goods to job worker
    • One job worker sends an item to another job worker
    • Job worker is returning goods to the principal
    • When products are transferred from a factory to a warehouse or from one warehouse to another before they are ready for supply

Other Cases For Issuing a Delivery Challan

Furthermore, there are cases where issuing a delivery challan for transported goods is acceptable. They are:

  • Transporting goods on an approval basis:
    • When an inter or intra-state product transportation occurs on a sale or return basis but is then withdrawn before the supply happens.
  • Transporting ‘works of art' to galleries:
    • Challan issued because art pieces are moved to galleries for exhibition and then returned.
  • Goods sent abroad for promotion or exhibition:
    • This is according to CBIC Circular No. 108/27/2019-GST dated July 18, 2019.
    • Items shipped outside India for display or promotional purposes are not considered a "supply" or "export.”
    • As a result, such transportation should be done using this delivery challan.
  • Goods delivered in multiple shipments
    • When goods are transferred using several means of shipping in partially or fully constructed state:
    • Before shipping the first consignment, the supplier must submit a comprehensive invoice.
    • For each succeeding consignment, the supplier must submit a delivery challan that includes the invoice reference.
    • Each consignment must be accompanied by copies of the appropriate delivery challan and invoice.
    • The original copy of the invoice must accompany the original copy of the delivery challan.
  • When producing tax invoice is impossible at the time of delivery of goods
    • If issuing a tax invoice during a sale or supply is impossible, the suppliers can produce a delivery challan for transporting the goods.
    • This is in accordance with Rule 55(4) of CGST and SGST Rules, 2017.
    • The supplier can give the tax invoice after the delivery of the products.
  • When an e-way bill is not necessary
    • In this case, suppliers issue a delivery challanif the e-way bill is not required.
    • In this case, the tax invoice or Bill of Supply are also not essential.
    • This is as per Rule 55A of the CGST Rules, which took effect on January 23, 2018.

Also Read:All About Tax Deducted At Source

Which Businesses NeedDelivery Challan?

We have discussed the many instances where suppliers require a delivery challan rather than a tax invoice. Businesses that need these delivery challansfor their operation are:

  • Trading businesses
  • Companies that have several warehouses where items are transported between warehouses.
  • Businesses supplying goods
  • Manufacturers
  • Wholesalers

What Are The Contents For TheGST Delivery Challan Format In Exceland Word Template?

There are five sections in the GST delivery challan format in excel:

  • Section 1: Header
  • A section containing information on the consignee.
  • A section containing Transport information
  • A section for Product Specifications.
  • A section for Signatures and remarks

Delivery Challan Format in Excel and Word for Job Work (3)

Section

Details

Header Section

The Header section will feature information such as:

  • Firm name
  • Address
  • Logo
  • GSTIN
  • Document heading “GST Delivery Challan” at the top

Consignee Details Section

In terms of transportation, the consignee is the person who receives the cargo.

This section will contain the consignee’s information such as:

  • Name
  • Address
  • GSTIN
  • Delivery Challan Number
  • Place of Supply (POS)
  • Issue date

Transport detail section

This section contains transport details such as:

  • Transportation mode(air/land/sea)
  • The name of the transport company
  • Number of the vehicle
  • Dispatch Date

Product Details

This section contains the details of the product, which are as follows:

  • Sr. No.: Serial Number
  • Description of the product’s colour, size, dimension, etc.
  • HSN/SAC Codes: Harmonized System Nomenclature code of Products or Services Accounting Code
  • Quantity of Goods
  • Units of the products, i.e. how many meters, bags, or pieces of items
  • Rate of the product
  • The total sale is the quantity of the products multiplied by their rate
  • Discount if available
  • The taxable value column is calculated automatically

Signature and Remarks Section

This section includes:

  • Challan total in words
  • Authorized signatory box
  • Notes
  • Business Greetings

Contents of the Delivery Challan Format in Word

The information in theDelivery Challan Format in Wordtemplate is similar to the excel format.The delivery challan comprises dispatch information while also ensuring an accurate transaction.

The document must contain the following information:

  • Serial number of a delivery challan
  • Date of dispatch
  • Order number of the purchase
  • HSN/SAC code
  • Information of the customer
  • Description of the products
  • Sales tax
  • Other charges
  • The total amount
  • After reviewing the document, it is essential to sign the document to complete the process.

Delivery Challan Format in Excel and Word for Job Work (4)

To go through the procedure, businesses can freely download the delivery challan in excel and word format. Since three copies are necessary, the supplier triplicates the document every time.

Goods sent for Job Work under GST

Principal – The GST taxpayer whose products are used during the job work process.

  • A GST-registered person may deliver raw materials, capital goods, or semi-finished items to a job worker to perform job work.
  • The individual who sends the materials for the work has the option of paying GST or not paying GST.

Also Read:Important Benefits of Registering for Composition Scheme under GST

Bringing back the processed goods in time

  • After the job work process is completed, the principal who provided the materials for the job work process may return the items to their location.
  • Additionally, they may supply these things straight to their ultimate consumer, including exports, from the job worker's location.
  • In the case of inputs, the commodities must be provided further or brought back from job worker premises within one year.
  • Capital items, excluding moulds and dyes, such as jigs and fixtures or tools, shall be provided or returned to the job worker's premises within three years.

Liabilities on the Principal

  • It is the principal's responsibility to keep track of commodities provided for job work and return them in accordance with GST guidelines.
  • If they fail to do so, as a general rule, commodities will be considered as supplied at the moment of issuance for job labour.
  • They will be accountable to pay the total amount for the goods.
  • Goods supplied from a job worker’s place to an end customer are counted as a supply from the principal.

Job Work Delivery Challan

  • After downloading the job work challan under GST, the principal can send the goods for job work processing.
  • The challan format is prepared as per GST rules.
  • The delivery challan format in GST is downloaded in excel and filled out.
  • The document will help maintain a record for the GSTR 4 return
  • Principal needs to triplicate the form
  • The job work challan is also used while the job worker returns goods to the principal after processing them.
  • You can download the delivery challan format in excel for further changes. You can also convert it into a word file.

Also Read:

Conclusion

We have understood the importance of a delivery challanand how it brings clarity to all job work proceedings. It is also an essential document that plays a vital role in record-keeping. For this reason, it is important to make an effective delivery challan. To make a challan more efficient, one must capture the specific details of the goods like the HSN codes, the taxable amount, and the description.

Disclaimer :
The information, product and services provided on this website are provided on an “as is” and “as available” basis without any warranty or representation, express or implied. Khatabook Blogs are meant purely for educational discussion of financial products and services. Khatabook does not make a guarantee that the service will meet your requirements, or that it will be uninterrupted, timely and secure, and that errors, if any, will be corrected.The material and information contained herein is for general information purposes only. Consult a professional before relying on the information to make any legal, financial or business decisions. Use this information strictly at your own risk. Khatabook will not be liable for any false, inaccurate or incomplete information present on the website. Although every effort is made to ensure that the information contained in this website is updated, relevant and accurate, Khatabook makes no guarantees about the completeness, reliability, accuracy, suitability or availability with respect to the website or the information, product, services or related graphics contained on the website for any purpose. Khatabook will not be liable for the website being temporarily unavailable, due to any technical issues or otherwise, beyond its control and for any loss or damage suffered as a result of the use of or access to, or inability to use or access to this website whatsoever.

Delivery Challan Format in Excel and Word for Job Work (2024)

FAQs

How can I make Challan for work? ›

The challan issued must include the following particulars:
  1. Date and number of the delivery challan.
  2. Name, address and GSTIN of the consigner and consignee.
  3. HSN code, description and quantity of goods.
  4. Taxable value, tax rate, tax amount- CGST, SGST, IGST, UTGST separately.
  5. Place of supply and signature.
12 Jan 2022

What is job work Challan? ›

The inputs or capital goods shall be sent to the job worker under the cover of a challan issued by the principal. The challan shall be issued even for the inputs or capital goods sent directly to the job worker. The challan shall contain the details specified in rule 10of the Invoice Rules.

What is delivery Challan example? ›

A Delivery Challan is a formal document that is created in situations where goods are being transported from one place to another which may or may not result in sales. Example: Transfer of goods from the Head Office to its branches. Delivery Challans are sent along with the shipment of goods.

How do I create a data feed in Excel? ›

How to create your data feed
  1. Step 1: Open your spreadsheet program. Using a spreadsheet program such as Microsoft Excel makes it easy to create a feed and convert it to the proper format.
  2. Step 2: Create a header row. ...
  3. Step 3: Enter your item information. ...
  4. Step 4: Convert your spreadsheet. ...
  5. Step 5: Submit your data feed.

What is job work with example? ›

Meaning of Job Work

The goods sent for job work maybe raw material, component parts, and semi-finished goods and even finished goods. Examples of common job works are slitting, machining, welding, painting, electroplating, assembly, powder coating etc.

Who can make delivery challan? ›

A delivery challan is a document issued by the seller to the buyer while delivering the goods, which may or may not result in sales. If a factory sends goods from one warehouse to another warehouse, the registered person will issue a delivery challan for such transportation.

What are job work charges? ›

Job-work charges means the valuable consideration received or receivable by a job-worker during a given period for executing a job- work minus the value of materials which are purchased by him on payment of sales tax in the State of Haryana and are consumed by him in execution of job-work during that period. Sample 1.

What do you write in a delivery note? ›

What should a delivery note include?
  1. The name and contact details of the seller.
  2. The name and contact details of the customer.
  3. The date of issue.
  4. The date of delivery.
  5. A description of the goods contained in the order.
  6. The quantity of each product included in the shipment.

Is e way bill required for delivery challan for job work? ›

Inputs sent by Principal to Job worker or vice-versa

Here, the threshold limit of INR 50,000 isn't applicable; hence even where the value of goods sent out to the job worker doesn't exceed INR 50,000, the principal needs to generate the Eway bill.

How many copies of delivery challan is prepared? ›

As per rule 55(2), the delivery challan should be prepared in three copies (triplicate) in the following manner-Issue of Delivery Challan in case of movement of Goods: Original copy marked as 'Original for Consignee', Duplicate copy marked as 'Duplicate for transporter', and.

Is it illegal to work two jobs in India? ›

Under the employment law in India, there is no specific provision that talks about the legality of dual employment in India. Section 60 of the Factories Act, 1948 talks about the restriction on double employment in India, on people working in factories.

How do I file a return for a job? ›

Here's a step-by-step guide on filing on the GST portal.
  1. Step 1: Login to the GST Portal.
  2. Step 2: Go the Services>>Returns>>ITC Forms.
  3. Step 3: Go to “Prepare Offline” Upload invoices.
  4. Step 4: Once invoices are uploaded then click 'Initiate Filing'.
  5. Step 5: Select tax period.
  6. Step 6: Check taxable amount and other details.
12 Jan 2022

What is job work in EWAY bill? ›

Eway bill job work has to be generated before initiating the movement of goods, and the transporter needs to carry it along with the invoice during the movement of goods in job work return e way bill within state limit.

What is delivery challan book? ›

A Delivery Challan is a document that is issued when goods are being transported from one place to another, which may or may not result in a sale. Delivery Challans are sent along with the shipment of goods.

Why do we use challan? ›

Challan as a Monetary Credit receipt

"A challan or bank challan is defined as an official document, form, or piece of paper used to credit money from one account to another. It is almost similar to the deposit slip available in the bank with which you can deposit money into someone's account in cash.

Is a delivery ticket an invoice? ›

Delivery Ticket means a vendor doc- ument supplied at the time of delivery which indicates the items delivered, can serve as a proper invoice based on contractual agreement.

What is the fastest way to fill data in Excel? ›

Go to Data > Flash Fill, or press Ctrl+E. Excel will sense the pattern you provided in C2, and fill the cells below.

What format is a data feed? ›

In addition to varying feed specifications, there are several feed formats that channels accept. These include CSV, plain text (txt), and XML. Plain text files are the simplest to produce as they require no technical skills.

What is the easiest method to fill data in Excel automatically? ›

Put the mouse pointer over the bottom right-hand corner of the cell until it's a black plus sign. Click and hold the left mouse button, and drag the plus sign over the cells you want to fill. And the series is filled in for you automatically using the AutoFill feature.

What are the 3 types of work? ›

There are only three types of work. There's a job, a career, and a calling.

What are the 4 job types? ›

4 Types of Jobs: Thinkers, Builders, Improvers, and Producers
  • Thinkers produce an idea.
  • Builders convert the idea into reality.
  • Improvers make it better.
  • Producers do the work in a repeatable manner to deliver goods and services to customers.
13 May 2013

What are the 3 types of jobs? ›

A Job Category defines the type of work performed, as opposed to the occupation or subject matter. The three categories are: 1) Operational & Technical, 2) Professional, 3) Supervisory & Managerial.

Is Proof of delivery required? ›

If your business delivers anything, you need proof of delivery to give customers peace of mind that they received what they paid for and to protect your business from claims that they didn't.

Is GST applicable on job work delivery challan? ›

Ans. Although the activity is a job work under GST, there is no requirement of delivery challan as principal's inputs/capital goods are not being moved. Therefore, ITC-04 also is not required.

What is delivery challan for job work in GST? ›

Delivery challan, slip of delivery or delivery challan GST, is an instrument that carries details about the delivered goods such as quantity, condition and description. This tax invoice cum challan also contains the recipient details, delivery location and time.

How is work price calculated? ›

How do you calculate labor rate? Add the full cost of what it takes an employee to create a product or complete a service. This includes their wages, taxes, and benefits. Then divide that total by the number of hours an employee works.

What is on a job cost sheet? ›

A job cost sheet is a document detailing all the costs incurred for the completion of a project. These costs can be documented during the project or after the job is complete. Usually, the accounting department compiles this record to: verify that expenses fell within the allocated budget. cost estimate for future jobs.

How do you take charge at work? ›

Getting Ahead and Leading the Way: How to Take Charge In The Workplace
  1. Go the extra mile. ...
  2. Find a mentor. ...
  3. Keep growing professionally. ...
  4. Challenge yourself.
  5. Stay up-to-date on your industry.
  6. Don't be afraid to voice accomplishments.
  7. Foster positive relationships within the company.
  8. Pass the mentorship on.
14 Jan 2014

What is a good sentence for delivery? ›

The delivery is scheduled for this morning. The company offers free delivery with orders over $100. Someone has to be home to accept delivery of the package. Allow six weeks for delivery.

How do you write a delivery report? ›

A delivery report contains the following:
  1. The SMS ID of the MT message. ...
  2. A date, giving the time at which the delivery event occurred.
  3. A delivery report type code giving an overview of the delivery status of the message. ...
  4. A detailed reason code, giving further information on the reason for the delivery report.

Which document is used as a proof of delivery? ›

What is Proof of Delivery? Proof of delivery (or POD) is a form of delivery receipt that confirms a consignee has received the correct goods. This receipt, or bill of confirmation, is used when a consignee wants to return an item, or file a damage claim.

Can we send material without invoice? ›

Rule 55 – Transportation of goods without issue of invoice

(4) Where the goods being transported are for the purpose of supply to the recipient but the tax invoice could not be issued at the time of removal of goods for the purpose of supply, the supplier shall issue a tax invoice after delivery of goods.

Is delivery challan and invoice same? ›

Another slight difference between these two documents is that an invoice indicates the particular value of products delivered while the challan doesn't. However, in some cases, challan may include the worth of products, but it never shows the tax charged to a customer.

Can I work in two companies with same UAN number? ›

Secondly, to claim the benefits of PF contribution with two or more companies, you will have to share the same UAN number with the other company also where in they can record the contribution. Hence both the companies can extend you the benefits of PF but on the same PF account.

Can I get salary from two companies? ›

18 July 2011 Yes One person can draw salary from two different company, there is no any issue. But he should disclose to any Employer company (at his option) that he is in receipt of salary from another company for the purpose of Compliance of TDS provision. This disclosure is not mandatory but it is advisable.

Can we join 2 companies at the same time? ›

CelebratingLife Infotech

No , there is no such specific legislation in India to stop dual employment in India, there is a section 40 in Factories act which stops the labour to work in more than one factory but for employer there is no such legislation to stop dual employment.

How do I send back to HR? ›

How to write an email to HR
  1. Properly address your email. If you work for a larger company, you may not already know your HR representative so it is important to learn this information. ...
  2. Write a specific subject line. ...
  3. Explain the situation. ...
  4. Clarify what steps you want to take. ...
  5. Close the email. ...
  6. Check for mistakes.

Why do we do return to work? ›

As the name suggests, a return to work interview is a meeting held with an employee after a period of absence. The primary purpose of a return to work interview is to welcome the employee back, discuss the reasons for their absence and confirm that they are fit to attend work.

What do you mean by job work? ›

What is job work? Job work means undertaking any treatment or process by a person on goods belonging to another registered taxable person. The person who is treating or processing the goods belonging to other person is called 'job worker' and the person to whom the goods belongs is called 'principal'.

How can I make challan for work? ›

The challan issued must include the following particulars:
  1. Date and number of the delivery challan.
  2. Name, address and GSTIN of the consigner and consignee.
  3. HSN code, description and quantity of goods.
  4. Taxable value, tax rate, tax amount- CGST, SGST, IGST, UTGST separately.
  5. Place of supply and signature.
12 Jan 2022

Is GST charged on job work? ›

Under the Central Excise law, inputs or partially worked inputs are sent to job-worker for processing before the introduction of GST and the goods returned back to the premises of the Principal within 6 months from the appointed day of GST, then no tax is applicable on such goods.

What is a job works contract? ›

“works contract” means a contract for building, construction, fabrication, completion, erection, installation, fitting out, improvement, modification, repair, maintenance, renovation, alteration or commissioning of any immovable property. wherein transfer of property in goods (whether as goods or in.

How do I create a receipt and payment in Excel? ›

Open Excel, or click the File tab if it's already open. Type Receipt in the Search field. Click a receipt to see a preview and click the Create button to open it.

How do you make an automatic dash in Excel? ›

Inserting Dashes between Letters and Numbers in Excel
  1. Select the cell or range of cells where you want to insert the dashes.
  2. Click the Home tab.
  3. In the Font group, click the Insert drop-down arrow.
  4. Click Special Characters. A dialog box appears.
  5. In the Symbol tab, select the character you want to insert. ...
  6. Click Insert.

Who prepares the delivery challan? ›

A delivery challan is a document issued by the seller to the buyer while delivering the goods, which may or may not result in sales. If a factory sends goods from one warehouse to another warehouse, the registered person will issue a delivery challan for such transportation.

How do I Create a payment receipt in Word? ›

Open the Word app installed in your desktop PC, laptop, or android tablet device. Click the New option located in the left sidebar and look for the search bar for online templates. Type Receipt and then tap the Enter button or toggle the search icon.

How does payment in Excel Work? ›

What is the PMT function in Excel? The Excel PMT function is a financial function that calculates the payment for a loan based on a constant interest rate, the number of periods and the loan amount. "PMT" stands for "payment", hence the function's name.

How do I turn on auto dash in Word? ›

Hyphenate text automatically

On the Layout tab, click the arrow next to Hyphenation . Select Automatic.

How do I make a dash in Word? ›

To insert an em dash, click where you want to insert the em dash and then press Ctrl + Alt + – (minus sign on the numeric keypad). To insert an en dash, click where you want to insert the en dash and then press Ctrl + – (minus sign on the numeric keypad). If this doesn't work, press NumLock on the numeric keypad.

How do you find the mean in Excel 2022? ›

To find the mean in Excel, you start by typing the syntax =AVERAGE or select AVERAGE from the formula dropdown menu. Then, you select which cells will be included in the calculation. For example: Say you will be calculating the mean for column A, rows two through 20. Your formula will look like this: =AVERAGE(A2:A20).

How do I calculate cells in Excel? ›

Select a cell next to the numbers you want to sum, click AutoSum on the Home tab, press Enter, and you're done. When you click AutoSum, Excel automatically enters a formula (that uses the SUM function) to sum the numbers. Here's an example.

How do I calculate daily charge in Excel? ›

To calculate Cost/ Day you can use inbuilt functions AVERAGE or AVERAGEIF functions. AVERAGE function if list contains cost of single product or commodity and AVERAGEIF function if you have more then one products cost on the list and you want to calculate cost per day for a particular commodity.

Is proof of delivery required? ›

If your business delivers anything, you need proof of delivery to give customers peace of mind that they received what they paid for and to protect your business from claims that they didn't.

Top Articles
Latest Posts
Article information

Author: Foster Heidenreich CPA

Last Updated:

Views: 5982

Rating: 4.6 / 5 (56 voted)

Reviews: 95% of readers found this page helpful

Author information

Name: Foster Heidenreich CPA

Birthday: 1995-01-14

Address: 55021 Usha Garden, North Larisa, DE 19209

Phone: +6812240846623

Job: Corporate Healthcare Strategist

Hobby: Singing, Listening to music, Rafting, LARPing, Gardening, Quilting, Rappelling

Introduction: My name is Foster Heidenreich CPA, I am a delightful, quaint, glorious, quaint, faithful, enchanting, fine person who loves writing and wants to share my knowledge and understanding with you.