Accounts Receivable Supervisor / Lead – Advanced Excel
Phoenix, AZ Finance
Job Type
Full-time
Description

Location: Phoenix, Arizona
Work Arrangement: Hybrid – Phoenix-based
Employment Type: Full-Time
Target Salary Range: $65,000–$75,000 annually


Position Overview


We are conducting a confidential search for an experienced Accounts Receivable Supervisor / Lead to join our Phoenix-based accounting team. This is a hands-on leadership position for someone who combines strong accounts receivable and collections experience with advanced Excel and analytical skills.


The ideal candidate is not only comfortable supervising and supporting an AR team but is also willing to work directly in the details - reviewing aging, reconciling accounts, analyzing large datasets, resolving billing issues, and handling complex or escalated customer accounts.


This position requires someone who is highly organized, analytical, deadline-driven, and comfortable holding both themselves and others accountable.


Key Responsibilities

  • Provide day-to-day leadership and      oversight of Accounts Receivable activities.
  • Monitor AR aging and drive      collection efforts to reduce past-due balances and improve cash flow.
  • Review collection activity and      ensure appropriate and timely follow-up on outstanding accounts.
  • Personally manage complex,      high-dollar, or escalated customer accounts when necessary.
  • Review and resolve billing      discrepancies, short payments, unapplied cash, credits, and account      reconciliation issues.
  • Assist with cash application and      ensure payments are accurately and timely applied.
  • Review customer accounts for      accuracy and identify billing or payment trends requiring corrective      action.
  • Support month-end close,      including AR reconciliations, aging analysis, and reporting.
  • Prepare and maintain AR reports,      collection reports, cash projections, and other management reporting.
  • Develop and monitor AR      performance metrics and KPIs.
  • Train, coach, and provide ongoing      guidance to AR team members.
  • Review team members' work for      accuracy, completeness, and timely follow-through.
  • Partner with Accounting,      Operations, Sales, Customer Service, and other departments to resolve      customer and billing issues.
  • Identify opportunities to improve      AR processes, reporting, controls, and efficiencies.
  • Maintain accurate documentation      and ensure established AR policies and procedures are consistently      followed.

Advanced Excel Requirements


Advanced Excel proficiency is required for this position. Candidates should be comfortable working independently with large datasets and using Excel to identify discrepancies, reconcile information, and provide meaningful financial analysis.

Candidates should have strong working knowledge of:

  • XLOOKUP and/or INDEX/MATCH
  • SUMIFS, COUNTIFS, IF/IFS, and      other advanced formulas
  • PivotTables and PivotCharts
  • Conditional formatting
  • Data validation
  • Filtering, sorting, and      manipulating large datasets
  • Identifying duplicates and      discrepancies between datasets
  • Performing large-scale account      and transaction reconciliations
  • Creating and maintaining AR aging      and collection reports
  • Building management-level reports      from raw accounting data

Power Query experience is strongly preferred.

Requirements

  

Qualifications:

  • 5+ years of progressive Accounts      Receivable, collections, billing, or related accounting experience.
  • 2+ years in an AR Lead,      Supervisor, Senior AR, or similar leadership capacity preferred.
  • Demonstrated experience managing      or providing day-to-day direction to AR employees.
  • Strong collections and customer      account management experience.
  • Advanced Microsoft Excel skills required.
  • Strong reconciliation and      analytical skills.
  • Experience working with      high-volume AR transactions and customer accounts.
  • Understanding of month-end close      and general accounting principles related to Accounts Receivable.
  • Ability to analyze data and      identify errors, trends, and process issues.
  • Strong written and verbal      communication skills.
  • Ability to professionally handle      difficult customer conversations and escalations.
  • Strong attention to detail with      the ability to manage multiple deadlines and priorities.
  • Ability to work independently      while also providing leadership and support to the team.
  • Experience with QuickBooks Online      or other accounting/ERP systems is preferred.

What We're Looking For


We are looking for a working supervisor, not someone who only delegates. The successful candidate will be comfortable moving between leadership responsibilities and detailed AR work throughout the day.


This person should be able to open an aging report, quickly identify the accounts requiring attention, analyze the underlying data, determine what is preventing collection, and develop an appropriate course of action.

The right candidate will bring a combination of:


Leadership + Collections + Accounting Knowledge + Advanced Excel + Data Analysis + Follow-Through


Work Arrangement


This is a hybrid position based in Phoenix, Arizona. Candidates must live within reasonable commuting distance of the Phoenix office and be available to work onsite as required.


Equal Employment Opportunity:


AccuSourceHR, Inc, provides equal employment opportunities to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability, genetic information, pregnancy, gender identity, sexual orientation, status as a Vietnam-era, special disabled veteran or other veteran, or any other status or characteristic protected by applicable federal, state and/or local laws.


AccuSourceHR, Inc. reserves the right to modify, interpret, or apply the job description as needed. This job description is for informational purposes only and should not be construed as an offer or guarantee of employment.


Any offer of employment is conditional upon the successful completion of a background investigation and drug screening.
By submitting your application for and/or accepting this position, you acknowledge and agree that, if selected, you will be required to electronically sign certain employment-related documents upon commencing your position. This may include, but is not limited to, the offer letter, employment agreement, and other necessary forms.


This job description is not designed to cover or contain all job duties required of the employee. There may be additional activities, duties and/or responsibilities that are required for this position that are not listed in this job description. 

Salary Description
$65,000–$75,000 annually