Tally Accounting
Posted by Asok K Nadhani on

Tax Deducted at Source (TDS) Reports in Tally

TDS Reports Menu in Tally

After entry of Vouchers relating to TDS, you may print various TDS Reports.

Select Display>Statutory Reports>TDS to get TDS Reports Menu to get TDS Reports menu

TDS Reports Menu in Tally

TDS Computation Report in Tally

At TDS Reports Menu. select Computation to get TDS Computation Statement showing the details of TDS Deducted, Paid, Payable etc.

TDS Computation statement in Tally

TDS Challan Reconciliation in Tally

At the time of Printing Challan, the Challan Number  etc (as stamped by the Bank  when the challan is deposited with Bank with requiste payment) is not available and the info is left blank at the time of Voucher entry.

After  getting the Challan stamped by Bank, you should enter the details of Challan through Challan Reconciliation, reconciling Challans with Tax Deposit Vouchers.

At TDS Reports Menu . select Challan Reconciliation  to get Challan Reconciliation Statement . 

Challan Reconciliation Statement in Tally

Challan Details : At Challan Reconciliation Statement, Click S:Set Challan Details  button, to get Challan Details entry screen.

At Challan Details entry screen, enter the respective details as follows:

  • Period : At Quarter From Date & Quarter To Date , enter the Start Date and End Date of the period for which the Tax is being deposited under the Challan.
  • Bank : At Bank Name, enter the Bank Name at which the Tax is being deposited
  • Bank BSR Code : At BSR Code, enter the Bank BSR Code of the Bank Branch at which the Tax is being deposited
  • Bank Challan No : At Bank Challan No, enter the Bank Challan Number of the TDS Deposit Challan
  • Bank Challan Date : AtChallan Date, enter the Date of Bank Challan of TDS Deposit.

Challan Details entry

Press Alt+A to save the details entered to get back the Challan Reconciliation Statement, showing the details entered.

TDS Challan Reconciliation Buttons in Tally

At Challan Reconciliation Statement, you get following Buttons:

  • F2:Period : To set the Period of the Report
  • F5:Challan Reconcile : To Reconcile the challans (the indicator Reconciliation appear at the heading of Challan Reconciliation Statement for info)

TDS Challan Reconciliation Buttons in Tally     

TDS Returns Printing Menu in Tally

At TDS Reports Menu, select Return to get TDS Returns Menu to showing various TDS Returns printing.

  • TDS Certificate (Form 16A)
  • Quarterly Returns
  • Annual Returns

TDS Statutory  Returns menu

TDS Form 16A Printing in Tally

Form 16A is the certificate of Deduction ad deposit of TDS to government. The deductor  has to submit Form 16A to the deductee.

However, as per current rules, Form 16A, printed through TRACES, from NSDL website is only valid. So, the Form 16A printed from Tally is not valid. You may print as record, to locate any difference between Form 16A of TRCAES and printed from your own records

At TDS Returns Menu , select Print Form 16A to get TDS Form 16A Printing screen and then select the Party for which you like to print Form 16A. Fill up the data to print the Form 16A .

At  TDS Forms 16A printing screen, at Nature of Payment, you may select the specific nature, or select All Items to print all the payments & TDS deductions in respect of the selected Party.

TDS Form 16A Printing in Tally

TDS Form 16A Printing Configuration  in Tally

At Form 16A Printing screen click F12:Configure to get Form 16A Printing Configuration screen to set the printing configuration options.

  • Second Page Title : At Print Form Title on subsequent pages (if applicable) :
    • Set Yes to print Form Title in subsequent pages also (when the Form extends to multiple pages)
    • Set No. Form Title is printed in First Page only (not in subsequent pages)
  • Government Treasury Details : At Print Government Details also :
    • Set Yes to print the section of Government Details also
    • Set No to omit the section of Government  details

TDS Deduction Certificate (Form 16A)

You can select only one Party and enter the printing details again & again at the Printing screen, for printing of  Form 16A, for each Party.

TDS Form 26Q Quarterly Return Printing in Tally

Form 26Q is the quarterly return of TDS, in respect of the Deductor, for payments made to Residents.

