Accounts Receivable Analyst

Aston Carter•Walnut Creek, CA

19h•$28 - $32•Onsite

About The Position

A benefits administration company is seeking an Accounts Receivable Accountant to join their accounting team. The individual will be responsible for engaging with participating employers to process contributions for health, welfare, and pension benefits for their employees.

Requirements

Proficiency in accounts receivable processes.
Advanced Microsoft Excel skills, including pivot tables and vlookups. (intermediate/advanced)
Strong accounting knowledge with at least 2+ years of experience in accounts receivable or general accounting.
Experience with data analysis and billing collections.
Ability to perform reconciliations and manage accounts receivable collections.
Familiarity with Microsoft Dynamics.
Experience with general ledger and monthly reconciliations.

Nice To Haves

Bachelor's degree in accounting, finance, or economics.
Proficiency in Excel functions such as pivot tables, vlookups, and hlookups.

Responsibilities

Process monthly contributions for participating employers using Microsoft Excel.
Create test files for data uploads to the company mainframe.
Process and review manual calculations, ensuring accuracy of system-generated calculations.
Download daily lockbox details to apply payments to specific accounts and allocate receipts to appropriate funds.
Reconcile and invoice for differences, preparing billing documents and discrepancy letters.
Balance monthly receipts to bank statements and prepare totals for the monthly general ledger update.
Perform file transfer, receipt, and collection of dependent premiums.
Research, prepare, bill, and document the status of compliance audits, account reconciliations, and withdrawal liability.
Research and bill receivable balances, including liquidated damages, providing supporting documentation for amounts due.
Coordinate arbitrations and collection actions for unpaid contributions, in conjunction with counsel and management.
Perform all rate maintenance, including the preparation of input sheets and updates to agreement codes, participation, rate lines, and rate tables.
Analyze inquiries from other departments or business associates regarding contribution data to prepare and load adjustments for monthly hours.
Maintain all facets of the employer account relationship, including account setup and termination, contact information updates, and assisting employers with requests.
Respond professionally and articulately to client inquiries, managing emotionally charged conversations with urgency and providing detailed descriptions of complex procedures and concepts.
Review collective bargaining agreements and trust agreements to correspond and communicate with employers, external auditors, and union locals regarding contribution reporting requirements.
Prepare submissions to the Board of Trustees, including payment plans and settlement proposals with the calculation of payment plan interest.
Prepare daily, weekly, and monthly statistical reports, and format information for ad hoc data requests.
Create and update department processes for new and assigned tasks; develop and test new procedures.
Assist in regular cross-training and proofreading activities.
Perform general office duties and ensure the workspace and office are kept clean.
Complete special projects as assigned.