GST Compliant Billing Format- Excel Program

By 7 Comments Ellipsis Infotech

Share This:

gst

 

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.

Invoice Sample

 

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

Company Master

Enter Customer/Supplier Detail in ‘Party Ledger‘

Party Ledger

Create Item Master in ‘Item Details’ Sheet

Item Master

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

Select Company

Fill up the details required

Invoice Fill Details Itemwise Entry Other Details and Tax CalculationClick on SAVE button.

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

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.

Click on View to fetch details

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

Inv exist Msg

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

Invoice Saved MsgYou 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!

0
Tags: , , ,

7 Comments

  1. fifa 18 coins July 21, 2017

    Pretty! This was a really wonderful post. Thank you for supplying this info.

  2. fifa 18 coins July 21, 2017

    Appreciate this post. Let me try it out.

  3. mink lashes July 21, 2017

    It’s great that you are getting ideas from this piece of writing as well as from our dialogue made here.

  4. Prakash K Basutkar July 11, 2017

    Have seen that CGST & SGST being separately shown on some invoices or BILL OF SUPPLY. Would that be possible to do in your format?

    • Admin July 13, 2017

      Sir, I did not get the question. What do you mean by “seperately shown”?

  5. santosh kumar Gulla July 4, 2017

    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 .

    • Admin July 13, 2017

      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.

?