Accounts Administration Specialist

CXP are now part of the Huntswood Group; KwaZulu-Natal; On-site; ZAR 250 000 - 300 000; Full time

Job summary

A financial services company based in Durban is seeking an Accounts Administration Specialist to ensure accurate financial reconciliations and compliance with company standards. The role requires strong analytical capabilities and advanced proficiency in Microsoft Excel, including the use of pivot tables and macros. The position supports US-based working hours, providing a unique opportunity to contribute to a high-impact project. Ideal candidates will have at least one year of relevant experience and a Grade 12 certificate.

Qualifications

• Minimum 1 year experience in a similar role.
• Fully proficient in Microsoft Excel.
• Matric certificate (Grade 12) complete.

Responsibilities

• Perform daily, weekly, and monthly reconciliations of financial records.
• Ensure compliance with company policies and regulatory requirements.
• Utilize advanced Excel formulas for data matching and discrepancies.
• Create pivot tables to summarize financial data.
• Automate reconciliation tasks using Excel macros.

Skills

Attention to detail

Analytical skills

Problem-solving skills

Communication skills

Interpersonal skills

Advanced Excel proficiency

Education

Matric certificate (Grade 12)

Tools

Microsoft Excel

Job description

Please note: Before applying for this post, please be mindful the working patterns will be supporting US based hours (3PM to 12PM local time (SAST)) Based in our office in Durban.

Accounts Administration Specialist

Introduction

We are seeking a detail-oriented and highly organized Accounts Administration Specialist to join our internal project team supporting a key client initiative. This role is critical in ensuring accurate financial reconciliations and maintaining compliance with company policies and regulatory standards. If you have strong analytical skills, advanced Excel proficiency, and thrive in a fast-paced environment, this is an excellent opportunity to contribute to a high-impact project.

Key Responsibilities

• Perform daily, weekly, and monthly reconciliations of bank accounts, supplier accounts, and other financial records.
• Ensure compliance with company policies, procedures, and regulatory requirements.
• Maintain and update reconciliation spreadsheets for multiple accounts.
• Utilize advanced Excel formulas (e.g., VLOOKUP, SUMIF, IF statements) to match transactions and identify discrepancies.
• Create pivot tables to summarize large volumes of financial data for reporting purposes.
• Conduct data validation to ensure accuracy and consistency in reconciliation reports.
• Generate charts and graphs in Excel to visualize reconciliation trends and variances.
• Automate repetitive reconciliation tasks using Excel macros where applicable.
• Consolidate data from multiple sources into a single workbook for monthly and quarterly reconciliations.
• Apply conditional formatting to highlight variances or outstanding items.
• Prepare and maintain audit-ready Excel files with clear documentation of reconciliations.
• Ensure proper version control and secure storage of Excel-based reconciliation reports.

Skills and Competencies

• Strong attention to detail and accuracy.
• Excellent analytical and problem-solving skills.
• Ability to work under pressure and meet deadlines.
• Good communication and interpersonal skills.
• Proficiency in Microsoft Excel (including Pivot Tables, Macros, and advanced formulas).

Experience / Background

• Minimum 1 year exp in a similar role - Essential
• Fully proficient in MS Excel - Essential
• Matric certificate (Grade 12) Complete - Essential