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:
|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:|
|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.|
On the Admin menu, select Reports > Sales > PayPal Settlement Reports.
PayPal Reference ID Type
One of the following reference codes:
Preapproved Payment ID
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.
The date when the settlement report was generated.
The encrypted merchant account number generated by PayPal.
The identification of a transaction of the money moving event. Transaction ID is generated by PayPal and cannot be changed by the merchant.
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.
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.
The date and time the transaction was initiated.
The date and time the transaction was completed.
The amount of the payment between the two parties and before fees.
The amount of fee associated with the settlement. All transaction fees are included in this amount. Fees are never amortized across several transactions.