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
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
14 August 2013
1)TDS deduction date in cell "C1"
2)DUE DATE in Cell "C2"
3)Paid date in Cell "C3"
4)Delay can be caluculated "C3-C1" which will be in cell "C4"
5)Give IF Formulae as below
=IF[C4>30,2,1]
It will give results as you desired
2)DUE DATE in Cell "C2"
3)Paid date in Cell "C3"
4)Delay can be caluculated "C3-C1" which will be in cell "C4"
5)Give IF Formulae as below
=IF[C4>30,2,1]
It will give results as you desired
14 August 2013
Dear Sir,
In the above formula you have not considered the Cell "C3". Pls refer the below equation Tds deduction date is 04-04-13 and due date 07-05-13. If we apply the said formula then it return the value 2 months delay. But actually there is no delay months.
In the above formula you have not considered the Cell "C3". Pls refer the below equation Tds deduction date is 04-04-13 and due date 07-05-13. If we apply the said formula then it return the value 2 months delay. But actually there is no delay months.
14 August 2013
1)In C6 formulae =C2-C3
2)In C7 Formulae =IF(C5>0,C4,0)
I guess error resolved now!!!
2)In C7 Formulae =IF(C5>0,C4,0)
I guess error resolved now!!!
16 August 2013
Dear Sir,
Let me know the value of Cell "C5" which you are comparing with if formula.
Let me know the value of Cell "C5" which you are comparing with if formula.
16 August 2013
Value arrived in point no. 5 in my first reply
16 August 2013
Not getting.
16 August 2013
=IF[C4>30,2,1]
16 August 2013
The same problem is here.
19 August 2013
The below formula will short out your query
For Due Date formula will be =
EDATE(A2,1)-DAY(A2)+7
Note : A2 is date of deduction
For no of month Defaults Formula will be =--(IF(B2
Note B2 is due date calculated above & C2 is actual date of deposit
For Due Date formula will be =
EDATE(A2,1)-DAY(A2)+7
Note : A2 is date of deduction
For no of month Defaults Formula will be =--(IF(B2
Note B2 is due date calculated above & C2 is actual date of deposit
21 August 2013
Dear Sir,
Kindly write the whole if formula for no of moth defaults.
Kindly write the whole if formula for no of moth defaults.
22 August 2013
Hey
There are many conditions to be checked for calculating interest.
Pl check https://www.taxpointindia.com/calculators/tds/tdscalc.asp
Thanks
There are many conditions to be checked for calculating interest.
Pl check https://www.taxpointindia.com/calculators/tds/tdscalc.asp
Thanks
22 August 2013
You can download excel file from here, earlier published on cci:
https://www.caclubindia.com/forum/files_download.asp?msg_id=1169097
Thanks
https://www.caclubindia.com/forum/files_download.asp?msg_id=1169097
Thanks
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
- CAPITAL GAIN BASE ON NOTIFICATION
- Form 140 tds
- Taxable or Tax exempt
- ADVANCE PAYMENT OF ADVOCATE
- TDS Deducted AY-2013-14 Not Reflected in 26as
- FAST-DS 2026 Under Tax Law - No recourse or support for person declaring via this scheme?
- NRI starting business in India
- Demand Outstanding AY 2013-14 TDS Deducted not shown in 26as
- REGARDING ANNUAL RETURNS FILLINGS OF A COMPANY INCORPORATED ON 28.03.2025
- TDS Return Q1 FY 2026-27
- 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
- STATUTORY AUDIT OF A SMALL PRIVATE COMPANY INCORPORATED ON 28.03.2025
- Guidance Needed: Linking Multiple Form 26QB Payments and Responding to ITD Defaulter Notice
- How to pay remaining amount of TDS after due date?
- Resigning a auditor from the company for misconduct
- RCM @ 5% on Hamali charges, Transport Charges, Unloading charges we take ITC or not
- CALCULATION OF DEFFERED TAX - OP BL IS DTL & CURRET IT DTA
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
CAclubindia
