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 authorization.
• Raise invoice to Principal.
• Forward rejections to the depot for resolution.
• Run SAP report for Distribution Fee, compare to GL for Margin recovery.
• Analyze 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 authorization.
• Raise manual invoice to the principal.
• Analyze monthly principal margins and prepare journals to correct margins.
• Assist admin controllers to correct the margin, of 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 a 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 the principal.
• Escalate outstanding issues to regional Financial Managers where necessary.
• Submit reports to the Principal for recovery before 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 the 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 aging summary and follow-up on items greater than 60 days
• Analyse intercompany sales/cost sales every month Analyse consignment sales/cost of sales.
• 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 clear them before month-end.

Other/Adhoc requirements:

• Providing ad-hoc reporting requirements for Principals i.e stock movement trends and YTD sales figures Identify differences per profit center and liaise with Master Data or BCX where necessary
• Resolve Principal queries relating to BDVs 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, prioritizing 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 being 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 a willingness to help others and “go the extra mile” to meet team targets and objectives.
• Champion training and development of self and others through utilizing 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 your targets and goals are clear and achievable.

Closing Date: 20th, April 2022