How to File GSTR 1 through Offline Utility | How to prepare JSON for GST Return Filing

Поделиться
HTML-код
  • Опубликовано: 7 сен 2024
  • 📍In this video we have discuss how to file GSTR 1 through offline method with the help of JSON. As you might be aware GST department has already provided many offline utilities/software to file GST Return. In this session we have explain in detail how to use Utility for filing GSTR 1 and how to prepare JSON.
    Join our courses - fintaxpro.in/c...
    📚Books i refer for GST
    👉Taxmann’s GST Ready Reckoner - amzn.to/3mIYOTG
    👉Taxmann's GST Practice Manual - amzn.to/38DGS4R
    👉GST Bare Act (Updated) - amzn.to/3gJEg9K
    👉Taxmann's GST on Works Contract & Real Estate - amzn.to/2V0KxX6
    📚Books i refer for Income Tax
    👉Practical Approach to Income Tax (Dr. Girish Ahuja) - amzn.to/38op9Ox
    👉Income Tax including Tax Planning & Management (Updated) - amzn.to/3yvtj1H
    👉TDS with Advance Tax and Refunds (Taxman) - amzn.to/3Bl5AmE
    👉Direct Taxes Ready Reckoner - amzn.to/3zoroxb
    📩Personal Consultancy - teamfintaxpro@gmail.com
    📞 +91 97180 97735 (CA Rajat Garg, Partner Fintaxpro Advisory LLP)
    Disclaimer- Although all provisions, notifications, updates and live demo are analyzed in-depth by our team before presenting to public. We hereby provide our point of view only and Tax matter are always subject to frequent changes hence advisory is only for the benefit of general public. Hence neither Fintaxpro Advisory LLP nor its designated partner are liable for any consequence arises on the basis of You Tube videos.
    #offlineGST #JSONforGSTR
    📽Studio Gear
    👉Mic Used - Boya BYM1 amzn.to/38cQBye
    👉Mic 2 - Rode Lavalier Go Pro amzn.to/37wDadl
    👉Tripod - Amazing Goods 7 feet amzn.to/3imexDW
    👉Webcam/Live Stream cam - Logitech C922 Pro amzn.to/34rdRaH
    👉Main Camera - iphone rare cam amzn.to/3nxCSbz
    👉Laptop - Lenovo ideapad S145 amzn.to/2KD295I
    👉Writing Pad - ipad 8th Gen amzn.to/2WulLvu
    🎞Post Production & Editing System
    👉CPU - AMD RYZEN 2700X amzn.to/3ali9El
    👉Motherboard - Gigabyte X570 amzn.to/2J0UcXx
    👉RAM - 16 GB DDR4 Corsair amzn.to/3nxFnKZ
    👉SSD - Kingston 250gb amzn.to/3p4B1LR
    👉Graphics Card - RTX2060 ZOTAC 6gb amzn.to/3aBPMSD
    👉Monitor - BENQ 27” amzn.to/38gFkx1
    Post Production Software’s
    👉Editing Software - Adobe Premier Pro 2020, Adobe After Effects 2020
    👉Thumbnails - Adobe Photoshop 2020
    This video also help you in below Topics-
    gstr 1 offline tool
    gstr 1 offline return
    gstr 1 offline tool error
    gstr 1 offline utility new version
    gstr 1 offline error
    gstr 1 offline tool download
    gstr 1 offline upload json file
    gstr 1 offline return filing in tamil
    gstr 1 offline return filing
    gstr 1 offline tool demo
    gstr 1 offline excel sheet
    gstr 1 offline excel utility download
    gstr 1 return filing offline error
    error in gstr 1 offline utility
    gstr 1 return filing offline in english
    gstr 1 offline filing
    gstr 1 offline filing process
    gstr 1 return filing offline excel
    gstr 1 return filing offline tally
    offline tool for gstr 1
    file gstr 1 offline utility
    how to gstr 1 offline tools
    gstr 1 return filing offline in hindi
    gstr 1 return offline filing in hindi
    gstr 1 return filing offline json
    filing gstr 1 offline
    gstr 1 return filing offline in malayalam
    filing of gstr 1 offline
    gstr 1 prepare offline
    gst r1 offline
    gstr 1 offline return filing youtube
    gstr 1 return filing offline tool
    gstr 1 offline tool not working
    gstr 1 offline tool not opening
    gstr 1 offline tool youtube
    gstr 1 offline tool excel
    gstr 1 offline utility
    gstr 1 offline utility not working
    gstr 1 offline utility error
    gstr 1 offline upload error
    gstr 1 offline upload procedure
    gstr-1 offline filing
    gstr 1 return filing offline 2019
    how to gstr 1 file offline
    how to gstr 1 offline tools
    gstr 1 offline tool
    gstr 1 offline filing
    gstr-1 offline filing
    gstr 1 offline tool error
    filing gstr 1 offline
    gstr 1 working
    gstr 1 offline return
    gstr 1 offline return filing
    gstr 1 using offline tool
    gstr 1 return offline filing in hindi
    gstr 1 return filing offline
    gst r1 offline
    gstr 1 through offline utility
    gstr 1 offline tool download
    gstr 1 offline tool demo
    gstr 1 offline tool excel
    gst offline tool gstr 1
    gstr 1 filing offline tool
    gstr 1 offline utility
    gst offline utility gstr 1
    gstr 1 offline utility new version
    file gstr 1 offline utility
    offline utility for gstr-1 for upload of invoices
    gstr 1 return filing offline utility
    error in gstr 1 offline utility
    gstr 1 excel offline utility
    how to download gstr 1 offline utility
    gstr 1 through offline utility
    gstr 1 offline utility
    how to use gstr 1 offline utility
    how to upload gstr 1 offline utility
    how to use gstr 1 offline utility
    gst offline utility gstr 1
    offline utility for gstr-1 for upload of invoices
    gstr 1 through offline utility

