Sales Territory Plan Template: Free Google Sheets Framework for Territory Alignment

Territory planning is where sales strategy meets operational reality. A good territory plan balances account value across reps, minimizes geographic overlap, ensures coverage in high-opportunity regions, and produces quotas that are defensible. A bad one creates resentment, leaves revenue on the table, and gets relitigated every quarter.

The most common failure mode is not lack of analysis, it's lack of visibility. Sales ops builds the plan in a spreadsheet, assigns accounts by name, and never visualizes the result on a map. Rep A gets 120 accounts spread across three states. Rep B gets 80 accounts in a single metro. The account counts look balanced. The territories are not.

This is a free territory plan template for Google Sheets. Download the template here, it's designed to work alongside a territory map so you can see the geographic reality of every assignment decision.

What a Territory Plan Covers

A territory plan answers four questions: which accounts exist, who owns them, how balanced is the distribution, and where are the gaps. Everything in the plan should trace back to one of these.

Account segmentation divides accounts into tiers or categories, by revenue potential, industry, geographic region, or a composite score. The segmentation determines how accounts are distributed: high-value accounts are assigned deliberately, while lower-tier accounts fill out the rest of the territory.

Rep assignment maps each account to a rep. This is the core of territory alignment, making sure each rep has a workable book of business in terms of account count, revenue potential, and geographic concentration.

Territory balance scoring measures whether the plan is fair. Common balance metrics include total account count per rep, total ARR or opportunity value per rep, number of high-tier accounts per rep, and geographic spread (drive time or state count). A plan is balanced when no single metric is more than 20% above or below the team average.

Coverage gap analysis identifies regions, industries, or account segments with no assigned rep. These are either expansion opportunities or deprioritized segments, the plan should state which.

Template Structure: 4 Tabs, One Workbook

The template is a Google Sheets workbook with four tabs. Each tab serves a distinct function in the planning process.

1. Tab 1 — Account Master

   Every account in your territory with columns for Account Name, Address, City, State, ZIP, Owner, Tier (A/B/C), ARR, Industry, and Segment. This is the source data, paste your Salesforce or CRM export here. Add a 'Tier' column if your export doesn't have one.

2. Tab 2 — Rep Summary

   One row per rep with rollup metrics, total accounts, total ARR, accounts by tier, number of states or metros covered. Formulas pull from the Account Master tab automatically. This is where you spot imbalances.

3. Tab 3 — Balance Scorecard

   A scoring matrix that rates each rep's territory on 4 dimensions, account count, ARR value, tier distribution, and geographic spread. Each dimension is scored as balanced (within 20% of average), heavy (over 20%), or light (under 20%). Flags reps who need accounts added or removed.

4. Tab 4 — Coverage Gaps

   Regions or segments with zero or minimal coverage. Columns for Region, Account Count, Total ARR Potential, Assigned Rep (blank if uncovered), and Priority (Expand / Monitor / Deprioritize). This tab feeds directly into headcount and expansion conversations.

How to Visualize Your Territory Plan on a Map

The template becomes significantly more useful when you can see the result geographically. The fastest way to do this is to split your Account Master by rep into separate tabs, each prefixed with 'layer_'.

For example, if you have three reps. Sarah, James, and Maria, create tabs named 'layer_Sarah', 'layer_James', and 'layer_Maria'. Copy each rep's accounts into their tab. Set a different tab color for each (Google Sheets lets you right-click the tab and choose a color).

Open the InstaMaps add-on and click Load Map. All three territories appear on the same map, color-coded by rep. You can instantly see overlap, gaps, and whether 'balanced on paper' translates to 'balanced on the ground.'

This visual step catches problems that spreadsheet analysis misses. A rep with 100 accounts spread across 4 states looks balanced in the scorecard but is operationally unworkable. A rep with 60 accounts clustered in one city has lower count but higher coverage density. The map reveals what the numbers hide.

Territory Alignment: The Process

Territory alignment is the process of adjusting account assignments to balance workload, coverage, and opportunity across reps. It typically happens annually (major realignment) and quarterly (minor adjustments).

Start with the Balance Scorecard tab. Identify reps who are heavy on one dimension and light on another. A rep with high account count but low ARR may have too many small accounts. A rep with high ARR but few accounts may be over-reliant on one or two large customers.

