Bill Payments using RPPS

TabaPay offers bill payments via MasterCard Remote Payment and Presentment Service (RPPS).

The MasterCard Remote Payment and Presentment Service (RPPS), governed by MasterCard International, is a fully electronic solution for bill payment processing that provides electronic routing, posting, and same day settlement of financial transactions.

Use Cases

  • Allow your consumers to make frequent payments towards their bills with approved vendors.
  • Add a bill payment function to your consumer facing budgeting, or savings platform.

Participants

Participant

Detail

Originator/Originator Bank

The Originator originates payment transactions to RPPS using TabaPay as the service provider to originate payments files to RPPS.

The Originator’s Bank is a financial institution used by any Originator. It is the institution from which the MasterCard Settlement Bank obtains funds via a Fedwire to credit Receivers for payment files sent through the RPPS network.

If an Originator is unable to fund payments sent through the RPPS network, the Originator’s Bank would be responsible for guaranteeing the funds for the Originator.

Biller

The Biller is a company to which a MasterCard RPPS payment transaction is sent.

Biller’s Bank

A Biller’s Bank is a financial institution that receives payments on behalf of a Biller from an Originator via the RPPS network.

TabaPay

TabaPay is the Originator’s Service Provider connecting to MasterCard RPPS for bill payments originated to the Biller via RPPS.

MasterCard RPPS

MasterCard RPPS maintains all connections between Originators and Receivers to transmit data and funds. It allows all parties involved to have one connection to reach multiple Originators and Billers, and maintains all connections, performs extensive edit checks on all files and payment transactions, batches and sends all files, and initiates all settlement transactions.

MasterCard RPPS Settlement Bank

The MasterCard Settlement Bank is the financial institution used by RPPS to initiate Fed wires to all Originators’ Settlement Banks and to credit all Receivers for payment files sent through the RPPS network. The MasterCard Settlement Bank sends Fed wires for the value of payments transferred through the MasterCard RPPS network to the appropriate Receivers. The MasterCard Settlement Bank is an agent of MasterCard RPPS and has an agreement with MasterCard RPPS to provide settlement services on its behalf.

Bill Payments via RPPS Flow

  1. Consumer at the Originator attempts to initiate payment to the Biller. The user experience of the consumer is provided by the Originator, and for the purposes of this workflow, displays interaction between Originator and Consumer.
  2. The Originator reviews an online directory with TabaPay (Read RPPS Biller Directory) TabaPay accesses directory at MasterCard RPPS to determine if the Biller can receive payments electronically via the RPPS network.
  3. Consumer confirms the payment to the biller. User experience of the consumer is provided by the Originator, and for the purposes of this document, details of the user experience, interaction between Originator and Consumer during biller search etc. is out of scope of this document.
  4. The Originator prepares a payment file containing bill payment transactions and sends the file to TabaPay. Validation of records is performed by TabaPay prior to sending a payment file to RPPS.
  5. TabaPay sends the file to MasterCard RPPS to process. This includes file and batch editing, account number validation and sorting/batching of payments.
  6. The MasterCard RPPS Settlement Bank initiates a Fedwire against the Originator’s bank to retrieve funds in the amount of the payment file after all accounts number validations are complete and inaccurate account numbers have been rejected.
    Note: Settlement occurs once daily at 6 PM PT for the total processing that occurred that day.
  7. The MasterCard RPPS Settlement Bank initiates Fedwires to credit the appropriate Biller’s Bank.
  8. MasterCard RPPS sends payment files to the appropriate Biller. MasterCard RPPS sends confirmation files to TabaPay confirming transactions received, processed, any rejects from RPPS, returns from Billers, and reasons for the reject or return.
  9. The Biller posts the credit to its account receivable.

RPPS Guidelines for Returns

Topic

Compliance Details

Returns

Billers can return any payment sent through TabaPay and the RPPS system.

Any payment not posted within 24 hours by the Biller is electronically returned via the RPPS network. RPPS routes it back to the correct Originator.

MasterCard RPPS also allows partial returns. These may be used for various reasons, such as discounts, commissions, rebates, or fees.

