Tax Collected at Source (TCS) Reports in Tally

TCS Outstanding Menu in Tally

Having created the Vouchers for TCS Sales & Tax Deposit, you may print various periodical Reports & Returns of TCS.

Select GoT > Display >Statements of Accounts > TCS Outstandings to get TCS Outstandings Menu

TCS Reports Menu in Tally

TCS Payables Reports in Tally

At TCS Outstandings Menu , select TCS Payables to get TCS Payables Report

TCS Payables Display in Tally

TCS Payable Report Display Configuration in Tally

At TCS Payable Display , click F12:Configure to get TCS Payable Configuration screen to set the Configuration similar to Outstandings Payable discussed earlier.

TCS Payable Display Configuration in Tally

TCS Payable Report Display Buttons in Tally

At TCS Payable Display, you get the buttons, similar to Buttons shown at Outstandings Payable, explained earlier

TCS Payable Display Buttons in Tally

TCS Ledger Outstanding Display in Tally

At TCS Outstandings Menu , select Ledger to get TCS Ledger Outstanding Display

TCS Ledger Outstanding Display

TCS Ledger Outstandings Display Configuration in Tally

At TCS Ledger Outstanding Display, click F12:Configure to get TCS Ledger Outstanding Display Configuration screen to set the Configuration similar to Ledger Outstanding Display Configuration discussed earlier

TCS Ledger Outstanding Report Display Configuration in Tally

TCS Ledger Outstanding Display Buttons : At TCS Ledger Outstanding Display , you get the buttons similar to Buttons shown at Outstandings Payable , explained earlier

TCS Challan Reconciliation Display in Tally

Ledger Voucher has been discussed earlier. At the time of printing of chalan, the challan number allotted by Bank is not available.

TCS Ledger Voucher Display in Tally

To enter the details of challan, acknowledged by Bank, at GoT>Display > Accounts Book > Ledger, select the TCS Ledger Account from the list of Accounts Ledger to get Ledger Voucher List of the selected TCS Ledger Account .

TCS Challan Reconcile Button in Tally

TCS Challan Reconciliation Process in Tally

At Ledger Voucher Display of TCS Ledger, click F5: Challan Reconcile Button to get TCS Challan Reconciliation screen.

TCS Challan Reconciliation in Tally

TCS Challan Details Entry : At TCS Challan Reconciliation screen, click S:Set Challan Details button to get Challan Details screen.

Challan Details Display Button in Tally

At Challan Details screen, enter the details as follows :

Bank Name : At Bank Name, select the Bank Name into which the TCS has been deposited, from the list of Designated Banks (or select New Name and enter the Bank Name).
BSR Code : At BSR Code, enter the BSR Code of the selected Bank.
Challan No : At Bank Challan No. enter the Challan Number as allotted by the Bank on the Challan
Challan Date : AtChallan Date, enter the Challan Date as provided by the Bank on the Challan.

Challan Details Display in Tally

TCS Form 27D Reconciliation in Tally

After issuing Form 27D to the Party, you have to enter the relevant details. At GoT> Display > Accounts Book > Ledger, select the Collectee Party Ledger from the list of Ledger Accounts to get Ledger Vouchers of the selected Party.

Party Ledger Voucher

AtLedger Vouchers screen of the Collectee Party , click F5:Form 27D Reconcile button, to get Form 27 D Reconcile screen

Form 27D Reconcile button

TCS Form 27D Date Auto Update: At Form 27 D Reconcile screen, click S:Set All Dates to auto update the Date of Form 27D Issue Date against each Voucher record.

TCS Returns menu in Tally

Select Display>Statutory Reports>TCS Reports to get TCS Returns Menu

TCS Returns Menu in Tally

TCS Form 27B Printing in Tally

TCS Form 27B is a summary of TCS return which contains control totals of Payment Amount and TDS

Form 27B is to be filed in physical form with each return i.e., Form 27E and Form 27EQ. If the return is submitted in the paper form, form 27B need not be attached.

At Gateway, select Display>Statutory Report>TCS Reports to get the TCS Reports menu.

At TCS Reports menu , select Print Form 27B to get Form 27B printing screen.

TCS Form 27B printing in Tally

At Form 27B Printing screen specify the following :

