QuickBooks® Upload RfP

• ~ Automate Account Receivable Collection
• ~ Automate Account Payable Payments
• ~ One-time and Recurring Debits / Credits

Secure QB Plugin payment processing through QuickBooks ® specializes in the origination of moving money electronically.

Ask about our special:

Request for Payments

To upload FedNow and Real-Time Payments (RTP) Request for Payment (RfP) files into your business bank's dashboard, whether for one-time payments or batch recurring payments, using SecureQBPlugin integrated with QuickBooks Online (QBO), follow this step-by-step guide.

Steps to Upload FedNow and RTP RfP Files Using SecureQBPlugin Integrated with QBO

1. Install and Configure SecureQBPlugin

• Go to SecureQBPlugin.com and download the plugin.
• Install the plugin on your computer.
• During setup, you will be prompted to connect SecureQBPlugin to your QuickBooks Online account. Follow the instructions to authenticate and authorize the connection.

2. Prepare Payment Data in QuickBooks Online (QBO)

• Ensure that the invoices or payment requests are created in QuickBooks Online. These invoices should contain essential information such as:
  • Customer (Payer) information: Name, account number (IBAN for international), etc.
  • Payment amount.
  • Invoice number and due date.
  • Payment terms if applicable.

3. Configure One-Time or Recurring Payments

• For One-Time Payments: Select a single invoice or payment request for a specific customer.
• For Recurring Payments: Identify multiple invoices or payments for different customers. If recurring, ensure that payment terms like frequency (e.g., weekly, monthly) and start/end dates are defined in QBO.

4. Export the Request for Payment (RfP) File Using SecureQBPlugin

SecureQBPlugin enables you to export the Request for Payment (RfP) file in a format that is compatible with FedNow and RTP, such as ISO 20022 XML, CSV, or JSON.

• Open SecureQBPlugin from your system.
• Select the transactions (invoices, payments) that need to be exported.
• Choose Export Format: Select either ISO 20022 XML (Pain.013), CSV, or JSON, based on the requirements of your bank’s FedNow or RTP system.

Mapping Fields for Export:

• Ensure that SecureQBPlugin maps fields like:
  • Customer (Payer) information.
  • Payment amounts.
  • Invoice numbers.
  • IBAN (for international payments).
  • Currency and due dates.
  • Recurring schedule (for batch recurring payments).
• After mapping, export the file to your desired format.

Example File Formats:

Example ISO 20022 XML (Pain.013) for One-Time Payment:

xml

<Document>

  <CstmrCdtTrfInitn>

    <GrpHdr>

      <MsgId>ONEPAY001</MsgId>

      <CreDtTm>2024-09-15T12:00:00</CreDtTm>

      <NbOfTxs>1</NbOfTxs>

      <CtrlSum>1500.00</CtrlSum>

    </GrpHdr>

    <PmtInf>

      <PmtInfId>PmtInf001</PmtInfId>

      <PmtMtd>TRF</PmtMtd>

      <ReqdExctnDt>2024-09-15</ReqdExctnDt>

      <Dbtr>

        <Nm>Customer One</Nm>

      </Dbtr>

      <DbtrAcct>

        <Id>

          <IBAN>US1234567890</IBAN>

        </Id>

      </DbtrAcct>

      <Cdtr>

        <Nm>Your Business Name</Nm>

      </Cdtr>

      <CdtrAcct>

        <Id>

          <IBAN>US9876543210</IBAN>

        </Id>

      </CdtrAcct>

      <Amt>

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

      </Amt>

      <RmtInf>

        <Ustrd>Invoice #INV001</Ustrd>

      </RmtInf>

    </PmtInf>

  </CstmrCdtTrfInitn>

</Document>

Example CSV for Batch Recurring Payments:

csv

MsgId,DebtorName,DebtorIBAN,CreditorName,CreditorIBAN,Amount,Currency,InvoiceNumber,Frequency,StartDate,EndDate

BATCHPAY001,Customer One,US1234567890,Your Business Name,US9876543210,1500.00,USD,INV001,Monthly,2024-09-15,2025-09-15

BATCHPAY001,Customer Two,US2234567890,Your Business Name,US9876543210,2000.00,USD,INV002,Monthly,2024-09-15,2025-09-15

Example JSON for One-Time Payment:

json

{

  "Payment": {

    "MsgId": "ONEPAY001",

    "Debtor": {

      "Name": "Customer One",

      "IBAN": "US1234567890"

    },

    "Creditor": {

      "Name": "Your Business Name",

      "IBAN": "US9876543210"

    },

    "Amount": {

      "Currency": "USD",

      "Value": 1500.00

    },

    "RemittanceInformation": "Invoice INV001"

  }

}

5. Upload the RfP File into Your Business Bank’s Dashboard

Once the file is exported, log into your business bank’s FedNow or RTP dashboard to upload the RfP file.

One-Time Payment:

• Log in to the business banking portal.
• Navigate to the Real-Time Payments (RTP) or FedNow section.
• Upload the file: Select the RfP file generated by SecureQBPlugin (XML, CSV, or JSON).
• Review the payment details: Confirm the payer’s name, amount, and other details.
• Submit the payment: Once confirmed, your bank will process the payment and notify the payer to complete the transaction in real-time.

Batch Recurring Payments:

• Log in to the bank portal, and navigate to the Batch Payment section under FedNow or RTP.
• Upload the batch file that contains multiple transactions.
• Review the batch: Ensure all details, such as amounts, recurring schedules, and payers, are correct.
• Submit the batch: Your bank will schedule the recurring payments and process them according to the defined frequency (e.g., monthly).

Automating Future Payments (Optional):

• If your business handles frequent or recurring payments, consider automating the process using SecureQBPlugin’s scheduling feature or by using API integrations if supported by your bank.

6. Monitor Payment Status in the Bank’s Dashboard

• After submitting, monitor the payment status in your bank’s portal:
  • Real-time notifications will show when the payer responds and completes the payment.
  • For recurring payments, the bank will show each scheduled payment’s status, including any successful or failed transactions.

7. Reconcile Payments in QuickBooks Online

• After payments are processed by your bank, reconcile the payment transactions in QuickBooks Online:
  • Use SecureQBPlugin to import the payment confirmations from your bank.
  • Match the payments to the invoices in QBO for proper reconciliation.
  • Ensure that all remittance and payment information is accurate in QBO.

Final Thoughts

By following this process using SecureQBPlugin integrated with QuickBooks Online, you can efficiently export and upload FedNow and Real-Time Payments (RTP) Request for Payment files into your business bank’s dashboard for both one-time payments and batch recurring payments.

Let me know if you need assistance with any specific step or would like help automating parts of this process!

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) show how to implement Create Real-Time Payments Request for Payment File up front delivering 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 continuing through a "Payment Hub", will be the RtP Hub will be The Clearing House, with messaging to the Debtor's (Payer's) bank.

Our in-house QuickBooks payments experts are standing ready to help you make an informed decision to move your company's payment processing forward.

 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.