Hello kids, if you have a lot of bills in GST and if you
are not in a position to feed the invoice in R1 one by one,
then using offline utility, we can upload all the bills in
one go on GST site and make the complex process of our
return filing easier.
In this video, we are going to show you how to upload all
the bills in one go on GST.
Friends, this will only work when your number of bills is
very high and you are not able to enter them one by one.
So in this case, you don't have to do anything, just go to
gst.gov.in website as you can see on your computer screen.
And here you can see the Downloads tab, click on this
Downloads.
Two pop-ups will come below, one offline tool and one GST
statistics.
Ignore this, go to offline tools and click on the first
option, Returns Offline Tool.
And friends, here you will get an option to download,
extract and run the Returns Offline Tool to collect and
upload the invoices and other data in offline mode.
Currently, this tool is available only for GST R1 and R2.
Good news for GST R1, this tool is available.
If you click on the download button, you will have a
utility download.
If you click on the download button, you will have two
options, Cancel and Proceed.
Click on Proceed.
The utility will be downloaded below.
You can see that the utility has been downloaded below.
Now you have to save this utility somewhere on your desktop.
The utility that has just been downloaded, please save it
somewhere on your desktop.
We have saved this utility on our desktop.
And after saving, we extracted it.
I will show you what we got by extracting.
Let's start.
You will be able to extract.
I hope you all know how to extract.
So, friends, this is how we entered the GST Offline Tool.
After extracting, all these files come to us.
1, 2, 3, 4, 5, 6, 7.
There are about 7 files.
Some are folders, some are PDFs.
Some are in the format of an application.
So, first of all, you have to pay attention to number 3,
where GST Offline Tool is written.
Which is an application.
You have to install it in your system.
You need to install this application in your system.
Double click on it.
It will ask for Yes and No in the pop-up.
Click Yes.
After that, a small pop-up setup will open.
Something like this.
Click Next.
Click Install.
After that, click Next.
It will be installed completely.
Wait until it is installed.
This is it.
Preparing to install.
Please wait while window configuration node.js
Let him do whatever he wants.
The computer is doing what it wants.
And now, shortcut icon has been created on your desktop.
It is written like this.
Sir, show us how it is written.
I'll show you.
Let me show you.
How will the pop-up come in front of you.
Click Finish on this.
What you see right now.
You will get a notification like this.
Shortcut icon has been created on your desktop.
Please double click the icon to launch the offline tool.
Click OK on this.
And it says, dear children, go to the desktop.
And you will get an icon on the desktop.
Sir, that icon will be in the name of GST Offline Tool.
It will be written on it.
One Nation One Tax Market.
Double click it and open it.
And when we double click it and open it.
It will open something like this.
As you can see on your computer screen right now.
It will open something like this.
What do you have to do in this?
Upload new invoice.
Other data for return.
The first option is to click on New.
And here we are teaching you to file GST R1.
GST returns will remain GST R1.
GST of supplier.
Whose GST returns are filling up.
Whose bills are too much.
You have to put the details of that.
What is the seller here?
Whose sales bills do you upload?
So I upload this client here.
After that, I selected the financial year.
I took July in the tax period of 23-24.
Latest now.
Is SCJ Taxpayer?
No.
Is Taxpayer Quarterly Filer?
If you file quarterly.
GST R1.
Then take Yes.
Otherwise, take No.
It is a little annoying here.
In this, you select.
No in both.
It will be a little difficult.
Click again and again.
Then finally click on Yes or No.
Okay Sir.
Then ask you one more thing.
Is aggregate turnover greater than 5 crores in previous
financial year?
If there is a turnover of more than 5 crores in the
previous financial year.
Then say Yes.
Otherwise, say No here.
And then finally.
You click on the Proceed tab.
Look at this.
It is cooking again in Yes or No.
It cooks a little.
It has a habit.
Then click on Proceed.
Okay Sir.
After that, we will say Yes to the warning.
We will confirm the details.
And see.
Let me remind you again.
I don't have to enter anything manually here.
Nothing has to be entered manually.
Here too.
Now you have to click on Import Files.
You have to click on Import Files.
And here in the Select section.
The first option to select is B2B SCZ.
Okay Sir.
After that, Sir.
You have to import it on the file of Import Excel.
You have to do some further work.
Which I am going to tell you now.
Okay Sir.
How will this CSV file be made?
Or this Excel that we have to import.
Whatever options are coming.
How will its further work be?
Let's see.
Sir.
In the very beginning, we had made a folder on the desktop.
If you remember.
In which those 7 files were downloaded.
Yes Sir.
You have to go back there.
Okay Sir.
We came back there.
In this, you have to click on Section-Wise CSV Files.
Click on Folder 1.
Two folders will come in it.
Click on GSTR 1.
And in this, 1, 2, 3, 4, 5.
The fifth file is B2B SCZ DE.
Double click on it.
Click on OK.
And this type of file will open in front of you.
As I am going to show you now.
This type of file.
Excel file will open in front of you.
In this way.
Excel file will be open.
What do you have to do here?
Receiver name, invoice number, invoice date, invoice value,
place of supply.
You have to enter some details.
You have to feed up some details.
In the name of the receiver.
Name of the receiver.
Invoice number.
Invoice date.
Invoice value.
Place of supply.
With state code.
As it is supplied in Haryana.
I have written 06 before Haryana.
Reverse charge, no.
Applicable tax rate, 18.
Invoice type, regular B2B.
Business to business transaction.
E-commerce, GSTN.
If it is of the opposite party,
Then write.
Otherwise, leave it empty.
Rate, 18%.
Then, taxable value.
If it is in the bill, then write.
Otherwise, write 0.
Similarly, all bills here.
Feed up all bills.
Ok Sir.
We will feed up all bills.
No problem.
OK Sir.
I'll tell you what will happen next.
Sir, keep one thing in mind.
Don't change any text size or format
After entering all the files
You have to save this excel file as csv
Click on file and save as
In save as type, type csv, delimited
Now you have to go back to the same utility
Where we were working earlier
Sir, show me where to go
Here, ok sir
Click on import excel
Import the file
Click on yes
Success return details added
Click on view summary
Sorry friends, we were importing csv file
Click on import csv
Are you sure you want to save data
If there is any error, it will tell you
Otherwise, it will generate your data
Now we have an error
We will read out the error
We will import the file again where we will try to upload
it again ok
friends, after correcting the error if you will upload csv
again it will show upload success, you have to click on
view summary button after view summary, all your data will
come like summary and there will be a button on the side of
generate generate, after clicking on generate a json file
will be generated and we have kept it on the desktop that
how that json file will be seen I will take it to the json
folder and keep that json file where all other things were,
come let us show how that json
will be, see here the file on the second number, this type
of json file will be generated here this file now you have
to upload it there in the concerned month, on the client
portal, on the gst portal will go, will log in and whatever
month's data you are sitting here by feeding up, will go in
that month
I will show you by logging in once
see here you have to log in the supplier, the supplier data
you have put you have to log in that, so let us go on gst,
let us go there
this time you have to go to services, returns in the return
dashboard you have to select concerned month and sir
prepare offline will be visible here, prepare offline,
click on this and here you have to choose that json file
and upload it here and here you have to choose that json
file and upload it here wherever you have put that json
file bring that json file from there and upload it here,
you can see your json file has been uploaded successfully
it can take 15 minutes, please revisit
you will come after 15 minutes, you will find that yes this
update has been done, after that you do not have to do
anything, all the details have been uploaded through otp
save on summary, then proceed to file then do the
verification through otp you have to do the same work in
the future so this was through offline utility you can
upload a lot of bills like this
I would like to give you an advice for this the bills you
are making, along with them make a detail in excel so that
when we import that excel utility we just have to copy and
paste you have the record in excel which we have made
mandatory to teach you we will meet in the next clip, thank
you bye bye and take care