CONSULTEASE.COM
Annual Membership

Sign In

Browse By

Free excel utility for annual return

Features of Free excel utility for annual return:

Here you can understand and download this free excel utility for annual return. I have tried to make it perfect but still in case of any issue pls ping me. The GST Annual Return is to be filled for the first time and the details to be filed and to be submitted is confusing. So, we have made an excel sheet for the calculation of Annual Return under GST. 

DISCLAIMER : THIS EXCEL UTILITY HAS BEEN PREPARED WITH UTMOST CAUTION,AND PREPARED ON THE BASIS OF MY UNDERSTANDING OF THE GSTR 9, THIS DOES NOT AURANTEE ITS ACCURACY , BEFORE RELYING ON IT IS SUGGESTED TO CROSS CHECK YOUR OWN WORKING. THIS EXCEL UTILITY WILL HELP IN PREPARING GSTR-9.

BASIS OF MAKING THIS GSTR- 9

(A) ACTUAL TAX LAIBILITY  10000
REPORTED IN 2017-18 9000
REPROTED IN 2018-19 500
ADDITIONAL LAIBILITY REPORTED THROUGH GSTR09 700
EXCESS TAX PAID  ERRONEIOUSLY -200
(B) OUTCOME OF  WORKING [FINAL REPORTING] 10000

Instruction to use Free excel utility for annual return 

  • Fill the basic data preferably in 3B   in 2017-18 & 2018-19 (pertaining to transaction 2017-18 but reported in 2018-19 only)
  • Post to Actual
  • It is presumed that some error/mistake in filing 3B so correct actual figure in books
  • After this process, we will have comparables and GSTR-9 outward & inward summary will be prepared
  • For this working, GSTR-1 may be used for reference only 
  • Don’t use the amount is negative.
  • Always save the file as *.xml

FOR EXAMPLE – OUTWARDS SUPPLY TO BE COMPILED AS BELOW:

  • Either place the data in the GSTR 3B outward sheet or in outward book sheet (prereably in 3B)
  • After placing the data in any sheet run the macro as follows:

In book outward sheet from ”3B to Book/Actual”your book will be prepared as if both are same and make necessary correction in Books /Actual by correct figureIn 3B-2017-18 outward sheet from ”Books to 3B”your 3B-2017-18 will be prepared as if both are same and make necessary correction in 3B-17-18 and 18-19 as per return filed

Data punched Macro to run  Remarks:

3B outward detail (2017-18 & 2018-19)

In books outward

 

  • GSTR-9 Outward part will be prepared by doing above exercise. 

The report will give :

  • As additional liability, if any, is being discharged through GSTR 9. (through DRC 03)
  • As additional liability, if any, is being discharged through GSTR 9C. (through DRC 03)
  • In few cases there may be indication of refund but through GSTR-9 refund can’t be taken
  • FOR INWARD SUPPLY: SAME METHEDOLOGY TO BE APPLIED AS APPLIED FOR OUTWARD SUPPLY COMPILATION , ADDITIONAL REVERSAL MAY BE MADE WHICH WAS NEVER BEEN MADE  , IN SHEET “ACTUAL ITC” – TABLE POST WORKING REVERSAL

Free excel utility for annual return

This excel is for overall calculation.

TABLE8A_WORKING.xlsx - Excel (Product Activation Failed) 2019-06-18 18.19.08

 

Stay informed...

Recieve the most important tips and updates

Absolutely Free! Unsubscribe anytime.

We adhere 100% to the no-spam policy.

Profile photo of CA Jatan Jain CA Jatan Jain

Delhi, India

Discuss Now
Opinions & information presented by ConsultEase Members are their own.