What are the responsibilities and job description for the Accounts Receivable Reporting Analyst - Consultant position at BrightCore?
BrightCore specializes in Talent Solutions for CFO organizations with expertise in Consulting (Interim & Project) and Executive Search. We partner with finance leaders to assess needs and deliver highly skilled, proven consultants for interim positions and strategic projects. We provide individual technical expertise or a team of professionals to tackle a complex project. We are trusted advisors in providing Finance & Accounting talent solutions to complement existing core teams, lift the capabilities of CFO organizations, and drive financial results.
Our clients include Private Equity, Middle Market, and Fortune 500 Companies in a variety of industries.
Our consultants include CPAs and MBAs, typically with a Big 4 foundation, extensive hands-on and leadership roles in large global companies, subject matter experts, and 10 years of experience in Finance & Accounting and various project roles supporting CFO organizations.
BrightCore is seeking an Accounts Receivable Reporting Analyst to consult at a well-known Atlanta based client. Work location is 4 days in office (Friday work from home).
Accounts Receivable (AR) Reporting Analyst is responsible for analyzing, monitoring, and reporting on a company's incoming payments and outstanding customer invoices. The role combines accounting knowledge with data analysis to improve cash flow and support financial decision-making.
Accounts Receivable Management
- Monitor customer accounts to ensure timely payment of invoices.
- Track outstanding balances and aging reports.
- Investigate overdue accounts and identify collection issues.
- Reconcile customer payments with invoices and account balances.
Reporting and Analysis
- Prepare daily, weekly, and monthly accounts receivable reports.
- Analyze AR aging trends and identify risks or problem accounts.
- Create dashboards and financial reports for management.
- Monitor key performance indicators (KPIs), such as:
- Days Sales Outstanding (DSO)
- Collection rate
- Bad debt trends
- Aging by customer
Data Accuracy
- Validate billing and payment data for accuracy.
- Reconcile discrepancies between accounting systems and customer records.
- Ensure financial records comply with company policies and accounting standards.
Customer and Internal Support
- Respond to customer inquiries regarding invoices and payments.
- Work with sales, customer service, and finance teams to resolve billing disputes.
- Assist the collections team by providing reporting and analysis.
Process Improvement
- Identify trends affecting collections and cash flow.
- Recommend improvements to AR processes and reporting.
- Help automate reports and improve reporting efficiency using tools such as Excel, Power BI, or SQL.
Month-End and Audit Support
- Assist with month-end close activities.
- Prepare AR reconciliations and supporting schedules.
- Provide documentation for internal and external audits.
Skills Required
- Strong Microsoft Excel skills (PivotTables, VLOOKUP/XLOOKUP, formulas).
- Experience with ERP systems such as Oracle Fusion.
- Knowledge of accounting principles and accounts receivable processes.
- Data analysis and reporting skills.
- Attention to detail and accuracy.
- Strong communication and problem-solving abilities.
Qualifications
- Bachelor's degree in Accounting, Finance, Business a plus.
- 5 years of experience in accounts receivable, accounting, or financial analysis.
- Familiarity with Microsoft Office, especially Excel and Oracle Fusion.
This role is well suited to someone who enjoys working with financial data, solving discrepancies, and using reporting tools to help improve an organization's cash collection and financial performance.
BrightCore consultants are offered a Full Suite of Benefits including:
- Health Insurance: Medical, Dental, Vision
- PTO / Vacation / Paid Holidays
- 401K Retirement Plan
- Health Savings Account (HSA) with “Mutual Fund Sweep” option
- Financial Wellness Program
- CPE & Upskilling Reimbursement