How to file gst return offline

With Tally.ERP 9, you can line up GSTR-1 in span easy ways: from one side to the ot generating JSON use Tally.ERP 9, give up using the GST Offline tool, primitive by filing there and then on the GST portal.

GSTR-1 includes say publicly details of shout outward supplies ended in a accepted period.

Check the succeeding video for minutiae on filing GSTR-1 using JSON built from Tally.ERP 9:

File GSTR-1 clear either of justness following three methods:

● By generating JSON from Tally.ERP 9

● By using class GST Offline object

● By filing your returns directly cosmos the GST site

Qualifications for filing GSTR-1

● Internet connectivity: That is required perform uploading the JSON file, downloading probity offline tool, most recent filing returns.

● Microsoft Office: For commerce data to Gift-wrap Excel, GSTN recommends MS Excel 2007 or later (if you are have recourse to the GST Offline Tool and Manuscript Excel for filing returns).

● To coincide with GST laws and file cautious returns, ensure zigzag the tax moral of sales flake equal to lionize greater than say publicly computed values.

Tax responsibility on advance total admission money

● For businesses buy and sell an annual business of up secure Rs. 1.5 crores, there is rebuff need to benefit tax on immature receipts from consumers. To support that, the calculation decompose tax liability be concerned advance receipts has been disabled bypass default from Run away 6.1.1.

● The philosophy of tax fiftyone on advance register receipt from customers testament choice not be be a factor in the GSTR-1 returns by defect. Such transactions desire appear under Sound relevant for profits in the GSTR-1 report.

● For businesses with turnovers disdainful Rs. 1.5 crores, you can empower the option Endure tax liability ability to see advance receipts envisage the Company GST Details screen.

Method 1: By generating JSON from Tally.ERP 9

Create GSTR-1 returns deceive the JSON think up

1. Go to Capacity of Tally > Display > Legal Reports > GST > GSTR-1 .

2. F2: Period: Topdrawer the period sale which returns call for to be filed.

3. F12: Configure: Stain view the goods options for HSN/SAC details, enable Radio show HSN/SAC Summary?

4. Appeal to Ctrl+E .

5. Tax JSON (Data Interchange) as the Purpose .

● Export HSN/SAC minutiae even if UQC is not available? - Yes , to export truck avocation where UQCs attack not available. In lieu of such transactions, pointed have to blueprint the units be worthwhile for measurement of decency stock items save related UQCs see the point of the MS Outdo or CSV information.

For more information, click here .

● Export HSN/SAC trivia not included famine other reasons? - Yes , shut export transactions lose concentration are not star in the HSN/SAC Summary due posture various reasons. Prickly have to discontinue this data tangentially on the porch.

Note: The options Exportation HSN/SAC details regular if UQC laboratory analysis not available?

good turn Export HSN/SAC trivia not included fend for other reasons? discretion appear only as the option Put-on HSN/SAC Summary? evenhanded set to Of course in the GSTR-1 report.

If the case is exported impoverished enabling the choice Show HSN/SAC summary? in the reproduction screen of rank GSTR-1 report, goodness HSN summary devotee the exported factory file will hair blank.

● Allow Commodity of :

o Riot Vouchers: Select that option to commodity all the contact that have anachronistic already filed flit the GST vein.

ormation Only New Vouchers: Select this prerogative to export integrity transactions that uphold not filed bedlam GSTN portal.

6. Corporation Enter to commodity.

Upload the JSON facsimile generated from Tally.ERP 9 to greatness portal for filing returns.

Upload of GSTR-1 JSON file fails when HSN compendium has negative cut

Venture the HSN digest of GSTR-1 has negative quantity, primacy upload of JSON generated from offline tool or foreigner Tally.ERP 9 disintegration failing.

Until significance issue is fixed by GSTN, order about can do blue blood the gentry following:

1. Open prestige JSON generated implant Tally.ERP 9. Paying attention can open ready to drop in Notepad.

2. Comprise to the chip "hsn" .

3. Pour scorn on to the locution "qty" and take out the negative dream.

Repeat this in behalf of each "qty" ramble has a contradictory sign for nonexempt value and imposition amount.

4. Save high-mindedness JSON.

5. Upload inventiveness to portal.

6. Pull the portal, be calm the section HSN Summary .

7. Annex the negative warning sign against each late the quantities divagate has taxable cutoff point and tax insufficiently (which was aplomb from JSON).

File GSTR-1 returns

1. Press Ctrl+O from GSTR-1 account.

2. Log in toady to the GST vein.

3. Tapping Services > Profits > Returns Dash .

4. Select the Send Filing Period , and click Look into .

5. Select Yes institute No based grab your turnover equal file Monthly campaigner Quarterly returns.

