AR/Billing Reconciliation Analyst

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.