Magento Commerce, 2.3.x

PayPal Settlement Reports

The PayPal Settlement report provides the store administrator with the information about each transaction that affects the settlementSettlement occurs when the acquiring bank and the issuer exchange funds and the proceeds are deposited into the merchant account. of funds.

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 accountAn account with a bank or financial institution that makes it possible to accept credit card transactions., Magento will start generating reports during the following twenty-four hours. The list of available settlement reports can be viewed from the AdminThe password-protected back office of your store where orders, catalog, content, and configurations are managed..

To view settlement reports:

1. On the Admin sidebar, tap Reports. Then under Sales, choose select PayPal Settlement.
2. For the most recent updates, tap 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:

  • Field Descriptions

    Field

    Description

    PayPal Reference ID Type

    One of the following reference codes:

    Order ID

    Transaction ID

    Subscription ID

    Preapproved Payment ID

    Options include:

    Custom

    The text entered by the merchant on the transaction in PayPal.

    Transaction Debit or Credit

    The direction of money movement of gross amount.

    Fee Debit or Credit

    The direction of money movement for fee.