Upload Real-Time Payments

To create and upload a Real-Time Payments (RTP) Request for Payment (RfP) file into your business bank, follow these steps:

1. File Creation

• File Format: RTP RfP files are typically created in CSV, XML, or ISO 20022 (PAIN .013) format. CSV is simpler and more commonly used for small-scale businesses, while ISO 20022 is often preferred for more structured and internationally standardized communication.
• Required Fields:
  • RequestID: Unique identifier for the payment request.
  • Creditor Name: Name of the company or individual requesting the payment.
  • Creditor Account Number: Bank account information of the requester.
  • Debtor Name: Name of the payer (customer or business).
  • Debtor Account Number: Payer’s bank account details.
  • Amount: Payment amount.
  • Currency: The currency in which the payment is requested (e.g., USD, EUR).
  • Due Date: Date when the payment is due.
  • Payment Reference: Invoice number or reference for the payment.

Example (CSV Format):

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

Example (ISO 20022 XML Format):

xml

<Document xmlns="urn:iso:std:iso:20022:tech:xsd:pain.013.001.06">

  <RfpMsg>

    <GrpHdr>

      <MsgId>RF123456789</MsgId>

      <CreDtTm>2024-09-14T08:30:00Z</CreDtTm>

    </GrpHdr>

    <Rfp>

      <RfpId>INVOICE-12345</RfpId>

      <PmtInf>

        <PmtMtd>TRF</PmtMtd>

        <Amt>

          <InstdAmt Ccy="USD">1500.00</InstdAmt>

        </Amt>

        <ReqdExctnDt>2024-09-20</ReqdExctnDt>

        <Cdtr>

          <Nm>Acme Corporation</Nm>

          <CdtrAcct>

            <Id>

              <IBAN>123456789</IBAN>

            </Id>

          </CdtrAcct>

        </Cdtr>

        <Dbtr>

          <Nm>Jane Smith</Nm>

          <DbtrAcct>

            <Id>

              <IBAN>987654321</IBAN>

            </DbtrAcct>

        </Dbtr>

        <RmtInf>

          <Ustrd>Invoice Payment - INVOICE-98765</Ustrd>

        </RmtInf>

      </PmtInf>

    </Rfp>

  </RfpMsg>

</Document>

2. Upload the File to Your Bank

• Log into your business bank’s portal: Navigate to the payments or billing section where file uploads are allowed.
• Select the upload option: Choose the option to upload RTP RfP files.
• File Format Validation: Some banks may require specific formatting for RfP files. Ensure your file meets the validation checks (e.g., proper CSV headers or ISO 20022 compliance).
• Upload the file: Once the file is validated, you can upload it for processing.

3. Process the Payment Request

• Review the payment request: After uploading, double-check the amounts, payee, and payer information.
• Submit the request: Once validated, confirm and submit the payment request through the bank's system. Most banks will provide real-time updates on the status of your request.

4. Reconciliation

• After the payment is processed, make sure to reconcile the transactions in your QuickBooks or other accounting software. The integration with tools like SecureQBPlugin ensures that the transactions are reflected automatically.

By following these steps, you can ensure that your Real-Time Payment Requests (RfP) are processed accurately and efficiently through your business bank.

References:

• SecureQBPlugin offers solutions for creating CSV or XML RFP files tailored to real-time payments

Request Real-Time Payments

RequestPaymentFileFormat.

• ISO 20022 and CSV formats are commonly used for RFP messages, especially when integrated with QuickBooks​

Import Real-Time Payments

Real-Time Payment Request.