If you're the IT lead or ops person at a 50-to-200-person Indian company, you've almost certainly been in this exact situation: a ₹2.4 lakh annual renewal hits the company card in January and nobody on finance knew it was coming. The vendor sent renewal notices to a billing email that three people have access to and zero people actively monitor. The budget is already locked. You cancel the tool or eat the cost, and either way someone's unhappy.
SaaS spend management IndiaaS subscriptions are designed to be invisible until they're not. Auto-renewals, annual billing, and scattered ownership across departments means the average Indian SMB is running 30-to-60 tools with no single place that shows what's being paid, by whom, and when it expires.
This article gives you a free Google Sheets template that covers the basics of a SaaS asset register, walks through how to populate it without losing a week of your life, and is honest about where a spreadsheet runs out of road. By the end, you'll have something usable today and a clear picture of what a lightweight automated layer looks like when you're ready for it.
Why IT Teams Still Reach for a Spreadsheet First
Most companies between 50 and 200 people don't have a formal IT asset management tool. That's not negligence. Dedicated ITAM platforms cost real money, require implementation time, and often solve problems at a scale that doesn't match where you are right now. A well-structured Google Sheet, on the other hand, costs nothing and can be live within an afternoon.
SaaS renewal calendar template India the value of a lightweight ITAM process. You get visibility, a renewal calendar, and a forcing function to assign ownership to every tool. What you don't get is automation, live usage data, or shadow-IT detection. Those gaps matter, and we'll cover them directly. But starting with a spreadsheet beats starting with nothing, which is what most teams are working with right now.
The average Indian SMB renews 60% of its SaaS stack on autopilot — with no utilisation review whatsoever.
SaaS audit checklist India the credit card statement. IT sees the provisioning requests. Neither team has the full picture. A shared asset register, even a manual one, fixes that coordination gap before it costs you money.
Key takeaway: A spreadsheet is the right starting point for most SMBs — fast to set up, free to run, and 80% effective. The remaining 20% is where automation earns its keep.
What Every SaaS Asset Register Needs to Capture
The usefulness of your register is determined entirely by which fields you include. Too few and it's decorative. Too many and nobody fills it in. Here's what actually earns its column.
Core subscription fields
- Tool name and vendor — obvious, but keep them separate columns so you can sort by vendor when consolidating contracts
- Category — productivity, security, infrastructure, marketing, etc. This feeds the department spend summary later
- Contract owner — the specific person accountable for this tool, not "IT" as a department
- Billing email — where renewal notices go; often different from the contract owner's email
- Annual cost in INR — always convert to annual and to INR; USD annual costs hiding as monthly charges are how renewals sneak up on you
- Renewal date and notice period in days — the notice period column is the one most templates skip, and it's the one that matters most. A tool with a 60-day cancellation notice requirement needs to surface on your radar in October if it renews in January
- Payment method — which card or account gets charged; critical when that card is cancelled or when you're doing a card audit
- Auto-renewal clause — yes or no; if yes, treat the notice-period deadline as the real renewal date
Usage and compliance fields
- Active license count vs. purchased seat count — the gap between these two numbers is money on the table
- Last-login data source — note where you're pulling utilisation data from (admin console, vendor report, manual survey) so you know how fresh it is
- Data residency — does the vendor store data in India or abroad? Relevant for regulated data types
- Vendor SOC 2 / ISO 27001 status — a one-cell flag that your security review can reference
GST-specific fields for Indian context
This block is what most international ITAM templates miss entirely. Add columns for vendor GSTIN, HSN/SAC code, GST amount per invoice (at 18%), and ITC-eligible (yes/no). If you're buying SaaS from a GST-registered vendor and you have a valid GSTIN on record, you can claim input tax credit on those invoices. For a company spending ₹30 lakh a year on SaaS, that's potentially ₹5.4 lakh in ITC that disappears if you're not tracking it.
Action: Before your next monthly close, pull three vendor invoices and check whether the vendor GSTIN is printed on the invoice. If it's missing, you can't file ITC on that invoice — contact the vendor's billing team and get it corrected retroactively where possible.
Run a free SaaS spend audit — find every hidden subscription
Inside the Template: Sheet-by-Sheet Breakdown
The template is structured across 4 sheets, each serving a distinct audience. The IT lead lives in Sheet 1. Finance lives in Sheet 3. The CFO glances at Sheet 2 when they want to know what's expiring.
Sheet 1 — Master SaaS Register
One row per subscription. This is the source of truth every other sheet pulls from. The renewal status column uses a formula: =DAYS(renewal_date, TODAY()) to calculate days remaining, and conditional formatting rules color the entire row red when fewer than 30 days remain, amber for 31-to-90 days, and green beyond that. At a glance, you know exactly which tools need attention this month.
Sheet 2 — Renewal Calendar (next 90 days)
Auto-populated from Sheet 1 using a FILTER() and SORT() combination that returns only rows where the renewal date falls within the next 90 days, sorted ascending. This sheet is what you share in the monthly IT-finance sync. No scrolling through 50 rows, no explaining colors.
Sheet 3 — Spend by Department
A SUMIF()-based pivot that groups annual spend by the department column in Sheet 1. When the CFO asks "how much is engineering spending on SaaS?" this answers it in one number. It's also how you spot when one department is running 3 overlapping project management tools without realising it.
Sheet 4 — License Utilisation
Manual input: purchased seats vs. seats with a login in the last 30 days. A calculated column shows utilisation percentage. Any tool below 70% is flagged. That 70% threshold isn't arbitrary — most SaaS vendors won't negotiate seat reductions mid-contract, but you can build the case for the renewal conversation with hard data from this sheet.
How to Populate the Template Without Losing a Week
The first population is the hardest. Here's the fastest path through it.
Step 1: Search the company Gmail. Use these search operators in sequence: subject:(invoice OR receipt OR subscription OR "payment confirmation") filtered to the last 12 months. Export or manually log every unique vendor that appears. This catches 70-80% of tools billed to the company email.
Step 2: Cross-check the corporate card. Pull a 12-month transaction export from the company credit card and bank account. Look for recurring line items you don't recognise. USD amounts that repeat monthly or annually are almost always SaaS. Convert each to INR at the billing month's exchange rate and log it.
Step 3: Run a shadow-IT survey. Email every department head a 10-question form. Ask them to list every tool their team uses, who pays for it, what it costs approximately, and whether it's on a personal card or the company account. Figma, Notion, Loom, Calendly, and similar tools frequently sit on personal cards because someone signed up for a free trial that converted to paid. This step surfaces 20-to-40% more subscriptions than the invoice search alone.
Step 4: Assign an owner to every row before you close the spreadsheet. Unowned tools are the ones that silently renew. If you can't name a human being who is accountable for a tool, that's a signal the tool may not need to exist.
Realistic time estimate for a 100-person company doing this for the first time: 4 to 8 hours. That's uncomfortable but it's a one-time cost. After the first pass, monthly maintenance drops to 30-to-45 minutes.
Keeping the Spreadsheet Accurate After Week One
This is where most ITAM spreadsheets quietly die. The first version is thorough. By month 3, it's missing 15 tools. By month 6, it's archaeological record rather than operational data.
Most ITAM spreadsheets are roughly 60% accurate within 90 days of creation without a formal maintenance process. New subscriptions get bought. People leave. Tools get cancelled. None of it makes it back to the register unless someone is explicitly responsible for updating it.
The fix is simple but requires commitment. Assign one Directly Responsible Individual — not a committee, not "the IT team" — who owns the register. This person does a monthly 30-minute pass: add new tools, update costs if annual plans renewed, flag anything that looks stale.
Set a recurring Google Calendar event 60 days before each major renewal date with a link directly to that row in the spreadsheet. When the notification fires, the DRI has time to actually evaluate whether the tool still makes sense before the auto-renewal window closes.
Watch out: Employee offboarding is the highest-risk moment for licence leakage. When someone leaves, their SaaS access often persists for months — sometimes years — with the company continuing to pay for a seat a ghost user holds. Add an ITAM review to your HR offboarding checklist and reclaim licences within 48 hours of a departure.
Add a simple change log tab: date, tool name, change made, changed by. It's append-only, takes 2 minutes per entry, and gives finance an audit trail when they question why a tool appeared or disappeared from the monthly spend report.
Key takeaway: The spreadsheet is only as good as its maintenance process. One DRI, monthly reviews, and an offboarding hook in HR keeps it from becoming fiction within a quarter.
The Spreadsheet's Hard Limits: Where It Breaks Down
It'd be dishonest to sell you on a template without being clear about where it fundamentally can't help you.
Manual entry means you're always slightly behind. New SaaS signups rarely get logged the day they happen. By the time someone updates the register, the tool has been live for a week, the free trial has converted to paid, and the first invoice has already hit the card.
Google Sheets cannot push alerts. A cell turning red when a renewal is 30 days out is only useful if someone opens the spreadsheet. If your DRI is on leave, travelling, or just busy, that visual cue means nothing. Building an alert via Google Apps Script is possible, but it requires scripting knowledge most IT leads at SMBs don't want to maintain.
Zero integration with actual usage data. You can't pull Slack daily active users, Zoom host utilisation, or Microsoft 365 active seat counts into a cell without calling vendor APIs. So your utilisation numbers are always estimates based on manual surveys or vendor-generated reports that you remember to request.
Shadow IT stays invisible. Tools paid on a personal card, a team's petty cash, or a department's miscellaneous budget line will never appear in your spreadsheet unless someone chooses to disclose them in the shadow-IT survey. And people don't always disclose them, especially if they're not sure the company would approve.
Past roughly 60 tools, the spreadsheet becomes genuinely unwieldy. Conditional formatting across 60 rows with 20 columns, manual scrolling, and multiple people with Commenter access creating version confusion: at that scale, you're spending more time maintaining the register than the register is saving you.
Key takeaway: A spreadsheet breaks down at the exact moments that matter most — new signups, shadow IT, and renewals you forgot to check for. That's not a reason to skip it; it's a reason to know its limits from day one.
Automating What the Spreadsheet Cannot Do: AI CIO in Practice
When the spreadsheet's limits start costing you money, the natural next step is connecting the data to something that doesn't require you to remember to look at it.
Our AI CIO ingests Gmail and Outlook invoices automatically. Instead of you searching for receipts, the system reads the billing inbox and extracts vendor name, amount, renewal date, and billing cadence without manual entry. What takes 4-to-8 hours the first time you build a spreadsheet takes about 30 seconds to connect.
Live license utilisation comes from OAuth integrations with Microsoft 365, Google Workspace, Slack, Zoho, and AWS. When you connect your Google Workspace admin account, we pull actual seat counts and last-login data directly from the admin API. The utilisation percentage in your register reflects reality as of today, not the last time someone ran a manual survey.
Renewal alerts go to Slack or email at 60 days and again at 30 days before each contract date. They're not a cell color change you have to remember to look at. They're a message in the channel where your team already works, with the renewal amount, the contract owner, and a link to the tool's record.
Shadow IT gets surfaced automatically. When the system processes billing emails, it flags recurring charges that don't match any tool in the master register. Those flagged charges are your shadow IT: the Figma seat a designer has been paying for personally for 18 months, the monitoring tool an engineer signed up for during a production incident and never cancelled.
GST handling — vendor GSTIN lookup, ITC eligibility checks, and consolidated invoicing across all your SaaS — runs without a spreadsheet column. We're inside the payment layer for many of our customers, which means we see the invoices as they arrive and can reconcile them against your GSTR-2B automatically. For teams spending ₹25 lakh or more annually on SaaS, that ITC recovery alone typically covers the cost of the platform several times over.
See what's in your marketplace for vendor options and negotiated pricing if you're evaluating tools in parallel.
Template Download and Setup Instructions
The template is a Google Sheet you can copy to your own Drive without signing in to anything. Use the link below to make a copy and follow these steps to get it live in under 30 minutes.
- Rename the company tab to your organisation name so when it's shared across teams there's no confusion about which version is current
- Set your fiscal year start month in the configuration cell on Sheet 3 (defaults to April for Indian fiscal year; change to January if you run a calendar year)
- Enter your first 5 tools and validate that the renewal-status coloring fires correctly before you import anything in bulk
- Set permissions: the ITAM owner gets Editor access; department heads get Commenter access only. This prevents accidental formula breakage from people editing cells they shouldn't touch
- Run the free spend audit first if you want to skip the manual invoice-hunting step entirely
When you're ready to move to an automated setup, the template exports cleanly as a CSV that our system ingests to seed your initial asset register. You don't lose the work you did in the spreadsheet — it becomes the starting point for the automated layer.
Signs it's time to move beyond the spreadsheet: you have more than 50 tools, your DRI is spending more than 2 hours a month on maintenance, you've had one or more surprise renewals in the past 6 months, or your shadow-IT survey surfaced more tools than your official register contained.
Action: Run the free SaaS spend audit before you fill in the template manually. Connect your work inbox once, let the system surface every subscription it can find automatically, and use those results to pre-populate the spreadsheet. It takes 30 seconds to connect and typically surfaces 15-to-25 tools most finance teams didn't have on their list.
From Spreadsheet to Automated ITAM: The Migration Path
Moving from a spreadsheet to an automated tool doesn't mean starting over. Export the completed template as a CSV, and we ingest it to seed the initial asset register in Easexpense. Your historical data, ownership assignments, and category tags carry over.
What stays manual after migration: anything requiring a judgement call. Whether to cancel a tool, whether to downgrade a plan, whether a department actually needs 50 seats or could do with 30. Those decisions still require a human. What becomes automatic: discovery of new subscriptions, renewal alerts, utilisation pulls, GST reconciliation, and shadow-IT flagging.
At 90 days post-migration, customers typically see three outcomes: some number of zombie licences reclaimed (seats for employees who left months ago), at least one significant renewal caught and renegotiated before the auto-renewal window closed, and a first clean consolidated GST invoice that their finance team could actually use for ITC filing.
The cost comparison is straightforward. One missed auto-renewal on a mid-market enterprise SaaS contract — say, an annual Salesforce or HubSpot plan — can cost ₹8-to-15 lakh that you're locked into for another year. The AI CIO costs a fraction of that annually. The spreadsheet costs nothing but doesn't prevent that scenario. That's the trade-off to evaluate honestly.
If you're evaluating the platform, the pricing page has current plans and the calculator that estimates your ITC recovery based on annual SaaS spend.
Frequently asked questions
What is an IT asset management spreadsheet for SaaS?
An IT asset management spreadsheet for SaaS is a structured register, typically built in Google Sheets or Excel, that tracks every software subscription a company pays for. Each row covers one tool and captures the vendor name, contract owner, renewal date, annual cost, seat count, and usage status. It gives IT leads and finance teams a single source of truth without buying a dedicated ITAM tool. For Indian companies, a well-built template also includes GST-specific fields like vendor GSTIN, HSN/SAC code, and ITC eligibility, which are often missing from international templates. It's not a perfect solution, but it's the fastest way to get from zero visibility to meaningful visibility without a software budget.
How do I track SaaS renewals in Google Sheets?
Add a renewal date column and use the DAYS() function to calculate how many days remain until each contract renews. Pair that with conditional formatting rules that color the row red when fewer than 30 days remain and amber for 31-to-90 days. The key field most people forget is the notice period: if a vendor requires 30 days' written notice to cancel, your effective action deadline is 30 days before the renewal date, not the renewal date itself. For automated alerts without manual checking, you can extend the sheet with a Google Apps Script that sends a Gmail notification when a renewal date crosses a threshold, though that requires scripting knowledge. If you want alerts without code, an automated SaaS management tool pushes them to Slack or email directly.
Is a free spreadsheet template good enough for SaaS asset management at a 100-person company?
For a company with fewer than 30 SaaS tools and a disciplined IT lead who updates the register monthly, a spreadsheet covers the basics reasonably well. Once you cross 40-to-50 subscriptions, the manual maintenance burden and the risk of stale data make it worth considering an automated alternative. The bigger structural gap is shadow IT: tools paid on personal cards or team budgets will never appear in a spreadsheet unless someone manually audits every invoice and department head is honest in their survey responses. At 100 people, you're likely running 40-to-60 tools across departments, which puts you squarely in the zone where automation starts paying for itself — particularly if you're trying to reconcile GST across all those invoices.
How do I find all the SaaS subscriptions my company is paying for?
Start by searching the company Gmail for terms like "invoice", "receipt", "subscription", and "payment confirmation" filtered to the last 12 months. Cross-reference those results against corporate credit card statements and bank transaction exports, looking for recurring charges in USD or other foreign currencies. For tools paid on personal cards, run a short survey with department heads asking them to list every tool their team uses, who pays for it, and what it costs approximately. This process typically takes 4-to-8 hours for a 100-person company and surfaces 20-to-40% more subscriptions than finance already knows about. If you want to skip most of that manual work, connecting your work inbox to a spend audit tool surfaces the same data in minutes.
Can I track GST and ITC on SaaS subscriptions in a spreadsheet?
Yes, by adding columns for vendor GSTIN, HSN or SAC code, the GST amount on each invoice (most B2B SaaS invoices carry 18% GST), and whether the subscription qualifies for input tax credit under Indian GST rules. If the vendor has a valid GSTIN printed on the invoice and your company's GSTIN is on record with the vendor, you can claim ITC on those purchases. The manual work is collecting GSTIN details from each vendor invoice and reconciling them against your GSTR-2B — a spreadsheet can hold the data but cannot do the reconciliation or flag mismatches automatically. For a company spending ₹30 lakh annually on SaaS, the ITC at 18% is ₹5.4 lakh, which makes this worth tracking carefully even if it takes some manual effort.
What is the difference between a SaaS management platform and a spreadsheet template?
A spreadsheet is a manual, static record that you update yourself and check by looking at it on whatever cadence you remember. A SaaS management platform integrates directly with your email, payment methods, and software APIs to automatically discover subscriptions, pull live usage data, and push renewal alerts before you remember to look. The spreadsheet costs nothing but requires consistent human effort to stay accurate — effort that tends to erode within a quarter. A platform costs a monthly fee but saves the equivalent of several hours per month and catches renewals and zombie licenses that a spreadsheet would miss. The right choice depends on your SaaS stack size: below 30 tools, the spreadsheet is probably fine. Above 50, the automation starts paying for itself in recovered ITC and avoided surprise renewals alone.
How often should I update my SaaS asset management spreadsheet?
A monthly review is the minimum to keep the register useful, ideally timed to coincide with your monthly finance close so any new invoices that appeared during the month get logged while they're fresh. The two highest-risk moments outside the monthly cycle are employee onboarding, when new tool access gets provisioned and rarely gets logged in the asset register, and employee offboarding, when licenses should be reclaimed but frequently aren't. Building the ITAM review explicitly into your HR offboarding checklist and your monthly finance close process keeps the spreadsheet within roughly one billing cycle of reality. Without those two hooks, even a well-maintained register starts drifting within 60 days.