HomeTallyPrimeTaxation ComplianceVAT in GCCResolve Mismatch in Transactions

 

Explore Categories

 

 PDF

Resolve Mismatch in GCC Transactions Under VAT in TallyPrime

The Uncertain Transaction (Corrections needed) in the Return Summary section of the VAT Return report lists the number of vouchers that are not included in the returns due to exceptions in information required for inclusion in returns. Drill down from this row to view the Summary of Exceptions screen.

You can identify the exceptions and correct the transactions before filing tax returns. The Vouchers with incomplete/mismatch in information appears as shown below:

The vouchers are grouped under different exception types such as:

  • Nature of transaction, assessable value, rate of tax modified in voucher
  • Incorrect tax type selected in tax ledger
  • Mismatch due to tax amount modified in the voucher
  • Vouchers with incomplete/incorrect adjustment details

The exceptions are listed in the order of priority, based on the importance of the information for generating returns and audit file. 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 is resolved. This will help you clear all exceptions before filing the returns.

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

 

Exception Resolution

You can view the exceptions related to masters and transactions, and resolve them

No. of voucher with incomplete/mismatch in information: Displays the total number of 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.

To resolve all exceptions at once:

  1. Select No. of voucher with incomplete/mismatch in information.
  2. Press Enter to display Uncertain Resolution screen with the list of vouchers, number of exceptions in each voucher, and exception types. The Uncertain 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 press Alt+W (Recompute) or Alt+J (Accept as is) to recompute or accept the details, respectively.
  5. Press Enter to navigate to the next exception type.
  6. Resolve the exceptions by providing details or using the buttons provided.
  7. Press Enter after all the 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 Uncertain Resolution screen.

Press Alt+H (Exclude Vouchers) in the Uncertain Resolution screen to exclude the voucher from returns.

 

Nature of transaction, assessable value, rate of tax modified in voucher

Displays the number 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. Press Alt+R (Resolve) to select Nature of transaction and enter other details manually, or press Alt+J (Accept as is). A message is displayed as shown below:
  5. Press Enter to accept.
  6. Similarly, accept the required vouchers.
  7. Accept the screen. As always, you can press Ctrl+A to save.

 

Incorrect tax type selected in tax ledger

Displays the number 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 ledger with the correct tax type.
  4. Accept the screen. As always, you can press Ctrl+A to save.

 

Mismatch due to tax amount modified in voucher

Displays the number of transactions in which there is a difference between the calculated and the entered tax amount. Also, if the difference is higher than the round-off value . The mismatch due to modified value can be resolved by following one of the options.

To define the round-off value in Vouchers with incomplete/mismatch in information screen:

  1. In Uncertain Resolution, you can set Round-off margin. Press Ctrl+B (Basis of Values) > Round-off margin > press Enter and set Round-off margin value, as required. Press Esc to view the default values.
  2. Accept the screen. As always, you can press Ctrl+A to save.

In case the difference in tax amount is within the given round-off margin, the transaction is by default included for returns, and not set as an exception.

Recompute

To resolve the exception by recomputing the tax amount:

  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. Navigate to the required transaction and press Enter.
  4. Press Alt+W (Recompute) to recalculate the tax amount.
  5. Accept the screen. As always, you can press Ctrl+A to save.

 

Create Adjustment

To resolve the exception by creating adjustment voucher:

  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. Select the transaction that needs an adjustment entry to balance the difference amount.
  4. Press Alt+S (Create Adjustment).
  5. Record a journal voucher and assign the difference amount to the VAT ledger, and save the voucher.

Similarly, adjustment transactions can be created for all the vouchers with a difference in tax amount.

To resolve this exception by linking to a journal transaction:

  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. Select the required transaction.
  4. Press Alt+L (Link Adjustment) to display the list of adjustment transactions for linking to balance the difference amount.
  5. Select the transaction, and press Alt+B (Save). Similarly, vouchers with exception can be linked to other vouchers.

Resolve

