Home Page : TallyERP9Book.Com Click...Order Now ! Click...Order Now ! Click....Book Contents !
Connect with ...

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.
 
 
 
Company Information @ Tally.ERP9
Group & Ledger

Introduction
1. THE GROUP
2. THE LEDGER
3. VOUCHERS TYPES

Advanced Inventory / Stock
Meaning
Order Processing
Re-Order Levels
Tracking Numbers
Batch-wise Details
Additional Cost Details
Bill of Materials (BOM)
Price Lists and Price Levels
Stock Valuation
Zero Valued Entries
Inventory Ageing Report
Actual and Billed Quantities
Advanced Usage of Vouchers
Maintain Bill-wise Details
Cost Center and Cost Category
Interest Calculation
Reversing Journals
Post-Dated Voucher
Memo (Memorandum) Voucher
Optional Voucher
Using Tracking Number
Tally.ERP9 Report
  1. Unit Objectives
  2. Modifying Reports (Options)
  3. Balance Sheet
  4. Profit & Loss Account
  5. Stock Summary
  6. Trial Balance
  7. Day Book
  8. Books of Accounts
  9. Statement of Accounts
  10. Inventory Books
  11. Statutory Reports
  12. List of Accounts ( Chart of Accounts)
  13. Exception Reports
  14. Printing Reports
 
Tally.ERP9 MIS and Other Reports
 
Statutory & Taxation
Utilities & Others @ Tally.ERP9
Credit Limits
Knowledge Base @ Tally.ERP9
Stock Items
Stock Groups
Inventory Masters
Inventory Vouchers
Inventory Report Statements
Balance Sheet
Accounting Reports
Accounting Vouchers
Interest Calculation
VAT-Value Added Tax
Service Tax
TDS (Tax Deducted at Source)
 

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