QuickBooks® Importing Real-Time Payment File Invoicing

• 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 import a Real-Time Payment (RTP) file into your version of QuickBooks Online (QBO) or QuickBooks Desktop using https://SecureQBPlugin.com, you'll need to follow a process that involves uploading and mapping the payment file (in formats such as ISO 20022, CSV, XML, or JSON) into your QuickBooks environment using SecureQBPlugin as a middleware tool. This allows for seamless integration of payment files into your accounting system.

Here’s a step-by-step guide:

Step 1: Set Up SecureQBPlugin

1. Visit SecureQBPlugin.com and create an account.
2. Install and configure the SecureQBPlugin on your system.
   • Ensure that the plugin is connected to your QuickBooks Online (QBO) or QuickBooks Desktop version.
   • Follow the configuration instructions to authenticate the plugin with your QuickBooks account. This may involve entering your QuickBooks credentials or generating tokens to allow access.

Step 2: Obtain the Real-Time Payment File

Ensure that your Real-Time Payment (RTP) file is in a compatible format. SecureQBPlugin typically supports:

• ISO 20022 XML
• CSV
• JSON
• Custom XML (Non-ISO 20022)

Make sure the file includes the necessary details:

• Transaction ID
• Sender and Receiver Information
• Amount
• Currency
• Payment Date
• Payment Reference (such as an invoice number)

Step 3: Log into QuickBooks

• Log into your QuickBooks Online (QBO) or QuickBooks Desktop account.
• Ensure you have the appropriate permissions to import transactions.

Step 4: Open SecureQBPlugin

Once you’re logged into QuickBooks, open the SecureQBPlugin from your desktop or browser extension (depending on your version).

• Ensure that SecureQBPlugin is connected to your QuickBooks account.
• The plugin will act as the middleware to upload the RTP file into QuickBooks.

Step 5: Upload the Real-Time Payment File via SecureQBPlugin

Follow these steps to upload the Real-Time Payment file using SecureQBPlugin:

For ISO 20022 XML Format:

1. Select the ISO 20022 XML format within the plugin.
2. Browse and upload the XML file from your system.
3. The plugin will automatically parse the ISO 20022 XML structure and extract the necessary fields like payer, receiver, amount, currency, and transaction details.
4. Map the fields if required by the plugin to ensure that each field corresponds to the correct QuickBooks field.

For CSV Format:

1. If your file is in CSV format, select CSV as the file type in SecureQBPlugin.
2. Upload the CSV file, ensuring that it has the necessary columns (Transaction ID, Sender, Receiver, Amount, Date, etc.).
3. Map the CSV columns to the appropriate fields in QuickBooks (e.g., mapping "Amount" in the CSV to the "Amount" field in QuickBooks).
4. Confirm that the fields align properly before proceeding.

For JSON Format:

1. If your file is in JSON, upload the JSON file in the same way.
2. The plugin will parse the JSON structure, automatically mapping the payment fields (e.g., Transaction ID, Amount, Sender, Receiver) to their corresponding fields in QuickBooks.

For XML (Non-ISO 20022) Format:

1. If your system uses custom XML, upload the file through the XML upload section in SecureQBPlugin.
2. Map the XML elements (such as payer, amount, and receiver) to QuickBooks fields as required by the plugin.

Step 6: Map Fields and Validate the Data

Once you’ve uploaded the RTP file, SecureQBPlugin will guide you through the process of field mapping. You need to ensure that:

• The Transaction Amount from the RTP file is mapped to the correct Amount field in QuickBooks.
• The Payee (Receiver) information is mapped to the relevant Customer or Vendor field.
• The Transaction Date is correctly applied.
• Any Payment Reference (e.g., invoice number) is correctly assigned to the Reference Number field in QuickBooks.

Validate the data after mapping:

• Verify the details such as payment amount, payee, and transaction reference.
• Ensure there are no mismatches or errors during the mapping process.

Step 7: Confirm and Complete the Import

Once all fields are correctly mapped and the data is validated:

