Resources
Excel Formats
Working spreadsheets with live formulas for GST, TDS, payroll, accounts and planning. Free to download and edit.
20 items
| Sr. No. | Resource Name | Category | File Type | Updated | Size | Version | Action |
|---|---|---|---|---|---|---|---|
| 1 | GST Sales Invoice RegisterLog every sales invoice and let formulas split GST into CGST, SGST or IGST using the buyer GSTIN state code. Totals at the bottom feed your GSTR-1 and GSTR-3B working. Self-created format | GST | XLSX | 03 Nov 2026 | 19 KB | 1.0 | Download |
| 2 | GSTR-2B vs Books ITC ReconciliationCompare input tax credit in your purchase register with GSTR-2B supplier by supplier, with an automatic status flag for each mismatch. Self-created format | GST | XLSX | 03 Nov 2026 | 17 KB | 1.0 | Download |
| 3 | GSTR-3B Monthly Working SheetPull output tax, reverse charge, ITC and reversals into one sheet to see net cash liability and a rough interest estimate before filing. Self-created format | GST | XLSX | 03 Nov 2026 | 6 KB | 1.0 | Download |
| 4 | TDS Deduction and Deposit TrackerRecord payments, pick the section, and the sheet looks up an editable rate, computes TDS and shows what is still to be deposited. Self-created format | TDS | XLSX | 03 Nov 2026 | 17 KB | 1.0 | Download |
| 5 | Monthly Salary Register with PF and ESIGross-to-net salary sheet for up to 60 employees with PF and ESI computed from editable rates and ceilings, plus employer PF cost. Self-created format | Payroll | XLSX | 03 Nov 2026 | 10 KB | 1.0 | Download |
| 6 | Asset-wise Depreciation Schedule (WDV / SLM)Compute three years of depreciation per asset under written-down-value or straight-line, with closing book value. Self-created format | Accounting | XLSX | 03 Nov 2026 | 8 KB | 1.0 | Download |
| 7 | Business Expense TrackerDay-to-day expense log with GST split and an automatic category-wise summary, handy for month-end bookkeeping. Self-created format | Accounting | XLSX | 03 Nov 2026 | 16 KB | 1.0 | Download |
| 8 | Cash Book with Running BalanceSingle-column cash book: enter receipts and payments and the running balance is carried forward automatically. Self-created format | Accounting | XLSX | 03 Nov 2026 | 20 KB | 1.0 | Download |
| 9 | Fixed Asset RegisterKeep a clean register of every fixed asset with cost, accumulated depreciation and net book value for audits and Schedule-III reporting. Self-created format | Accounting | XLSX | 03 Nov 2026 | 13 KB | 1.0 | Download |
| 10 | Income Tax Estimator (New Regime, editable slabs)Quick estimate of tax and balance payable using an editable slab table, so you can update rates yourself when the law changes. Self-created format | Income Tax | XLSX | 03 Nov 2026 | 6 KB | 1.0 | Download |
| 11 | Advance Tax Instalment PlannerSplit your estimated net tax into cumulative instalments and track what you have actually paid against each one. Self-created format | Income Tax | XLSX | 03 Nov 2026 | 6 KB | 1.0 | Download |
| 12 | Loan EMI and Amortisation ScheduleMonth-by-month principal and interest schedule for loans up to 30 years, driven by amount, rate and tenure. Self-created format | Finance | XLSX | 03 Nov 2026 | 21 KB | 1.0 | Download |
| 13 | GST Tax Invoice TemplateFill-in invoice with line items, automatic taxable value, CGST/SGST or IGST split by place of supply, round-off and payable amount. Self-created format | Billing | XLSX | 03 Nov 2026 | 6 KB | 1.0 | Download |
| 14 | Inventory Stock RegisterTrack opening, purchases, sales and closing stock per item with stock value and an automatic reorder flag. Self-created format | Business | XLSX | 03 Nov 2026 | 17 KB | 1.0 | Download |
| 15 | Debtors Ageing ReportEnter outstanding invoices and see days overdue and 0-30 / 31-60 / 61-90 / 90+ buckets, to prioritise collection calls. Self-created format | Accounting | XLSX | 03 Nov 2026 | 18 KB | 1.0 | Download |
| 16 | Budget vs Actual Variance SheetList budget and actual figures by head and read the variance in rupees and per cent at a glance. Self-created format | Business | XLSX | 03 Nov 2026 | 7 KB | 1.0 | Download |
| 17 | Break-even AnalysisFind break-even units and sales, margin of safety and planned profit from price, variable cost and fixed cost. Self-created format | Business | XLSX | 03 Nov 2026 | 5 KB | 1.0 | Download |
| 18 | Financial Ratio AnalysisEnter ten balance-sheet and P&L figures to get liquidity, leverage, margin and working-capital day ratios with a plain-English meaning for each. Self-created format | Accounting | XLSX | 03 Nov 2026 | 6 KB | 1.0 | Download |
| 19 | Monthly Attendance and Leave SheetDay-wise attendance grid for 50 staff with automatic present, absent, leave and payable-day counts to feed the salary register. Self-created format | Payroll | XLSX | 03 Nov 2026 | 11 KB | 1.0 | Download |
| 20 | HRA Exemption Calculator (Old Regime)Applies the least-of-three rule for HRA exemption and shows taxable HRA, for employees choosing the old tax regime. Self-created format | Income Tax | XLSX | 03 Nov 2026 | 5 KB | 1.0 | Download |
Nothing matches your filters.
Samples and formats are for general guidance. Check them against the current official forms and rules, and have important documents reviewed by a professional before use. Official links open the government websites.
Need this prepared for you?
We can fill, file or draft these for your business.