Sales Order and Invoices

Delivery Challans Excel format

Delivery Challans Excel format

Delivery Challans: What is Delivery Challans?

In business many times, the Supplier is not able to make an Invoice with every items delivery due to multiple reasons thats explained below. In those scenarios, he sends the materials making Delivery Challans and later invoices it. So many business owners look for the Delivery Challans Excel formats as it helps them to simplify the process and follow t. Why this method is followed?

  1. In a day customer is asking the multiple items frequently and want to get it delivered ASAP through Delivery Challans.
  2. Customer wants one invoice per day for all the items thats delivered so that its easy for Customer to manage the Bills, Tracking etc. Some customers insists to send the material through Delivery Challan and send invoice once in a week or month.
  3. Many times, items are sent and it comes back as replacement or not good etc. So it doesn’t make invoice for each items and then replace it back.
  4. So Delivery Challan helps and makes the life of Customer and Supplier easy. After the materials sent via Delivery Challan, then invoice has to be prepared.

Delivery challan under GST

Most of the time Delivery Challans are important as this is the ONLY WAY to do the Business. For example in the following cases, invoice can’t be made at that time or later too.

  1. Material sent for Job work as Customer doesn’t know the actual cost of the work.
  2. Materials sent to Exhibition and comes back after the show. Delivery challans are important tool to track the items movement from the Stores to show and comes back
  3. Finished Goods are sent via Delivery Challans for Inter company transfers.


Delivery Challans: How many types of Delivery Challans?

Delivery challan contents would change based on the type of activities, Industry (Manufacturing, Service or Traders). However we can identify the same in 3 formats

  1. Outward Delivery challan (Job work or Subcontracting) – Its prepared when items are sent out for Job Work or along with Invoice for the Transporters
  2. Inward Delivery Challans – Mainly for the recording of the Materials that comes in post Raw materials sent out and now we have to record back indicating “sent items have come now”

Each of the above will have the impact on the Inventory or Stock.

Delivery Challan details – format and contents

Delivery challan or known in business as “DC” will have its serial numbers that sequentially maintained across the financial years. It requires a physical signature and can’t be a “Auto Signature” or “computer generated ones”. Since these document accompanies the Product, the focus more towards having ORIGINAL document. Below are the field details in a DC.

  • Date and serial number of the delivery challan.
  • Company Name, Address, GSTN number with a clearly defined contact details.
  • Name, address and GSTIN of the Subcontractor.
  • HSN code for the goods. / SAC code for services, if any.
  • Description of goods.
  • Quantity of goods supplied.
  • Taxable value of supply and the GST tax rate applied.
  • Transportation charges, if any
  • Place of supply, in case of inter-state movement of goods.

Please note that earlier, DC never had any financial and tax details. Post Indian GST we are expected to show these details too. Delivery challans are prepared by Stores person at the time of material goes out of his STORES. Its made either in DUPLICATE or TRIPLICATEs. Each customer follows his own formats of Delivery Challan and there is no standard formats.

GST delivery challan format in excel

Download the free Delivery Challan Excel Format

GST Delivery Challan Format in Word


delivery challan word format

How Delivery Challans work in

How it works for Job work Outward delivery Challan?

You can use this menu to send the Finished goods / Work In progress items to Customer post the work is done. This helps to track the Work In progress or Finished Goods thats sent to Customer etc. In the business, Customer will send his raw materials to his subcontractor to do the activities thats not done within his factory. It could be for Assembly, Conversion of RM to Semi Finished Goods etc. So he will send a “Job work outward delivery challan” listing the items that are sent to him. The reasons for getting the Job work outside the factory premise are

  1. It cheap to do it outside
  2. No need to have additional working capacity, while the work load is very low.
  3. It could be too much specialised and skilled work.
  4. Chemical or plating or Blackening kind of work.

While making an Job Work Outward Delivery Challan, we choose an Inward Delivery Challan against which the FG is sent. Please check the video on Jobwork for a customer.


Other features and Functionalities of, a Cloud ERP system for SMEs

We are summarising the product features of an ERP and how it would help Business Owners. Call us at +91 80 2662 9236 for more details.


ERP Modules

ERP Modules

Click here for more details.

  1. Check here the’s ERP Features

  2. How to implement an ERP Software that’s easy and quick to do?

  3. Problems that are faced by an ERP implementation

Call us +91 80 2662 9236 for a FREE DEMO or send an email to “”


If you like this, please share this. Thanks
Share on Facebook
Pin on Pinterest
Tweet about this on Twitter
Share on LinkedIn
Email this to someone