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
- Off Market debit and credit transaction
- Itr 1 processing
- ITR 2 Short Term gain & Long term gain
- Reporting Income under Section 44ADA
- Showing Gift from relative in ITR for this year
- ITR validation error - Balance sheet is not filled
- INCOME TAX ON REDEVELOPEMENT OF FLAT
- Form 10E u/s 89(1). Need clarification because experts opinions differ !!!!
- ITR selection for salaries and capital gain less than L
- Share accounting-->fifo - capital gain - period as per fifo?
- Opting out" of regime provided under subsection (1A) of Section 115BAC but Form 10IEA is not filed.
- Query regarding TDS on EPFO Higher Pension Arrears*
- Gst invoice numbering and delivery challan numbering
- Sales amount in Gstr1
- E Commerce GSTR1 & 3B how to file
- GST Cancellation without jurisdiction
- Legal Opinion on Registrar's Refusal to Investigate a Society for Non-Renewal and Non-Compliance
- GST Refund_RFD-01
- Form10BD was uploaded successfully without any Error but after 24 hours, Form10BE are not available
- Annexure B utility for GST Refund
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
