SodaStream Acctg Ops Asst Accountant
2 weeks ago
Reporting to Accounting Ops Lead, the Accounting Ops Asst Accountant will be responsible for managing Inventory.
ResponsibilitiesInventory
- 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.
- 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
- 
					  Acctg Ops Accountant1 week ago 
 Melbourne, Victoria, Australia PepsiCo Australia and New Zealand Full time $90,000 - $120,000 per yearReporting 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 yearOverview 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... 
- 
					  Business Account Manager7 days ago 
 Melbourne, Victoria, Australia ASUS Full time $80,000 - $120,000 per yearASUS, 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... 
- 
					  Retail Media Account Manager7 days ago 
 Melbourne, Victoria, Australia Australian Venue Co. Full time $80,000 - $120,000 per yearAt 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... 
- 
					  Retail Media Account Manager7 days ago 
 Melbourne, Victoria, Australia Australian Venue Co Full time $80,000 - $120,000 per yearJob 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... 
- 
					  Continuous Improvement Logistics Lead1 week ago 
 Melbourne, Victoria, Australia KraftHeinz Full time $120,000 - $180,000 per yearGrow 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... 
- 
					  Continuous Improvement Logistics Lead1 week ago 
 Melbourne, Victoria, Australia Kraft Heinz Full time $120,000 - $180,000 per yearContinuous 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... 
- 
					  Independent Board Director7 days ago 
 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... 
- 
					  Client Services Representative7 days ago 
 Melbourne, Victoria, Australia Zerocap Full time $60,000 - $120,000 per yearAbout 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 Assistant7 days ago 
 Melbourne, Victoria, Australia CALEDIMER PTY LTD Full time $45,000 - $65,000 per yearOur 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...