Lilly Associate Consultant in Greenfield, Indiana
This position will be a key contributor to the Elanco Corporate Accounting and Reporting (eCAR) team and will assist with and be responsible for many aspects within the month-end closing process and the consolidation of financial results for Elanco; Corporate consolidation activities including preparation of top-level journal vouchers, consolidation roll-ups, carve-out accounting, intercompany accounting and other special transaction accounting. This position requires interaction with other eCAR team members, Lilly CFR, Financial Planning and Analysis, GBS Accounting, Global Treasury, Corporate Tax, Corporate Manufacturing, and external auditors.
Responsibilities include: Royalty accounting, including journal voucher preparation and reporting. Assist in preparing the accounting and executing the corporate consolidations process and external management reporting for Elanco consolidated results; Corporate consolidation activities including consolidation roll ups; Preparation of top-level entries and carve-out accounting postings for Elanco; Troubleshooting accounting issues with affiliates; Performing audit and quality checks during the monthly close; Assistance with Intercompany accounting, including Tax restructurings; other monthly and quarterly close-related analyses such as balance sheet and OID analysis; Quarterly financial reporting activities including assistance in the preparation of SEC quarterly external report filings (10Q/10K), investor earnings release and presentations, and certain year-end reporting schedules. Additional special project work, including changes in accounting, consolidations activities, carve-out accounting, intercompany processes associated with the separate Initial public offering (IPO) of Elanco as well as preparation of the annual and quarterly SEC reporting for Elanco.
Key Objectives / Deliverables:
Assist in preparing the accounting and executing the Corporate Consolidation process for Elanco
Preparation of top-level journal vouchers and carve-out accounting postings
Assist with preparation of intercompany accounting entries, including Tax restructurings
Preparation of monthly-close SOx deliverables, including audit and quality checks (e.g., line reports, etc.)
Preparation of monthly and quarterly analyses such as the Balance Sheet analysis and OID
Assist in publishing Internal Consolidated Financial Statements (COR)
Provide accurate and timely accounting guidance to affiliates and business partners
Compilation of select financial statements and supporting footnotes and schedules for the quarterly 10-Q and annual 10-K SEC filings for Elanco
Special project work including changes in accounting, consolidations activities, carve-out accounting, intercompany processes associated with the separate Initial public offering (IPO) of Elanco as well as preparation of the annual and quarterly SEC reporting for Elanco.
Corporate Closing Coordination: Ensure closing and consolidation vouchers are prepared and processed accurately and in a timely manner. Monitor Non-SAP affiliate trial balance submissions. Work with other CFR team members and learn all aspects of the Corporate financial consolidation process sufficient to share responsibilities; Review of Corporate audit and quality checks during the monthly close; Troubleshoot issues with affiliate and GBS accounting personnel, FP&A, BPKC and country/regional analysts. Assist with management reporting including the preparation of the Balance Sheet analysis and Corporate OID schedule. Pursue opportunities to streamline processes within the closing process. Provide accounting operational and technical guidance to affiliates and other corporate areas (Tax, Treasury, Manufacturing) in the form of training, policies and adequate instructions to ensure that we maintain a quality control environment, make efficient use of company resources and assure compliance with Elanco Global Accounting Policies and Practices. Understand link between external reporting and management reporting to ensure that we account for transactions properly in SAP and provide appropriate guidance to affiliates.
Top-level journal vouchers, Carve-out and Intercompany postings: Assist in development of carve-out accounting process and preparation of carve-out postings for Elanco; Prepare monthly Top level accounting entries and account reconciliations and monitor; Assist with the preparation of intercompany accounting instructions for unique and special transactions.
External Financial Reports: Prepare Consolidated Balance Sheet analysis at quarter-end and OID schedule at month-end. Assist in preparation and review of all external reporting for the Press Release, Audit Committee, Investor Relations and the filing of the SEC 10Q and 10K. Look for opportunities to streamline reporting within SAP and other systems and processes.
Elanco IPO Project: Special project work including changes in accounting, consolidations activities, carve-out accounting, intercompany processes associated with the separate Initial public offering (IPO) of Elanco as well as preparation of the annual and quarterly SEC reporting for Elanco.
Other Special Projects: maintain year-end reporting schedules for footnotes (YECI/SMR); assist with government reporting; perform SOX control reviews for JV’s and Account reconciliations; other special projects as identified throughout the year.
Working knowledge and experience with SAP GA module and Business Objects
Strong self-management skills and high learning agility
Proven ability to produce high quality work
Excellent interpersonal skills with customer focus
Ability to perform well under pressure
Solid problem solving skills and ability to be innovative and creative
Strong communication and teamwork skills
Extensive knowledge of MS Excel, Word and PowerPoint
Ability to multi-task and prioritize responsibilities
Attention to detail
Flexibility during peak closing periods. Overtime is required during month-end closing, especially at year-end. Minimal travel.
Elanco is an EEO/Affirmative Action Employer and does not discriminate on the basis of age, race, color, religion, gender, sexual orientation, gender identity, gender expression, national origin, protected veteran status, disability or any other legally protected status
3+ years’ experience in Finance function or public accounting practice, with in-depth knowledge of US GAAP technical accounting
Bachelor's Degree in Accounting or Finance in line with solid accounting skills
CPA ,CPA Candidate or Chartered Accountant
Qualified candidates must be legally authorized to be employed in the United States. Elanco does not anticipate providing sponsorship for employment visa status (e.g., H-1B or TN status) for this employment position
Elanco is a global animal health company that develops products and knowledge services to prevent and treat disease in food animals and pets in more than 90 countries. With a 64-year heritage, we rigorously innovate to improve the health of animals and benefit our customers, while fostering an inclusive, cause-driven culture for more than 5,800 employees. At Elanco, we’re driven by our vision of food and companionship enriching life – all to advance the health of animals, people and the planet. Learn more at www.elanco.com .
State / Province: