April25_MID_Level_Detail.pdf

PDF 223 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 transactional detail report for Merchant Credit Card Services provided by Elavon to the County of San Mateo for April 2025, supporting the County's Request for Proposals for comprehensive merchant credit card processing services. The report documents payment processing activity across multiple county departments, including the County Clerk-Recorder, Parks and Recreation, Public Works, Sheriff's Office, Environmental Health Services, and San Mateo Medical Center (SMMC). The data encompasses three primary merchant service groups (1022, 1030, and 1023) representing distinct operational units within county government. For the reporting period, the county processed a total of 21,180 items generating $1,861,499 in transaction volume with an average ticket size of $87.96. The SMMC MedEpay Group (6695) processed an additional 287 items valued at $85,401. The contract term runs from December 1, 2025, through November 30, 2028, with potential extension options available.

The transactional data reveals total fees of $45,984 across all county operations for April 2025, comprising interchange fees ($18,456), assessments ($2,775), and Elavon processing fees ($24,753), representing 2.47 percent of total transaction volume. Individual department performance varies significantly, with Environmental Health Services generating the highest transaction volume ($530,473) and SMMC Parks Marina processing the most items (6,361 transactions). Downgrade charges totaled $67,308, representing 3.6 percent of volume, with the highest downgrades occurring in Environmental Health Services ($53,870) and Parks Marina ($7,456). Historical fiscal year 2024 data indicates annual transaction volume of $16,440,033 with 198,813 transactions and total fees of $432,141. The selected vendor must be PCI-DSS compliant, implement tokenization and encryption technologies, provide fraud management tools, and integrate with existing systems including the EPIC electronic health record system. Vendors must provide references from three previous clients with similar merchant card service experience and submit proposals by July 18, 2025.

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
FY24_MID_Level_Detail.pdf PDF
April25_MID_Level_Detail.pdf PDF
FY24_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_-_Under_$200K_DRAFT.docx DOCX document
Standard_Contract_Template_-_Over_$200K_DRAFT.docx DOCX document
Standard_Contract_Template_-_Over_$200K_DRAFT.docx DOCX document
Standard_Contract_Template_-_Under_$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

1022 XXXXX8667 SAN MATEO COUNTY PLANNING REDWOOD CITY 516 477,419$ 934.48$ 4,447$ 0.9% -$ -$ -$ -$ 0.00% 0.00% 0.00% 0.00%

XXXXXX9671 VITAL STATISTICS AC PHLAB SAN MATEO 552 60,908$ 110.34$ 60$ 0.1% 986$ 106$ 408$ 1,501$ 1.62% 0.17% 0.67% 2.46% 72.8%

XXXXXX7925 SMC SHERIFF RECORD UNINFE ATLANTA 64 26$ 0.41$ -$ 0.0% -$ -$ 26$ 26$ 0.00% 0.00% 100.00% 100.00% 0.0%

XXXXXX7400 SAN MATEO COUNTY PLANNING SERVICKNOXVILLE 512 14,354$ 28.03$ 133$ 0.9% -$ -$ 14,354$ 14,354$ 0.00% 0.00% 100.00% 100.00% 0.0%

XXXXXX9970200060 SAN MATEO CNTY BLDG PLN REDWOOD CITY 9 3,896$ 432.86$ -$ 0.0% 71$ 7$ 57$ 135$ 1.82% 0.19% 1.46% 3.47% 57.9%

XXXXXX9970200185 SAN MATEO CO AIRPORT SAN CARLOS 36 2,000$ 55.56$ 300$ 15.0% 40$ 6$ 20$ 67$ 2.02% 0.32% 1.00% 3.34% 70.1%

XXXXXX3734 SMC SHERIFF RECORDS UNINC REDWOOD CITY 66 1,067$ 16.58$ -$ 0.0% -$ -$ -$ -$ 0.00% 0.00% 0.00% 0.00%

XXXXXX4412 VRS CATERING CONNECTION SAN CARLOS 5 100$ 20.05$ -$ 0.0% 2$ 0$ 59$ 61$ 2.05% 0.25% 58.83% 61.12% 3.8%

XXXXXX0591 SMC SHERIFF RECORDS MILLFEE ATLANTA 17 15$ 0.90$ -$ 0.0% -$ -$ 15$ 15$ 0.00% 0.00% 100.00% 100.00% 0.0%

XXXXXX8628 SMC SHERIFF RECORDS SCLFEE ATLANTA 9 8$ 0.94$ -$ 0.0% -$ -$ 8$ 8$ 0.00% 0.00% 100.00% 100.00% 0.0%

