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

Is it possible to account Advance payments to party and deduct TDS on such advances? How to adjust the advances paid to the party towards the Bill?

ExampleOn 15-04-2010, ABC Company made an advance payment of Rs.50,000 to Pheonix Agencies towards Advertisement Expenses. While making payment tax was deducted form the Source. Advances were adjusted towards the bill of Rs.2,00,000 dated 26-04-2010.


Tally.ERP 9 allows accounting advance payments to party and deduct TDS on the advances and later adjust the advance paid towards the Bill.

Follow the given procedure to account advances and adjust the advances towards the Bill

Step 1: Record a Payment Voucher (to account advances)

To create a Payment Voucher

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

Set up

In F12: configure (Payment Configuration)

  • Ensure Use Single Entry mode for Pymt/Rcpt/Contra is set to Yes

1. In Account field select the Bank Ledger. E.g. Canara Bank

2. Under Particulars select the party ledger Pheonix Agencies. In Amount field enter the amount paid as advance and press enter to view Bill-wise Details screen

3. In Bill-wise Details screen

  • In Type of Ref field select the reference as Advance
  • In Name field enter the bill name as Adv-201
  • Amount will be displayed automatically

FAQ on TDS  in Tally.ERP9


4. Accept the Bill-wise Details screen

5. Under Particulars select tax ledger, TDS - Contractor and press enter to view TDS Details screen

TDS Details screen appears as shown

FAQ on TDS  in Tally.ERP9


6. Press Enter to accept the TDS Details. Tax deducted will be displayed with negative sign.

The completed Payment Voucher is displayed as shown

FAQ on TDS  in Tally.ERP9


7. Press Enter to save.

Step 2: Record a Journal Voucher (to account the bill & adjust the advances)

To account the bill received and adjustment of advances paid

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

1. In Debit field select the expenses ledger - Advertisement Expenses. In Debit amount field enter the total bill amount of Rs. 2,00,000

2. In Credit field select the Party Ledger - Pheonix Agencies. Press Enter to view TDS Details screen

3. In TDS Details screen

  • In Type of Ref field select Agst Ref
  • In Name field select Pymt/1-2 from the Pending Tax Bills. On selection of Tax bill Nature of Payment, TDS Duty Ledger, Assessable Amount and Payable Amount will be defaulted automatically and application will not allow altering the details.

FAQ on TDS  in Tally.ERP9


  • In Type of Ref field select New Ref.
  • In Name field Tax Bill reference will be defaulted automatically
  • In Nature of Payment select Payment to Contractors (Advertisement Contractors)
  • In TDS Duty Ledger field select TDS – Contractors and set Deduct Now to Yes.

The completed TDS Details screen is displayed as shown

FAQ on TDS  in Tally.ERP9


Observe, the advance of Rs. 50,000 is adjusted towards the bill and TDS is calculated only on the balance amount of Rs. 1,50,000.

4. In Bill-wise Details screen select the bill reference as shown

  • In Type of Ref select Agst Ref, in Name field select the bill Adv-201 dated 15-4-2010 form the pending bills and in Amount field mention the amount adjusted as Rs. 50,000.
  • In Type of Ref select New Ref, in Name field enter the bill name as PA/152/10-11 and in amount filed mention the amount pending for payment
  • In Type of Ref select New Ref, in Name field enter the bill name as PA/152/10-11 and in amount filed tax deducted will be defaulted.

FAQ on TDS  in Tally.ERP9


5. In Credit field select the TDS ledger TDS- Contractor. Tax deducted - Rs. 3,000 (on 1,50,000) will be defaulted automatically.

The completed journal voucher is displayed as shown

FAQ on TDS  in Tally.ERP9


6. Press Enter to save.
[FAQ] : Tally.ERP 9

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

Delivered by FeedBurner


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.

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      
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