Get..Tally.ERP9 Book + GST Assignment @ Rs. 550


 

Tax Deducted At Source (TDS) using Tally.ERP9


TDS means Tax Deducted at Source. The concept of TDS was introduced in the Income Tax Act, 1961, with the objective of deducting the tax on an income, at the source of income. It is one of the methods of collecting Income Tax, which ensures regular flow of revenue to the Government.

TDS Process

  1. Deductee (Seller) provides Services and Bill to the Deductor (Buyer).

  2. Deductor makes the payment after deducting TDS.

  3. Deductor remits the TDS amount into Bank (Treasury).

  4. Bank (Treasury) remit the amount to the Government Account.

  5. Deductor Issues Form 16A to Deductee for the TDS amount deducted.

  6. Deductor Files the e-TDS to NSDL.

  7. NSDL uploads the e-TDS information to Income Tax Department.

  8. Deductee Files the Return with Form 16A to Income tax Department.

1. Enabling TDS in Tally.ERP9

1. Go to Gateway of Tally > F11: Features > Statutory & Taxation

2. Set Enable Tax Deducted at Source (TDS) to Yes in the Company Operations Alteration screen as below :

3. Enable the option Set/alter TDS details ? to display TDS Deductor Details screen as below :

TDS Deductor Details in Tally.ERP9

Please enter all details in Company TDS Deductor Details as above.

Press F12 : Advanced Configure in above Screen for  Configure TDS as below :

>>        All the organisation types will appear in the Collector/Deductor Type list for the option Deductor Type

>>        All Surcharges details applicable to TDS will be enable in second option

>>        The Third Option is to enable display of the alternate contact details of TDS

2. Creating TDS Nature of Payment

For payments attracting TDS, the relevant nature of payment is defined by the department with associated tax rate, section, payment code, and threshold limit. Few Examples are given below …

Section

Nature of Payment

TDS Rate

192

Salaries

Average Rate Applicable

194I

Rent on Plant and Machinery

2%

194I

Rent on Land, Building, Houses, Offices etc.

10% by Company in excess of Rs.2,00,000
5% by Individual . HUF, Businessman in excess of Rs.50,000

194C

Payment to Contractor / Sub-contractor

1%

194D

Insurance Commission

5%

194DA

Payment in respect of life insurance policy

1%

194EE

Payment in respect of Deposit under NSS

10%

194H

Commission or Brokerage

5%

194J

Sum paid by way of Fees for Professional Services

10%

While creating a TDS Nature of Payment, you can press Ctrl+C to select the required nature of payment.

1. Go to Gateway of Tally > Accounts Info. > Statutory Info. > TDS Nature of Pymts Create

2. Press Ctrl+C to view the list of Nature of Payment 

3. Select the required Nature of Payment.

3. TDS on Expenses using Tally.ERP9

You can create an accounting voucher for your business expenses, along with the applicable TDS.

Example :      
On 1.4.2018, SWAYAM EDUCAITON paid NeXT Enterprises Rs.5,00,000 as Rent

Step-1: Creating Expenses Ledger i.e. Rent

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

  2. Select Indirect Expenses as the group name with Inventory values are affected to No

  3. Enable the option Is TDS Applicable ?  and also   Select the Nature of Payment from the List of Nature of Payments

The Ledger Creation screen appears as shown below:

Creating Ledger with TDS Transaction in TallyERP9

 

Step-2 : Create Party Ledger i.e. NeXT Enterprises ( Under Sundry Creditor) as below:

>>        Enable the option Is TDS Deductible ? and Select a Deductee Type from the List and also Enable Deduct TDS in Same Voucher , if required

Creating Party Ledger with TDS transaction using TallyErp9

Step-3 : Create TDS Ledger

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

  2. Enter the Name and Select Duties and Taxes as the group name in the Under field, then Select TDS as the Type of Duty/Tax.

  3. Select a Nature of Payment  from the List of Nature of Payments

Creating TDS Ledger using TallyERP9

Step-4 : TDS Transaction ( Accounting for TDS on Expenses)

Go to Gateway of Tally > Accounting Voucher > F7: Journal  and pass the Journal Entry as below :

TDS Transaction using TallyERP9

Note : Out of Rs.5,00,000 towards Rent to NeXT Enterprises, only Rs.4,50,000 is credited to party account and Rs. 50,000 ( i.e. 10% TDS)  is transferred to TDS on Rent automatically and which is payable under Duties & Taxes

4. TDS on Advance Payment against Expenses using Tally.ERP9

You can create an accounting voucher for advance payments made directly or by a third-party, along with the applicable TDS.

