OverviewThe Franchise Finance - Funding role is responsible for managing the end-to-end funding process. Key responsibilities include pulling bottler volumes, calculating and validating funding, analysing trends period-over-period, forecasting, and providing actionable insights. The role also involves preparing final funding amounts for bottler funding's and tracking disbursements. This position works closely with cross-functional teams to ensure funding is accurate, timely, and aligned with compliance standards, while supporting key business decisions through financial analysis.
Responsibilities- Prepare Franchise Fundings: Prepare periodic, quarterly, and annual franchise fundings as per instructions, ensuring accuracy and completeness.
- Analyse Funding Data: Perform detailed funding analysis, including Year-over-Year (YoY), Period-over-Period (PoP), and Quarter-over-Quarter (QoQ) comparisons.
- Identify Variances: Identify trends, increases, or decreases in funding and volume, and provide insights on key drivers.
- Work with Stakeholders: Collaborate with internal teams, division teams, and franchise managers to understand major impacts on funding changes.
- Explain Variances: Provide clear explanations for significant increases or decreases in funding.
- Review Manual Submissions: Check manual funding submissions and ensure they are reviewed within the given timeline (TAT).
- Share Submission Updates: Prepare bi-weekly updates summarizing the status of all manual funding submissions.
- Manage Aquafina Billing: Manage billing activities related to Aquafina, ensuring billing activity completed every month within the given timeline.
- Ensure Billing Accuracy: Monitor billing processes to ensure correctness and alignment with agreements.
- Prepare Funding Forecasts: Create forecasts for franchise funding projects based on actual payments from each program.
- Support Decision-Making: Use data-driven insights to help with strategic decisions and resource planning.
- Perform Reconciliations: Regularly reconcile actual payments with recorded project financials.
- Fix Discrepancies: Identify and resolve any mismatches or errors in financial data.
- Manage Generic Email Box: Monitor and manage the generic email inbox to ensure timely responses and resolution of queries.
- Support Trade Spend Team: Collaborate with the Trade Spend (IBM) team to process SAP credit memos efficiently.
- Work with Division Planners: Support Division Planners in (IBP) reconciliation activities.
- Handle Ad-Hoc Queries: Address and resolve ad-hoc queries from stakeholders in a timely manner.
- Prepare Customized Reports: Create and deliver customized reports based on specific requirements and business needs.
- Create an inclusive and collaborative environment
- Share best practices from other ICC teams to elevate the service levels of the Finance team in ICC
- Support where required summaries for the business on key business metrics
- Drive Process improvements for simplification and standardization of reports.
Qualifications- 5-6 years of experience in Finance FP&A/Accounting
- Strong analytical and financial modelling skills
- Advanced Excel and financial systems (SAP, Power BI preferred)
- Attention to detail and accuracy in numbers
- Good understanding of volume-based funding mechanisms
- Ability to work with large data sets and draw meaningful insights
- Effective communication and collaboration with cross-functional teams
- Time management and ability to handle multiple priorities
- Problem-solving mindset and proactive approach
