SYNTHETIC DATA. Fictional properties and placeholder vendors. Nothing is paid, disputed or sent; every item is for a person to review.

Utility Watch · Weekly review

Utility bill exceptions

Week of 2026-09-28 · 31 accounts · 274 bills on file

Checked service months from 2026-03-01.

Flags to review

Back to top

Review each reason and its source rows. Open or close a property to focus the list; all properties start open. A bill can have more than one flag.

Bayou Flats (synthetic)6 flags

  • Late fee / past-due balance

    LATE_FEE_OR_PAST_DUE
    Utility
    electric
    Account
    SYN-7005
    Bill / expected period
    B50087

    late fee $179.02, prior balance $3,222.36 on the bill

    Source rows
    • bills.csv:88

  • Payment does not match bill

    PAYMENT_MISMATCH
    Utility
    water
    Account
    SYN-7007
    Bill / expected period
    B50125

    owed $4,232.12; 2 payment(s) totalling $8,464.24

    Source rows
    • bills.csv:126
    • payments.csv:120
    • payments.csv:121

  • Payment does not match bill

    PAYMENT_MISMATCH
    Utility
    trash
    Account
    SYN-7008
    Bill / expected period
    B50142

    owed $1,258.66; 1 payment(s) totalling $1,108.66

    Source rows
    • bills.csv:143
    • payments.csv:137

  • Service periods overlap

    PERIOD_OVERLAP
    Utility
    gas
    Account
    SYN-7006
    Bill / expected period
    B50107

    service period 2026-06-22..2026-07-31 overlaps prior bill B50106 (2026-06-01..2026-06-30); 9 days may be billed twice

    Source rows
    • bills.csv:108
    • bills.csv:107

  • Usage on a vacant unit

    VACANT_UNIT_USAGE
    Utility
    water
    Account
    SYN-7021
    Bill / expected period
    B50242

    unit 201 vacant; 0.360 kgal/day vs standby ceiling 0.05 (possible leak or running equipment)

    Source rows
    • bills.csv:243
    • occupancy.csv:5

  • Usage on a vacant unit

    VACANT_UNIT_USAGE
    Utility
    water
    Account
    SYN-7021
    Bill / expected period
    B50243

    unit 201 vacant; 0.360 kgal/day vs standby ceiling 0.05 (possible leak or running equipment)

    Source rows
    • bills.csv:244
    • occupancy.csv:5
Cypress Court (synthetic)3 flags

  • Effective rate jumped

    RATE_CHANGE
    Utility
    trash
    Account
    SYN-7004
    Bill / expected period
    B50068

    $123.7817/pull vs trailing median $92.0173 (x1.35); check tariff/rate plan

    Source rows
    • bills.csv:69

  • Usage spike vs same month last year

    USAGE_SPIKE
    Utility
    gas
    Account
    SYN-7002
    Bill / expected period
    B50032

    92.7 therm/day vs 49.4 same month last year (x1.88)

    Source rows
    • bills.csv:33
    • bills.csv:21

  • Usage spike vs same month last year

    USAGE_SPIKE
    Utility
    water
    Account
    SYN-7003
    Bill / expected period
    B50050

    17.9 kgal/day vs 10.0 same month last year (x1.79)

    Source rows
    • bills.csv:51
    • bills.csv:39
Gaylord Ridge (synthetic)3 flags

  • Duplicate bill (hold)

    DUPLICATE_BILL
    Utility
    trash
    Account
    SYN-7012
    Bill / expected period
    B50213

    same invoice number as B50212 (HAUL-50212); hold, do not pay twice

    Source rows
    • bills.csv:214
    • bills.csv:213

  • Expected bill missing

    MISSING_BILL
    Utility
    electric
    Account
    SYN-7009
    Bill / expected period
    SYN-7009:2026-04-01

    no bill for service month 2026-04; check vendor portal / mail before a late fee lands

    Source rows
    • accounts.csv:10

  • Unpaid and past due

    UNPAID_PAST_DUE
    Utility
    gas
    Account
    SYN-7010
    Bill / expected period
    B50178

    due 2026-09-06, no payment on file

    Source rows
    • bills.csv:179

Could not judge

Back to top

These items need a person to resolve missing information or another exception. They are held out of the payment queue. Match the account and bill or expected period to the source rows.

Queued for payment approval

Back to top

