Tds interest calculation formula
This query is : Resolved
Mukesh Katara
(Querist)
02 February 2012
DEAR FRNDS
PLS GIVE ME EXCEL FORMULA FOR COUNT MONTH REGARDING TDS INTEREST CALCULATION
EXAMPLE:-
BILL DATE IS-29/04/2011
TDS PMT DATE 25/01/2012
TDS AMT 50000
SIMPLE MONTH COUNT IS 10
BUT WHEN I CALCULATE WITH FORMULA MONTH IS CALCULATE 9.
PLEASE SHORT THIS AS EARLY
THANKING YOU
MUKESH
PLS GIVE ME EXCEL FORMULA FOR COUNT MONTH REGARDING TDS INTEREST CALCULATION
EXAMPLE:-
BILL DATE IS-29/04/2011
TDS PMT DATE 25/01/2012
TDS AMT 50000
SIMPLE MONTH COUNT IS 10
BUT WHEN I CALCULATE WITH FORMULA MONTH IS CALCULATE 9.
PLEASE SHORT THIS AS EARLY
THANKING YOU
MUKESH
02 February 2012
29/4/2011 - 29/1/2012 = 9 months
on or after 29/1/2012 = 10 months
As payment date is 25/1/12 , 9 months is correct
on or after 29/1/2012 = 10 months
As payment date is 25/1/12 , 9 months is correct
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
- Late Filing Fee Waiver for Q1 Form 144 (Earlier 27Q) – Transition to Income-tax Act, 2025
- GST input credit on commercial property
- Working on Gold wastage during Melting of old gold jewellery
- GST REFUND ISSUE ON PURCHASE OF PLANT AND MACHINERY
- TDS on Dashcam rent and allied services
- GSTR-9C filing
- Import Order Cancelled.
- Form 144 TDS Return Validation Error – Mandatory Fields
- How do you manage client document collection and follow-ups in your CA/CS practice?
- Royalty payments to the Mining Department for procurement of murum - GST input
- Subject: Legal Remedy for Removal of Income Tax Demand for AY 2024–25 – Charitable Trust
- Expert Help Required for TDS Refund 100000 Through TRACES – AY 2022–23
- IMPORT PURCHASE ENTRY PASSED IN BOOKS OF ACCOUNT
- FAST DS 26 Undisclosed Foreign Asset Disclosure Scheme 2026
- Regime change
- Tally: Imported bank entries do not show up in manual reconciliation
- 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
CAclubindia