Person Responsible details : At the left part, enter the address and Contact details of collector (Authorised Person), signing the Form.
- Flat No : At Flat No, enter the Flat Number / Door Number
- Name : At Name, enter the Name of the Person
- Designation : At Designation, enter the Designation of the Person.
- Premises Name : At Name of the Premises/ Building, enter the Name of the Building
- Road: At Road / Street /Lane, enter the Name of the Road / Street /Lane
- Location : At Area/ Location, enter the Area/ Location Name of the premises.
- Town / City /District : At Town / City /District, enter the Town /City & District Name of the location of premises
- State : At State, enter the State where the premises is situated.
- Telephone: At Telephone, enter the Telephone Number (Land line with STD Code / Mobile Number) of the signatory.
- e-Mail : At E-Mail, enter the e-mail address of the Person (if any)
Other details : At the right part, enter the Particulars of the Form 27 Report, as follows:
- Collector Category : At Category (Deductor / Collector), enter the Category of the Deductor Oganisation.
- Report Start Date: At From, enter the Start Date of the Return (leave blank to start from beginning of FY)
- Report End Date: At To, enter the End Date of the Return (leave blank for upto end of FY)
- Last Challan Period : At Challan Date Till, enter the last challan date considered in the report
- Form Type : At Enclosed Form Type, select the enclosed Form Number from the list (e.g 27E)
- Previous Receipt Reference : At Previous Receipt No. enter the previous Return submission acknowledgement number, if any
- Annexures : At Number of Annexures enclosed, enter Number of annexed documents enclosed.
- Other information : At Other information, enter any other Important note you like to record
- Place : At Place, enter the Place of filing the return
- Date : At Date, enter Date of filing the return

Type Y to get the printed Form 27B

TCS From 27B in Print in Tally

TCS Form 27D Printing in Tally

Form 27D is a certificate of proof that collector has collected the and paid the same to the government. This proof is essential to the collectee to claim the credit of tax in his Income Tax returns.

Form 27D printing for a single Cillectee in Tally

At TCS Reports menu, select Print Form 27D and select the Collectee (Customer) to get Form 27D printing screen, to print Form 27D

TCS Form 27D Individual printing in Tally

At Form 27D printing screen, at the left Part, enter as follows:

Name : At Name, enter the Name of the Person
Designation : At Designation, enter the Designation of the Person.
Format : At Print in Previous Format, set Yes to print in Previous Format, else set No
Report Start Date: At From, enter the Start Date of the Return (leave blank to start from beginning of FY)
Report End Date: At To, enter the End Date of the Return (leave blank for upto end of FY)
Last Challan : At Challan Date Till, enter the last challan date considered in the report
Copy Type : At Type of Copy, select from the list as follows:
- User Defined : To use User Defined Format. Further, at Copy Type Txt Box, enter the Form Type.
- Default : To use Standard Format
Certificate No.: At Certificate No, enter the Certificate Reference Number

At Form 27D printing screen, at the Right Part, enter the Particulars of the Return as follows :

Place : Place of filing the Return
Date : Date of filing the Return
Acknowledgement Reference : Under Acknowledgement, enter the Return Acknowledgement Reference & Dates against each Quarter
CIT (TDS) Details: Under CIT (TDS) Details, enter the details of the Commissioner as follows
- Name: At Name, enter the Name of the Commissioner
- Address: At Address, enter the address of the commissioner office
- City: At City Enter City name of the commissioner office
- Pin Code: At Pin Code, enter the PIN Code of the commissioner office

Form 27D in Print in Tally

TCS Form 27D printing for Multiple Collectees in Tally

To print Form 27D of all Customers, select GoT>Multi-Account printing> Multi-Form 27D printing at to get the Form 27D Printing screen. Set up the options as above for Form 27D printing.

e-TCS

The IncomeTax department has introduced the Electronic Filing of Returns scheme 2005. It is applicable to all the Deductors / Collectors wanting to furnish their TCS returns online.

It is mandatory for Corporate & Government Deductors / collectors to file TCS Returns in electronic form
Deductors / collectors (other than government and corporates) may file their TCS returns in the electronic or physical form.

NSDL has been appointed by the Income Tax Department as an e-TCS intermediary to receive on its behalf e-TCS returns from Deductors / Collectors.

Deductors/ Collectors furnishing their e-TCS have to furnish:

Form 27B as a control chart.
A CD/ Floppy containing the e-TCS Annual return (Form 27E).

To export the ETCS Forms in NSDL compliant formats, at TCS Reports Menu, select ETCS Forms. Just as described for TCS Return, select the Form, fill up the details at Exporting ETCS Forms to export data in compatible Form

The exported file will be saved in the path specified in the output file name. The file can be validated through NSDL’s freely downloadable File Validation Utility. This can be used to verify whether the ETCS return filed by the Deductors conforms to the prescribed format.

View PDF