Make reassignment decisions using the map and the scorecard together. Move accounts from heavy reps to light reps, prioritizing geographic adjacency, an account should go to the closest rep, not just the rep with the lowest count. This is where the map is essential: without it, you're guessing at geography.

After making changes, re-check the Balance Scorecard. The goal is to get all reps within 20% of the team average on all four dimensions. Perfect balance is impossible, the goal is defensible balance, where every imbalance has a clear rationale (key account relationship, regional expertise, growth assignment).

Account Tiering: How to Segment Before You Assign

Account tiering determines the quality of each territory, not just the quantity. Without tiers, you can create numerically balanced territories where one rep has 80 enterprise accounts and another has 80 accounts that will never close. The tier system prevents this.

The simplest tiering model uses three tiers based on revenue potential. Tier A is the top 20% of accounts by ARR, contract value, or estimated deal size, these are strategic accounts that justify dedicated attention. Tier B is the middle 30-40%, solid accounts with reliable revenue potential. Tier C is the bottom 40-50%, smaller accounts that are maintained but not actively developed.

Each tier should have a different visit or engagement cadence. Tier A accounts get weekly or biweekly touches, calls, meetings, QBR presentations. Tier B accounts get monthly contact. Tier C accounts get quarterly check-ins or are handled through digital channels. This cadence framework ensures reps spend time proportional to opportunity value, not spread evenly across all accounts regardless of potential.

When building the territory plan, assign Tier A accounts deliberately based on rep expertise and geographic proximity. Distribute Tier B accounts to balance workload. Fill remaining capacity with Tier C accounts. A balanced territory has a proportional share of each tier, not just a balanced total count.

Territory Optimization vs Territory Design: When to Use Which

Territory design is building territories from scratch, new team, new market, or a full reorganization. You start with the account list and an empty assignment column. The template's Account Master and Coverage Gaps tabs are the primary tools here.

Territory optimization is improving existing territories without a full redesign. Reps already own accounts, and you're adjusting the edges, moving 10-20 accounts to fix an imbalance, filling a coverage gap, or absorbing a departing rep's book. The Balance Scorecard tab is the primary tool here.

The common mistake is treating optimization like design, reshuffling everything when only a few changes are needed. Customers have relationships with their reps. Unnecessary reassignments create churn. The scorecard helps you make the minimum changes needed to fix the imbalance, not a maximum reshuffling.

Change Management: How to Roll Out Territory Changes Without Losing Reps

Territory changes are one of the top reasons sales reps leave. A rep who loses their best accounts to a reorganization feels punished for success. A rep who gets 30 new accounts dumped on them feels set up to fail. How you communicate territory changes matters as much as the changes themselves.

Gather input before finalizing. The best territory plans use both top-down data (market analysis, account scoring, revenue targets) and bottom-up feedback (rep knowledge of account relationships, travel patterns, and competitive dynamics). Share the proposed plan with reps individually before the team announcement. Give them 48 hours to flag concerns, not to veto changes, but to surface information the data doesn't capture.

When reassigning accounts, prioritize geographic adjacency over numerical balance. An account should go to the closest qualified rep, not just the rep with the lightest load. This reduces travel time and increases the likelihood the transition succeeds. For key accounts (Tier A), consider a warm handoff period where both the outgoing and incoming rep are involved for 30 days.

Communicate the rationale, not just the result. 'You're losing 10 accounts' creates resentment. 'We're moving 10 accounts to the new Midwest rep so you can focus your travel on the 15 enterprise accounts in your core region' creates buy-in. Every reassignment should have a visible benefit for the rep losing the accounts.

Step-by-Step: Building a Territory Plan From Scratch

If you're creating territories for the first time, new team, new market, or a full reorg, follow this sequence. Each step builds on the previous one.

1. Step 1 — Export your account data

   Pull every account with address, industry, ARR (or estimated deal size), and current owner (if any) from Salesforce or your CRM. Paste into the Account Master tab.

2. Step 2 — Tier every account

   Add a Tier column (A/B/C) based on revenue potential. If you don't have revenue data, tier by company size, industry fit, or engagement history. Every account must have a tier before you assign it.

3. Step 3 — Visualize the accounts on a map before assigning anyone

   Rename the Account Master tab to 'layer_All_Accounts' and open InstaMaps. Look at where the accounts are geographically. Identify natural clusters, dense metros, and sparse regions. This visual step prevents the most common mistake: creating territories that look balanced in a spreadsheet but are unworkable on the ground.

