City_of_Tucson_Pricing_Pro_Forma_UPDATED.xlsx

XLSX spreadsheet 48 KB Posted Apr 26, 2024

Attached to: General and Merchant Banking, pCard, Debit Card, Cashiering, and Payment Acceptance
Solicitation number: 240172
Issued by: Pima County, Arizona

About this file

Written by GovTribe AI · Sep 22, 2025

This document is a pro-forma pricing spreadsheet for the City of Tucson, Arizona, detailing a comprehensive banking services request for proposal (RFP). The City is seeking qualified financial institutions to provide banking services across eight service groups, including general banking, institutional custody, merchant card processing, commercial cards, payroll/prepaid debit cards, cashiering services, payment acceptance, and corporate trust services. The RFP covers multiple banking product lines with extensive transaction volume estimates, such as ACH services, wire transfers, lockbox services, electronic deposits, and various payment processing capabilities.

The pricing document provides granular volume and unit cost details for each service group, with estimated annual transaction volumes for different banking activities. Pricing is structured across multiple tiers and service categories, including transaction fees, maintenance charges, and specialized service costs. The proposal includes detailed breakdowns for services like merchant card processing (covering Visa, MasterCard, Discover, and American Express), prepaid debit cards, cashiering services, and payment acceptance platforms. The City has engaged PFM Group Consulting LLC to assist in issuing the RFP and evaluating proposal responses, with the goal of selecting a comprehensive banking services provider that can meet the municipality's diverse financial transaction and service needs.

View the file

Other files