The Biller can electronically return any payment to the Originator through TabaPay and RPPS network. Each returned payment includes a return code that provides the reason the payment is being returned. Payments may be returned if the Biller is unable to post the payment, as may occur if an invalid account number or closed account number is used.

Errors and resulting payment disputes are minimized because MasterCard RPPS edits all transaction files prior to sending them to the Biller’s Bank. However, a Biller can return any payment to an Originator via the RPPS network/TabaPay.

Guaranteed Funds

All funds to match payment files sent through MasterCard RPPS are transferred via Fedwire; hence, they are guaranteed funds.

Soft Descriptor

Every Bill Payment will appear as “Bill Payment” in the consumer’s statement.

Biller Search using RPPS Biller Directory

Note: For RPPS Errors, refer to RPPS Exception Codes.

Biller Search using RPPS Biller Directory

  1. Originator requests Biller Name and Biller Address from consumer and provides the values to TabaPay in a flat file. Format must be conformant with TabaPay requirements.
  2. TabaPay sends the full file RPPS Biller Directory to the Originator.
  3. Originator searches for the Biller (using numerical values from the address) using the Biller Name in the Biller Directory file.
  4. Once Originator confirms the Biller Name from the Consumer, and requests account number for the Consumer at the Biller, Originator creates bill payment for the biller with TabaPay using the Consumer’s account number in the required format.

Refer RPPS Biller Directory File Format

Originator Payment File

📘

ACH vs RPPs Files

ACH and RPPS share similar file formats. You will see some columns that do not apply to RPPS.

Input File Format:

Column Name

Description

Example Values and Constraints

ISO

4-digits

TabaPay-assigned

1234
If this is wrong we reject the transaction

MID

4, 6, or 8 digits.

During your onboarding, you will choose the length (4, 6, or 8-digits)

1234
If this is wrong we reject the transaction

ACH Type

N
This value is static for RPPS input files. This field is not relevant for RPPS so just use the static value.

Has to be: N (If not, it could cause issues in the future).

Entry Type

RPPS
This value is static for RPPS input files This field is not relevant for RPPS so just use the static value.

Has to be: RPPS (If not, it could cause issues in the future).

Entry Description

Blank
This field is not relevant for RPPS so just leave blank.

Please leave this blank, not intended to be used. If not blank, not guaranteed to pass.

Amount

Decimals, no $ sign.

10.00

IIN

1-15 alphanumeric characters.
Unique reference.

123456789012345

First Name

Customer First Name

James

Last Name

Customer Last Name

Johnson

Account Type

RP
This value is static

Has to be: RP (If not, it could cause issues in the future).

Biller ID

Biller ID from RPPS Biller List

Account Number

Account Number under Biller

Debit/Credit

C
This value is static for RPPS input files. C indicates your are "sending" money to the biller.

Has to be: C

Note: in some cases, you can request the funds back within 5 calendar days of submitting the file. Use the value: D
This only applies if the biller allows it.

Company Name

Blank
This field is not relevant for RPPS so just leave blank.

Please leave this blank, not intended to be used. If not blank, not guaranteed to pass.

Sample Input File

Scroll over the table for more columns: ISO, MID, ACH Type, Entry Type, Entry Descriptions, Amount, IIN, First name, Last name, Account type, RTN, Account, Debit-Credit.

ISOMIDACH TypeEntry TypeEntry DescriptionAmountIINFirst nameLast nameAccount typeRTNAccountDebit-CreditCompany Name
628121NRPPS205rpps0000496SamwiseGamgeeRP1234567894444444444CFellowship
628121NRPPS443.89rpps0000497SamwiseGamgeeRP1234567894444444445CFellowship
628121NRPPS5.03rpps0000498SamwiseGamgeeRP1234567893333333335CFellowship
628121NRPPS6.81rpps0000499SamwiseGamgeeRP1234567894444444445CFellowship
628121NRPPS155.4rpps0000500SamwiseGamgeeRP000238020356789CFellowship
628121NRPPS68.93rpps0000501SamwiseGamgeeRP000238020356780CFellowship

Input File Format

Processed File from TabaPay

RPPS Files

File Details

File sharing details will be provided to the client

