TDS & Tax

FY 2025-26 Β· Q1 Challan Due 31 Jul 2025
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
βœ“ Filed & deposited
Q3 FY 2024–25 β€” Oct–Dec 2024
β‚Ή15.2L Β· BSR 0480109 / 001198 Β· 28 Jan 2025
βœ“ Filed & deposited
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
EmployeeRegimeAnnual GrossTotal DeductionsTaxable IncomeAnnual TaxMonthly TDSYTD DeductedStatus
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
Edit in Configuration β†’
⚠ 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
Default from FY 2024-25
#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
Opt-in required
#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β‚Ή1CrStandard surcharge
β‚Ή1Crβ‚Ή2CrHigher income
β‚Ή2Crβ‚Ή5CrNew regime cap at 25%
β‚Ή5CrNo limitNew 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 AprMayJun JulAugSep OctNovDec JanFebMar Annual TotalProjectedVariance
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
Q2 β€” Jul–Sep 2024
β‚Ή15,62,400 Β· BSR 0480109 / 001142 Β· 31 Oct 2024
β‚Ή15,62,400
Perquisites & ESOP Tax
Perquisite valuation Β· ESOP exercise tax computation Β· TDS in month of event
Edit in Configuration β†’
β„Ή 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
EmployeeExercise DateShares ExercisedExercise Price (β‚Ή)FMV on Date (β‚Ή)Perquisite ValueTDS RateTDS AmountDeducted InStatus
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 TypeValuation MethodTaxable AmountEmployer-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
βœ“ Filed
Employees
152
TDS
β‚Ή17.1L
Filed
28 Jul
Q2
Jul – Sep 2025
Upcoming
TDS (est.)
β‚Ή17.1L
Due
31 Oct
Q3
Oct – Dec 2025
Due
31 Jan 2026
Q4
Jan – Mar 2026
+ Annex II
Due
31 May 2026
Q1 FY 2025–26 β€” Form 24Q Detail
Apr–Jun 2025 Β· 152 employees Β· β‚Ή17,10,480 TDS
βœ“ Filed 28 Jul 2025
Deductor Details
Challan Details β€” Annexure I
MonthBSR CodeChallan SerialDate of DepositTDS DeductedTDS DepositedDifference
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
Q4 only
β„Ή 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
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)