JOB RESPONSIBILITIES:
Forecast and Plan Planning
- Works closely with Operation Committee (OpCom) determining robust assumptions on sales volume, pricing, investments and working capital to drive Plan and Forecast. Ensures Plan and
- Forecast accurately reflects operational cost assumptions and historical trends.
- Provides variance analysis on current Plan/Forecast versus previous Plan/Forecast. Assists
- Financial Planning & Analysis Manager in all matters relating to Plan and Forecast submission and presentation.
- Develops and maintains all worksheets to collect and analyze inputs to Plan and Forecast process. Ensures adequate planning for data collection to meet Plan and Forecast deadlines.
- Ensures all templates continuously maintained for historical actual data.
- Upload Forecast and Plan into Fusion (including volume for gross sales and free goods)
- Verifies and ensures Plan and Forecast are accurately uploaded into Fusion including Profit and Loss statement, Headcount, Net Working Capital, Capex
- Participates and values forecast for Integrated Reconciliation Meeting, part of Integrated
- Business Planning (IBP) on monthly basis
Business Partnering
- Is active business partner of Commercial functions (including but not limited to Trade, Ecommerce, Medical and Marketing) by taking finance-expert role for Business Unit, providing financial data, knowledge and analysis with prepared financial information as required to support fact-based brand analysis.
- Provides monthly reports to management, Regional Office, Corporate Head Quarter i.e. Price
- Volume – Exchange rate, Capex, Productivity… in the timely and accurate manner.
- Prepares and submits ad-hoc reports, analysis and presentations to managers, Regional Office, Head Office.
- Supports Marketing to build financial case for New Product Development (NPD)
- Checks and monitors budget of Marketing Costs for Marketing to submit MET in timely manner.
- Supports Commercial functions with Marketing Costs – Brand Equity Investment (BEI) and Non-BEI spending – analysis and management on monthly basis.
- Supports Commercial functions with Trade Spends analysis and management on monthly basis.
Accounting and Reporting
Handle Month-end closing works by:
- Work with Thai Finance team to raise manual journals in JET. Demonstrated understanding of the requirements for each following journal, i.e.:
- Journals impacted to sales: sales deferral, Trade Spend vs Trade Fund accrual, labelling and obsolete at DB, Distributor Top-Up Provision…
- Freight in
- Other journals as may be required
- Reconcile Management Transformation by Sales
- Coordinate with Supply Chain, Accounting team to make sure revenue is properly recognized and the deadline for monthly sales reporting WD+1 is met
- Work closely with Thailand Finance team to review monthly expenses (Cost of Goods Sold (COGS), Marketing Costs and Commercial Fixed Costs (CFC), Neutral) to make sure expenses are recorded in timely and accurate manner
- Perform Balance Sheet reconciliation
- Prepare Weekly Sales to Regional Office
Monthly reporting:
- Review Profits and Loss Statement (PNL); Analyze and provide commentary on the variance higher than threshold
- Provide monthly expense report for Marketing costs and CFC to Department Heads and
- Business Unit Leads
- Submit to Regional Office
- Pre-Flash for monthly Net Revenue (NR) estimate on last week of the month
- Flash for monthly NR and Country Operating Profit (COP) on WD+2
- Estimate In-market-sales (IMS) by channel for E-commerce (EC) and Convenience Store (CVS)
- IMS by Brand on monthly basis
- Distributor Stock (including Gross Sales, Gross IMS, Distribution Margin, Trade Spend, NR, Distributor Stock)
- Gross Margin Variance Analysis (GMVA)
- Upload and submit EC PNL in Fusion
- Submit monthly Key Performance Indicators (KPI), Working Capital for OpCom review on time and proactively communicate key issues/highlights
- Assist Finance Director and Financial Planning & Analysis Manager in finance preparations
- Submit ad-hoc reports and analysis to managers, Regional Office, Corporate Head Office
- Work with requestors in Commercial departments to perform Return on Investment (ROI) analysis for the given Marketing project
- Master data management in JDE:
- Work with Thailand Customer Service team on Pricing update
- Working with Thailand to request separate General Ledger account for Vietnam Health management where needed
Other Reporting and Analysis
- Masters on JDE for Accounting module. Acts as country Subject Master Expert (SME) for the application.
- Participates in ad-hoc regional and local projects to implement new software or improve productivity and compliance
- Participates in ad-hoc analysis resulting in continuous improvement of overall operations
- Provides finance training to non-finance colleagues.
JOB REQUIREMENT:
- Bachelor’s degree – Economics (Accounting, Finance)
- Experience in financial planning, analysis and accounting
- Experience in Financial/Corporate reporting and the associated monthly close processes
- Experience working with risk assessment and internal control objectives
- At least 2-year experience of working at an international company
- Masters general accounting and financial theories and concepts. Ability to properly apply them in business situations.
- Demonstrates understanding of internal control environment requirements
- Understands financial principles and standards and how to leverage this knowledge in making sound decisions
- Processes knowledge of key computer software packages (i.e. SAP, JDE, Fusion, BPC) and is proficient in pulling data from these packages for use in relevant analysis
- Masters of Microsoft Excel (expert level) and Power Point
- Demonstrates ability to maintain absolute confidentiality when being privy to highly sensitive information such as, but not limited to, salary and benefit data and information about decisions under consideration by management
- Demonstrates strong prioritization skill to manage multi tasks and projects simultaneously; Ensures accuracy and timelines to meet business needs; Focuses on high priority opportunities.
- Establishes strong working relationships with key internal stakeholders and cross-market colleagues to share knowledge and best practice.
- Demonstrates competence in using a variety of applicable software packages to perform business tasks.
- Able to educate non-finance colleagues on finance principles and concepts.
- Proven good writing, speaking and editing skills, in local language and English
- Able to deliver value added business results through superior execution
- Able to work effectively across functions in a matrix organization, to coordinate and work through a network of agencies/consultants
- Is open and responsive to feedback to improve performance of self and team
