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 Summary of Exceptions Report in Tally.ERP9
 

Vouchers with incomplete/mismatch in information list includes voucher that contain GST details but are not included in the count of Included in returnsand Not relevant for returns due to incomplete information or mismatch.

You can correct exceptions in the vouchers before exporting GST returns. The Vouchers with incomplete/mismatch in information report appears as shown below:

The exceptions are listed in the order of priority, based on the importance of the information for generating returns. Hence, a voucher with multiple exceptions is listed in the exception type higher up the order. Once that exception is resolved, the voucher will move down to the next exception type. Such vouchers with multiple exceptions continue to be listed as exceptions until all incomplete/mismatch information are resolved. This will ensure that all exceptions are resolved before filing the returns as follow :

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

2.         UoM(s) not mapped to Unit Quantity Code (UQC)

3.         Country, state and dealer type not specified

4.         Tax rate/tax type not specified

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

6.         Incorrect tax type selected in tax ledger

7.         Mismatch due to tax amount modified in voucher

8.         Voucher with incomplete/incorrect adjustment details

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

10.      Exception Types

11.      Filter for Item level and Ledger level exceptions

11.1.      Item Exceptions

11.2.      Ledger Exceptions

 

However, vouchers with only one exception are moved to Included in returns list after that exception is resolved.

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

Displays the count of total vouchers with exceptions. Drill down from this row to view all the vouchers with exceptions, number of exceptions in each voucher, and type of exception. All exceptions can be resolved from here without having to open different exception categories.

To resolve all exceptions without having to go from one exception type to another

1.    Select No. of voucher with incomplete/mismatch in information.

2.    Press Enter to display Exception Resolution screen with the list of vouchers, number of exceptions in each voucher, and exception types. The Exception Resolution screen appears as shown below:

3.    Select any transaction and press Enter to display the Voucher Details Alteration screen which is divided into multiple sections, one for each exception in the voucher, as shown below:

4.    Select or enter required information for the first exception type. Further, you can click F5: Recompute or A: Accept as is to recompute or accept the details, respectively.

5.    Press Enter to navigate to next exception type.

6.    Resolve the exceptions by providing details or using the buttons provided.

7.    Press Enter after all exceptions in the voucher are resolved to view the next voucher with respective exceptions.

8.    Continue resolving the exceptions voucher by voucher, or press Esc to return to Exception Resolution screen.

Note: Click X: Exclude Vouchers in the Exception Resolution screen to exclude the voucher from GSTR-1 return.

2.     UoM(s) not mapped to Unit Quantity Code (UQC)

Displays the count of transactions for which Unit Quantity Code is not mapped with the unit of measure.

To resolve this exception

1.    Select the exception UoM(s) not mapped to Unit Quantity Code (UQC). You can map the unit of measure with UQC using the button (S: Map with UQC) or pressing Enter on the UoM Symbol.

2.    Select the UoM Symbol.

     Mapping with UQC from the report

o     Click S: Map with UQC and select the UQC.

o     Press Enter to save.

     Selecting UQC in the stock item master

o     Press Enter on the selected UoM Symbol.

o     Select the Unit Quantity Code (UQC), as shown below:

o     Press Enter to save.

3. Country, state and dealer type not specified

Displays the count of transactions where,

     Country/state is not selected in the party ledger master,

     State selected in transaction and party ledger are different, or

     Nature of transaction is not derived.

To resolve this exception

1.    Select the exception Country, state and dealer type not specified.

2.    Press Enter. All the transactions of the exception type are displayed. The Exception Resolution screen appears.

3.    Select the state, specify the GSTIN and select dealer type for each transaction.

4.    Press Ctrl+A to accept.

Note: Click X: Exclude Vouchers to exclude the voucher from GSTR-1 return.

4.     Tax rate/tax type not specified

Displays the count of transactions for which the rate or tax type is not selected in the item/ledger master.

To resolve this exception

1.    Select the exception Tax rate/tax type not specified.

2.    Press Enter. All the transactions of the exception type are displayed. The Exception Resolution screen appears as shown below:

3.    Select the Nature of transaction, if not provided.

4.    Enter Rate, as required for each transaction.

5.    Press Enter to save.

Note: Click X: Exclude Vouchers to exclude the voucher from GSTR-1 return.

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

Displays count of transactions in which the Nature of transaction, taxable value or rate of tax defined in the ledger master has been changed in the transaction.

To resolve this exception

1.    Select the exception Nature of transaction, taxable value, rate of tax modified in voucher.

2.    Press Enter. All the transactions of the exception type are displayed, as shown below:

3.    Select the required voucher.

4.    Click R: Resolve to select Nature of transaction and enter other details manually, or click A: Accept as is. A message is displayed as shown below:

5.    Press Enter to accept.

6.    Similarly, accept the required vouchers.

7.    Press Ctrl+A to accept.

6.     Incorrect tax type selected in tax ledger

Displays count of transactions in which type of duty is invalid.

To resolve this exception

1.    Select the exception Incorrect tax type selected in tax ledger.

2.    Press Enter. All the transactions of the exception type are displayed, as shown below:

3.    Select the tax type for each transaction.

4.    Press Enter to save.

7.     Mismatch due to tax amount modified in voucher

Displays the count of transactions in which difference is found between the calculated and entered tax amount. The mismatch due to modified value can be resolved by following one of the options.

To resolve this exception

1.    Select the exception Mismatch due to tax amount modified in voucher.

2.    Press Enter. All the transactions of the exception type are displayed.

3.    Based on your accounting requirements, you can recompute the tax values, or resolve the mismatch, or accept the transaction as is.

     Resolve

o     Navigate to required transaction.

o     Click R: Resolve, and enter the tax value in As per transaction column of the voucher. The Exception Resolution screen appears as shown below:

