GST Invoice template in excel
From 1st July 2017, India rolls out its biggest indirect tax reforms Goods and Service tax. All invoices prepared from 1st july should be prepared with GST as per the Invoice rules. We have prepared GST invoice template in excel to prepare the invoice.
In this you can update the details and take the print of invoice as per GST invoice rules.
Initially, company master should be updated to reflect the details in invoice.
After updating the details in this sheet, this will be reflected in the Invoice format.
In Invoice Print format, you can update the details in yellow colour fields.
In this format you can update up to 10 items for sales.
You can update the details of Insurance, Freight and Packing details in addition to basic amount.
Tax rates for GST can be update to calculate the tax as applicable.
The final invoice print will be as below .