how to prepare gstr 1 data in excel | how to file gstr 1 from tally prime 6.1 | B2b B2c HSN summary

GST Related Notification Link :-
1. :- https://whatsapp.com/channel/0029VaATKkAG8l56gBnMqR1g
2. :- https://t.me/professionalprime

gstr 1 return in excel format in tally prime 6.1
how to prepare gstr 1 data in excel
Here is a detailed description of how to generate and export the GSTR-1 return in Excel format from Tally Prime.
Description: Generating GSTR-1 in Excel Format in Tally Prime
Exporting the GSTR-1 report to Excel from Tally Prime is a straightforward process. The exported Excel file is created in a format that is compatible with the government's official GST Offline Tool, which you can use to create a JSON file for uploading to the GST portal.
Here is the step-by-step guide:
Step 1: Ensure Your Data is Accurate
Before generating any report, ensure all your sales and outward supply transactions for the tax period are correctly entered. This includes:
• Sales Invoices (B2B and B2C)
• Export Invoices
• Credit and Debit Notes
• Advances Received
• Correct GSTINs for your parties
• Proper HSN/SAC codes and tax rates for your items/services
Step 2: Navigate to the GSTR-1 Report
There are two easy ways to open the GSTR-1 report in Tally Prime:
Method A: Using "Go To" (The fastest way)
1. From any screen in Tally Prime, press Alt + G (Go To).
2. Type GSTR-1 in the search bar.
3. Select GSTR-1 from the list and press Enter.
Method B: Using the Menu Path
1. From the Gateway of Tally, go to Display More Reports.
2. Select GST Reports.
3. Select GSTR-1.
Step 3: Set the Correct Period
1. Once the GSTR-1 report is open, it will show data for the current period by default.
2. To change the period (e.g., for April 2024), press F2: Period.
3. Enter the From and To dates for the month or quarter you are filing for and press Enter.
Step 4: Review and Correct Errors
This is the most critical step. Tally Prime organizes the GSTR-1 report to help you easily identify problems.
1. Look at the "Uncertain Transactions (Corrections needed)" section at the top of the report.
2. This count must be ZERO before you export.
3. If there is a number greater than zero, press Enter on this section. Tally will show you exactly what is wrong (e.g., "Mismatch in tax rate", "Missing GSTIN/UIN", etc.).
4. Drill down into each error, correct the master data or the transaction, and save it. Keep doing this until the "Uncertain Transactions" count is zero.
5. Briefly review the other sections like B2B Invoices, B2C (Large), Credit/Debit Notes, etc., to ensure the values look correct.
Step 5: Export the GSTR-1 Report to Excel
1. Once you are confident the data is 100% correct, press Ctrl + E (Export).
2. A small menu will appear. Select "GST Return".
3. The Export screen will appear. Now, you need to configure the settings.
Step 6: Configure the Export Settings
On the Export screen, configure the following options:
1. File Format: Press Enter on this option and select Excel (Spreadsheet) from the list.
2. Export separate files for each section: Set this to No. This ensures Tally creates a single Excel workbook with multiple sheets (worksheets) inside, which is the format required by the offline tool.
3. Folder Path: This is where the Excel file will be saved. You can change it by selecting "Folder Path" and specifying a new location on your computer.
4. File Name: Tally suggests a default file name. You can change it if needed.
After setting these, click "Configure" for a few more important options:
• Ensure "Show HSN/SAC Summary" is set to Yes.
• Ensure "Show Document Summary" is set to Yes.
Press Esc to go back to the Export screen.
Step 7: Finalize and Export
1. After reviewing all the configurations, press E (Send/Export).
2. Tally Prime will process the data and create the Excel file in the folder path you specified. The folder containing the file will usually open automatically.
Description of the Exported Excel File
The generated Excel file is not a simple data dump. It is structured precisely to match the government's requirements. When you open the file, you will see multiple worksheets (tabs) at the bottom, such as:
• b2b: For Business-to-Business invoices.
• b2cl: For Business-to-Consumer (Large) invoices (inter-state sales above ₹2.5 lakhs).
• b2cs: A summary of Business-to-Consumer (Small) sales.
• cdnr: For Credit/Debit notes issued to registered parties.
• cdnur: For Credit/Debit notes issued to unregistered parties (for B2CL/Export invoices).
• exp: For Export invoices.
• hsn: The HSN/SAC-wise summary of all outward supplies.
• docs: A summary of invoice series issued, cancelled, etc., during the period.
This file can now be directly imported into the GST Offline Tool to generate the JSON file, which you then upload to the GST Portal to file your return.

Видео how to prepare gstr 1 data in excel | how to file gstr 1 from tally prime 6.1 | B2b B2c HSN summary канала professional prime