Impress employers and recruiters.
Choose from hundreds of resume examples.

Target Resume Now

About the Role

The Commissions Analyst will calculate, track, and report sales commissions using Excel-based models and Salesforce CRM data. This role requires exceptional attention to detail, strong organizational skills, and the ability to consistently meet deadlines in a fast-paced environment. The ideal candidate is a collaborative team player who can build effective working relationships across all departments and levels.

Responsibilities

Pull and validate sales, bookings, and opportunity data directly from Salesforce CRM for use in commission calculations
Build and maintain complex Excel commission models to calculate monthly/quarterly payouts, including tiers, accelerators, and draws
Reconcile Salesforce CRM opportunity/closed-won data against signed contracts and finance bookings to confirm commissionable revenue
Maintain a master commission tracker in Excel, keeping rep quotas, territories, and deal splits current and accurate
Investigate and resolve commission disputes and data discrepancies quickly and accurately, escalating and communicating status proactively
Prepare and deliver individual commission statements and leadership reports on a strict, recurring schedule
Partner closely with Sales, Sales Ops, Finance, Payroll and HR to maintain clean data and resolve issues collaboratively
Support commission plan modeling and "what-if" scenario analysis in Excel for new or revised comp plans
Maintain organized, audit-ready documentation and calculation trails for SOX/compliance purposes
Manage multiple concurrent deadlines during month-end/quarter-end close without sacrificing accuracy
Identify opportunities to streamline and automate manual Excel processes

Requirements

Bachelor's degree in Finance, Accounting, Business, or related field
Over 8 years of experience in sales compensation, finance, or analytical role
Demonstrated track record of high accuracy and attention to detail, particularly under deadline pressure
Strong organizational skills with the ability to manage multiple priorities and deliver consistently on time
Proven ability to work effectively and build trust across departments and all levels of an organization
Advanced Excel skills: pivot tables, XLOOKUP/VLOOKUP, SUMIFS/COUNTIFS, IF/nested IF, data validation
Hands-on experience running reports and dashboards in Salesforce CRM
Excellent written and verbal communication skills, with the ability to explain calculations clearly to non-finance stakeholders
Discretion and professionalism handling confidential compensation data
SQL basics for pulling data from a data warehouse
Prior experience in HCM/SaaS/B2B sales organizations
Exposure to commission plan design or sales compensation modeling
Salesforce Administrator certification or hands-on config experience a plus

Skills

Excel
Salesforce CRM
VLOOKUP/XLOOKUP
SUMIFS
pivot tables
nested IF statements
Power Query
macros
SQL
Salesforce Administrator certification

Location

Work Type

Full-time

Experience Level

Over 8 years of experience

Education Level

Bachelor's degree

Benefits

Medical, Dental, Vision, HSA, FSA - All effective on day 1!
Company paid Basic Life Insurance, A+D, Long-Term Disability, and Short-Term Disability
401K Program with 3% safe harbor contribution
Employee Stock Purchase Program
Fitness Reimbursement Program
Self-Managed PTO

About the Company

Over 600 employees strong, Asure sees Human Capital Management (HCM) through the lens of entrepreneurs and executives with an owner’s mentality.
We help businesses develop their “Human Capital” to get to the next level, stay compliant, and allocate their time, money and technology toward growth.
Our HCM platform empowers more than 100,000 clients to build great teams and better manage their people while staying compliant in an ever-changing HR legislative landscape.
Asure’s HCM offering includes Payroll & Tax, HR, and Time & Attendance software and HR Services ranging from online compliance tools to a fully outsourced HR department.
Our Mission: To provide Human Capital Management (HCM) software and services that help companies grow, while nurturing a culture of growth around us.
Helping customers grow by getting the most from their human capital.
Helping our employees grow personally and professionally.
Growing relationships in our communities that inspire goodness.
Grow shareholder value
Our Vision: Be the most trusted Human Capital Management resource to entrepreneurs everywhere.
Our Values: Embrace Change, Lead with Integrity, Own the Outcome, Deliver Awesome, Be a Good Human

Equal Opportunity

We are an equal opportunity employer.
All candidates must be legally authorized to work in the US, as we are unable to sponsor or transfer Visas at this time.