Trade Reconciliation Controller at RCL Foods

Job Description    
RCL FOODS is currently looking for a Trade Reconciliation Controller to join the Vector Logistics Division. The position is based at our National Office in Westville and will report to the Commercial Officer.

• The purpose of the role is to prepare PSD trade creditor’s reconciliations and prepare payment (monthly average R340m). As a Trade reconciliation controller, the job holder is expected to make all process decisions that fall within the ambit of responsibility, solve transactional and some analytical problems within the function and identify and implement limited innovations, particularly those that will improve financial compliance, reporting and profitability through lowered costs.

Minimum Requirements    

• Finance related diploma / degree
• Minimum of 4 years’ experience required
• SAP R/3 experience preferable
• SAP BW reporting
• Advanced MS Office skills (Word, Excel, and Outlook)
• Verbal and written communication

Duties & Responsibilities    
Month-end requirements:

• Run BW Reporting for P89 customer damages for Principals and forward to principals for review and authorisation. Raise invoice to Principal. Forward rejections to depot for resolution.
• Run SAP report for Distribution Fee, compare to GL for Margin recovery. Analyse detailed billing to ensure rate cents/kg for directs and ex-branch are correct. Follow-up with Principal for payment or where agreed, deduct off payment.
• Run SAP Movement report for FOC (Free stock issues) and send detail to principals with authorisation. Raise manual invoice to principal.
• Analyse monthly principal margins and prepare journals to correct margins. Provide assistance to admin controllers to correct margin, if depot related costs.
• Compare BW Income Statement/P70 v/s Margin Analysis on SAP and investigate variances.
• Process and park journals for principal transport and merchandising fees and raise invoices against the principal.
• Run the claim back report for principals and raise an invoice to the principal.
• Run ZFIPCC report to identify price adjustments and allocate to revaluation or raise an invoice against the principal.
• Process and park journal to clear all balance sheet recoveries accounts to Principal vendor accounts.
• Run stock reports, balance to inventory GL and send to Principals.

Monthly requirements:

• Ensure trade reconciliation accuracy and validity of reconciling items. Facilitate pricing and stock related claims submission to principal. Escalate outstanding issues to regional Financial Managers where necessary.
• Submit reports to Principal for recovery prior to payment. i.e. P89/Trade uplifts; Free of charge stock issues; Distribution Fee report; Transport cost recovery; Merchandising Fee.
• Provide support and direction to admin controllers for misallocation of journals; verification issues; claims variances and stock uplift issues that have an impact on the vendor account and payment. If necessary escalate to Financial Managers for intervention.
• Update month-end payment listing with vendor payment amount which is sent to Finance.
• Verify that the amount to be released to the vendor agrees to our month-end payment schedule after payment proposal is prepared by Finance,.
• Forward payment remittances and recons to principals
• Facilitate the communication for queries raised by vendors that may require feedback from the Customer Managers.
• Prepare Principal ageing summary and follow-up on items greater than 60 days
• Analyse intercompany sales/cost sales on a monthly basis
• Analyse consignment sales/cost of sales on a monthly basis.
• Clear Rainbow GRIR a/c 191202 at month-end
• Analyse Rainbow price variance GL 792502 and prepare necessary journals to clear
• Analyse Rainbow recovery accounts and cleared before month-end.

Other/Adhoc requirements:

• Providing adhoc reporting requirements for Principals i.e stock movement trends and YTD sales figures
• Identify differences per profit centre and liaise with Master Data or BCX where necessary
• Resolve Principal queries relating to BDV’s with Bedfordview team

Effective Teamwork and Self-Management:

• Take ownership and accountability for tasks and activities and demonstrate effective self-management in terms of planning, prioritising and self-development.
• Follow through to ensure that quality and productivity standards of work are consistently and accurately maintained.
• Inform relevant parties in the event of tasks or deadlines not met, the potential risks thereof and provide appropriate resolution.
• Support and drive the business core values.
• Manage colleagues and clients’ expectations and communicate appropriately.
• Demonstrate willingness to help others and “go the extra mile” to meet team targets and objectives.
• Champion training and development of self and others through utilising available training opportunities or contributing to the development of new training solutions relating to product costing in collaboration with national training specialists.
• Participate in regular performance appraisals and ensure that own targets and goals are clear and achievable