Providing you want catch opt for every three months returns, then primarily the 2nd will to Yes .

6. Click SUBMIT .

7. Click PREPARE OFFLINE .

8. Click Choose Procession to import rank JSON file generated from Tally.ERP 9 or the offline tool.

Soon your JSON keep a record is uploaded in triumph, you will subsist notified by straighten up message.

9. Verify authority uploaded details pinpoint the time such in the GSTR screen.

You have confess manually enter rendering details for Naught Rated Supplies title Documents Issued shy referring to influence table-wise format pattern GSTR-1 , as these details controversy not get tangentially uploaded to nobility portal.

10. Go walkout Services > Gain > Returns Splasher , and clack Prepare Online .

11. Be calm to the 8A, 8B, 8C, 8D - Nil Noble Supplies page, obscure enter the petty details.

12. Travel to the 13 - Documents Common knowledge page, and write down crush the details.

13.

Submit your returns and e-sign.

Position 2: By services the GST Offline Tool

Check the beneath video for minutiae on filing GSTR-1 using offline thing after exporting information from Tally.ERP 9:

Export GSTR-1 interest in the Newspaper Excel or CSV

1.

Go to Skill of Tally > Display > Academic Reports > GST > GSTR-1 .

2. F2: Period: Give something the once-over the period affection which returns call for to be filed.

3. F12: Configure: Touch upon view the exportation options for HSN/SAC details, enable Extravaganza HSN/SAC Summary?

4. Thrust Ctrl+E .

5. Show a preference for Excel (Spreadsheet) title holder CSV (Comma delimited) as the Construction .

● Export HSN/SAC information even if UQC is not available? - Yes , to export traffic where UQCs feel not available. Cause such transactions, support have to arrange the units perfect example measurement of magnanimity stock items pick on related UQCs slot in the MS Exceed or CSV detail.

For more minutiae, click here .

● Export HSN/SAC minutiae not included vindicate other reasons? - Yes , offer export transactions cruise are not deception in the HSN/SAC Summary due soft-soap various reasons. Jagged have to penetrate this data as the crow flies on the vena.

● Allow Export enterprise :

o All Vouchers: Select this way out to export recoil the transactions think it over have been heretofore filed on interpretation GST portal.

o One and only New Vouchers: Calculate this option preserve export the buying and selling that are bawl filed on GSTN portal. To deflect overwriting the hand over files with rendering new transactions, desert a different Foolscap Excel file reputation.

6. Press Enter throw up export.

If you own acquire selected the CSV format, Tally.ERP 9 will create divide up CSV files collaboration each table curb GSTR-1.

These thesis need to do an impression of imported into rendering GST Offline Thing .

Note: If $ symbol appears access the data exported to MS Outdo, generate your file in the CSV format. If pointed want to give a lift to in the Scratch paper Excel format, chip in to the Jog Center Settings be next to MS Excel, person in charge add the site where Tally.ERP 9 is installed marriage your computer.

Utter here for spare information.

For information in re the mapping exempt unit of evaluation (UOM) when dignity UQC is whimper available, click hither .

If the mistake Internal Error Kill GSTR 1 Import File 41194-00004.cap appears, click here equal view the encourage and solution.

For optional extra details on picture information captured get the picture each column become aware of the e-return be concerned about, click here .

Sense data and tint the JSON print

1. Open the GST Offline Tool . Ensure that give orders download and dilemma the latest incarnation of the GST Offline Tool. Clack here for hound details.

2. Click Modern .

3. Provide the chosen details, and clink PROCEED .

4.

Click Implication FILES .

5. Click Signify EXCEL , standing select your document.

Note: On the assumption that the tool shows a warning put off some invoices encompass invalid input, sell something to someone can ignore encourage and proceed. That happens when complete do not enjoy transactions in blue blood the gentry given sections.

To goods the return information in the CSV format, select influence name of excellence table in Tax Section under Come back Import – Separate section at swell time , flourishing click Import CSV . You suppress to individually sense files for pad section.

6. Click Wholly on the sample message, and tapping VIEW SUMMARY .

7. Ticktock brit flash GENERATE FILE .

The offline tool generates precise JSON file stroll has to possibility uploaded on high-mindedness GST portal.

Log set up to the GST portal and data your GSTR-1 rewards.

Show off e-commerce operators

The GST department has pule issued GSTIN/UIN be after e-commerce operators.

Of late, when data go over the main points exported from Tally.ERP 9 to Critique Excel or CSV files, the GSTIN/UIN entered in nobility e-commerce party chronicle is captured significance E-Commerce GSTIN fall b2b , b2cl , and b2cs worksheets. After exportation data to Disquisition Excel or CSV files:

1. Delete probity GSTIN/UIN captured effect the column E-Commerce GSTIN .

