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

Before generating settlement reports, the store administrator must contact PayPal Merchant Technical Services to create an SFTP user account, and enable settlement reports and SFTP for the PayPal business account.

After configuring and enabling settlement reports in the PayPal merchant account, Magento will start generating reports within twenty-four hours.

The store administrator can fetch the most recent settlement reports by clicking the Fetch Updates button located in the upper right part of the page. After clicking it, a dialog box appears, stating that the system will connect to the PayPal SFTP server to fetch the reports. When all recent reports are added to the list, the Infolog message appears, stating the number of reports fetched. The report includes the following additional information for each transaction:

To enable settlement reports:

1.

On the Admin menu, select System > Configuration. Then in the panel on the left under Sales, select Payment Methods.

2.

Click the Configure button for one of the following PayPal solutions:

• PayPal Express Checkout
• PayPal Payments Advanced (includes Express Checkout)
• PayPal Payments Pro (includes Express Checkout)

3.

Scroll down to the Settlement Report Settings section, and do the following:

Settlement Report Settings

a.

Enter your SFTP Credentials.

b.

Complete the remaining information according to your business requirements.

For detailed configuration instructions, see the topic for your PayPal solution.

c.

When complete, click the Save Config button.

To view the settlement reports:

On the Admin menu, select Reports > Sales > PayPal Settlement Reports.

• Field Descriptions

  Field	Description
  PayPal Reference ID Type	One of the following reference codes: Order ID Transaction ID Subscription ID
  Preapproved Payment ID	Options: 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.

• Settlement Report

  Field	Description
  Report Date	The date when the settlement report was generated.
  Merchant Account	The encrypted merchant account number generated by PayPal.
  Transaction ID	The identification of a transaction of the money moving event. Transaction ID is generated by PayPal and cannot be changed by the merchant.
  Invoice ID	The identification of an invoice generated within Magento. The field can be populated with either an invoice ID sent with the capture request or with the value of the invoice ID (if any) from the authorizing transaction.
  PayPal Reference ID	The identification of a related, pre-existing transaction or event.
  Event Code	The code assigned to the transaction according to the event that has initiated it. Among these can be website payments standard payment, express or direct checkout API, pre-approved payment, subscription payment, and so on.
  Initiation Date	The date and time the transaction was initiated.
  Completion Date	The date and time the transaction was completed.
  Gross Amount	The amount of the payment between the two parties and before fees.
  Fee Amount	The amount of fee associated with the settlement. All transaction fees are included in this amount. Fees are never amortized across several transactions.