SodaStream Acctg Ops Asst Accountant

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