Eight practical lessons for accountants, finance executives and business owners in India: GST and TDS registers, receivables ageing, a monthly MIS P&L, a 13-week cash flow, budget vs actual, a fixed asset register and financial ratios.

Every lesson has an Excel workbook with automatic checks. Assumes the Excel Beginner Course or similar.

1. 1Excel for Finance Lesson 1: GST Sales Register and Monthly SummaryBuild a GST sales register in Excel: CGST/SGST vs IGST by state code, rate-wise and head-wise monthly totals with SUMIFS and SUMPRODUCT,…
2. 2Excel for Finance Lesson 2: TDS Register and Quarterly SummaryMaintain a TDS register in Excel: section-wise rates, the higher rate without PAN, TDS per payment, monthly deposit totals and due dates,…
3. 3Excel for Finance Lesson 3: Receivables Ageing and CollectionsTrack receivables in Excel: outstanding per invoice, days past due from the due date, ageing buckets, customer-wise outstanding, collection efficiency and a…
4. 4Excel for Finance Lesson 4: Monthly MIS P&L From a GL ExtractTurn a general-ledger or trial-balance extract into a monthly P&L: map heads to groups, SUMIFS by month and type, gross profit, EBITDA,…
5. 5Excel for Finance Lesson 5: 13-Week Cash Flow ForecastBuild a rolling 13-week cash flow forecast in Excel: weekly collections and payments, running closing balance, minimum-cash alerts, the lowest point, and…
6. 6Excel for Finance Lesson 6: Budget vs Actual With VariancesBuild a budget vs actual report: variance and variance %, favourable/adverse logic that differs for income and costs, conditional formatting, largest variances,…
7. 7Excel for Finance Lesson 7: Fixed Asset Register and DepreciationKeep a fixed asset register in Excel: SLM depreciation with SLN, WDV at block rates, months of use in the first year,…
8. 8Excel for Finance Lesson 8: Financial Ratios From the P&L and Balance SheetCalculate and read the key ratios in Excel: gross and net margin, current and quick ratio, debt-equity, interest coverage, debtor and inventory…

Related: GST reconciliation with GSTR-2B, monthly MIS report, depreciation SLM and WDV.