Revenue Reconciliation Specialist

Red Ember Recruitment (PTY) Ltd; Durbanville; On-site; ZAR 180,000 - 300,000; Full time

Job summary

Red Ember Recruitment (PTY) Ltd seeks a detail-oriented Revenue Reconciliation Clerk for a permanent role based in Durbanville, South Africa. You will perform daily revenue and banking reconciliations, verify transactions, and maintain accurate records.

The ideal candidate has strong Excel skills (including VLOOKUP), at least 2 years in reconciliations or finance administration, and the ability to investigate discrepancies and meet deadlines in a fast-paced environment.

Qualifications

• 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 with large spreadsheets and data comparison 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 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 documentation and reconciliation records for audit purposes.
• Prepare daily, weekly and monthly reconciliation reports.
• Liaise with internal departments and service providers to resolve queries.
• Ensure all reconciliations are completed accurately and within deadlines.
• Assist with general finance administration as required.

Skills

VLOOKUP

Excel

Reconciliations

Finance admin

Bookkeeping

Attention to detail

Analytical thinking

Time management

Communication skills

Education

Accounting/Finance diploma

Tools

ERP systems

Job description

Red Ember Recruitment (PTY) Ltd seeks a detail-oriented Revenue Reconciliation Clerk for a permanent role based in Durbanville, South Africa. You will perform daily revenue and banking reconciliations, verify transactions, and maintain accurate records.

The ideal candidate has strong Excel skills (including VLOOKUP), at least 2 years in reconciliations or finance administration, and the ability to investigate discrepancies and meet deadlines in a fast-paced environment.