GST Compliant Billing Format- Excel Program

Hello everyone,

As we all know that GST has become a reality and has been implemented with a bang! Although we encourage and support GST Law there are still many confusions regarding the law as specially when it comes to different voucher formats. To make it simplified and understandable to users/business owners we have developed one Billing/Invoice Format using Microsoft Excel after consulting team of Tax Consultants.

DOWNLOAD EXCEL

(* This Sheet is macro enabled. To use this make macros enable.)

The intention is simple! To provide a standardized template which can also work as a small program for business users who do not possess or afford any kind of ERP/ Softwares.

 

You can download the excel by clicking on the link.

(* This Sheet is macro enabled. To use this make macros enable.)

STEPS TO CREATE INVOICE:

Enter Company Master Details in ‘Company Master‘ sheet

Enter Customer/Supplier Detail in ‘Party Ledger‘

Create Item Master in ‘Item Details’ Sheet

Now You can create your Invoice. Go to ‘Invoice‘ and Select the Company from which you are providing service/supplying goods.

Fill up the details required

Click on SAVE button.

Go on and create multiple invoices. Invoice details will be saved in the sheet named ‘Invoice Register‘ as shown below.

If you want to make changes/modifications in the invoice, go to ‘Invoice’ sheet. Type in the exact Invoice No and click on VIEW button.

---

NOTE: Make sure you type in the exact ‘InvoiceNo’ as it is case sensitive.

---

Make modifications and click on SAVE button. If the Invoice No is already entered in the register, it will pop up the following message.

After it is saved it will pop up the following message.

You can print it on your company letterhead or can set company letterhead image as document header. To do so, go to insert>Header & Footer. Then click on picture under design tab and save the sheet. You are good to go.