Simplest way to learn GST in Tally.ERP9
Get TallyERP9 Book with GST Updated for Rs.450 Tally.ERP9 Book + GST for Tally Book CONTENTS Get TallyERP9 Book with GST Updated for Rs.450
GSTR-1 Status Reconciliation Report in Tally.ERP9
 

GST compliance is complete if information of outward and inward supplies in books reconcile with the data on GST portal. Due to involvement of counter-party, multiple systems, and users, discrepancies creep in frequently making reconciliation a critical step.

 The filing process involves

     Supplier uploading details of outward supplies in GSTR-1.

     Buyer receiving the supply details in his GSTR-2A.

     Buyer approving, rejecting, modifying or adding the supply details and filing GSTR-2.

     Supplier receiving the modified supply details in GSTR-1A. Supplier approving or rejecting the updated supply details.

All the approval, rejection, or modification is done on the GST portal. The supplier or the buyer has to login to the GST portal to check the status of each voucher. The GSTR-1 report in Tally.ERP 9 has the status reconciliation feature that enables you to mark the status of each transaction based on the online status. This will allow you to track the status of all the transactions uploaded without having to login to the portal.

To view Status Reconciliation report

1.    Go to Gateway of Tally > Display > Statutory Reports > GST > GSTR – 1.

2.    Click U: Status Reconciliation. The Status Reconciliation screen appears as shown below:

 

Count: Displays the total count of vouchers under the particular table for the reporting period.

 

Activity Status

To Be Uploaded: Displays the number of vouchers yet to be exported. The count vouchers that are not yet exported to GSTR-1 return file are displayed in this column.

Uploaded: Displays the number of vouchers exported. This column is automatically updated when a voucher is exported to GSTR-1 return file.

Rejected by GST: Displays the count of vouchers marked as Rejected by GST. You can mark the voucher status as rejected when GST rejects the voucher for reasons such as, duplicate invoice, reference of original transaction is not found in case of debit/credit note, GSTIN of any user being suspended, and so on.

Accepted: Displays the count of vouchers marked as Accepted. You can mark the status as accepted when input tax claim made by the buyer in the GSTR-1A.

Rejected: Displays the count of vouchers marked as Rejected. You can mark the status as rejected when the buyer rejects the voucher details as displayed in the GSTR-1A.

Reconciliation Status

Not Reconciled: Displays the count of vouchers marked as Not Reconciled. You can mark the status as Not Reconciled when the details in the online portal do not match with your books.

Reconciled: Displays the count of vouchers marked as Reconciled. You can mark the status as Reconciled when the details in the online portal match with your books.

Set Status

Drill down from any table to view the voucher register with list of vouchers and change the status of the voucher.

The voucher register displayed on drill down from a table in Status Reconciliation screen appears as shown below:

 

To set the status of a voucher

1.    Select a voucher or multiple vouchers using Spacebar.

2.    Click S: Set Status.

3.    Select the Activity status and Reconciliation status of the voucher based on the details in the GST portal and press Enter.

The status change is displayed in the Voucher Register as shown:

4.    Press Escape (Esc) to return to the Status Reconciliation screen. The voucher count in columns is changed based on the status updates.

Status-wise View

You can view the status reconciliation in the status-wise view.

To change to status-wise view

1.    Click F5: Status-wise View in the Status Reconciliation screen.

 

F12: Configure

Show uncertain transactions?: Enable this option to view the number vouchers that are not included in the returns due to incomplete information or mismatch. This voucher count is displayed at the bottom of the Status Reconciliation screen.
 
POPULAR TOPICS @ GST in Tally.ERP9
FAQ @ GST Invoicing and Printing
FAQ @ GST Features and Tax Calculations
Unregistered Dealers under GST
HSN/SAC for GST
Recording Transactions under GST
Licensing and Migration for GST
Table-wise Report of GSTR-1
Using Multiple addresses for Ledger Account
Create A Voucher Class for Inclusive of Tax Calculations
Creating Voucher Types in Tally.ERP9
Restarting Voucher Numbering
Renewing Your Tally Software Service subscription for Tally.ERP 9
How to Upgrade to the Latest Tally.ERP 9 Release
How to Update Your Tally.ERP 9 License
How to Reactivate Tally.ERP 9 License
Surrendering Tally.ERP 9 License
Activating Tally.ERP 9 License
Configuring Tally.ERP 9 License from Tally Gateway Server
Summary of Exceptions- GSTR-2
Table-wise Report-GSTR-2
Returns Summary – GSTR-2
Computation Details- GSTR-2
Status Reconciliation- GSTR-2
Returns Summary- GSTR-1
Computation Details- GSTR-1
Summary of Exceptions- GSTR-1
Table-wise GSTR-1
Status Reconciliation-GSTR-1
Reversal of Tax Credit under GST
Refund of Tax Credit under GST
Recording Transitional Credit under GST
Adjustments Against Tax Credit under GST
Liability for interest, Penalty, Late Fee, and other Dues in GST
Advance Payment to Supplier under Reverse Charge in GST
GST Payment Voucher
Sales Returns under GST
Export Sales under GST
Sales of Mixed supply under GST
Sales of Composite Supply under GST
Nil-Rated GST-Sales
Exempt GST-Sales
SEZ GST-Sales
GST-Sales to Consumer (B2C large and small invoices)
GST-Sales Involving Consignee (ship to) and buyer (bill to)
GST-Sale of Works Contract Services
Local GST-Sales
Interstate GST-Sales
GST-Sales of Goods and Services in a Single Invoice
Restart Voucher Numbering in GST Sale
Purchase Returns under GST
Record Inward Supply Of Services As Imports under GST
Raise Tax Liability under GST Purchase
Claim Tax Credit On The Liability Of Imports under GST Purchase
Nil Rated GST-Purchases
Exempt GST-Purchases
SEZ GST-Purchases
GST-Purchase of Works Contract Services
Local GST-Purchase
Interstate GST-Purchase
Updating / Creating a Sales Ledger under GST
Updating/Creating a Purchase Ledger under GST
Setting up GST Rates
Activating GST
Providing GST-related details
Sales Inclusive of Tax in Tally.ERP9
 
| Setup GST | GST Purchase | GST Sales | GST Adjustment | GSTR-1 Report | GSTR-2 Report | GSTR-3B Report | GST Report | GST Topics | Tally.ERP9 Book |