Commissions Analyst I

American Business Forms•Glenwood, MN

About The Position

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.

Requirements

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.
Working knowledge of accounting principles and practices
Knowledge of technical accounting skills.
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
Ability to calculate figures and amounts such as discounts, interest, commissions, proportions, and percentages.
Proficient in performing detailed numerical computations.
Basic knowledge of Excel and the ability to set up worksheets for analysis and reporting.
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.

Nice To Haves

Bachelor’s degree in business, accounting, and/or finance with three or more years of related experience, training or an equivalent combination of education and experience.

Responsibilities

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.