Generate TDS Reports

Generate TDS Reports

You can generate and view a few MIS reports required for TDS.

 

Ledgers Without PAN

While filing e-TDS returns, the correct PAN should be defined in the party ledgers configured for TDS deduction. The report Ledgers without PAN displays the list of all the party ledgers configured for TDS deduction for which PAN is not defined. You can configure it to view the list of all ledgers for which PAN is defined, and the PAN can be corrected, if required. Additionally, you can view information on the Deductee Type, Contact Person, and Contact Number defined in the party ledger.

In this section

 

View the party ledger for which PAN is not specified and enter the PAN

  1. Gateway of Tally > Display More Reports > Statutory Reports > TDS Reports > Ledgers without PAN.
    Alternatively, press Alt+G (Go To) > type or select TDS Reports > Ledgers without PAN > and press Enter.

    Based on the availability of PAN for the party ledger, enter the PAN as shown below:
  2. Accept the screen. As always, you can press Ctrl+A to save and return to the TDS Return menu.

 

View the ledgers for which PAN is specified but needs to be corrected

  1. Press Enter on Ledgers without PAN in the TDS Reports menu.
  2. Press F8 (All Ledgers) to view the list of ledgers for which PAN is defined.
  3. Select the PAN/IT No. that needs to be corrected.
  4. Modify the PAN/IT No., as required.
  5. Accept the screen. As always, you can press Ctrl+A to save. The corrected PAN gets updated in the party ledger master.

 

Report description

A brief explanation on the fields and columns provided in this report is given below:

Field/Column Name

Description

No. of Deductees

Displays the total count of party ledgers configured for TDS deduction (the option Is TDS Deductable is set to Yes in party ledger). This field appears when you press F8 (All Ledgers) in the Ledgers without PAN report.

PAN Empty

Displays the percentage of party masters for whom PAN is not defined. This field appears when you press F8 (All Ledgers) in the Ledgers without PAN report.

Supplier Ledger Name

Displays the Name of the party ledger configured for TDS deduction.

Deductee Type

Displays the Deductee type selected in the party ledger.

Contact Person

Displays the name of the Contact person entered in the party ledger.

Contact Number

Displays the Phone no. entered in the party ledger.

PAN/IT No.

Displays the PAN/IT No. entered in the party ledger.

 

TDS Outstanding Report

The TDS Outstanding report displays all the pending TDS payments. You can view the pending details party-wise, or based on resident or non-resident status.

In this section

 

View TDS Outstanding report

  1. Gateway of Tally > Display More Reports > Statutory Reports > TDS Reports > TDS Outstandings.
    Alternatively, press Alt+G (Go To) > type or select TDS Reports > TDS Outstandings> and press Enter.

A brief explanation about the fields in the report is given below:

Field Name

Description

Nature of Payment

Displays the name of the TDS Nature of Payment as specified in the duty ledger which was used in recording the TDS booking with deduction or TDS deduction entry.

Company

Displays the total amount of outstanding for all parties of Company-resident deductee type used in recording the TDS booking with deduction or TDS deduction entry.

Non Company

Displays the total amount of outstanding for all parties of Individual/HUF-resident deductee type used while recording the TDS booking with deduction or TDS deduction entry.

Total Pending

Displays the total outstanding amount of all TDS payment from all parties.

 

View section code, payment code and pending payment payable details of non-resident, resident, or both

  1. Press F12 (Configure) in the TDS Nature of Payment Outstandings report.
  2. Set the options Show Section Code and Show Payment Code to Yes. Select the required resident type.
  3. Accept the screen. As always, you can press Ctrl+A to save.

    By default the report appears category-wise, you can change it to party-wise by pressing F5 (Party-wise).

 

View the party-wise TDS details

Press F5 (Party-wise) to view the party-wise details.

 

View the transaction details for each nature of payment

  1. Select the required Nature of Payment and press Enter. The TDS Nature of Payment Outstandings report for the selected nature of payment appears.
  2. Ctrl+B (Basis of Values) In TDS Nature of Payment Outstandings, you can display the Range of Bills Type in reports. Press Ctrl+B (Basis of Values) > Range of Bills Type > select All Bills. Press Esc to view the default values. Similarly, you can select different Range of Bills Type to display and compare the effect on your report values. Press Ctrl+B (Basis of Values) > Range of Bills Type > select Overdue Bills, or Pending Bills, as needed. Press Esc to view the default values.
  3. Press F12 (Configure) to change the display of report in terms of the following options:
    1. Format of Report
    2. Sorting Method

A brief explanation about the report fields is given below:

Field Name

Description

Date

Displays the date of recording payment, journal or purchase voucher.

Ref. No.

Displays the reference number entered in the payment, journal or purchase voucher.

Party’s Name

Displays the party name from where TDS is deducted and the payment for the same are yet to be made.

Opening Amount

Displays the opening amount of TDS.

Pending Amount

Displays the pending amount of payment to be made to the government.

Due On

Displays the last date of payment.

Overdue By Days

Displays the number of days passed after the due date.

 

TDS Reconciliation Report

The TDS Reconciliation report displays the all the reconciled TDS payments.

  1. Gateway of Tally > Display More Reports > Statutory Reports > TDS Reports > Challan Reconciliation.
    Alternatively, press Alt+G (Go To) > type or select TDS Reports > Challan Reconciliation> and press Enter.
  2. Press F8 (Show All) to show all or pending challan.
  3. Ctrl+B (Basis of Values) In TDS Challan Reconciliation, you can display the List of Configurations in reports. Press Ctrl+B (Basis of Values) > Show All Challan Types to Yes. Press Esc to view the default values.
  4. Press Alt+R (Reconcile).

Note: As per NSDL department file validation tool, challan number and challan date are not mandatory. In case of online TDS duty payment, user can provide the challan number and challan date or leave the fields blank, and validate E-TDS file successfully.

Column Names

Description

Date

Displays the payment voucher date.

Particulars

Displays the duty ledger selected in the voucher.

E-TDS Quarter Period

Displays the From and To dates entered at the Statutory Payment Details screen. If TDS duty payment is recorded manually, the quarterly period has to be entered manually here.

Section No.

Displays the section number of the TDS Nature of Payments entered at the Statutory Payment Details screen of the TDS duty payment entry.

Deductee Type

Displays the Deductee Status Type entered at the Statutory Payment Details screen of the TDS duty payment entry.

Resident Type

Displays the Residential Status entered at the Statutory Payment Details screen of the TDS duty payment entry.

Cheque/DD No.

Displays the cheque or DD number which were entered manually at the time or reconciliation.

Cheque/DD Date.

Displays the cheque or DD date which were entered manually at the time or reconciliation.

BSR Code

Displays the BSR Code of the bank which was entered manually at the time or reconciliation.

Challan No.

Displays the challan number provided by the bank which was entered manually at the time of reconciliation.

Challan Date

Displays the challan date provided by the bank which was entered manually at the time of reconciliation.

Vch No.

Displays the payment voucher number.

Amount

Displays the amount paid recorded in the TDS payment voucher.

Did you find this article useful?