SodaStream Acctg Ops Asst Accountant

2 weeks ago


Melbourne, Victoria, Australia PepsiCo Full time $60,000 - $80,000 per year
Overview

Reporting to Accounting Ops Lead, the Accounting Ops Asst Accountant will be responsible for managing Inventory.

Responsibilities

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 the approved BOM form.
  • Run product returns report and collate information, then clear production returns (write-off's, transfers to FG or Rework) before end of month.
  • Identify physical count variances and coordinate with the Acctg Ops Lead to investigate and resolve those issues with the Warehouse.
  • 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.
  • Reconcile and update NZ shipment reports at end of month.
  • Run and collate Syrup Expiry Report and write off syrups less than a month old.
  • Collate and run Warranty Report monthly. Report faulty machines and faulty cylinders by type and fault description on Oracle. Enter costs in US$ of these faulty products in Oracle.
  • Run 'Inventory as of date' report from Oracle at end of month and collate. Enter data into monthly Management report.
  • Calculation of provision requirement for Syrups in Stock nearing expiry.
  • Run slow moving report monthly and email to Planning & BI Manager.
  • 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.
  • Run Global cylinder report and check for errors.
  • 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.
  • Lead the physical count in all locations (Finance Rep).
  • Prepare key inventory reconciliations to be submitted to HQ.
  • Tally stocks in TM1 at month end.

Cylinders

  • Calculating and recording write-off of cylinders in AUT sub-inventory at month end.
  • Foreign cylinders -Recording of all manual transactions including maintaining provision against inventory balance.
  • 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).
  • Cylinder reconciliation spreadsheets for retailers that require it.
  • Investigate unidentified cylinders received into warehouse and after investigation receipt them in Oracle.
  • Run and collate reports for cylinders sent back from SGS and DFE for Independent group of customers.
  • Cylinder reconciliation of credits raised, and cylinders received into warehouse from SGS and DFE.
  • Scrap cylinders from SCRAP CYL sub-inventory (as identified by Retest Dept).

AR Dummy Accounts

  • Monitoring of AR Dummy accounts monthly to identify any anomalies.
    Investigate customers with unusual dummy account balances and correct errors or omission from the past.

Overall

  • Support other team members during work overflow situations.
  • Coordinate with HQ IT Department for all Oracle system issues, maintenance and development.
  • Provide supporting documentation and explanations to auditors (internal and external).
  • Assisting the Acctg Ops Lead in ensuring that internal controls are operating as designed and all relevant documentation is maintained as prescribed by the PepsiCo Global Control Standard (GCS).
  • Be cross trained in other job areas within the Finance Department to act as cover for staff on annual leave or emergency leave.
  • Any other new responsibilities that may be required by HQ or management requirements.
Qualifications
  • Knowledge of Inventory Management
  • Knowledge of general accounting principles and procedures
  • Previous experience in using major ERP's. Oracle experience & Netsuite highly desired
  • Excellent Microsoft Office (Excel, Word, Outlook etc.) skills
  • Proficient in data entry and management
  • Strong attention to detail


  • Melbourne, Victoria, Australia PepsiCo Australia and New Zealand Full time $90,000 - $120,000 per year

    Reporting to the Head of Finance, the Acctg Ops Accountant (FP&A) will be responsible for key managing key FP&A processes including close, forecast, AOP, long-term strategic planning.Manages key FP&A processes including close, forecast, AOP, long-term strategic planningProvide financial analysis relating to operating cost (Sales & Distribution, Advertising &...


  • Melbourne, Victoria, Australia PepsiCo Full time $60,000 - $120,000 per year

    Overview Position DescriptionJob Title:  Sales Business Development AnalystJob Code:J Job Level:L05PEP Title:Sales Bus Dev Asst AnalystReporting to:  Key Accounts Manager - GroceryLocation:  SodaStream Australia Head Office – Knoxfield, MelbourneSodaStream is seeking a highly skilled and strategic individual to join our Australian team. The Sales...


  • Melbourne, Victoria, Australia ASUS Full time $80,000 - $120,000 per year

    ASUS, a technology-oriented company blessed with one of the world's top R&D teams, is renowned for high-quality products and cutting-edge innovation. As a leading company in the new digital era, ASUS offers a complete product portfolio to compete in the new millennium. Due to business expansion, we are currently seeking an experienced and...


  • Melbourne, Victoria, Australia Australian Venue Co. Full time $80,000 - $120,000 per year

    At Australian Venue Co., we're redefining the hospitality experience through creativity, technology, and media innovation. Our Retail Media division connects leading alcohol brands — and soon, non-endemic brands — with millions of consumers across 200+ venues nationwide. We blend real-world experiences with innovative retail media strategies to influence...


  • Melbourne, Victoria, Australia Australian Venue Co Full time $80,000 - $120,000 per year

    Job no: 525865Work type: SalariedLocation: MelbourneCategories: MarketingAt Australian Venue Co., we're redefining the hospitality experience through creativity, technology, and media innovation. Our Retail Media division connects leading alcohol brands — and soon, non-endemic brands — with millions of consumers across 200+ venues nationwide. We blend...


  • Melbourne, Victoria, Australia KraftHeinz Full time $120,000 - $180,000 per year

    Grow Your Supply Chain & Operations Career with Kraft HeinzAre you a proven continuous improvement professional looking to develop their career in Supply Chain & Operations? We have a critical role with a key focus on process and productivity improvements to deliver cost savings within logistics, warehousing, customer excellence, supply and demand across the...


  • Melbourne, Victoria, Australia Kraft Heinz Full time $120,000 - $180,000 per year

    Continuous Improvement Logistics LeadOpportunity to grow your career in Supply Chain & OperationsFlexible work arrangement – 3 days in office, 2 days remoteCollaborative and dynamic work environmentGrow Your Supply Chain & Operations Career with Kraft HeinzAre you a proven continuous improvement professional looking to develop their career in Supply Chain...


  • Melbourne, Victoria, Australia Common Equity Housing Limited (CEHL) Full time $120,000 - $180,000 per year

    · Strong commercial background· Community Housing Provider· Two-year remunerated appointment· Located in Carlton (Melbourne)Common Equity Housing Limited (CEHL) is a Victorian Registered Housing Association and Public Benevolent Institution (Charity) that develops and manages affordable housing throughout Victoria.With a portfolio of more than 2000...


  • Melbourne, Victoria, Australia Zerocap Full time $60,000 - $120,000 per year

    About usZerocap is a global digital asset trading firm, trusted by institutional clients in 50+ countries. We help clients access crypto markets through secure trading and liquidity solutions. Our goal is simple: to make finance borderless and friction-free.As we expand across the Asia-Pacific region, we're building a dedicated client enablement and support...

  • Teachers Assistant

    7 days ago


    Melbourne, Victoria, Australia CALEDIMER PTY LTD Full time $45,000 - $65,000 per year

    Our Company - GymbaROO stands out as being the ONLY parent-child program in the world that specialises in research-based, neuro-developmental, fun learning environments for babies to school-aged children and their parents. It is also the only program in the world that has integrated key developmental activities, essential for complete development in each age...