GST Invoice Format | Free Dynamic Excel sheet

GST Invoice Format-Feature image

GST Invoice Format in Excel

As per the new taxation system in India, Every registered dealer under GST has to make the invoice in the new format (GST Invoice Format)as per guided by Central Govt. or GST Act 2017. GST Invoice Format is the very crucial document in the GST Act, 2017 we have made software for you to provide help to you to generate GST Invoice.

Check Requirement of GST Invoice Format please Click Here

In this Topic, We will explain how to use our GST Invoice generator Software Step by Step as the following: –

1. Download and Extract it
2. Enter Your Organisation details
3. Add Inventories
4. Add some Customers
5. Create Invoice

1. Download and Extract it

First, you have to download it from the link below and Extract it with the help of WinRAR (Click Here to Download) software then you get a folder : –

010 document 6 150x150 - GST Invoice Format | Free Dynamic Excel sheetDownload – GST Invoice Creating Software

GST Invoice Explain  - GST Invoice Format | Free Dynamic Excel sheet

GST Invoice Explain 2  - GST Invoice Format | Free Dynamic Excel sheet

2. Enter Your Organisation details:

Now you have to open the Excel sheet from this folder and enable all the micro or options whatever asked by Microsoft Excel then enter the details asked in the sheet Named: Organisation Details. This information will be asked only one time by software.

your business Details - GST Invoice Format | Free Dynamic Excel sheet

3. Add Inventories:

Now, you have to create your stock list for easy pop-up items at the time when you will creating/generating Invoice. You can also add any stock item at the time of creating/generating Invoice.

Click on the Button Add New Item then there will pop up a form fill this form and click on Button Add New Item is shown on the form. As shown in the image below.

GST Invoice format 3  - GST Invoice Format | Free Dynamic Excel sheet

4. Add some Customers:

Now, you have to create your Customer list for easy and speedy invoice generation. You can also add New Customer at the time of creating/generating Invoice.

Click on the Button Add Customer then there will pop up a form fill this form and click on Button Add New Customer to Database is shown on the form. As shown in the image below.

GST Invoice format 4  - GST Invoice Format | Free Dynamic Excel sheet

5. Create Invoice:

Now, Goto sheet Create Invoice and select customer with the help of two options explained as the below:

Create Invoice  - GST Invoice Format | Free Dynamic Excel sheet
Create Invoice – GST Invoice Format

1. Search Customer:

 If you have already added the customer in the database then select it with the help of search customer and insert it into an invoice. and with the help of the second option, You will redirect to Form of Add new Customer.

Select Customer GST Invoice Format - GST Invoice Format | Free Dynamic Excel sheet
Select Customer – GST Invoice Format

2. Add Customer:

This option is same with option explained in Customer Page.

Then enter shipping address if different from billing address.

Then decide your invoice No. format only One time then it will automatically get increment to next no.

like: if you decide 10001 then, when you save invoice it will automatically change to 10002. Special characters (|\/!@#$%^&*()) are not allowed in Invoice.

then Today date will show automatic but you can change the date of invoice if you want to but you can only change date up to the date of your last invoice.

Now, Select the items to be billed. The process is the same as the selection of the customer. Here is also available two option for search from old items and add new items if needed.

Now, Select Quantity and Discount(if applicable) only for each selected item then click on Save & view Invoice.

You will get all three saved copies of invoices and print it if needed. 

In the last Sheet:

you will get all your sale of the Day, Month, Quarter, Semester and Year by the applying filter on it for your GST Returns. 

GST Invoice format 7  - GST Invoice Format | Free Dynamic Excel sheet

Thanks for reading the topic of GST Invoice Format, please comment your feedback whatever you want Or If you have any question please ask us by commenting.

Please Share and spread it. 

Summary
Review Date
Reviewed Item
Download Dynamic Excel sheet for Invoice in GST
Author Rating
51star - GST Invoice Format | Free Dynamic Excel sheet1star - GST Invoice Format | Free Dynamic Excel sheet1star - GST Invoice Format | Free Dynamic Excel sheet1star - GST Invoice Format | Free Dynamic Excel sheet1star - GST Invoice Format | Free Dynamic Excel sheet