Input File Name: yyyymmdd_ISO_ACHInput_N_v2-5.csv or yyyymmdd_ISO_MID_ACHInput_N_v2-5.csv (Send to TabaPay)

Generated by the merchant and contains the transaction requests.

  • Merchant deposits input file(s) into the file sharing tool.

  • yyyymmdd = the date you send us the file.

  • All input files since last batch are processed.

  • TabaPay moves Input files to 'Inboxprocessed' after processing.

Email to [email protected] with copy to [email protected]: subject: NAME ACH; total debits and $s, total credits and $s

  • yyyymmdd=file date
  • N=sequence number (1..n) if multiple files per cycle used
  • A=file modifier (A..Z)
  • For ISO: Do not use MID
  • Comma separator for each field

Cut-off Time

Cut-off time is 2 PM PT.

  • File cutoff missed will be moved to next window
  • Confirmation of processing emailed to merchant

TabaPay pushes RPPS files via SFTP

SFTP Push - Security options can include:

  • Merchant whitelists TabaPay IP
  • SFTP ID and Password
  • TabaPay public key for SFTP security (ID or ID+PW)

FAQs

FAQs | Transaction Costs

What is the cost of each bill pay transaction through Tabapay?

Standard RPPS costs + TabaPay Markup based on contract. Refer to the Network Fee Guide for the MRPPS label for RPPS rate.

Will I be charged if a transaction is returned or rejected?

You will pay for every transaction that MasterCard charges; No separate TabaPay or MasterCard charges on Returns.

FAQs | Payment File Confirmation

When payments are processed, rejected, or returned how long will it take for TabaPay to inform us?

TabaPay’s cutoff is 2 PM PT. You should receive the processed file after the batch at about 2:30 PM PT. You will receive other reports next morning via Dropbox.

How will those payment updates be shared?

SFTP via Dropbox

FAQs | File Format

Is Account the Bill Pay Account number linking Consumer and Biller?

Yes. Account number matches against biller masks in the Mastercard RPPS Biller/Creditor Directory.

Debit/Credit designator – is this telling us that the Biller accepts Debit or Credit cards?

Credit is a payment sent to an account. Debit is a reversal, or payment pulled from an account.

If so, where would we send the credit card number in the payment file?

Not in the payment file, but TabaPay can help you with processing consumer credit card payments through TabaPay as well. Our card acceptance suite includes PCI-Compliant iFrame as well as APIs to place transactions with us.

Does TabaPay initiate the credit card transaction to pay the biller?

Payment to the biller is handled by the network.

Biller Directory File Format

  • Record 0 consists of biller information.
  • Record 1 contains biller addresses.
  • Record 2 contains biller masks.
  • There may be multiple 1 and 2 records associated with a 0 record.
  • Each 1 record may contain from 1 to 20 addresses.
  • If no biller addresses are available for a biller, no 1 record will be created.
  • Each 2 record may contain from 1 to 80 masks for the full and partial downloads, and from 1 to 60 masks for the advanced full download.
  • There must be at least one mask for a biller.
  • The address record may contain from 1 to 10 addresses, and the mask record may contain from 1 to 25 masks.
  • Record 3 contains mask descriptors.
  • Record 4 contains AKAs.
  • Record 5 contains contacts.
  • Record 6 contains phone and fax numbers.
    • There may be multiple 3 records associated with a 2 record, multiple 4 and 5 records associated with a 0 record and multiple 6 records associated with a 5 record.
    • Each 3 record may contain from 1 to 35 mask descriptors.
    • Each 4 record may contain from 1 to 15 AKAs.
    • Each 5 record may contain from 1 to 7 contacts.
    • Each 6 record may contain from 1 to 20 phone numbers.
    • If there is no data for record types 3 through 6, then they will not be created.
    • If a mask has mask descriptors, then that mask will be on a 2 record by itself, and the descriptors will be on one or more 3 records after it.
    • If a contact has phone/fax numbers the contact will be on a 5 record by itself, and the phone/fax numbers will be on one or more 6 records after it.
    • Mask record may contain from 1 to 50 masks and the contact record may contain from 1 to 3 contacts.
    • An 'X0' record will be generated to indicate no data for partial and advanced partial file downloads.
  • Mask record may contain from 1 to 50 masks and the contact record may contain from 1 to 3 contacts.
  • An 'X0' record will be generated to indicate no data for partial and advanced partial file downloads.

