TDS Dashboard β FY 2025β26
152 employees Β· Q1 in progress Β· Q1 challan due 31 Jul 2025
Projected Annual TDS
βΉ68.4L
FY 2025β26 Β· 152 employees
Deducted AprβJun
βΉ17.1L
Q1 Β· 3 months
On track
Challan Deposited
βΉ0
Q1 pending β due 31 Jul
Action needed
Short-deduction Employees
6
Feb/Mar catch-up needed
Perquisite TDS
βΉ8.2L
ESOP + car + accommodation
Monthly TDS Trend β FY 2025β26
Actual (green) Β· Projected (blue) Β· Feb/Mar catch-up in red
βΉ5.7L
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
βΉ6.2L
Jan
βΉ9.8L
Feb
βΉ9.8L
Mar
AprβJun: actual βΉ5.7L/month Β· JulβDec: projected Β· Jan: proof submissions adjust TDS Β· FebβMar: catch-up month for short-deductions
Challan & Compliance Status
Quarterly TDS deposit status (ITNS 281)
Q1 β AprβJun 2025
TDS deducted: βΉ17.1L Β· Due by 31 Jul 2025
β³ Not yet deposited
Q4 FY 2024β25 β JanβMar 2025
βΉ14.8L Β· BSR 0480109 / 001234 Β· 30 Apr 2025
Q3 FY 2024β25 β OctβDec 2024
βΉ15.2L Β· BSR 0480109 / 001198 Β· 28 Jan 2025
24Q Form 24Q β Q4 FY 2024β25
E-TDS return Β· Due 31 May 2025
Annex II pending
Employee TDS Overview β Top by Liability
Click any row for full tax computation
| Employee | Regime | Annual Gross | Total Deductions | Taxable Income | Annual Tax | Monthly TDS | YTD Deducted | Status | |
|---|---|---|---|---|---|---|---|---|---|
PS Priya Singh Management Β· EMP-0412 |
Old | βΉ24,00,000 | βΉ6,80,000 | βΉ17,20,000 | βΉ3,45,600 | βΉ28,800 | βΉ86,400 | On track | |
VK Vikram Kamath Engineering Β· EMP-0201 |
New | βΉ20,00,000 | βΉ2,10,000 | βΉ17,90,000 | βΉ3,18,240 | βΉ26,520 | βΉ79,560 | On track | |
AJ Anu Joshi Sales Β· EMP-0892 |
Old | βΉ15,00,000 | βΉ4,05,000 | βΉ10,95,000 | βΉ1,77,000 | βΉ14,750 | βΉ29,500 | Short β βΉ14K | |
KJ Kiran Joshi Engineering Β· EMP-1184 |
New | βΉ12,00,000 | βΉ1,47,000 | βΉ10,53,000 | βΉ79,560 | βΉ6,630 | βΉ19,890 | On track |
Showing 4 of 152 Β· βΉ68.4L total projected TDS Β· 6 short-deductions
Tax Computation Engine
Full waterfall tax working for any employee Β· Click sections to expand Β· All values are FY 2025β26
Tax Computation β Kiran Joshi Β· FY 2025β26 Β· New Regime
Section-by-section working Β· Monthly salary βΉ1,00,000 Β· Grade A Β· Engineering
A β INCOME FROM SALARY
Basic Salary
βΉ4,80,000
House Rent Allowance
βΉ2,40,000
Special Allowance
βΉ4,08,000
Employer NPS contribution (Sec 80CCD(2))
βΉ72,000
Gross Salary
βΉ12,00,000
B β EXEMPT ALLOWANCES (NEW REGIME)
In new regime, HRA exemption and Sec 10 allowance exemptions are NOT available. Only standard deduction (βΉ75,000) and employer NPS are allowed.
HRA Exemption (Sec 10(13A))
Not applicable
C β STANDARD DEDUCTION & EMPLOYER NPS
Standard Deduction (Sec 16(ia))
β βΉ75,000
Employer NPS β Sec 80CCD(2)
β βΉ72,000
Professional Tax β Sec 16(iii)
β βΉ2,400
Gross Total Income (GTI)
βΉ10,50,600
D β CHAPTER VI-A DEDUCTIONS (NEW REGIME)
80C investments β Not available in new regime
βΉ0
80D medical insurance β Not available in new regime
βΉ0
Net Taxable Income
βΉ10,50,600
E β SLAB TAX COMPUTATION (NEW REGIME FY 2025β26)
βΉ0 β βΉ4,00,000 @ 0%
βΉ0
βΉ4,00,001 β βΉ8,00,000 @ 5%
βΉ20,000
βΆ βΉ8,00,001 β βΉ12,00,000 @ 10% β Active slab
βΉ25,060
βΉ12,00,001 β βΉ16,00,000 @ 15%
βΉ0
βΉ16,00,001 β βΉ20,00,000 @ 20%
βΉ0
βΉ20,00,001+ @ 30%
βΉ0
Income Tax Before Cess
βΉ45,060
F β REBATE & SURCHARGE
87A Rebate (taxable income β€ βΉ12L in new regime)
β βΉ0
Surcharge (income βΉ10.5L β no surcharge applies)
βΉ0
Health & Education Cess @ 4%
+ βΉ1,802
Total Tax Payable (Annual)
βΉ46,862
G β TDS MONTHLY SCHEDULE
Annual Tax Payable
βΉ46,862
Months remaining in FY (from Apr)
12
Other income declared (Sec 192(2B))
βΉ0
Advance tax paid
βΉ0
Monthly TDS = βΉ46,862 Γ· 12
βΉ3,905 / month
Quick Summary
Gross SalaryβΉ12,00,000
Total DeductionsββΉ1,49,400
Taxable IncomeβΉ10,50,600
Income TaxβΉ45,060
Cess (4%)βΉ1,802
Total Tax PayableβΉ46,862
Monthly TDSβΉ3,905
Regime Comparison
NEW REGIME
βΉ46,862
βΉ3,905/month
β Currently applied
OLD REGIME
βΉ54,620
βΉ4,552/month
βΉ7,758 more / year
Computation Notes
β’ New regime selected by employee on 08 Apr 2025.
β’ Employer NPS βΉ6,000/month (10% of Basic) allowed in both regimes.
β’ Taxable income βΉ10.5L β 87A rebate NOT available (applies only β€ βΉ7L in new regime, but note marginal relief may apply).
β’ Re-projected each month as remaining months decrease.
Tax Slab Configuration β FY 2025β26
Updated after Union Budget Feb 2025 Β· New regime is default Β· Edit only after official Budget notification
β Tax slabs are now managed centrally in Configuration β TDS Configuration β Tax Slab Configuration. A slab change there triggers TDS recomputation for the entire company from the next payroll run. Only update after the official Budget gazette notification.
New Tax Regime β FY 2025β26
Default regime Β· Lower rates Β· Fewer deductions
| # | Income Range (βΉ) | Rate (%) | Tax on Slab (βΉ) | Cumulative (βΉ) |
|---|---|---|---|---|
| 01 | to | βΉ0 | βΉ0 | |
| 02 | to | βΉ20,000 | βΉ20,000 | |
| 03 | to | βΉ40,000 | βΉ60,000 | |
| 04 | to | βΉ60,000 | βΉ1,20,000 | |
| 05 | to | βΉ80,000 | βΉ2,00,000 | |
| 06 | to | βΉ1,00,000 | βΉ3,00,000 | |
| 07 | Above | On excess | β |
Tax rebate: βΉ25,000
%
Old Tax Regime
Opt-in Β· Higher rates but more deductions
| # | Income Range (βΉ) | Rate (%) | Tax on Slab (βΉ) | Cumulative (βΉ) |
|---|---|---|---|---|
| 01 | to | βΉ0 | βΉ0 | |
| 02 | to | βΉ12,500 | βΉ12,500 | |
| 03 | to | βΉ1,00,000 | βΉ1,12,500 | |
| 04 | Above | On excess | β |
Tax rebate: βΉ12,500
%
Surcharge Bands
Applied on income tax (before cess) when income exceeds specified thresholds
| Income Exceeds (βΉ) | Up To (βΉ) | Old Regime Surcharge % | New Regime Surcharge % | Notes |
|---|---|---|---|---|
| βΉ50L | βΉ1Cr | Standard surcharge | ||
| βΉ1Cr | βΉ2Cr | Higher income | ||
| βΉ2Cr | βΉ5Cr | New regime cap at 25% | ||
| βΉ5Cr | No limit | New regime capped at 25% |
Monthly TDS Ledger β FY 2025β26
Per-employee TDS across all 12 months Β· Green = actual deducted Β· Blue = projected Β· Red = catch-up
Actual deducted
Projected
Declaration changed
Catch-up month
ESOP / perquisite spike
| Employee | Regime | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Annual Total | Projected | Variance |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Priya Singh |
Old | βΉ28,800 | βΉ28,800 | βΉ28,800 | βΉ28,800 | βΉ28,800 | βΉ28,800 | βΉ28,800 | βΉ28,800 | βΉ28,800 | βΉ28,800 | βΉ28,800 | βΉ28,800 | βΉ3,45,600 | βΉ3,45,600 | On track |
Kiran Joshi |
New | βΉ3,905 | βΉ3,905 | βΉ3,905 | βΉ3,905 | βΉ3,905 | βΉ3,905 | βΉ3,905 | βΉ3,905 | βΉ3,905 | βΉ3,905 | βΉ3,905 | βΉ3,905 | βΉ46,860 | βΉ46,862 | On track |
Anu Joshi |
Old | βΉ8,400 | βΉ8,400 | βΉ8,400 | βΉ7,200 | βΉ7,200 | βΉ7,200 | βΉ7,200 | βΉ7,200 | βΉ7,200 | βΉ7,200 | βΉ14,400 | βΉ14,400 | βΉ1,03,800 | βΉ1,03,800 | Short βΉ14K |
Vikram Kamath |
New | βΉ26,520 | βΉ26,520 | βΉ26,520 | βΉ26,520 | βΉ26,520 | βΉ26,520 | βΉ86,200 | βΉ26,520 | βΉ26,520 | βΉ26,520 | βΉ26,520 | βΉ26,520 | βΉ3,77,400 | βΉ3,18,240 | ESOP spike |
| All Employees | βΉ5.7L | βΉ5.7L | βΉ5.7L | βΉ5.7L | βΉ5.7L | βΉ5.7L | βΉ5.7L | βΉ5.7L | βΉ5.7L | βΉ6.2L | βΉ9.8L | βΉ9.8L | βΉ68.4L | βΉ68.4L |
4 employees shown Β· Scroll right to see all months Β· ESOP spike in Oct for Vikram Kamath highlighted in purple
Challan Management β ITNS 281
Record TDS deposits to government Β· BSR code Β· Reconcile deducted vs deposited
Total TDS Deducted (FY)
βΉ17.1L
AprβJun 2025 (Q1)
Not Yet Deposited
βΉ17.1L
Q1 due 31 Jul 2025
Deposited (Prior FY)
βΉ61.2L
FY 2024β25 fully reconciled
Difference / Unreconciled
βΉ0
Prior FY clean
β³
Q1 β AprβJun 2025 Β· PENDING DEPOSIT
Due by 31 Jul 2025 Β· βΉ17,10,480 to deposit
Quarter
Q1 (AprβJun 2025)
Amount to Deposit
βΉ17,10,480
Due Date
31 Jul 2025
Challan Type
ITNS 281 (TDS β Salary)
Prior Challans β FY 2024β25
β Filed
Q4 β JanβMar 2025
βΉ14,80,200 Β· BSR 0480109 / 001234 Β· 30 Apr 2025
βΉ14,80,200
βΎ
β Filed
Q3 β OctβDec 2024
βΉ15,24,600 Β· BSR 0480109 / 001198 Β· 28 Jan 2025
βΉ15,24,600
βΎ
β Filed
βΉ15,62,400
Q2 β JulβSep 2024
βΉ15,62,400 Β· BSR 0480109 / 001142 Β· 31 Oct 2024
Perquisites & ESOP Tax
Perquisite valuation Β· ESOP exercise tax computation Β· TDS in month of event
βΉ Perquisite valuation rules and ESOP tax configuration are now managed in Configuration β Perquisites & Benefits Taxation and Configuration β ESOP Tax. This view shows the event log and per-employee tax impact.
ESOP Perquisite TDS (FY)
βΉ6.4L
3 employees exercised options
Car / Accommodation TDS
βΉ1.8L
12 employees with car perk
Total Perquisite Value
βΉ28.4L
Taxable + Concessional
ESOP Tax Configuration
Perquisite = (FMV on exercise date β Exercise price) Γ Shares Β· TDS in month of exercise
βΉ ESOPs are taxed as perquisite under Sec 17(2) in the year of exercise, not grant. For eligible startups under Sec 80-IAC, tax can be deferred to earliest of: sale / leaving company / 5 years from exercise.
Alert HR when ESOP exercise value exceeds βΉ1,00,000
Auto-notify payroll team to adjust TDS for that month
ESOP Exercise Events β FY 2025β26
| Employee | Exercise Date | Shares Exercised | Exercise Price (βΉ) | FMV on Date (βΉ) | Perquisite Value | TDS Rate | TDS Amount | Deducted In | Status |
|---|---|---|---|---|---|---|---|---|---|
VK Vikram Kamath EMP-0201 |
15 Oct 2025 | 2,000 | βΉ100 | βΉ4,250 | βΉ82,00,000 | 30% + 4% | βΉ25,58,400 | Oct 2025 payroll | Deducted |
AP Ananya Patil EMP-1041 |
08 Dec 2025 | 500 | βΉ120 | βΉ3,800 | βΉ18,40,000 | 30% + 4% | βΉ5,74,560 | Dec 2025 payroll | Upcoming |
Perquisite Valuation Rules β Sec 17(2)
Taxable perquisites valuation as per Income Tax Rules
| Perquisite Type | Valuation Method | Taxable Amount | Employer-configured for your company |
|---|---|---|---|
| Company Car β€ 1600cc | βΉ1,800/month (if driver provided: + βΉ900/month) | βΉ1,800ββΉ2,700/mo | |
| Company Car > 1600cc | βΉ2,400/month (if driver: + βΉ900/month) | βΉ2,400ββΉ3,300/mo | |
| Furnished Accommodation | 15%/10%/7.5% of salary depending on city pop. | City-specific | |
| Interest-free / Concessional Loan | SBI MCLR as of Apr 1 Γ outstanding loan balance | Variable | |
| Club Membership (company-paid) | Actual fee paid by employer | Actual cost |
Form 24Q β Quarterly e-TDS Return
File quarterly TDS returns with TRACES Β· Annexure I (quarterly) Β· Annexure II (Q4 only β salary details)
Q1
Apr β Jun 2025
Employees
152
TDS
βΉ17.1L
Filed
28 Jul
Q2
Jul β Sep 2025
TDS (est.)
βΉ17.1L
Due
31 Oct
Q3
Oct β Dec 2025
Due
31 Jan 2026
Q4
Jan β Mar 2026
Due
31 May 2026
Q1 FY 2025β26 β Form 24Q Detail
AprβJun 2025 Β· 152 employees Β· βΉ17,10,480 TDS
Deductor Details
Challan Details β Annexure I
| Month | BSR Code | Challan Serial | Date of Deposit | TDS Deducted | TDS Deposited | Difference |
|---|---|---|---|---|---|---|
| April 2025 | βΉ5,70,160 | βΉ5,70,160 | βΉ0 | |||
| May 2025 | βΉ5,70,160 | βΉ5,70,160 | βΉ0 | |||
| June 2025 | βΉ5,70,160 | βΉ5,70,160 | βΉ0 |
Q1 Fully reconciled β βΉ0 difference
Acknowledgement No: 302501281234567 Β· Filed: 28 Jul 2025 11:42 AM
Q4 Annexure II β Annual Salary Details
Only for Q4 return Β· Per-employee salary breakup, deductions, taxable income, total TDS
βΉ Annexure II is unique to Q4 Form 24Q. It contains detailed salary information for each employee β used to auto-generate Form 16 Part A. Must include all perquisites, deductions, and annual tax computation.
β’ Annual salary income per employee (Basic + allowances + perquisites)
β’ Section-wise deductions claimed (80C, 80D, HRA, etc.)
β’ Taxable income and total tax computed
β’ TDS deducted each month and total TDS for the year
β’ Previous employer TDS (from Form 12B) included here
Filing Calendar
Q1 (AprβJun)31 Jul β
Q2 (JulβSep)31 Oct 2025
Q3 (OctβDec)31 Jan 2026
Q4 (JanβMar)31 May 2026
β Q4 includes Annex II. Start preparation by Apr 15, 2026.
TRACES Integration
TRACES toggle settings are managed in Configuration β TDS Config β TRACES & External Integration.
Other Income & Advance Tax
Sec 192(2B) employee declarations Β· House property loss Β· Advance tax credit Β· Form 26AS reconciliation
βΉ Employees can declare other income under Sec 192(2B) so the employer can account for it in TDS. This is optional β employer is not liable if employee withholds. If other income increases tax, TDS is increased; if loss (e.g. house property), TDS is reduced.
Section 192(2B) Declaration β Ananya Patil
Other income declared by employee for TDS computation
House Property Income / Loss
Home loan interest deduction (Sec 24(b))β βΉ1,80,000 (max βΉ2L for self-occ.)
Net house property incomeβ βΉ1,80,000 (loss)
Other Sources Income
Advance Tax & TDS from Other Sources
Total advance tax paid directly to govt
Bank TDS on FD interest (Form 26AS)
TDS Impact β With vs Without Other Income
| Component | Without Decl. | With Decl. |
|---|---|---|
| Salary Taxable Income | βΉ7,95,000 | βΉ7,95,000 |
| House Property Loss | β | ββΉ1,80,000 |
| Other Income (FD) | β | +βΉ12,000 |
| Net Taxable Income | βΉ7,95,000 | βΉ6,27,000 |
| Annual Tax + Cess | βΉ49,010 | βΉ32,448 |
| TDS from bank (FD) | β | ββΉ1,200 |
| Monthly TDS by Employer | βΉ4,084 | βΉ2,604 |
β House property loss saves βΉ1,480 per month in TDS. Employee has been notified.
Form 26AS Integration
Cross-verify TDS already deducted by other parties
26AS auto-fetch and mismatch alert settings are in Configuration β TDS Config β TRACES & External Integration.
Last fetched: 01 Jul 2025 Β· 12 employees with Form 26AS TDS (>βΉ0)