A demonstration. This is not the city's website. It is a working proposal for the City of Pharr, built with the city's real seal, officials, departments and video. Every agenda item, vote, vehicle and dollar figure is invented, and each page says so. About this proposal Developed by Pragmatic Business Solutions, LLC (opens in a new tab), a Rio Grande City, TX custom software company.

City of Pharr Pride · Progress · Community · Learning
ENEspañol: ES

Staff dashboard

Utility billing — the counter

Opened when the window unlocks at eight and left open on the second monitor all day. This is a today screen; the twelve-month trends live below the fold.

Friday 4 September 2026, 8:00 a.m. · the cycle closes Tuesday at five

Needs attention this morning

  • Fourteen accounts are using more than twice their own average

    These are leaks until proven otherwise. Called before billing, the conversation is help. Called after billing, it is a dispute at the window.

    Open the call list

  • 84 accounts are without water on West Ferguson

    A main break this morning. They will call here, not Public Works. The notice went out in both languages at 6:40.

    See the affected accounts

  • Four accounts have been estimated three cycles running

    Two are buried meter boxes with work orders open. Two have no work order, which means nobody has actually been sent.

    Raise the two work orders

The numbers

Every tile links to the list that produced it. A number nobody can drill into is a brochure.

  • Active accounts

    21,480

    Water, wastewater and solid waste on one bill

    On target

  • Collected within 60 days

    96.8%

    Target is 96% · was 96.4% last month

    On target

  • Bills held before the cycle closes

    38

    Each one is a phone call that has to happen before Tuesday at five, or it becomes a bill somebody disputes at the window

    Watch

  • Possible leaks flagged this cycle

    14

    Usage more than double the account's own twelve-month average

    Action

  • Accounts eligible for shut-off

    112

    A count, not a list. The list is role-gated — in a city this size an address is close to a name.

    Watch

  • Median bill this cycle

    $41.20

    Up $2.10 on last cycle — the summer rate tier

    Waiting on someone else

  • Paid without coming to the window

    62%

    Was 38% before the account worked in Spanish on a phone

    On target

  • Estimated reads three cycles running

    4

    Somebody has to get an actual read before these bill again

    Action

Bills held — clear these before the cycle closes Tuesday at five

AccountService addressRouteWhy it is heldThis readWhat to do
ACCT-2041181408 W Ferguson AveR-07Using far more than usual28,400 gal · +241%Call before billing — main break on this block
ACCT-1983323117 S Cage BlvdR-02Read came back zero0 galCheck if the unit is vacant or the meter stopped
ACCT-211907820 W Sioux RdR-11No read — the meter box is buried—Work order to raise the box
ACCT-1877405 Las Milpas RdR-14Estimated three cycles runningestimated 6,800 galSomebody has to get an actual read
ACCT-2205141200 E Business 83C-03Final read pending — sold 28 August—Close the account and bill it
ACCT-224881704 N Jackson RdR-05New account, no history2,940 galConfirm the deposit posted

Over the fiscal year

October to September, because that is the Texas fiscal year. September is four days of a month — it is drawn, but it never sets a trend.

What people owe the water utilityThousands of dollars at month end. The over-90 block is the only bucket that costs the city real money, and it has fallen every month since payment arrangements were offered in both languages.
  • Current
  • 31 to 60 days
  • 61 to 90 days
  • Over 90 days
$0$1,000$2,000$3,000$4,000Current 1,71131 to 60 days 38661 to 90 days 175Over 90 days 442OctCurrent 1,64731 to 60 days 41961 to 90 days 189Over 90 days 469NovCurrent 1,58231 to 60 days 44261 to 90 days 212Over 90 days 497DecCurrent 1,56931 to 60 days 54361 to 90 days 285Over 90 days 603JanCurrent 1,54631 to 60 days 47861 to 90 days 248Over 90 days 653FebCurrent 1,66131 to 60 days 44261 to 90 days 221Over 90 days 635MarCurrent 1,76631 to 60 days 41961 to 90 days 202Over 90 days 607AprCurrent 1,87231 to 60 days 40561 to 90 days 189Over 90 days 580MayCurrent 1,98331 to 60 days 43261 to 90 days 198Over 90 days 557JunCurrent 2,10731 to 60 days 46961 to 90 days 216Over 90 days 543JulCurrent 2,07931 to 60 days 49761 to 90 days 235Over 90 days 524AugCurrent 2,02931 to 60 days 47861 to 90 days 225Over 90 days 511Sep
Table view
MonthCurrent31 to 60 days61 to 90 daysOver 90 days
Oct1,711386175442
Nov1,647419189469
Dec1,582442212497
Jan1,569543285603
Feb1,546478248653
Mar1,661442221635
Apr1,766419202607
May1,872405189580
Jun1,983432198557
Jul2,107469216543
Aug2,079497235524
Sep2,029478225511
How people paid the cityShare of payment transactions. Twenty-nine per cent at the window is still about 1,800 payments a month, and it is disproportionately older residents and people without a card. Do not close the window.
  • Counter at City Hall
  • Online
  • Phone
  • Mail and drop box
  • Bank bill-pay
0200400600Counter at City Hall 234%Online 81%Phone 40.5%Mail and drop box 63%Bank bill-pay 31.5%OctCounter at City Hall 225%Online 90%Phone 45%Mail and drop box 58%Bank bill-pay 31.5%NovCounter at City Hall 212%Online 104%Phone 49.5%Mail and drop box 58%Bank bill-pay 27%DecCounter at City Hall 202%Online 112%Phone 54%Mail and drop box 54%Bank bill-pay 27%JanCounter at City Hall 189%Online 126%Phone 54%Mail and drop box 54%Bank bill-pay 27%FebCounter at City Hall 176%Online 140%Phone 58%Mail and drop box 49.5%Bank bill-pay 27%MarCounter at City Hall 166%Online 148%Phone 58%Mail and drop box 49.5%Bank bill-pay 27%AprCounter at City Hall 158%Online 158%Phone 63%Mail and drop box 45%Bank bill-pay 27%MayCounter at City Hall 153%Online 162%Phone 63%Mail and drop box 45%Bank bill-pay 27%JunCounter at City Hall 144%Online 171%Phone 68%Mail and drop box 40.5%Bank bill-pay 27%JulCounter at City Hall 140%Online 176%Phone 68%Mail and drop box 40.5%Bank bill-pay 27%AugCounter at City Hall 130%Online 184%Phone 68%Mail and drop box 40.5%Bank bill-pay 27%Sep
Table view
MonthCounter at City HallOnlinePhoneMail and drop boxBank bill-pay
Oct234%81%40.5%63%31.5%
Nov225%90%45%58%31.5%
Dec212%104%49.5%58%27%
Jan202%112%54%54%27%
Feb189%126%54%54%27%
Mar176%140%58%49.5%27%
Apr166%148%58%49.5%27%
May158%158%63%45%27%
Jun153%162%63%45%27%
Jul144%171%68%40.5%27%
Aug140%176%68%40.5%27%
Sep130%184%68%40.5%27%

The other views