Based on the relevance to the returns, it will be classified as included or excluded.
You can be confident that only the correct transactions are a part of the returns that you file. Also, the capability to move a transaction from included to excluded or vice versa, will give you more control and flexibility over the final returns.
Sometimes, due to gaps in the information entered, the application may not be able to decide if the transaction has to be included in the generation of returns. In this case, the transaction will be grouped under Uncertain Transactions.
Classification |
Reason |
Actions that can be done |
Included |
All information that is required to effect the returns will be grouped under Included |
From the Voucher Register, X: Excluded can be clicked to exclude the transaction, if required. |
Excluded |
A transaction is excluded because the nature of transaction doesn't affect the returns. |
Drill down to the voucher level and confirm if the transactions have to be excluded, or make the required changes to include the transaction. |
Uncertain |
A transaction is grouped under uncertain because there is insufficient information to ascertain if the transaction has to be included for a return. |
Drill down to the Summary of exceptions Provide the required information and resolve the exception. |
Click a link below to know how to resolve exceptions from the return forms.
Excise
When the information provided in the masters created is uncertain, the exception is listed under Master Related Exceptions.
When appropriate excise details like stock item type and conversion factor are not defined, or if there is a mismatch in the details entered, the transaction will be listed under this category.
Unable to determine the Stock Item Type
Reason
If the option Excise Applicable? has been set to Not Applicable in the stock item, then the Stock Item Type will not be defined.
Solution
This exception can be resolved by setting the appropriate stock item type.
To set the stock item type
Press Enter on the transaction.
Click S: Set Item Type.
Select the Nature of Removal, as required.
Press Esc.
Click F6: Save.
Press Enter.
The modification made is saved, and the exception is resolved.
Note: Alternatively, click X: Exclude Vouchers from the Uncertain Vouchers screen to exclude the transaction..
Unable to determine the Conversion Factor
Reason
If the option Excise Applicable? has been set to Not Applicable in the stock item, then the conversion factor to convert the UOM to the excise reporting unit will not be defined.
Solution
This exception can be resolved by defining the conversion factor.
To set the conversion type
Press Enter on the transaction.
Enter the conversion factor.
Press Esc.
Click F6: Save.
Press Enter.
The modification made is saved, and the exception is resolved.
Note: Alternatively, you can exclude the transaction by clicking X: Exclude Vouchers from the Uncertain Vouchers screen.
Mismatch in expected & actual type of stock item
Reason
A transaction will be classified under this exception when there is a mismatch in the nature of purchase or removal, and the stock item type. The mismatch causing exceptions are:
The Nature of Removal is Removal as Such and the Stock Item Type is Finished Goods
The Nature of Purchase is Manufacturer and the Stock Item Type is Finished Goods
The Nature of Removal is Domestic and the Stock Item Type is Principal Input
This exception can be resolved by solving the mismatch between the nature of removal/purchase and the stock item type selected.
To set the item type
Press Enter on the transaction.
Click S: Set Item Type.
Select the Nature of Removal, as required.
Press Esc.
Click F6: Save.
Press Enter.
The modification made is saved, and the exception is resolved.
Note: Alternatively, click X: Exclude Vouchers from the Uncertain Vouchers screen to exclude the transaction.
When the information provided in the duty ledger is uncertain, the exception is listed under Duty Ledgers.
Unable to determine Tax Type and Duty Head for duty ledger
Reason
If the duty ledger selected in a transaction does not have the Type of Duty selected, and hence the Excise Duty Head is not selected, the transaction will be listed as an exception in this category.
Solution
This exception can be resolved by defining the appropriate tax type and the duty head for the tax ledger.
To define the tax details
Press Enter on the transaction.
Select the Tax Type.
Select the Excise Duty Head.
The Uncertain Vouchers screen appears as shown below:
Press Enter.
Press Esc.
Click F6: Save.
Press Enter.
The modification made is saved, and the exception is resolved.
Note: Alternatively, click X: Exclude Vouchers from the Uncertain Vouchers screen to exclude the transaction.
Unable to determine Tariff Details for Stock Item
Reason
If the tariff details for a stock item are not defined, the transactions in which the stock item is used will be categorised under Not able to determine Tariff details for Stock Item.
Solution
This exception can be resolved by defining excise tariff details like HSN Code, Reporting UoM and, Valuation Type.
To set the excise tariff details
Press Spacebar and select the transaction.
Click S: Set Tariff Details.
Define tariff details as shown below:
Press Enter.
The modification made is saved, and the exception is resolved.
Note: Alternatively, click X: Exclude Vouchers from the Uncertain Vouchers screen to exclude the transaction.
Unable to determine Excise Applicability
Mismatch in Excise Unit
Unable to determine the Nature of Purchase
Reason
This exception will display the count of purchase transactions recorded with duty ledger predefined with Type of Duty/Tax as Others and selected in purchase entry without defining the nature of purchase.
Solution
This exception can be resolved by specifying the nature of purchase.
To specify the nature of purchase
Press Enter on Unable to determine the Nature of Purchase.
Press Spacebar to select the transaction.
Click S: Set Nature of Purchase.
Select the appropriate nature of purchase.
Press Enter.
The modification made is saved, and the exception is resolved.
Unable to determine the Nature of Removal
This exception will display the count of transactions for which the nature of removal is not defined. The nature of removal has to fall in the category of Captive Consumption, Domestic, Exempt, Export, Export – Duty Chargeable, Removal as Such and Special rate.
Solution
This exception will be resolved by setting the appropriate nature of removal.
To set the nature of removal
Select Unable to determine the Nature of Removal and press Enter.
Press Spacebar to select the transaction.
Click S: Set Nature of Removal button.
Select the appropriate nature of removal.
Press Enter.
The modification made is now saved, and the exception is resolved.
Unable to determine Book Number in Voucher
No duty ledger or notification number is available in the transaction
This exception will display the count of transactions for which the notification number is not defined.
To solve this exception
Select No duty ledger or notification number is available in the transaction, and press Enter.
Click S: Set Notification Number
Enter the details in the fields provided for Notification Number, Serial Number, and select the Notification Type as Tariff/Non Tariff.
Press Enter.
The modification made is saved, and the exception is resolved.
This exception will appear for all Nature of Removal other than Special Rate for mismatch in,
Duty Rate, if the rate of duty configured in item master and provided in transaction are different
Assessable Value, wherein the duty amount against each duty head shown in the invoice is different
When the Nature of Removal is Export – Bond/LUT and SEZ – Bond/LUT and the transaction has different duty ledger with amount which is not ‘0’
This exception is applicable only for Home Clearance (Domestic, Captive Consumption - with duty), Export/Rebate, SEZ/Rebate were the duty is applicable.
If any transaction listed under this exception has to be excluded from this list without correcting the exception, press Spacebar to select the transaction and press Ctrl+E. The transaction will be moved to Excluded by User category of Excluded Transactions.
To solve this exception
Select Mismatch in tax amount, and press Enter.
Press Spacebar to select the transaction
Click A: Accept Difference button
The modification made is saved, and the exception is resolved.
Unable to determine Nature of Adjustment for journal entries
This exception displays the count of journal vouchers which has excise duty ledgers grouped under Excise with the Type of Duty/Tax set to Others.
If any transaction listed under this exception has to be excluded from this list without correcting the exception, press Spacebar to select the transaction and press Ctrl+E. The transaction will be moved to Excluded by User category of Excluded Transactions.
To solve this exception
Select Not able to determine Nature of Adjustment for Journal Entries, and press Enter.
Press Spacebar to select the transaction.
Click S: Set Nature of Adj. and select the nature of adjustment.
Press Enter.
The modification made is now saved, and the exception is resolved.
When the information provided in the masters created is uncertain, the exception is listed under Master Related Exception.
When appropriate excise details like stock item type and conversion factor are not defined, or if there is a mismatch in the details entered, the transaction will be listed under this category of exception.
Unable to determine the Stock Item Type
Reason
If the option Excise Applicable? has been set to Not Applicable in the stock item, then the Stock Item Type will not be defined.
Solution
This exception can be resolved by setting the appropriate stock item type.
To set the item type
Press Enter on the transaction.
Click S: Set Item Type.
Select the Nature of Removal, as required.
Press Esc.
Click F6: Save.
Press Enter.
The modification made is saved, and the exception is resolved.
Note: Alternatively, click X: Exclude Vouchers from the Uncertain Vouchers screen to exclude the transaction.
Unable to determine the Conversion Factor
Reason
If the option Excise Applicable? has been set to Not Applicable in the stock item, then the conversion factor to convert the UOM to the excise reporting unit will not be defined.
Solution
This exception can be resolved by defining the conversion factor.
To set the conversion type
Press Enter on the transaction.
Enter the conversion factor.
Press Esc.
Click F6: Save.
Press Enter.
The modification made is saved, and the exception is resolved.
Note: Alternatively, click X: Exclude Vouchers from the Uncertain Vouchers screen to exclude the transaction.
Mismatch in expected & actual type of stock item
Reason
A transaction will be classified under this exception type when there is a mismatch in the nature of purchase or removal, and the stock item type. The mismatches causing exceptions are:
The Nature of Removal is Removal as Such and the Stock Item Type is Finished Goods
The Nature of Purchase is Manufacturer and the Stock Item Type is Finished Goods
The Nature of Removal is Domestic and the Stock Item Type is Principal Input
This exception can be resolved by solving the mismatch between the nature of removal/purchase and the stock item type selected.
To set the item type
Press Enter on the transaction.
Click S: Set Item Type.
Select the Nature of Removal, as required.
Press Esc.
Click F6: Save.
Press Enter.
The modification made is saved, and the exception is resolved.
Note: Alternatively, click X: Exclude Vouchers from the Uncertain Vouchers screen to exclude the transaction.
When the information provided in the duty ledger is uncertain, the exception is listed under Duty Ledgers.
Unable to determine Tax Type and Duty Head for duty ledger
Reason
If the duty ledger selected in a transaction doesn't have the Type of Duty selected, and hence the Duty Head is not selected, the transaction will be listed as an exception in this category.
Solution
This exception can be resolved by defining the appropriate tax type and the duty head for the tax ledger.
To define the tax details
Press Enter on the transaction.
Select the Tax Type.
Select the Excise Duty Head.
The Uncertain Vouchers screen appears as below:
Press Enter.
Press Esc.
Click F6: Save.
Press Enter.
The modification made is saved, and the exception is resolved.
Note: Alternatively, click X: Exclude Vouchers from the Uncertain Vouchers screen to exclude the transaction.
Unable to determine Tariff details for Stock Item
Reason
If the tariff details for a stock item are not defined, the transactions in which the stock item is used will be categorised under Not able to determine Tariff details for Stock Item.
Solution
This exception can be resolved by defining excise tariff details like HSN Code, Reporting UoM and, Valuation Type.
To set the excise tariff details
Press Spacebar and select the transaction.
Click S: Set Tariff Details.
Define tariff details as shown below:
Press Enter.
The modification made is saved, and the exception is resolved.
Note: Alternatively, click X: Exclude Vouchers from the Uncertain Vouchers screen to exclude the transaction.
Unable to determine Excise Applicability
Mismatch in Excise Unit
Unable to determine Nature of Purchase
Reason
This exception will display the count of purchase transactions recorded with duty ledger predefined with Type of Duty/Tax as Others and selected in purchase entry without defining the nature of purchase.
Solution
If any transaction listed under this exception has to be excluded from this list without correcting the exception, press Spacebar to select the transaction and press Ctrl+E. The transaction will be moved to Excluded by User category of Excluded Transactions.
To solve this exception
Press Enter on Unable to determine the Nature of Purchase
Press Spacebar to select the transaction
If party ledgers of multiple transactions have to be allocated to same nature of purchase, select all of them using Spacebar
Click S: Set Nature of Purchase
Select the appropriate nature of purchase.
Press Enter.
The modification made is saved, and the exception is resolved.
Unable to determine the Nature of Removal
Reason
This exception will display the count of transactions for which the nature of removal is not defined. The nature of removal has to fall in the category of Captive Consumption, Domestic, Exempt, Export, Export – Duty Chargeable, Removal as Such and Special rate.
Solution
If any transaction listed under this exception has to be excluded from this list without correcting the exception, press Spacebar to select the transaction and press Ctrl+E. The transaction will be moved to Excluded by User category of Excluded Transactions.
To solve this exception
Select Unable to determine the Nature of Removal, and press Enter.
Press Spacebar to select the transaction
If party ledgers of multiple transactions have to be allocated to same nature of removal, select all of them using Spacebar
Click S: Set Nature of Removal
Select the appropriate nature of removal.
Press Enter.
The modification made is saved, and the exception is resolved.
Unable to determine Book Number in Voucher
No duty ledger or notification number is available in the transaction
This exception will display the count of transactions for which the notification number is not defined.
To solve this exception
Select No duty ledger or notification number is available in the transaction, and press Enter.
Click S: Set Notification Number
Enter the details in the fields provided for Notification Number, Serial Number and select the Notification Type as Tariff/ Non Tariff.
Press Enter.
The modification made is saved, and the exception is resolved.
Mismatch in tax amount
Mismatch in expected & actual Nature of Purchase: This exception will display the count of transactions in which the nature of purchase defined in the party master is different from the selection made in the transaction.
Note: If the purchase invoice is recorded with duty ledger by selecting Type of Duty/Tax as Excise, the duty gets apportioned to the item cost and will not appear in this exception.
If any transaction listed under this exception has to be excluded from this list without correcting the exception, press Spacebar to select the transaction and click Ctrl+E: Exclude Voucher button. The transaction will be moved to Excluded by User category of Excluded Transactions.
To solve this exception by accepting the difference,
Select Mismatch in expected & actual Nature of Purchase and press Enter
Press Spacebar to select a transaction.
If the mismatch of all transactions have to be accepted in one go, select all the items using Spacebar
Click Ctrl+O: Accept Difference button and press Enter
The exception will be solved.
Not able to determine the Excise Unit & Book Number: This exception will display the count of transactions for which the excise unit is set to Any in the Voucher Type exception, Not able to determine Excise Unit.
To view the list of transactions comprising of this exception, press F7: Show Vouchers button. If any transaction which is listed here has to be excluded from this list without correcting the exception, press Spacebar to select the transaction and press Ctrl+E. The transaction will be moved to Excluded by User category of Excluded Transactions.
To solve this exception
Select Not able to determine the Excise Unit & Book Number in Voucher, and press Enter.
Select the relevant Excise Unit
Select the excise Book Number
Enter the Serial number
Press Enter.
The exception will be solved.
Difference in Tax Amount due to Actual vs Expected: This exception will appear for all Nature of Removal other than Special Rate for mismatch in,
Duty Rate, if the rate of duty configured in item master and provided in transaction are different
Assessable Value, wherein the duty amount against each duty head shown in the invoice is different
When the Nature of Removal is Export – Bond/LUT and SEZ – Bond/LUT and the transaction has different duty ledger with amount which is not ‘0’
This exception is applicable only for Home Clearance (Domestic, Captive Consumption - with duty), Export/Rebate, SEZ/Rebate were the duty is applicable.
If any transaction listed under this exception has to be excluded from this list without correcting the exception, press Spacebar to select the transaction and click Ctrl+E: Exclude Voucher button. The transaction will be moved to Excluded by User category of Excluded Transactions.
To solve this exception
Select Difference in Tax Amount due to Actual Vs. Expected and press Enter
Press Spacebar to select the transaction
Click A: Accept Difference button
The modification made is saved, and the exception is resolved.
Unable to determine Nature of Adjustment for journal entries
This exception displays the count of journal vouchers which has excise duty ledgers grouped under Excise with the Type of Duty/Tax set to Others.
If any transaction listed under this exception has to be excluded from this list without correcting the exception, press Spacebar to select the transaction and press Ctrl+E. The transaction will be moved to Excluded by User category of Excluded Transactions.
To solve this exception
Select Not able to determine Nature of Adjustment for Journal Entries, and press Enter.
Press Spacebar to select the transaction.
Click S: Set Nature of Adj. and select the nature of adjustment.
Press Enter.
The modification made is saved, and the exception is resolved.
The exceptions or information gaps found in the transactions which are related to the masters are listed here.
This displays the count of entries for which details for stock items (Tariff Classification, conversion factor or the reporting UOM, duty type or duty head and mismatch of actual and expected type of stock items) are not defined. While solving exception, provision to view transactions recorded using these masters is made available.
To view the list of transactions comprising of this exception, press F7: Show Vouchers button. If any transaction which is listed here has to be excluded from this list without correcting the exception, press Spacebar to select the transaction and press Ctrl+E. The transaction will be moved to Excluded by User category of Excluded Transactions.
Unable to determine the Stock Item Type
This exception displays the count of transactions recorded using stock items for which the reporting stock item type are not defined.
To solve this exception
Select Unable to determine the Stock Item Type, and press Enter.
Click S: Set Item Type
Select the respective stock item type as Capital Goods/Finished Goods/Intermediate Goods/Other Inputs/Principal Input/Waste/Scrap
Press Enter.
The modification made is saved, and the exception is resolved.
Unable to determine the Conversion Factor
Mismatch in expected & actual type of stock item
This exception will display the count of transactions in which there is mismatch in the nature of removal and the stock item type. Transactions get categorised under this exception when:
The Nature of Removal is Removal as Such and the Stock Item Type is Finished Goods
The Nature of Removal is Domestic and the Stock Item Type is Principal Input
To solve this exception
Select Mismatch in expected & actual type of stock item, and press Enter
Press Spacebar to select an item
Click S: Set Item Type button
Select the Stock Item Type, and press Enter.
The modification made is saved, and the exception is resolved.
Unable to determine Tax Type and Duty Head for duty ledger
This exception displays the count of all transactions recorded without defining the tax types as CENVAT or Excise and excise duty heads.
To solve this exception
Press Enter on Unable to determine Tax Type and Duty Head for duty ledger
Select the Tax Type as Excise and Excise Duty Heads (for example, basic excise duty)
Press Enter to accept
The modification made is saved, and the exception is resolved.
Unable to determine Tariff details for Stock Item
This exception displays the count of transactions recorded with stock item for which tariff is not defined.
To solve this exception
Select Unable to determine Tariff details for Stock Item, and press Enter.
Press Spacebar to select the item.
Click S: Set Tariff
If the required tariff is not listed, press Alt + C and create the tariff master.
Select the tariff name, and press Enter.
The modification made is saved, and the exception is resolved.
Unable to determine Excise Applicability
Mismatch in Excise Unit
Unable to determine the Nature of Removal
This exception will display the count of transactions for which the nature of removal is not defined. The nature of removal has to fall in the category of Captive Consumption, Domestic, Exempt, Export, Export – Duty Chargeable, Removal as Such and Special rate.
If any transaction listed under this exception has to be excluded from this list without correcting the exception, press Spacebar to select the transaction and press Ctrl+E. The transaction will be moved to Excluded by User category of Excluded Transactions.
To solve this exception
Select Unable to determine the Nature of Removal, and press Enter.
Press Spacebar to select the transaction
If party ledgers of multiple transactions have to be allocated to same nature of removal, select all of them using Spacebar.
Click S: Set Nature of Removal
Select the appropriate nature of removal.
Press Enter
The modification made is saved, and the exception is resolved.
Unable to determine Book Number in Voucher
No duty ledger or notification number is available in the transaction
This exception will display the count of transactions for which the notification number is not defined.
To solve this exception
Select No duty ledger or notification number is available in the transaction, and press Enter
Click S: Set Notification Number
Enter the details in the fields provided for Notification Number, Serial Number and select the Notification Type as Tariff/ Non Tariff
Press Enter.
The modification made is saved, and the exception is resolved.
Mismatch in tax amount
The exception, Not able to determine Excise Unit will display the count of all transactions recorded without linking it to excise unit. To solve this exception by providing the relevant information,
Press Enter on Not able to determine Excise Unit to view the Uncertain Vouchers screen
Press Spacebar to select the voucher type and click S: Set Excise Unit button
If multiple voucher types have to be assigned to same excise unit, select all the voucher types using Spacebar
From the list displayed, select the required excise unit or set it to Any
If the relevant excise unit is selected, the transaction 'will not appear' in Not able to determine the Excise Unit & Book Number in Voucher exception of Transactions Related Exception
If it is set to Any, the transaction 'will appear' in Not able to determine the Excise Unit & Book Number in Voucher exception of Transactions Related Exception
To view the list of transactions comprising of this exception, press F7: Show Vouchers button. If any transaction which is listed here has to be excluded from this list without correcting the exception,
Press Spacebar to select the transaction
Press Ctrl+E and the transaction will be moved to Excluded by User category of Excluded Transactions.
Note: Once the errors are corrected, the transaction cannot be excluded. It will automatically be moved under Included Transactions.
Not able to determine Duty details for Stock Item: This exception will display the count of transactions recorded with stock item for which duty types are not defined.
To solve this exception
Select Not able to determine Duty details for Stock Item, and press Enter.
Press Spacebar to select the item
Click S: Set Duty Details
Select the Valuation Type, Type of Duty, enter the date of applicability and Rate of Duty
Press Enter.
The modification made is saved, and the exception is resolved.
Not able to determine the Excise Unit & Book Number in Voucher: This exception will display the count of transactions for which the excise unit is set to Any in the Voucher Type exception, Not able to determine Excise Unit.
To view the list of transactions comprising of this exception, press F7: Show Vouchers button. If any transaction which is listed here has to be excluded from this list without correcting the exception, press Spacebar to select the transaction and click Ctrl+E: Exclude Voucher button. The transaction will be moved to Excluded by User category of Excluded Transactions.
To solve this exception,
Select Not able to determine the Excise Unit & Book Number in Voucher and press Enter
Select the relevant Excise Unit
Select the excise Book Number
Enter the Serial number
Press Enter to accept it
The modification made is saved, and the exception is resolved.
Difference in Tax Amount due to Actual vs Expected: This exception will appear for all Nature of Removal other than Special Rate for mismatch in,
Duty Rate, if the rate of duty configured in item master and provided in transaction are different
Assessable Value, wherein the duty amount against each duty head shown in the invoice is different
When the Nature of Removal is Export – Bond/LUT and SEZ – Bond/LUT and the transaction has different duty ledger with amount which is not 0.
This exception is applicable only for Home Clearance (Domestic, Captive Consumption - with duty), Export/Rebate, SEZ/Rebate were the duty is applicable. If any transaction listed under this exception has to be excluded from this list without correcting the exception, press Spacebar to select the transaction and press Ctrl+E. The transaction will be moved to Excluded by User category of Excluded Transactions.
To solve this exception
Select Difference in Tax Amount due to Actual Vs. Expected, and press Enter
Press Spacebar to select the transaction
Click A: Accept Difference
The modification made is saved, and the exception is resolved.
Transaction count appears under this exception when Tariff name, HSN Code, Reporting UOM, Valuation Type, Type of Duty and Rate of Duty are not defined in the stock item master.
To view the list of transactions recorded using the stock items listed in this report, click V: Show Vouchers button. The transaction displayed here can be:
Corrected, which will automatically move the transaction under Included Transactions section.
Moved under Excluded Transactions section by clicking X: Exclude Vouchers button if they are not required to form part of the return. Such transactions will be moved to Excluded by User category of Excluded Transactions.
Marked as a non-excise voucher.
To solve this exception
Press Enter on Unable to determine Tariff details for Stock Item. The Tariff Details screen appears with item-wise details.
View of Tariff Details report can be changed to:
Stock Group wise report by clicking Ctrl+T keys. The name of stock group appears along with the stock item grouped under it in detailed mode.
Voucher-wise report by clicking V: Show Vouchers button. The list of transactions recorded using this stock item is displayed.
Select the stock item. If same tariff is applicable to multiple items, select them by pressing Spacebar.
Click S: Set Tariff Details button.
Enter the Tariff Name and HSN Code.
Select the Reporting UOM and Valuation Type.
Set Calculate Duty on MRP to Yes only if the duty calculation is based on MRP and enter the Abatement %. If not, retain it as No.
Select the Type of Duty as Basic Excise Duty and enter the Rate % or Rate per Unit depending on the Valuation Type.
If user defined duty types have been created and need to be listed under Basic Excise Duty, select the same.
If new duty type has to be created and used, select New. The Excise Duty Classification screen appears. Create the new duty type and select it under Basic Excise Duty and enter the Rate %.
The exception will be solved.
The exceptions or information gaps found at the transaction level are listed here.
Count of transactions appears under this exception when, Tax Unit is not selected in the transactions. If there any transactions of purchase, sale, debit note and credit note recorded before enabling excise, then all such transactions will appear under this exception.
If there are multiple tax units, then the relevant tax unit can be selected in debit and credit notes only if the option Allow selection of Tax Unit for Credit Note/Debit Note is enabled in the Configuration screen of the invoice. If this option is not enabled, the transactions cannot be identified with any excise tax unit. Hence, it appears under this exception.
To view the list of transactions, click V: Show Vouchers button. The transaction displayed here can be:
Corrected, which will automatically move the transaction under Included Transactions section.
Moved under Excluded Transactions section by clicking X: Exclude Vouchers button if they are not required to form part of the return. Such transactions will be moved to Excluded by User category of Excluded Transactions.
Marked as a non-excise voucher.
To solve this exception
Press Enter on Unable to determine Excise Applicability.
Select the transaction. If same excise tax unit is applicable to multiple transactions, select the required transaction by pressing Spacebar.
Click E: Excise button.
Select the relevant Excise Tax Unit.
Press Enter to accept it.
The exception will be solved.
Transaction count appears under this exception when the Nature of Purchase is set to Not Applicable in the Party Details screen of excise purchase and excise credit note transactions.
To view the list of transactions recorded without selecting the Nature of Purchase, click V: Show Vouchers button. The transaction displayed here can be:
Corrected, which will automatically move the transaction under Included Transactions section.
Moved under Excluded Transactions section by clicking X: Exclude Vouchers button if they are not required to form part of the return. Such transactions will be moved to Excluded by User category of Excluded Transactions.
To solve this exception and accept the different,
Press Enter on Unable to determine the Nature of Purchase
Select the transaction. If party ledgers of multiple transactions have to be allocated to same nature of purchase, select all of them by pressing Spacebar.
Click S: Set Nature of Purchase button.
Select the required Nature of Purchase.
Press Enter to accept it.
The exception will be solved.
Transaction count appears under this exception when the dealer excise feature is enabled after recording purchase invoice and credit note.
To view the list of transactions recorded without providing supplier details, click V: Show Vouchers button. If the transactions displayed are not required to form part of the return, it can be moved under Excluded Transactions section by clicking X: Exclude Vouchers button.
To solve this exception
Press Enter on Unable to determine the Supplier Details.
Press Enter to view the Accounting Voucher Alteration screen of purchase invoice or credit note.
Place the cursor on Amount field and press Enter to display the Excise Details screen.
Enter the:
Relevant details under Supplier Invoice Details, Manufacturer/Importer Details and Duty Details in Excise Details screen of purchase invoice.
Sales Invoice Number, Sales Invoice Date and select the sales invoice to link it to the credit note.
Accept the invoice.
The exception will be solved.
Since there is provision to change the Rate of Duty in Excise Details screen of excise purchase and excise credit note, the count of all such transactions wherein the Rate of Duty is changed in the invoice appears here.
The transaction displayed here can be moved under Excluded Transactions section by clicking X: Exclude Vouchers button if they are not required to form part of the return.
To solve this exception, press Enter on Mismatch in tax amount.
This exception can be solved in the following two ways:
Click A: Accept as is button if the amount calculated in the transaction as per the changed rate of duty, has to be considered in the returns.
Change the Rate of Duty in the invoice to match it with the rate predefined in masters or at company level. For this:
Select the transaction and press Enter to view the Voucher Alteration screen.
Place the cursor on Amount field and press Enter to display the Excise Details screen.
Change the rate entered in the Rate of Duty field/column.
Accept the invoice.
The exception will be solved.
Transaction count appears under this exception when the purchase invoices are not selected in Supplier Details screen of excise sales invoice and debit note.
To solve this exception
Press Enter on Supplier Invoices are Not Linked to Clearance
Select a transaction and press Enter. The List of Supplier Invoices screen is displayed.
Select the corresponding purchase transaction.
A sales invoice can be linked to:
Only one purchase invoice as full clearance.
Multiple purchase invoices as partial clearance by entering the quantity to be linked for each invoice.
Click F4: Full button to consume the entire quantity or click F5: Partial to consume partial quantity from the purchase invoice.
Press Enter to save.
The exception will be solved.
Unable to determine Tariff details for Stock Item
Transaction count appears under this exception when Tariff name, HSN Code, Reporting UOM, Valuation Type, Type of Duty and Rate of Duty are not defined in the stock item master.
To view the list of transactions recorded using the stock items listed in this report, click V: Show Vouchers button. The transaction displayed here can be:
Corrected, which will automatically move the transaction under Included Transactions section.
Moved under Excluded Transactions section by clicking X: Exclude Vouchers button if they are not required to form part of the return. Such transactions will be moved to Excluded by User category of Excluded Transactions.
Marked as a non-excise voucher.
To solve this exception
Press Enter on Unable to determine Tariff details for Stock Item. The Tariff Details screen appears with item-wise details.
View of Tariff Details report can be changed to:
Stock Group wise report by clicking Ctrl+T keys. The name of stock group appears along with the stock item grouped under it in detailed mode.
Voucher-wise report by clicking V: Show Vouchers button. The list of transactions recorded using this stock item is displayed.
Click S: Set Tariff Details button.
Enter the Tariff Name and HSN Code.
Select the Reporting UOM and Valuation Type.
Set Calculate Duty on MRP to Yes only if the duty calculation is based on MRP and enter the Abatement %. If not, retain it as No.
Select the Type of Duty as Basic Excise Duty and enter the Rate % or Rate per Unit depending on the Valuation Type.
If user defined duty types have been created and need to be listed under Basic Excise Duty, select the same.
If new duty type has to be created and used, select New. The Excise Duty Classification screen appears. Create the new duty type and select it under Basic Excise Duty and enter the Rate %.
The exception is solved.
To know more on how to create excise classification, click here.
All uncertainties associated with transactions is listed here.
Unable to determine Excise Applicability
Count of transactions appears under this exception when, Tax Unit is not selected in debit note and credit note. Tax Unit has to be selected especially when more than one tax unit is created in the company.
To view the list of transactions, click V: Show Vouchers button. The transaction displayed here can be:
Corrected, which will automatically move the transaction under Included Transactions section.
Moved under Excluded Transactions section by clicking X: Exclude Vouchers button if they are not required to form part of the return. Such transactions will be moved to Excluded by User category of Excluded Transactions.
Marked as a non-excise voucher.
To solve this exception
Press Enter on Unable to determine Excise Applicability.
Select the transaction. If same tax unit is applicable to multiple transactions, select the required transaction by pressing Spacebar.
Click E: Excise button.
Select the relevant Excise Unit.
Press Enter to accept it.
The exception is solved.
Unable to determine the Nature of Purchase
Transaction count appears under this exception when the Nature of Purchase is set to Not Applicable in the Party Details screen of excise purchase and excise credit note transactions.
To view the list of transactions recorded without selecting the Nature of Purchase, click V: Show Vouchers button. The transaction displayed here can be:
Corrected, which will automatically move the transaction under Included Transactions section.
Moved under Excluded Transactions section by clicking X: Exclude Vouchers button if they are not required to form part of the return. Such transactions will be moved to Excluded by User category of Excluded Transactions.
To solve this exception
Press Enter on Unable to determine the Nature of Purchase.
Select the transaction. If party ledgers of multiple transactions have to be allocated to same nature of purchase, select all of them by pressing Spacebar.
Click S: Set Nature of Purchase button.
Select the required Nature of Purchase.
Press Enter to accept it.
The exception is solved.
Unable to determine the Supplier Details
Transaction count appears under this exception when the dealer excise feature is enabled after recording purchase invoice and credit note.
To view the list of transactions recorded without providing supplier details, click V: Show Vouchers button. If the transactions displayed are not required to form part of the return, it can be moved under Excluded Transactions section by clicking X: Exclude Vouchers button.
To solve this exception
Press Enter on Unable to determine the Supplier Details.
Press Enter to view the Accounting Voucher Alteration screen of purchase invoice or credit note.
Place the cursor on Amount field and press Enter to display the Excise Details screen.
Enter the:
Sales Invoice Number, Sales Invoice Date and select the sales invoice to link it to the credit note.
Relevant details under Supplier Invoice Details, Manufacturer/Importer Details and Duty Details in Excise Details screen of purchase invoice.
Accept the invoice.
The exception is solved.
There is provision to change the Rate of Duty in Excise Details screen of excise purchase and excise credit note. Count of all such transactions wherein the Rate of Duty is changed in the invoice appears here.
The transaction displayed here can be moved under Excluded Transactions section by clicking X: Exclude Vouchers button if they are not required to form part of the return.
To solve this exception
Click A: Accept as is button if the amount calculated in the transaction has to be considered in the returns.
Change the Rate of Duty in the invoice to match it with the rate predefined in masters or at company level. For this:
Select the transaction and press Enter to view the Voucher Alteration screen.
Place the cursor on Amount field and press Enter to display the Excise Details screen.
Change the rate entered in the Rate of Duty field/column.
Accept the invoice.
The exception will be solved.
Supplier Invoices are Not Linked to Clearance
Transaction count appears under this exception when the purchase invoices are not selected in Supplier Details screen of excise sales invoice and debit note.
To solve this exception
Press Enter on Supplier Invoices are Not Linked to Clearance
Select a transaction and press Enter. The List of Supplier Invoices screen will be displayed.
Select the corresponding purchase transaction.
A sales invoice can be linked to:
Only one purchase invoice as full clearance.
Multiple purchase invoices as partial clearance by entering the quantity to be linked for each invoice.
Click F4: Full button to consume the entire quantity or click F5: Partial to consume partial quantity from the purchase invoice.
Press Enter to save.
The exception is solved.
Unable to determine service category
Reason
The ledgers selected in the transactions don't have a specific service category tagged to them.
Solution
Setting a service category for the ledgers will resolve this exception.
To set service category
Press spacebar and select a ledger/ group.
Click S: Set Category.
Enter the service category name, applicability date, and rate details in the Service Category Details screen.
Press Enter.
The exception is now resolved.
Reason
The service tax rates are not defined in the service category.
Solution
Defining service tax rates will solve this exception.
To define tax rates
Press Enter on Unable to determine tax rates.
Enter the date fro which the defined tax is applicable from.
Enter the Service Tax, Education Cess, and Higher Education Cess.
Press Enter.
The exception is now resolved.
Unable to determine the type of tax of duty ledger
Unable to determine service category
Mismatch in tax details of masters and transactions
Exempt Notification Number and Notification Serial Number Not Found
Abatement Notification Number and Notification Serial Number Not Found
Unable to determine the link in receipt/payment/credit note/debit note vouchers
Mismatch in tax amount
Unable to determine nature of adjustment
Source document/challan details
Mismatch in nature of transaction and type of adjustment flag
Unable to determine tax breakup
Master Related Exceptions
Unable to Determine TCS applicability for ledgers/stock item
Reason
The sales/income ledger that has been credited in the transaction, or the stock item selected, has not been tagged to a specific TCS Nature of Goods.
Solution
Selecting the appropriate TCS Nature of Goods will resolve this exception
To select the TCS Nature of Goods
Press Enter on Unable to Determine TCS applicability for ledgers/stock item.
Press spacebar to select the appropriate group.
Click N: Nature of Goods.
Set the nature of goods, as required.
Unable to determine collectee type for party
Reason
The collectee type of the party ledger is set to undefined.
Solution
Selecting a collectee type will resolve this exception.
To set the collectee type
Press Enter on Unable to determine collectee type for party.
Press Spacebar to select the Name of the Ledger.
Click D: Collectee Type.
Select the required collectee type.
The exception will be resolved.
PAN not available for the party
Reason
The party ledger selected has been enabled for TCS but PAN has not been specified
Solution
The PAN, and the applicability of PAN or the status of PAN application have to be recorded for the party.
To enter PAN Details
Press Enter on PAN not available for the Party.
Enter the PAN of the party and applicability, if PAN is available.
or
Press Enter in the PAN No field to go to the field PAN Status.
Select the PAN Status as applicable.
Notification not available for zero/lower rate of TDS
Reason
A lower rate or zero rate deduction is recorded for a transaction, and the corresponding notification number is not defined for the party/expense ledger.
Solution
This exception can be resolved by specifying the notification details.
In the drill down report for this exception, party ledgers that have been used to pass the zero rate/lower rate TCS entries will be listed. Identify the parties for which lower deduction/zero rate is applicable, select the relevant TCS Category, and provide the exemption notification number, applicability period, and the rate.
Unable to determine TCS applicability for ledgers
Reason
The TCS duty ledger has not been classified under a TCS Category.
Solution
Selecting a specific TCS Nature of Payment of TCS duty ledger will resolve this exception.
To select the Nature of Payment
Press Enter on Unable to determine TCS applicability of ledgers.
Select the Default Nature of Goods.
Duty ledgers for which TCS Nature of Goods has not been defined will be listed. Place the cursor on the required items and press Spacebar to select them.
Click N: Nature of Goods to set their Nature of Goods.
No link is available with booking and booking with collection voucher
Reason
The TCS category set for the sales/income ledger is not the same as the TCS category selected during voucher entry.
Solution
Setting the appropriate nature of goods will resolve this exception.
To resolve the exception
Press Enter on No link is available with collection voucher.
Select the transaction and click F3: Link All.
Note: If the TCS Category for the ledger is set to Any and a TCS Category is specified during voucher entry, this exception will not arise.
Unable to determine the TDS applicability for ledger/ stock item
The expense/purchase ledger that has been debited in a transaction, has not been enabled for TDS. Also, the expense ledger has not been tagged to a specific expense category for TDS.
Solution
This exception can be resolved by selecting a nature of payment.
To set the nature of payment
Press Spacebar to select a group.
Click N: Nature of Payment.
Select a TDS Nature of Payment.
The exception is now resolved.
Unable to determine deductee type for party
Reason
The deductee type of the party ledger is set to undefined.
Solution
Selecting a deductee type will resolve this exception.
To set the deductee type
Press Enter on Unable to determine deductee type for party.
Press Spacebar to select the Name of the Ledger.
Click D: Deductee Type.
Select the required deductee type.
The exception will be resolved.
PAN not available for the party
Reason
The party ledger selected has been enabled for TDS but PAN has not been specified
Solution
The PAN, and the applicability of PAN or the status of PAN application have to be recorded for the party.
To enter PAN Details
Press Enter on PAN not available for the Party.
Enter the PAN of the party and applicability, if PAN is available.
or
Press Enter in the PAN No field to go to the field PAN Status.
Select the PAN Status as applicable.
Notification not available for zero/lower rate of TDS
Reason
A lower rate or zero rate deduction is recorded for a transaction, and the corresponding notification number is not defined for the party/expense ledger.
Solution
This exception can be resolved by specifying the notification details.
In the drill down report for this exception, party ledgers that have been used to pass the zero rate/lower rate TDS entries will be listed. Identify the parties for which lower deduction/zero rate is applicable, select the relevant TDS Category, and provide the exemption notification number, applicability period, and the rate.
Unable to determine TDS applicability for ledgers
Reason
The TDS duty ledger has not been classified under a TDS Category.
Solution
Selecting a specific TDS Nature of Payment of TDS duty ledger will resolve this exception.
To select the Nature of Payment
Press Enter on Unable to determine TDS applicability of ledgers.
Select the Default Nature of Goods.
Duty ledgers for which TDS Nature of Goods has not been defined will be listed. Place the cursor on the required items and press Spacebar to select them.
Click N: Nature of Goods to set their Nature of Payments.
Unable to determine the tax rate for nature of payment
Reason
The tax rate for the nature of payment has not been specified.
Solution
Press Enter on Unable to Determine the Tax Rate for Nature of Payment.
Select Yes in the column Is Zero Rated, if required. Else, specify the rate of duty in the column Rate.
Press Enter.
The exception is solved.
No link is available with booking and booking with deduction entries
Reason
The TDS category set for the purchase/expense ledger is not the same as the TDS category selected during voucher entry.
Solution
Setting the appropriate nature of payment will resolve this exception.
To resolve the exception
Press Enter on No link is available with collection voucher.
Select the transaction and click F3: Link All.
Note: If the TDS Category for the ledger is set to Any and a TDS Category is specified during voucher entry, this exception will not arise.
Unable to determine deductee details in cash transactions
Reason
In transactions that Cash has been selected in the field Party's A/C name, there are no deductee details available.
Solution
Selecting the appropriate party ledger will resolve this exception.
To select the party ledger
Press Enter on Unable to determine deductee details in cash transactions
Enter the Party Name or click M: Party List to select a party ledger.
Select the Deductee Type and enter PAN, if the details are not available in the ledger master.
Press Enter.
Press Enter to accept the details.
The exception is now resolved.
TDS deducted but not linked with expense/ purchase transaction
Reason
The deduction entry has not been linked to a booking entry.
Solution
Press Enter on TDS deducted but not linked with expense/purchase trasnaction.
Press Enter on the required entry.
Press spacebar to select the required booking vouchers.
Click F3: Autofill or F4: Full or F5: Partial, as required to enter the amount in Link to Deduction.
Press Enter.
The exception will be resolved.
Expenses/purchase returns not linked with expense/purchase transaction
Reason
The deduction entry has not been linked to a booking entry.
Solution
Press Enter on TDS deducted but not linked with expense/purchase trasnaction.
Press Enter on the required entry.
Press spacebar to select the required booking vouchers.
Click F3: Autofill or F4: Full or F5: Partial, as required to enter the amount in Link to Deduction.
Press Enter.
The exception will be resolved.
Transactions accepted with conflicts
Reason
The transactions recorded have conflicts or mismatches.
Solution
To resolve this conflict
Press Enter on the entry which has conflicts.
Press spacebar on the entry.
Click A: Accept as is.
Press Enter to accept the voucher as is.
This exception will be resolved.
On resolving the exceptions, a transaction will either be included or excluded. All the included transactions will effect the returns calculation. The calculation of tax liability can be viewed in the return form.
This section displays the count of tax payments recorded for the return.
The period considered for displaying the payment details is different from that specified for the returns. This is because tax payments are made in the subsequent month. This can be beyond the range of the period specified for the return period. Hence, to display the payment details, an additional time period of one month from the last voucher date, or the return period specified will be considered.
From the return forms screen you can modify the payment period to make sure the tax payments made in the later period are considered.
To modify the payment period
Press Ctrl+F2 from the return form screen.
Enter the Payment Date.
Press Enter.
The payment transactions will be grouped under Included or Excluded.
Included: All tax payments made in this return period, for the tax return.
Not Included: The payment transactions which have exceptions, and the ones having no implication on the return will be displayed here.
On resolving all exceptions, you can generate returns by exporting to XML/ Excel format. All the required annexures can be generated after resolving exceptions. You can export the returns to XML/ Excel format, and then file your returns.
Return persistence and revised returns
You can save the filed returns for reference. You can use this to compare and generate returns again. The history of the returns can be retained even after modification.
You can modify the returns for any given period (even after filing), and generate revised returns. If the returns have been already saved, thenyou can either over write the changes or save it as revised returns.
All modifications made in the masters and transactions will be tracked for a given period when saved. The changes are grouped as created, altered, deleted, or cancelled. You can view the voucher as it was before modification, compare the values and decide to retain the changes or revert.
A return book register has the list of saved returns. You can navigate to a specific return, recompute, overwrite or save the revised returns from here.