Description
Reporting to the Finance Manager, the Senior Financial Accountant will be responsible for analysing key financial information to provide feedback that will increase the Company's efficiency and profitability by assisting with the formulation of both the medium and long-term financial plan.
In addition, assist in month end closing and reporting to HQ
Responsibilities and Duties:
Ensuring PepsiCo Group accounting policies are consistently being applied in all relevant areas.
Analyse the Purchase Price Variance (PPV) account monthly and identify any unusual transactions so that they can be cleared/adjusted before closing for month end.
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 (TM1 is our Corporate financial reporting tool).
Calculation of provision requirement for Syrups in Stock nearing expiry.
Analysing the Scrap expense account monthly to identify any unusual or large scrap items and ensuring approval is obtained from the Group Controller and Group CFO before scrapping items above US$10,000.
Tallying Stock figure of GL with the Stock figure in TM1.
Calculate and record Warranty provision on a periodic basis.
Calculation and recording of monthly reclassification of Freight on Direct business.
Writing explanations of variations (Analytics) for areas of responsibility in the monthly Group Reporting Package for submission to HQ.
Coordinate and attend the annual physical count of Stock in the warehouses.
Work with the Inventory & Credit Claims Officer to analyse physical count differences and resolving those differences with the Operations/Warehouse teams.
Periodically organise a physical count of fixed assets to ensure all assets are identified and accurate per the asset register.
Working with the Finance Manager to ensure that internal controls are in operation and all relevant documentation is maintained for the areas of Inventory as prescribed by the PepsiCo Global Control Standard (GCS).
Preparing Journals in Controller for HQ Relief for transactions not to be considered for reporting in the Contribution P&L. Analysing the impact of Direct-to-Consumer performance for the business.
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.
TM1 (BI tool)
Maintain Customers Rebate %age (Fin_Discount_Groups_Params cube) for Budget, Flash and Forecast versions.
Maintain Gas and Cylinder price (Fin_Initial_Price cube) for Budget, Flash and Actual versions.
Maintain multi-products packs information (Fin_Packages cube) for Flash and Actual versions.
Maintain Loan Cylinders information for Quantity, etc.
(Fin_Loan_Cylinders 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 Director.
Maintain Site amount (Fin_Price_Cost cube) for Budget, Flash and Actual versions.
Download sell-out data from Krunchbox for analysis and senior management reporting.
Preparing BOM Forms in coordination with Manager - Planning & BI and getting the Form approved by Management (Operations Director, Finance Manager and Managing Director).
Ensuring BOM's are recorded as Package in Item/SKU parameters in TM1 by informing the Data Catalog Engineer at HQ.
Monthly review of the BOM's spreadsheet maintained by the Inventory & Credit Claims Officer and ensuring any costing changes are updated in the BOM's.
Ensuring old and unused BOM are kept inactive in Oracle.
Coordinating and providing information to other Depts involved in calculation of Gross Margin on sale of new products.
Liaising with the Operations Director to review operations and recommending new productivity or cost saving initiatives.
Reviewing processes and procedures to develop recommendations for improvement efforts.
Providing monthly expenses details for all Departments and commentary on expenses.
Reviewing the Operations Dept's calculations of monthly Cylinder Refill cost and Retest cost to ensure its adequacy and reliability.
Evaluating previous budgets and expenditures to develop and implement future budgets.
Preparing the Annual Budget by working with the Department heads to build their annual budgets and forecasts and loading them in TM1.
Preparing the monthly Forecast P&L in coordination with Manager - Planning & BI (for Sales) and other Department heads for Expenses.
Assist with the preparation and filing of the Fringe Benefits Tax (FBT) Return.
Mentor and manage Finance team members (Inventory and Credit Claims Officer and Inventory and Credit Claims Assistant).
Assisting the Finance Manager with ad hoc requests from HQ.
Any other new responsibilities that may be asked by HQ or management requirements.
Requirements
Knowledge of general accounting principles and procedures.
Knowledge of US GAAP is an advantage Significant analytical skillset, including the utilisation of BI and reporting tools Previous experience in using major ERP's.
Oracle experience highly desired Excellent Microsoft Office (Excel, Word, Outlook etc.)
skills including writing macros in Excel Proficient in data entry and management 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