Accounting & Reconciliations Specialist (Part-time)

Ledgent Finance & Accounting; Irvine (CA); On-site; USD 37,000 - 41,000; Part time

Job summary

Ledgent Finance & Accounting is seeking a Part-Time Accounting Admin Assistant to support a data cleanup project in Irvine. You will reconcile accounts across AppColl, Clio, QuickBooks, and Legal Tracker, clean historical data, and investigate discrepancies with advanced Excel techniques.

The role emphasizes attention to detail, analytical thinking, and collaboration with accounting leadership. On-site schedule is 20+ hours weekly, with DOE compensation in the $27-$30/hour range.

Qualifications

• Bachelor's degree preferred in accounting or related field.
• Experience in accounting, bookkeeping, AR, or financial analysis preferred.
• Strong Excel skills: VLOOKUP/XLOOKUP, Pivot Tables, Data Validation, advanced formulas.

Responsibilities

• Reconcile accounts receivable and financial data across multiple software platforms.
• Review and clean up historical data from system migration.
• Investigate and resolve duplicate, missing, or corrupted records.
• Perform data analysis and forensic-style research for accuracy.
• Create Excel reports, reconciliation schedules, and tracking tools.
• Identify trends and discrepancies in large data sets.
• Collaborate with firm admins and accounting leadership to resolve issues.
• Support process improvement and ongoing projects.

Skills

Microsoft Excel

Analytical thinking

Attention to detail

Education

Bachelor's degree in Accounting, Finance, Business, Mathematics, Economics, or related field

Tools

AppColl

Clio

QuickBooks

Legal Tracker

Job description

Part-Time Accounting Admin Assistant

Location: Irvine, CA (100% On-Site)

Schedule: Part-Time, 20 Hours per Week or more

Comp: $27-30/hr DOE

About the Opportunity

A growing law firm is seeking a detail-oriented and analytical professional to support a critical accounting data cleanup and reconciliation project. This role will focus on identifying, researching, and correcting discrepancies across multiple financial and case management systems following a recent system migration. This is an excellent opportunity for someone who enjoys working with data, solving complex reconciliation issues, and utilizing advanced Excel skills to identify patterns, variances, and inconsistencies. The position also offers potential for expanded responsibilities and long-term growth based on performance and business needs.

Key Responsibilities

• Reconcile accounts receivable and financial data across multiple software platforms, including:
  • AppColl
  • Clio
  • QuickBooks
  • Legal Tracker
• Review and clean up historical accounting and billing data resulting from system migration issues.
• Investigate and resolve duplicate, missing, or corrupted records.
• Perform detailed data analysis and forensic-style research to ensure data accuracy and integrity.
• Create and maintain Excel reports, reconciliation schedules, and tracking tools.
• Identify trends, patterns, and discrepancies within large data sets.
• Collaborate with firm administrators and accounting leadership to resolve outstanding data issues.
• Assist with process improvement recommendations to enhance future data management and reporting accuracy.
• Support ongoing accounting and operational projects as assigned.

Qualifications

• Bachelor's degree in Accounting, Finance, Business, Mathematics, Economics, or related field preferred.
• Prior accounting, bookkeeping, accounts receivable, audit, or financial analysis experience is highly preferred.
• Strong Microsoft Excel skills required, including:
  • VLOOKUP/XLOOKUP
  • Pivot Tables
  • Data Validation
  • Advanced formulas and data analysis functions
• Excellent numerical aptitude and analytical thinking.
• Strong attention to detail and ability to identify anomalies within large data sets.

All qualified applicants will receive consideration for employment without regard to race, color, national origin, age, ancestry, religion, sex, sexual orientation, gender identity, gender expression, marital status, disability, medical condition, genetic information, pregnancy, or military or veteran status. We consider all qualified applicants, including those with criminal histories, in a manner consistent with state and local laws, including the California Fair Chance Act, City of Los Angeles' Fair Chance Initiative for Hiring Ordinance, Los Angeles County Fair Chance Ordinance, and San Francisco Fair Chance Ordinance.