Partner deal registration template (free Google Sheet, and the point where it stops working)
In a 2026 survey of 102 partnership professionals, 72% said they still run some part of their program in a spreadsheet. Only 26% had a PRM. That's not a confession; it's the normal state of a partner program at a company under a few hundred people, and it's fine right up until it isn't.
This page gives you the sheet we'd use, explains the three columns most templates leave out, and then walks through what broke for real people who stayed on a sheet (or a CRM property) a little too long. Their posts are linked. None of them are customers of ours.
Copying the template
The template is a single Google Sheet with two tabs, Deals and Partners, plus a short read-me. Make your own copy here. Share the Deals tab with partners as view-only and give them a form for submissions, because a partner with edit access to the whole sheet is a partner who will one day sort it and not unsort it.
Prefer Excel? Download the .xlsx.
Deals tab columns
| Column | Why it's there |
|---|---|
| Deal name | The company, not the contact. Contacts change jobs. |
| Partner | Must match a row on the Partners tab exactly. Free text here is how attribution dies. |
| Registered on | The date the partner told you, not the date you logged it. |
| Source | Portal, email, Slack, event, or link. You'll want this later. |
| Stage | Use your CRM's stage names. Don't invent new ones. |
| Amount | Estimated. Update on close. |
| Close date | Blank until it closes. |
| Last activity | The date anything happened. Goes stale first. |
| Commission % | From the partner's terms, copied per deal, because terms change. |
| Commission owed | Amount × commission %, filled on close. |
| Paid on | Blank until you pay. |
Partners tab columns: partner name, contact, email, commission %, agreement date, status.
Adding the three columns people leave out
Most templates stop at name, partner, stage, and amount. That's enough to answer "what's in the pipeline." It is not enough to answer the three questions that actually come up.
Registered on. Two partners will eventually bring you the same account. A HubSpot user running a reseller program built a landing-page form for exactly this reason, so the vendor "won't work with their competitors on the same opportunity." Then the second partner registered a contact who was already on a deal, and the form overwrote the first partner's ownership. The fix the community offered was a workflow that emails a human to go check whether it's a conflict. The date column is how that human decides.
Last activity. A deal nobody has touched in 60 days is a deal in name only, and you cannot find those by scrolling. Another HubSpot user described a channel program where several partners were chasing the same end customers, so the same opportunity showed up multiple times and the pipeline looked bigger than it was. Their words: "embellishing numbers." A last-activity column doesn't stop duplicates, but it does tell you which of the duplicates is the live one.
Paid on. You promised a partner 15%. The deal closed in March, it's July, and the only thing standing between you and an awkward email is this column being blank. One partnerships person put it plainly: paying commissions from their CRM data was "a cumbersome manual process, involving data sheets." That was 2021. The replies suggested spinning up a separate free HubSpot account per partner and syncing between them. There's no sign anyone did.
Knowing when the sheet stops working
Our rule of thumb is 10 partners or 50 open deals, and we hold it loosely. The 2026 benchmark found 21% of programs still tracking partner-sourced deals entirely by hand, and 30% of respondents spending more time on operations than on partners. The sheet doesn't fail on a particular Tuesday. It fails in a predictable order, and you can watch each step happen in other people's forum posts.
First, the partner column stops matching. Someone types "Acme," someone else types "Acme Corp," and the leaderboard now has two Acmes. A HubSpot Ideas thread that's been open since 2017 asks for resellers on deals as a native feature. One commenter tried teams, parent-child companies, and custom fields, and gave up on all three because every one needed manual upkeep. Three years later another commenter was still typing "VAR" into a free-text property and admitted it required "a lot of hubspot hygiene maintenance." That's the partner column, just inside a CRM.
Then last activity goes stale. Nobody updates a date column by hand, so within a month the sheet says every deal is alive and is wrong about half of them.
Then commission math moves to a second tab that only you understand, and the first week you take off is the first week nobody gets paid.
There's a counterpoint worth taking seriously. A drone manufacturer selling through resellers tried a Salesforce partner portal, found partners wouldn't use it, and went back to one Excel file per partner that the partner edits and someone at the company re-keys into the CRM. Adoption was low, they said, and the portal "not very well suited for quickly editing/collaborating." A sheet is the thing partners will actually fill in. The price is double entry, and the double entry is yours.
Retiring the sheet
SoundGTM is a partner program platform for the one person running the whole program. Partners register deals through a portal, a tracked link, or a form on your site. You tag the partner on the deal in your CRM, and from there SoundGTM keeps stage, close date, and last activity current without you touching a column.
Every deal gets a risk score from its stage, age, and activity. When one goes quiet, SoundGTM tells you and drafts the check-in. When a deal converts, the commission calculates against that partner's terms and waits for you to authorize it, so "Paid on" stops being a column you forget and becomes a button you press.
The trade-off hasn't changed from the spreadsheet: somebody still has to tag the partner on the deal. A deal sitting in your CRM with no partner attached is invisible to us too.
Free up to 10 partners and 50 deals, no credit card, HubSpot or Attio on the free tier. AI drafting and LinkedIn features are on paid tiers.
Click through the demo without signing up: partnertracker.soundgtm.com/demo
Or give the spreadsheet a dignified retirement. Start free.