Home Page : TallyERP9Book.Com Click...Order Now ! Click...Order Now ! Click....Book Contents !
Connect with ...
 
FAQ-7 ( TDS ):

How to record Works Contract Transactions in Tally.ERP 9 to Calculate TDS on the net amount of Purchase?

For Example:- ABC Company receives bill form VRG Builders & Developers for works contract given. 

Total Value of the Bill received from VRG Builders & Developers is Rs. 58925/-
Purchase cost of Work contract is Rs.54000/-
Vat @ 5% is Rs. 2700/-
Service Tax @ 4.12% is Rs.2225/-

TDS @ 1% to be Deducted on the above Bill

Steps to record the Works Contract transactions are:

Step 1: Create Ledger Masters

Step 2:  Record Purchase Voucher (Account Invoice Mode)

Step 3: Record a Payment Voucher (payment to party)

Step 4: Check TDS Computation

Step 1: Create Ledger Masters

i. Party Ledger (supplier): Create VRG Builders & Developers ledger > under Sundry Creditors > enable the option Is Service Tax Applicable to Yes > enable the option Is TDS Deductable to Yes > in Deductee Type field select Company - Resident

ii. Purchase Ledger: Create Works Contract Purchases ledger > under Purchase Accounts 

  • Enable the option Is Service Tax Applicable to Yes > in Category Name screen select Works Contract Service 
  • Enable the option  Used in VAT Returns to Yes > select VAT/Tax Class as Purchases @ 5%
  •  Enable the option Is TDS Applicable to Yes > in Nature of Payment field select Payment to Sub-Contractors

iii. VAT Ledger: Create Vat @ 5% ledger > under Duties & Taxes > select VAT in Type of Duty/Tax field > VAT/Tax Class as Input VAT @ 5% > enable the option Is TDS Applicable to Yes > select the Nature of Payment as Payment to Sub-Contractors

iv. Service Tax Ledger: Create Service Tax @ 4.12% ledger > under Duties & Taxes > select Service Tax in Type of Duty/Tax field > Category Name as Works Contract Service > enable the option Is TDS Applicable to Yes > select the Nature of Payment as Payment to Sub-Contractors

v. TDS Ledger: Create TDS Ledger > under Duties & Taxes > select TDS in Type of Duty/Tax field > Nature of Payment as Payment to Sub-Contractors

Step 2:  Record Purchase Voucher (Account Invoice Mode)

Go to Gateway of Tally > Accounting Vouchers > F9: Purchase

Note: In F12: Configuration set the option Allow Alteration of TDS Nature of Payment in Expenses to Yes

  • In the Party A/c Name field select Party Ledger
  • Under Particulars select the Purchase Ledger and specify the amount as 54,000 and press enter to view TDS Nature of Payment Details screen.
  • In TDS Nature of Payment Details by default the Nature of Payment selected in the ledger will be displayed. In Assessable Value field accept the default amount of Rs.54,000

Works Contract Transactions in Tally.ERP 9 to Calculate TDS

   [13-20]

  • Under Particulars select the VAT ledger, VAT amount will be calculated and displayed automatically. Press enter to view TDS Nature of Payment Details screen, accept the default details.
  • Under Particulars select Service Tax Ledger. In the Service Tax Computation screen change the service tax percentage to 4% (as service Tax charged on works contract is 4%). Service tax will be calculated based on the Service Tax Rate defined. In TDS Nature of Payment Details screen, accept the default details.

Works Contract Transactions in Tally.ERP 9 to Calculate TDS

   [13-21]

  • Under Particulars select TDS ledger and press enter to view the TDS Details screen. Observe TDS is calculated on the Total Amount (Work Contract Purchase Value + VAT + Service Tax = 58924.80).

Purchase Entry is displayed as shown

Works Contract Transactions in Tally.ERP 9 to Calculate TDS

   [13-22]

Note: TDS deducted is displayed with Negative Sign.

In Bill-wise Details screen select the reference details as shown

Works Contract Transactions in Tally.ERP 9 to Calculate TDS

   [13-23]

Completed Purchase Voucher is as shown below

Works Contract Transactions in Tally.ERP 9 to Calculate TDS

   [13-24]

Step 3: Record a Payment Entry

Make the payment to the party and the payment voucher will be dispalyed as shown

Works Contract Transactions in Tally.ERP 9 to Calculate TDS

   [13-25]

Step 4: Check TDS Computation

Go to Gateway of Tally > Display > Statutory Reports > TDS Reports > Computation

Works Contract Transactions in Tally.ERP 9 to Calculate TDS

   [13-26]

Similarly you can check Input Credit Form and VAT Computation reports to view the details of Service Tax and VAT

 
 
 
 
[FAQ] : Tally.ERP 9
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
 
 

Enter your email address:
[ Get Tally.ERP 9 Questions & Knowledge Base Feed delivered by eMail ]

Delivered by FeedBurner

 
 
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 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. This Website is not associated with any product or vendor mentioned in this Website.

GETTINGS STARTED @ Tally.ERP 9
QUESTIONS BASE @ Tally.ERP 9
REPORT GENERATES @ Tally.ERP 9
TIPS & TRICKS @ Tally.ERP9 GST for Tally.ERP9
1 > Financial Statement Report 1 > Tips & Tricks @ Tally.ERP 9 1 >Introduction to GST ( IGST . CGST, SGST )
2 > Accounts Book & Register Report 2 > FAQ's @ Tally.ERP 9 2 >Calculation of GST ( IGST, CGST & SGST)
3 > Stock Register / Reports 3 > Short Cut Keys @ Tally.ERP 9 3 > GST on Tally.ERP 9 ( With Practical Assignment )
4 > Job Costing Reports 4 > Tips-Weekly Refresher @ Tally.ERP9 4 > Generate GSTR-1 Returns / Reports under Tally.ERP9
5 > Pay Roll Register Reports   5> Status Reconciliation (GSTR-1)
6 > Point of Sale Register Reports   6 > Challan Reconciliation Report for GST Payments
     
  8 > Excise - Manufacturer      
  9 > Technology / Utilities      
 
SWAYAM EDUCATION
Mandal Bagicha, Hemkapada,
Sunhat, Balasore-756002 ( Odisha )-India
eMail ID : tallyerp9bookorder@gmail.com
Web : www.tallyerp9book.com
Mob : 09437264738
Get Updated ...
Website Designed, Hosted, Owned by : www.BalasoreCity.Com