Location : Mohali / Chandigarh, India
Shift : Nighttime (U.S. Hours - 8 : 30 PM - 5 : 30 AM IST)
Type : Full-time, On-site
About The Role
We're looking for an experienced and analytical Commissions Specialist to take full ownership of our company's multi-tiered commissions system.
You'll calculate, audit, and process payouts for hundreds of sales representatives, leads, and managers across multiple programs — ensuring every number is verified, every report reconciled, and every payout is on time.
This role requires strong Excel / Google Sheets skills, impeccable attention to detail, and a thorough understanding of sales performance, payouts, and incentive structures.
You'll be the bridge between sales, operations, and accounting — ensuring accuracy, transparency, and accountability in the commissions process.
Key Responsibilities
- Manage end-to-end commissions processing for all sales and operational roles
- Pull data from CRMs (Insightly, Ascent, or others) to calculate eligible payouts
- Apply complex commission matrices and tiered structures for different roles (SP1s, Leads, Regionals, VPs, Dealers, etc.)
- Validate all deals and ensure status accuracy before payout (Closed → Installed → Funded)
- Perform cross-checks between CRM, payroll, and accounting data for precision
- Generate commission reports and dashboards for management review
- Handle commission adjustments, clawbacks, and escalations professionally
- Maintain clear documentation and audit trails for all payouts
- Work with accounting to reconcile payouts and ensure timely disbursement
- Collaborate with HR and Payroll teams to implement commission structures and policy updates
- Continuously improve and automate commission calculation templates and workflows
Skills & Qualifications
5+ years of experience in commissions, payroll analytics, or finance operationsStrong understanding of sales compensation plans and performance trackingExpert in Google Sheets / Excel (nested formulas, lookups, pivot tables, array formulas)Familiar with CRM systems (Insightly, Salesforce, HubSpot, or similar)Experience reconciling data between systems (CRM ↔ Payroll ↔ Accounting)High attention to detail and commitment to 100% accuracyExcellent English communication skills for clear cross-team correspondenceProven ability to meet deadlines and handle confidential financial data responsiblyExperience with solar or U.S.-based sales organizations is a plusKPIs / Success Metrics
100% on-time commission processing and reportingZero unresolved discrepancies older than 7 daysClear and accurate reporting for leadership each cycleFully documented and automated commission templatesTools & Platforms
Google Sheets / ExcelCRM (Insightly / Ascent / HubSpot)Accounting : QuickBooks Online / NetSuiteGoogle Workspace (Drive, Docs, Gmail)Slack / Asana / Monday.comIdeal Candidate
You're a numbers perfectionist who thrives in structured systems.
You love digging into data, finding inconsistencies, and ensuring every commission is fair, accurate, and justified.
You think in formulas, document everything, and take pride in creating an environment where sales reps trust the numbers — because they're always right.
Skills Required
google sheets , Excel