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
 

GST On Advance Payment Received From Customer In TallyERP 9
[ A Complete GST Tutorial on Tally.ERP9 ]

In Tally.ERP 9

 

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


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

>>   The advance amount received from customers can be recorded in a receipt voucher. The receipt voucher that is marked as an advance receipt, can be printed with the required GST details.

>>   For any advance received for goods or services, if the corresponding sales invoice is not raised in the same month, the dealer who has received the advance has to pay the GST.

>>   When an invoice is raised against an advance received in a different tax period, the voucher recorded for advance amount received has to be tracked against it.

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

1.                    Go to Gateway of Tally > Accounting Vouchers > F6: Receipt.

2.    Click V: Advance Receipt to mark the voucher for advance receipt. The values entered in this voucher are captured inGSTR-1 report.

Note:  Receipt vouchers recorded without clicking V: Advance Receipt will not have GST implications, and will form part of the Summary of Excluded Vouchers.

 

3.    In the Advance Receipt Details screen, select the Stock Item (goods enabled for GST) or Ledger Name (services enabled for GST). Based on the GST rates defined in the stock item or ledger, the breakup of GST rate for Central TaxState Taxand Cess is displayed.

4.    Enter the advance received in the Amount column. You can adjust this against the sales invoice partially/fully, based on the sale value. At the end of the month, depending on the balance amount of advance available, you can record a journal voucher to raise the liability.

Note:  It is recommended to enter the entire advance amount in the Amount column so that the entire advance can be used to setoff against the sales invoice raised in the same month or different month.

Based on the amount entered, the breakup of GST amount gets auto calculated for Central TaxState Tax and Cess, if applicable. The Advance Receipt Details screen appears as shown below:

Note: The central and state tax rates shown in the above screen, are captured in the GSTR-1 report.

5.         Press Ctrl+A to accept the Advance Receipt Details screen and return to receipt voucher.

6.         Select the type of reference as Advance and enter the reference details in the Bill-wise Details screen.

7.         If the amount is received through bank, select the Transaction Type and enter the required details in the Bank Allocations screen.

8.         Press Enter to save.

9.         Click P: Print and enable the option Print Advance Receipt to Yes to print the invoice.

The printed payment voucher with the GST details appears as shown below:

The GSTR-1 report displays the tax liability on advance receipts as shown below:

The advance receipt voucher count appears in the Included in returns row.

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

When the sales invoice is recorded in the same month, the receipt voucher has to be linked to it by selecting the Type of Refas Agst Ref in the Bill-wise Details screen of sales invoice.

Don’t forget to Set ‘No’ to  “Use defaults for bill allocations” under F12 : Configure in Sales Invoice

As the sales invoice is recorded in the same month, the GSTR-1 report displays only the sales invoice as shown below:

The advance receipt voucher appears as part of transactions Not relevant for returns and is ategorized as No GST Implications in the Summary of Excluded Vouchers report.

 

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

9.2.1.          Advance receipt voucher

Record a receipt voucher in the month of July as shown below:

9.2.2.          Journal voucher to raise the liability

At the end of the month, record a journal voucher to raise the liability to pay tax as shown below:

The journal voucher that is recorded does not have any impact on the GSTR-1 report.

 

9.2.3.          Sales Invoice against Advance Receipt of Previous Month

Record a sales invoice in the month of August as shown below:

 

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

After recording the sales invoice, you need to reverse:

To reverse the tax liability, record a journal voucher by debiting the GST ledgers and crediting the expense ledger or ledger grouped under Current Assets, as shown below:

 

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

9.3.1.          To exclude a transaction

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

2.         Select Included in returns and press Enter.

3.         Select Advance Receipt and press Enter.

4.         Select the receipt voucher and click X: Exclude Vouchers.

5.    Click Yes for the message Do you want to exclude this voucher?.

 

9.3.2. To reverse the liability on cancellation of a transaction

1.          Click J: Stat Adjustment in GSTR-1 report or from the Accounting Vouchers > F7: Journal.

2.          Select the options as shown below:

3.    Debit the GST ledgers and credit the ledger grouped under Current Assets as shown below:

 
 
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