GST Invoice Format 3.1 – Free Dynamic Excel sheet

Posted by By Sarbjit Singh Amanpreet Kaur Bharaj 8 Min Read 1 year Ago 6k Views
Last Updated:October 11, 2023
GST Invoice Format 3.0 - Free Dynamic Excel sheet
GST Invoice Format 3.0 - Free Dynamic Excel sheet

Nowadays, In India, The seller must have to register under the GST Act, if he has a turnover above Rs 40 lakh within the financial year. So every seller needs a GST invoice format. We have provided solutions for all sellers all over India. It is a dynamic GST invoice format in Excel.

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 guided by the Central Govt. or GST Act 2017. GST Invoice Format is a very crucial document in the GST Act, 2017 we have made software for you to provide help to you to generate GST invoices.

Check the Requirement of GST Invoice Format please Click Here

Feature of GST Offline Invoice Creator: 

1You can be allowed to Trade discounts to your Customers charge in simple percentages and the amount will auto-calculate
2Auto-generated and save the invoice in just one click
3Auto-generated new invoice No.
4Save of Invoice as a PDF in folders
5Auto Detect type of Sale (Interstate or Intrastate) and charge the correct Type of GST i.e. IGST or CGST/SGST
6Auto-detect the Rate of GST from the stock list.
7Maintained the list of stock. So, you don’t need to add stock items again and again while generating an invoice
8Maintained the list of Customers. Select from the list and generate the invoice
9Upload Your Logo 
10Add a different shipping address
11Add E-way bill details
12Auto-generate Summary for all sale
13GST amount is shown Item with the rate of percentage
14Generate Three Copies of the Invoice
-Customer Copy
-Supplier Copy
-Transported Copy
15Auto Round off the total amount
16Show all amounts in rupee and paise with one click 
17Show all amounts only in rupees with one click 
18Auto-generated total invoice amount in words
19Add up to 10 Terms and conditions
20You can add your bank details
21Colorful invoice format 
22You can generate an invoice for up to 25 items
23You can be allowed to Trade discounts to your Customers charge in simple percentages and the amount will auto calculate
24You can be allowed to Trade discounts to your Customers charge in simple percentages and the amount will auto-calculate
25You can add Contact person Details i.e Name, Email, and Mobile No. in the customer list database
26You can add the amount of freight paid

How to operate it

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: –

Download GST Offline Invoice Creator 2.0 by TutorsTips.com
GST Invoice Format
GST Invoice Format - 2

2. Enter Your Organisation details:

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

your business Details

3. Add Inventories:

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

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

GST Invoice format

4. Add some Customers:

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

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

GST Invoice format

5. Create Invoice:

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

Create Invoice - GST Invoice Format
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 be redirected to the Form of Add new Customer.

Select Customer - GST Invoice Format
Select Customer – GST Invoice Format

2. Add Customer:

This option is the same as the option explained on the Customer Page.

3. Add Shipping Address:

Then enter the shipping address if different from the billing address.

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

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

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

4. Select items:

Now, select the items to be billed. The process is the same as the selection of the customer. Here are two options for searching from old items and adding 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 them if needed. 

6. In the last Sheet:

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

GST Invoice format

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

Please Share it with your friends.