At TDS Returns Menu, under Quarterly section, select Form 26Q to get Form 26Q Printing screen.

Form 16A Printing Configuration

At Form 26Q Printing screen,  fill up the required data to print Form 26Q

TDS Form 26Q Printing in Tally

TDS Form 26Q Annexure Printing in Tally

Annexure to Form 26Q is to be annexed the Form 26Q (quarterly return of TDS), containing the details of TDS deducted and deposited to Government.

At TDS Returns Menu, under Quarterly section, select  Annexure to Form 26Q to get Form 26Q Annexure Printing screen.

TDS Form 26Q in Print

At Form 26Q Annexure Printing screen, Fill up the required data to print Form 26Q Annexure

Form 26Q Annexure Printing in Tally

TDS Form 27Q Quarterly Return Printing in Tally

Form 27Q is the quarterly return of TDS, in respect of the Deductor, for payments made to and TDS deducted from  Non- Residents.

At TDS Returns Menu, under Quarterly section, select Form 27Q to get Form 27Q Printing screen .

TDS Form 26Q Annexure in Print in Tally

At Form 27Q Printing screen , fill up the required data to print Form 27Q

TDS Form 27Q Printing in Tally

TDS Form 27Q Annexure Printing in Tally

Annexure to Form 27Q is to be annexed the Form 27Q (quarterly return of TDS), containing the details of TDS deducted and deposited to Government.

At TDS Returns Menu , under Quarterly section, select Annexure Form 27Q to get Form 27Q Annexure Printing screen .

TDS Form 27Q  in Print in Tally

At Form 27Q Annexure Printing screen, Fill up the required data (similar to Form 27Q Printing)  to print Form 27Q Annexure

TDS Form 26 Annual Return Printing in Tally

Form 26 is the Annual Return of TDS, in respect of the Deductor, for payments made to and TDS deducted from  Residents.

At TDS Returns Menu, under Annual section, select Form 26 to get Form 26 Annual Return Printing screen, similar to Form 26Q (Quarterly)  Printing Screen .

At  Form 26Q  Printing Screen,  Fill up the required data to print Form 26 .

Form 27Q Annexure Printing in Tally

TDS Form 26 Annexure printing in Tally

At TDS Returns Menu, under Annual section, select Annexure to Form 26 to get  Annexure to Form 26 Annual Return Printing screen, similar to Form 26Q (Quarterly)  Annexure Printing screen . Fill up the required data to print Form 26 Annexure . 

TDS Form 26 Annual Return in Print in Tally

TDS Form 27 Annual Return printing in Tally

Form 27 is the Annual Return of TDS, in respect of the Deductor, for payments made to and TDS deducted from Non Residents (or Not Ordinarily Residents)

At TDS Returns Menu , under Annual section, select Form 27 (Annual) to get Form 27 Printing screen, similar to Form 26Q Printing screen. Fill up the required data to print Form 27 .

TDS Form 26 Annexure in Print in Tally

TDS Form 27 Annexure printing in Tally

At TDS Returns Menu, under Annual section, select Annexure to Form 27 to get Form 27 Annexure Printing screen, similar to Form 27Q Annexure Printing screen. Fill up the required data to print Form 27 Annexure

TDS Outstanding Reports Menu in Tally

At TDS reports Menu, select Outstandings to get  TDS Outstanding Reports Menu

TDS Form 27 Annual Return in Tally

TDS Payables Reports display in Tally

At TDS Outstanding Menu, select TDS Payables to get TDS Payables report

TDS Outstanding Menu

TDS Payables Reports display Buttons in Tally

The buttons of Outstanding Statement have been described earlier. Here we describe buttons exclusively related to TDS

TDS Payables Reports Display in Tally

F7:Deductee Type : Click F7:Deductee Type button, to get Deductee Type selection screen to select the Deductee Type form the list.

TDS Payables Reports display Buttons in Tally

TDS Ledger Outstanding Display in Tally

At TDS Outstandings menu, select Ledger  to get TDS Ledger  Outstanding Menu.

TDS Deductee Type selection in Tally

