Statistics of Vouchers

Total Number of Vouchers

The count of all  included, excluded, and uncertain transactions is displayed here.

Press Enter to display the Statistics of Vouchers.

Summary of Included Vouchers

Press Enter on Included Transactions.

The Summary of Included Vouchers appears as shown below:

You can drill down to the voucher level to make modifications, or exclude vouchers from this report.

Summary of Excluded Vouchers

Press Enter on Excluded Vouchers.

The Summary of Excluded Vouchers appears as shown below:

You can drill down to the voucher level from this report.

Summary of Exceptions

Press Enter on Uncertain transactions to drill down to the Summary of Exceptions.

Transactions with exceptions can be resolved from this report, and included to form a part of 26Q generation.

Master Related Exceptions

Expenses/ Purchase Master

• Unable to determine the TDS applicability for ledger/ stock item

  Reason

  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

  1. Press Spacebar to select a group.

  2. Click N: Nature of Payment.

  3. Select a TDS Nature of Payment.

  The exception is now resolved.

Party Master

• 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

  1. Press Enter on Unable to determine deductee type for party.

  2. Press Spacebar to select the Name of the Ledger.

  3. Click D: Deductee Type.

  4. 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

  1. Press Enter on PAN not available for the Party.

  2. Enter the PAN of the party and applicability, if PAN is available.

                                                     or

  2. Press Enter in the PAN No field to go to the field PAN Status.

  3. 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.

Duty Master

• 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

  1. Press Enter on Unable to determine TDS applicability of ledgers.

  2. Select the Default Nature of Goods.

  3. 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.

  4. Click N: Nature of Goods to set their Nature of Payments.

   

Nature of Payment

• Unable to determine the tax rate for nature of payment

  Reason

  The tax rate for the nature of payment has not been specified.

  Solution

  1. Press Enter on Unable to Determine the Tax Rate for Nature of Payment.

  2. Select Yes in the column Is Zero Rated, if required. Else, specify the rate of duty in the column Rate.

  3. Press Enter.

  The exception is solved.

Transaction Related Exceptions

Mismatch in Nature of Payment

• 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

  1. Press Enter on No link is available with collection voucher.

  2. 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

  1. Press Enter on Unable to determine deductee details in cash transactions

  2. Enter the Party Name or click M: Party List to select a party ledger.

  3. Select the Deductee Type and enter PAN, if the details are not available in the ledger master.

  4. Press Enter.

  5. Press Enter to accept the details.

  The exception is now resolved.

Deduction Entries

• TDS deducted but not linked with expense/ purchase transaction

  Reason

  The deduction entry has not been linked to a booking entry.

  Solution

  1. Press Enter on TDS deducted but not linked with expense/purchase trasnaction.

  2. Press Enter on the required entry.

  3. Press spacebar to select the required booking vouchers.

  4. Click F3: Autofill or F4: Full or F5: Partial, as required to enter the amount in Link to Deduction.

  5. 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

  1. Press Enter on TDS deducted but not linked with expense/purchase trasnaction.

  2. Press Enter on the required entry.

  3. Press spacebar to select the required booking vouchers.

  4. Click F3: Autofill or F4: Full or F5: Partial, as required to enter the amount in Link to Deduction.

  5. Press Enter.

  The exception will be resolved.

Overridden Entries

• Transactions accepted with conflicts

  Reason

  The transactions recorded have conflicts or mismatches.

  Solution

  To resolve this conflict

  1. Press Enter on  the entry which has conflicts.

  2. Press spacebar on the entry.

  3. Click A: Accept as is.

  4. Press Enter to accept the voucher as is.

  This exception will be resolved.

Deduction Details

The tax deduction details are grouped in the following heads:

• Deduction at Normal Rate

• Deduction at Higher Rate

• Lower Rated Taxable Expense

• Under Exemption limit

• Exempt in lieu of PAN available

Press Enter on the required deduction type to view a detailed report.

Payment Details

All payment vouchers that have been ‘included’ for generating returns, will be captured in this section based on the category of payment.

Drill down to view the Payment Voucher report, where the date, voucher number, duty type (education cess, secondary education cess, etc.) and the respective amount, payment type (Interest, Late Fee, etc.) and the respective amount, and the total amount paid.

Press Enter to view the payment vouchers report.

The following details will be displayed:

• Party Name

• Deductee Type

• PAN

• Rate

• Assessable Value

• Income Tax

• Surcharge

• Education Cess

• Secondary Education Cess

• Total amount paid