12 clean, unpaid bills · $39,821.07 total. Listed by due date, earliest first. Review the account, invoice and source row before approving in your payment system. Nothing here is approved or paid.

  1. Due 2026-10-03

    $5,809.56
    Property
    Bayou Flats (synthetic)
    Utility
    electric
    Vendor
    Metro Power Co (placeholder)
    Account
    SYN-7005
    Bill
    B50090
    Invoice
    METR-50090
    QUEUED_FOR_APPROVAL (not paid)
    Source rows
    • bills.csv:91

  2. Due 2026-10-04

    $7,056.00
    Property
    Cypress Court (synthetic)
    Utility
    electric
    Vendor
    Metro Power Co (placeholder)
    Account
    SYN-7001
    Bill
    B50018
    Invoice
    METR-50018
    QUEUED_FOR_APPROVAL (not paid)
    Source rows
    • bills.csv:19

  3. Due 2026-10-06

    $1,022.79
    Property
    Bayou Flats (synthetic)
    Utility
    gas
    Vendor
    Gulf Gas Utility (placeholder)
    Account
    SYN-7006
    Bill
    B50108
    Invoice
    GULF-50108
    QUEUED_FOR_APPROVAL (not paid)
    Source rows
    • bills.csv:109

  4. Due 2026-10-06

    $7,504.19
    Property
    Gaylord Ridge (synthetic)
    Utility
    electric
    Vendor
    Metro Power Co (placeholder)
    Account
    SYN-7009
    Bill
    B50161
    Invoice
    METR-50161
    QUEUED_FOR_APPROVAL (not paid)
    Source rows
    • bills.csv:162

  5. Due 2026-10-08

    $4,155.10
    Property
    Bayou Flats (synthetic)
    Utility
    water
    Vendor
    City Water Dept (placeholder)
    Account
    SYN-7007
    Bill
    B50126
    Invoice
    CITY-50126
    QUEUED_FOR_APPROVAL (not paid)
    Source rows
    • bills.csv:127

  6. Due 2026-10-08

    $4,338.24
    Property
    Gaylord Ridge (synthetic)
    Utility
    water
    Vendor
    City Water Dept (placeholder)
    Account
    SYN-7011
    Bill
    B50197
    Invoice
    CITY-50197
    QUEUED_FOR_APPROVAL (not paid)
    Source rows
    • bills.csv:198

  7. Due 2026-10-09

    $1,015.72
    Property
    Cypress Court (synthetic)
    Utility
    gas
    Vendor
    Gulf Gas Utility (placeholder)
    Account
    SYN-7002
    Bill
    B50036
    Invoice
    GULF-50036
    QUEUED_FOR_APPROVAL (not paid)
    Source rows
    • bills.csv:37

  8. Due 2026-10-09

    $948.34
    Property
    Gaylord Ridge (synthetic)
    Utility
    gas
    Vendor
    Gulf Gas Utility (placeholder)
    Account
    SYN-7010
    Bill
    B50179
    Invoice
    GULF-50179
    QUEUED_FOR_APPROVAL (not paid)
    Source rows
    • bills.csv:180

  9. Due 2026-10-10

    $4,248.69
    Property
    Cypress Court (synthetic)
    Utility
    water
    Vendor
    City Water Dept (placeholder)
    Account
    SYN-7003
    Bill
    B50054
    Invoice
    CITY-50054
    QUEUED_FOR_APPROVAL (not paid)
    Source rows
    • bills.csv:55

  10. Due 2026-10-11

    $1,246.39
    Property
    Bayou Flats (synthetic)
    Utility
    trash
    Vendor
    Haul-Rite Waste (placeholder)
    Account
    SYN-7008
    Bill
    B50144
    Invoice
    HAUL-50144
    QUEUED_FOR_APPROVAL (not paid)
    Source rows
    • bills.csv:145

  11. Due 2026-10-13

    $1,472.55
    Property
    Cypress Court (synthetic)
    Utility
    trash
    Vendor
    Haul-Rite Waste (placeholder)
    Account
    SYN-7004
    Bill
    B50072
    Invoice
    HAUL-50072
    QUEUED_FOR_APPROVAL (not paid)
    Source rows
    • bills.csv:73

  12. Due 2026-10-15

    $1,003.50
    Property
    Gaylord Ridge (synthetic)
    Utility
    trash
    Vendor
    Haul-Rite Waste (placeholder)
    Account
    SYN-7012
    Bill
    B50216
    Invoice
    HAUL-50216
    QUEUED_FOR_APPROVAL (not paid)
    Source rows
    • bills.csv:217