File	Type	Posted
General_and_Merchant_Banking,_pCard,_Debit_Card,_Cashiering,_and_Payment_Acceptance_(Addendum_#8_Revision).pdf	PDF	May 2, 2024
City_of_Tucson_Investment_Policy.pdf	PDF	May 2, 2024
Appendix_F_-_Utility_Bill_Redesign_RESIDENTIAL_.pdf	PDF	Apr 26, 2024
Appendix_E_-_Sample_Lockbox_Correspondence.pdf	PDF	Apr 26, 2024
City_of_Tucson_Banking_RFP_240172_Evaluation_Questions_UPDATED.xlsx	XLSX spreadsheet	Apr 12, 2024
Appendix_D_-_Bond_Issues.pdf	PDF	Mar 26, 2024
Appendix_C_-_Commercial_Card_Consortium_Participants.pdf	PDF	Mar 26, 2024
Appendix_B_-_Institutional_Custody_Portfolios.pdf	PDF	Mar 26, 2024
Appendix_A_-_Sample_Lockbox_Remittance_Document.pdf	PDF	Mar 26, 2024
FTA_TERMS_AND_CONDITIONS.pdf	PDF	Mar 20, 2024
5369-B.PDF	PDF	Mar 20, 2024
COT_ARPA_Terms_and_Conditions.pdf	PDF	Mar 20, 2024
Offer_and_Acceptance.pdf	PDF	Mar 20, 2024

Show all 13

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.

SG1 General Banking

Attachment : PRO-FORMA PRICING
Fee Proposal
Service Group 1: General Banking
AFP	Service	Average	Proposed	Total
Code	Description	Monthly Volume	Unit Cost	Monthly Cost
	GENERAL ACCOUNT SERVICES
01 0000	Account Maintenance (with Check Return)	8
01 0000	Account Maintenance	19
01 0020	ZBA Master Account Maintenance	1
01 0021	ZBA Subaccount Maintenance	2
01 0100	Debits Posted	298
01 0310	DDA Statement - Paper	11
01 0100	Remote Deposit Capture - Per Deposit Credited	39
01 0610	Check Deposit Adjustment	2
	DEPOSIT SERVICES
01 0320	Online Statement - Special Instruction	1
10 0416	Online Return Item Reporting Maintenance	6
10 0416	Online Return Item Subscription - Per Item	10
10 0015	Miscellaneous Credits Posted	24
10 0006	Branch Deposit	4
10 0113	Vault Deposit - Standard Coin Bag	1
10 0111	Vault Deposit - Non-Standard Coin Bag	91
10 0144	Vault Coin Rolls Furnished	43
10 0501	Vault Deposit Adjustment	3
10 0141	Vault Order - Automated	14
10 0199	Vault Deposit - Currency and Coin Per Dollar	349,942
10 0199	Vault Currency Furnished Per Dollar	920
10 0520	Vault Adjustment Advice - US Mail	2
10 0199	Vendor Fees - Armored Car	2,518
10 0610	Deposit Reconciliation - Per Item	953
10 0225	Deposited Check (Branch/Vault)	5,715
10 0225	Wholesale Lockbox - Deposited Check	33,528
10 0006	Branch Deposit - Currency and Coin Per Dollar	4,049
10 0100	Vault Deposit - Per Deposit	296
10 0040	Cash Order Fee - Branch	1
10 0040	Rolled Coin Furnished - Branch	1
10 0040	Currency Furnished Per Dollar - Branch	398
10 0400	Return Item - Chargeback	42
10 0416	Online Return Item Retrieval - Per Image Retrieved	1
10 0416	Online Return Item Service Maintenance	5
10 0401	Return Item - Special Instructions	39
10 0401	Return Item - Special Instructions - Monthly Base	1
10 0402	Return Item Redeposited	15
40 0003	Remote Deposit Capture Maintenance	9
10 0224	Remote Deposit Capture - Deposited Item	1,112
10 0230	Electronic Deposit - Deposit Adjustment	1
	LOCKBOX SERVICES
05 0400	Lockbox Data Transmission Maintenance	1
05 0135	Lockbox Incoming Data File Maintenance	1
05 0500	Lockbox Online Decision Maintenance	1
05 0000	Lockbox Remittance Processed Cash	3
05 0000	Lockbox Remittance Processed Express Mail	67
05 0530	Lockbox No Check Item	145
05 0500	Lockbox Online Decision Exceptions	982
05 0500	Lockbox Online Decision Reject	65
05 011R	Lockbox Document Image Processing	145,874
05 0600	Lockbox Web Image Retrieval Item	145,874
05 0129	Lockbox Keying	131,589
05 0410	Lockbox Package U.S. Mail Delivery	49
05 01IE	Lockbox Post Office Returned Mail	3
05 031Z	Lockbox Online Transaction Report per Item	28
05 0020	Lockbox Wholetail Maintenance	1
05 0100	Lockbox Wholetail Checks	31,524
05 0122	Lockbox Wholetail Total Payment Processed	35,055
05 9999	Lockbox Wholetail Standard Item Processed Non-Scan	2,681
05 0122	Lockbox Wholetail Multi Payment	5,068
05 0002	Lockbox Wholetail Partial Payment	3,091
05 0899	Lockbox Wholetail Change of Address	35,055
05 0401	Lockbox Wholetail Data Transmission Item	37,735
	E-LOCKBOX SERVICES
05 9999	E-Lockbox Item	40,160
05 0030	E-Lockbox Maintenance	1
05 0030	E-Lockbox Reporting Maintenance	1
05 0030	E-Lockbox Reversal Reporting Maintenance	1
05 0030	E-Lockbox Validation File Maintenance	1
05 0530	E-Lockbox Suspended Payment - Per Item	1,028
05 9999	E-Lockbox Payment Return - Per Item	45
05 9999	E-Lockbox Payment Reversed	7
	PAPER DISBURSEMENT SERVICES
15 0724	Positive Pay Exception - Online Image	21
15 0810	Printing & Supplies - Vendor	7,531
15 0300	Controlled Disbursement MICR Rejects >1% Thru 2%	1
15 0222	Positive Pay Exception Checks Returned	6
15 0410	Stop Payment - Online	11
15 0030	Positive Pay Only Maintenance (No Recon)	5
15 0120	Positive Pay Only Item	2,122
15 1352	Online Image View < 90 Days - Per Item Viewed	40
15 1352	Online Image View > 90 Days - Per Item Viewed	23
15 0310	Positive Pay Exceptions - Per Item	25
15 0401	Positive Pay Verification Call - Cashed	1
15 0310	Positive Pay Checks Paid No Issue Record	18
15 0401	Positive Pay Verification Call - Deposited	1
15 1350	Paid Check Image CD-ROM Monthly Maintenance	1
15 1353	Paid Check Image Per CD-ROM	1
15 9999	Checks Returned With Statement - Per Item	1
15 0100	Checks Paid	1,959
15 0499	Stop Payment - Paper Confirmation	1
15 0122	Payee Positive Pay Per Item	1,938
15 0500	Check Cashed for Non-Account Holder	9
15 1399	Paid Check Image CD-ROM Per Item	1,758
15 0412	Stop Payment - Automatic Renewal	5
15 0300	MICR Check Rejects >2%	1
15 0240	Check Block - Maximum Check Dollar Amount Block	8
15 1352	Remote Deposit Capture - Per Image Retrieved	1,114
15 0240	Check Block - Check Cashing Threshold	8
15 0240	Check Block - OTC/Branch Processing Block	9
15 0240	Check Block - Checks Paid to Individuals Block	8
	PAPER DISBURSEMENT RECONCILIATION SERVICES
20 0201	Online Check Issue Input - Per Item	257
20 0020	Deposit Reconciliation Maintenance	1
20 0301	ARP Output - Per Transmission	44
20 0306	ARP Optional Reports	56
20 9999	ARP Aged Issue Records (60 day) on File - Per Item	1,631
20 0100	Outgoing Transmission - Per Item	1,962
20 0306	Online ARP Statements and Reports Maintenance	5
	GENERAL ACH SERVICES
25 0703	Online ACH Hyperlink Item Detailed Inquiry - Per Item	6
25 0703	ACH Online Subscription - Per Account	3
25 0703	ACH Online Subscription - Per Item	1,499
25 1001	ACH Fraud Filter Set Up	1
25 0201	Electronic Credits Posted	1,332
25 0000	ACH Vendor Monthly Base	1
25 0400	ACH Online Return Subscription - Per Account	8
25 0400	ACH Online Return Subscription - Per Item	75
25 0000	ACH Monthly Maintenance - Online File Upload	3
25 0102	ACH Item Originated	12,423
25 0102	ACH Item Originated - Same Day	190
25 0120	ACH Originated Addenda Record	1
25 0202	ACH Debit/Credit Received Item	935
25 0220	ACH Received Addenda	2,090
25 0302	ACH Return Item - Electronic	7
25 0302	ACH Return Item - Manual	1
25 0302	ACH Return Admin - Manual	1
25 0302	ACH Return Admin - Electronic	23
25 0312	ACH Unauthorized Return Item - Electronic	4
25 0312	ACH Unauthorized Return Item - Quality Fee	5
25 0500	ACH Online Batch Release - Per Batch	5
25 0501	ACH Transmission - Per Transmission	70
25 0710	ACH Fax Report - Per Page	1
25 0622	ACH Exception Process - Duplicate File	1
25 0642	ACH Reversal - Per Item	2
25 0102	ACH Item Originated Online	2,076
25 1120	ACH Payments Set Up Fee	1
25 0000	Online ACH Maintenance	3
25 1000	ACH Vendor Set Up	1
25 1000	ACH Set Up	1
25 1010	ACH Special Investigation Request	2
25 1050	ACH Online Fraud Filter Review Maintenance	25
25 1053	ACH Online Fraud Filter Review - Per Item	6
25 0302	ACH Notification of Change - Electronic	19
25 0302	ACH Notification of Change - Manual	1
25 0720	ACH Notification - Reject	1
25 0620	ACH Delete Item	1
25 0102	ACH Item Originated Online - Same Day	402
	EDI PAYMENT SERVICES
30 0200	Enhanced Receivables Transmission	21
30 0010	Enhanced Receivables Monthly Maintenance	1
30 0200	E-Lockbox Transmission	22
30 0210	Receivables Mgr Transactions Reported	34,204
30 0010	Online EDI ACH Payment Detail Maintenance	4
30 0225	Online EDI ACH Payment Detail - Per Item	35
30 0225	Online EDI ACH Payment Detail - Addenda Item	8
	WIRE & OTHER FUNDS TRANSFER SERVICES
35 9999	Outgoing International Wires - OUR Charge	1
35 9999	Wire Account Addition - Online	1
35 9999	Outgoing Wire Returned to Customer	1
35 0300	Wire In - Domestic	5
35 0320	Wire In - Correspondent Bank USD or FX	1
35 0100	Wire Out Online - Domestic	14
35 0120	Wire Book Transfer Online	62
35 0113	Wire Out Online - International USD	1
	INFORMATION SERVICES
40 1001	Photocopy Customer Service - Per Item	1
40 0340	Online Search (Per 100 Search Items)	207
40 0052	Online Previous Day Reporting Maintenance	26
40 0271	Online Previous Day Reporting Items Loaded	4,052
40 022Z	Event Messaging Service - Email	302
40 0051	ARP Statements and Reports (CSV/Excel) Maintenance	1
40 0272	ARP Statements and Reports (CSV/Excel) Per Item	2,417
40 0002	BAI Maintenance	26
40 0221	BAI Transactions Reported	4,000
40 0231	Remote Deposit Capture Report Per Item	1,115
40 9999	Remote Deposit Capture Discretionary Data Item	1,112
40 0003	Deposit Detail Transmission Base	3
40 0224	Deposit Detail Transmission - Per Item	1,104
40 0055	Online Current Reporting Maintenance	8
40 0340	Online Wire Inquiry Detail - Per Item	1
	INTERNATIONAL SERVICES
60 9999	Deposited Check on Canadian Bank	2
	POTENTIAL NEW SERVICE - INTEGRATED PAYABLES

ADDITIONAL SERVICES NECESSARY TO MEET CORE RFP REQUIREMENTS

Estimate volumes for each service

TOTAL ANNUAL COST

OPTIONAL SERVICES PROPOSED

SG2 Institutional Custody

Attachment : PRO-FORMA PRICING
Fee Proposal
Service Group 2: Institutional Custody - Fixed-Income Portfolios
Service		Proposed	Total
Description	Volume	Unit Cost	Monthly Cost
Asset Based Fee Schedule
First $50 million
$50 - $100 million
$100 - $150 million
$150 - $200 million
$200+ million

Administration Fees
Account Maintenance Fee (Annual Charge)
Number of Portfolio Holdings	523
Total Return Performance Reporting
Other Charges (reporting, etc.)

Transaction Fees
DTC / Fed Transactions
Interest Payments (Semi-Annual Coupon Payments)
MBS/ABS Paydowns
Incoming Domestic Wires
Outgoing Domestic Wires
Purchases	800
Sales	421

Minimum Annual Cost?

Additional Services Necessary to Meet Core RFP Requirements

Estimate volumes for each service

Total Annual Cost

Optional Services Proposed

SG3 Merchant Card Processing

Attachment : PRO-FORMA PRICING
Fee Proposal
Service Group 3: Merchant Card Processing
Service	Annual	Proposed	Total
Description	Volume	Unit Cost	Annual Cost

$ VOLUME
Visa	$ 93,100,000
MasterCard	$ 31,066,000
Discover	$ 1,695,000
American Express	$ 7,258,000
Debit	$ 42,621,000

# OF TRANSACTIONS
Visa	1,947,681
MasterCard	338,206
Discover	32,159
American Express	58,284
Debit	404,976

Chargeback Fee

AVS Fee

PCI SUPPORT PACKAGE

Per Month / Per Merchant ID

NON-PCI COMPLIANCE FEE

Per Month / Per Merchant ID

ENCRYPTION & TOKENIZATION

Tokenization (per Transaction Fee)

P2PE EQUIPMENT (Please list all available equipment options)

Equipment Fee (One-Time Cost)

Equipment Maintenance

ADDITIONAL SERVICES NECESSARY TO MEET CORE RFP REQUIREMENTS

Estimate volumes for each service

TOTAL ANNUAL COST

OPTIONAL SERVICES PROPOSED

Provide pricing for merchant card terminal options including voice analog and wireless terminals

SG4 Commercial Card

Attachment : PRO-FORMA PRICING

Fee Proposal

Service Group 4: Commercial Card

Annual Consortium Combined Charge Volume	Individual Participant Combined Charge Volume
	0 - 1,000,000	1,000,001 - 2,500,000	2,500,001 - 5,000,000	5,000,001 - 10,000,000	10,000,001 - 15,000,000	15,000,001 - 20,000,000	20,000,001 - 30,000,000	30,000,001 - 40,000,000	40,000,001 - 50,000,000	$50,000,001 - $70,000,000	$70,000,001+
Standard Terms	30/25	30/25	30/25	30/25	30/25	30/25	30/25	30/25	30/25	30/25	30/25
0 - 200,000,000
200,000,001 - 250,000,000
250,000,001 - 300,000,000
300,000,001 - 350,000,000
350,000,001 - 400,000,000
400,000,001 - 450,000,000
450,000,001 - 500,000,000
500,000,001+
Large Ticket/Partner Program
7/3 Term Escalator
14/7 Term Escalator
30/3 Term Escalator
30/7 Term Escalator
30/10 Term Escalator
30/14 Term Escalator

SG5 Payroll_Prepaid Debit Card

Attachment : PRO-FORMA PRICING
Fee Proposal
Service Group 5: Payroll/Prepaid Debit Cards
Service		Proposed	Total
Description	Annual Volume	Unit Cost	Annual Cost
Prepaid Debit Card
Set-Up Fees
New Card Fee (Reloadable)	360
Implementation Fee

Charges to City
Same-Day Load onto Card per Transaction
Monthly Account Maintenance
Per Card Maintenance	8,965
Software
Standard Reporting
Training

Charges to Cardholder

ATM Withdrawals

# of Free Withdrawals

Out-of-Network ATM Fee

POS - PIN

POS - Signature

Teller Withdrawal

Monthly Account Fees

Electronic Monthly Statement

Paper Monthly Statement

ATM Inquiry

Operator Inquiry

Card Replacement

Other Cardholder Fees

Declined POS Transaction

Declined ATM Transaction

Monthly Inactivity

Negative Balance Fee

Payroll Card

Set-Up Fees

New Card Fee

Implementation Fee

Customization

Charges to City
Transaction Fees (Load Fee)
Monthly Account Maintenance
Per Card Maintenance	120
Software
Standard Reporting
Training

Charges to Employee

ATM Withdrawals

Out-of-Network ATM Fee

POS - PIN

POS - Signature

Teller Withdrawal

Monthly Account Fees

Electronic Monthly Statement

Paper Monthly Statement

ATM Inquiry

Card Replacement

Other Employee Fees

Declined POS Transaction

Declined ATM Transaction

Monthly Inactivity

Negative Balance Fee

ADDITIONAL SERVICES NECESSARY TO MEET CORE RFP REQUIREMENTS

Estimate volumes for each service

TOTAL ANNUAL COST

OPTIONAL SERVICES PROPOSED

SG6 Cashiering

Attachment : PRO-FORMA PRICING
Fee Proposal
Service Group 6: Cashiering Services
	Service	Annual	Proposed	Estimated
	Description	Volume	Unit Cost	Annual Cost

Subscription License
0 - 100,000 transactions
100,000 - 150,000 transactions	119,818
150,000 - 200,000 transactions
200,000 - 250,000 transactions
250,000+ transactions
Unlimited Users
24/7 Online Payments
Online system access (research, reports and configuration)
Cost per Collection Point
Annual License Maintenance and Support
Annual Hosting
Interface Development
Payment Processing Fees
Credit Card Gateway Fee
EMV and E2E Encryption (up to X devices)	17
Wed Debit Fees
Tender Types
Online Credit Card	47,570
In-House Credit Card	17,548
Online ACH	9,050
In-House Cash	21,712
In-House Checks	23,938
Other

ADDITIONAL SERVICES NECESSARY TO MEET CORE RFP REQUIREMENTS

Estimate volumes for each service

TOTAL ANNUAL COST

OPTIONAL SERVICES PROPOSED

SG7 Payment Acceptance

Attachment : PRO-FORMA PRICING
Fee Proposal
Service Group 7: Payment Acceptance for City Payments
Service	Annual	Proposed	Estimated
Description	Volume	Unit Cost	Annual Cost

Monthly Maintenance Charge per Relationship
Monthly Maintenance Charge per Site
Monthly Maintenance Charge per Sub-Portal (for Sites with multiple payment types)
Transaction Fee for ACH Payments Received from Customer	800,328
Transaction Fee for Credit/Debit Card Payments Received from Customer	857,604
IVR Monthly Maintenance per Site
IVR Monthly Maintenance per Sub-Portal (for Sites with multiple payment types)
IVR Transaction Processing per Minute
Transaction Fee for Apple Pay	16,632
Transaction Fee for Google Pay	1,788
Transaction Fee for Walmart Pay
Transaction Fee for PayPal/PayPal Credit	88,056
Transaction Fee for Venmo
Transaction Fee for One-Time API	338,388
Bill File Uploaded/Transmitted per File
Bill Record Loaded to Portal per Record
Receipt Posting File per File
Receipt Posting File Monthly Maintenance per Site
Receipt Posting File Monthly Maintenance per Sub-Portal (for Sites with multiple payment types)
Receipt Posting File per Item
Customer Email - per Event
Customer Text Message - per Event
Account Updater Maintenance per Site
Account Updater Maintenance per Sub-Portal (for Sites with multiple payment types)
Account Updater per Event
Chargeback Fee
ACH Return Fee
Development Programming Charges, if required (per Hour)

ADDITIONAL SERVICES NECESSARY TO MEET CORE RFP REQUIREMENTS

Estimate volumes for each service

TOTAL ANNUAL COST

OPTIONAL SERVICES PROPOSED

SG8 Corporate Trust

Attachment : PRO-FORMA PRICING
Fee Proposal
Service Group 8: Corporate Trust Services
	Service	Proposed	Estimated
	Description	Unit Cost	Annual Cost

Initial Acceptance Fee

Upfront Out of Pocket Fees

Legal Fees (per bond issuance)

Annual Administrative Fee

Variable Rate Deal (per bond issuance)

Fixed Rate Deail (per bond issuance)

Investment Agreement (Annual)

Transition Fees, if any?

*** Please provide an estimate on the total costs for the bond issues identified in Appendix D

ADDITIONAL SERVICES NECESSARY TO MEET CORE RFP REQUIREMENTS

Estimate volumes for each service

TOTAL ANNUAL COST

OPTIONAL SERVICES PROPOSED

File details come from the government source that posted it. Updated Sep 22, 2025.