Rebate Accounting Analyst

REBATE ACCOUNTING ANALYST (F1470809

NAS-CJM) Goodlettsville, Tennessee

Title:

Rebate Accounting Analyst

Location:

Goodlettsville TN

Start Date:

ASAP
Pay Rate: $28-33/hour
Type:
Contract to hire opportunity

• Advanced excel skills (writing formulas, pivot tables, vlookups, etc.)
• Excellent problem solving skills. Someone that enjoys puzzles will do well in this role.
• Completion of a four-year bachelor’s degree in accounting or business AND 3+ years of working experience in an accounting role
• Proficient technical skills with the ability to develop, write, and produce reports and databases

• Develops and performs all rebate accounting for accrued rebates, earned rebates, and prepaid rebates for assigned programs in compliance with GAAP and Company accounting policies and procedures, including SOX controls.
• In rebate program setup, determines rebate type and category for proper reporting.
• Determines sources of data and verifies integrity and appropriateness of data relative to the program and contract.
• Determines methods of rebate calculation, and calculates rebate accruals, processes payments/deductions, and updates applicable rebate spreadsheets and databases.
• Develops rapport and procedures and communicates status with all levels of management, in particular those with an interest in the analyst’s assigned program or department.
• Management includes those with budgetary responsibility for rebates.
• Must communicate with vendors as well.
• Reviews and understands contracts and agreements, existing and proposed, interprets proper accounting and explains to management how the accounting may affect current, expected or proposed rebate performance or forecast.
• Ensures programs are sufficiently documented and understood.
• Makes billing decisions, including whether to prepare a rebate bill or not, and for what amount, a partial bill, a full bill or prepaid amount.
• Ages rebates receivable and follows up with merchants and vendors to collect rebates.
• Retains authority to deduct in lieu of receiving a check if required.
• Recommends write-off of uncollectible rebates.
• Creates monthly period-end accrual uploads to the GL and RSL.
• Reconciles assigned rebates, and completes period close documentation.
• Develops analytical reports using report writer software and data sources such as PO receipts, POS, and payment information.
• Performs ad hoc analysis and makes recommendations to management regarding potential or future rebate programs.
• Reconciles vendor rebate-related issues by conducting research, locating back-up documentation, and clarifying information using various systems, databases, and reports.
• Analyzes rebate processes and procedures to ensure best practices are used.
• Recommends, designs, and develops enhancements to the rebate process.
• Supports Merchandising and Logistics planning, budgeting and forecasting with knowledge of rebate programs, recommendations, and anticipated performance and accounting.
• Ensures accurate and timely billing, tracking, and recording of vendor rebates for assigned programs.
• Analyze rebate processes to ensure best practices are utilized.
• Partners with Financial Planning, Merchandising, Advertising, and outside vendors to properly record and collect vendor rebate funds.
• Determines the best strategy, approach or process to account for each rebate program .
• Serves as a liaison between vendors, buyers, and other internal departments to coordinate rebates and expedite the resolution of any issues.