At TDS Ledger  Outstanding Menu , select :

  • Al Items to get TDS Ledger Outstandings of all Parties.

TDS Ledger  Outstanding List in Tally

  • One Item and then select the Party Leger Account to get TDS Ledger Outstanding of the selected Party Ledger

TDS Ledger  Outstanding List in Tally

The Buttons and Configuration options of Ledger Outstandings have been described earlier.

TDS Nature of Payments Outstandings Reports Menu  in Tally

At TDS Outstandings menu, select  Nature of Payments  to get TDS Nature of Payments Menu.

TDS  Deductee Ledger  Outstanding display in Tally

At TDS Nature of Payments  Menu , select :

  • All Items to get TDS Outstandings of all types of Nature of Payments .

TDS Nature of Payments Outstanding list  display in Tally

  • One Item and then select the Nature of Payment to get TDS Nature of Payment Outstandings of the selected Nature of Payment.

TDS Nature of Payments Outstanding list  display in Tally

The buttons at Nature of Payments are similar to those of TDS Outstanding

TDS Not Deducted Report in Tally

This Report shows the payments made to parties without deduction of TDS.

At TDS Outstandings menu, select  TDS Not Deducted to get  TDS Not Deducted  Report

TDS Nature of Payments Outstanding Details display in Tally

TDS Not Deducted Display Buttons in Tally

At TDS Not Deducted Report , the following buttons are available related to TDS

  • F7:Show Pending / Show All : Click the toggle Button
  • F7: Show Pending : To show only the Pending  Items for which TDS is not deducted
  • F7: Show All : To show all  Items for which TDS was not deducted

TDS Not Deducted Report Display in Tally

eTDS Statutory Returns in Tally

As per Electronic Filing of Returns of Tax Deducted at Source Scheme 2003 :

  • It is mandatory for Corporate & Government deductors to furnish their TDS returns in electronic form (e-TDS return).
  • Deductors (other than government and corporates) may file TDS return in electronic or
  • physical form.
  • National Securities Depository Ltd. (NSDL) is the e-TDS Intermediary to receive the e-TDS returns from the deductors, on behalf of Income Tax Department.

eTDS  Returns filing in Tally

Deductors furnishing e-TDS returns are required to furnish a control chart in Form 27A in physical form along with the e-TDS return furnished in CD/floppy. Form 27A is a summary of TDS return (Form 24, 26 or 27), which contains control totals of Amount Paidand Tax deducted at source. The control totals mentioned on Form 27A should match with the corresponding control totals in e-TDS return file. Form 27A is required to be furnished separately for each TDS return (Form 24, 26 or 27).

The deductors / collectors preparing e-TDS returns are required to validate their returns with the File Validation Utility (a freely downloadable utility developed by NSDL), to conform to the prescribed format.

eTDS Returns Menu in Tally

At TDS Reports Menu, select E–Return > E–TDS to get e-TDS Menu

Menu in Tally

eTDS Form submission in Tally

Form 26Q is a Quarterlyreturn for deduction of tax in respect of payments made to residents other than salary. To export Form 26Q

Go to Gateway of Tally > Display > Statutory Reports > TDS Reports > E-Return > E-TDS > Form 26Q

  • In Exporting eTDS Form, press Backspaceand enter the following details
  • By default, the Language and Format is preset as Restricted (ASCII Only)and SDF (Fixed Width)respectively.
  • In Export Locationfield enter the details of the path to where the txt file to be exported.
  • In the Output File Namefield specify the file name as Form 26Q.txt
  • Press Enterto Accept the Person Responsible Details(The Address details are automatically defaulted from the Company masters in the Person Responsible Details column)
  • Select Yesor Noas applicable, in Is Change in Address since last Returnfield.
  • Under Other Details, In Category (Deductor/Collector)field select the Deductor Categoryand specify the applicable date in the Fromand Tofields
  • Specify Challan Datein the Challan Date Tillfield (i.e., Challan date to be considered for TDS payments made for the respective quarter/period)
  • In Form Namefield, Form 26Qis defaulted
  • Specify the Placeand Dateof Filing Returns

View PDF