AR/Billing Reconciliation Analyst

Socket.dev; Cypress (TX); On-site; USD 65,000 - 90,000; Full time

Job summary

Socket.dev is seeking a meticulous AR / Billing Reconciliation Analyst to lead forensic audits and reconciliation of our billing sub-ledger. The role combines accounting fundamentals with strong analytical skills to identify discrepancies and improve accuracy.

You will perform line-by-line audits, contract and variance matching, and implement SOPs with the AR Supervisor. A bachelor’s in accounting/finance and 3–5+ years in reconciliations are required.

Qualifications

• Bachelor's degree in Accounting/Finance required.
• 3–5+ years of accounting, sub-ledger reconciliation, or forensic billing audit experience.
• Advanced Excel proficiency with XLOOKUP/VLOOKUP and complex Pivot Tables.
• Fluency in double-entry bookkeeping, debits/credits, sub-ledger and GL impacts.
• Investigative, patient, detail-driven mindset for untangling complex data without broad patches.

Responsibilities

• Forensic sub-ledger cleanup: identify, trace, and resolve discrepancies in AR and billing sub-ledgers.
• Contract & variance matching: cross-reference contracts/MSAs/POs against bills to isolate variances.
• Compliant ledger corrections: calculate and implement credit memos, debits, and reverse incorrect entries.
• Cash application reconstruction: audit bank deposit logs, wire transfers, and remittance files to reallocate misapplied funds.
• Policy & control architecture: draft and deploy new SOPs with the AR Supervisor.
• Strategic client buffer: provide macro-level reconciliations for complex corporate billing inquiries.

Skills

Advanced Excel Mastery

Double-Entry Bookkeeping Fluency

Problem-Solving Persona

Forensic Billing Audit Experience

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.