Free Excel Utilities and Templates
Professionally built, branded Excel utilities for Indian tax and finance professionals. Full formulas, protected input cells, and audit-ready computation logic. Developed and verified by a practising Chartered Accountant.
6 Utilities Live · Free DownloadDownload an Excel utility
Each workbook below is aligned with the Income-tax Act 1961, Income-tax Rules 1962 (as amended via Rules 2026), the Finance Act 2025, and the Code on Wages 2019 where applicable. Updated for FY 2026-27 / AY 2027-28. Direct download — no signup, no email, no paywall.
Income Tax Comparison Utility
Old vs New Regime comparison for FY 2025-26 and FY 2026-27, with Sec 87A rebate, surcharge, cess, and marginal relief baked in.
EMI Amortisation Schedule
Reducing-balance EMI with up to 360 monthly rows — principal vs interest split, cumulative outstanding, and annual summary.
FD and RD Maturity Calculator
Quarterly compounding FD and RD with year-wise balances, TDS on interest (Sec 194A) toggle, and post-tax yield view.
TDS Rate Chart and Calculator
50+ sections for FY 2026-27 with dropdown-driven calculator. 194C, 194J, 194I, 194A, 194Q, 194R, 194S. 206AA / 206AB toggle built in.
Depreciation Calculator
IT Act (WDV) and Companies Act 2013 Schedule II (SLM / WDV) side-by-side. 90+ asset classes, half-year rule, additional depreciation.
Salary Structure Planner
Code on Wages 2019 compliant (Basic ≥ 50% floor). 8-metro HRA, waterfall allocation, FY 2026-27 amended limits. Reconciles exactly to CTC.
What every utility includes
- Fully transparent formulas that you can audit cell by cell
- Highlighted yellow input cells; output cells are view-protected
- Clean output sheets with print-friendly layouts
- Branded cover sheet citing the relevant Section, Rule, or financial basis
- Compatible with MS Excel 2016+, LibreOffice Calc, and Google Sheets
- 100% free download, no email registration
Prefer a quick online version?
Every utility above has a matching online calculator — instant results, no Excel required. Browse the full suite of calculators on CalcGuru.
Browse All Calculators →Tax Workings
TDS, GST, IT, TCS computation workbooks for finance / audit teams
TDS Working File
Annual TDS register with vendor master, challan utilisation tracking, party-wise + section-wise consolidated reports for audit
Payroll Workings
PF, ESI, salary register workbooks with statutory accuracy
Audit Workings
Engagement-level working papers for internal, statutory and tax audits
Reconciliations
GSTR-2B, bank, party ledger reconciliation workbooks
Tax Compliance & Checklists
Income Tax, GST, TDS, TCS workings and filing checklists
TDS Data Collection Template
Annual workbook for clients to record monthly TDS deductions and email back to their CA. 12 monthly tabs + persistent vendor directory.
ROC Compliance & Checklists
Companies Act compliances, board procedures, statutory registers
Payroll Compliance
PF, ESI, PT and labour-law compliance templates and trackers
Registrations
Fillable forms to collect promoter details + documents required for various business entity registrations
Pvt Ltd Registration – All Indian Promoters
Fillable form for incorporating a Private Limited Company where ALL promoters are Indian residents. Both Detailed and Simple versions.
Pvt Ltd Registration – NRI / Foreign Individual Promoters
For Pvt Ltd where one or more promoters are NRI or Foreign Citizens (individuals only, not body corporates). Includes apostille requirements + FC-GPR filing.
Pvt Ltd Subsidiary of Foreign Company
When the promoter is a foreign body corporate setting up an Indian subsidiary. Captures foreign parent company details + apostilled corporate documents (COI, charter, board resolution, POA).
LLP Registration
Limited Liability Partnership incorporation form. DPIN, FiLLiP filing, LLP Agreement drafting, Form 3 critical 30-day deadline.
Audit
Internal, statutory and tax audit support templates
FEMA & International
FCGPR, FLA, ECB and foreign remittance compliance templates