GSTR-1 Filing using Tally.ERP 9 Release 6
As per the 23rd GST Council Meeting, taxpayers are divided into two categories based on their aggregate annual turnover and accordingly dates for GSTR-1 filing have been issued.
Taxpayers with an annual aggregate turnover of up to Rs 1.5 Crores have to file GSTR-1 on a quarterly basis. For the quarter of January to March, they have to file by the 30th April 2018.
Taxpayers with an annual aggregate turnover of more than Rs 1.5 Crores need to file GSTR-1 on a monthly basis. For the months of January, they have to file by the 10th March 2018.
In this blog post, we will discuss GSTR-1 filing using GST-ready Tally.ERP 9 Release 6.
Introduction to form GSTR-1
GSTR-1 is a form in which a business must provide the details of its outward supplies. Outward supplies refer to all supplies comprising of sales made to other businesses, sales to consumers, exports, advance receipts from customers, and so on.
There are multiple tables in the form, and businesses have to furnish details in each table. For example, businesses have to fill in:
a) ‘Sales done to other registered business (B2B Invoices)’ bill by bill with details of the buyer.
- b) ‘Sales done to consumers of small amounts (B2CS Invoices)’ as a summary and not bill by bill.
- c) ‘Sales done to consumers of large amounts (B2CL Invoices)’ bill by bill with details of consumer.
Are you a business owner who takes the help of GST practitioner to file returns?
Apart from the help you get from your GST practitioner, you also need a software which can help you record business data in a GST compliant way. You can do one of the following based on your style of working –
a) Take a backup of your company data and share it with your GST practitioner. Click here to find out how to get data backup in Tally.ERP 9.
b) Modify or make corrections in vouchers that appear under Incomplete/Mismatch headings in the GSTR-1 report. Export the updated GSTR-1 as a MS Excel Template, and share it with your GST practitioner.
Are you a business owner who files the returns on your own?
If you are filing GST returns on your own, you need a GST-ready software in which you could generate GSTR-1. By using GST-ready Tally.ERP 9 Release 6, you can generate GSTR-1 easily from within the software itself.
If you are using Release 6.2 or higher, you can generate GSTR-1 in JSON format which can be directly uploaded on the GSTN portal without having to use the offline utility.
If you are using a lower version of Tally.ERP 9, open the GSTR-1 report, apply corrections to vouchers that appear under Incomplete/Mismatch headings and export the same to MS Excel Template. This has to get validated by the offline utility tool available in the GSTN portal. The resultant JSON file generated by the tool has to be uploaded in the portal for filing.
Are you a GST practitioner (CA, tax consultant, accountant) who files returns for clients?
If you are a GST practitioner, you may be digitizing books of your clients using GST-ready Tally.ERP 9. You can file GSTR-1 using the same data, and save time and effort by generating GSTR-1 from within the software itself.
You may receive data in the following manner from clients:
1) Data backup taken in Tally.ERP 9
2) GSTR-1 Excel Template as required in the GSTN portal
3) Data from any other software (not covered in this blog post)
For data backed up in Tally.ERP 9, you can simply restore the backup on to your Tally.ERP 9 and generate the GSTR-1. If you are using Release 6.2 or higher, you can generate GSTR-1 forms of your clients in JSON format and directly upload them on the GSTN portal for filing.
If you are using a lower version of Tally.ERP 9, apply corrections to the vouchers wherever required, export the same to MS Excel Template, get it validated using the GSTN offline utility tool and finally upload to the GSTN portal.
GSTR-1 filing using Tally.ERP 9 Release 6.1
If you have received GSTR-1 MS Excel Template as required by GSTN, then you need to import that in the offline tool, generate the JSON file and upload the JSON file to GSTN portal.
Click here to upgrade to latest version of Tally.ERP 9 . You will also get the advantage of updating books with only modified vouchers.
Click here for more details about generating GSTR-1 using Tally.ERP 9.
From where can we get the offline utility for GSTR-1 filing?
You can download the offline tool here.
Note: Refer to the “System Requirements” section on the GST Department page and ensure that your system matches the system requirements prescribed. In addition, read the instructions provided to install the offline tool.
Happy filing and stay tuned for more!
160,145 total views, 199 views today
Author: Shailesh Bhatt
91 Comments
Comments are closed.
Dear Tally Team,
Now GSTR-1 filling available in Tally.ERP 9 Rel.6.1 and many user has filled their GSTR-1 return using Tally but what about GSTR-2 ? How I file GSTR-2 from Tally because no utility tool available at this time and also GSTR-2 will be auto reflect from GSTR-2A then how I match GSTR-2 report which available on portal with already posted data in Tally?
GSTR-2 filling will start on 11th Sep, 2017. So please suggest.
Please wait for our next Release, we will keep you posted on our latest developments.
There is a problem with Tally ERP9 6.1 in the GSTR1 report section. Before updating to 6.1 it used to show the buyer names in the particulars column but after updating it is showing the name of consignee name (Name of Jobwork Process House) and the 2nd problem is that the serial number doesnt have any order for eg. Bill No. 1 dt. 10/07/17 and Bill No. 2 dt. 08/07/17 means they are not in perfect order but in GSTR1 doc summary it is showing from Bill Number 2 – Bill Number 25. and Bill No. 1 is not counted. Please help.
Sir/Mam,
Please help how to export all invoices state wise
You may export Sales Register in Excel Format with the option “Export for Pivot” and “Show Ledger Properties” as “Yes”. Register will get export to Excel with a separate state name column. You may apply filters in Excel to get State-wise Invoices. However, we would like to know the purpose of the requirement.
Hi, please confirm where to mention in gSTR1 towardas purchase of inpward supply from unregistered vendors
how reverse charge entry show in gstr-1 in tally, and after reverse charge paid when we take input of reverse charge back
Please refer below links for details
https://help.tallysolutions.com/article/te9rel61/Tax_India/gst/acctng_inward_supply_urd_gst_6_0_3.htm
I have updated Tally ERP 6.1. So I wanted to generate my GSTR-1 Excel file but after exporting the file , the exported excel file does not contain any relevant data of my B2B or B2CL etc instead it showing data like this, this is worksheet name sheet 1 of exported file
Nature of Document Sr. No. From Sr. No. To Total Number Cancelled
$docsnatureofdocument $docssrnofrom $docssrnoto $docstotal $docscanceled
rest worksheet like b2b,b2cl,b2cs etc are all same. This is very difficult for me to file my return and today is 1st sept. So kindly help me
Due to formatting and other validation parameters of GSTR-1 file, MS Office treats it as a potentially vulnerable file. To help protect your computer, files of these nature are opened in Protected View or sometimes in Read-only mode. This can only be resolved by changing the settings of MS Excel so that it treats the file as a trusted file.
The steps to resolve the issue are as given below.
1. Open MS Excel from start menu
2. Select File menu
3. Click on Options tab.
4. Click on Trust Center from the pop-up window.
5. Click on Trust Center Settings button.
6. Select Trusted Locations tab from left side ribbon
7. Click on Add new location button
8. Provide the absolute path of the directory where tally has been installed, in the dialogue-box
9. Select the check-box Subfolders of this location are also trusted and click on OK.
I have issued both exempted sales and non-exempted sales in a single invoice in tally… now, while generating GSTR-1 the amount of exempted sales shown along with non-exempted sales are shown under TAXABLE SALES in GSTR1 report, whereas the amount should be shown under NIL-RATED INVOICES, again the amount of exempted sales is shown correctly in GSTR – 3B. Now, while generating GSTR1 in GST portal, no error is shown… Does it mean that I can submit the report as shown in Tally’s GSTR -1??? But there will be difference in exempted sales between GSTR1 and GSTR 3B….
please advice what to do…
Exempted sales and Nil Rated sales are different. Also, in case any of the items in invoice is taxable then it will appear in taxable invoice(B2B or B2C) in GSTR-1.
DEAR SIR,
GSTR1 doc summary it is showing from Bill Number – Bill Number . and Bill No. is not counted. Please help.
Nature of Document Sr. No. From Sr. No. To Total Number Cancelled
Your Query is not clear. Please provide details.
I have make multi tax invoice with 18% and 28% but while import GSTR1 file in GST 1.2 tool which was exported by Tally, tool can’t import multi tax invoice, only single tax capture 18% or 28% not both. Please resolve this problem.
For multi tax invoice we suggest to use GST offline tool version 1.1
I am not able to upload the GSTR1 excel/csv file generated through tally ERP. as it is saying uploading error.
Please specify the error and we suggest you to use Tally.ERP 9 Release 6.1 and offline utility version 1.1. Let us know still if you face problems.
Is it possible to generate trans 1 data from tally??
You can get the required data from Tally, but from Tally you will not be able to generate Trans-1
There is a problem with Tally ERP9 6.1 in the GSTR1 report section. Before updating to 6.1 it used to show the buyer names in the particulars column but after updating it is showing the name of consignee name (Name of Jobwork Process House) and the 2nd problem is that the serial number doesnt have any order for eg. Bill No. 1 dt. 10/07/17 and Bill No. 2 dt. 08/07/17 means they are not in perfect order but in GSTR1 doc summary it is showing from Bill Number 2 – Bill Number 25. and Bill No. 1 is not counted. Please help.
For first problem, GSTIN Number is important in GSTR-1. For second problem it requires detailed analysis. Please connect our support desk for this issue . or drop a mail to support@tallysolutions.com.
Hello Tally
I have been using tally erp 6 and got the message to update my tally to 6.1 release in the gateway of tally versions & update tab, from there I entered into Products & Features Menu and by pressing F6 I updated my tally to release 6.1. Now I have Tally ERP 6.1. So I wanted to generate my GSTR-1 Excel file but after exporting the file , the exported excel file does not contain any relevant data of my B2B or B2CL etc instead it showing data like this, this is worksheet name sheet 1 of exported file
Nature of Document Sr. No. From Sr. No. To Total Number Cancelled
$docsnatureofdocument $docssrnofrom $docssrnoto $docstotal $docscanceled
rest worksheet like b2b,b2cl,b2cs etc are all same. This is very difficult for me to file my return and today is 1st sept. So kindly help me.
Even i am facing the same problem
Please connect our support desk for this issue . or drop a mail to support@tallysolutions.com.
Same problem I am facing
we are facing the same problem. the excel file generated by using tally erp 9 version 6.1 or above is not opening in GST offline tool utlility. we feel we are fooled by tally that we can file gstr1 or any other return directly using their tool. we have to upload all invoice details manually again.
i also have the same problem…..
Please connect our support desk for this issue . or drop a mail to support@tallysolutions.com.
Generated .xlsx file with E-Return opens in protected view without data though using tally 6.1 version. But can generat csv format successfully would you please explain Why cannot be done in excel format?
Please connect our support desk for this issue . or drop a mail to support@tallysolutions.com.
Hello,
any idea of the threshold for B2CL invoices ??
Invoice with value above 2.5 L and should be interstate, to be considered in B2CL.
We are running a trading business, wherein we are dealing with the products GST ranging from 5%, 12%, 18% & 28%. In a single invoice, we will be having the taxes of 2-3 items varying from 5% to 28%. Is there any report wherein CGST & SGST breakup is available separately with the tax breakup. Also note, as per our auditor we have created separate ledgers for all the above taxes for SGST as well as CGST, as auditor says he cannot find the breakup of taxes. Due to this our invoice is running to pages. Please help us.
We will take it into consideration in our forthcoming Releases.
i have a query regarding transport charges..my transport agency is registered in gst and they are charging 5% as gst charges on frieght…so do i still need to pay gst on frieght through rcm method?
As per the law Transportation service falls under RCM hence you should treat it accordingly, irrespective of type of Service provider.
What is threshold limit ,after which GTA charges comes under RCM?
There is no threshold for reverse charge in case of GTA, as GTA as a service falls under RCM.
i have filed GSTR-3B but i dont have idea for filliing GSTR-1 , pls advice
GSTR-1 is for outward supplies, for details visit below blog
http://blogs.tallysolutions.com/guide-to-file-gstr-1/
Not able to convert tally data into excel though using tally 6.1 version. But can convert thru csv format? Why cannot be done thru excel? Please explain
We are analyzing this cases and soon share details with you.
What is total invoice value and total taxable value in GSTR1
SIR NOT CAPTURE GSTN NO IN PAYMENT & RECIEPT VOUCHOR VER.6.1
While printing the voucher you can enable “Print GST Advance Receipt” to Yes then it will be available.
List of UOM is not complete as per GST website. Lots and Ltrs are not available in Tally 6.1.
We sell in litres. But list of uom does not have litres which will cause a major problem for us. How to solve it. ?
As of use Kilo Litre as a unit and divide by 1000, till GSTN provides litre as a unit.
Is it possible to change the Iomega in csv format or excel format as litre and then upload instead of converting into kilolitre
When is the Release 6.1 final going to come. Waiting eagerly. Deadline is 5th Sept. When should we expect it?
It is available now you can visit below page or upgrade from within Tally.ERP 9
https://tallysolutions.com/download/
Is it possible to change the Uom in csv format or excel format as litre and then upload instead of converting into kilolitre
export invoice with igst having different gst tax rate not imported by gstr-1 offline tool error shown duplicate entry
We suggest you to use Offline Utility version 1.1 . Please download using below link
http://webinars.tallysolutions.com:9090/.index.php?DirName=./Self_Learning_Videos/GST/offline
I am use Tally latest version. My doubts related sale of nil rate items to registered person.
In gstr1 the total amount shown to Outward supply for nil rate. and not to show B2B sale. In this case the buyer how to see their GSTR or how auto populated in this invoice on their gstr2
E RETURN EXPORTED BY TALLY FOR GSTR-1 CAN NOT BE UPLOADED PLEASE RESOLVE THE ISSUE AS EARLY AS POSSIBLE
Please use Preview Release of 6.1 for GSTR-1, follow instructions on page:-
https://tallysolutions.com/gst-preview-release-6-1/
also same as mr rohit says GTA REVERSE CHARGE AND LIBILITY INCRESE DUE TO CAPITAL GOODS PURCHASE ENTERIES NOT SHOWN IN GSTR-1 PREPARE BY TALLY .WE ALLREADY DONE THE JOURNAL ENTERIES FOR THAT BUT NOT SHOWN.SO SUGGEST
We suggest to use Tally Release 6.1 for GSTR-1, follow the instructions as mentioned there :-
https://tallysolutions.com/gst-preview-release-6-1/
i have tally erp 9 release 6.3 latest i file GSTR3B SUCCESSFULLY BY TALLY.BUT THERE IS PROBLEM IN GSTR-1 THE E.RETURN MAKE BY TALLY IN EXCEL FORMAT NOT UPLOADED IN THE OFFLINE UTILITY .AS THE FORMAT NOT FISIBLE TO THE UTILITY. SO SUGGEST HOW I OPLOAD THE DATA IN THE OFFLINE UTILITY.THANKS
For GSTR-1 we will be soon releasing 6.1 , As of preview is available you can follow instructions as mentioned and download from :-
https://tallysolutions.com/gst-preview-release-6-1/
I have filed 3-B, but i do not file trans-1, can i now file trans-1, please guide us.
For this please check with your tax consultants.
Reverse charge on gta entries are not showing in GSTR1 of tally. how can i upload the same in offline utility.
You need to pass a journal entry to increase tax liability then it will be visible in GSTR-1. For details refer
https://help.tallysolutions.com/article/te9rel60/Tax_India/gst/Purc_from_URD_report.htm
Sir, i am talking about GSTR1, 3B is OK all entries are showing 3B and GSTR 2. But not in GSTR1. Do we have to report reverse charge entries in GSTR1
sir i m using 6.0.3 , for gstr 1 filing i need to export our july month data ,in excell format or csv format . i cant export in CSV FORMAT , for that what to do ??
in offline tool can we update our all data in excel formet ??
under reverse charge entry where to show in gstr -1 or gstr -2 ( like transport exp) who made under rcm in tally .
please give some information
thanks
Please use Release 6.1 for GSTR-1. The preview and detailed instructions are available at
https://tallysolutions.com/gst-preview-release-6-1/.
For Advance receipt Gstr1 in tally shows gross amount as taxable amount
Hi,
I have filed 3-B, but i do not file trans-1, can i now file trans-1, please guide us.
We suggest to consult with your tax consultant.
when is the official release of the 6.1 preview as after download of new release it gets mixed up with the old 6.0.3 release. the official update may help
By beginning of next week you will get the Release 6.1
Sir, Facing 3 issues.
1. It is showing error at Row No 5 in Sheet CDNR, CDNUR, EXP & AT even if the data is blank.
2. UQC “FTS-FEET” is not provided, which is available in Off-line Tool.
3. Sheet “docs” is blank, which is supposed to show details of documents issued.
For Point 1 :- This is noted and reported it. The offline utility is trying to validate blank date fields also.
For Point 2 :- This is already noted and reported. The Excel Template provided, does not have provision to capture FTS-FEET. However, we thank you for raising this concern with us
For Point 3:- At present the “Docs” sheet has to be filled manually by the user. You can get the count from Display–> Statement of Accounts –> Statistics
Thanks!
how can high sea purchase & import purchase be entered in Tally ERP
Please refer below link:-
https://help.tallysolutions.com/tallyweb/modules/pss/crm/kb/search/CKBTallyHelpSearchWIC.php?strEventID=9&productID=&docLink=te9rel60/Tax_India/gst/import_goods_6.0.3.htm&docTitle=Recording%20the%20Import%20of%20Goods%20under%20GST%20(Valid%20From%20Release%206.0.3)&search_type=1&strSearchString=Recording%20the%20Import%20of%20Goods%20under%20GST%20(Valid%20From%20Release%206.0.3)&strSCIframeName=&strInvokedFromSupportCentreFlag=
There is link in the blog about how to file GSTR 1. In offline tool when trying to upload the GSTR1 prepared by tally in excel format it shows error. The format of tally excel sheet & offline tool are different. In tally Party details & HSN code details are on one page where as in offline there is seprate sheet for the HSN Code. Then there is one sheet where in you have to explain all the details of unit of measurement. No such detail is being made in tally GSTR 1
Please advice
Please try our preview release which is available on https://tallysolutions.com/gst-preview-release-6-1/
Also, we recommend you not try with live data as of now. Install it on a different drive.
Can GSTR1 be filed using Tally ERP 9 version 6.0.3 ???? And if yes how ????
When will full release for GSTR1 be made available ????
Please provide some phone number for Tally support. We have been trying the toll free number 18002008859 for past 1 month but no one answers.
We suggest you to contact our support team at support@tallysolutions.com
Sir how to treat Inter-State Unregistered Dealer Purchases in GST? How to Compute the Tax Liability? Whether it should be CGST + SGST (or) IGST.
We have been purchasing Sand and Blue Metals from TAMILNADU (from unregistered dealers) to PUDUCHERRY works. Most of them are Unregistered Dealers. Our FIRM is a registered dealer in PUDUCHERRY.
We are generating SELF INVOICE for this kind of Inter-State Unregistered Dealer purchases. Tally ERP 9 treats this as CGST + SGST purchase. Is it correct? We are in a dilemma that how to treat this kind of purchases.
Please guide us.
Thanking You.
Unregister Dealer CANNOT do inter state transaction. He has to be registered even if his turnover is less than 20 lacs for doing inter-state sales.
What’s price
For Single User License it’s 18000/- + Taxes.
For buying online visit
https://tipl.tallysolutions.com/tallyweb/modules/sd/docmgmt/COnlineOrderNewEntryWIC.php
When available Tally.ERP 6.1 Release
We have released Preview yesterday, you can experience it by visiting below site
http://blogs.tallysolutions.com/file-gstr-1-using-tally-erp-9/
Can GSTR1 be filed using Tally ERP 9 version 6.0.3 ???? And if yes how ????
When will full release for GSTR1 be made available ????
Please provide some phone number for Tally support. We have been trying the toll free number 18002008859 for past 1 month but no one answers.Please call us on 9769558290
For GSTR-1 we recommend you to update to Release 6.1, whose preview is available on our website. We strongly recommend as of not to do on live data.
For preview release refer below link.
https://tallysolutions.com/gst-preview-release-6-1/