Skip to content
Ayush Agro Foods

Free template · Tracker sheet

Software register and renewal tracker

One sheet, one row per tool. The columns that make owners, seats, renewals and GST visible in one place, with three worked example rows to show how each is filled in.

Format
Tracker sheet
Sheet
18 columns
Get it as
CSV
Price
Free

How to adopt it

Four steps to put it to work.

  1. 01

    Download the CSV and open it in Excel or Google Sheets. Delete the three worked example rows.

  2. 02

    Add one row for every recurring software charge in twelve months of statements and your ledger.

  3. 03

    Ask each department head to name the owner for their rows within a week.

  4. 04

    Each month, match new statement lines against the register and mark foreign bills for the reverse-charge check.

Download the sheet

Built in your browser as a CSV that opens in Excel or Google Sheets.

Who
Finance keeps it; owners confirm their rows each quarter
When
Updated monthly from statements, reviewed before each renewal
Want the formatted Excel and Google Sheets version?

The columns

Renewal tracker columns
ColumnWhat to put in it
ToolProduct name as your team knows it
Vendor and countryLegal name from the invoice, and where the vendor is based
Department, ownerThe person who decides at renewal
Paid fromCard last four digits or bank account, never the full number
Currency, amount per cycle, cycleUSD 600, Annual
Annual cost (INR)From actual debits, including card markup
Seats paid, active in 60 daysFrom the vendor admin panel or sign-in data
Renewal date, notice dateNotice date from the contract, or the renewal date for self-serve plans
GST treatmentIndian GST on invoice / Foreign, no GST (check RCM) / Foreign, GST charged
Invoice heldYes or No, and where it is filed
Decision, decided by, dateRenew, reduce seats, monthly, cancel

Four views to build on it

  • Renewals in the next 90 days, sorted by notice date.
  • Seats paid against seats active, sorted by the cost of unused seats.
  • Foreign bills with no GST, for the monthly reverse-charge check with your CA.
  • Tools with no owner or no invoice, to fix first.

The routine

  • Monthly: new statement lines get a row and an owner; foreign bills are marked for the reverse-charge check.
  • Quarterly: owners confirm seats and the next renewal for their rows.
  • Each exit: use the offboarding access checklist against this register.
  • Year end: total annual cost by department for the budget.

The three example rows use fictional tool names and amounts from a worked example. GST treatment is a prompt for your accountant, not a conclusion. General information, not tax advice.

The sheet

What the CSV contains

18 columns, 3 rows. Scroll sideways on a phone.

Software register and renewal tracker columns and rows
ToolVendor and countryDepartmentOwnerPaid fromCurrencyAmount per cycleCycleAnnual cost (INR)Seats paidActive in 60 daysRenewal dateNotice dateGST treatmentInvoice heldDecisionDecided byDecision date
Framewell (worked example)Framewell Inc, USADesignAnanya IyerCard ··4417USD7200Annual62928040232026-12-132026-12-13Foreign, no GST (check RCM)YesReduce to 26 seatsAnanya Iyer2026-11-14
DealDesk CRM (worked example)DealDesk Software Pvt Ltd, IndiaSalesVikram ShettyCurrent account ··2210INR486000Annual48600030192026-12-292026-11-29Indian GST on invoiceYes
Clipnote (worked example)Clipnote Ltd, UKCompany-wideFaisal KhanCard ··8302USD3000Annual2622002592026-12-042026-12-04Foreign, no GST (check RCM)No

Tax note

General information, not tax advice. Confirm with your chartered accountant. GST and income-tax positions on cross-border software change with CBIC notifications, Finance Acts and court rulings.

Formatted version

Email me the Excel and Google Sheets version.

The same tracker sheet with formatting, drop-down lists and filters set up, in Excel and as a Google Sheets copy you can make your own.

We send the files to this address and a short series on software spend. Unsubscribe from any email.

Questions about this template

Ask the team

Why record the annual cost from actual debits?

Because for USD tools the rupees that leave your account include the bank's markup and vary month to month. The register should show what the tool really costs you.

Why a notice date as well as a renewal date?

Contracts signed with a vendor's sales team often need written notice 30 to 90 days before renewal. Miss it and the contract renews on the same terms.

When does a sheet stop being enough?

When matching statements each month takes longer than anyone has, when seat counts need sign-in data from several systems, or when renewals arrive faster than reminders. That is the work Ayush Agro Foods does.

Done with the sheet? Let Ayush Agro Foods keep it current.

Ayush Agro Foods builds the register from your statements and ledger, reads seat usage from sign-ins, and sends each owner their renewal 30 days early. Send one card statement before the demo.

  • Read-only access
  • Data hosted in India
  • Priced in rupees
  • 14-day trial on your data