Get.. Tally.ERP9 Book @ Rs.550 and TallyPrime Book @ Rs.600

 


TallyPrime Book @ Rs.600
Tally.ERP9 Book @ Rs.550
 

How to Reverse Excess TDS Deducted @ Tally.ERP9

Query

How to Reverse Excess TDS Deducted in Tally.ERP 9?

Solution

In case of partial cancellation of transaction (s), the expenses and excess TDS deducted needs to be reversed. In Tally.ERP 9, such reversal of expenses and TDS is possible only when the cancellation of transaction is made before the payment of TDS to the Government.

In Tally.ERP 9, reversal of expenses can be accounted using Debit Note and reversal of TDS deducted can be accounted using Credit Note.

Example: On 17-10-2009 ABC Company received bill from Pheonix Agencies for Rs. 75,000 towards Advertising expenses. On 21-10-2009 ABC Company cancelled the advertisement services to the extent of Rs.25,000 and Expenses and TDS deducted are reversed.

To account these Transaction follow the given steps

1. Book the Expenses in Journal Voucher

2. Reverse the Expenses (Debit Note)

3. Reverse the excess TDS Deducted (Credit Note)

Step 1: Book the Expenses in Journal Voucher

Before recording the transaction ensure all the masters are created.

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

  • In Debit field select Advertisement Expenses and enter 75,000 in the Amount field.
  • In Credit field select Phoenix Agencies and press enter to view TDS Details screen
  • In TDS Details screen,
    • Select Type of Ref as New Ref.
    • In Name filed accept default reference number
    • Select Payments to Contractors (advertisement Contractors) in Nature of payment field
    • Select the TDS Ledger
    • In Assessable Amount field amount specified against the expenses ledger will be displayed
    • Set Yes in Deduct now field
Reverse Excess TDS Deducted @ Tally.ERP9
  • Payable Amount as calculated in the TDS Details screen will be defaulted in the Party’s Amount (Credit) field.
  • In Bill-wise Details screen
    • Select New Ref as the Type of Ref
    • In the Name field enter the Bill name as Bill -0178
    • Skip the Due Date or Credit Days field
    • Accept the default amount allocation and Dr/Cr. By default Tally.ERP 9 displays the Bill amount in the amount field as the credit balance.
    • Press Enter, select New Ref as Type of Ref and Enter Bill name as Bill -0178
    • Skip the Due Date or Credit Days field and accept the default amount allocation and Dr/Cr. By default Tally.ERP 9 displays the Tax amount in the amount field as the debit balance.
  • In the Credit field select TDS – Contractor from the List of Ledger Accounts.
  • In the Amount field, Rs. 1500 [Bill amount (75,000) – Pending Amount (73,500)] is displayed automatically.
Reverse Excess TDS Deducted @ Tally.ERP9
  • Press Enter to accept and save.

Step 2: Reverse the Expenses (Debit Note)

Go to Gateway of Tally > Accounting Vouchers > Ctrl+F9: Debit Note

  • Press Alt + I for Account Invoice mode.
  • In Party’s A/c Name field select Pheonix Agencies from the List of Ledger Accounts.
  • Under Particulars select Advertisement Expenses and enterRs. 25,000 in the Amount field.
  • In TDS Details screen
    • In Type of Ref select Agst Ref
    • In Name field, select Jurl/16-1 to adjust the reversal of expenses and select Payments to Contractors (advertisement Contractors) in Nature of Payment field
    • Based on the Tax Reference Number selected, Tally.ERP 9 defaults TDS Duty Ledger. In Assessable Value field Rs. 25000 will be displayed indicating that Rs.25000 is reversed against the expenses booked on 17-10-2009
Reverse Excess TDS Deducted @ Tally.ERP9

Note: Observe TDS Amount is not displayed as we are not reversing TDS in Debit Note

  • In Bill–wise Details screen, select Agst Ref as the Type of Ref. In the Name field select Bill-0178 dated 17-10-2009 from the Pending Bills to reverse the expenses.
Reverse Excess TDS Deducted @ Tally.ERP9
Reverse Excess TDS Deducted @ Tally.ERP9
  • Press Enter to accept and save.

Step 3: Reverse the excess TDS Deducted (Credit Note)

Go to Gateway of Tally > Accounting Vouchers > Ctrl+F8: Credit Note

  • Press Alt + I for Account Invoice mode.
  • In Party’s A/c Name field select Pheonix Agencies
  • Under Particulars select TDS - Contractor and press enter to view TDS Details screen
  • In TDS Details screen, select Agst Ref in Type of Ref, in Name field select Jurl/16-1 to adjust the reversal of TDS. Based on the Tax Reference Number selected, Tally.ERP 9 defaults Nature of Payment and TDS Amount
Reverse Excess TDS Deducted @ Tally.ERP9
In Bill–wise Details screen, select Agst Ref as the Type of Ref. In the Name field select Bill-0178 dated 17-10-2009 from the Pending Bills to reverse the TDS.
Reverse Excess TDS Deducted @ Tally.ERP9
Reverse Excess TDS Deducted @ Tally.ERP9
Press Enter to accept and save.
 
 
Get.. TallyPrime-3.* Book (Advanced Usage)

Get.. TallyPrime Book (Advanced Usage) @ Rs. 600

Get..Tally.ERP9 Book (Advanced Usage) @ Rs. 550

 

 

Get..TallyPrime 4.0 Book (Advanced Usage)
@ Rs. 800 !

Covering... 25 Chapters + 53 Practical Assignment

Buy Now

Get.. TallyPrime 4.0 Book (Advanced Usage) @ Rs. 800

Get..TallyPrime-2.1 Book (Advanced Usage)
@ Rs. 600 !

17 Chapters in TallyPrime Book + 45 Practical Assignment with GST in TallyPrime & All features are described with Practical Problems with Solutions.

Buy Now

Get.. TallyPrime Book (Advanced Usage) @ Rs. 600


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,TallyPrime,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 | Tally.ERP 9 Book ORDER | TallyPrime 4.0 Book ORDER | TallyPrime-2.1 Book ORDER |
© 2023 : www.tallyerp9book.com