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.
DOWNLOAD EXCEL
(* This Sheet is macro enabled. To use this make macros enable.)
Request: Guys please share this post as much as possible and help people.
In case anyone needs any help, write us on gst@ellipsisinfotech.com
Thanks!
Pretty! This was a really wonderful post. Thank you for supplying this info.
Appreciate this post. Let me try it out.
It’s great that you are getting ideas from this piece of writing as well as from our dialogue made here.
Have seen that CGST & SGST being separately shown on some invoices or BILL OF SUPPLY. Would that be possible to do in your format?
Sir, I did not get the question. What do you mean by “seperately shown”?
The file is good however still need to add more features .
1 Only IGST is calculated in the invoice however not the CGST and SGST .
2 Item description should be drop down
3 What is the use of column Z to AR from invoice register
Appreciate if you can let me the whether i am missing something or is it need to add to the macros .
Hi Santosh,
1. As soon as your GSTIN for the place of destination is changed and belongs to the same state it will automatically CGST and SGST.
2. Item is fetched from the master. So if you need to change it, you need to change it into the master sheet.
3. Column Z to AR are to record the line items 2-5 of Invoice.
Thanks for posting and using it.
Admin.