Summary of included transactions
This section displays the total number of transactions, categorized as Included, Excluded and Uncertain, pertaining to a period.
1. Total Number of Transactions: This displays the total number of transactions for a particular period. The total count is categorized as included transactions, excluded transactions, and uncertain transactions. Voucher count appears against each of these categories. The drill-down report of this row displays the Statistics report, which comprises voucher types with the corresponding voucher count.
2. Included Transactions: This displays the number of transactions included in the report for a particular period. All vouchers having the required information, either in corresponding masters or in transactions, satisfying the requirements for filing returns are included here. These vouchers are a part of both VAT and CST Form - including all VAT/CST sales transactions, VAT/CST purchase transactions, VAT/CST sales and purchase returns, and VAT/CST adjustments.
o Annexure Ready: This displays the count of error-free purchase and sales transactions which form part of VAT Annexures. These transactions are captured under Included Transactions.
o Annexure Errors: This displays the count of purchase and sales transactions with errors which form part of annexures. Although only the voucher count is provided for Annexure Ready and Annexure Errors, the transaction details are made available in the drill-down reports to facilitate corrections to be made.
o Non Annexure Vouchers: This section displays the count of transactions which are not considered in the Annexures.
3. Excluded Transactions: This section excludes all vouchers which are not related to VAT/CST, and do not form part of the Form VAT 100 returns generation. These transactions do not carry details pertaining to VAT and CST, and do not have any implication on Form VAT 100.
4. Uncertain Transactions: Vouchers which fall neither under Included Transactions nor under Excluded Transactions are displayed here. These vouchers are related to VAT/CST, but they do not carry the information required to qualify as Included.
The following transaction types will fall in Included Transaction:
● Purchase: Displays the count of all purchase transactions recorded in purchase, journal and payment vouchers.
● Sales: Displays the count of all sales transactions recorded in sales, journal and receipt vouchers.
● VAT Adjustment: Displays the count of all journal vouchers recorded for VAT adjustments.
● Sales Returns: Displays the count of sales returns recorded in journal and credit note.
● Purchase Returns: Displays the count of purchase returns recorded in journal voucher and debit note.
● Purchase Tax: Displays the journal voucher recorded by selecting Tax on URD Purchase as the nature of adjustment.
To view any of the transactions
● Select the transactions types (Sales or Purchase or VAT Adjustment or Sales Returns or Purchase Returns or Purchase Tax) and press Enter
To exclude the voucher
● Press Spacebar to select the required voucher.
● Click X: Exclude Vouchers.
A message Do you want to exclude this voucher? is displayed. Click Yes to exclude the voucher.
Excluded Transactions Details screen displays count of all the transactions which are not considered for generating the returns.
To view the Exclude Transactions Details screen
1. Select Excluded Transactions in Form VAT 10 report.
2. Press Enter. The condensed view is displayed.
3. Click F1: Detailed to display the detailed mode.
● Vouchers Excluded by Users: Displays the count of transactions which have been manually excluded from list of included or uncertain transactions. If any transaction has been inadvertently excluded, it can be moved back to included or uncertain transactions by clicking the I: Include Vouchers button.
● Contra: Displays the count of contra entries which involve only bank and cash ledgers.
● Payroll Vouchers: Displays the count of transactions recorded using payroll and attendance vouchers. VAT does not apply to these transactions.
● Order Vouchers: Displays the count of sales order, purchase order, job work in order and job work out order vouchers as VAT is not applicable while placing an order.
● Inventory Vouchers: Displays the count of receipt note, stock journal, delivery note, material in, material out, rejections in, rejections out and physical stock vouchers as they are purely inventory in nature and do not attract VAT.
● No VAT Implications: Displays the count of receipts and payments.
● Other Vouchers: Displays the count of memorandum and reversing journal vouchers. All the categories and voucher types are not displayed by default. Based on the voucher type used and the exclusions done by user, the relevant categories appear with the transaction count.
To view the transactions grouped under each category
1. Select the category or voucher type.
2. Press Enter to view the Voucher Register screen.
3. Select the transaction, and press Enter to view it in alteration mode.
To display narration entered for each voucher
● Click F12: Configure in the Voucher Register screen.
● Set the option Show narrations to Yes.
Summary of Exceptions screen displays the count of transactions which are neither included nor excluded in the VAT Form due to insufficient information.
To view the Summary of Exceptions screen
● Select Uncertain Transactions in Form VAT 10 report.
● Press Enter.
Unable to determine country/state: Displays the transactions for which state is not selected in the party ledger master.
Unable to determine party's dealer type: Displays the transactions for which dealer type is not selected in the party master.
Unable to determine duty type of ledger: Displays the transactions for which the duty type is not selected in the tax ledger grouped under Duties & Taxes.
Unable to determine tax details of the stock group/stock item(s): Displays the stock groups (if linked to stock items), and stock items grouped under it, for which the VAT rate is not defined either in master or at the company level.
Unable to determine tax details of group/ledger(s): Displays the account groups, and ledgers grouped under it, for which the tax rate is not defined either in master or at the company level.
Conflict in party's country/state in master and transaction: Displays the transactions in which the state selected is different in transaction and party ledger.
Transactions accepted with tax information conflicts: Displays the transactions in which the Nature of Transaction defined in the ledger master has been changed in the transaction without causing any impact on the tax amount.
Mismatch in tax amount: Displays the transactions with difference between the calculated amount and transaction value.
Transactions may appear with the following exceptions:
● Assessable Value Modified: This exception occurs when assessable value is modified in the transaction.
● Assessable Value/Rate Modified: This exception occurs when assessable value and tax rate are modified in the transaction.
● No Tax Involved: This exception occurs when VAT ledger is not selected in the transaction.
● Rate Value Modified: This exception occurs when tax rate is modified in the transaction.
● Rounded Off: This exception occurs when VAT amount is altered in the invoice by:
o Rounding off the decimals.
o Entering the decimals.
● Wrong Calculation: This exception occurs when incorrect VAT or CST amount is entered in the transaction.
● Wrong Duty Ledger: This exception occurs when VAT ledger (with Type of Duty/Tax set to VAT) is selected in interstate transactions and CST ledger (with Type of Duty/Tax set to CST) is selected in local purchases and sales.
Unable to determine nature of adjustment: Displays the journal vouchers recorded with tax ledger (grouped under Duties & Taxes), without selecting Nature of Adjustment.
Unable to determine purchase tax details: Displays list of journal vouchers recorded with Tax on URD Purchase as the Nature of adjustment, without entering the Rate and Assessable Value in VAT Details screen, displayed on crediting the VAT ledger.