GSTR 1 | How to file GSTR 1 using JAVA supported Excel format (GSTR 1 Offline Utility) Part -A

GSTR 1 | How to file GSTR 1 using JAVA supported Excel format (GSTR 1 Offline Utility) Part -A

GSTN portal provided GSTR1 offline utility in order to upload date in specified format which support java utility on GSTN portal and you can feed your data offline and than upload the same in one go at GSTN portal www.gst.gov.in. I show you here the details which you have to keep in my mind while uploading data for your GSTR 1.
Below are Instruction of GSTR 1 Offline Utility:-
The Offline tool comes bundled with MS Excel Template and a java tool.
This Excel workbook template has 11 data entry worksheets, 1 master sheet and 1 Help Instruction sheet i.e. total 13 worksheets. The 11 data entry worksheets are named: b2b, b2cl, b2cs, cdnr, cdnur exp, at, atadj, exemp, hsn and doc in which day-to-day business transaction required to be reported in GSTR 1 can be recorded or entered by the taxpayers. At desired interval, the data entered in the MS-Excel worksheet can be uploaded on the GST Portal using the java offline tool which will import the data from excel workbook and convert the same into a Json file which is understood by GST portal. (www.gst.gov.in)
It has been designed to enable taxpayers to prepare GSTR 1 in offline mode (without Internet). It can also be used to carry out bulk upload of invoice/other details to GST portal.
The appearance and functionalities of the Offline tool screens are similar to that of the returns filing screens on the GST Portal.
 Approximately 19,000 line items can be uploaded in one go using the java tool. In case a taxpayer has more invoice data, he can use the tool multiple times to upload the invoice data.

My Smart home channel link:
https://www.youtube.com/channel/UCnB-gg8-_UEvytau8QD1EwQ

To download GST Excel Template file click below:-
https://www.gst.gov.in/download/returns
for GST registration process than click below:

For checking your GST registration status click below:

For GST Planning and Implementation doubts click below video:

Mail us at learnandstyle@gmail.com

IProducts I use for video recording and more, Link to buy are below. Please click:
Budget Mike for Audio recording:
1) http://amzn.to/2xb0FVh
2) http://amzn.to/2xrGOAy
Generic 57000928MG Silica Gel Professional Condenser Microphone Mic Sound Studio Recording Dynamic (Works with Phantom Power Supply Or Sound Card Only)
http://amzn.to/2x9fsmq

iball Rocky with mike, headphone and speakers:
http://amzn.to/2vnISYy
http://amzn.to/2g35Hix
Budget Cemeras:
1) http://amzn.to/2xbyvZY
2) http://amzn.to/2xbjCqL
DSLR: http://amzn.to/2w1UMJB
Redme note 4 (xiaomi)
http://amzn.to/2g3kn14
Coolpad Cool 1 (Gold, 3GB RAM + 32GB memory)
http://amzn.to/2eDXBc6
Coolpad Note 5 (Royal Gold, 32 GB)
http://amzn.to/2xNig5T
Camera Stands:
http://amzn.to/2xNB9FE
http://amzn.to/2eDdH5y

Mini Tripod:
memore Mini Tripod Universal YT-228 For Digital Camera & All Mobile Phones- Black (YT-228 Tripod)
http://amzn.to/2xO1Av2
Laptops:
Lenovo Ideapad 320E 80XH01GKIN 15.6-inch Laptop (6th Gen Core i3-6006U/4GB/1TB/FreeDOS/Integrated Graphics)
http://amzn.to/2f1WZgQ
HP HP 15 HP Notebook 15-BS549TU 2017 15.6-inch Laptop (Celeron N3060/4GB/500GB/Windows 10 Home Single Language(64 bit)/Integrated Graphics), Jet Black
http://amzn.to/2xNK4XW
Desktop:
Lenovo 510S-08IAP 90GB000QIN 21.5-inch All-in-One Desktop (Intel Core i3 7th Gen/7100/4GB/1TB/DOS/Integrated Graphics) LED IPS Monitor:
http://amzn.to/2xNepWm
Tegh Computers Complete Desktop Computers Intel Core 2 Duo/2 GB/160 GB/15 Inch Led
http://amzn.to/2xNk4Md

Please Like, Share and Subscribe
Love
Pooja

Thanks for watching

Team
Learnandstyle
LOL

Shares 0