To resolve the exception by manually entering the tax amount:

  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. Select the required transaction.
  4. Press Alt+R (Resolve), and enter the tax value in As per transaction column of the voucher.
  5. Accept the screen. As always, you can press Ctrl+A to save.

Accept as is

To accept the voucher as is:

  1. Select the exception Mismatch due to tax amount modified in voucher.
  2. Press Enter. All the transactions of the particular exception are displayed.
  3. Select the required voucher and press Alt+J (Accept as is). A message is displayed as shown below:
  4. Press Enter to accept. Similarly, accept the required vouchers.
  5. Accept the screen. As always, you can press Ctrl+A to save.

Voucher with incomplete/incorrect adjustment details

Displays the number 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 as shown below:
  3. Select the Nature of adjustment and Additional details for each voucher.
  4. Accept the screen. As always, you can press Ctrl+A to save.

Tax payments (not included/uncertain)

Drill down from this row to view tax payment vouchers that are not included in the returns due to insufficient information.

  1. Alt+G (Go To) > type or select VAT 201 > press Enter.
    Alternatively, Gateway of Tally > Display More Reports > Vat Reports > VAT 201 > press Enter.
  2. Drill down to Payment Details section > Tax payments (not included/uncertain) > press Enter.
    The Tax Payments Exception screen appears as shown below:
  • Unable to determine duty type of ledger: This is a master-related exception that applies in cases when a user passes a VAT payment, but during ledger creation/alteration, the Type of duty/taxis selected as Others rather VAT.
  • Unable to determine payment period/type of tax payment: This is a transaction-related exception that applies in cases when a user passes a VAT payment but leaves the Period From field empty under Autofill.

    Note: To qualify for this exception, the VAT payment voucher must go through the Autofill process.

UAE VAT

Information required for generating Audit File not provided

Displays the number of transactions excluded from the audit file due to insufficient information.

To resolve the exception

  1. Select Information required for generating Audit File not provided.
  2. Press Enter to display Information required for generating Audit File not provided screen with the list of vouchers with mismatch/incomplete information.
  3. Select any voucher and press Enter to view the screen, as shown below:
  4. Enter the missing information or update the incorrect details, and press Enter to return to the Uncertain Resolution screen.
  5. Select the next voucher to update the details required for audit file and continue.

 

KSA VAT

Parties with invalid VAT Account Number

Displays the number of transactions excluded from the return due to invalid VAT account number for party ledgers.

  1. Select Parties with invalid VAT Account Number.
  2. Press Enter to display Exception Resolution screen with the list of vouchers with mismatch/incomplete information.
  3. Select any voucher and press Enter to display the exceptions.
  4. Enter the missing information or update the incorrect details, and press Enter to return to the Uncertain Resolution screen.
  5. Select the next voucher to update the required details and continue.

 

Oman VAT

Parties with invalid VATIN

Displays the number of transactions excluded from the return due to invalid VAT account number for party ledgers.

  1. Select Parties with invalid VATIN.
  2. Press Enter to display Exception Resolution screen with the list of vouchers with mismatch/incomplete information.
  3. Select any voucher and press Enter to display the exceptions.
  4. Enter the missing information or update the incorrect details, and press Enter to return to the Uncertain Resolution screen.
  5. Select the next voucher to update the required details and continue.

 

Filter for Voucher 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 ledger-wise. In ledger-wise view, all exceptions caused by a particular ledger can be resolved from ledger-wise exceptions list.

Ledger Exceptions

Press F8 (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 ledger master level, all voucher level exceptions resulting from that ledger are resolved. To update the information and resolve exception at master level:

  1. Press F8 (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. Make the required corrections based on the exception type.
  4. Accept the screen. As always, you can press Ctrl+A to save.

 

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. Press F8 (Ledger Exceptions).
  2. Navigate to required exception type and press Enter from Total Vouchers column to display Uncertain Resolution screen, as shown below:
  3. Make the required corrections based on the exception type.
  4. Accept the screen. As always, you can press Ctrl+A to save
TallyHelpwhatsAppbanner
Is this information useful?
YesNo
Helpful?
/* */