GSTR-1 Report

Gstr1 (1)

GSTR-1 Report

GSTR-1 is a monthly or quarterly return that should be filed by every registered dealer. It contains details of all outward supplies (sales). The return has a total of 13 sections. Businesses with sales of up to Rs. 1.5 Cr has an option to file a quarterly return. Other taxpayers with sales above Rs. 1.5 Cr have to file monthly return.

GSTR-1 Report in ACCOXI

ACCOXI is the most modern accounting software that provides easy and deliberate results for accounting. It provides the module of Reports and it consists of various heads of reports like Payables, Receivables, Accounts, Purchase, sales, etc. GSTR-1 Report is available in GST Reports head. The report helps the user to get the filing status of GSTR-1 for a particular GSTIN. The monthly GSTR-1 report helps a user stay up-to-date with the real-time status of all GSTR-1 returns for any particular GSTIN. This report helps the taxpayer to keep and maintain track of his returns filed and helps to avoid GST notices. When the user opens the ACCOXI account, the Reports module will appear on the bottom left side of the modules. Click on the Reports module, it opens to various financial reports of the Organization. There are various heads of reports like Payables, Receivables, Accounts, GST Reports, Customer payments, Supplier payments, purchase, sales, etc.

Gstr1 (2)

Click on the GST Report head and select the option GSTR-1. By clicking on the Time to Get Paid option, summary details will popup on the screen. 

Gstr1
GSTR-1

GSTR-1 report helps the user get the filing status of GSTR-1 across a selected period. The invoice level or summary level information of the filed data is made available for the user’s study.

Gstr1report

           Fields

                                    Description

Customize Report

 Customize reports enable the user to filter the details. By clicking on the customize report, the user can filter the report by date between. 

User can filter the details by using the option Date in the customize menu. By clicking the by date option, need to enter the starting date along with the end date, and then the GSTR-1 details will appear based on the date entered. 

By clicking on Run Report, users get the customized report based on data entered. 

 

Print

If the user wants to take the print out of the report, it can be done by using the menu Print on the top right side of the page. When the user clicks on the print menu, it opens to Report page and it contains the details regarding the print.                          

User needs to export the data to Excel format and can set the page range, page height, width and can enter the required number of copies here. By clicking on the Print button,the user gets the print out of time to get the payment details report.                       

There are different tables and sections included in GSTR-1. Each one is meant to capture a particular aspect of sales and outward supplies made under GST. GSTR-1 contains 13 tables in which the outward supplies details needs to be captured. Based on the nature of the business and the nature of the supplies effected during the month, only the relevant tables are applicable, not all. Following are the format of GSTR-1.

A.Summary for B2B (4)

B2B 4 SUMMARY

B2B means business to business transactions. In this transaction, the customer is also a registered person and is eligible to take ITC. For B2B supplies, invoice wise details of both intra-state and inter state supplies are recorded in GSTR-1 report.

It displays the Total number of recipients, Number of invoices, Total invoice value, Total taxable value and Total CESS details on the top side of the form. It shows the complete details of recipients such as GSTIN/UIN of Recipient, Receiver name, Invoice number, Invoice date, Invoice value, Place of supply, Reverse charge, Applicable % of tax rate, Invoice type, E-commerce GSTIN, Rate, Taxable value and CESS amount.

B.Summary For B2CL(5)

B2CL means Business to Consumer transactions where the transaction is inter state and invoice value is more than 2,50,000.  In B2CL transactions, the consumer is an unregistered dealer and is not eligible to take ITC. In these transactions invoice wise details of inter state supplies with invoice value exceeding Rs 2,50,000 to be recorded in GSTR-1 report.

B2CL SUMMARY

It displays the Total number of invoices, Total invoice value, Total taxable value and Total CESS details on the top side of the form. It shows the complete details of transactions such as Invoice number, Invoice date, Invoice value, Place of supply, Applicable % of tax rate, E-commerce GSTIN, Rate, Taxable value, Sale from bonded WH, and CESS amount. 

C.Summary for B2CS(7)

B2CS SUMMARY

B2CS means Business to a Consumer transaction. In B2CS transactions, the consumer is an unregistered dealer and is not eligible to take ITC. For these transactions, consolidated details of intra-state sales with invoice value up to Rs 2,50,000 for each rate of tax recorded in GSTR-1 report.

It displays the Total taxable value and Total CESS details on the top side of the form. It shows the complete details of transactions such as Type of supply, Place of supply, Applicable % of tax rate, E-commerce GSTIN, Rate, CESS amount and Taxable value.

D.Summary for CDNR (9B)

CDNR displays the details of table for Credit/Debit Notes (Registered) 9B of GSTR-1 report. Credit/Debit notes/Refund vouchers issued to the registered taxpayers during the tax period. Debit or Credit note issued against invoice will be reported here against original invoice.

CDNR SUMMARY

It displays the Total number of recipients, Number of invoices, Number of notes/vouchers, Total note/refund voucher value, Total taxable value and Total CESS on the top side of the form. It shows the details of GSTIN/UIN of recipient, Receiver name, Invoice/advance receipt number, Invoice/advance receipt date, No of notes/vouchers, Note/refund voucher date, Document type, Place of supply, Note/refund voucher value, Applicable % of tax rate, Rate, Taxable value and CESS amount.

E.Summary for CDNUR (9B)

CDNUR displays the details of table for Credit/Debit Notes (Un-Registered) 9B of GSTR-1 report. Credit or Debit notes/Refund vouchers issued to the un-registered tax payers against inter state invoice value is more than 2,50,000.