XXXXXX5815 SMC PUBLIC WORKS PARKING REDWOOD CITY 2,894 5,813$ 2.01$ 82$ 1.4% 216$ 75$ 1,141$ 1,432$ 3.71% 1.29% 19.63% 24.63% 20.3%

XXXXXX9721 EMS AGENCY S SAN FRAN 26 2,718$ 104.54$ -$ 0.0% 30$ 6$ 50$ 86$ 1.09% 0.23% 1.83% 3.15% 41.8%

XXXXXX9747 EDISON CLINICS SAN MATEO 5 192$ 38.40$ -$ 0.0% 2$ 0$ 70$ 72$ 1.01% 0.13% 36.45% 37.58% 3.0%

XXXXXX7258 DEPT OF AGRICULTURE W AND MREDWOOD CITY 7 190$ 27.14$ -$ 0.0% 4$ 1$ 19$ 24$ 2.06% 0.27% 10.24% 12.57% 18.5%

XXXXXX7536 SMC DPT OF AG W AND M DEVICEREDWOOD CITY 56 32,254$ 575.96$ 379$ 1.2% 301$ 28$ 55$ 384$ 0.93% 0.09% 0.17% 1.19% 85.7%

XXXXXX0960 MOBILE CLINIC SAN MATEO 7 435$ 62.14$ -$ 0.0% 2$ 0$ 51$ 54$ 0.55% 0.04% 11.72% 12.31% 4.8%

XXXXXX0633 SMC SHERIFF RECORDS MILL REDWOOD CITY 17 616$ 36.26$ -$ 0.0% -$ -$ -$ -$ 0.00% 0.00% 0.00% 0.00%

XXXXXX7702 ENVIRONMENTAL HEALTH SERVICESSAN MATEO 575 530,473$ 922.56$ 53,870$ 10.2% 10,161$ 1,452$ 812$ 12,425$ 1.92% 0.27% 0.15% 2.34% 93.5%

XXXXXX9970200219 SAN MATEO PARKS MARINA REDWOOD CITY 6,361 51,150$ 8.04$ 7,456$ 14.6% 1,515$ 374$ 2,365$ 4,254$ 2.96% 0.73% 4.62% 8.32% 44.4%

XXXXXX9970200284 SMC ENVIRONMENTAL HEALTH SAN MATEO 165 132,900$ 805.45$ 100$ 0.1% 1,796$ 231$ 248$ 2,275$ 1.35% 0.17% 0.19% 1.71% 89.1%

XXXXXX1313 VRS CATERING CONNECTION ONLINESAN CARLOS 0 -$ -$ -$ -$ 35$ 35$ 0.0%

XXXXXX8148 SMC SO FIREARMS RANGE REDWOOD CITY 45 1,405$ 31.22$ -$ 0.0% 22$ 5$ 68$ 95$ 1.54% 0.35% 4.87% 6.75% 27.9%

XXXXXX6200 SMC SHERIFF RECORDS SCL REDWOOD CITY 8 337$ 42.13$ -$ 0.0% -$ -$ -$ -$ 0.00% 0.00% 0.00% 0.00%

XXXXXX2860 SMC SHERIFF RECORDS HMBFEE REDWOOD CITY 5 5$ 0.90$ -$ 0.0% -$ -$ 5$ 5$ 0.00% 0.00% 100.00% 100.00% 0.0%

XXXXXX0476 SMC SHERIFF RECORDS HMB REDWOOD CITY 5 180$ 36.00$ -$ 0.0% -$ -$ -$ -$ 0.00% 0.00% 0.00% 0.00%

XXXXXX3051 SAN MATEO COUNTY PLAN ACH REDWOOD CITY 132 347,112$ 2,629.64$ -$ 0.0% -$ -$ 1$ 1$ 0.00% 0.00% 0.00% 0.00% 0.0%

XXXXXX8250 SAN MATEO COUNTY AIRPORTS SAN CARLOS 0 -$ -$ -$ -$ 52$ 52$ 0.0%

XXXXXX0884 SAN MATEO COUNTY AGING AND ADULTSAN MATEO 0 -$ -$ -$ -$ -$ -$

1022 Total 12,094 1,665,573$ 137.86$ 66,828$ 4.0% 15,149$ 2,292$ 19,920$ 37,361$ 0.91% 0.14% 1.20% 2.24% 46.7%

1030 XXXXXX5377 SMMC BUSINESS SERVICES SAN MATEO 9 2,593$ 288.08$ -$ 0.0% 66$ 5$ 114$ 185$ 2.53% 0.20% 4.38% 7.12% 38.4%

