We are Huntswood. The people who put partnership first. A trusted team with the insight, expertise, and pace to create better outcomes for our clients, their customers, and the communities they are a part of.
We deliver resourcing, outsourcing and advisory services from complaints to customer service, remediation to resilience – bringing together the pe...
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).
20 Initiatives to Boost Employee EngagementAre you struggling with improving employee engagement at work? This article covers everything from better communication to building a strong workplace culture.
30 Common Interview Mistakes to AvoidThis piece examines 30 of the most common mistakes applicants make at interviews, so you know how to better avoid them.
Gmail
Yahoomail