File Layout

Record lengths for the fixed-width format (in bytes):

  • Biller - 1450 to 1451
  • Biller Address - 232 to 4621 (2311 automated)
  • Mask - 46 to 2701 (2251 automated)
  • Mask Descriptor - 61 to 2101;
  • AKA - 149 to 2221
  • Contact - 658 to 4600 (1972 automated)
  • Contact Phone - 101 to 2001

Biller Record (0)

Field NameField Size (Bytes)Field Description
Record TypeN 1Type of Record; 0 - Biller
Biller KeyN 10Unique key for this biller record. This value never changes.
Record Effective DateN 10The date of the last change to this record - YYYY-MM-DD
Biller IDN 10Unique biller ID
Live DateN 10The date this biller was first activated - YYYY-MM-DD
Transit Routing Number/ABAN 10Credit Counseling Biller ID populated on the RPPS website.
Biller NameAN 128Corporate Name
Biller ClassAN 50Industry Type
Biller TypeAN 30Identifies the biller type.
Line of BusinessAN 2Indicates biller line of business
File FormatN 3File format for the biller
Accepts Prenotes?AN 1Y - Yes, N - No
Accepts Guaranteed Payments Only?AN 1Y - Yes, N - No
*Accepts DMP Prenotes?AN 1Y - Yes, N - No
*Accepts DMP Payments Only?AN 1Y - Yes, N - No
*Average Response Time (Hours)N 4The typical time for a biller to respond to a DMP request
*Accept CDP Prenotes?AN 1Y - Yes, N - No
*Accept CDV Prenotes?AN 1Y - Yes, N - No
*Accept CDD Prenotes?AN 1Y - Yes, N - No
*Accept CDF Prenotes?AN 1Y - Yes, N - No
*Accept CDN Prenotes?AN 1Y - Yes, N - No
*Accept FBD Prenotes?AN 1Y - Yes, N - No
*Accept FBC Prenotes?AN 1Y - Yes, N - No
*Return CDR?AN 1Y - Yes, N - No
*Return CDT?AN 1Y - Yes, N - No
*Return CDA?AN 1Y - Yes, N - No
*Return CDV?AN 1Y - Yes, N - No
*Return CDC?AN 1Y - Yes, N - No
*Return CDM?AN 1Y - Yes, N - No
Require Addenda with Reversals?AN 1Y - Yes, N - No
Country CodeAN 3Three character ISO country code
State/Province CodeAN 3Three character ISO country subdivision code
Check Digit Routine?AN 1Y - Yes, N - No
Currency CodeAN 3Three character ISO currency code
Territory CodeN 11 - Global, 2 - National, 3 - Regional
Previous Biller NameAN 128Biller Name prior to Change
NoteAN 1000Comment field
Accepts Exception Payments?AN 1Y - Yes, N - No
Same Day Payment Deadline CycleAN 1Deadline cycle for same-day billers (not present if same-day not supported)
Total AddressesN 6Total Number of Addresses Associated with this Biller
Total MasksN 6Total Number of Masks Associated with this Biller
Total AKAsN 6Total Number of AKAs Associated with this Biller
Total ContactsN 6Total Number of Contacts Associated with this Biller

Address Record (1)

Field NameField TypeField Description
Record TypeN 1Type of Record; 1 - Address
Address Key (N)N 10Unique key for this address record. This value never changes.
Record Effective Date(N)N 10The date of the last change to this record - YYYY-MM-DD
Address Type (N)AN 40The kind of address
Address Line 1 (N)AN 501st line of Biller Address
Address Line 2 (N)AN 502nd line of Biller Address
City (N)AN 50Biller City Name
State/Province Code (N)AN 3Three character ISO country subdivision code
Country Code (N)AN 3Three character ISO country code

Biller Mask Record (2)