Комментарии • 143

  • @FinTaxPro
    @FinTaxPro  3 года назад +3

    📍Certificate Course by Fintaxpro Advisory LLP
    📚GST Practical Course - bit.ly/3qv1gwJ
    📚ITR Filing Course - bit.ly/2JZaRuB

  • @HCA108
    @HCA108 3 года назад +15

    I'm wondering what is there to dislike... Some ppl are never happy. I feel like I've joined internship under him 😃. He is sharing every detail in his videos. Thank you dear...

    • @FinTaxPro
      @FinTaxPro  3 года назад +1

      Thanks for you kind words 😇

    • @vikflair
      @vikflair 3 года назад

      those could be his competitors...

  • @woldyworld-fashionablevlog1378
    @woldyworld-fashionablevlog1378 Год назад +2

    This error show when filling GSTR 1 from gst utility
    Section B2B, SEZ, De
    Possible Reason.
    .Please check the spreadsheet , Either all rows have invalid data or the wrong section filed is copied/uploaded
    Notes : Please upload the data of the selected selection only. If using copy excel button, please ensure that you copy header along with the data.

  • @ghazirizvi6388
    @ghazirizvi6388 3 года назад +2

    Dear Sir,
    Your Video is really Imp. to us.
    Thank U Sir.

  • @kiranjain3755
    @kiranjain3755 Год назад

    This video was really helpful for me..... I was so confused & googled a lot of things ..... but I got answer for all my queries here ❤

  • @pravesh9631
    @pravesh9631 3 года назад +1

    Ur video is very important in my accountant job

  • @AmitKumar-mg9zj
    @AmitKumar-mg9zj 5 месяцев назад

    Thank you so much sir , Aapne bahut achchhe se samjhaaya hai 🙏🙏

  • @beingmanish3951
    @beingmanish3951 8 месяцев назад

    This video is Really Helpful for me . Thanks for making this type of video..keep it up

  • @pankajpal957
    @pankajpal957 3 года назад +1

    Thank you sir for offline gstr 1 file video and also thank you for online video and gstr 1 and 3b format given in Dropbox very helpful form me return filling great job sir

    • @FinTaxPro
      @FinTaxPro  3 года назад +1

      Glad it helps :)

    • @pankajpal957
      @pankajpal957 3 года назад

      Sap tutorial available hai sir

    • @pankajpal957
      @pankajpal957 3 года назад

      Sir Kya mai aap se phone se bat kr skta hu

    • @pankajpal957
      @pankajpal957 3 года назад

      Please send me mobile no

  • @mirza4742
    @mirza4742 3 года назад +3

    Sir please make video on how to file "GSTR1" with "COMPUGST" Software , I like your videos ❤️ , it's very knowledgeable and help me a lot .

    • @FinTaxPro
      @FinTaxPro  3 года назад

      Sure i will try to make it soon

  • @siddharthgoyal1313
    @siddharthgoyal1313 2 года назад

    Bhot Bhot Bhot Accha Sir Good Explanation with Good Quality

  • @vikflair
    @vikflair 3 года назад +2

    Well done.. just as it should be explained..

  • @samsar785
    @samsar785 2 месяца назад

    For out of 62 B2C, 54 were uploaded in the portal and about the rest you said those were zero rated transactions. Do you mean cancelled transactions for 62-54=6 transactions?

  • @user-wc9yr6wc5m
    @user-wc9yr6wc5m 9 месяцев назад

    Wa sir ji maza aa gaya

  • @pravesh9631
    @pravesh9631 3 года назад +3

    I am proud of u☺

  • @SurajYadav-lt8df
    @SurajYadav-lt8df 5 месяцев назад

    Hello sir ek question hai gst offline utility ko lekr
    Jaise hmare pass ek invoice hai jisme tax rate 5,12,18 teno rate ka tax lga hai to us case me tax rate kaise dalenge

  • @1552009mahesh
    @1552009mahesh 2 года назад +2

    Thank you sir. Very well explained.

  • @majjiaravind9292
    @majjiaravind9292 Год назад

    I'm getting following error "Error! The system is checking on compliance for Form DRC-01B. Please click on 'Generate summary' again after few seconds". Please help

  • @sandeepkamble9922
    @sandeepkamble9922 3 года назад +1

    Want to say thank you to you dil se🙏

    • @FinTaxPro
      @FinTaxPro  3 года назад

      Glad you like it Sandeep Ji 😊

  • @BillingSoftwareGuru
    @BillingSoftwareGuru 2 года назад

    Very Nice Explanation Sir.

  • @dumarigautam7314
    @dumarigautam7314 3 года назад +1

    Thanks you sir knowledge for offline utility

  • @Amitkumar-ws1eq
    @Amitkumar-ws1eq 3 года назад +2

    Sir 1 question h
    Ex- jese ek invoice no h 001 jisme 5% , 12%, 18% ka item h to usko excel me kese dalna h kyuki 3 baar invoice no daal ke karne par ye leta nhi h please bataiye🙏

  • @vinayagarwal7274
    @vinayagarwal7274 3 года назад

    Great n nice explained in details for off line thanks

  • @lavanya_a
    @lavanya_a 2 года назад

    Thankyou. It helped me a lot in filing ❤️

  • @fatemapresswala5023
    @fatemapresswala5023 Год назад

    Excellent teaching 🔥🔥🔥we love it keep growing

  • @shrutijadhav2100
    @shrutijadhav2100 2 года назад

    Hi sir I had download the gstr poratl office line tool but i can't modify the b2b cvs exel

  • @rajveerprajapati136
    @rajveerprajapati136 Год назад

    Sir EXPORT without payment of GST ki summary ko bhi HSN wise show karana hoga kya?.... Kyuki isme gst ka amount to exist nhi karta

  • @ambikagupta7810
    @ambikagupta7810 8 месяцев назад

    Sir agar ek invoice m alag alag rate h toh utiltm kaise show hoga vo please bataeye

  • @heyachanshi
    @heyachanshi Год назад

    Sir i need to file gst returns for a client who has online sales through various platforms like Amazon, Flipkart and site sale.. now when i make json of that data..then in view summary i find some amount of cgst and sgst in igst, and vice versa...how can i resolve that? Please help with the issue

  • @PriyaSingh-nr8kr
    @PriyaSingh-nr8kr 6 месяцев назад

    sheet shown is in protected mode? how to unlock protect workbook

  • @ranadeep7462
    @ranadeep7462 Год назад

    I am facing problems
    File could not be uploaded! Download the latest version of Offline tool to generate the JSON file or ensure to validate your uploaded file against the template published at Specification Portal.

  • @poojapooja-mc6ic
    @poojapooja-mc6ic 4 месяца назад

    Hello sir... Agar mein bills offline tool ke through upload karke baad mein GSTR1 file karne se pehle kuch mistakes hogayi ho toh.... Aur mein manually bills upload karna ho toh reset option use kare toh Jo mein json upload Kiya tha ho complete delete ho jayega kya?????

  • @rajeshmane3354
    @rajeshmane3354 Год назад

    Very valuable information given sir

  • @A_Vision_Of_Mind
    @A_Vision_Of_Mind 11 месяцев назад

    Sir 5 number column me taxable amount mynus me kyon dikhaya hai aapne ? -193.21 koi Karan hai kya?

  • @VijaySingh3434
    @VijaySingh3434 2 года назад

    I failed to file GSTR1 on due date and now its showing error. I want to file NIL return for the month of July 2022.
    "Error! Summary for Filing is not Generated or is not available at this time. Please try again later."
    can u please help me with this.

  • @ajayrao9521
    @ajayrao9521 3 года назад +1

    Sir your are right

  • @ecom3019
    @ecom3019 2 года назад

    i need to upload .xml file for filling after due date itr 4 ay 2020 2021. so which offline utility can be used to produce .xml file

  • @ig__mirza
    @ig__mirza 2 года назад

    Sir me jab portal pe gst 1 file krri thi to achanak se system logout hogaya and login hone k nad summary automatically generate hogayi

  • @sanjuaugust
    @sanjuaugust Год назад

    if the same has both rate of tax how to fill in B to B csv file

  • @anithapn6950
    @anithapn6950 Год назад

    Good evening sir, when i create an account in this portal is it orginal? Because this is only for educational purpose.

  • @ShambhuKumar-mg4lg
    @ShambhuKumar-mg4lg 2 года назад

    Dear Sir,
    Plz
    Guide me. GSTR 1 filling offiline one party and multiple tax Rate how to file GSTR 1

  • @saadjsayed
    @saadjsayed 3 года назад +3

    How to input the invoice in the utility if it had multiple products and rates?

    • @MAHESHPATEL-zz6bo
      @MAHESHPATEL-zz6bo Год назад

      If saime invoice insert A.. B C.. Before Bill nomber un excel

    • @saadjsayed
      @saadjsayed Год назад

      @@MAHESHPATEL-zz6bo I used to do that but now I file it directly through GSTR 1 utility and not CSV

  • @kashishvijay7136
    @kashishvijay7136 Год назад

    Thanks a lot sirji

  • @srushtipagar2992
    @srushtipagar2992 2 года назад

    While uploading the excel file in offline gst portal through one section at time the portal isn't showing b2cs option what should I do?

  • @geniusrahul6960
    @geniusrahul6960 Год назад

    thank You Sir.

  • @rajeshbajoria6268
    @rajeshbajoria6268 Год назад

    great tutorial ..thanks

  • @mohammednazim5540
    @mohammednazim5540 2 года назад

    Thanks for the explanation

  • @vaishavirishabhprakash3098
    @vaishavirishabhprakash3098 3 года назад

    Thank you . Would like to know how to put multi tax in GSTR1 CSV FILE?

  • @Geetaupnisad
    @Geetaupnisad 2 года назад

    Error data invalid show when i try to do same. What is the issue sir

  • @divyashetty8287
    @divyashetty8287 3 года назад +2

    Great explanation.. Thank you sir 🤝🤝🤝... How and from where do we have to download the CSV files?

    • @FinTaxPro
      @FinTaxPro  3 года назад +1

      Go to GST portal - Downloads- offline utility zip
      You will get the CSV files in zip folder

    • @divyashetty8287
      @divyashetty8287 3 года назад

      @@FinTaxPro Ok.. Thank you sir🤝🙏😊

  • @bhaskard7831
    @bhaskard7831 3 года назад

    What should i do for multiple rate of tax for singal invoice

  • @amit70607
    @amit70607 2 года назад

    excellent presentation. Very useful.

    • @FinTaxPro
      @FinTaxPro  2 года назад

      Glad it was helpful!

  • @pankajkumarthakur6198
    @pankajkumarthakur6198 2 года назад

    Nice video.....

  • @rehankhan-iq2mj
    @rehankhan-iq2mj Год назад

    Utility working sheet kaise banti hai jisme state daalo to state code ke saath name aa jata hai

  • @shrikantpise8436
    @shrikantpise8436 2 года назад +1

    Thanks sir ji 🙏🙌👍😊

  • @kaushalvermaofficial
    @kaushalvermaofficial 3 года назад +1

    Very helpful

  • @aparanha1275
    @aparanha1275 Год назад

    CSV file kaise JASON ban gaya ??? To filling GSTR 1 ya CSV file nahi toh JASON file upload hoga na Ji ???

  • @computech2020
    @computech2020 3 года назад +1

    Agar mera sales April me hogaya hai our uska filing be hogaya hai then customer ne muje july me goods return karta hai due to not sold then gstr1 july me kya karna hoga credit not or amendment

  • @Rj_Roahan_07
    @Rj_Roahan_07 2 года назад

    Sir main ak accounting ka job krta hu but mujhe gstr1 aur gst3B bharna nahi aata hai please help me

  • @prashant_singhh
    @prashant_singhh 2 года назад

    Superb sri

  • @hamamasti
    @hamamasti 2 года назад +1

    Sir, mujhe yeh bataiye ki jab e-commerce seller ka data liya hai to offline utility me b2cs me apne OE kyu select kiya. OE matlab to other than e-commerce hota hai na.
    Please clear it.

  • @vijayshetty1666
    @vijayshetty1666 3 года назад +1

    How can I upload different tax rates for same invoice number in excel? If I try to upload then it's shows duplicate invoices entered

    • @FinTaxPro
      @FinTaxPro  3 года назад +2

      Add a number/figure after invoice
      For example if invoice no is 50 than enter as below
      50
      50_a
      50_b

    • @tarkeshwargupta7162
      @tarkeshwargupta7162 3 года назад

      @@FinTaxPro what about number of invoices issued in documents issued table?

  • @birjeshchaturvedi5295
    @birjeshchaturvedi5295 2 года назад

    Useful information

  • @aakashverma0226
    @aakashverma0226 Год назад

    Thnx for the help 🙂

  • @HamadYamani-gg9ym
    @HamadYamani-gg9ym 2 месяца назад

    Nice sir

  • @komalagarwal9582
    @komalagarwal9582 3 года назад +1

    Is CompuGst also good? is it included in the course....should i learn that

    • @FinTaxPro
      @FinTaxPro  3 года назад +1

      CompuGST is good but for course we use only government Utilities and portal.

  • @laxman8475
    @laxman8475 2 года назад

    SIR, B2B GENERATE KARTE SAMAY AGAR TAX RATE DIFFERENT HAI TOH KY KARE

  • @pravesh9631
    @pravesh9631 3 года назад +1

    Thanks sir

  • @ayyappaguntakala1639
    @ayyappaguntakala1639 3 года назад

    Sir, make videos on income tax TDS return and payment.

  • @aparanha1275
    @aparanha1275 Год назад

    Kya ji kaise pada rahe hai !!!CSV suru kar ke achanak JASON file pe kaise chala gaya... totally confused matter ban gaya ji 😢 Concepts clear karen please 🙏

  • @danjoshi2501
    @danjoshi2501 3 года назад +1

    Hey I've Seen Your Review on Amazon. So I came here to check. Can you please let me know... Are you using C922 Pro in this Video ?

    • @FinTaxPro
      @FinTaxPro  3 года назад

      No Rohit
      This video is from my mobile camera with 4k recording. I use C 922 pro only for Live sessions. You can check the facecam of our live sessions for C 922 quality.

    • @FinTaxPro
      @FinTaxPro  3 года назад

      Refer this live session for C 922 pro quality ruclips.net/video/KGEg-78JGdg/видео.html

    • @danjoshi2501
      @danjoshi2501 3 года назад

      How is it for meetings on zoom and streamings?

    • @FinTaxPro
      @FinTaxPro  3 года назад

      It works fine in both.

  • @subhashkumarsrkgl3594
    @subhashkumarsrkgl3594 Год назад

    Thanku you

  • @govindchouhan4533
    @govindchouhan4533 3 года назад +1

    Thanks boss

  • @mahirshaikh8971
    @mahirshaikh8971 3 года назад +1

    Sir ek hi invoice m different rate hoto kese kare sheet m ???

    • @FinTaxPro
      @FinTaxPro  3 года назад

      Invoice number thoda sa change kar do

    • @mahirshaikh8971
      @mahirshaikh8971 3 года назад

      @@FinTaxPro same invoice number s Chad raha h ab mene try kiya new update m so hogaya

  • @kansingh5968
    @kansingh5968 3 года назад +1

    Nice

  • @shanthamallesh7163
    @shanthamallesh7163 3 года назад +1

    Tq Sir

  • @kansingh5968
    @kansingh5968 2 года назад

    Nice video

  • @vipingujjar7929
    @vipingujjar7929 3 года назад +1

    Sir Kya aap professional accountant ka course bhi karate Ho please reply

    • @FinTaxPro
      @FinTaxPro  3 года назад

      📍Certificate Course by Fintaxpro Advisory LLP
      📚GST Practical Course - bit.ly/3qv1gwJ
      📚ITR Filing Course - bit.ly/2JZaRuB

  • @NadeemAnsari-yq6yc
    @NadeemAnsari-yq6yc 3 года назад

    how to do for quarterly

  • @arungupta99
    @arungupta99 3 года назад

    HOW TO CHANGE STATE NAME WITH STATE WITH CODE IN RAW FILE?

  • @abhinavpandey3022
    @abhinavpandey3022 Год назад

    Applicable tax column mein 65% kab ayega kab nhi

  • @manish8329
    @manish8329 2 года назад

    IS IT MANDATE TO UPLOAD GSTR 1 AND GSTR 2? YA SIRF GSTR 3 AND GSTR 1 HI UPLOAD KARNA HOTA HAI

    • @FinTaxPro
      @FinTaxPro  2 года назад

      Only GSTR 1 & GSTR 3B

  • @manish8329
    @manish8329 2 года назад

    AREY DADA, WHAT IS LARGE INVOICE AND SMALL INVOICE, YE TO BATA DO

    • @FinTaxPro
      @FinTaxPro  2 года назад

      GSTR 1 ki overview wali video check kijiye please

  • @jsrjhamitrawat
    @jsrjhamitrawat Год назад

    Jai shree ram... Jai shree hanuman baba... 🍎🚩🚩🚩🚩🚩🚩

  • @Rj_Roahan_07
    @Rj_Roahan_07 2 года назад

    Main apse sampark Krna chahta hu please help me sir

  • @otgyt-ls3bh
    @otgyt-ls3bh 3 года назад

    wah bhai

  • @SurajGupta-gr5lu
    @SurajGupta-gr5lu 3 года назад

    GST EXCEL FORMAT! SHARE PLEASE

  • @sharanarjunagi7821
    @sharanarjunagi7821 2 года назад

    Bhai video clear nahi hai, thod close se clear dikaya to acha hoga

  • @onlinetrading1198
    @onlinetrading1198 2 года назад

    Sir invoice number toh dala hi nhi

  • @omkarpatil5437
    @omkarpatil5437 Год назад

    Sir apka contact number

  • @theacademy188
    @theacademy188 3 года назад

    Superb explanation, thank you so much

  • @smithaej3766
    @smithaej3766 2 года назад

    Well explained thank you

  • @Sumit-dixit
    @Sumit-dixit 3 года назад +1

    Thank you Sir

  • @timplesharma795
    @timplesharma795 2 года назад

    Thanks bro

  • @otgyt-ls3bh
    @otgyt-ls3bh 3 года назад

    very helpful

  • @rohitt2245
    @rohitt2245 3 года назад +1

    Thanx 🙏

  • @kasikasi8796
    @kasikasi8796 3 года назад

    Thanku sir

  • @gauravsharma19393
    @gauravsharma19393 2 года назад

    Thank you✌

  • @rahulrajendran6141
    @rahulrajendran6141 3 года назад +1

    Thanks bro