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