Tracking Partner Referral Leads in NetSuite
NetSuite gives two paths for tracking partner referrals: native PRM or a custom CRM setup. Choose based on lead handoff vs. revenue attribution needs.
Sarah Jenkins, CPAPrincipal Finance Automation Specialist
On this page
When you send a prospect to a partner and that deal closes, you need the referral income to hit your books without a spreadsheet scavenger hunt. NetSuite gives you two solid paths for this: the native Partner Relationship Management (PRM) module or a custom lead-tracking setup with standard CRM fields. Here's how to decide which fits your referral model.
The Core Problem: Lead Handoff vs. Revenue Attribution
Your scenario has two distinct tracking needs. First, you need visibility on which leads went to which partner and their current status. Second, you need financial reporting on referral or residual income when those deals close.
These are different problems. PRM handles both natively. A custom field approach handles the first well but leaves the second to manual journal entries. Knowing the difference saves you from building something that breaks at month-end.
Option 1: NetSuite PRM for Formal Partner Programs
If you have an established partner program with multiple partners, PRM is the intended solution. It's part of the CRM module and requires a license. The key features that match your needs:
- Lead registration and assignment to specific partners
- Status tracking from sent to closed, with timestamps
- Commission and referral tracking tied to opportunities and sales orders
- Channel manager dashboards showing lead volume and conversion by partner
To enable PRM, go to Setup > Company > Enable Features and check Partner Relationship Management on the CRM subtab. This adds the Partner record type and related fields to leads, opportunities, and transactions.
From an audit perspective, PRM gives you a clean trail. Each lead carries the partner assignment, and when the opportunity closes, the commission calculation flows to the partner record. Your auditors can trace a lead from origination to referral payment without asking you to reconstruct the history.
One detail worth noting: enabling PRM also unlocks the Partner Commissions/Royalties feature on the same CRM subtab. That feature creates the system-generated Commissions Payable account and lets you build schedules that calculate commission when earned. If you're tracking residual income, this is the piece that automates the accrual.
Option 2: Custom Fields for Simple Referral Tracking
PRM may be overkill if you send leads to a handful of partners occasionally. A lighter setup uses standard lead fields plus a few custom entity fields. Here's the configuration:
Step 1: Create the Custom Fields
Go to Customization > Lists, Records, & Fields > Entity Fields > New:
| Field Label | Type | Field ID | Purpose |
|---|---|---|---|
| Referred to Partner | List/Record (Partner) | custentity_referred_partner | Which partner received the lead |
| Referral Date | Date | custentity_referral_date | When you sent the lead |
| Referral Status | List | custentity_referral_status | Open, Won, Lost, Paid |
| Referral Agreement | Free-Form Text | custentity_referral_agreement | Notes on commission terms |
Display these fields on the Lead record under Customization > Forms > Entry Forms > Lead. Select the standard Lead form and add your fields to the appropriate section.
Step 2: Track Status with a Workflow
A simple workflow updates the referral status based on the lead's standard status field. Go to Customization > Workflow > New and create a state-based workflow:
- State 1: Sent to Partner (trigger: lead status changes to "Sent to Partner")
- State 2: Won (trigger: lead status changes to "Closed Won")
- State 3: Lost (trigger: lead status changes to "Closed Lost")
Each state updates custentity_referral_status automatically. This gives you the status visibility you asked for without manual updates.
Step 3: Build a Saved Search
Create a saved search to report on referral activity:
Go to Reports > Saved Searches > All Saved Searches > New > Lead. Set the criteria to Custom Fields > Referred to Partner is not empty. Add these result columns:
- Lead (name)
- Company Name
- Referred to Partner
- Referral Date
- Referral Status
- Status (standard lead status)
- Created Date
Save this as "Partner Referral Leads" and schedule it to email you weekly. This replaces the "how many leads did we send" question you'd otherwise answer manually.
The Revenue Attribution Gap
Here's where the custom field approach falls short. When the partner's deal closes, that income lands in their NetSuite account, not yours. You won't see referral revenue on your opportunity or sales order. The partner will need to report the closed deal to you, or you'll need a separate agreement for them to log it.
For residual income, this becomes a manual process. Each month, you'll create a journal entry:
- Debit: Accounts Receivable (or Cash if prepaid)
- Credit: Referral Income account
The control here is the saved search. Run it monthly, match closed leads against your partner's reports, and post the entry. Your auditors will appreciate the documented reconciliation.
Which Path Should You Choose?
| Factor | PRM | Custom Fields |
|---|---|---|
| Number of partners | 5+ | Fewer than 5 |
| Commission complexity | Tiered, recurring | Simple, one-time |
| Need for partner self-service | Yes | No |
| Implementation time | 1-2 weeks | 1-2 hours |
| Financial integration | Automated | Manual journal entries |
If you're a small firm sending occasional referrals, start with custom fields. You'll get the visibility you need today without the overhead of a full partner portal. If referral income becomes material to your P&L, migrate to PRM before the manual tracking becomes a control weakness.
What to Check Next
Before you build anything, confirm you have the Partner role or Sales Administrator permission. Without it, you won't see the Partner list even after enabling the feature.
Also check whether your partners have NetSuite accounts. PRM's self-service features require Partner Access and Advanced Partner Access, both enabled on the Web Presence subtab of the Enable Features page. If your partners don't have NetSuite access, the custom field route becomes the practical choice. For navigation specifics, review the NetSuite Basics Guide to confirm where features appear in your UI.
For the residual income question specifically, get the commission terms in writing from each partner. NetSuite tracks what you record, not what you're owed. A simple agreement document attached to the partner record keeps the terms visible when you post that monthly journal entry.
Final Check: Partner Access and Permissions
One more consideration: if you enable PRM but don't set up partner access, you get the internal tracking without the partner portal. That's a middle path worth considering. You get the commission schedules and the Commissions Payable account, but partners log in only if you grant access.
For a small firm, that hybrid approach might be the sweet spot. You get automated financial tracking without managing partner logins. When the volume grows, flip on Partner Access and your partners can see their own lead pipelines. Start with what fits today, and keep the upgrade path open.