XXXXXX6776 SMMC REV COLLECTION IVR SAN MATEO 289 35,735$ 123.65$ -$ 0.0% 387$ 78$ 60$ 525$ 1.08% 0.22% 0.17% 1.47% 88.7%

XXXXXX3213 CAFE 39 SAN MATEO 6,627 43,905$ 6.63$ -$ 0.0% 1,255$ 203$ 2,403$ 3,861$ 2.86% 0.46% 5.47% 8.80% 37.8%

XXXXXX5393 SMCMC PHARMACY SAN MATEO 123 2,823$ 22.95$ -$ 0.0% 44$ 6$ 57$ 107$ 1.57% 0.22% 2.01% 3.81% 47.1%

XXXXXX4483 SMMC SEQUOIA TEEN WELLNESSREDWOOD CITY 0 -$ -$ -$ -$ 65$ 65$ 0.0%

XXXXXX9700 SO SAN FRANCISCO CLINIC SOUTH SAN FRANCISCO 0 -$ -$ -$ -$ 75$ 75$ 0.0%

XXXXXX6271 SMCMC RADIOLOGY SAN MATEO 0 -$ -$ -$ -$ 85$ 85$ 0.0%

XXXXXX5500 SMCMC NORTH CNTY HEALTH DALY CITY 0 -$ -$ -$ -$ 65$ 65$ 0.0%

XXXXXX5468 SMCMC MEDICAL IMD CLINIC SAN MATEO 0 -$ -$ -$ -$ 65$ 65$ 0.0%

XXXXXX7403 SMMC PEDIATRIC CLINIC SAN MATEO 0 -$ -$ -$ -$ 65$ 65$ 0.0%

XXXXXX5534 SMMC FAIR OAKS HLTH 3RDFL REDWOOD CITY 0 -$ -$ -$ -$ 85$ 85$ 0.0%

XXXXXX5492 SMMC INNOVATIVE CLINIC SAN MATEO 0 -$ -$ -$ -$ 65$ 65$ 0.0%

XXXXXX5526 SMMC FAIR OAKS HLTH 2ndFL REDWOOD CITY 0 -$ -$ -$ -$ 65$ 65$ 0.0%

XXXXXX1343 SMMC FAIR OAKS HLTH 1STFL REDWOOD CITY 0 -$ -$ -$ -$ 65$ 65$ 0.0%

XXXXXX5401 SMCMC EMERGENCY ROOM SAN MATEO 0 -$ -$ -$ -$ 85$ 85$ 0.0%

XXXXXX5450 SMCMC SPECIALTY CLINIC SAN MATEO 0 -$ -$ -$ -$ 65$ 65$ 0.0%

XXXXXX7411 SMMC COASTSIDE CLINIC HALF MOON BAY 0 -$ -$ -$ -$ 65$ 65$ 0.0%

XXXXXX9623 SMMC REHABILATION SERVICES SAN MATEO 0 -$ -$ -$ -$ 65$ 65$ 0.0%

XXXXXX5427 SMCMC PRE ADMIT SAN MATEO 0 -$ -$ -$ -$ 65$ 65$ 0.0%

XXXXXX5476 SMCMC OB GYN CLINIC SAN MATEO 0 -$ -$ -$ -$ 65$ 65$ 0.0%

XXXXXX5435 SMCMC RRSCC SAN MATEO 0 -$ -$ -$ -$ 65$ 65$ 0.0%

1030 Total 7,048 85,055$ 12.07$ -$ 0.0% 1,753$ 293$ 3,808$ 5,854$ 2.06% 0.34% 4.48% 6.88% 34.9%

1023 XXXXXX0003185055 SAN MATEO COUNTY RECORDER CUSTOMREDWOOD CITY 191 5,392$ 28.23$ -$ 0.0% 90$ 13$ 91$ 193$ 1.66% 0.23% 1.69% 3.58% 52.9%

XXXXXX0003185030 SAN MATEO COUNTY RECORDER RECORDREDWOOD CITY 211 16,969$ 80.42$ 26$ 0.2% 260$ 31$ 141$ 432$ 1.53% 0.18% 0.83% 2.54% 67.3%

XXXXXX0003185063 SAN MATEO COUNTY RECORDER VITALREDWOOD CITY 550 24,869$ 45.22$ -$ 0.0% 331$ 41$ 222$ 595$ 1.33% 0.17% 0.89% 2.39% 62.6%

