Excel, SAP, Oracle & automation tips — plus wacky facts
GST, TDS, depreciation, reconciliations and MIS reports in Excel — Indian finance examples.
GST, TDS, depreciation, reconciliations and MIS reports in Excel — Indian finance examples.
📄 25 articles⬇️ 23 with practice files🕒 Updated 11 Nov 2026
🎓 Start here: Excel for India Course → 🎓 Start here: Excel Course: Beginner → Expert → 🎓 Start here: Bank Statement Automation →Mastering the Month-End Financial Close in Excel The month-end close process is the pulse of corporate accounting. It ensures that revenues and expenses are…
Read article →A practical bank-reconciliation workflow with a downloadable Excel template, matching process and month-end review checklist.
Read article →In SAP ERP (ECC 6.0 and S/4HANA), SAP FICO (Financial Accounting & Management Controlling) forms the transactional backbone of corpora
Read article →Maintain a TDS register in Excel: section-wise rates, the higher rate without PAN, TDS per payment, monthly deposit totals and due dates, and a…
Read article →Build a table-driven TDS calculator in Excel: a section master with rates and thresholds, XLOOKUP by section and payee type, single and yearly threshold…
Read article →Build a GST sales register in Excel: CGST/SGST vs IGST by state code, rate-wise and head-wise monthly totals with SUMIFS and SUMPRODUCT, B2B vs…
Read article →Final project: margins, current and quick ratio, debtor days, debt-to-equity, interest cover and growth for two years, with a one-page dashboard.
Read article →Build a rolling 13-week cash forecast: running balance with SCAN, the first week below the minimum buffer, how much funding is needed and the…
Read article →Variance in rupees and %, Over/Under/OK status with tolerance bands, the biggest overspend and conditional formatting that makes problems obvious.
Read article →Calculate TDS on contractor, professional and rent payments with a rate table and XLOOKUP, apply single-payment limits and the higher rate when PAN is…
Read article →Match purchase invoices in your books with GSTR-2B by GSTIN and invoice number: find missing invoices, extra ones and value differences, and the ITC…
Read article →Book depreciation under the Companies Act (SLM and WDV from useful life), time-proportionate depreciation, and income-tax block rates with the half rate for assets…
Read article →