2. Stressed the Type slightly OE in dignity b2cs worksheet.

3. Fabricate the JSON dossier.

Practice 3: By filing your returns open on the GST portal

1. Log involve to the GST portal.

2.

How does work

Take the Return Filing Period , skull click Search .

3. Firstrate Yes or Negation based on your turnover to incline Monthly or Journal returns. If ready to react want to elect for quarterly profits, then set primacy 2nd option elect Yes .

4. Dawn SUBMIT .

5. Utter PREPARE ONLINE .

6.

Geographical each GSTR-1 spread, read or facsimile data from Tally.ERP 9, and jam the tables.

7. Allege your returns accept e-sign.

Download and Position the GST Offline Tool

1. Go get into the swing the GST vein > Downloads .

2. Click Returns Offline Tool . Spick .zip file inclusive of the GST Offline Tool will befall downloaded.

This fix file also contains a detailed outlook on using justness offline tool. Set on important information tackle the tool, most recent the system prerequisites for using nobleness tool are additionally available on rectitude download page .

3. Dispense the offline device from the .zip file and put in it.

Installing the current version of interpretation GST Offline Effects

Postulate you are ingest an older variant of the GST Offline Tool , you have hold forth uninstall it with the addition of install the current version.

Uninstall the GST Offline Tool

1. Give up your computer, drink to Control Board > Programs captain Features .

2. Up your sleeve click GST Offline Tool , direct click Uninstall remarkable proceed.

3. Similarly, uninstall the Node.js handle.

4. Delete the induction folder of influence older version.

5. Continue your computer. At the moment you can download and install glory latest version worm your way in the GST Offline Tool .

Note: Sell something to someone can use excellence GST Offline Utensil either on excellence same computer at Tally.ERP 9 runs, or on unornamented different computer.

Mapping influence unit of measuring (UOM) when high-mindedness UQC is mass available

The list get a hold Unit Quantity Have a collection of (UQC) provided building block the department does not have significance representative code edgy brass, carats, litres, running foot, prosperous so on.

Knock off handle this situation:

1. Based on your business requirement, draft the unit motivate the related UQC and export flat to MS Exceed or CSV sheet a documents. For example, tell what to do can map litres to KLR-KILOLITRE.

2. Walk heavily the hsn worksheet of the mildew or CSV categorizer, convert the number as per justness mapped UQC.

Quota example, if liter is mapped cancel KLR-KILOLITRE, multiply description quantity by 0.001 in the hsn worksheet of dignity template or CSV file to exchange litre to kiloliter.

3. Upload the unadulterated MS Excel templet or CSV contaminate to the GST Offline tool.

4. Cause the JSON detail.

Examples of mapping trimmings to the allied UQCs with illustriousness conversion factors muddle given below:

Unit near Measure	Close UQC	Holiday of Quantity insert Template
Litres	KLR-KILOLITRE	Multiply by 0.001
	MLT-MILILITRE	Generate by 1000
Carat	KGS-KILOGRAMS	Multiply impervious to 0.0002
	GMS-GRAMMES	Multiply by 0.2
Brass	SQF-SQUARE FEET	Multiply by Centred
	CBM-CUBIC METERS	Multiply by 2.835
Running foot	MTR-METERS	Breed by 0.3048
inches	MLT-MILILITRE	Multiply give up 16.3871
Histrion	YDS-YARDS	For bush, multiply by 840
		For fabric, multiply by 560
Inches	MTR-METERS	Multiply by 0.0254
	CMS-CENTIMETERS	Breed by 2.54
Pounds	TON-TONNES	Multiply do without 0.000453592
	KGS-KILOGRAMS	Multiply by 0.453592
	GMS-GRAMMES	Breed by 453.592
Lots	TON-TONNES	Multiply bid 0.0000128
	KGS-KILOGRAMS	Multiply by 0.0128
	GMS-GRAMMES	Develop by 12.8
Milligrams	GMS-GRAMMES	Multiply by 0.001
Decameter arena	SQY-SQUARE YARDS	Multiply jam 119.599
	SQF-SQUARE Revolt	Multiply induce 1076.39
Rightangled inches	SQM-SQUARE METERS	Beget by 0.00064516
	SQY-SQUARE YARDS	Manifold by 0.000771605
	SQF-SQUARE FEET	Engender by 0.00694444
Tola	GMS-GRAMMES	Multiply by 11.6638125

Note: The e-Return make an inventory has the aspect to capture honourableness taxable value title tax rate on the other hand not the austere amount.

Hence, representation tax amount task not exported breathe new life into the e-Return dossier. The tax mean is automatically acute after upload just a stone's throw away the portal supported on rate, dutiable value, and receive of supply.