Select Your Language :

TDS on Expenses @ Lower Rate [TDS] in Tally.ERP9

Assessing Officer shall issue a certificate for deduction of Tax at Lower rate than the relevant rate specified under the section, Where the assessing officer is satisfied that the total income of the recipient (Assessee) justifies the deduction of income tax at any lower rates than the rate specified under the sections specified under the act and has received an application in Form 13 from the assessee under sub-section (1) of section 197.

The certificate granted shall be valid for the assessment year specified and is valid only for the person named therein.

In Tally.ERP 9, the user can record and compute TDS on transactions, on which lower rate of deduction is applicable.

Example: ABC Company received a Bill from ACE Computers for Rs.80,000 towards commission charges.

ACE Computers has a certificate for deduction of Income tax at Lower rate @ 5%, on Commission.

Step 1: Create Party Ledger

Set Up:

In F12: Configure (Ledger Configuration)

  • Set Allow Advanced entries in TDS Masters to Yes


To Create Ledger

Go to Gateway of Tally > Accounts Info. > Ledgers > Create

  1. Enter the Name of the Party Ledger e.g. ACE Computers

  2. Select Sundry Creditors from the List of Groups in the Under field

  3. Set Maintain balances bill-by-bill to Yes

  4. Enter the Default Credit Period, if required.

  5. Set Is TDS Deductable to Yes

  6. In the Deductee Type field, select Partnership Firm from the List of Deductee Type

  7. Set Use Advanced TDS Entries to Yes

Note: Use Advanced TDS Entries field will be enabled in the ledger creation screen only when Allow Advanced entries in TDS Masters is set to Yes in  F12: Configure (Ledger Configuration).

  1. In Advanced TDS Entries screen

  2. Set the option  Zero / Lower Deduction to Yes


  1. In Zero / Lower Deduction Details screen

  2. Nature of Payment: Select the Nature of payment for which the lower rate of income tax is allowed. E.g. Commission Or Brokerage

  3. Section Number: Tally.ERP 9 displays the Sections, under which an application for lower rate (section 197) or Zero rate (197A) are approved.

  4. Certificate No./ Date: Enter Lower rate certificate number and the date of issue.

  5. Applicable From: Mention the date (as per the certificate) from when the lower rate is approved.       

  6. Applicable To: Mention the date till when the certificate of Lower rate will remain in force.

  7. TDS: Mention the Rate of Income Tax         

  8. Surcharge, Ed Cess and Sec Ed Cess: Tally.ERP 9 defaults the rate as Zero.


  1. Under Advanced TDS Entries, set Deduct TDS in Same Voucher if Applicable to Yes


Note: when the option Deduct TDS in Same Voucher if Applicable is enabled, the income tax will be automatically deducted in the same voucher where the Due/ Payment is accounted for the party.

  1. In Deduct TDS in same voucher if Applicable screen

  2. Nature of Payment: In this field you can select all nature of payments or any nature of payment (applicable to the party) on which the Tax to be deducted in the same voucher. Eg. Commission Or Brokerage


  1. Enter Address, State and PIN Code under Mailing Details.

Note: From Rel 4.8 an option to provide Bank Details is provided in the Ledger Master.

  1. Enter PAN/IT No. under Tax Information.


  1. Press Enter to accept and save.


Step 2: Create a Journal Voucher

To create a Journal voucher

Go to Gateway of Tally > Accounting Vouchers > F7: Journal

  1. Press F2 and change the date to 30-04-2009.

  2. In Debit field select Commission Charges from the List of Ledger Accounts.

  3. Enter 80,000 in the Amount field.

  4. In TDS Nature of Payment Details screen, accept the default details.

  5. In the Credit field select Ace Computers and press Enter.

  6. In TDS Details screen

  7. In Type of Ref field select New Ref from the Method of Adjustment.

  8. In Name field, accept the default TDS Reference Number – Jrnl / 6-1.

  9. In Nature of Payment field select Commission Or Brokerage from the List of Nature of Pymt(s).

  10. In Is Zero/ Lower Rate field select section 197 for Lower Deduction.

  11. Select TDS – Commission Or Brokerage in the TDS Duty Ledger field.

  12. In the Assessable Amount field, the amount as specified against the expenses ledger will be defaulted.

  13. Deduct now field will be defaulted to Yes and Tally.ERP 9 won’t allow the user to alter the setting.

Note: Deduct now field will be defaulted to Yes, when the option Deduct TDS in Same Voucher if applicable is enabled in the Party Ledger for the Nature of Payment (selected in the transaction).  

  • TDS Amount field displays the Tax Deducted at Source.

  • Payable Amount field displays the amount (after TDS) payable to the Party.


  1.  Payable Amount as calculated in the TDS Details screen will be defaulted in the Party’s Amount (Credit) field.

  2. In Bill-wise Details screen

  3. Select New Ref as the Type of Ref

  4. In the Name field enter the Bill name as Bill-099

  5. Skip the Due Date or Credit Days field

  6. Accept the default amount allocation and Dr/Cr. By default Tally.ERP 9 displays the Bill amount in the amount field as the credit balance.

  7. Select New Ref as the Type of Ref

  8. In the Name field enter the Bill name as Bill-099

  9. Skip the Due Date or Credit Days field

  10. Accept the default amount allocation and Dr/Cr. By default Tally.ERP 9 displays the Tax amount in the amount field as the credit balance


  1. In the Credit field select TDS – Commission Or Brokerage  from the List of Ledger Accounts.

  2. In the Amount field, Rs. 4,120 is displayed automatically.

  3. Enter Narration, if required.


  1. Press Enter to accept and save.

Tally.ERP 9 Reference Manual LIBRARY
Installation of Tally.ERP9
Site Licensing of Tally.ERP9
Shortcut Keys in Tally.ERP9
Maintaining Company Data
Creating Masters
5a. Accounts Information [Creating Masters]
5b. Inventory Information [Creating Masters]
Voucher Entry
Reports in Tally.ERP9
Excise for Dealer
Excise for Manufacturer
Reports [ Excise for Manufacturer]
Excise for Importer
Service Tax in Tally.ERP9
Tax Collected at Source (TCS) in Tally.ERP9
Tax Deducted at Source (TDS) in Tally.ERP9
Value Added Tax (VAT) in Tally.ERP9
Central Sales Tax (CST) in Tally.ERP9
GST using Tally.ERP9
Disclaimer :
Tally, Tally 9, Tally9, Tally.ERP, Tally.ERP 9, Tally.Server 9, Tally.NET & Power of Simplicity are either registered trademarks or trademarks of Tally Solutions Pvt. Ltd. in India and/or other countries. All other trademarks are properties of their respective owners.
The visitors may click here to visit the web site of Tally Solutions Pvt. Ltd. for resolving their doubts or for clarifications