FY24_MID_Level_Detail.pdf
PDF 210 KB Posted
- Attached to
- Merchant Credit Card Services
- Solicitation number
- 15200-25-002
- Issued by
- San Mateo County, San Bernardino City, California
About this file
This document is a detailed financial report for the County of San Mateo, California, covering merchant credit card transaction activity for fiscal year 2024 (July 1, 2023 - June 30, 2024). The report encompasses transaction data for multiple county departments and facilities across various locations including San Mateo, Redwood City, Half Moon Bay, South San Francisco, and San Carlos, with a comprehensive breakdown of transaction volumes, average ticket sizes, downgrades, interchange fees, assessments, and total fees for each merchant location.
The financial analysis reveals a grand total of 198,813 transactions generating $16,440,033 in volume, with total fees of $432,141, representing an average fee of 2.62% per transaction. Notable insights include significant variation in transaction volumes across departments, with some locations like San Mateo County Planning showing high-value transactions but varied fee structures. The Environmental Health Services department demonstrates particularly high downgrade percentages, with one location experiencing a 32.1% downgrade rate. The overall fee structure shows consistent patterns of interchange, assessment, and Elavon fees across different county departments, suggesting a standardized merchant services approach for the county's financial operations.
View the file
Other files
Show all 34
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Values
CHN_NUM EXTERNAL_MID MER_DBA_TXT DBA_ADDR_CITY Items Volume Avg_Ticket Downgrade $ Downgrade % Interchange Assessments Elavon Fees Total Fees ITX/Vol ASM/Vol Elavon/Vol Total Fees/Vol ITX+ASM/ Total Fees
1030 XXXXXX7411 SMMC COASTSIDE CLINIC HALF MOON BAY 113 5,642$ 49.93$ -$ 0.0% 38$ 5$ 758$ 802$ 0.68% 0.10% 13.44% 14.22% 5.4%
XXXXX5526 SMMC FAIR OAKS HLTH 2ndFL REDWOOD CITY 175 5,028$ 28.73$ -$ 0.0% 58$ 7$ 753$ 817$ 1.14% 0.14% 14.97% 16.25% 7.9%
XXXXXX13213 CAFE 39 SAN MATEO 63,397 403,353$ 6.36$ 64$ 0.0% 11,875$ 1,844$ 23,375$ 37,094$ 2.94% 0.46% 5.79% 9.20% 37.0%
XXXXXX5377 SMMC BUSINESS SERVICES SAN MATEO 686 510,269$ 743.83$ 51,882$ 10.2% 9,282$ 783$ 3,216$ 13,281$ 1.82% 0.15% 0.63% 2.60% 75.8%
XXXXXX5492 SMMC INNOVATIVE CLINIC SAN MATEO 271 10,115$ 37.48$ 85$ 0.8% 96$ 45$ 726$ 867$ 0.95% 0.45% 7.17% 8.57% 16.3%
XXXXXX5500 SMCMC NORTH CNTY HEALTH DALY CITY 148 6,500$ 44.35$ -$ 0.0% 61$ 7$ 890$ 959$ 0.94% 0.11% 13.65% 14.70% 7.2%
XXXXXX5468 SMCMC MEDICAL IMD CLINIC SAN MATEO 96 4,440$ 46.25$ 185$ 4.2% 69$ 7$ 762$ 838$ 1.55% 0.15% 17.16% 18.87% 9.0%
XXXXXX5435 SMCMC RRSCC SAN MATEO 52 2,405$ 46.25$ 15$ 0.6% 36$ 4$ 754$ 793$ 1.48% 0.16% 31.35% 32.99% 5.0%
XXXXXX9700 SO SAN FRANCISCO CLINIC SOUTH SAN FRANCISCO 58 2,190$ 37.76$ 15$ 0.7% 21$ 3$ 900$ 923$ 0.94% 0.11% 41.08% 42.13% 2.5%
XXXXXX5534 SMMC FAIR OAKS HLTH 3RDFL REDWOOD CITY 70 6,107$ 87.24$ -$ 0.0% 50$ 5$ 986$ 1,041$ 0.82% 0.08% 16.14% 17.04% 5.3%
XXXXXX5476 SMCMC OB GYN CLINIC SAN MATEO 54 3,525$ 66.79$ 15$ 0.4% 24$ 19$ 753$ 795$ 0.67% 0.52% 21.26% 22.46% 5.3%
XXXXXX5427 SMCMC PRE ADMIT SAN MATEO 60 9,130$ 152.17$ -$ 0.0% 83$ 7$ 716$ 806$ 0.91% 0.07% 7.84% 8.83% 11.1%
XXXXXX5393 SMCMC PHARMACY SAN MATEO 1,887 57,182$ 30.30$ 35$ 0.1% 746$ 134$ 842$ 1,722$ 1.31% 0.23% 1.47% 3.01% 51.1%
XXXXXX5450 SMCMC SPECIALTY CLINIC SAN MATEO 275 10,778$ 39.63$ -$ 0.0% 119$ 15$ 728$ 863$ 1.10% 0.14% 6.73% 7.97% 15.6%
XXXXXX6776 SMMC REV COLLECTION IVR SAN MATEO 3,622 597,475$ 165.05$ 1,475$ 0.2% 8,872$ 1,088$ 792$ 10,753$ 1.48% 0.18% 0.13% 1.80% 92.6%
XXXXXX5401 SMCMC EMERGENCY ROOM SAN MATEO 711 118,587$ 168.83$ 2,906$ 2.4% 1,429$ 255$ 1,162$ 2,847$ 1.20% 0.21% 0.97% 2.38% 59.2%
XXXXXX4483 SMMC SEQUOIA TEEN WELLNESS REDWOOD CITY 0 -$ -$ -$ -$ 780$ 780$ 0.0%
XXXXXX1343 SMMC FAIR OAKS HLTH 1STFL REDWOOD CITY 0 -$ -$ -$ -$ 780$ 780$ 0.0%
XXXXXX6271 SMCMC RADIOLOGY SAN MATEO 0 -$ -$ -$ -$ 1,020$ 1,020$ 0.0%
XXXXXX7403 SMMC PEDIATRIC CLINIC SAN MATEO 0 -$ -$ -$ -$ 780$ 780$ 0.0%
XXXXXX9623 SMMC REHABILATION SERVICES SAN MATEO 5 60$ 12.00$ -$ 0.0% 1$ 0$ 780$ 781$ 1.70% 0.32% 1299.37% 1301.38% 0.2%
1030 Total 71,680 1,752,786$ 24.47$ 56,677$ 3.2% 32,861$ 4,227$ 42,253$ 79,340$ 1.87% 0.24% 2.41% 4.52% 46.7%
1023 XXXXXX0003185048 SAN MATEO COUNTY RECORDER SPECIA REDWOOD CITY 9,308 562,230$ 60.41$ 1,419$ 0.3% 7,624$ 927$ 4,609$ 13,160$ 1.36% 0.16% 0.82% 2.34% 65.0%
XXXXX0003185055 SAN MATEO COUNTY RECORDER CUSTOM REDWOOD CITY 2,063 58,055$ 28.16$ 29$ 0.0% 914$ 165$ 1,190$ 2,269$ 1.57% 0.28% 2.05% 3.91% 47.5%
XXXXXX0003185063 SAN MATEO COUNTY RECORDER VITAL REDWOOD CITY 5,598 283,063$ 50.59$ 192$ 0.1% 3,899$ 519$ 2,558$ 6,976$ 1.38% 0.18% 0.90% 2.46% 63.3%
XXXXXX0003185030 SAN MATEO COUNTY RECORDER RECORD REDWOOD CITY 2,141 222,284$ 104.00$ 311$ 0.1% 3,253$ 345$ 1,747$ 5,345$ 1.46% 0.16% 0.79% 2.40% 67.3%
XXXXXX2503 SMC ELECTIONS SAN MATEO 11 30,185$ 3,887.22$ 7,000$ 20.0% 536$ 54$ 786$ 1,375$ 1.53% 0.15% 2.25% 3.93% 42.9%
1023 Total 19,121 1,155,816$ 60.73$ 8,951$ 0.8% 16,225$ 2,010$ 10,890$ 29,124$ 1.40% 0.17% 0.94% 2.51% 62.6%
1022 XXXXXX8148 SMC SO FIREARMS RANGE REDWOOD CITY 415 13,862$ 33.81$ 124$ 0.9% 214$ 39$ 555$ 808$ 1.53% 0.28% 3.98% 5.78% 31.3%
XXXXXX1176 ENVIRONMENTAL HEALTH SERVICES SAN MATEO 438 419,984$ 983.36$ 1,747$ 0.4% 4,520$ 410$ 845$ 5,775$ 1.06% 0.10% 0.20% 1.36% 85.4%
XXXXXX8667 SAN MATEO COUNTY PLANNING REDWOOD CITY 5,599 3,667,083$ 655.75$ 48,802$ 1.3% -$ -$ -$ -$ 0.00% 0.00% 0.00% 0.00%
XXXXXX4412 VRS CATERING CONNECTION SAN CARLOS 207 44,083$ 216.37$ 846$ 1.9% 723$ 70$ 813$ 1,605$ 1.64% 0.16% 1.84% 3.64% 49.4%
XXXXXX7400 SAN MATEO COUNTY PLANNING SERVIC KNOXVILLE 5,594 110,051$ 19.67$ 1,465$ 1.3% -$ -$ 110,051$ 110,051$ 0.00% 0.00% 100.00% 100.00% 0.0%
XXXXXX9970200060 SAN MATEO CNTY BLDG PLN REDWOOD CITY 157 156,320$ 1,042.66$ 7,073$ 4.3% 2,551$ 249$ 489$ 3,290$ 1.57% 0.15% 0.30% 2.02% 85.1%
XXXXXX9747 EDISON CLINICS SAN MATEO 154 4,532$ 29.78$ -$ 0.0% 64$ 10$ 840$ 913$ 1.40% 0.21% 18.43% 20.04% 8.0%
XXXXXX9970200219 SAN MATEO PARKS MARINA REDWOOD CITY 47,206 467,211$ 9.92$ 41,298$ 8.8% 12,523$ 2,540$ 31,516$ 46,578$ 2.68% 0.54% 6.73% 9.95% 32.3%
XXXXXX5815 SMC PUBLIC WORKS PARKING REDWOOD CITY 33,882 72,998$ 2.15$ 1,002$ 1.4% 2,638$ 813$ 13,359$ 16,811$ 3.61% 1.11% 18.30% 23.03% 20.5%
XXXXXX0960 MOBILE CLINIC SAN MATEO 144 5,048$ 35.48$ -$ 0.0% 63$ 10$ 612$ 685$ 1.24% 0.19% 12.07% 13.50% 10.6%
XXXXXX9970200284 SMC ENVIRONMENTAL HEALTH SAN MATEO 2,065 1,846,325$ 901.12$ 21,441$ 1.2% 26,871$ 2,838$ 4,001$ 33,710$ 1.45% 0.15% 0.22% 1.82% 88.1%
XXXXXX9970200185 SAN MATEO CO AIRPORT SAN CARLOS 623 38,363$ 61.58$ 23,500$ 61.3% 960$ 135$ 401$ 1,497$ 2.50% 0.35% 1.05% 3.90% 73.2%
XXXXXX9721 EMS AGENCY S SAN FRAN 273 26,930$ 103.06$ -$ 0.0% 324$ 64$ 601$ 988$ 1.18% 0.23% 2.18% 3.59% 39.2%
XXXXXX7258 DEPT OF AGRICULTURE W AND M REDWOOD CITY 258 7,980$ 31.15$ 230$ 2.9% 171$ 24$ 343$ 538$ 2.13% 0.30% 4.28% 6.72% 36.2%
XXXXXX9671 VITAL STATISTICS AC PHLAB SAN MATEO 5,022 435,655$ 86.83$ 375$ 0.1% 6,834$ 747$ 3,847$ 11,427$ 1.57% 0.17% 0.88% 2.62% 66.3%
XXXXXX7702 ENVIRONMENTAL HEALTH SERVICES SAN MATEO 4,303 3,579,881$ 840.21$ 1,154,409$ 32.1% 75,387$ 7,004$ 2,531$ 84,922$ 2.10% 0.20% 0.07% 2.36% 97.0%
XXXXXX7536 SMC DPT OF AG W AND M DEVICE REDWOOD CITY 413 168,962$ 409.11$ 234$ 0.1% 1,445$ 128$ 392$ 1,965$ 0.86% 0.08% 0.23% 1.16% 80.1%
XXXXXX7744 PUBLIC HEALTH LAB SAN MATEO 8 284$ 35.50$ -$ 0.0% 7$ 1$ 770$ 777$ 2.37% 0.19% 271.08% 273.64% 0.9%
XXXXXX1313 VRS CATERING CONNECTION ONLINE SAN CARLOS 0 -$ -$ -$ -$ 420$ 420$ 0.0%
XXXXXX6200 SMC SHERIFF RECORDS SCL REDWOOD CITY 0 -$ -$ -$ -$ -$ -$
XXXXXX3051 SAN MATEO COUNTY PLAN ACH REDWOOD CITY 1,105 2,461,383$ 2,227.50$ -$ 0.0% -$ -$ 5$ 5$ 0.00% 0.00% 0.00% 0.00% 0.0%
XXXXXX7925 SMC SHERIFF RECORD UNINFE ATLANTA 0 -$ -$ -$ -$ -$ -$
XXXXXX2860 SMC SHERIFF RECORDS HMBFEE REDWOOD CITY 0 -$ -$ -$ -$ -$ -$
XXXXXX0884 SAN MATEO COUNTY AGING AND ADULT SAN MATEO 146 4,495$ 30.79$ -$ 0.0% 0$ -$ 370$ 370$ 0.00% 0.00% 8.24% 8.24% 0.0%
XXXXXX8250 SAN MATEO COUNTY AIRPORTS SAN CARLOS 0 -$ -$ -$ -$ 540$ 540$ 0.0%
XXXXXX8628 SMC SHERIFF RECORDS SCLFEE ATLANTA 0 -$ -$ -$ -$ -$ -$
XXXXXX0633 SMC SHERIFF RECORDS MILL REDWOOD CITY 0 -$ -$ -$ -$ -$ -$
XXXXXX3734 SMC SHERIFF RECORDS UNINC REDWOOD CITY 0 -$ -$ -$ -$ -$ -$
XXXXXX0591 SMC SHERIFF RECORDS MILLFEE ATLANTA 0 -$ -$ -$ -$ -$ -$
XXXXXX0476 SMC SHERIFF RECORDS HMB REDWOOD CITY 0 -$ -$ -$ -$ -$ -$
1022 Total 108,012 13,531,430$ 125.65$ 1,302,546$ 9.6% 135,294$ 15,081$ 173,301$ 323,676$ 1.00% 0.11% 1.28% 2.39% 46.5%
Grand Total 198,813 16,440,033$ 82.92$ 1,368,174$ 8.3% 184,380$ 21,318$ 226,443$ 432,141$ 1.12% 0.13% 1.37% 2.62% 47.6%
Stats Fees % of Fees
San Mateo County - All County Depts FY24 Activity
Fiscal Year 2024: 07/01/2023-06/30/2024
Stats Fees % of Fees
Values
CHN_NUM EXTERNAL_MID MER_DBA_TXT DBA_ADDR_CITY Items Volume Avg_Ticket Downgrade $ Downgrade % Interchange Assessments Elavon Fees Total Fees ITX/Vol ASM/Vol Elavon/Vol Total Fees/Vol ITX+ASM/ Total Fees
0 XXXXXX3506 COUNTY OF SAN MATEO REDWOOD CITY 2,169 705,806$ 326.68$ 29,565$ 4.2% 8,477$ 1,121$ 361$ 9,958$ 1.20% 0.16% 0.05% 1.41% 96.4%
0 Total 2,169 705,806$ 326.68$ 29,565$ 4.2% 8,477$ 1,121$ 361$ 9,958$ 1.20% 0.16% 0.05% 1.41% 96.4%
Grand Total 2,169 705,806$ 326.68$ 29,565$ 4.2% 8,477$ 1,121$ 361$ 9,958$ 1.20% 0.16% 0.05% 1.41% 96.4%
File details come from the government source that posted it. Updated .