The Statistics of Vouchers section in VAT Form 100 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:
● Sales
The following nature of transactions are provided for sales which can be defined either in the master or transaction level:
● Sales – Taxable
● Sales – Works Contract
● Sales – Exempt
● Sales – Zero rated
● Exports
● Deemed Export
● Interstate Sales Special Category Goods
● Interstate Sales-Taxable
● Interstate Sales-Works Contract
● Interstate Sales-Tax Free
● Interstate Sales-Exempt
● Interstate Sales-E1
● Interstate Sales-E2
● Consignment Transfer Outward
● Interstate Consignment Transfer Outward
● Branch Transfer Outward
● Interstate Branch Transfer Outward
● Purchase
The following nature of transactions are provided for purchases which can be defined either in the master or transaction level:
● Purchase Taxable
● Purchases – Capital Goods
● Purchases – Works Contract
● Purchases – Exempt URD
● Interstate Purchases – Taxable
● Consignment Transfer Inward
● Interstate Consignment Transfer Inward
● Branch Transfer Inward
● Interstate Branch Transfer Inward
● Imports
● Sales Returns and Purchase Return Transactions
This displays the count of sales or purchase returns which are recorded in Journal, Credit Note, Debit Note, Receipt or Payment vouchers. Based on the selection of purchase and sales ledgers, the nature of transactions will be displayed.
This displays the count of all the journal vouchers passed for VAT Adjustments.
To view the voucher register for VAT Adjustment
● Select VAT Adjustment and press Enter.
To view either the sales register or purchase register
● Select Sales or Purchase 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.
This displays the count of excluded voucher types which do not affect VAT. The following transaction types will fall in Excluded Transaction:
● Vouchers Excluded by User: This includes transactions manually excluded by users
● Contra Vouchers: Contra vouchers are not used for VAT related transactions, so it appears under Excluded Transaction.
● Payroll Vouchers: Payroll vouchers are used for maintaining attendance, salary processing etc which do not have VAT related transactions.
● Order Vouchers: This includes the following order vouchers:
o Sales Order
o Purchase Order
o Job work out Order
o Job Work In Order
● Inventory Vouchers: The following vouchers are included in Inventory vouchers:
o Stock/Manufacturing Journal
o Physical Stock Journal
o Rejection In/Out
o Material In/Out
o Job Work In/Out Order
o Delivery Note
o Receipt Note
● No VAT Implications: This includes all payment and receipt vouchers without any sales and duty ledgers. The receipt vouchers include:
o Party receipts
o Income/Expense Receipts
o Journals (Adjustment Entries)
o Post Dated Vouchers
● Other Vouchers: This includes Memorandum Vouchers, Reversing Journal.
● Excluded due to other adjustments: This show displays the count of adjustment transactions recorded in journal which are identified as service tax adjustments, excise adjustments.
To view the excluded voucher type
● Select the required voucher type and press Enter.
To include the voucher
● Select the required voucher in Vouchers Excluded By User.
● Click I: Include Vouchers.
This displays the count of transactions which were neither included nor excluded in the VAT Form due to insufficient information about the masters or transaction.
The Uncertain Transactions Details screen has the following groups:
When the information provided in the masters created is uncertain, the exception is listed under Master Related Exceptions.
● 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 items: 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 Information
Conflict in party's country/state in master and transaction: This displays the count of transactions for which the country or state of the party in the transaction cannot be determined. To resolve this, the list of transactions having this conflict can be opened from this screen, and the required information can be either entered or edited using the option R:Define Location Type.
Transactions accepted with tax information conflicts: This displays the count of transactions for which the tax details were overridden before or at the time of passing transaction. To resolve this, the transactions can be either accepted or excluded using the options provided.
Tax Mismatch
Mismatch in Tax Amount: This displays the count of transactions in which there is a difference between the auto-calculated tax amount, and the amount entered by user. To resolve this, the values in their respective vouchers can either rounded off, or the voucher can be excluded using the relevant options.
VAT/CST Adjustment:
Unable to determine the nature of adjustment: This displays the count of transactions for which the VAT flag is not selected in the journal voucher. To resolve this issue, the required voucher can be edited or excluded using the options provided.
Unable to determine purchase tax details: This displays the count of transactions for which the purchase tax details are not defined. To resolve this issue, the required voucher can be modified or excluded using the options provided.
● 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 the 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 (Karnataka)' has been shared with
