Excel-Driven Revenue Reconciliation Specialist

Red Ember Recruitment (Pty) Ltd; Wes-Kaap; On-site; ZAR 180,000 - 240,000; Full time

Job summary

Red Ember Recruitment (Pty) Ltd in Plattekloof is seeking a detail-oriented Revenue Reconciliation Clerk to manage daily revenue and banking reconciliations, match POS sales to bank statements, and maintain accurate financial data in internal systems and Excel.

You will investigate discrepancies, prepare reconciliations and reports, liaise with other departments and service providers, and contribute to audit-ready records.

Qualifications

• 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, particularly VLOOKUP.
• Experience working with large spreadsheets and comparing data across 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.

Responsibilities

• Perform daily revenue and banking reconciliations.
• Reconcile 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.

Skills

Numerical ability

Analytical skills

Attention to detail

Time management

Communication skills

Problem solving

Education

Grade 12

Accounting/Finance/Bookkeeping certificate or diploma

Tools

VLOOKUP

Job description

Red Ember Recruitment (Pty) Ltd in Plattekloof is seeking a detail-oriented Revenue Reconciliation Clerk to manage daily revenue and banking reconciliations, match POS sales to bank statements, and maintain accurate financial data in internal systems and Excel.

You will investigate discrepancies, prepare reconciliations and reports, liaise with other departments and service providers, and contribute to audit-ready records.