# GSTR 1 Data Preparation Using Clear Sales Template
{% stepper %}
{% step %}
Launch the Clear GST software from the Clear Compliance Cloud launchpad to access the dashboard of the Clear GST software.
{% endstep %}
{% step %}
Click on the **GSTR1** option located under the Filing section.
{% endstep %}
{% step %}
Select the relevant GSTN from the dropdown menu.
{% endstep %}
{% step %}
Choose the return period by selecting the appropriate date.
{% endstep %}
{% step %}
Click on **Continue** to proceed to the next step.
{% endstep %}
{% step %}
Activate the GST by updating the GSTN credentials. If you choose to skip this step, click on **Skip**.
{% endstep %}
{% step %}
Click on **Prepare Data** to move forward to the data preparation options.
{% endstep %}
{% step %}
Check the **Import file** option that is already available for importing the data necessary for filing GSTR1.
{% endstep %}
{% step %}
Select the **Clear sales template** for downloading. Once you click on it, the template will download automatically.
{% endstep %}
{% step %}
Open the downloaded Clear sales template. Here, you'll find various headers. We'll focus on identifying which headers are essential and which are optional.
{% endstep %}
{% step %}
Review the **invoice details** section in the template. The first column is the **document type code**, where you specify the type of document, such as an invoice, credit note, or debit note.
{% endstep %}
{% step %}
Enter the **document date**. This should be the date on which the document or invoice was created.
{% endstep %}
{% step %}
Add the **document number**. This is a unique identifier for the document.
{% endstep %}
{% step %}
Although not mandatory, including the **recipient's billing name** is recommended.
{% endstep %}
{% step %}
If it's a B2B (business-to-business) transaction, enter the **recipient's billing GSTN number**. For B2C (business-to-consumer) transactions or those with foreign countries, this is not required.
{% endstep %}
{% step %}
Choose the **place of supply** from the dropdown menu. This helps in determining the applicable tax jurisdiction.
{% endstep %}
{% step %}
Identify if the item is a good or service.
{% endstep %}
{% step %}
Select the item type from the **drop-down menu**.
{% endstep %}
{% step %}
Enter the item description, HSN code, quantity, and unit of measurement.
{% endstep %}
{% step %}
Again, select from the **drop-down menu**.
{% endstep %}
{% step %}
Enter the item price and discount. If a discount is applicable, mention it; otherwise, leave it blank.
{% endstep %}
{% step %}
Enter the taxable amount and GST rate.
{% endstep %}
{% step %}
Note that the CGST Rate, SGST Rate, and IGST Rate amounts are important fields but do not require manual entry. When you import your Excel template, these values will be auto-calculated based on the taxable amount, GST rate, and place of supply.
{% endstep %}
{% step %}
From the beginning up to the GST rate, update all the headers that are mandatory or relevant for you. The CGST, SGST, and IGST rates or amounts will auto-calculate.
{% endstep %}
{% step %}
From the reason for issuing a credit note to the end, note that there are multiple headers available, but all are optional. Specify them only if certain criteria are applicable to your documents; otherwise, leave them blank.
{% endstep %}
{% step %}
If you need to specify a reason for issuing a credit note, select the reason from the drop-down menu.
{% endstep %}
{% step %}
If the note is for a pre-GST invoice, select 'Yes' if applicable.
{% endstep %}
{% step %}
If not applicable, you may leave it blank or specify this in the document.
{% endstep %}
{% step %}
If your document is a bill of supply, define it as 'Yes'.
{% endstep %}
{% step %}
Select the category—nil rated, exempted, or non-GST item—from the drop-down menu.
{% endstep %}
{% step %}
If the item does not fall under the bill of supply, leave it blank.
{% endstep %}
{% step %}
This indicates that it is not applicable to you.
{% endstep %}
{% step %}
Lastly, check if the reverse charge is applicable to you. If yes, mark it accordingly; otherwise, leave it blank.
{% endstep %}
{% step %}
Determine if the section is applicable for your situation, specifically if you are exporting goods. If it applies, select Y; if not, leave it blank.
{% endstep %}
{% step %}
Choose the type of export from the dropdown menu.
{% endstep %}
{% step %}
Enter the Shipping port code.
{% endstep %}
{% step %}
Input the Shipping bill number.
{% endstep %}
{% step %}
Fill in the Bill date and related details.
{% endstep %}
{% step %}
Verify if GST, TDS, or IDT has already been deducted. If deducted, select Y; if not applicable, leave it blank.
{% endstep %}
{% step %}
Enter your GSTN if you're filing the return. This field is optional.
{% endstep %}
{% step %}
Optionally fill in the recipient's billing address, city, and state.
{% endstep %}
{% step %}
Check if the document is cancelled. If cancelled, select Y; otherwise, leave it blank.
{% endstep %}
{% step %}
Determine if this is a composition, dealer, or UIN registered. If applicable, select the appropriate option from the dropdown; if not, leave it blank.
{% endstep %}
{% step %}
Review other headers and fill them as applicable, leaving them blank if they do not apply.
{% endstep %}
{% step %}
Determine if the invoice is part of a previously filed return. If it is, you will need to fill out a specific segment.
{% endstep %}
{% step %}
Select the filing month and the quarter from the dropdown menu.
{% endstep %}
{% step %}
If you need to declare an amendment to the invoice, this segment becomes important. Enter the original document date, document number, and original GST number for the amendment.
{% endstep %}
{% step %}
Review other available headers that are not required for GSTR1 filing but are provided for comprehensive record maintenance from an enterprise perspective.
{% endstep %}
{% step %}
Update information under relevant headers on the left side, or leave them blank if they do not apply to your situation.
{% endstep %}
{% step %}
For fields like GST rate, CGST, SGST, and IGST rate or amount, you can leave these blank as they will be auto-calculated.
{% endstep %}
{% step %}
Observe all the headers provided. If certain criteria apply to your documents, specify them under the respective headers. Otherwise, leave them blank.
For any doubts while preparing the data, refer to the explanation sheet provided. This will clarify which headers are mandatory and which are optional.
{% endstep %}
{% step %}
Prepare your data using the appropriate template. You can choose either the Clear Sales Template or the Government Template depending on your needs.
{% endstep %}
{% step %}
Click on Select a file to import and choose the Excel sheet from your system. Ensure the sheet has been properly selected.
{% endstep %}
{% step %}
Select the relevant GSTN number and the corresponding return period for your data.
{% endstep %}
{% step %}
Choose the template. Select Clear Tax Sales Template if you are using the Clear option. For government-related templates, select accordingly.
{% endstep %}
{% step %}
Click on Check File for errors and duplicates. This will help identify any discrepancies or errors in your data. Rectify any issues found before proceeding.
{% endstep %}
{% step %}
After corrections, click on Prepare Data. This action will process your data based on the previously ingested documents and prepare your entire GSTR-1 form automatically.
{% endstep %}
{% step %}
To view the documents you've processed, click on Data Overview.
{% endstep %}
{% step %}
For sales data, click on Sales and select the GSTN.
{% endstep %}
{% step %}
Select the relevant Return period for which you want to review the documents.
{% endstep %}
{% step %}
Review the documents ingested for the month. You can view all the documents processed during this period.
{% endstep %}
{% step %}
If you need to open or edit any specific document, you have the option to do so.
{% endstep %}
{% step %}
Select the document you want to work with.
{% endstep %}
{% step %}
If you need to perform multiple activities at the same time, proceed as follows.
{% endstep %}
{% step %}
For instance, if you want to download a document, select the document as shown.
{% endstep %}
{% step %}
Choose whether to download a detailed report or a summary report, delete the document, or hide certain columns for a clearer view.
{% endstep %}
{% step %}
If you need to apply these actions to multiple documents simultaneously, you can manage that as well.
{% endstep %}
{% step %}
View filter information such as the number of documents, rows, total document value, and taxes like CGST, SGST, and IGST based on the existing documents.
{% endstep %}
{% step %}
Check additional details like data ingestion history and delete history. If necessary, restore documents from this interface.
{% endstep %}
{% endstepper %}
This method allows you to handle various document-related tasks efficiently, using either a clear template or a government template, as discussed in this session. This tutorial also covered the data overview section, which helps you view all ingested documents and perform necessary operations on them.
