How to File GSTR 1 through Offline Utility | How to prepare JSON for GST Return Filing
Vložit
- čas přidán 6. 09. 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
📍Certificate Course by Fintaxpro Advisory LLP
📚GST Practical Course - bit.ly/3qv1gwJ
📚ITR Filing Course - bit.ly/2JZaRuB
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...
Thanks for you kind words 😇
those could be his competitors...
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.
Thank you so much sir , Aapne bahut achchhe se samjhaaya hai 🙏🙏
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🙏
Mera bhi same problem hai.!
You got any reply?
ANY SOLUTION FOUND ???
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 .
Sure i will try to make it soon
Dear Sir,
Your Video is really Imp. to us.
Thank U Sir.
Glad it helps 😊
Ur video is very important in my accountant job
Glad it helps 😊
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 ❤
This video is Really Helpful for me . Thanks for making this type of video..keep it up
Bhot Bhot Bhot Accha Sir Good Explanation with Good Quality
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
Glad it helps :)
Sap tutorial available hai sir
Sir Kya mai aap se phone se bat kr skta hu
Please send me mobile no
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
Wa sir ji maza aa gaya
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?
Thank you sir. Very well explained.
Glad you like it
I am proud of u☺
Well done.. just as it should be explained..
Glad you like it
How to input the invoice in the utility if it had multiple products and rates?
If saime invoice insert A.. B C.. Before Bill nomber un excel
@@MAHESHPATEL-zz6bo I used to do that but now I file it directly through GSTR 1 utility and not CSV
Very Nice Explanation Sir.
Dear Sir,
Plz
Guide me. GSTR 1 filling offiline one party and multiple tax Rate how to file GSTR 1
Thanks you sir knowledge for offline utility
Always welcome
Great explanation.. Thank you sir 🤝🤝🤝... How and from where do we have to download the CSV files?
Go to GST portal - Downloads- offline utility zip
You will get the CSV files in zip folder
@@FinTaxPro Ok.. Thank you sir🤝🙏😊
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.
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
Sir agar ek invoice m alag alag rate h toh utiltm kaise show hoga vo please bataeye
if the same has both rate of tax how to fill in B to B csv file
Great n nice explained in details for off line thanks
sheet shown is in protected mode? how to unlock protect workbook
Want to say thank you to you dil se🙏
Glad you like it Sandeep Ji 😊
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
Thankyou. It helped me a lot in filing ❤️
Sir 5 number column me taxable amount mynus me kyon dikhaya hai aapne ? -193.21 koi Karan hai kya?
Hi sir I had download the gstr poratl office line tool but i can't modify the b2b cvs exel
Thank you . Would like to know how to put multi tax in GSTR1 CSV FILE?
Excellent teaching 🔥🔥🔥we love it keep growing
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
Very valuable information given sir
Thanks a lot sirji
Good evening sir, when i create an account in this portal is it orginal? Because this is only for educational purpose.
What should i do for multiple rate of tax for singal invoice
Sir your are right
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?
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.
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.
Already replied
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
thank You Sir.
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?????
Utility working sheet kaise banti hai jisme state daalo to state code ke saath name aa jata hai
Is CompuGst also good? is it included in the course....should i learn that
CompuGST is good but for course we use only government Utilities and portal.
great tutorial ..thanks
Thanks for the explanation
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
Add a number/figure after invoice
For example if invoice no is 50 than enter as below
50
50_a
50_b
@@FinTaxPro what about number of invoices issued in documents issued table?
Sir, make videos on income tax TDS return and payment.
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 ?
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.
Refer this live session for C 922 pro quality czcams.com/video/KGEg-78JGdg/video.html
How is it for meetings on zoom and streamings?
It works fine in both.
Thanks sir ji 🙏🙌👍😊
Welcome
SIR, B2B GENERATE KARTE SAMAY AGAR TAX RATE DIFFERENT HAI TOH KY KARE
excellent presentation. Very useful.
Glad it was helpful!
Nice video.....
Very helpful
Glad it helps 😊
Sir Kya aap professional accountant ka course bhi karate Ho please reply
📍Certificate Course by Fintaxpro Advisory LLP
📚GST Practical Course - bit.ly/3qv1gwJ
📚ITR Filing Course - bit.ly/2JZaRuB
Error data invalid show when i try to do same. What is the issue sir
Sir ek hi invoice m different rate hoto kese kare sheet m ???
Invoice number thoda sa change kar do
@@FinTaxPro same invoice number s Chad raha h ab mene try kiya new update m so hogaya
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
Credit note
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
Superb sri
Thnx for the help 🙂
Nice sir
Thanks sir
CSV file kaise JASON ban gaya ??? To filling GSTR 1 ya CSV file nahi toh JASON file upload hoga na Ji ???
Useful information
Thanku you
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 🙏
HOW TO CHANGE STATE NAME WITH STATE WITH CODE IN RAW FILE?
Sir main ak accounting ka job krta hu but mujhe gstr1 aur gst3B bharna nahi aata hai please help me
Thanks boss
Always welcome 😊
Tq Sir
Always welcome 🙂
how to do for quarterly
Nice
Glad you like it
Jai shree ram... Jai shree hanuman baba... 🍎🚩🚩🚩🚩🚩🚩
Applicable tax column mein 65% kab ayega kab nhi
Nice video
IS IT MANDATE TO UPLOAD GSTR 1 AND GSTR 2? YA SIRF GSTR 3 AND GSTR 1 HI UPLOAD KARNA HOTA HAI
Only GSTR 1 & GSTR 3B
AREY DADA, WHAT IS LARGE INVOICE AND SMALL INVOICE, YE TO BATA DO
GSTR 1 ki overview wali video check kijiye please
wah bhai
Bhai video clear nahi hai, thod close se clear dikaya to acha hoga
Main apse sampark Krna chahta hu please help me sir
GST EXCEL FORMAT! SHARE PLEASE
Sir invoice number toh dala hi nhi
OPtional
Sir apka contact number
Superb explanation, thank you so much
Well explained thank you
Thanks bro
Thank you Sir
Welcome
very helpful
Thanx 🙏
Always welcome
Thanku sir
Thank you✌
Thanks bro
Welcome