Field NameField TypeField Description
Record TypeN 1Type of Record; 2 - Mask
Mask Key (N)N 10Unique key for this mask record. This value never changes.
Record Effective Date(N)N 10The date of the last change to this record - YYYY-MM-DD
Mask Length (N)N 2Length of Mask
Mask (N)AN 22*=Alpha, #=Numeric, @=Alpha or Numeric, !=Special Character
Exception Mask? (N)AN 1Y - Yes, N - No

Biller Mask Descriptor Record (3)

Field NameField TypeField Description
Record TypeN 1Type of Record; 3 - Biller Mask Descriptor
Biller Mask Descriptor Key (N)N 10Unique key for this record. This value never changes.
Record Effective Date (N)N 10The date of the last change to this record - YYYY-MM-DD
Mask Descriptor (N)AN 50Description of Biller Mask

Biller AKA Record (4)

Field NameField TypeField Description
Record TypeN 1Type of Record; 4 - AKA
AKA Key (N)N 10Unique key for this AKA record. This value never changes.
Record Effective Date(N)N 10The date of the last change to this record - YYYY-MM-DD
AKA Name (N)AN 128Biller Alias

Biller Contact Record (5)

Field NameField TypeField Description
Record TypeN 1Type of Record; 5 - Contact
Contact Key (N)N 10Unique key for this contact record. This value never changes.
Record Effective Date(N)N 10The date of the last change to this record - YYYY-MM-DD
Contact Type (N)AN 40The kind of contact
Organization Name (N)AN 128Organization contact is associated with
Courtesy Title (N)AN 20Contact courtesy title
First Name (N)AN 50Contact first name
Last Name (N)AN 50Contact last name
Title (N)AN 50Contact business position title
Address Line 1 (N)AN 501st line of Biller Address
Address Line 2 (N)AN 502nd line of Biller Address
City (N)AN 50Biller City Name
State/Province Code (N)AN 3Three character ISO country subdivision code
Country Code (N)AN 3Three character ISO country code
Postal Code (N)AN 15Address Postal Code
Email (N)AN 128Email address

Biller Contact Phone Record (6)

Field NameField TypeField Description
Record TypeN 1Type of Record; 6 - Phone
Phone Key (N)N 10Unique key for this Phone record. This value never changes.
Record Effective Date(N)N 10The date of the last change to this record - YYYY-MM-DD
Phone Type (N)AN 30Phone, Fax or Alternate Phone
Phone Number (N)AN 50Can include dashes, spaces, etc.

File Layout for Advanced Partial File Type

Record lengths for the fixed-width format(in bytes):

  • Biller - 22 to 2072
  • Biller Address - 32 to 182
  • Mask - 32 to 126
  • Mask Descriptor - 42 to 192
  • AKA - 32 to 338
  • Contact - 32 to 338
  • Phone - 42 to 192
Field NameField TypeField Description
ACD IndicatorAN 1Indicates an add or delete of a record or a change to a field. A deleted record will have no field changes listed.
Record TypeN 1Type of Record; 0 - Biller, 1 - Address, 2 - Mask, 3 - Mask Descriptor, 4 - AKA, 5 - Biller Contact, 6 - Phone Number
Biller KeyN 10All record types. Unique left-justified key identifying either the biller record changed (type 0) or the biller record the change is associated with (types 1–6). This value never changes.
Record KeyN 10Record Types 1–6. Unique left-justified key identifying either the record changed (types 1,2,4,5) or the record the change is associated with (types 3,6). This value never changes.
Record Key (Alt)N 10Record Types 3 and 6 only. Unique left-justified key for this record. This value never changes.
Effective DateN 10The date this change becomes effective - YYYY-MM-DD
FieldAN 50The name of the field being added or changed; not available on a delete.
Current ValueAN 1000(0), 50(1), 22(2), 50(3), 128(4), 128(5), 50(6)The field value as of the effective date; available on an add or a change.
Prior ValueAN 1000(0), 50(1), 22(2), 50(3), 128(4), 128(5), 50(6)The field value before the effective date; available only on a change.

No-Data Record

Field NameField Size (Bytes)Field Description
ACD IndicatorAN 2Indicates no data modifications are available (X0)
Effective DateN 10Indicates the processing date of the file - YYYY-MM-DD