XXXXXX0003185048 SAN MATEO COUNTY RECORDER SPECIAREDWOOD CITY 1,086 63,641$ 58.60$ 454$ 0.7% 874$ 106$ 505$ 1,484$ 1.37% 0.17% 0.79% 2.33% 66.0%

XXXXXX2503 SMC ELECTIONS SAN MATEO 0 -$ -$ -$ -$ 65$ 65$ 0.0%

1023 Total 2,038 110,871$ 54.40$ 480$ 0.4% 1,554$ 190$ 1,025$ 2,769$ 1.40% 0.17% 0.92% 2.50% 63.0%

Grand Total 21,180 1,861,499$ 87.96$ 67,308$ 3.6% 18,456$ 2,775$ 24,753$ 45,984$ 0.99% 0.15% 1.33% 2.47% 46.2%

Stats Fees % of Fees

San Mateo County - All County Dept's

April 2025

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

6695 XXXXXX8410 SMC MYCHART REDWOOD CITY 216 52,902$ 248.69$ 3,598$ 6.8% 0$ -$ 1,584$ 1,584$ 0.00% 0.00% 2.99% 2.99% 0.0%

XXXXXX8303 SMMC PRE TESTING SAN MATEO 35 31,876$ 910.73$ -$ 0.0% 0$ -$ 953$ 953$ 0.00% 0.00% 2.99% 2.99% 0.0%

XXXXXX7800 SMC FAIR OAKS HLTH FL 2 REDWOOD CITY 8 414$ 69.74$ -$ 0.0% (0)$ -$ 13$ 13$ 0.00% 0.00% 2.99% 2.99% 0.0%

XXXXXX7792 SMC FAIR OAKS HLTH FL 1 REDWOOD CITY 2 -$ 2.00$ -$ 0.0% 0$ -$ 0$ 0$ 0.01% 0.00% 2.99% 3.00% 0.3%

XXXXXX7727 SMC COASTSIDE CLINIC HALF MOON BAY 1 10$ 10.00$ -$ 0.0% 0$ -$ 0$ 0$ 0.01% 0.00% 2.99% 3.00% 0.3%

XXXXXX7818 SMC FAIR OAKS HLTH FL 3 REDWOOD CITY 4 -$ 2.00$ -$ 0.0% 0$ -$ 0$ 0$ 0.01% 0.00% 2.99% 3.00% 0.3%

XXXXXX7735 SMC DALY CITY CLINIC DALY CITY 8 -$ 2.00$ -$ 0.0% 0$ -$ 0$ 0$ 0.01% 0.00% 2.99% 3.00% 0.3%

XXXXXX8048 SMMC INNOV CARE CLINIC SAN MATEO 2 -$ 5.00$ -$ 0.0% 0$ -$ 0$ 0$ 0.01% 0.00% 2.99% 3.00% 0.3%

XXXXXX8238 SMMC EMERGENCY SAN MATEO 3 196$ 200.00$ -$ 0.0% -$ -$ 6$ 6$ 0.00% 0.00% 2.99% 2.99% 0.0%

XXXXXX8162 SMC SEQUOIA WELLNESS REDWOOD CITY 2 -$ 2.00$ -$ 0.0% 0$ -$ 0$ 0$ 0.01% 0.00% 2.99% 3.00% 0.3%

XXXXXX8105 SMMC OBGYN CLINIC SAN MATEO 2 14$ 150.00$ -$ 0.0% 0$ -$ 4$ 4$ 0.00% 0.00% 2.99% 2.99% 0.1%

XXXXXX8139 SMMC PEDIATRIC CLINIC SAN MATEO 1 (2)$ -$ -$ -$ -$ -$

XXXXXX8188 SMC SO SAN FRAN CLINIC S SAN FRAN 3 (9)$ -$ -$ -$ -$ -$

XXXXXX8352 SMMC REHAB SERVICES SAN MATEO 0 -$ -$ -$ -$ -$ -$

XXXXXX8287 SMMC OP PHARMACY SAN MATEO 0 -$ -$ -$ -$ -$ -$

XXXXXX8147 SMMC RRSCC SAN MATEO 0 -$ -$ -$ -$ -$ -$

XXXXXX8063 SMMC MED SPECIALTY CLINIC SAN MATEO 0 -$ -$ -$ -$ -$ -$

6695 Total 287 85,401$ 321.98$ 3,598$ 4.2% 0$ -$ 2,561$ 2,561$ 0.00% 0.00% 2.99% 2.99% 0.0%

San Mateo County - SMMC MedEpay Group

April 2025

Stats Fees % of Fees

File details come from the government source that posted it. Updated .