Excel formula for tds delay month calculation
This query is : Resolved
11 August 2013
Dear Sir, Kindly share the Excel formula for TDS Delay months Calculation.
Eg : if TDS Deduction Date is 04/05 /2013 and its due date is 07/06/2013. But Deducted deposited TDS amount on 09/06/13 the it should be display 02 delay months. Note : For each month due date is 07th of Next month except March is 30th Apr
Eg : if TDS Deduction Date is 04/05 /2013 and its due date is 07/06/2013. But Deducted deposited TDS amount on 09/06/13 the it should be display 02 delay months. Note : For each month due date is 07th of Next month except March is 30th Apr
31 August 2013
need to calculate the 1.5% per month and multiply by 2 and calculate 3%
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now
Click here to login now
Similar Resolved Queries
Unanswered Queries
- Price inclusive or exclusive of GST while made entry in P& L Account
- Gst registered proprietorship firm
- TDS Challan - change of FY 2025-26 to TY 2026-27
- Dep. as per companies act
- Minimum tax payable to file Updated return
- AUDITOR APPOINTMENT FOR THE YEAR ENDING MARCH 27
- Applicability of GST on Salary Reimbursement Component
- SALARY CAN BE CAPITALIZE
- TDS on purchase of under construction property from a reseller
- UDIN ISSUE
- FAST DS 26 Undisclosed Foreign Asset Disclosure Scheme 2026
- Starting trading business
- Regime change
- Goods sold but invoice not issued
- Tally: Imported bank entries do not show up in manual reconciliation
- Sales of goods of amount Rs97 lakhs to a party
- Confused About My Career After 12th — Cyber Security, AI or Finance? Need Guidance
- FAST-DS 2026 Under Tax Law - No recourse or support for person declaring via this scheme?
- Guidance Needed: Linking Multiple Form 26QB Payments and Responding to ITD Defaulter Notice
- How to pay remaining amount of TDS after due date?
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
Subscribe to Pro
Join an elite circle of professionals
Quick Links
ARTICLESHIP
07 September 2026
CA Articles
Kothari Jain Patil & Chartered Accountants
Pune
CA Inter
View Details
ARTICLESHIP
07 September 2026
Article/ Paid Assistant
Murali and Sumeet Chartered Accountant
Bengaluru
CA Foundation
View Details
08 September 2026
Semi-Qualified Assitant
Subrahmanyam & Sivudu CA Firm
Hyderabad
CA Inter
View Details
CCI
Pro
CAclubindia
