PayPal Reports

Overview

Reports are generated every 24 hours and placed on the PayPal site and the FTP server by 12pm daily in the leading time zone of the reporting window. Character encoding for reports is UTF-8.

Retention

The report is available via PayPal's website and the secure FTP server for 45 days after its delivery to the server.

Versioning

In the future, these reports may be available in multiple versions. To take advantage of new versions, you can receive two versions of the same report concurrently (or non-consecutive versions of the same report) for testing and integration purposes. Contact your account manager for information on new or deprecated versions of the report, to enable access to different versions, and to request any changes in report distribution.

File record limit

Some daily report files, available online and as SFTP reports, support up to 1 million transactions. If a day’s transactions exceed this limit, PayPal splits the report across multiple files.

Access reports

To access reports, you'll need to contact your account manager or Merchant Technical Support to set up access to the reporting and batch job schedulers and to set the data format, CSV or TAB, for your reports.

After you've set up access, you'll also need to create an SFTP user account on the PayPal site.

Create an SFTP user account

PayPal’s report server is a secure file transfer protocol (SFTP) server that enables business partners and large merchants to fetch PayPal processing results. You can communicate with the server through the command line or any SFTP client of your choice, such as WinSCP, Cyberduck, or FileZilla. See PayPal Secure FTP Server Specification for more information about communicating with the server after you've set up your account.

  1. Contact your account manager to set up report access and parameters.
  2. Once report access is enabled, log in to your PayPal account.
  3. Click the settings icon in the upper right-hand corner of the page and then click Account Settings.
  4. On the Account access page, click Update next to the Secure FTP Users item.
  5. Follow the instructions on the screen until you complete the user account setup and the final screen displays the new user information.

Note: It can take up to 48 hours to create an SFTP server user account. PayPal sends an email message to your primary email address when the server is ready.

Troubleshooting: The PayPal account user interface recently changed. If you're having trouble finding the Secure FTP Users item after your account has been enabled, refer to Secure SFTP Server Users. Your PayPal account must be enabled for report access before you can create an SFTP user account.

Download reports

Download your reports from PayPal’s live or sandbox environment.

To use command-line SFTP to retrieve reports:

  1. Open a Terminal window.

    • To access reports on sandbox:

      $ sftp sftp_account_username@reports.sandbox.paypal.com
      
    • To access reports on live:

      $ sftp_account_username@reports.paypal.com
      
  2. Enter your SFTP account password.

  3. Change directory to your outgoing reports:

    $ cd ppreports/outgoing
    
  4. List the files in this directory:

    $ ls
    
  5. Download report files:

    $ Get filename
    
  6. Log off the reporting server:

    $ `exit`
    

For more information about retrieving reports by using an SFTP client such as WinSCP for Windows, go to PayPal's Merchant Technical Support website and search for retrieve reports.

Feedback