Sales Territory Planning for Indian B2B Teams: A Spreadsheet-Based 30-Day System

Sales Territory Planning for Indian B2B Teams: A Spreadsheet-Based 30-Day SystemA practical way for Indian B2B teams to assign accounts, balance field-sales workload and improve territory coverage using a spreadsheet.Why geography alone is not a sales planTwo salespeople can each receive three districts and still have completely different workloads. One territory may contain 60 active buyers within a short drive, while the other contains 140 prospects spread across industrial estates. Equal map area does not mean equal opportunity. A good territory model balances realistic revenue potential, account workload, travel time and the capacity of the person responsible for it.Start with an account list, not a mapExport your customer and prospect list from your CRM or spreadsheet. Keep one row per business location. Record account name, city, PIN code, industry, revenue or potential band, last purchase, stage, decision-maker, account owner, contact frequency and estimated travel time. Remove duplicate entries and flag missing locations. This matters because a beautifully coloured map cannot repair inaccurate customer data. If a business has several plants, decide whether those locations need separate field coverage.Choose the right territory unitTerritories can be defined by geography, industry, account size, product line or a combination. A distributor covering industrial equipment may group customers by industrial cluster and travel route. A SaaS company selling remotely may divide by account potential and industry instead. A founder with only two salespeople may need just two clear ownership rules rather than a complicated hierarchy. The rule should help a rep know which accounts to contact and who handles an inbound enquiry.Calculate weighted account workloadAssign visit or contact points to each account. For example, a strategic customer requiring four visits a month may carry four points, while a smaller account requiring one visit carries one. Add separate points for long travel or complex technical demos. This is a planning score, not a universal industry formula. Compare total points per representative. If Rep A has 85 points and Rep B has 45, investigate before calling the split fair. Some accounts may need specialised expertise.Example territory balanceMeasureTerritory ATerritory BAccounts8065Monthly visit points110105Qualified pipeline₹42 lakh₹39 lakhEstimated monthly travel950 km1,450 kmTerritory B has fewer accounts but more travel. The manager might cluster its visits, move a border account or support remote demonstrations. The figures are illustrative, not benchmarks.Estimate sales capacity before setting targetsSuppose a field rep has 20 working days per month. After internal meetings, leave and administration, 14 days remain for customer visits. At four realistic visits a day, capacity is about 56 visits monthly. If the territory needs 90 in-person visits, the plan is not achievable without changes. Reduce visit frequency for lower-priority accounts, use remote meetings or adjust the coverage model. Targets must reflect actual selling time, not a calendar filled with theoretical appointments.Build a simple spreadsheetUse separate tabs for Accounts, Territory Rules, Rep Capacity, Activity Plan and Weekly Dashboard. The Accounts tab should include unique IDs to avoid double assignment. Use filters or pivot tables to total opportunity value, account count and visit points by rep. Keep a change log with old owner, new owner, date, reason and approving manager. Never silently move an active negotiation to another person.A 30-day rolloutDays 1 to 5: clean account data, mark missing locations and identify top accounts.Days 6 to 10: choose territory rules and estimate workload using contact frequency and travel.Days 11 to 15: build two or three allocation scenarios and compare workload, pipeline and capacity.Days 16 to 20: review scenarios with salespeople and protect active customer relationships.Days 21 to 25: confirm ownership, handover notes and inbound-lead routing.Days 26 to 30: pilot weekly reporting and fix assignment disputes.What to measure each weekTrack active accounts contacted, qualified meetings, pipeline created, opportunities advanced, revenue booked, overdue follow-ups, travel hours and accounts without an owner. Compare territories using ratios where appropriate, such as meetings per available field day, rather than ranking reps only by gross revenue. Look for coverage gaps and uneven workload. Review whether the model helps customers receive timely attention.Territory redesign without upsetting customersAnnounce changes internally before contacting customers. Prepare a handover note with the last discussion, open quotations, service issues and next commitment. Let the previous owner introduce the new owner for strategic accounts. Do not move accounts repeatedly to chase one good quarter. Review the model at a defined interval and allow urgent exceptions for staffing or major customer changes.Common mistakesAvoid splitting territories only by postal code without considering demand. Do not reward reps for hoarding accounts they cannot serve. Do not assign one opportunity to multiple owners without a clear coordination rule. Do not make performance claims from one month's data. Do not treat a high-potential prospect as guaranteed revenue. Finally, do not require field visits for every interaction when a remote conversation would serve the customer.Frequently asked questionsDo small businesses need territory planning software?No. A clean spreadsheet and clear ownership rules are enough to start. Software becomes useful when scale and routing complexity justify its cost.Should territories have equal revenue?Not necessarily. Compare potential, workload, maturity and rep capacity before setting targets.How often should territories change?Review coverage regularly, but make ownership changes only when there is a sound business reason.Can inside sales use territories?Yes. Segments can be based on industry, account size, language, time zone or product need.First actionChoose 30 customer accounts, add their current owners and contact requirements, and calculate workload points. This small pilot will reveal whether your present assignments are manageable before you reorganise the full sales team.Sources and verificationSalesforce Trailhead: Design and Manage Sales Territories; Salesforce: Sales Territory Mapping. All sample workload scores and figures are illustrative planning examples.