April25_MID_Level_Detail.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

Written by GovTribe AI ·

April 2025 Merchant Credit Card Services Transactional Data Report for San Mateo County

This is a detailed transactional analysis document prepared for the County of San Mateo's Treasurer-Tax Collector's Office, presenting merchant credit card processing data for April 2025 across multiple county departments and service locations. The report encompasses three primary merchant categories (CHN_NUM codes 1022, 1030, and 1023) representing diverse county functions including planning departments, sheriff's records, public works parking, environmental health services, medical centers, and recorder offices. The analysis covers 21,180 total transactions valued at $1,861,499 processed across locations in Redwood City, San Mateo, San Carlos, Half Moon Bay, Atlanta, and Daly City. The data captures transaction volumes ranging from zero to 6,627 items per merchant location, with average ticket values spanning from $0.41 to $2,629.64. Additionally, a separate merchant category (CHN_NUM 6695) for San Mateo Medical Center's MedEpay platform processed 287 transactions totaling $85,401 in April 2025.

The report details comprehensive fee structures including interchange fees, assessments, and Elavon processor fees, with total monthly fees across all categories reaching $45,984. Fee percentages of volume ranged from 1.20% to 2.47% across the primary categories, while downgrade percentages varied from 0.0% to 15.0%. Individual merchant locations demonstrated significant variability in processing profiles, with some departments generating no transaction activity while others, such as San Mateo Parks Marina with 6,361 items and Environmental Health Services with 575 items, represented substantial processing volumes. The historical context referenced in the related RFP indicates this April 2025 data reflects ongoing payment processing operations under an existing merchant services arrangement, providing baseline metrics for the upcoming procurement cycle targeting contract execution on December 1, 2025, through November 30, 2028.

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
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
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

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 .