Key Account Register

This register is built for accounts that have already closed and are being actively managed for retention and growth, not deals in the sales pipeline. Use the Tier column (Strategic, Enterprise, Mid-Market, SMB) to decide the cutoff — most teams start by adding every account above a revenue or strategic-importance threshold. Smaller transactional customers can stay in your CRM without cluttering this table. If an account moves from prospect to closed-won, that's the trigger to add a row here.

Health Status should be reviewed at least monthly, or immediately after a significant event like a support escalation, executive change, or usage drop. Renewal Date rarely changes, but it should be verified at contract signing and any amendment. Many teams set a recurring calendar reminder tied to each account's Renewal Date, 90 and 30 days out, to trigger a renewal review before the record goes stale.

The Account Owner column assigns a single accountable person per record, typically the account manager or customer success manager. That owner updates Health Status, Account Notes, and contract details as things change; sales or finance can populate Annual Contract Value at signing. Avoid leaving Account Owner blank — an unowned strategic account is the most common way renewals get missed.

The register is an operational tracking tool, not a system of record for revenue recognition or legal contract terms — it should point to, not replace, your CRM opportunity records and signed contract documents. It does give auditors and finance a quick cross-check of active accounts, contract values, and renewal timing. Keep Annual Contract Value aligned with your billing system rather than treating this table as the authoritative figure.

Yes, both are select columns and the option lists can be edited to match your existing account segmentation or health-scoring model. Some teams add a Platinum tier above Strategic, or expand Health Status to include an Onboarding stage. Keep the list short (3-5 options) so the ranking boards and reports stay readable.

A spreadsheet has no field-level type discipline — dates get typed as text, contract values get formatted inconsistently, and there's no built-in view of accounts at risk. This template enforces a currency field for contract value, a date field for renewals, and dropdowns for tier and health, so filtering and ranking (like accounts by Health Status) work reliably. It also removes the manual step of building a pivot table every time leadership asks which accounts are red.

Export your current key account list from your CRM or spreadsheet with account name, owner, contract value, and renewal date, then import it as the initial set of rows. Assign every account an owner and a first-pass Health Status before sharing the table with the team, so the register isn't half-empty on day one. Schedule a short kickoff to align on what Green, Yellow, and Red mean in practice, since inconsistent definitions undermine the health board.

As a standalone table, Annual Contract Value and Renewal Date are entered or updated manually, which is sufficient for most account management teams. If your contract or billing system supports exports or syncs, you can refresh this register on a schedule rather than re-entering figures by hand. The register is designed to sit alongside those systems as the relationship-management view, not to replace them.