It displays the Number of notes/vouchers, Number of invoices, Total taxable value and Total CESS on the top side of the form. It shows the details of UR type, Invoice/advance receipt number, Invoice/advance receipt date, No of notes/vouchers, Note/refund voucher  value, Note/refund voucher number, Note/refund voucher date, Document type, Place of supply, Note/refund voucher value, Applicable % of tax rate, Rate, Taxable value and CESS amount.

CDNUR SUMMARY

F.Summary for Exp (6)

Exp means Export supplies including supplies to SEZ/SEZ Developer or deemed exports. It displays the number of invoice, total invoice value, Number of shipping bill and Total taxable value on the top side of the form. It shows the complete export details such as Export type, Invoice date, Invoice number, Invoice value, Port code, Shipping bill number, Applicable % of tax rate , Rate, Taxable value and CESS amount. 

EXP 6 SUMMARY

G.Nil rated, Exempted and Non GST Outward supplies (8)

NIL RATED SUMMARY

Table 8 of the GSTR-1 report contains the details of Nil rated, Exempted and Non GST supplies made during the tax period. It displays the Total Nil rated supplies, Total exempted supplies, Total Non-GST supplies on the top side of the form. It shows the supply details of Nil rated and Exempted (Other than Nil rated/Non GST supply).

H.Summary for HSN (12)

HSN12

HSN (12) contains the details of HSN wise summary of goods/services supplied during the tax period. It displays the HSN details of Total number of HSN, Total value, Total taxable value, Total integrated tax, Total central tax, Total state/UT tax and Total CESS on the top side of the form. Table data shows the details of HSN, Description, UQC, Total Quantity, Total Value, Taxable value, Integrated tax amount, Central tax amount, State or UT tax amount and CESS amount.

I.Summary of Issued Documents during Tax period (13)

ISSUED DOC SUMMARY

Summary of documents issued during period tax period includes details of all invoices issued  in a tax period, any kind of revised invoice, debit notes, credit notes etc. It displays Total number and Total cancelled number of documents on the top side of the form. Table data shows the details of Description, Series No From, Series No To, Total number and cancelled. 

 

Menus Available in Print View

When the user clicks on the print menu, it opens to Report page. It shows GSTR-1 report view and it consists of various menus.     

PRINT VIEW

        Fields

                                   Description

Refresh

If the latest data is not displayed, click on the refresh icon on the top left corner of the page to fetch the new data.

 

                          

 

Pagination Control

It controls the page navigation. User can select the page by using the page control keys or can enter the page number in the given box. After enter the page number, it will open to the screen.

 

 

            

Page Setup

This menu helps the user to set the page size, page orientation and margin size.

        By clicking on the Page Setup icon, a new tab will appear and user can select the page size, orientation and margin size with the tab.

                 

 

Switch to Interactive Layout

It helps the user to change the page to Interactive Layout. By clicking on the icon, it will change to an interactive layout.

        

Zoom

User can use the zoom option to select the required zoom size for print. By clicking on the select option, available zoom size will appear and can select required size.

                           

Print

By clicking on the Print button, user gets the print out of the report.

 

                                

 

Export

Export menu enable the user to export the report to PDF format and can save in the system.

                                 

                  

When the user click on the Export menu, a new tab will appear for save the file. Then user can select the location to save the file, can set a name and click on save button to save the file as PDF format.            

                                                                                                       

 

Exit

Exit menu is for exit from the Print report page and it redirects to the previous page.

                                   

 

 

Frequently Asked Questions?

01What is the content of GSTR 1 report in Accoxi?

GSTR-1 is a monthly or quarterly return that should be filed by every registered dealer. It contains details of all outward supplies (sales). The return has a total of 13 sections. Businesses with sales of up to Rs. 1.5 Cr have an option to file quarterly return. Other tax payers with sales above Rs. 1.5 Cr have to file monthly return.

The monthly GSTR-1 report helps a user stay up-to-date with the real time status of all GSTR-1 returns for any particular GSTIN. This report helps the tax payer to keep and maintain track of his returns filed and helps to avoid GST notices. 

02How to take print of the GSTR 1 report with complete list of items?

  • Click on the Reports module.
  • Select the report GSTR1 report under GST report head.
  • At the right hand side of the report, there is a Print button.
  • Click on the Print button and it opens the print view form.
  • You can set the page range, page height, width and can enter the required number of copies here.
  • Click on the Print button to get the printout of the GSTR1 report with complete list of items.

03How can I export the data in to Excel format?

  • Click on the Reports module.
  • Select the report GSTR1 report under GST report head.
  • At the right hand side of the report, there is a Print button.
  • Click on the Print button and it opens the print view form.
  • Click on the Export button at the bottom right side of the page.
  • New window will appear for to save the file. You can select the location to save the file.
  • Click on save button to save the data in Excel format.

04Can I Know my taxable value through GSTR 1 report?

  • Click on the Reports module.
  • Select the option GSTR 1 report from GST report head.
  • Then GST report opens and on the top right of the table, total taxable value is shown.

05Is there any option to filter the GSTR1 report?

Yes. You can filter the GSTR1 report by using the option Customize Report. It can be done by following steps;

  • Click on the Reports module.
  • Select the report GSTR1 report under GST report head.
  • Click on the Customize Report menu.
  • By clicking on the customize report, you can filter the report by date between.
  • Click on Run Report to get the customized data.