DocumentationCommerceStores and Purchase Experience

PayPal Settlement report

Last update: Mon Jul 17 2023 00:00:00 GMT+0000 (Coordinated Universal Time)

CREATED FOR:

  • Beginner
  • Intermediate
  • Admin
  • User

The PayPal Settlement report provides merchants with the information about each transaction that affects the settlement of funds.

NOTE
Before generating settlement reports, the store administrator must request PayPal Merchant Technical Services to create an SFTP user account, enable settlement reports generation, and enable SFTP in their PayPal business account.

After configuring and enabling settlement reports in the PayPal merchant account, Adobe Commerce and Magento Open Source will start generating reports during the following 24 hours. The list of available settlement reports can be viewed from the Admin.

To view settlement reports:

  1. On the Admin sidebar, go to Reports > Sales > PayPal Settlement.

    PayPal Settlement Reports {width="600" modal="regular"}

  2. For the most recent updates, click Fetch Updates in the upper-right corner.

    The system connects to the PayPal SFTP server to fetch the reports. When the process is complete, a message appears with the number of reports fetched. The report includes the following information for each transaction:

    table 0-row-2 1-row-2 2-row-2 layout-auto
    Report column Description
    PayPal Reference ID Type One of the following reference codes:
    - Order IDT
    - Transaction ID
    - Subscription ID
    Preapproved Payment ID Custom - The text entered by the merchant on the transaction at PayPal.
    Transaction Debit or Credit - The direction of money movement of gross amount.
    Fee Debit or Credit - The direction of money movement for fee.
recommendation-more-help
dacea746-44a9-4368-b3fb-3bcff64c6be1