Assistant Accountant Chem/Petro/Oil & Gas Durban - Kwa Zulu Natal - South Africa
Essential: B. Commerce (Accounts)
2 to 3 years post qualification experience.
Roles & Responsibilities:
Oil and related transport supplier reconciliations:
Preparation of the supplier reconciliations (which includes checks from source documents to Zeno weighbridge data, importing of PO and GRNs into the ERP system (Syspro), price calculation checks and AP invoice matching). Preparation and execution of supplier payments within contractual terms. Liaison with procurement / branch managers / supplier finance teams to address and resolve any supplier related queries in an efficient manner.
Inventory mass balance:
Input of receipts from above, sales from debtors and transfers, reallocations, usages, and closing stock received from branches into the mass balance excel template (Quantity and Amount). Sense-check the information input into the mass balance to identify any errors and potential inventory reconciliation queries ahead of time and alert branch stock controllers. Liaison with branch stock controllers and managers to investigate, explain, and/or correct calculated stock losses. Preparation and input of cost of sales journals into the ERP system and ensure that control account ledger accounts agree to mass balance totals and balances.
Cost of sales month end updates and checks (not exhaustive):
Calculate effluent water on billing in line with ship slop contracts, send to Ship slops sales representative for review and to debtors for billing. Check Interbranch sales and cost of sales general ledger accounts sum to nil. Calculate and journal interbranch admin fees, ad hoc commission charges / interbranch TPT/Lube TPT reallocations to cost of sales. Calculate and journal carbon tax charges for the month. Refresh GRN trial balance ODBCs and check that all oil related accruals are valid, within prescription period and general ledger balance. Refresh COS and Margin ODBCs and perform sense checks to identify and correct any potential errors / reallocations. Prepare a summary of blends for final products showing changes in components and unit costs. Provide feedback on variance analysis queries/other received from the financial manager.
Customer pricing data checks and uploads (market data updates product mechanism updates customer pricing formula updates, transport data updates) into excel and Megasoft application monthly. Customer pricing updates into ERP after review by the financial manager and divisional managers monthly. Field customer pricing admin queries and update the ERP system where necessary. Facilitate the clearance of export sale transactions out of the VM (including the checking and uploading of supporting documents) within the acceptable times frames as issued by SARS. Prepare the DAS schedule, reconcile the schedule to Athena and submit the DAS return on SARS e-filing monthly. Prepare and submit carbon tax reconciliation on an annual basis. ERP system (Syspro) and related finance applications admin support
Ensure that work is performed in line with company policies and procedures. Ad hoc assignments as and when required by management.
Highly ethical, consistent, energetic, dedicated individual. Business orientated with strong technical ability and a logical thinker. A good team player with good communication and prioritisation skills. Able to function optimally with minimal direct supervision or support. Able to work under pressure. Good interaction with all stakeholders (internal & external). Subordinates: No subordinate management however strong inter-employee communication required.
Excel (advanced), Proficient on Syspro, MS SQL queries
Own reliable transport
Infrequent travel to branches.
After hours and weekend time as required by financial calendar.