Financial Manager - Entyce Beverages
National Brands Limited (Including Real Beverage Company)
Johannesburg, South Africa
My responsibilities for NBL were to be the accounting technical support to the category commercial managers (tea, coffee, creamer), assist the category commercial managers with the daily management and review of their categories and month end closing. This included capital project evaluations using EVA and NPV methodologies, new product feasibility scenarios and month end closing journals. I was tasked to manage daily service delivery matters and the relationship with Finance Shared Services (FSS) for Entyce and RBC. For RBC, my responsibilities included all aspects of financial management and reporting to the internal management team as well as the holding company (AVI). I was heavily involved in the audit process and prepared the accounting pack for inclusion in the consolidated annual financial statements. I managed RBC’s daily cash flow prepared weekly 8-week cash flow forecasts. I reviewed accounts payable reconciliations prior to payments being released.One of the highlights while working with RBC was that I recovered a R1.4m VAT over payment from the revenue authorities.My responsibilities shifted towards the reporting aspects of the business, where I was responsible for the preparation and submission of deliverables for Entyce and RBC. I was able to use my advanced Excel skills to improve many aspects of the reporting framework. I created opportunities to deliver meaningful and concise information to the management team efficiently and effectively. I started using the Power Pivot add-in in Excel to assist with preparation of reporting deliverables. I created my own BI data warehouse from SAP, Cognos and other sources. This enabled me to extract the relevant data for any report quickly and easily, cross referenced to multiple sources. I was considered to be the go-to guy for any Excel related matters.The Entyce and Snackworks business units where restructured, where I played a pivotal role in determining the most appropriate cost centre hierarchy.