Import Real-Time Payments File
How to Import Real-Time Payments Request for Payment File
Real-Time instant payments, are defined simply as: Irrevocably collected funds in a bank account and usable immediately by the owner of the account. Our "Good Funds" payment gateway allows for instant real-time digital payments that are immediate, irrevocable, intra-bank and/or interbank account-to-account (A2A) transfers that utilize a real-time messaging system connected to every transaction participant through all U.S.-based financial institutions.
To import a Real-Time Payments (RTP) Request for Payment (RFP) file using https://Real-TimePayments.com into your Bank or Credit Union’s dashboard, you will need to follow the steps outlined by your financial institution’s platform. Most institutions that support Real-Time Payments will allow you to upload payment request files in formats such as ISO 20022 XML, CSV, or JSON via their online portal. Below is a general guide to importing a Request for Payment (RFP) using Real-Time Payments.com into your financial institution.
Step-by-Step Guide to Importing RTP Request for Payment File into Your Bank or Credit Union
1. Obtain the Request for Payment (RFP) File
Make sure you have the Request for Payment (RFP) file ready. It can be in various formats:
- ISO 20022 XML (standard for financial messages)
- CSV (comma-separated value files used for data exchange)
- JSON (JavaScript Object Notation, typically used in API integrations)
- XML (a custom XML file structure used in payment systems)
Your RFP file should include:
- Debtor (Payer) Information
- Creditor (Payee) Information
- Amount
- Currency
- Payment Date
- Payment Reference (such as an invoice number)
2. Log Into Your Financial Institution’s Dashboard
- Navigate to your bank or credit union’s online portal.
- Log in with the necessary credentials (you may need admin-level access to upload files).
3. Navigate to the Payment or File Upload Section
- Look for the Payments section, Request for Payment options, or File Upload area.
- Depending on your institution, you may find sections labeled Real-Time Payments, FedNow, or similar.
4. Upload the Request for Payment (RFP) File
The process varies depending on the format of the RFP file you’re using:
For ISO 20022 XML Format:
- Select ISO 20022 XML as the file type in the bank’s dashboard.
- Upload the ISO 20022 XML file from your local storage.
- The bank system will validate the XML schema and fields, ensuring that it complies with the required structure (pain.013.001 for Request for Payment).
- The XML will contain the following key
fields:
- Payer Information (debtor)
- Payee Information (creditor)
- Payment Amount
- Payment Reference
Example: ISO 20022 XML Request for Payment File
xml
<?xml version="1.0" encoding="UTF-8"?>
<Document xmlns="urn:iso:std:iso:20022:tech:xsd:pain.013.001.07">
<FIToFIPmtReq>
<GrpHdr>
<MsgId>RFP-987654321</MsgId>
<CreDtTm>2024-09-13T10:30:00</CreDtTm>
<NbOfTxs>1</NbOfTxs>
</GrpHdr>
<PmtReq>
<ReqdColltnDt>2024-09-14</ReqdColltnDt>
<PmtTpInf>
<SvcLvl>
<Cd>URGP</Cd>
</SvcLvl>
</PmtTpInf>
<Dbtr>
<Nm>Jane Smith</Nm>
<PstlAdr>
<Ctry>US</Ctry>
</PstlAdr>
</Dbtr>
<DbtrAcct>
<Id>
<IBAN>US987654321098765432</IBAN>
</Id>
</DbtrAcct>
<Cdtr>
<Nm>Acme Corporation</Nm>
<PstlAdr>
<Ctry>US</Ctry>
</PstlAdr>
</Cdtr>
<CdtrAcct>
<Id>
<IBAN>US123456789012345678</IBAN>
</Id>
</CdtrAcct>
<Amt>
<InstdAmt Ccy="USD">1500.00</InstdAmt>
</Amt>
<RmtInf>
<Ustrd>Invoice Payment Request for Invoice-98765</Ustrd>
</RmtInf>
</PmtReq>
</FIToFIPmtReq>
</Document>
For CSV Format:
- Select CSV as the file type in the dashboard.
- Upload the CSV file from your local computer.
- Make sure the CSV contains the necessary
fields:
- Transaction ID
- Debtor Information (payer)
- Creditor Information (payee)
- Amount
- Payment Date
- Payment Reference (invoice number)
Example: CSV File for Request for Payment
csv
RequestID,CreditorName,CreditorAccountNumber,DebtorName,DebtorAccountNumber,Amount,Currency,DueDate,Reference
RFP-12345,Acme Corporation,123456789,Jane Smith,987654321,1500.00,USD,2024-09-14,Invoice Payment Request for Invoice-98765
- Field Mapping: If necessary, map the CSV columns to the relevant fields in the bank’s system (e.g., map "Amount" to the bank’s Amount field).
For JSON Format:
- Select JSON as the file type if your bank supports JSON.
- Upload the JSON file that includes the relevant payment request data.
Example: JSON File for Request for Payment
json
{
"RequestForPayment": {
"RequestID": "RFP-12345",
"Amount": {
"currency": "USD",
"value": "1500.00"
},
"Creditor": {
"Name": "Acme Corporation",
"AccountNumber": "123456789"
},
"Debtor": {
"Name": "Jane Smith",
"AccountNumber": "987654321"
},
"DueDate": "2024-09-14",
"Reference": "Invoice Payment Request for Invoice-98765"
}
}
For Custom XML (Non-ISO 20022) Format:
- Select XML as the file format if your bank uses a custom XML format.
- Upload the XML file and map the fields as necessary to ensure the system recognizes the payer, payee, amount, and payment date.
5. Validate and Review the Upload
After uploading, your bank’s system will likely validate the file for:
- Payer Information (correct account details, names)
- Payee Information
- Amount (ensure it matches the expected payment)
- Payment Reference (match it to the correct invoice or request ID)
If the validation detects errors, correct the issues (e.g., missing fields or invalid data) and re-upload the file.
6. Confirm and Submit the Request
Once the file passes validation:
- Review the Request for Payment details such as amount, payee, and payment reference.
- Submit the file to the bank’s system for processing.
7. Monitor Payment Status
After submission, track the status of the payment request:
- Pending: The payment request is awaiting action by the payer.
- Completed: The payment has been successfully processed by the payer.
- Failed: There was an issue processing the request (e.g., insufficient funds or invalid data).
Most financial institutions will provide a Transaction History or Payment Status section where you can monitor the progress.
8. Reconcile Payment (Optional for Businesses)
Once the payment is processed:
- Reconcile the payment in your accounting or ERP system by matching it with the corresponding invoice or transaction.
- If needed, download the payment confirmation or transaction report from the bank’s dashboard for your records.
Common Use Cases for RTP RFP Uploads
B2B (Business-to-Business) Example:
- Scenario: A supplier sends a Request for Payment to a client for goods delivered. The client processes the payment via their financial institution.
- File: The supplier uploads an ISO 20022 XML file to their bank’s dashboard, initiating a payment request linked to an invoice.
B2C (Business-to-Consumer) Example:
- Scenario: A service provider sends a payment request to a customer for a subscription service.
- File: The service provider uploads a CSV file through their credit union’s dashboard, and the customer receives the payment request for review and authorization.
Key Considerations:
- File Format Compatibility: Ensure the format (ISO 20022 XML, CSV, JSON, XML) is supported by your bank or credit union’s system.
- Field Mapping: Properly map file fields (e.g., payer, payee, amount) to your bank’s required fields.
- Validation: Review the file post-upload to avoid errors in processing.
- Monitoring: Keep track of the payment request’s status until the payment is completed.
Conclusion
Importing a Real-Time Payments Request for Payment (RFP) file via https://Real-TimePayments.com into your Bank or Credit Union’s dashboard involves uploading the appropriate file format, validating the data, and tracking the status. The steps outlined above provide a comprehensive guide to ensure the smooth processing of payment requests in both B2B and B2C contexts.
Would you like assistance with a specific bank platform, or need help preparing the file for upload? Let us know!
Creation Request for Payment Bank File
Call us, the .csv and or .xml Request for Payment (RfP) file you need while on your 1st phone call! We guarantee our reports work to your Bank and Credit Union. We were years ahead of competitors recognizing the benefits of RequestForPayment.com. We are not a Bank. Our function as a role as an "Accounting System" in Open Banking with Real-Time Payments to work with Billers to create the Request for Payment to upload the Biller's Bank online platform. U.S. Companies need help to learn the RfP message delivering their bank. Today Payments' ISO 20022 Payment Initiation (PAIN .013) shows how to implement Create Real-Time Payments Request for Payment File up front delivering a message from the Creditor (Payee) to it's bank. Most banks (FIs) will deliver the message Import and Batch files for their company depositors for both FedNow and Real-Time Payments (RtP). Once uploaded correctly, the Creditor's (Payee's) bank continues through a "Payment Hub", will be the RtP Hub will be The Clearing House, with messaging to the Debtor's (Payer's) bank.
... easily create Real-Time Payments RfP files. No risk. Test with your bank and delete "test" files before APPROVAL on your Bank's Online Payments Platform.
Today Payments is a leader in the evolution of immediate payments. We were years ahead of competitors recognizing the benefits of Same-Day ACH
and Real-Time Payments funding. Our business clients receive faster
availability of funds on deposited items and instant notification of
items presented for deposit all based on real-time activity.
Dedicated to providing superior customer service and
industry-leading technology.
1) Free ISO 20022 Request for Payment File Formats, for FedNow and Real-Time Payments (The Clearing House) .pdf for you manually create "Mandatory" (Mandatory data for completed file) fields, start at page 4, with "yellow" highlighting. $0.0 + No Support
2) We create .csv or .xml formatting using your Bank or Credit Union. Create Multiple Templates. Payer/Customer Routing Transit and Deposit Account Number may be required to import with your bank. You can upload or "key data" into our software for File Creation of "Mandatory" general file.
Fees = $57 monthly, including Support Fees and Batch Fee, Monthly Fee, User Fee, Additional Payment Method on "Hosted Payment Page" (Request for file with an HTML link per transaction to "Hosted Payment Page" with ancillary payment methods of FedNow, RTP, ACH, Cards and many more!) + $.03 per Transaction + 1% percentage on gross dollar file,
3) Payer Routing Transit and Deposit Account Number is NOT required to import with your bank. We add your URI for each separate Payer transaction.
Fees Above 2) plus $29 monthly additional QuickBooks Online "QBO" formatting, and "Hosted Payment Page" and WYSIWYG
4) Above 3) plus Create "Total" (over 600 Mandatory, Conditional & Optional fields of all ISO 20022 Pain .013) Price on quote.
Each day, thousands of businesses around the country are turning their transactions into profit with real-time payment solutions like ours.
Activation Dynamic RfP Aging and Bank Reconciliation worksheets - only $49 annually
1. Worksheet Automatically Aging for Requests for Payments and Explanations
- Worksheet to determine "Reasons and Rejects Coding" readying for re-sent Payers.
- Use our solution yourself. Stop paying accountant's over $50 an hour. So EASY to USE.
- No "Color Cells to Match Transactions" (You're currently doing this. You won't coloring with our solution).
- One-Sheet for Aging Request for Payments
(Merge, Match and Clear over 100,000 transactions in less than 5 minutes!)
- Batch deposits displaying Bank Statements are not used anymore. Real-time Payments are displayed "by transaction".
- Make sure your Bank displaying "Daily FedNow and Real-time Payments" reporting for "Funds Sent and Received". (These banks have Great Reporting.)
Contact Us for Request For Payment payment processing