Description
Sodastream
Ensuring PepsiCo Group accounting policies are consistently being applied in the areas assigned.
Calculation and recording of monthly reclassification of Freight on Direct-to-Consumer (DTC - online sales) business.
Monthly analysis of the Purchase Price Variance (PPV) account and identify any unusual transactions so that they can be cleared/adjusted before closing for month end.
Ownership of payroll related accruals and reconciliations e.g. PAYG, Payroll Tax, Super, etc. in coordination with HR Dept.
Ownership of Advertising & Marketing expenses and accruals and working closely with the Marketing Department.
Preparing the monthly Journal in Oracle for allocation of other departments costs to Cylinder Operations.
Assisting the Financial Reporting Manager in explanations of variations (Analytics) for areas of your responsibility in the monthly variance analysis file for submission to HQ.
Preparing Journals in Controller for HQ Relief for transactions not to be considered for reporting in the Contribution P&L.
Analysing and reporting the results of DTC business performance.
Preparing a monthly Management Report for senior management by analysing financial and operational results to better understand the Company performance. Using BI tools to deliver meaningful insights into business performance by identifying which products have the highest profit margin and which customers or products require price amendments to achieve the desired results.
Reporting of Department expenses on a monthly basis to all Department heads and analysis.
Complete ownership of accounting, financial reporting and compliance reporting for Sodastream (New Zealand) Ltd (a NZ registered entity with no operations).
Evaluating previous budgets and expenditures to develop and implement future budgets. Preparing the Annual Operating Plan (Budget) by working with the Department heads to build their annual budget and loading them in TM1.
Preparing the monthly Forecast P&L in coordination with Manager - Planning & BI for Sales information and other Department heads for Expenses.
Assist the Finance Manager in preparing slides for various Management presentations e.g. AOP, monthly PBR.
Working with the Financial Reporting Manager to ensure that internal controls are in operation and all relevant documentation is maintained for the areas of Inventory as prescribed by PepsiCo Global Control Standard (GCS).
Liaising with the Supply Chain Manager to review operations and recommending new productivity or cost saving initiatives. Reviewing processes and procedures to develop recommendations for improvements.
Inventory
Update HQ stock prices (transfer price - TP) in Oracle (annually and as and when required).
Update and create standard costs in the Bill of Materials (BOM) in Oracle based on approved BOM form.
Preparing BOM Forms in coordination with the requisitioner and getting the Form approved by Management (Finance Manager and Managing Director).
Run product returns report and collate information, then clear production returns (write-off's, transfers to FG or Rework) before end of month.
Enter physical count quantities of Stock in Oracle at time of physical counts (twice a year).
Identify physical count variances and coordinate with the Warehouse to investigate and resolve differences.
Run auto invoice and fix errors as and when required and especially at end of month.
Create new part numbers and costings from Oracle 12 (HQ Oracle) into Oracle 11.
Cost rollups and cost updates at end of month and whenever new parts are created.
Run and check standard cost report for BOM's monthly.
Transfer inventory via General Ledger transfers as and when required and at month end.
Issue and receipt cylinders inventory for New Zealand and Japan.
Reconcile and update NZ and Japan shipment reports at end of month.
Run and collate Syrup Expiry Report and calculate provision requirement for Syrups in Stock nearing expiry.
Run 'Inventory as of date' report from Oracle at end of month and collate. Enter data into monthly Management report.
Run receipts and containers report, credit order summary report, product return report via Web Discoverer monthly.
Run Soda transaction summary report for both AU2 and AUT sub-inventories and reconcile to Balance Sheet Account Reconciliation file at month end.
Run WIP A/C distribution report and reconcile to Balance Sheet Reconciliation file at month end.
Check transaction interface in Oracle is cleared at end of month.
Run and collate weekly retailer warranty report.
Create new sub-inventories and locators in Oracle as and when required.
Calculating and recording write-off of cylinders in AUT sub-inventory at month end.
Loan Cylinders reconciliation including depreciation calculation and posting the relevant Journals in Oracle including entering the details in TM1.
Investigate unidentified cylinders received into warehouse and after investigation receipt them in Oracle.
Scrap cylinders from SCRAP CYL sub-inventory (as identified by Retest Dept).
TM1 (BI tool)
Maintain Customers Rebate %age (Fin_Discount_Groups_Params cube) for Budget, Actual and Forecast versions.
Maintain Gas and Cylinder price (Fin_Initial_Price cube) for Budget and Actual versions.
Maintain multi-products packs information (Fin_Packages cube).
Maintain Cylinder quantities information and Agreement status by customer (Fin_Recytal cube). Input cylinder sell-out data from information obtained from Krunchbox.
Maintain customer Channel classification including No of Doors (Fin_Customers_Atributes cube) in consultation with the Sales Department.
Maintain Site amount (Fin_Price_Cost cube) for Budget and Actual versions.
Prepare the monthly DDTC P&L cube.
Prepare the monthly COC cube.
Ensuring BOM's are recorded as Package (Fin_Packages cube) in Item/SKU parameters in TM1 by informing the Data Catalog Engineer at HQ.
SodaPress AU and SodaPress NZ
Coordination with 3rd party accountants for recording of daily transactions and month end journals.
Month end closing and reporting to HQ of all relevant requirements, e.g. Key Account reconciliations, etc.
Coordinate with the external auditors and tax advisors for all legal and regulatory filings of both entities.
Any other requirements from HQ Finance for reporting including Budgets and loading them in TM1.
Assisting the Financial Reporting Manager and the Finance Manager with ad hoc requests from HQ.
Any other new responsibilities that may be asked by HQ or management requirements.
Requirements
Preferably be CPA/CA qualified
Strong attention to detail
Strong ability to multi-task
Highly organised
Excellent communication skills with ability to build relationships
Excellent problem solving skills. Pro-active in investigating to resolve issues
A strong sense of urgency to ensure all deadlines are met
Strong influencing and interpersonal skills
High level of commercial acumen
Ability to mentor, manage and develop team members
Flexibility to work late hours as and when required to meet deadlines or to resolve IT issues
Ability to meet strict deadlines
Applicant must have valid work rights to work in Australia.
The company will not be able to support any VISA sponsorship or relocation charges request.
#J-18808-Ljbffr
