Accounts Receivable Specialist - Excel & Collections

Aston Carter; United States; Hybrid; USD 24,000 - 34,000; Full time

Benefits offered by this job

Medical, dental & vision

401(k) Retirement Plan

Time Off / PTO

Job summary

Aston Carter is seeking an Accounts Receivable Clerk for a Contract to Hire position based in Somerset, NJ. The role supports the AR function by cleaning up overdue balances, reducing backlog, and performing data-driven analyses in Excel.

The candidate should have a accounting or business degree, corporate AR experience, and strong Excel skills (VLOOKUP, PivotTables). This hybrid role offers exposure to broader finance responsibilities as the company grows.

Qualifications

• Bachelor's degree in Accounting or a business-related field.
• Experience in a corporate environment, preferably in collections or a related Accounts Receivable function.
• Proficiency in Excel with VLOOKUPs and PivotTables for data analysis and reporting.
• Strong customer orientation and ability to communicate clearly with internal and external stakeholders.
• Solid data entry skills with attention to detail and accuracy.

Responsibilities

• Assist in reducing and cleaning up the backlog of Accounts Receivable invoices to improve cash flow and reporting accuracy.
• Follow up with escalated customer accounts to secure payment of past-due balances in a professional and customer-focused manner.
• Process and print copies of invoices for a portfolio of approximately 50–100 customers, ensuring accuracy and timely distribution.
• Perform ad hoc Excel tasks, including creating charts/graphs, manipulating data, and analyzing customer balances.
• Use Excel tools such as VLOOKUP and pivot tables to organize, reconcile, and review financial data for customer accounts.
• Deliver high-quality customer service addressing inquiries about invoices, balances, and payment status.
• Support the AR team with additional data entry, documentation, and reporting tasks as needed.
• Collaborate with internal stakeholders to support new corporate structures within finance.

Skills

Excel proficiency

Customer focus

Data entry accuracy

Multitasking

Education

Bachelor's degree in Accounting or business-related field

Tools

Microsoft Excel (VLOOKUP, PivotTables)

Job description

Aston Carter is seeking an Accounts Receivable Clerk for a Contract to Hire position based in Somerset, NJ. The role supports the AR function by cleaning up overdue balances, reducing backlog, and performing data-driven analyses in Excel.

The candidate should have a accounting or business degree, corporate AR experience, and strong Excel skills (VLOOKUP, PivotTables). This hybrid role offers exposure to broader finance responsibilities as the company grows.