4. Step 4 — Draw territory boundaries using geography and density

   Assign clusters of accounts to reps based on proximity. Each territory should be a contiguous geographic area that a rep can reasonably cover. Avoid splitting a single metro across two reps unless volume justifies it.

5. Step 5 — Check balance using the Balance Scorecard tab

   Every rep should be within 20% of the team average on account count, ARR value, tier distribution, and geographic spread. Adjust assignments until the scorecard shows defensible balance.

6. Step 6 — Verify on the map

   Split the Account Master into per-rep 'layer_' tabs and open InstaMaps again. Look for overlap (two reps with accounts in the same area), gaps (areas with accounts and no rep), and impractical travel patterns (a rep with accounts scattered across 3+ states).

7. Step 7 — Document coverage gaps

   Populate the Coverage Gaps tab with regions or segments that have no assigned rep. Mark each as Expand (hire/assign), Monitor (revisit next quarter), or Deprioritize (not worth covering now). This becomes your territory roadmap.

From Territory Plan to Defensible Quotas

Most territory plan guides stop at account assignment. But the territory plan is the foundation for quota setting, and bad quotas are the #1 cause of rep attrition. If you skip this step, you end up with quotas based on last year's number plus 15%, regardless of whether the territory can support it.

The territory plan gives you the data to set quotas that are defensible. Start with the Rep Summary tab. Each rep's territory has a total ARR (existing revenue) and a total pipeline potential (open opportunities plus estimated whitespace). A defensible quota is based on what the territory can produce, not what the company needs the rep to hit.

The formula is straightforward: quota = (existing ARR * retention rate) + (pipeline value * historical win rate) + (whitespace * estimated penetration rate). A rep with $2M in existing ARR at 90% retention, $1.5M in pipeline at 30% win rate, and $500K in whitespace at 10% penetration gets a quota of $1.8M + $450K + $50K = $2.3M. That's defensible because every input is traceable to the territory data.

When territories are unbalanced, quotas will be unbalanced, and they should be. A rep with a territory that has $5M in ARR potential should carry a higher quota than a rep with $2M in potential. Equal quotas for unequal territories create guaranteed failure for the rep with the smaller territory and sandbagging for the rep with the larger one. The Balance Scorecard tab makes this visible: if ARR potential is 2.5x different between your highest and lowest rep, quotas should reflect that proportionally.

Present the territory plan and quota model together. When reps see that their quota comes from their territory data, not an arbitrary top-down number, they buy in. When leadership sees that quotas trace to account-level potential, they trust the forecast. The territory plan is the bridge between strategy and accountability.

When a Rep Leaves: Emergency Territory Redistribution

A rep departure is the most common trigger for unplanned territory work. If you don't have a playbook for this, you lose 2-3 weeks of coverage while figuring out what to do, and active deals die in that window.

Triage within the first 48 hours. Pull the departing rep's accounts from the Account Master tab and sort by tier and pipeline status. Tier A accounts with active pipeline (open opportunities in current quarter) are critical, these need to be reassigned to a named rep within 48 hours. The buyer has a relationship with someone at your company, and a gap longer than a week signals organizational instability.

Tier A accounts without active pipeline are important but not urgent. These can wait 1-2 weeks for a thoughtful reassignment. Tier B and C accounts can go into a temporary holding pool for 2-4 weeks while you assess whether to redistribute or hold for a new hire.

Reassign using geographic proximity, not load balancing. The rep who's physically closest to the orphaned Tier A accounts should get them, even if their account count goes above average temporarily. A rep 30 minutes away can meet the customer this week. A rep 3 states away can't, regardless of their available capacity.

Update the territory map immediately. Remove the departing rep's 'layer_' tab and redistribute their accounts into the remaining reps' tabs. Open InstaMaps and verify the redistribution makes geographic sense. Then update the Balance Scorecard, accept that it will be temporarily imbalanced and document why.

If you're backfilling the role, hold the Tier B/C accounts rather than distributing them. Loading existing reps with 30 extra accounts they'll give back in 6 weeks creates churn for the accounts and resentment from the reps. Create a 'layer_Open' tab for the unassigned accounts so they're visible on the map but not burdening anyone's quota.

Common Questions