1.  Introduction to GST ( IGST . CGST, SGST )

 

2.  Calculation of GST ( IGST, CGST & SGST) (Practical Assignment )

 

3.  GST on Tally.ERP 9 ( With Practical Assignment )

     Step-1  :  Activating GST for Your Company

     Step-2  : Setting Up GST Rates

     Step-3 :  Updating/Creating Sales and Purchase Ledgers for GST Compliance

     Step-4  : Restarting Voucher Numbering for GST Transactions

     Step-5 : Updating/Creating Party GSTIN/UIN

     Step-6  : Creating GST Ledgers

     Step-7  : Creating Party Ledgers for GST

     Step-8  : Recording Purchase under GST

     Step-9 : Recording GST Sales and Printing Invoices

 

4.  Generate GSTR-1 Returns / Reports under Tally.ERP9

  4.1. Table-Wise Format (Department  Format)

 4.2.    Returns Summary ( GSTR-1)

  4.2.1 Total number of vouchers for the period

  4.2.2. Included in returns

  4.2.3. Not relevant for returns

4.2.4.Incomplete/mismatch in information (to be resolved)

      (SUMMARY OF EXCEPTIONS – GSTR-1)

4.2.4.1.     No. of voucher with incomplete / mismatch in information

       4.2.4.2.  Country , State and Dealer Type not Specified

      4.2.4.3.Tax Rate / Tax Type not Specified

4.2.4.4.Nature of transaction, taxable value, rate of tax modified in voucher

4.2.4.5.  Incorrect tax type selected in tax ledger

4.2.4.6.Mismatch due to tax amount modified in voucher

4.2.4.7.  Voucher with incomplete / incorrect adjustment details ( SGTR-2)

4.2.4.8. Information required for generating table-wise details not provided

4.2.4.9.  Exception Types

     4.2.4.9.1. Item Exceptions

     4.2.4.9.2. Ledger Exceptions

4.3. GSTR-1 Particulars ( Computation Details)

     4.3.1. Outward Supplies

 

5.  Status Reconciliation (GSTR-1)

5.1.  Set Status

5.2.  Status-wise View

 

6.  Challan Reconciliation Report for GST Payments

7. Creating Income and Expenses Ledger in GST

 
8. Reverse Charge on Purchase from Unregistered Dealer (URD) | Reverse Charge in GST in Tally

Step-1:     Create Supplier Ledger i.e. Supplier (L) URD – Local

Step-2:     Similarly.. Create Supplier Ledger of Outside State i.e. Supplier (O) URD – Interstate

Step-3:     Create  Local Purchase Ledger i.e. “Purchase from URD-Local”

Step-4:     Similarly.. Create  Outside Purchase Ledger i.e. “Purchase from URD-Interstate ”

Step-5:     Recording an Invoice for Purchase from Unregistered Dealer-Local

Step-6  :   Similarly, You can Record an Invoice for Purchase from Unregistered Dealer-Interstate (Outside State)

Step-7:     View Total Tax Liability under Reverse Charge GST in GSTR2

Step-8 :    Recording a Journal Voucher Transaction for Increase in Tax Liability on Purchase from Unregistered Dealers

 
9. GST On Advance Payment Received From Customer in Tally | GST in Tally ERP 9

9.1.  Advance Receipt exclusive of tax adjusted against Sales Invoice in the same month

9.1.1.     To record a receipt voucher for advance receipt from customer exclusive of tax

9.1.2.     Sales Invoice Linked to an Advance Receipt Voucher in the same month as above.

9.2. Advance Received and Sales Invoice recorded in different months.

9.2.1.  Advance receipt voucher

9.2.2. Journal voucher to raise the liability

9.2.3. Sales Invoice against Advance Receipt of Previous Month

9.2.3. Journal Voucher to Reverse the Tax Liability raised in Journal Voucher for the Advance Received of the Previous Month.

9.3.  Reversal of GST on account of Cancellation of Advance Received.

9.3.1.  To exclude a transaction

9.3.2. To reverse the liability on cancellation of a transaction

 

10. Recording An Advance Payment To Supplier Under GST

 
11. Transferring Tax Credits of VAT, Excise, and Service Tax to GST
 
12. Recording Sales of Composite Supply under GST
(Expenses Apportioning)
 
13. ‘Nil-Rated Sales’ on GST in Tally.ERP9
 
14. ‘Exempt Sales’ on GST in Tally.ERP9
 
15. FAQ on GST in Tally.ERP 9
 
16. Common Queries About GST in Tally.ERP9
 

Status Reconciliation (GSTR-1) in Tally.ERP9

In Tally.ERP 9


5.  Status Reconciliation (GSTR-1)

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 the supply details and filing GSTR-2.

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

●          Generating GSTR-3 the supplier with payment of taxes when buyer and seller approve all the supply details.

All the approval, rejection, modification and confirmation 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:

Activity Status: Displays the columns for different status of vouchers.

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

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: Displays the columns for reconciliation status of vouchers.

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.

5.1.  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.

5.2.  Status-wise View    

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

To change to status-wise view

1.          Click V: 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.

 
Disclaimer :.

The names of Companies and persons used in this Website have been used for illustrative purposes only.
The visitors may visit www.tallysolutions.com , the web site of Tally Solutions Pvt. Ltd. for resolving their doubts or for clarifications

Trademark :

GST on Tally.ERP9, TallyERP9 GST, Tally 9, Tally9, Tally.ERP, Tally.ERP –9, Tally.Server 9, Tally.NET & Power of Simplicity are either registered trademarks or trademarks of Tally Solutions Pvt. Ltd. in India and/or other countries. All other trademarks are properties of their respective owners. This Website not associated with any product or vendor mentioned in this Website.

 
Simplest way to learn GST in Tally.ERP9
Get TallyERP9 Book with GST Updated for Rs.450
 
Get TallyERP9 Book with GST Updated for Rs.450 Get TallyERP9 Book with GST Updated for Rs.450 Tally.ERP9 Book + GST for Tally Book CONTENTS