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 is a fiscal year 2024 financial detail report for the County of San Mateo documenting merchant credit card processing activities across multiple county departments and agencies. The report covers the period from July 1, 2023 through June 30, 2024 and provides transaction-level data for various county entities including the San Mateo Medical Center, County Recorder's Office, Environmental Health Services, Parks and Recreation, Sheriff's Office, and multiple healthcare clinics. During this period, the county processed a total of 198,813 transactions representing $16,440,033 in volume across all departments. The County of San Mateo Treasurer-Tax Collector's Office is currently seeking qualified merchant credit card service providers through an RFP with a target contract term of December 1, 2025 through November 30, 2028, with potential extension options. Proposals are due by 5:00 PM on July 18, 2025 and will be evaluated on vendor qualifications, experience, proposed approach, customer service capabilities, and cost.

The historical financial data demonstrates significant transaction activity with total processing fees of $432,141 (2.62% of transaction volume), comprising interchange fees of $184,380, assessments of $21,318, and Elavon processing fees of $226,443. The selected vendor must be PCI-DSS compliant and capable of implementing tokenization, encryption technologies, and fraud management tools across multiple county locations including Redwood City, San Mateo, San Carlos, and Half Moon Bay. The vendor must demonstrate integration capability with the county's EPIC electronic health record system and provide customer support during county business hours to handle transaction disputes and customer claims. Vendors are required to provide zero-cost equipment, software, and services, with transaction fees paid directly by individual user departments. Interested vendors must submit an ACH Authorization Agreement and provide references from at least three previous clients with comparable merchant card service experience. The RFP includes compliance requirements under Section 504 of the Rehabilitation Act of 1973 regarding non-discrimination practices based on disability.

View the file

Other files

File Type Posted
Merchant_Credit_Card_Services_(Addendum_#9_Revision).pdf PDF
Merchant_Credit_Card_Services_(Addendum_#9_Revision).pdf PDF
About_the_openepic_API_Program_for_Organizations_in_the_US.pdf PDF
About_the_openepic_API_Program_for_Organizations_in_the_US.pdf PDF
K._DPW_Parking_-_Addt_Info.pdf PDF
K._DPW_Parking_-_Addt_Info.pdf PDF
Debit_card_assumptions_FY25_.pdf PDF
Device_Counts.pdf PDF
Device_Counts.pdf PDF
Debit_card_assumptions_FY25_.pdf PDF
Merchant_Credit_Card_Services_(Addendum_#6_Revision).pdf PDF
April25_MID_Level_Detail.pdf PDF
FY24_MID_Level_Detail.pdf PDF
April25_MID_Level_Detail.pdf PDF
FY24_MID_Level_Detail.pdf PDF
April25_MID_Level_Detail.pdf PDF
References_Page.pdf PDF
References_Page.pdf PDF
References_Page.pdf PDF
ACH_Authorization_Agreement_form_04012022.pdf PDF
ACH_Authorization_Agreement_form_04012022.pdf PDF
ACH_Authorization_Agreement_form_04012022.pdf PDF
Attachment_H.pdf PDF
Attachment_H.pdf PDF
Attachment_H.pdf PDF
Attachment_I_504_Compliance.pdf PDF
Attachment_I_504_Compliance.pdf PDF
Attachment_I_504_Compliance.pdf PDF
Standard_Contract_Template_-_Over_$200K_DRAFT.docx DOCX document
Standard_Contract_Template_-_Under_$200K_DRAFT.docx DOCX document
Standard_Contract_Template_-_Over_$200K_DRAFT.docx DOCX document
Standard_Contract_Template_-_Under_$200K_DRAFT.docx DOCX document
Standard_Contract_Template_-_Under_$200K_DRAFT.docx DOCX document
Standard_Contract_Template_-_Over_$200K_DRAFT.docx DOCX document
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 .