Junior Sales Finance Partner at GlaxoSmithKline (GSK)

Supports the Sales Finance Business Partner in managing the P&L for the Southern Africa Consumer business and provides financial business partnering support to the Southern Africa Sales team.

Scope And Responsibilities
Controlling and monitoring of sales and gross to net

• Manage gross to net ratio
• Review and analyse Cognos to ensure gross to net in line with budget
• Track sales to forecast numbers
• Ensure accurate monthly provision journals are calculated and posted for expected customer claims and discounts
• Track discounting and returns to ensure in line with customer plans and financial budget
• Report and comment on month end sales
• Discussions on month end sales with sales team
• Manage monthly P&L against budget and forecasts
• Monitor on invoice discounting by providing monthly info to sales, facilitating monthly meetings to discuss and ensuring feedback is received and challenged as necessary
• Monitor monthly returns to ensure processes are followed correctly and keep returns to a minimum
• Monitor sales claims for deviances from policy and trends
• Prepare monthly gross to net reconciliation reports

Monthly

• Review month end results along with Sales Business Partner and provide insight into drivers of brand sales, gross to net, opex etc.to explain changes and trends in results
• Assist in explaining and providing commentary on deviations from budgets, prior year and forecasts
• Develop and continuously improve month end reporting formats
• Prepare management accounting information
• Stock in trade – request details from Commercial Systems & analytics team on the numbers, include in man pack and MPR with commentary
• W&D (local + export) – prepare accrual journals (local based on the latest Imperial statement) and export (based on calculation that Finance BP will give)
• Cost centre reports + list of cost centre owners – prepare cost centre reports monthly and distribute to cost centre owners and resolve any queries
• OE expenses – prepare the summary for any JV expenses, send for upload in BISON and to MEA
• Azhar template – complete the template with net sales for Actual periods and latest forecast for the remainder of the year
• Presentation slides: Stock, Opex, HC, BBBEE, CAPA – include a waterfall graph for Opex with commentary, include a slide showing movements in HC, request information on BBBEE and CAPA
• Cross charges – calculate the cross charges for ICSS for Pharma and send the journal for processing
• HR issues + send to HR – reporting on headcount so if there are any issues in mapping of headcount on Qlikview, request HR to make the changes
• Rebate journals + roll forward files – prepare the accrual journals for G2N
• On-invoice discounting report – prepare the report and distribute to sales team and resolve any queries
• Recons for rebates – prepare the recons for all the rebate accounts
• All Opex journals – monthly accrual journals
• MPR – this includes slides for stock and headcount
• Returns journals – the monthly CRM journals on WD1
• Facility cross charge model – prepare the actual costs for the cross charge to other markets

Annually

• Assist with the budgeting and forecasting process
• Assisting with the preparation and controlling of Opex budgets for the Consumer division.
• Ensuring reasonableness of sales budgets
• Assistance in providing information for the Commercial and Finance decks for budget and Forecast presentations
• Preparation and control of the annual calenderisation process
• Preparation, control and submission of monthly forecast
• Add value by challenging and understanding monthly forecasts during Pre-DRM Meetings.
• Preparation of the monthly DRM cash up based on the volumes shared by Supply Chain Demand Planning.
• Opex 2021 budget file – prepare the budget file towards the end of the year and load into the system
• CMF + Update 2 + Plan – prepare overhead workings and link it into the upload tool

Daily

• Extract reports from JDE

Ad-hoc

• Will require access to all systems (JDE, Cognos, BISON, SAP FC, Qlikview, thinkcell)
• Be able to manage Ad hoc requests

General business partnering

• Being proactive in providing daily support and assistance to the commercial team
• Deliver focused analytics to ensure effective decisions across the Consumer business
• Evaluate promotions and discounting including ROI analysis and monitoring
• Monitor performance of brands, consumption data
• Review gross to net by customer monthly and look for opportunities to add value or better manage the process
• Monitor levels of stock in trade
• Prepare and evaluate pricing for commercial team
• Attend demand forecasting meeting with sales and marketing as well as other marketing team meetings
• Provide regular finance training to the sales team
• Support commercial projects in conjunction with the sales and marketing teams
• Develop an in-depth knowledge of the industry and competitors
• Ad-hoc support and preparation of information to support the Sales Business Partner, Senior Finance Business Partner and Head of Finance.
• Ad-hoc support and preparation of information to support the Commercial Leadership Team
• Running reports and extracting information from JDE (general ledger), Cognos, BISON
• Provide information and assist with the internal and external audits
• Support the head of finance with working capital management
• Input and involvement in new systems development and training of systems where necessary
• Ensure there are up to date SOPs/knowledge documents to support all systems and processes
• Review and Release payments on Citibank