Export Tally Data to Excel and Build a Sales Dashboard
Export Day Book, sales register and stock summary from TallyPrime to Excel, clean them with Power Query, and build a monthly sales dashboard that…
Read article →Category Archives: Excel for Finance
GST, TDS, depreciation, reconciliations and MIS reports in Excel — Indian finance examples.
GST Reconciliation in Excel: Match GSTR-2B With Your Purchase Register
GST Reconciliation in Excel: Match GSTR-2B With Your Purchase Register
Step-by-step GSTR-2B vs purchase-register reconciliation in Excel: clean GSTINs and invoice numbers, build a match key, find missing and mismatched invoices, and prepare the…
Read article →Depreciation in Excel: SLM, WDV and Income-Tax Block Method
Depreciation in Excel: SLM, WDV and Income-Tax Block Method
Calculate depreciation in Excel with SLN, DB and custom formulas: straight-line (Companies Act), written-down value, the 180-day half-rate rule, and a complete fixed-asset schedule.
Read article →Build a TDS Calculator in Excel (Section, Rate, Threshold and PAN Check)
Build a TDS Calculator in Excel (Section, Rate, Threshold and PAN Check)
A practical Excel TDS calculator: a rate table by section, threshold checks with SUMIFS, higher rate when PAN is missing, and a monthly summary…
Read article →Build a Monthly MIS Report in Excel From Scratch (Complete Guide)
Build a Monthly MIS Report in Excel From Scratch (Complete Guide)
A complete, reusable monthly MIS workbook: raw data sheets, a mapping table, SUMIFS-driven P&L and KPI pages, variance vs budget and last year, conditional…
Read article →