Tech Manager Lab Blog

SaaS Spend Audit in Excel: Find Shadow IT + Cancel Waste in 30 Minutes

30-minute SaaS spend audit for 20–200 seat firms: 3-source discovery (identity, money, billing), dedupe pivot, five decisions. Typical 50-seat find: ~Rs 86,800/month, over Rs 10 lakh/year. Free Excel template included.

KEY FINDINGS

• Discovery: Entra/Google export + 90-day card CSV + billing export
• Dedupe: normalize names, pivot by category, flag shelfware (assigned minus active)
• Decide: cancel, downgrade, consolidate, keep + SSO, renegotiate
• Traps: annual no-refund windows, OAuth zombie tokens, founder-card GST loss

RESEARCH DATA

• Average org: 305 apps, +9–12/month; 211 renewals/year (Zylo)
• 46% of licenses unused; 65% unused/underused (Zylo, Vertice)
• 1/3 of apps are shadow IT; IT manages ~13–15% of spend (Zylo)
• India twist: ~18% landed uplift on USD-billed tools (reverse-charge GST + forex)

METHOD: 50-seat math — Slack→Teams Rs 30,250 + Zoom trim Rs 22,610 + Dropbox→OneDrive Rs 24,000 + DocuSign trim Rs 10,000 ≈ Rs 86,800/mo. Worked example, not a guarantee.

RELATED

License Audit: Ghost Seats · 20-Point IT Health Check

SOURCES: figures as stated in the episode — watch on YouTube. Market figures linked inline. Illustrative calculations are examples, not audited benchmarks.

The IT Operating Model That Fixes All 4 Breaks (Part 4 Finale)

Series finale. Four breaks, four fixes, one operating model: ownership, decision rights, service measures, operating rhythms, continuous improvement. Each fix starts this week with no budget approval.

KEY FINDINGS

• Fix sprawl with one crossing point for every system
• Fix interrupts with a triage rule plus a protected block
• Fix accountability with authority on paper: escalation splits decided in advance
• Fix after-hours with a stated boundary the team can see
• A model decides once; a habit re-decides every week

RESEARCH DATA

• Runbook automation market $4.2B (2025) → $9.8B (2033), 11.2% CAGR (Stonebranch)
• Only ~32% of change initiatives succeed (2024–25 industry roundups); unauthorized change drives audit failures (KPMG 2024)
• US tech debt costs ~$2.41T/year (Accenture); ~30% of IT budgets go to debt service (Protiviti)
• 69% of IT leaders say tech debt blocks innovation (OutSystems)

RELATED

After-Hours & Accountability Breaks (Part 3) · 20-Point IT Health Check

SOURCES: figures as stated in the episode — watch on YouTube. Market figures linked inline. Illustrative calculations are examples, not audited benchmarks.

After-Hours Work and Accountability Breaks (Part 3)

Part 3 covers the two breaks that never leave your week: the accountability break and the after-hours break. Diagnosis only — the fixes are in Part 4.

KEY FINDINGS

• Accountability break: you own the outcome, someone else holds the levers
• After-hours break: the day ends, the work does not
• Busy weeks can end; heavy weeks follow you home

RESEARCH DATA

• Diagnosis only; repairs reserved for Part 4
• Series positioning: Part 3 of 4 in “What IT Managers Do in 2026”

RELATED

Microsoft 365 License Audit: 30 Ghost Seats Cost ₹3.5 Lakh a Year (SMB) · 20-Point IT Health Check

SOURCES: figures as stated in the episode — watch on YouTube. Illustrative calculations are examples, not audited benchmarks.

Microsoft 365 License Audit: 30 Ghost Seats Cost ₹3.5 Lakh a Year (SMB)

A 9-minute walkthrough covering how to find ghost seats in Microsoft 365 licenses, reconcile them against Zoho Books bills, and save approximately ₹3.5 lakh annually for companies with 100+ seats.

KEY FINDINGS

• Users often miss unused licenses leading to significant waste
• Quarterly reconciliation process saves substantial costs
• Power Query can automate license tracking
• Manager-approved suspensions reduce waste

RESEARCH DATA

• Average savings: ₹3.5 lakh/year at 100+ seat firms
• Time saved: ~2 hours/month on license auditing
• Common pain points: manual spreadsheet tracking, delayed billing reconciliation

METHOD: 30 ghost seats × ~₹975/seat/month × 12 ≈ ₹3,51,000/year at ~100 seats. Worked example from the episode — your rate card decides your number.

RELATED

After-Hours Work and Accountability Breaks (Part 3) · Tool Sprawl and Interruptions Steal Your Week (Part 2) · 20-Point IT Health Check

SOURCES: figures as stated in the episode — watch on YouTube. Illustrative calculations are examples, not audited benchmarks.

Tool Sprawl and Interruptions Steal Your Week (Part 2)

Part 2 continues the discussion on managing tool sprawl, interruptions, and maintaining productivity in IT environments.

KEY FINDINGS

• Top 5 productivity killers for IT managers
• Strategies for prioritizing essential tools
• Case study: reducing tool count by 40%

RESEARCH DATA

• 78% of IT managers struggle with tool overload
• Average time lost to tool switching: 15 minutes/day
• ROI: 3:1 for productivity gains

METHOD: 78%, 15-min and 3:1 ROI figures are illustrative examples stated in the episode, not independently surveyed benchmarks.

RELATED

Microsoft 365 License Audit: 30 Ghost Seats Cost ₹3.5 Lakh a Year (SMB) · What IT Managers Do in 2026 — And How It's Broken (Part 1) · 20-Point IT Health Check

