Commissions Analyst I

Description

This role oversees commissions administrations financial reporting rebate and profit-split processing BPP (Business Protection Plan) Claims and commission split/rebate maintenance for sales associates and third parties. It ensures financial accuracy timely payments effective internal controls and continuous process improvement.

Essential Duties and Responsibilities include the following: Other duties may be assigned.

• Manage prepare and process gross commission and rebate totals monthly
• Manage and maintain all payroll split agreements
• Provide training and guidance for new sales associates recently onboarded including (but not limited to) commission and OES report education
• Manage implement and monitor all sales associate and third-party ledger balances and established repayment plans
• Prepare and process third party commission payments monthly quarterly and as needed.
• Verify and post journal entries related to commission payroll and other scenarios
• Oversee the single split preferred vendor (SSPV) related set-up and calculations. Respond to SSPV inquiries and analysis for Associates or home office personnel.
• Provide Ad-hoc reporting as requested by sales associates or home office personnel.
• Provide support to sales associates and home office personnel in response to inquiries related to commissions SSPV sales associate expense ledgers payroll or other commission related questions.
• Prepare & maintain and enhance ESOP/Fiscal year end reporting necessary to aid in the valuation and allocation of shares and gross sales and profitability of sales associates.
• Work in conjunction with Financial Analyst II to maintain update and create Qlikview or other analytical reports upon request
• Complete tasks needed to identify and correct any variances from the commission subsystem to the ERP system.
• Test and validate program and system enhancements that impact commission calculations and/or reporting accuracy.
• Assist in the review of profit and/or commissions with Sales Associates and home office personnel as needed.
• Assist in the review of commission related general ledger account balances as needed
• Regularly review gross profit model and commission splits of sales associates. Analyze transactions for accuracy and report questionable transactions and/or agreements to senior leadership.
• Provide additional analysis of gross profit commission splits and/or other reporting as requested by sales associate or senior leadership.
• Other duties as assigned.

Supervisory Responsibilities

This job has no supervisory responsibilities.

To perform this job successfully an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge skill and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Education and/or Experience

Required: Associate degree in accounting finance and/or business with a minimum of three years of related experience training; or an equivalent combination of education and experience. Preferred: Bachelors degree in business accounting and/or finance with three or more years of related experience training or an equivalent combination of education and experience. This position requires a working knowledge of accounting principles and practices and a knowledge of technical accounting skills.

Core Competencies

Attention to detail and accuracy; ability to prioritize plan and organize; ability to schedule and monitor problem analysis and problem-solving skills; communication; initiative; teamwork; confidentiality. Competency in Microsoft applications; word outlook with a higher level working knowledge

Language Skills

Ability to read analyze and interpret general business periodicals professional journals technical procedures or governmental regulations. Ability to write reports business correspondence and procedure manuals. Ability to effectively present information and respond to questions from groups of managers sales associates and employees.

Mathematical Skills

Ability to calculate figures and amounts such as discounts interest commissions proportions and percentages. Must be proficient in performing detailed numerical computations. Basic knowledge of Excel and the ability to set up worksheets for analysis and reporting.

Reasoning Ability

Ability to solve practical problems and deal with a variety of concrete variables in situations where only limited standardization exists. Ability to interpret a variety of instructions furnished in written oral diagram or schedule form.

Physical Demands The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

While performing the duties of this job the employee is regularly required to sit. The employee is occasionally required to stand and/or walk. The employee must occasionally lift and/or move up to 25 pounds. Specific vision abilities required by this job include close vision.

Work Environment The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

The noise level in the work environment is usually quiet.

AA/EEO/Vet/Military

Required Experience:

Senior IC