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.
01
Download the CSV and open it in Excel or Google Sheets. Delete the three worked example rows.
02
Add one row for every recurring software charge in twelve months of statements and your ledger.
03
Ask each department head to name the owner for their rows within a week.
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
The columns
| Column | What to put in it |
|---|---|
| Tool | Product name as your team knows it |
| Vendor and country | Legal name from the invoice, and where the vendor is based |
| Department, owner | The person who decides at renewal |
| Paid from | Card last four digits or bank account, never the full number |
| Currency, amount per cycle, cycle | USD 600, Annual |
| Annual cost (INR) | From actual debits, including card markup |
| Seats paid, active in 60 days | From the vendor admin panel or sign-in data |
| Renewal date, notice date | Notice date from the contract, or the renewal date for self-serve plans |
| GST treatment | Indian GST on invoice / Foreign, no GST (check RCM) / Foreign, GST charged |
| Invoice held | Yes or No, and where it is filed |
| Decision, decided by, date | Renew, 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.
| Tool | Vendor and country | Department | Owner | Paid from | Currency | Amount per cycle | Cycle | Annual cost (INR) | Seats paid | Active in 60 days | Renewal date | Notice date | GST treatment | Invoice held | Decision | Decided by | Decision date |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Framewell (worked example) | Framewell Inc, USA | Design | Ananya Iyer | Card ··4417 | USD | 7200 | Annual | 629280 | 40 | 23 | 2026-12-13 | 2026-12-13 | Foreign, no GST (check RCM) | Yes | Reduce to 26 seats | Ananya Iyer | 2026-11-14 |
| DealDesk CRM (worked example) | DealDesk Software Pvt Ltd, India | Sales | Vikram Shetty | Current account ··2210 | INR | 486000 | Annual | 486000 | 30 | 19 | 2026-12-29 | 2026-11-29 | Indian GST on invoice | Yes | |||
| Clipnote (worked example) | Clipnote Ltd, UK | Company-wide | Faisal Khan | Card ··8302 | USD | 3000 | Annual | 262200 | 25 | 9 | 2026-12-04 | 2026-12-04 | Foreign, 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.
Questions about this template
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