Executive Dashboard

Overview / Dashboard
Total Collections
$14.8M
▲ 12.3%vs prior period
Transaction Count
48,291
▲ 8.7%vs prior period
Avg Transaction
$306.52
▲ 3.4%vs prior period
Online Adoption
67.4%
▲ 5.1 ptsYoY growth
Service Fees Collected
$371.2K
▲ 11.8%vs prior period

Monthly Collection Trend

Revenue by Department

Payment Channel Mix

Payment Method Distribution

Recent High-Value Transactions

DateTransaction IDDepartmentTypePayerAmountMethodStatus
Gross Collections
$14,802,417
▲ 12.3%vs prior period
Net to County
$14,431,167
After fees & refunds
Refunds Issued
$48,320
▼ 2.1%of gross
YTD Collection Rate
91.6%
▲ 1.8 ptsvs target 90%

Collections: Current Year vs Prior Year

Revenue by Payment Type

Cumulative Collections vs Budget

Top Revenue Categories

Property Tax$9,241,006
Utility Payments$2,812,400
Business Licenses$1,180,300
Traffic Violations$892,100
Permits & Fees$676,611

Collection Efficiency

Property Tax Rate94.2%
Utility Rate88.7%
License/Permit Rate96.1%
Traffic/Court Rate72.3%
Overall Rate91.6%

Period Comparison

Current Period$14.8M
Prior Period$13.2M
Variance+$1.6M
Budget Target$16.2M
Budget Attainment91.4%
Property Tax
$9.24M
62.4% of total
Utilities
$2.81M
19.0% of total
Business Licenses
$1.18M
8.0% of total
Traffic & Court
$892K
6.0% of total
Permits & Fees
$677K
4.6% of total

Monthly Trend by Department

Department Share of Collections

Department Performance Summary

DepartmentTransactionsGross AmountNet AmountAvg TxnCollection RateYoY Change
Property Tax18,412$9,241,006$9,010,181$501.9094.2%+14.1%
Utility Payments16,280$2,812,400$2,742,090$172.7588.7%+6.3%
Business Licenses4,120$1,180,300$1,150,793$286.4896.1%+18.4%
Traffic & Court6,840$892,100$869,798$130.4172.3%-2.8%
Permits & Fees2,639$676,611$659,696$256.3991.0%+22.6%
Credit Card
52.3%
25,242 txns | $8.14M
Debit Card
28.1%
13,570 txns | $3.82M
E-Check / ACH
19.6%
9,479 txns | $2.84M

Payment Method Trend (Monthly)

Average Transaction by Method

Online vs In-Office Payments

Fee Revenue by Method

Credit Card Breakdown

Visa48.2%
Mastercard31.6%
Amex12.4%
Discover7.8%

Processing Metrics

Approval Rate97.8%
Decline Rate1.9%
Chargeback Rate0.08%
Avg Settlement Time1.8 days

E-Check Performance

Success Rate96.2%
NSF Returns3.1%
Avg Settlement3.2 days
Avg E-Check Amt$299.47

Transaction Detail Report

Date & Time Transaction ID Reference # Department Payment Type Payer Name Method Gross Amount Service Fee Net Amount Status
Reconciliation compares Government Window settlement amounts against county general ledger entries. Last reconciled: March 7, 2026.
GW Settlement Total
$2,418,306
Current period
GL Recorded Total
$2,417,842
County ledger
Variance
$464
0.02% difference
Matched Rate
99.4%
6,218 of 6,255 txns

Settlement Summary

Total Settlements12
Settlement Amount$2,418,306
Fees Deducted$60,458
Net Deposited$2,357,848
Refunds($4,210)

GL Reconciliation

GL Revenue Entries$2,417,842
GL Fee Expense$60,422
GL Net$2,357,420
Bank Deposit$2,357,848
Outstanding$428

Reconciliation Status

Matched6,218
Unmatched37
Timing Differences22
Exceptions15
Match Rate99.4%

Daily Settlement vs GL Posting

Total Settled (Period)
$2,357,848
Net after fees
Avg Settlement Time
1.8 days
Business days
Pending Settlement
$142,306
In transit
Settlements This Month
4
Next: Mar 12

Settlement Batches

Settlement IDDatePeriodGross AmountFeesRefundsNet DepositTxn CountBank RefStatus
STL-2026-0308Mar 8, 2026Mar 3–7$218,490$5,462($310)$212,718742ACH-88412Deposited
STL-2026-0301Mar 1, 2026Feb 24–28$196,210$4,905($520)$190,785668ACH-88290Deposited
STL-2026-0222Feb 22, 2026Feb 17–21$184,630$4,616($180)$179,834614ACH-88105Deposited
STL-2026-0215Feb 15, 2026Feb 10–14$201,890$5,047($440)$196,403690ACH-87981Deposited
STL-2026-0208Feb 8, 2026Feb 3–7$178,420$4,461($290)$173,669592ACH-87842Deposited
STL-2026-0201Feb 1, 2026Jan 27–31$210,340$5,259($610)$204,471718ACH-87710Deposited
STL-2026-0125Jan 25, 2026Jan 20–24$192,080$4,802($150)$187,128644ACH-87588Deposited
STL-2026-0118Jan 18, 2026Jan 13–17$188,740$4,719($380)$183,641628ACH-87452Deposited
STL-2026-0312Mar 12, 2026Mar 8–11$142,306$3,558$138,748482Pending

Weekly Settlement Amounts

GovernmentWindow charges a 2.5% service fee (minimum $1.50) on all card payments. This fee is paid by the citizen and does not reduce county revenue.
Total Fees Collected
$371,250
2.5% of gross
Avg Fee per Txn
$7.69
Min $1.50
Minimum-Fee Txns
8,412
17.4% of txns (under $60)
Effective Fee Rate
2.51%
Slightly above 2.5% due to min fee

Fee Revenue by Month

Fee Distribution by Department

Transaction Amount Distribution (Fee Impact)