SOURCES: figures as stated in the episode — watch on YouTube. Illustrative calculations are examples, not audited benchmarks.

What IT Managers Do in 2026 — And How It's Broken (Part 1)

Analysis of current IT management challenges and trends in 2026.

KEY FINDINGS

• Shift toward cloud-native infrastructure
• Increased demand for cybersecurity training
• Hybrid work impact on IT operations

RESEARCH DATA

• 65% of IT managers cite cybersecurity as top concern
• Cloud migration complexity increases by 30% YoY
• Remote team support requires 40% more IT capacity

METHOD: trend figures are illustrative examples stated in the episode, not independently surveyed benchmarks.

RELATED

Tool Sprawl and Interruptions Steal Your Week (Part 2) · 7 AI Tools Every IT Manager Needs for Workflow Automation · 20-Point IT Health Check

SOURCES: figures as stated in the episode — watch on YouTube. Illustrative calculations are examples, not audited benchmarks.

7 AI Tools Every IT Manager Needs for Workflow Automation

Overview of AI-powered tools for IT operations, including scheduling, ticket routing, and automated reporting.

KEY FINDINGS

• Top 7 AI tools for IT efficiency
• Implementation roadmap for adoption
• Cost-benefit analysis

RESEARCH DATA

• Average productivity gain: 25% with AI automation
• Top 3 tools with highest ROI: ticket routing, automated reporting, chatbots
• Implementation timeline: 4-6 weeks for pilot programs

METHOD: 25% gain and ROI rankings are illustrative examples stated in the episode, not independently measured benchmarks.

RELATED

What IT Managers Do in 2026 — And How It's Broken (Part 1) · How to Build an IT Operating Model People Actually Use (Part 4) · 20-Point IT Health Check

SOURCES: figures as stated in the episode — watch on YouTube. Illustrative calculations are examples, not audited benchmarks.

How to Build an IT Operating Model People Actually Use (Part 4)

Step-by-step guide to building sustainable IT operating models.

KEY FINDINGS

• Four pillars of effective IT operations
• Scaling from 20-200 seat firms to enterprise
• Metrics for measuring operational health

RESEARCH DATA

• Success factors: clear governance, standardized processes, continuous improvement
• Common pitfalls: siloed teams, lack of documentation
• Benchmark metrics: MTTR reduction, SLA compliance rates

METHOD: governance factors and benchmark metrics are practitioner guidance from the episode, not independently surveyed data.

RELATED

7 AI Tools Every IT Manager Needs for Workflow Automation · How to Turn an IT Technical Request Into a Business Case (Part 3) · 20-Point IT Health Check

SOURCES: figures as stated in the episode — watch on YouTube. Illustrative calculations are examples, not audited benchmarks.

How to Turn an IT Technical Request Into a Business Case (Part 3)

Framework for converting technical requests into compelling business cases with ROI justification.

KEY FINDINGS

• Five-step framework for business case creation
• Quantitative vs. qualitative justification techniques
• Stakeholder engagement strategies

RESEARCH DATA

• 80% of successful projects had clear ROI calculations
• Average business case approval time: 14 days
• Top justification factors: cost avoidance, revenue enablement, risk mitigation

METHOD: 80%, 14-day and justification figures are illustrative examples stated in the episode, not independently surveyed benchmarks.

RELATED

How to Build an IT Operating Model People Actually Use (Part 4) · IT Vendor Scorecard: 5 Categories to Rate Any Vendor (Part 2) · 20-Point IT Health Check

SOURCES: figures as stated in the episode — watch on YouTube. Illustrative calculations are examples, not audited benchmarks.

IT Vendor Scorecard: 5 Categories to Rate Any Vendor (Part 2)

Framework for evaluating IT vendors across five key categories.

KEY FINDINGS

• Vendor evaluation criteria: cost, support, scalability, security, integration
• Weighted scoring model for decision-making
• Red flags to watch for in vendor contracts

RESEARCH DATA

• Vendors scoring above 85% in scorecards achieve 30% higher retention
• Top 3 scoring categories: support responsiveness, SLAs, pricing transparency
• Common negotiation levers: contract terms, renewal clauses, exit strategy

METHOD: 85%/30% and category rankings are illustrative examples stated in the episode, not independently surveyed benchmarks.

RELATED

How to Turn an IT Technical Request Into a Business Case (Part 3) · Vendor Negotiation for IT Managers: The 3 Numbers You Need (Part 1) · 20-Point IT Health Check

SOURCES: figures as stated in the episode — watch on YouTube. Illustrative calculations are examples, not audited benchmarks.

Vendor Negotiation for IT Managers: The 3 Numbers You Need (Part 1)

Essential metrics for negotiating better deals with IT vendors.

KEY FINDINGS

• Three critical numbers: Total Cost of Ownership (TCO), Hidden Costs, Contract Flexibility
• Negotiation tactics for each metric
• Template for vendor negotiation conversations

RESEARCH DATA

• TCO typically underestimates actual costs by 40-60%
• Hidden costs average 25% of stated price
• Contracts with flexibility clauses reduce churn by 35%

METHOD: 40–60%, 25% and 35% figures are illustrative examples stated in the episode, not independently surveyed benchmarks.

RELATED

IT Vendor Scorecard: 5 Categories to Rate Any Vendor (Part 2) · 20-Point IT Health Check

SOURCES: figures as stated in the episode — watch on YouTube. Illustrative calculations are examples, not audited benchmarks.