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.
10 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.
SIP Calculator
Step-up SIP plus lumpsum, with a full year-wise schedule and inflation-adjusted value.
Capital Gains Calculator
Shares, property, gold and debt funds — post-2024 rules, grandfathering and indexation.
PPF Calculator
7.1% maturity with a year-wise passbook, annual or monthly min-balance interest.
SSY Calculator
Sukanya Samriddhi at 8.2% — 15-year deposits and a 21-year maturity passbook.
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
2 items
TDS Working File
Annual TDS register with vendor master, challan utilisation tracking, party-wise + section-wise consolidated reports for audit
GST Working File (Annual GSTR-1 & 3B)
Full-year outward register that rebuilds GSTR-1 and GSTR-3B for any chosen month, with HSN Table 12, RCM and a built-in GSTR-1 vs 3B reconciliation.
Payroll Workings
PF, ESI, salary register workbooks with statutory accuracy
1 item
Payroll Register (PF / ESI / PT)
Monthly salary register with auto PF, EPS, EDLI, ESI and state-wise Professional Tax, editable allowance columns and an Attendance / LOP sheet feeding the calculations.
Audit Workings
Engagement-level working papers for internal, statutory and tax audits
1 item
Debtors & Creditors Ageing
Bucket every open invoice and bill by age (0-30 / 31-60 / 61-90 / 91-180 / over 180), party-wise, with overdue flags and editable bucket boundaries.
Reconciliations
GSTR-2B, bank, party ledger reconciliation workbooks
2 items
GSTR-2B Reconciliation
Match your purchase register against GSTR-2B – matched, value-mismatch, only-in-books and only-in-2B – with the Section 16(4) time-bar flag and the eligible-ITC figure to claim.
Bank Reconciliation Statement
Reconcile the cash book to the bank statement; auto-classifies unpresented cheques, uncredited deposits and bank-only entries, and proves the closing balances tie.
Tax Compliance & Checklists
Income Tax, GST, TDS, TCS workings and filing checklists
1 item
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
Coming soon
Payroll Compliance
PF, ESI, PT and labour-law compliance templates and trackers
Coming soon
Registrations
Fillable forms to collect promoter details + documents required for various business entity registrations
6 items
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
Coming soon
FEMA & International
FCGPR, FLA, ECB and foreign remittance compliance templates
Coming soon