• Click Confirm or Complete Import in SecureQBPlugin.
• The plugin will transfer the payment data from the RTP file into QuickBooks.

The imported data will be reflected in QuickBooks as:

• Sales Receipts
• Payments Received
• Journal Entries, depending on your setup in QuickBooks and how the payments need to be categorized.

Step 8: Review Imported Transactions in QuickBooks

After the RTP file is successfully imported:

1. Navigate to the Banking or Transactions section in QuickBooks Online or Desktop.
2. Review the imported payment data.
3. Reconcile the payment against invoices, bills, or other payment requests in QuickBooks to ensure everything aligns correctly.

Step 9: Reconcile and Finalize (Optional)

For businesses, you may want to reconcile the payment data with your accounting records:

• Go to the Reconciliation section in QuickBooks.
• Match the payment transactions with corresponding invoices or transactions.
• Finalize the reconciliation process once everything is balanced.

Example File Formats for Real-Time Payment Files

ISO 20022 XML Example:

<?xml version="1.0" encoding="UTF-8"?>

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

  <CstmrCdtTrfInitn>

    <GrpHdr>

      <MsgId>RTP-987654321</MsgId>

      <CreDtTm>2024-09-13T10:00:00</CreDtTm>

      <NbOfTxs>1</NbOfTxs>

      <CtrlSum>500.00</CtrlSum>

      <InitgPty>

        <Nm>John Doe</Nm>

      </InitgPty>

    </GrpHdr>

    <PmtInf>

      <PmtInfId>Payment-12345</PmtInfId>

      <PmtMtd>TRF</PmtMtd>

      <BtchBookg>false</BtchBookg>

      <NbOfTxs>1</NbOfTxs>

      <CtrlSum>500.00</CtrlSum>

      <PmtTpInf>

        <SvcLvl>

          <Cd>URGP</Cd> <!-- Urgent Payment -->

        </SvcLvl>

      </PmtTpInf>

      <Dbtr>

        <Nm>John Doe</Nm>

      </Dbtr>

      <DbtrAcct>

        <Id>

          <IBAN>US123456789012345678</IBAN>

        </Id>

      </DbtrAcct>

      <Cdtr>

        <Nm>Jane Smith</Nm>

      </Cdtr>

      <CdtrAcct>

        <Id>

          <IBAN>US987654321098765432</IBAN>

        </Id>

      </CdtrAcct>

      <Amt>

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

      </Amt>

      <RmtInf>

        <Ustrd>Invoice-98765</Ustrd> <!-- Unstructured Remittance Information -->

      </RmtInf>

    </PmtInf>

  </CstmrCdtTrfInitn>

</Document>

CSV Example:

csv

Copy code

TransactionID,SenderName,SenderAccountNumber,ReceiverName,ReceiverAccountNumber,Amount,Currency,PaymentDate,Reference

RTP-12345,John Doe,123456789,Jane Smith,987654321,500.00,USD,2024-09-13,Invoice-98765

JSON Example:

json

Copy code

{

  "RealTimePayment": {

    "TransactionID": "RTP-12345",

    "Amount": {

      "currency": "USD",

      "value": "500.00"

    },

    "Sender": {

      "Name": "John Doe",

      "AccountNumber": "123456789"

    },

    "Receiver": {

      "Name": "Jane Smith",

      "AccountNumber": "987654321"

    },

    "PaymentDate": "2024-09-13",

    "Reference": "Invoice-98765"

  }

}

Conclusion

Using SecureQBPlugin to import Real-Time Payment (RTP) files into QuickBooks Online or QuickBooks Desktop enables seamless integration of payment data. The process ensures that you can easily handle multiple file formats (ISO 20022, CSV, JSON, etc.) and map payment information to QuickBooks fields for accurate accounting and reconciliation.

Let us at SecureQBPlugin.com know if you need more assistance with specific steps, formats, or configurations!

Allow us to offer and create an electronic payment processing program to provide you access to your funds in an expeditious manner.

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.