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.
50+ Utilities & Templates 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 Calculator (Salaried)
AY 2026-27 Old vs New regime side by side – Section 10 regime split, let-out house property, 87A marginal relief and surcharge relief done correctly. v2.
EMI Amortisation Schedule
Reducing-balance EMI with up to 360 monthly rows — principal vs interest split, cumulative outstanding, and annual summary.
Advanced Tax Calculator (All Heads)
All 5 heads for AY 2026-27 – capital gains engine with post-July-2024 rates and the indexation option, residency switches, exemption adjustment and marginal reliefs.
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.
MSME Ageing + 43B(h) File
Supplier master with auto 43B(h) applicability, s.15 due dates and ageing, compound interest ledger at the correct RBI rate, clause 22 figures and MSME-1 extract.
Form 3CD Audit Checklist
Clause-wise tax audit checklist for AY 2026-27 – amended Form 3CD (clause 36B, MSME clause 22), workflow columns, auto annexures and a client PBC list.
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.
Statutory register workbooks
Ready-to-use statutory registers under the Companies Act 2013 and the labour codes — one pre-formatted Excel workbook each, free and no sign-up.
Company Secretarial Registers
Six statutory registers — MGT-1, share transfers, directors & KMP, CHG-7 and allotment — in one workbook.
HR & Labour Registers
Employee Register (Form I), wages & deductions (Form IV), attendance-muster (Form IX) and wage slip (Form V).
Additional Statutory Registers
Duplicate certificates (SH-2), loans & investments (MBP-2), interested-director contracts (MBP-4) and debenture holders (MGT-2).
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
20 templates
ROC Annual Compliance Checklist & Calendar
All annual ROC filings and due dates for a private limited company or OPC in one place.
Director’s Report – Small Company / OPC
Abridged Board’s report under Rule 8A, filed with AOC-4.
Notice of Annual General Meeting
Section 101 AGM notice with explanatory statement.
Minutes of Board Meeting
Secretarial Standard SS-1 compliant board minutes format.
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
Audit season workbooks and letter formats – checklist pack, UDIN register, engagement letters, MRL and NOC
9 items
Statutory Audit Checklist Pack (Excel)
CARO 2020 applicability tester, 18-area audit programme, SA 230 file index and UDIN register in one verified workbook.
UDIN Register + Tracker (Excel)
60-day generation countdown with OVERDUE flags, and the 60-audit 44AB ceiling tracked partner-wise.
Audit Engagement Letter Format
Statutory audit engagement letter to SA 210 – CARO, IFC, audit trail and acknowledgment covered, with a linked generator.
Management Representation Letter (SA 580)
The three mandatory representations plus Rule 11(e), audit trail and MSME confirmations – dated never after the report.
FEMA & International
FCGPR, FLA, ECB and foreign remittance compliance templates
Coming soon