o     Press Ctrl+A to accept. Similarly, resolve the required vouchers.

     Accept as is

o     Navigate to required transaction.

o     Select the required voucher and click A: Accept as is. A message is displayed as shown below:

o     Press Enter to accept. Similarly, accept the required vouchers.

     Recompute

o     Navigate to required transaction and press Enter.

o     Click F5: Recompute to recalculate the tax amount.

o     Press Ctrl+A to accept. Similarly, recompute the required vouchers.

8.     Voucher with incomplete/incorrect adjustment details

Displays the count of journal transactions in which Nature of adjustment is not selected.

To resolve this exception

1.    Select the exception Voucher with incomplete/incorrect adjustment details.

2.    Press Enter. All transactions are displayed of a particular exception are listed, as shown  below:

   

3.    Select the Nature of adjustment and Additional details for each voucher.

4.    Press Ctrl+A to accept.

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

Displays the count of transactions excluded from table-wise format of GSTR-1 due to incomplete information. The button Exception Types is provided to resolve all party ledger level or voucher level corrections from a single screen.

To resolve all exceptions without having to go from one exception type to another

1.    Select Information required for generating table-wise details not provided.

2.    Press Enter to display Exception Resolution screen with list of vouchers with mismatch/incomplete information.

3.    Select any voucher and press Enter to display the Table-wise exceptions(s) screen, as shown below:

4.    Enter the missing information or update the incorrect details, and press Enter to return to the Exception Resolution screen.

5.    Select the next voucher to update the required details and continue.

10.     Exception Types

Using this option you can resolve exceptions from a common screen by grouping all table-wise related exceptions into two buckets Party Ledger level Corrections and Configuration Level Corrections. Exceptions in each group can be resolved from a single screen without having to move voucher by voucher.

To resolve all party ledger level exceptions

1.    Select Information required for generating table-wise details not provided.

2.    Press Enter to display Exception Resolution screen with list of vouchers with mismatch/incomplete information.

3.    Press Ctrl+E.

4.    Select Party Ledger Level Corrections in the Select Exception Resolution Type screen.

5.    Select the State Name, State Code and enter party GTIN number for the listed parties in the Party Ledger Level correction screen, as shown below:

6.    Press Ctrl+A to accept.

To resolve all configuration level exceptions

1.    Select Information required for generating table-wise not provided.

2.    Press Enter to display Exception Resolution screen with list of vouchers with mismatch/incomplete information.

3.    Press Ctrl+E.

4.    Select Configuration Level Corrections in the Select Exception Resolution Type screen.

5.    Enter HSN/SAC code for the listed vouchers.

6.    Press Ctrl+A to accept.

Drill-down from any row and resolve the respective exceptions to include the vouchers in return.

11.     Filter for Item level and Ledger level exceptions

By default, the list of exceptions displays incomplete/mismatch information details voucher-wise. However, the button options provided in the report allow you to view the exceptions item master-wise or ledger-wise. In item master-wise view, all exceptions caused by an item can be resolved by updating missing or incorrect information from a single screen. This will result in resolving multiple voucher exceptions caused by the particular master. Similarly, all exceptions caused by a particular ledger can be resolved from ledger-wise exceptions list.

11.1.   Item Exceptions

Click I: Item Exceptions to alter view of Vouchers with incomplete/mismatch in information report to display vouchers with incomplete/mismatch of information in item master. The vouchers with exceptions are displayed against different exception types in 2 columns:

Total Masters

Drill down from this column to view information missing/mismatch in item at master level. You can provide the required details at stock group level to update all items in the group or at individual item level. By providing required information at item master level, all voucher level exceptions resulting from that item are resolved.

To update the information and resolve exception at master level

1.    Click I: Item Exceptions.

2.    Navigate to required exception type and press Enter from Total Masters column to display Multi Stock Alteration screen.

3.    Select the Classification.

The Multi Stock Alteration screen appears as shown below:

4.    Enter HSN/SAC, and tax rate.

5.    Select Taxability and enter the Effective date.

6.    Press Ctrl+A to accept.

Total Vouchers

Drill down from this column to view information missing/mismatch in the items at voucher level. You can provide the required details for each transaction.

To update the information and resolve voucher exception at voucher level

1.    Click I: Item Exceptions.

2.    Navigate to required exception type and press Enter from Total Masters column to display Exception Resolution screen, as shown below:

3.    Select Nature of transaction.

4.    Enter Rate.

5.    Press Ctrl+A to accept.

11.2.   Ledger Exceptions

Click L: Ledger Exceptions to view of Vouchers with incomplete/mismatch in information report displays vouchers with missing/mismatch of information in ledger master. The vouchers with exceptions are displayed against different exception types in 2 columns:

Total Masters

Drill down from this column to view information missing/mismatch at ledger master level. You can provide the required details at ledger group level to update all ledgers in the group or at individual ledger level. By providing required information at leger master level, all voucher level exceptions resulting from that ledger are resolved.

To update the information and resolve exception at master level

1.    Click L: Ledger Exceptions.

2.    Navigate to required exception type and press Enter from Total Masters column to display Multi Ledger Alteration screen, as shown below:

3.    Enter HSN/SAC, and tax rate.

4.    Select Taxability and enter the Effective date.

5.    Press Ctrl+A to accept.

Total Vouchers

Drill down from this column to view information missing/mismatch in the ledger at voucher level. You can provide the required details for each transaction.

To update the information and resolve voucher exception at voucher level

1.    Click L: Ledger Exceptions.

2.    Navigate to required exception type and press Enter from Total Vouchers column to display Exception Resolution screen, as shown below:

3.    Select Nature of transaction and enter rate.

4.    Press Ctrl+A to accept.

 
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 |