Pepco & Arcadia Bill Analyzer

Entra login + OneDrive sync + PDF parsing (client-side)

Uses BOTH Pepco totals: Pepco Total (Before Credit) and Pepco Due (After Credit). New Pepco format supported via Service Period Total / Current Charges.

Stored in the signed-in user's OneDrive root.

Status
Not signed in
Ready.
Auto-merge Health (Service Period End)
0 Pepco records 0 Arcadia records 0 Merged periods 0 Pepco-only 0 Arcadia-only
Show unmatched periods
Pepco periods missing Arcadia
    Arcadia periods missing Pepco

      Matching key: serviceEndISO. Pepco derives from “Billing Period … to …”. Arcadia derives from “Service period …” + Payment Date year.

      Savings Summary
      No savings yet
      Last month savings
      —
      Arcadia Gross − Arcadia Due
      Cumulative savings
      —
      Sum across merged periods
      Average monthly savings
      —
      Avg across merged periods
      Savings rate
      —
      Savings ÷ Arcadia Gross

      Savings uses Arcadia statement math (Gross − Due), and Pepco “before credit” stays separate as Pepco Total (Before Credit).

      Visualization
      Show

      Left axis = dollars. Right axis = Pepco kWh.

      Merged by Service Period End Date
      Show raw records (debug)
      Provider Service End kWh Pepco Total Pepco Due Arcadia Gross Arcadia Due Arcadia Savings Source
      Service End kWh Pepco Total (Before Credit) Pepco Due (After Credit) Arcadia Gross Arcadia Due (Charged) Arcadia Savings Sources