Find Your
Next Level Job

Accounts Receivable Analyst (Excel-Driven) (BJW - A/R)

Overview

job salary$21 - $21/hour
job locationFlorida -- Jacksonville
job typeContract

Position Overview

The Accounts Receivable Specialist is responsible for ensuring the accurate and timely processing of customer invoices, payments, and account reconciliations. This role is critical to maintaining healthy cash flow, reducing aging balances, and supporting the month-end close process. The ideal candidate brings strong analytical ability, advanced Excel skills, and a collaborative mindset to manage high-volume AR activity and resolve discrepancies efficiently.


Key Responsibilities

  • Process and post customer payments, including checks, ACH, wire transfers, and credit card transactions, with a high level of accuracy.

  • Apply cash to customer accounts and investigate, reconcile, and resolve unapplied or misapplied payments.

  • Generate and distribute customer invoices and statements in accordance with established billing schedules.

  • Monitor accounts receivable aging and proactively follow up on past-due balances to minimize delinquency.

  • Conduct collection activities via phone and email while maintaining professional, positive customer relationships.

  • Research and resolve billing discrepancies, short pays, deductions, and chargebacks.

  • Reconcile the AR subledger to the general ledger and assist with month-end close activities.

  • Maintain accurate customer master data, including credit limits, payment terms, and account notes.

  • Partner with Sales, Customer Service, and Billing teams to resolve account issues and improve collection outcomes.

  • Prepare AR reports, aging schedules, cash application summaries, and cash forecasts for management review.

  • Utilize advanced Excel functions (pivot tables, VLOOKUP/XLOOKUP, formulas, data analysis tools) to analyze AR trends, identify issues, and improve reporting efficiency.

  • Ensure compliance with company policies, internal controls, and audit requirements.

  • Support continuous improvement initiatives to enhance AR processes, reporting, and cash flow performance.


Qualifications

Required

  • Associate’s or Bachelor’s degree in Accounting, Finance, or a related field (or equivalent experience).

  • Minimum 2+ years of accounts receivable or general accounting experience.

  • Strong to advanced Excel skills, including pivot tables, lookups, formulas, and data analysis.

  • Experience working with ERP or accounting systems and high-volume transaction environments.

Ascendo is a certified minority owned staffing firm, and we welcome and celebrate diversity. Ascendo is an Equal Opportunity Employer and does not discriminate on the basis of race, color, religion, sex (including pregnancy and gender identity), national origin, political affiliation, sexual orientation, marital status, disability, genetic information, age, parental status, military service or any other characteristic protected by federal, state or local law.


Contact information

Bradley Wallace