Assuming you are for the financial year 2023-2024, and using old tax regime for simplicity:
Tax Slabs for FY 2023-2024 (Old Regime):
Let's calculate tax with a simple if statement (for simplicity, education cess and surcharge are not considered):
Cess (B11): Assuming 4% cess on tax
Total Tax (B12):
============================================
XXCXX DECLARATION FORM – SALARY TAX CALCULATION
============================================
Name: _____________ PAN: _____________
FY: 2024-25
DECLARED DEDUCTIONS:
GROSS SALARY : ₹ 12,00,000
TAXABLE INCOME : ₹ 7,25,000 xxcxx declaration impots calculator india excel pdf link
TAX LIABILITY (Old) : ₹ 58,240 (incl. cess)
TAX LIABILITY (New) : ₹ 33,800 (incl. cess)
I CHOOSE: [ ] Old Regime [X] New Regime
New Tax Regime (Default):
Old Tax Regime:
This guide covers how to use Excel for tax calculation, how to submit investment declarations, and links to official government PDFs.
| Error | Consequence | Solution |
|-------|-------------|----------|
| Reporting Indian income on 2042 directly (without 2047) | Double taxation – no credit allowed | Always attach 2047. |
| Using current year exchange rate instead of average annual | Miscalculation of French tax | Use the official Banque de France rate for the exact tax year. |
| Forgetting the Quotient Familial (family coefficient) | Overstated tax by 40%+ | Divide taxable income by number of parts (2 for couple + 0.5 per child). |
| Not including Indian rental income (revenus fonciers) | French tax audit + penalties (up to 40%) | Declare even if no TDS was deducted in India. |
| Claiming 100% of Indian TDS as credit | Exceeds the DTAA limit (max = French tax on that income) | Use MIN( French tax on India income, actual TDS) formula. | Assuming you are for the financial year 2023-2024,
Field,Value (Example),Your Entry
Employee Name,Rajesh Sharma,
PAN,AXXXXXXXX,
FY,2024-25,
Basic Salary (pm),50000,
HRA Received (pm),25000,
Rent Paid (pm),15000,
80C Investments,150000,
80D (Self),25000,
80D (Parents),50000,
Home Loan Interest,200000,
NPS (80CCD1B),50000,