New Delhi, DelhiMon – Sat: 10:00 AM – 7:00 PMinfo@skwealthtax.com
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 NameCategoryFile TypeUpdatedSizeVersionAction
1GST 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 formatGST XLSX03 Nov 202619 KB1.0 Download
2GSTR-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 formatGST XLSX03 Nov 202617 KB1.0 Download
3GSTR-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 formatGST XLSX03 Nov 20266 KB1.0 Download
4TDS 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 formatTDS XLSX03 Nov 202617 KB1.0 Download
5Monthly 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 formatPayroll XLSX03 Nov 202610 KB1.0 Download
6Asset-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 formatAccounting XLSX03 Nov 20268 KB1.0 Download
7Business Expense TrackerDay-to-day expense log with GST split and an automatic category-wise summary, handy for month-end bookkeeping. Self-created formatAccounting XLSX03 Nov 202616 KB1.0 Download
8Cash Book with Running BalanceSingle-column cash book: enter receipts and payments and the running balance is carried forward automatically. Self-created formatAccounting XLSX03 Nov 202620 KB1.0 Download
9Fixed 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 formatAccounting XLSX03 Nov 202613 KB1.0 Download
10Income 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 formatIncome Tax XLSX03 Nov 20266 KB1.0 Download
11Advance Tax Instalment PlannerSplit your estimated net tax into cumulative instalments and track what you have actually paid against each one. Self-created formatIncome Tax XLSX03 Nov 20266 KB1.0 Download
12Loan EMI and Amortisation ScheduleMonth-by-month principal and interest schedule for loans up to 30 years, driven by amount, rate and tenure. Self-created formatFinance XLSX03 Nov 202621 KB1.0 Download
13GST 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 formatBilling XLSX03 Nov 20266 KB1.0 Download
14Inventory Stock RegisterTrack opening, purchases, sales and closing stock per item with stock value and an automatic reorder flag. Self-created formatBusiness XLSX03 Nov 202617 KB1.0 Download
15Debtors Ageing ReportEnter outstanding invoices and see days overdue and 0-30 / 31-60 / 61-90 / 90+ buckets, to prioritise collection calls. Self-created formatAccounting XLSX03 Nov 202618 KB1.0 Download
16Budget vs Actual Variance SheetList budget and actual figures by head and read the variance in rupees and per cent at a glance. Self-created formatBusiness XLSX03 Nov 20267 KB1.0 Download
17Break-even AnalysisFind break-even units and sales, margin of safety and planned profit from price, variable cost and fixed cost. Self-created formatBusiness XLSX03 Nov 20265 KB1.0 Download
18Financial 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 formatAccounting XLSX03 Nov 20266 KB1.0 Download
19Monthly 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 formatPayroll XLSX03 Nov 202611 KB1.0 Download
20HRA 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 formatIncome Tax XLSX03 Nov 20265 KB1.0 Download
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.