REBATE ACCOUNTING ANALYST

REBATE ACCOUNTING ANALYST (F1470809NAS-CJM) Goodlettsville, Tennessee Title: Rebate Accounting Analyst Location: Goodlettsville TN Start Date: ASAP Pay Rate: $28-33/hour Type: Contract to hire opportunity

REQUIREMENTS: REBATE ACCOUNTING ANALYST

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

RESPONSIBILITIES: REBATE ACCOUNTING ANALYST

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. #J-18808-Ljbffr Beacon Hill