50 Comments

  1. After filing B2B worksheet do we need to fill HSN sheet also. Is that mandatory?

  2. kindly show us the complete filing

  3. EXCEL SHEETS DOWNLOADED BUT THEY ARE IN WINZIP I DO NOT HAVE WINZIP THEN HOW TO GET THESE EXCEL FORMATES OF GSTR1

  4. In B2B, we have to mention the RATE and it says, "Enter the combined (State tax + Central tax) or the integrated tax, as applicable."

    If, in a particular invoice there are all four tax rate 5,12,18 & 28 then what should be done??

  5. Thank you Mam

  6. Kindly explain where should i make the entries for my sale to sez units. In b2b or in exports or in both. My sale to sez is without igst as per the igst notificstion 64/2017

  7. Nil rate gst vale bills bhi B2B(4) Me upload krne hai Kay?

  8. Excel file toh password protected hai. Password kaha se laye?

  9. sale sirf cutomer ko diya ho sirf b to c wala form fill up krenge na baki khali rehnedenge..

  10. mam composit party ki sale kis head me likhenge b2b ya b2cs

  11. one includes two tax rate what to do .pls

  12. should gstr 3 tax amount and gstr1 tax amount should b same..?? 140/- difference is coming is it ok..??

  13. please muze Revers charges GSTR1 me kaha offline sheet pe kaha or kaise fill karna hai

  14. Excellent tutorials Madam.Many thanks for sharing your knowledge.Can you please explain how to upload Excel file GSTR1 created using ctrl+E from Tally .The tally format does not match the department format it seems.As my invoices have multiple tax items on single invoice I prefer uploading complete excel file created using Tally.

  15. Voice sound so poor

  16. drop down is not working of this worksheet in office 2007 excel . do you have any solution ? Thanks for your video tutorial by the way. my mail id is surajitsahaballb@gmail.com

  17. Where to file debit note and credit note given to URD under 2.5lakhs intra state and interstate

  18. Difference between invoice value and taxable value, cess amount,reverse charge please video ….

  19. mam gstr2 live demo di ji a

  20. Supose one invoice in diffrent rate than how to select rate in java suported exceel sheet

  21. MAM PLZ EXPLAIN UNREGISTERED EXEMPT PURCHASE

  22. voice quality is so poor

  23. HOW TO USE OFFLINE TOOL OF GSTR-1 FOR UPLOADING SAME INVOICE HAVING 3 RATE OF TAX ITEMS??

  24. Mam please see the example of b2b invoice value and taxable value does not match

  25. Where to fill – Credit/ Debit Notes/Refund vouchers issued to the unregistered persons against invoice value is less than Rs 2.5 lakh? There no such option in all 11 forms.

  26. What is cess amount in b2cs? Is it the GST tax applicable on taxable value column?
    Is it like for an amount 200 and rate 5%, cess is 10 Rs? Or does it signify something else?

  27. mam Yeh excel sheet main 8,000. aise likhle se chalega yea nhi,,.phir 8000 likhna padta hai

  28. if receipient in within state and place of supply is outside State then which tax will be charged IGST OR CGST AND SGST

  29. good evening, ek invoice me agar 5% , 12% & 18% ho to entry kaise karna hai ? kyuki me ne ratewise entry ki to error aa raha he ki duplicate "invoice no". Please help.

  30. Hello mam,
    In few of my interstate sales invoices, auto calculation of IGST comes 0.01 or 0.02 paisa more or less. In the ledger of IGST, rounding method is done "not applicable". After editing myself manually the correct tax figure, ALT+A TAX ANALYSIS REPORT SHOWS LIKE THIS " AS PER TAX ANALYSIS SAY 100.01 & AS PER TRANSACTION IS 100.03".
    UN GSTR 1, IT IS THE SAME WHAT I EDITED.
    PLEASE HELP, WHAT TO DO.?

  31. Migrated from vat to gst & wrongly opted composition scheme ..What is the procedure to shift in Normal scheme now

  32. Difference between invoice value and taxable value

  33. if in one invoice there are different items at different rates how will we enter in excel utility

  34. unable enter data in gstr1

  35. in case of b2cs there is no column for invoice value then how taxable value will come.. ??? please reply asap

  36. harishgudha5@gmail.com
    plz send me excel utility for trans-1

  37. Error file is not getting downloaded. Where I have to chk & download.

  38. How to fill up GSTR-1 B2B when 2 different tax charged in single bill for example 1st is visiting card 12% and 2nd is leaflet 5%

  39. I had generat json file by off line tool but this file don’t uploading on portal message showing an error encountered uploading file

  40. B2cs me unreg. Ki exempt sale to show nahi karni hogi

  41. HOW TO SHOW PARTY NAME AND GST CLASSIFY IN EXCEL SHEET

  42. dear sir you show the video how to upload gstr-1 from tally to gst portal step by step clearly with a dummy example

  43. plz make a video on offline uploading of gstr 1 and uploading of invoices .
    if already made than provied link
    thanks
    looking your early response

  44. Hello Mam,

    For exporters B2C- in other countries, they dont have gstn. How to manage this

    Please let me know the gstr 1 excel ormat for b2c foregin export and invoice format

  45. mam, please tell me in GSTR-1 where I will put the details(B2B, B2C or any other place) of RCM details for unregister person(whose GST No. not present) by which we can get ITC.- kbanerjee65@gmail.com

  46. warm regards ma’m. we will b grateful if u show how a retail pharmacy will fill return (offline or online) pls. Notable point are:
    1. sell at MRP inclusive of tax
    2. sell in small value invoices to multiple B2C which include products of diff HSN and diff tax categories.
    3. may sell B2B to corporates as credit bill at MRP, giving discounts.

  47. mam inward supply liable to reverse charge ki detail isme jayegi?

  48. Do you have a video for ecommerce related gst entries? Things like rates reverse charges etc….thank you

  49. Hi Mam,
    Please btaye retail or cash sales ko kha par mention kare…??

  50. If you find this helpful than please like, share and subscribe.Please support our other channels as well: My Smart Home: https://www.youtube.com/channel/UCnB-gg8-_UEvytau8QD1EwQ Love Pooja

Comments are closed.