Revenue Reconciliation Clerk - ZR_2592_JOB

Job Description

Red Ember Recruitment is seeking a detail-oriented Revenue Reconciliation Clerk for a permanent opportunity in the Plattekloof. This role is ideal for a numerically strong individual who enjoys working with financial data, investigating discrepancies and keeping records accurate.

• Perform daily revenue and banking reconciliations.
  
• Reconcile point-of-sale (POS) sales against bank statements, cash deposits and card settlement reports.
  
• Capture, verify and maintain accurate financial data on internal systems and Excel spreadsheets.
  
• Use Excel functions, particularly VLOOKUP, to match transaction data, compare records and identify discrepancies.
  
• Investigate and follow up on missing transactions, incorrect amounts and outstanding reconciling items.
  
• Assist with identifying cash shortages, settlement discrepancies and potential revenue losses.
  
• Maintain organised supporting documentation and reconciliation records for audit purposes.
  
• Prepare daily, weekly and monthly reconciliation reports.
  
• Liaise with internal departments and relevant service providers to resolve queries.
  
• Ensure all reconciliations are completed accurately and within the required deadlines.
  
• Assist with general finance administration as required.
  

Requirements

• Grade 12 (Matric) is essential.
  
• A certificate or diploma in Accounting, Finance or Bookkeeping will be advantageous.
  
• Minimum 2 years’ relevant experience in reconciliations, finance administration, bookkeeping or a similar role.
  
• Strong Microsoft Excel skills are essential, particularly VLOOKUP.
  
• Experience working with large spreadsheets and comparing data across multiple reports.
  
• Basic understanding of banking, cash-ups, financial transactions and reconciliations.
  
• Experience with accounting or ERP systems will be advantageous.
  
• Retail, restaurant, FMCG or multi-site business experience will be beneficial.
  

Required Skills and Competencies

• Strong Excel skills, including VLOOKUP, filtering, sorting and working with formulas.
  
• Excellent numerical and analytical abilities.
  
• High attention to detail and accuracy.
  
• Ability to identify discrepancies and investigate variances.
  
• Good organisational and time-management skills.
  
• Ability to meet daily deadlines in a fast-paced environment.
  
• Strong problem-solving skills.
  
• Good written and verbal communication skills.
  
• High level of integrity and accountability.
  
• Ability to work independently and as part of a finance team.
  

Requirements
Matric is essential; an Accounting, Finance or Bookkeeping qualification is advantageous. At least 2 years’ relevant experience in reconciliations, finance administration, bookkeeping or a similar role. Strong, practical Microsoft Excel skills — especially VLOOKUP. Experience working with spreadsheets and comparing data across reports. Good numerical ability, attention to detail and problem-solving skills. Accounting or ERP system experience is advantageous; retail, restaurant or FMCG experience is beneficial.