Job Description:
DUTIES AND RESPONSIBILITIES
Commission Plan Administration
- Administer plans: Work with leadership to manage, validate and administer sales commission plans.
- Maintain plan records: Maintain commission plan documents and participant records, including setup and updates for new hires, terminations, transfers and plan changes.
- Support plan changes: Support the annual sales compensation planning cycle and mid-period plan changes by modeling and testing calculation logic and communicating the impact to stakeholders.
- Improve the process: Continuously improve the sales compensation management process, controls and strategy.
Commission Calculation and Payment
- Maintain data: Analyze and maintain records of sales and commission data from multiple sources.
- Calculate commissions: Calculate commission payments from actual sales and operating results using Excel formulas.
- Process adjustments: Calculate and process adjustments and special payments in accordance with plan documents, including accelerators, clawbacks and chargebacks, draws, SPIFFs and true-ups, as applicable.
- Communicate results: Prepare and distribute commission statements and communicate plan terms to sales teams through plan and quota letters, guidance on plan structures and reports.
- Resolve questions: Work closely with team leads, sales management and other stakeholders to answer commission questions and resolve disputes.
Reconciliation, Close, and Controls
- Reconcile records: Reconcile commission records to internal sales and accounting data and resolve discrepancies.
- Support the close: Support the monthly close by managing commission accruals, journal entries, account reconciliations and flux reviews.
- Maintain the audit trail: Maintain audit trails and supporting documentation for commission calculations, adjustments and approvals; perform routine reviews of calculations, sales crediting and inputs; and support internal and external audit requests.
- Ensure compliance: Ensure all financial reporting and transactions maintain compliance with Company and regulatory financial policies, standards, and controls.
Financial Analysis, Reporting, and Forecasting
- Analyze and advise: Conduct financial analysis to advise and support decision-making and achieve business objectives.
- Build models: Develop and maintain financial modeling and analytical tools to measure the impact of various economic scenarios, risks, and business changes to forecast commission expense and company performance.
- Track variances: Track variances between financial projections and actual results to identify and troubleshoot differences and recommend adjustments or improvements.
- Report results: Prepare and analyze commission and other financial reports, including variance analysis, trend analysis and KPIs.
- Support budget and forecast: Assist with the annual budget and rolling forecasts and monitor actual results against budget and forecast.
- Support ad hoc work: Assist with ad hoc projects and reporting as needed.
- All other duties assigned
QUALIFICATIONS
Education
- Bachelor’s degree in Accounting, Finance or a related field.
- CPA preferred, not required
Experience
- 5+ years of accounting, finance or FP&A experience
- Public accounting or commission/compensation experience preferred
Skills & Competencies
- Advanced Microsoft Excel skills
- Strong analytical skills, with attention to detail and accuracy in data entry and calculations
- Working knowledge of accounting principles and the month-end close process, including accruals, journal entries and account reconciliations
- Working knowledge of internal controls, with the ability to maintain audit-ready documentation
- Financial modeling and variance analysis skills, including support for budgeting and forecasting
- Working knowledge of NetSuite or a comparable ERP (Oracle experience a plus); Salesforce familiarity is a plus.
- Ability to work as a team player and promote a cooperative work atmosphere
- Clear written and verbal communication with diverse groups, including Sales and senior management.
- Ability to create and present reports, as well as correspondence regularly
- Efficient in solving problems, and working with diverse variables
PHYSICAL DEMANDS AND WORK ENVIRONMENT
- Typical office environment
Base Pay Range:
$105,000-110,000/yr
This range represents the low and high end of the anticipated base salary range for this position. The base salary will depend on a number of factors such as: qualifications, experience level, and skillset.
Voluntary full-time employment benefits include medical, dental, and vision; life, AD&D, critical illness, and hospital insurance; short and long-term disability; identity/legal protection; as well as access to FSA and HSA accounts. Full and part-time employees are eligible to contribute to traditional and/or Roth 401(k) plans. Our Employee Assistance Program (EAP) offers counseling for a multitude of topics including (but not limited to) mental health, finances, adult care, disability, and grief.