73 audit-ready Excel templates. Every Indian compliance section, baked in.
GST. TDS. ITR. Payroll. Cap Table. Schedule III financials. Validation utilities. Stop maintaining spreadsheets every Budget — start filing returns. FY 2026-27 rates already loaded.
- Form 16 in 5 minutes — not 5 days. Print-ready CBDT format, dual-regime.
- GSTR-1 / 3B / 2A-2B / 9 / 9C reconciliations — every mismatch class auto-flagged.
- Sec 43B(h) MSME disallowance, Sec 40A(3) cash limit, Rule 36(4) — caught before audit.
- Cap Table + ESOP + Liquidation Waterfall for founders pitching the next round.
Every Indian section, circular, and rule — accounted for.
Section references documented inside every template. FY 2026-27 rates loaded.
Built for the 6 people who actually do this work
Which role do you wear? Click your pain — we'll show you what's inside for you.
HR / Payroll Manager
8 days every March on Form 16. 36-state PT/LWF maintained manually. Gratuity formula breaks when an employee crosses 5 years.
D1 CTC · D2 Salary Slip · D3-D5 PF/ESI/PT · D6 LWF (36 states) · D7 Gratuity · D10 Form 16 Part B
Accountant / CA Article
Monthly GSTR-1 vs Books reconciliation. TDS challan + 234E + Form 24Q/26Q. Trial balance that won't tie out at year-end.
A1-A3 GST recon · B1-B12 TDS suite · F5 Day Book · F6 Trial Balance · F7-F8 Schedule III
Practising CA
Client filings for 20+ entities. Each year Budget changes break half your working files. Audit qualifications you didn't catch.
Full bundle — every template is editable. 'Rates' sheet in each workbook = one cell to update for Budget changes.
Founder / Owner
Doing your own books because hiring is expensive. Cap table in PowerPoint screenshots. ESOP grants on the back of a napkin.
E1 Cap Table · E2 ESOP Vesting · E7 Liquidation Waterfall · F7-F8 Sch III · A7 GST Invoice
CFO / Finance Head
Schedule III P&L + BS for ROC every Sept. Cash flow tied to BS without errors. Ratio dashboard for board reviews.
F6 Trial Balance · F7 P&L Sch III · F8 BS Sch III · F9 Cash Flow (AS 3) · F10 Ratio Dashboard
Internal Audit / Compliance
Walkthroughs for GST audit (9C). Looking for MSME violations. Sec 17(5) blocked credit reviews. Sec 43B(h) disallowance estimation.
A11 GSTR-9C · A14 Audit Working Papers · F3 Creditors Aging (MSME flag) · A4 ITC Matching
7 modules. 73 templates. One workbook.
Each module is a folder of ready .xlsx files. Open the one you need.
GST
15 templatesGSTR-1, 3B, 2A/2B, 9, 9C reconciliations + ITC matching, RCM, E-way Bill, Refunds, Audit working papers, 239 HSN + 107 SAC codes
TDS
12 templatesSec 192 to 194R, Challans (Form 281), Forms 16 / 16A / 24Q / 26Q with dual-regime + interest + 234E late fee
ITR
10 templatesITR-1/2/3/4 (Sugam) + regime comparison, 80C/D/G tracker, Capital Gains (post-Jul-2024 rates), Crypto Sec 115BBH, DTAA, Advance Tax
Payroll
10 templatesCTC, Salary Slip, PF, ESI, Professional Tax (36 states · 101 slabs), LWF, Gratuity, Leave Encashment, Bonus, Form 16
Cap Table & ESOP
8 templatesMulti-round Cap Table, ESOP Vesting + Sec 17(2)(vi) tax, Dilution Waterfall, SAFE/CCD/CCPS, Liquidation Preference, Sec 191A deferral
Accounting
10 templatesBank Reconciliation, Petty Cash, Debtors/Creditors Aging (MSME), Day Book, Trial Balance, Schedule III P&L + BS, Cash Flow, Ratio Dashboard
Validation
8 templatesPAN, GSTIN, Aadhaar (Verhoeff), IFSC (33 banks), Mobile + Telecom Circle, PIN Code, Bank Account (18 banks), UPI (27 PSPs)
Each module follows the same yellow-input · purple-output convention. Familiar in 60 seconds.
8 compliance traps your books are bleeding from
Each one bites at audit. Each one is auto-flagged inside the workbook.
Sec 43B(h) MSME 45-day disallowance
Most accountants miss this when Udyam Aadhaar isn't logged in the master. ₹50K-₹5L tax hits at audit.
F3 Sundry Creditors Aging — auto-flags every MSME vendor > 45 days. Disallowance ₹ computed per vendor at year-end.
Sec 40A(3) ₹10K cash payment limit
One ₹12K cash entry in a single voucher = expense disallowed. ₹3.6K minimum tax loss.
F2 Petty Cash — red banner the moment a single-day single-party cash entry crosses ₹10K.
Sec 17(5) GST blocked credits
Office building maintenance, motor vehicle, food + beverage — credit you can't claim but accidentally did.
A4 ITC Matching — VLOOKUP into Sec 17(5) classes. Auto-marks blocked vs eligible per invoice.
Sec 16(2) — ITC reversal after 180 days unpaid
Vendor invoice you booked + claimed ITC but never paid → silent ITC reversal at year-end.
A3 GSTR-2A vs 2B vs Books — late-payer detection auto-reverses ITC if vendor invoice > 180 days unpaid.
PF EPS wage cap ₹15,000 logic
If you put ₹50K basic into the standard 12% formula, you over-deduct EPS and HR has to refund the employee.
D3 PF Computation — Capped vs Uncapped dropdown. EPS split + EPF split computed correctly per case.
Sec 234C tolerance — 12%/36% not 15%/45%
Most calculators use 15%/45% which is the PAYMENT schedule, not the 234C TRIGGER threshold. Over-states interest.
C10 Advance Tax — uses correct 234C tolerance thresholds for each installment (lower than the 15%/45% schedule).
Post-Jul-2024 Capital Gains rates
Half the calculators online still apply old 10% LTCG + 1L exemption. Wrong for AY 2026-27 onwards.
C7 Capital Gains — 12.5% no-indexation default, 20% with-indexation OPTION only for pre-23-Jul-24 property acquisitions.
Crypto Sec 115BBH no loss offset
Every other crypto calculator treats it like equity STCG. ₹50K-₹5L over/under tax errors common.
C8 Crypto VDA — losses computed but LAPSE explicitly. No offset against gains. No carry forward. Tax = MAX(gain,0) × 30%.
Same job. 6× faster. Less likely to break.
Four real workflows. Before the workbook → with the workbook.
HR — Payroll Month-End
- • Day 1-2: Pull attendance + leave + LOP from HR tool
- • Day 3: Recompute PF/ESI/PT per employee in Excel (formulas broke last month)
- • Day 4: Generate 60 salary slips manually using Word mail-merge
- • Day 5: Reconcile with previous month + handle 5 employee queries
- ⏱ 8 hrs every month-end
- • Drop monthly attendance into D1 CTC sheet
- • D2 Salary Slip auto-generates all 60 slips (print to PDF)
- • D3 + D4 + D5 + D6 auto-compute all statutory
- • Done before lunch
- ⏱ ~90 minutes
Accountant — Monthly GST Filing
- • Day 1: Export GSTR-1 from portal + your books
- • Day 2-3: Manual VLOOKUP to find missing/extra/amount-mismatched invoices
- • Day 4: Reconcile GSTR-3B with 2A/2B (eyeball it)
- • Day 5: Compute late fee + interest if delayed
- ⏱ 5 days every month
- • Paste GSTR-1 + Books data into A1 (auto-flags 4 mismatch types)
- • Paste 2A + 2B into A3 (5-category ITC mismatch ready)
- • A12 late fee + Sec 50(3) interest computed
- • Reviewed and filed by EOD Day 1
- ⏱ 1 day per month
Founder — Cap Table for Investors
- • Open PowerPoint, draw shareholder boxes
- • Manually compute % after new round (math wrong twice)
- • Update ESOP pool by hand (often forget pre-money vs post-money)
- • Send to investor — they reply 'this doesn't tie out'
- ⏱ Embarrassing 3 hours
- • E1 Cap Table — type pre-money + investment + ESOP target
- • ESOP top-up math solved algebraically (no circular reference)
- • Per-shareholder % at each round auto-rolls forward
- • Investor-ready in 15 minutes
- ⏱ 0.25 hr
CA — Year-End ROC Filing
- • Pull TB from Tally → Excel
- • Manually map 40+ ledgers to Schedule III lines
- • Build P&L + BS by hand (formula errors every time)
- • Cash Flow worked out separately — never ties to BS exactly
- ⏱ 12-14 hrs over 3 days per client
- • F6 Trial Balance → SUMIFS into F7 P&L + F8 BS automatically
- • F9 Cash Flow ties to closing cash via formula
- • F10 Ratio Dashboard auto-populated for management note
- • All Schedule III aligned for ROC
- ⏱ 3-4 hrs per client
What you actually save — in days, not adjectives
Conservative buyer estimate from the first 12 months.
At a modest ₹500/hr billable, that's ₹3.6L+ of recovered time per year. Payback in well under one cycle.
Type 5 inputs.
Get a print-ready Form 16.
- •Yellow cells: Employee name, PAN, gross salary, regime (old/new), CTC inputs.
- •Purple cells: tax computed under chosen regime, surcharge, cess, net tax.
- •Print-ready CBDT Form 16 Part B page, A4 portrait, signature block.
- •Dual-regime preview lets you compare before locking the regime.
- •Footer auto-stamps FY 2026-27 + section refs.
Every one of the 73 templates follows this convention: yellow inputs, purple outputs, conditional formatting for warnings, print-ready output where applicable.
What you get when you buy
No fluff. Files, structured. Open and use.
73 .xlsx Templates
7 folders, 1 per module
Start-Here PDF Guide
16 pages · task index · rates cheat sheet
Per-Template README
Inputs, outputs, section refs in each .xlsx
FY 2026-27 Rates Loaded
Slabs, GST, PF/ESI/PT, all current
Budget 2027 Update
Free refresh within 4 weeks of Budget
Lifetime Access
Pay once. Download forever.
₹999. 73 audit-ready templates.
One purchase. Every Indian compliance section. Budget 2027 update included.
vs Tally / Zoho / Hiring / Build-it-yourself
We don't replace Tally. We do what Tally doesn't.
Most buyers run this alongside their existing books tool.
Is this the right pack for you?
Honest checklist. 30 seconds.
This IS for you if...
- ✓You handle Indian compliance — payroll, GST, TDS, ITR, books
- ✓You already know Excel — don't need a tutorial, need ready templates
- ✓You've been bitten by a compliance miss (43B(h), Rule 36(4), PF cap, etc.)
- ✓You maintain 5-50 person org / 1-10 client books and want to stop reinventing
- ✓You want to send investor / auditor / board files that don't embarrass you
- ✓You'd rather spend Budget 2027 reading the speech, not patching spreadsheets
This is NOT for you if...
- ✕You want to LEARN Excel from scratch (try our ₹199 Excel Master Pack)
- ✕You need an ERP that runs invoicing + inventory live (use Tally / Zoho)
- ✕Your compliance is non-Indian (US 1099, UK PAYE, etc.)
- ✕You want a SaaS that files your returns automatically
- ✕You don't want to share your data with files you control — wait, that's a plus
Cross-checked by practising accountants
Every template has been built to follow the section references it cites. Wave-by-wave verification caught and fixed real bugs before release: Sec 17(2)(vi) ESOP perquisite, post-Jul-2024 cap gains property option, Sec 234C tolerance vs payment thresholds, and others. Each .xlsx self-tests with assertions before shipping.
Free refresh, every Budget, for life
Indian Budget changes a few rates every Feb. Within 4 weeks of Budget 2027 (and every Budget thereafter), the refreshed workbook hits your inbox at no cost. Existing files keep working — the new ones just have updated numbers baked in.
"Show me one wrong calc" guarantee
Buy. Open every template. Run your real numbers. If within 7 days you don't feel this saves you days of work — email support@learnandexcel.in with the word "refund." We'll send your money back. You keep the files.
Find a computation that contradicts current Indian law within 30 days? Email us with the scenario and we'll fix it within 7 days or refund you in full.
Questions practitioners ask before clicking
Plain answers. Compliance-first.
Yes — every template is built to FY 2026-27 (AY 2027-28) rates: new-regime slabs 0/5/10/15/20/25/30, old-regime 0/5/20/30, capital gains post-Jul-2024 rates (111A 20%, 112A 12.5% above ₹1.25L, Sec 112 12.5% no-indexation), GST rates 0/5/12/18/28+cess, Sec 87A rebates (₹60K new / ₹12.5K old), all PF/ESI/PT slabs current. Every section reference is documented within the template. We update for every Budget within 4 weeks. That said, this is not a substitute for your CA — use the outputs to inform filings, verify with your CA before submitting.
Tally handles your books of account. This workbook handles everything Tally doesn't: ITR computation with regime comparison, ESOP perquisite + capital gain dual-event tax, Cap Table with proper Indian CCPS dilution math, Schedule III P&L + BS for ROC filing, Sec 191A startup deferral calculator, 234A/B/C interest, Form 67 + DTAA FTC, dual-regime salary projection. Most of our buyers use Tally + this workbook side-by-side.
Instant email with download links to: 73 .xlsx templates organized into 7 folders (G/D/B/A/C/E/F per the module structure), 1 PDF Start-Here guide(16 pages) mapping every template to the task it solves + India compliance calendar + FY 2026-27 key rates cheat sheet, and a per-template README inside each workbook explaining inputs, outputs, assumptions, section refs. Plus free Budget 2027 update + future Budget refreshes.
Every Budget changes a few things — slabs, thresholds, depreciation rates, etc. Within 4 weeks of Budget Feb-2027, we ship the refreshed workbook to your registered email at no cost. Your existing downloads still work; the new files just have the updated numbers baked in. You get this for as long as you've bought (lifetime).
Tested in Microsoft 365, Excel 2019/2021, LibreOffice Calc 7.x, and Google Sheets (with minor cosmetic-only differences in CF rules). Every template uses standard formulas (SUMIFS, VLOOKUP, INDEX/MATCH, IF, DATEDIF, etc.) — no VBA, no Power Query, no add-ins. Opens on any spreadsheet tool.
Single-practitioner license covers your own use including the clients you serve. If you run a firm with multiple chartered accountants, drop us a note at hello@learnandexcel.in for a firm license at a fair rate. Distribution / re-sale / sub-licensing of the files themselves to other practitioners or firms is not permitted.
The validation + payroll + GST + accounting modules are designed for non-CA founders too. Each template has yellow input cells (your numbers) and purple computed cells (the answers). The 16-page Start-Here PDF has an "I want to..." index that maps tasks (e.g. "Pay my first employee", "File my first GSTR-1") to the exact template to open. The ITR + ESOP + Cap Table modules will be heavier — that's where you'd want your CA involved to verify.
Within 30 days of purchase, if you find a computation that contradicts current Indian law (as on the workbook's cover date), email us with the template name + scenario and we'll either fix it within 7 days or refund you in full. We've already caught and documented several niche cases — Sec 17(2)(vi) ESOP perquisite, post-Jul-2024 cap gains property option, Sec 234C tolerance vs payment thresholds. Every template has been cross-checked by practicing accountants before release.
Most buyers report payback within 1 cycle. HR teams save the most on the very first month-end close (the Form 16 / payroll suite alone saves a week annually). Accountants save the most on the GST module. CAs save the most on year-end Schedule III + Audit working papers. Founders save the most when pitching the next round (Cap Table + ESOP + Liquidation waterfall).
7-day no-questions refund — email support@learnandexcel.in within 7 days of purchase saying "refund" and we'll send your money back. You keep the files. We'd rather have honest non-customers than annoyed buyers.
Spend the next closing on coffee, not crisis.
73 audit-ready templates. Every Indian section baked in. FY 2026-27 rates loaded. Budget 2027 update on the house. One-time ₹999.
Instant download · Budget 2027 update included · 7-day refund · Indian Business Excel Workbook — 73 Compliance Templates