A controller's SaaS vendor list template needs ten columns: Vendor, Category, GL Code, Payment Method, Billing Cadence, Seats, Annual Cost, Owner, Source, and Notes. The two columns generic templates skip — GL Code and Source — are the ones that make the list auditable: GL Code ties each vendor to your chart of accounts, and Source records exactly which ledger, card feed, or bank statement the vendor was discovered in, so anyone can re-verify the list six months later.
Download the free vendor list template (.xlsx) — no email or signup required. It ships with a frozen header row, three worked sample rows, and a data-validation dropdown for Billing Cadence (Monthly / Annual / Usage).
The Template Structure
| Column | Type | Why a controller needs it |
|---|---|---|
| Vendor | Text | Canonical vendor name — not the processor name on the statement. |
| Category | Text | Communication, Customer Support, Productivity, etc. for budget rollups. |
| GL Code | Text | Maps the vendor to your chart of accounts so the list reconciles to the GL. |
| Payment Method | Text | Corporate card, AP invoice, or a reimbursed personal card (shadow IT flag). |
| Billing Cadence | Dropdown | Monthly, Annual, or Usage — drives how you accrue and forecast. |
| Seats | Number | Licensed seat count for right-sizing at renewal. |
| Annual Cost | Currency | Annualized total, even for monthly billing. |
| Owner | The person accountable for the tool's renew/cancel decision. | |
| Source | Text | Where the vendor was found: which GL account, card feed, or bank line. |
| Notes | Text | Notice periods, consolidation candidates, pending cancellations. |
Worked Example: Filling In the Source Column
The Source column is what separates an audit-ready vendor list from a wiki page nobody trusts. Record where each vendor surfaced, in enough detail to re-run the search:
- From QuickBooks: Zendesk appears as twelve identical monthly invoices coded to account 6210 (Software & Subscriptions). Source:
QuickBooks — 6210 Software. Anyone can rerun a Transaction Detail by Account report and find the same twelve lines. - From Brex: Slack shows as one annual charge on the corporate card, auto-categorized under Software & Subscriptions. Source:
Brex card •4821 — Software & Subscriptions. The card statement, not the GL memo, is the primary evidence. - From the bank feed: Loom shows up as a recurring $30 charge on a reimbursed personal card — it never hit a software GL account at all. Source:
Bank feed — recurring $30 charge. This is the shadow IT case: without a bank-feed pass, it stays invisible.
Three vendors, three different ledgers of record. If your template can't capture that, the next person to audit the list has to redo the discovery from scratch. The full discovery process — which reports to run and which merchant patterns to look for — is covered in how to build a SaaS vendor list from accounting data.
From Vendor List to Renewal Calendar
A vendor list answers "what do we pay for?" The follow-up question — "when can we cancel it?" — needs contract end dates and notice periods, which live in order forms, not the ledger. Once your vendor list is stable, extend it with the SaaS renewal calendar template, which adds cancellation-deadline formulas and 90/60/30/7-day alert dates. For the operating process around both, see the vendor management guide for controllers.
Frequently Asked Questions
How often should the vendor list be refreshed?
Quarterly. Re-export your transaction detail report and card statements, diff against the list, and add anything new. The Source column makes the diff fast because you know exactly which report each vendor came from.
What counts as a SaaS vendor for this list?
Any recurring software charge — including usage-based tools, payment-processor charges that mask the real vendor (Stripe, Paddle), and reimbursed personal-card subscriptions. If it recurs and it's software, it goes on the list.
Should the controller or the tool owner maintain the list?
The controller owns the list; tool owners own the decisions. Finance maintains the inventory because it controls the source data (the ledger), but each row's Owner field names the person who decides renew, right-size, or cancel.
Ready to stop maintaining this by hand? Start with the free Satellite renewal tracker — import this spreadsheet as CSV, get automated renewal alerts, and let expense-based discovery surface the vendors you missed. Satellite is a flat $299/month with Google Workspace and Zoom integrations built in.