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.
The following nature of transactions are provided for purchases which can be defined either in the master or transaction level:
● Branch Transfer Inward
● Consignment Transfer Inward
● Imports
● Interstate Branch Transfer Inward
● Interstate Consignment Transfer Inward
● Interstate Purchase - Against Form C
● Interstate Purchase Deemed Export
● Interstate Purchase - E1
● Interstate Purchase - E2
● Interstate Purchase Exempt - E1
● Interstate Purchase - Taxable
● Interstate Purchase - Zero Rated
● Purchase From Composition Dealer
● Purchase From Unregistered Dealer
● Purchase Taxable
● Purchase Tax Free
● Purchase - Works Contract
● Sales: Displays the count of all sales transactions recorded in sales, journal and receipt vouchers.
The following nature of transactions are provided for sales which can be defined either in the master or transaction level:
● Branch Transfer Outward
● Consignment Transfer Outward
● Deemed Export
● Exports
● Interstate Branch Transfer Outward
● Interstate Consignment Transfer Outward
● Interstate Deemed Export
● Interstate Labour Charges Collected
● Interstate Sales - Against Form C
● Interstate Sales - E1
● Interstate Sales - E2
● Interstate Sales Exempt
● Interstate Sales Exempt - E1
● Interstate Sales - Others
● Interstate Sales - Taxable
● Interstate Sales - Tax Free
● Interstate Sales - Zero Rated
● Interstate Transfer Outward - Principal
● Labour Charges Collected
● Sales Exempt
● Sales - Others
● Sales Taxable
● Sales - Works Contract
● Sales Zero Rated
● VAT Adjustment: Displays the count of all journal vouchers recorded for VAT adjustments.
To display the list of journal vouchers
1. Select VAT Adjustments.
2. Press Enter. The Voucher Register screen appears with all the journal vouchers recorded by selecting the nature of adjustments and VAT ledgers.
On selecting VAT ledger, a sub-screen appears in the voucher to provide assessable value, tax and/or commodity details. Only when these details are provided in the are provided, it gets considered in the Included Transactions count.
3. Select the required Voucher and press Enter.
To exclude a voucher from being considered in the count of Included Transactions
● Select the voucher, and click X: Exclude Vouchers.
● Sales Returns: Displays the count of sales returns recorded in journal and credit note.
To display the list of sales returns transactions
1. Select Sales Returns.
2. Press Enter.
3. The Voucher Register screen appears with all the sales returns vouchers included in the count of Included Transactions.
4. Select the required voucher, and press Enter.
To exclude a voucher from being considered in the count of Included Transactions
● Select the voucher and click X: Exclude Vouchers.
● Purchase Returns: Displays the count of purchase returns recorded in journal voucher and debit note.
To display the list of purchase returns transactions
1. Select Purchase Returns.
2. Press Enter.
3. The Voucher Register screen appears with all the purchase returns vouchers included in the count of Included Transactions.
4. Select the required voucher, and press Enter.
To exclude a voucher from being considered in the count of Included Transactions
● Select the voucher and click X: Exclude Vouchers.
● 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.
To resolve this exception
1. Select the exception Unable to determine country/state.
2. Press Enter. All the ledgers for which state is not selected are displayed with corresponding count of transactions in which they are used.
3. Select the state using any of the following methods:
● Set Location
o Click S: Set Location button.
o Select the State.
o Select the Dealer Type.
o Press Ctrl+A to accept.
● Edit
o Press Ctrl+E to display the Multi Ledger Alteration.
o Select the Country.
o Select the State.
o Select the Dealer Type.
o Press Ctrl+A to accept.
● Set as Common Party (when purchase and sales of different items are recorded using the same party ledger)
o Press Spacebar.
o Click C: Common Party button.
o Press Enter to accept the message Do you want to set as 'Common Party'.
Unable to determine party's dealer type: Displays the transactions for which dealer type is not selected in the party master.
To resolve this exception
1. Select the exception Unable to determine party's dealer type.
2. Press Enter.
All the ledgers for which dealer type is not selected are displayed with corresponding count of transactions in which they are used.
3. Select the dealer type using any of the following methods:
● Set Dealer Type
o Click S: Set Dealer Type.
o Select the Type of Dealer.
o Press Ctrl+A to accept.
● Edit
o Press Ctrl+E to display the Multi Ledger Alteration screen.
o Select the Dealer Type.
o Press Ctrl+A to accept.
● Set as Common Party (when purchase and sales of different items are recorded using the same party ledger)
o Press Spacebar.
o Click C: Common Party button.
o Press Enter to accept the message Do you want to set as 'Common Party'.
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.
To resolve this exception
1. Select the exception Unable to determine duty type of ledger.
2. Press Enter. All the ledgers (grouped under Duties & Taxes) in which the Type of duty/tax is set to Others are displayed with corresponding count of transactions in which they are used. These ledgers appear when tax amount is manually entered in the transaction.
3. Click S: Set Duty Type.
4. Select Type of duty/tax from the list.
5. Press Ctrl+A to accept.
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.
To solve this exception
1. Select the exception Unable to determine the tax details of the Stock Group/Stock Item(s).
2. Press Enter.
Note: Stock group-wise details can be changed to item-wise listing by clicking F5: Item-wise (Grouped) toggle button.
3. Click S: Set Rate.
4. Enter the Applicable From date.
5. Select the Tax Type.
6. Enter the Tax Rate.
7. Save the screen.
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.
To resolve this exception
1. Select the exception Unable to determine the tax details of Group/Ledger(s).
2. Press Enter.
Note: Group-wise details can be changed to ledger-wise listing by clicking F5: Led-wise (Grouped) toggle button.
3. Click S: Set Rate.
4. Enter the Applicable From date.
5. Select the Tax Type.
6. Enter the Tax Rate.
7. Press Ctrl+A to accept the screen.
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.
To solve this exception
1. Select the exception Conflict in party's country/state in master and transaction.
2. Press Enter. Under each transaction, the following two rows are displayed:
o State in Voucher with name of the state selected in Party Details screen of the invoice.
o State in Ledger Master with name of the state selected in party ledger.
To display narration of each transaction, click F12: Configure and enable the option Show Narration also.
3. Click S: Resolve Conflict button. You can select the state which is defined either in the transaction or ledger master.
4. Select Ledger or Voucher for the option Consider Party Location from.
5. Save the screen.
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.
Transactions get categorized under this exception when there is no impact on the tax amount despite selection of a different Nature of Transaction in the invoice.
To solve this exception
1. Select the exception Transactions accepted with tax information conflicts.
2. Press Enter.
3. Click F12: Configure to display narration of each transaction and enable the option Show Narration also.
4. Click A: Accept as is button to accept the invoice with the Nature of Transaction selected in the invoice.
5. Press Enter to solve the conflict.
Mismatch in tax amount: Displays the transactions with difference between the calculated amount and transaction value.
To resolve this exception
1. Select the exception Mismatch in tax amount.
2. Press Enter.
3. Use any of the following options to solve it:
o Click A: Accept as is to accept the transaction without making any corrections. The accepted transactions will be moved under Included Transactions.
o Click S: Create Adjustment to create a journal voucher to account for difference in tax amount. For this adjustment entry, Nature of Adjustments should not be selected.
o Click L: Link Adjustment to link it to an existing transaction. On clicking this button, the list of transactions which can be linked will be displayed for selection. If any of it can be linked, select it and click S: Save button.
Transactions may appear with the following exceptions:
● Assessable Value Modified: This exception occurs when assessable value is modified in the transaction.
To modify or override assessable value in purchase or sales invoice
1. Click F12: Configure in invoice and set the options as given below:
o Use common ledger A/c for item allocation to No.
o Allow modification of Tax Details in VAT to Yes.
2. Select the purchase or sales ledger in the Accounting Details screen and press Enter. The VAT Details screen is displayed.
3. Click F12: Configure on VAT Details screen and set the option Allow override of Assessable Value? to Yes.
4. Enter the modified Assessable Value.
5. Accept the VAT Details screen.
6. Select VAT ledger in the invoice and accept the transaction.
● Assessable Value/Rate Modified: This exception occurs when assessable value and tax rate are modified in the transaction.
To modify or override tax details in purchase or sales invoice
1. Click F12: Configure in invoice and set the options:
o Use common ledger A/c for item allocation? to No.
o Allow modification of Tax Details in VAT? to Yes.
2. Select the purchase or sales ledger in the Accounting Details screen and press Enter. The VAT Details screen is displayed.
3. Click F12: Configure of VAT Details screen and set the following options to Yes.
o Allow override of Assessable Value?
o Allow override of Tax Rate?
4. Enter the modified Tax Rate and Assessable Value.
5. Accept the VAT Details screen.
6. Select VAT ledger in the invoice and accept 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.
To modify or override tax details in purchase or sales invoice
1. Click F12: Configure in invoice and set the option Allow modification of Tax Details in VAT? to Yes.
2. Select the purchase or sales ledger in the Accounting Details screen and press Enter. The VAT Details screen is displayed.
3. Click F12: Configure of VAT Details screen and set the option Allow override of Tax Rate? to Yes.
4. Enter the modified Tax Rate.
5. Accept the VAT Classification Details screen.
6. Select VAT ledger in the invoice and accept 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.
To resolve this exception
1. Select the exception Unable to determine nature of adjustment.
2. Press Enter.
3. Click S: Set Details.
4. Select the Type of duty/tax from the list.
5. Select the Nature of Adjustment and the applicable Additional Details.
6. Press Ctrl+A to accept the Stat Adjustment Details screen.
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.
To resolve this exception
1. Select the exception Unable to determine purchase tax details.
2. Press Enter.
To display narration of each transaction, click F12: Configure and enable the option Show Narration also.
3. Select the journal voucher, and press Enter.
4. Select the VAT ledger, and press Enter.
5. Enter the Rate and Assessable Value in VAT Details screen.
6. Press Ctrl+A to accept the journal.
'Statistics of Vouchers - Form VAT 10 (Rajasthan)' has been shared with