Example :
On 01-05-2018, SWAYAM EDUCATION paid an Advance of Rs. 1,00,000 on Rent to NeXT Enterprises as Rent directly
.

1. Go to Gateway of Tally > Accounting Voucher > F5: Payment

Payment Voucher appears as shown below :

TDS on Advance payment against Expenses using TallyERP9

Note :  When selecting TDS tax ledger, the TDS amount will automatically filled in the Amount field i.e. 10% on Amount paid

5. Recording TDS Payment Transaction to the Government using Tally.ERP9

You can record a payment transaction with inclusion of the necessary TDS to be paid to the government.

Example :
On 1-6-2018, SWAYAM EDUCATION paid TDS deducted in the month of April & May 2018 to the Government directly
.

  1. Go to Gateway of Tally > Accounting Vouchers > F5: Payment.

  2. Click S: Stat Payment.

The Statutory Payment Details screen appears as shown below:

The Payment invoice appears as shown below:

 

6. TDS Reports using Tally.ERP9

TDS Reports using Tally.ERP9 has been classified as…

A- Form 26Q (TDS)

Form 26Q is the Quarterly return of TDS in respect of all payments other than salaries. As per the Income Tax Act, 1961, every corporate and government entity responsible for deduction of tax at source should furnish TDS returns containing details of deductee(s) and challan details relating to deposit of tax with the Income Tax Department.

The Form 26Q report in Tally.ERP 9 assists you in generating accurate the returns to be filed.

>>        Go to Gateway of Tally Display Reports Statutory Report > TDS Reports > Form 26Q

TDS Report Form 26Q in TallyERP9

It has three main sections:

  1. Statistics of Vouchers : The Statistics of Vouchers section of Form 26Q displays the total number of transactions pertaining to a period which are categorised as Included Excluded and Uncertain Transactions .

  2. Deduction Details :   The Deduction Details section under the TDS Reports for Form 26Q or 27Q denotes the type of deduction under which each of the Included transaction is grouped

  3. Payment Details : This section contains details of all TDS payment vouchers of the current period and displays all payment entries recorded for interest, penalty, late fee, and so on. These other payment entries for interest, penalty, and late fee, and so on will be displayed under Other Payments.

Payments made to party, petty expenses, or any statutory payments other than that of TDS are not displayed here. 

B- Form 27Q (TDS)

Form 27Q is a Quarterly return for deduction of tax in respect of payments made to non-residents other than salary. The Form 27Q report in Tally.ERP 9 assists you in generating accurate returns to be filed.
The Form 27Q report has three sections: 
1.         Statistics of Voucher 
2.         Deduction Details , and 
3.         Payment Details 
… like Form 26Q as above.
To generate Form 27Q : Go to Gateway of Tally Display Reports Form 27Q

C- TDS Reconciliation Report

The TDS Reconciliation report displays the all the reconciled TDS payments where we can view the Challan Reconciliation Report and also we Reconcile TDS Payment Challans.

>> Go to Gateway of Tally Display Statutory Reports TDS Reports Challan Reconciliation.

>> Click F5: Reconcile Challan

>> Press Alt+S to set Challan Date

D- 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 as shown below :

>> Go to Gateway of Tally Display Statutory Reports TDS Reports TDS Outstandings.

The TDS Nature of Payment Outstandings report appears as shown below:

E- Ledgers without PAN (TDS)

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

>> Go to Gateway of Tally Display Statutory Reports TDS Reports Ledgers without PAN

 
Get..Tally.ERP9 Book + GST Assignment @ Rs. 550
 
 

Get..Tally.ERP9 Book + GST Assignment @ `. 550 !

15 Chapters in Tally.ERP9 Book + 21 Chapters in GST Practical Assignment on GST in Tally.ERP9 & All features are described with Practical Problems with Solutions.

Buy Now


 
Disclaimer :
The names of Companies and persons used in this Website have been used for illustrative purposes only.
The visitors may visit www.tallysolutions.com , the web site of Tally Solutions Pvt. Ltd. for resolving their doubts or for clarifications

Trademark :
Tally,Tally GST,TallyERP9 GST, 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. This Website is not associated with any product or vendor mentioned in this Website.
SWAYAM EDUCATION
Mandal Bagicha, Hemkapada,
Sunhat, Balasore-756002 ( Odisha )-India
eMail ID : tallyerp9bookorder@gmail.com
Web : www.tallyerp9book.com
Mob : 09437264738

| About | Privacy Policy |

© 2019 : www.tallyerp9book.com

Tally.ERP9 Book CONTENT Tally.ERP9 Book ORDER