How to use the TDS Register Report

October 18, 2023

What is TDS?

The government introduced the TDS (Tax Deducted at Source) system to collect tax at the source from individuals or entities making payments. In India, there are various sections (nature of transactions) under which TDS is deducted by the payer and the rates also vary according to the nature of the transaction and in certain cases based on the nature of the payee. So, let’s dive into using the TDS Register Report.

TDS in Tally

In Tally, it is possible to setup TDS tracking. The following are the steps to setup TDS in Tally:

1. To setup TDS you have to first enable it through F11 -> Features
2. Setup the deduction ledgers through the ledger screen by creating ledgers under the Duties and Taxes group
3. In Expense Ledgers then you can tag the TDS applicability through the “Is TDS Applicable” setting and also select the Nature of Payment from the List of Nature of Payments
4. In party master, you will have to tag the TDS applicability and also specify the nature of the party since the rates vary in some sections according to the party type
5. You can also setup the nil or lower deduction certificate details in the party master if the same is applicable
6. Now when the setup is complete you can pass transactions and the TDS should automatically be applied

Reporting on TDS

If you have maintained the setup in Tally and pass transactions according to the guidelines then you should be able to get the TDS register from Tally itself including return formats.

However, for a lot of users of Tally, there is difficulty in maintaining the setup and passing transactions with the required rules. In such cases, the TDS register report in EasyReports would help you to report on the TDS deductions.

The TDS register provides a columnar view of the bookings done in the TDS ledger. In one view itself, you can see all the transactions passed in the TDS ledger and see the bookings party-wise with the details of the debit to the expense account and the party or bank credits. If there are any adjustments or payments in the TDS ledger the same would also show up.

This report would be extremely helpful to accountants and auditors as well since it would save a lot of time with ledger scrutiny for statutory and tax audit purposes. Combined with the “Expense Register” report from EasyReports one can easily get data for tracking TDS.