AR/Billing Reconciliation Analyst

ABC-Home-; Cypress (TX); On-site; USD 65,000 - 95,000; Full time

Job summary

ABC-Home- is seeking a meticulous AR / Billing Reconciliation Analyst to lead the forensic audit and reconciliation of the billing sub-ledger, requiring a formal accounting or finance framework and superior analytical capabilities.

You will perform line-by-line audits, contract and variance matching, compliant ledger corrections, and cash application reconstruction, collaborating with the AR Supervisor to draft SOPs and providing macro-level reconciliations for complex customer inquiries.

Qualifications

• Bachelor's degree in Accounting, Finance, or a quantitative discipline.
• 3–5+ years in accounting, sub-ledger reconciliation, or forensic billing.
• Advanced Excel mastery including XLOOKUP/VLOOKUP and Pivot Tables.
• Fluency in double-entry bookkeeping and GL reconciliation impacts.
• Investigative, patient and detail-driven problem solver.

Responsibilities

• Forensic sub-ledger cleanup and line-by-line audits of AR/billing data.
• Contract and variance matching against MSAs and POs to isolate variances.
• Prepare and execute credit memos, debit adjustments, and reverse entries.
• Audit bank deposits, wires, and remittance files to reallocate misapplied funds.
• Collaborate with AR Supervisor to draft and deploy SOPs.
• Provide macro-level reconciliations for complex client inquiries.

Skills

XLOOKUP/VLOOKUP

Pivot Tables

Advanced Excel

Forensic Billing Audit

Double-Entry Bookkeeping

Education

Bachelor's degree in Accounting/Finance

Job description

Description

We are seeking a highly meticulous, data-driven AR / Billing Reconciliation Analyst to lead the forensic audit and reconciliation of our billing sub-ledger. The ideal candidate possesses a formal accounting or finance framework combined with superior analytical capabilities.

Core Responsibilities & Objectives

• Forensic Sub-Ledger Cleanup: Systematically identifying, tracing, and resolving account discrepancies. Perform line-by-line audits of historical transactional data within the accounts receivable and billing sub-ledgers to pinpoint, isolate, and repair manual human entry errors.
• Contract & Variance Matching: Cross-reference multi-layered customer contracts, master service agreements (MSAs), and purchase orders against issued bills to mathematically isolate billing variances and historical under/over-charges.
• Compliant Ledger Corrections: Calculate, stage, and physically execute precise credit memos, debit adjustments, and reverse incorrect entries within the billing system.
• Cash Application Reconstruction: Audit historical bank deposit logs, wire transfers, and customer remittance files to identify and reallocate misapplied funds if any
• Policy & Control Architecture: Collaborate directly with the AR Supervisor to draft, build, and deploy new Standard Operating Procedures (SOPs).
• Strategic Client Buffer: Partner with relationship management teams to provide clear, macro-level reconciliations and statement presentations for complex corporate customer billing inquiries.

Requirements

Required Qualifications & Skills

• Education: Bachelor's degree in Accounting, Finance, or a heavily quantitative business discipline is required.
• Experience: 3–5+ years of dedicated professional accounting, sub-ledger reconciliation, or forensic billing audit experience.
• Advanced Excel Mastery: Absolute proficiency in intermediate-to-advanced spreadsheet modeling, including XLOOKUP/VLOOKUP, complex Pivot Tables.
• Double-Entry Bookkeeping Fluency: Comprehensive operational knowledge of debits, credits, sub-ledger accounting architecture, and general ledger reconciliation impacts.
• Problem-Solving Persona: An investigative, patient, and detail-driven mindset that thrives on untangling complex relational database errors row-by-row rather than relying on automated sweeping patches.