Mass Payments Reporting

<< Using the Mass Payments API

PayPal tracks information for Mass Payments for both the complete transaction and the individual payments sent to the recipients. You can view transaction information and details about those transactions on the PayPal website using the Transaction finder on the Reports page. You can also view this information by accessing the transactions list in the Activity section. In addition, you can view Mass Payments information in history logs, transaction logs, the Transaction Details report, and the Settlement report.

The following topics provide detailed information on how to view mass payment transaction information:

Using the Reports Page to Review Mass Payments Transactions

The Reports page displays financial and monthly sales trend information and provides a way to access sales activity reports and recurring payment information. In addition, this page contains a Transaction finder that you can use to search for Mass Payments transactions.

Searching for Mass Payments in the Reports Page

To search for specific Mass Payments transactions using the Reports page:

  1. Log in to your PayPal business account at www.paypal.com.

  2. Click Reports at the top of the page and then select Transactions > Transaction finder.

    Note: If you don't see Reports at the top of the page, navigate to My Account > History > Reports, and then select the Transaction finder link near the bottom of the page. The Transaction finder page opens.

  3. Specify your search criteria:

    • To search by a specific recipient, enter the recipient ID that you specified in the Mass Payments file, into the Search keyword(s) field. For example, if you used email addresses for the recipient ID, enter the recipient's email address.
    • To search by a specific date range, use the Date range calendar selection fields to specify a date range.
    • Select Mass Payments from the Transaction type dropdown menu.
  4. Specify any additional filters to use for this search by clicking the Filter your results link.

  5. Click Search. At the bottom of the Transaction finder page, the Search Transaction Results list displays all transactions that match your search criteria.

Search Transaction Results List

The Search Transaction Results list displays the following information for each transaction:

  • Date
  • Type
  • Name
  • Subject
  • Gross Amount
  • Fees
  • Net Amount

Within this list, you can perform the following actions:

  • Sort the transactions by Name or Gross Amount.
  • Click Print to print a copy.
  • Click Download to save the list to a file.

Downloading the Search Transaction Results

To download the complete set of transactions list results:

  1. In the Transaction finder page, enter search criteria and click Search to populate the Transaction Results list with the data that you want to download.
  2. Select a file type for the download from the list next to the Download button.
  3. Click Download and then follow the instructions within the dialog box to save the file.

Using the Activity Page to Review Mass Payment Transactions

Use the Activity page to view Mass Payments transactions that are successfully processed for your account. By default, the Activity page displays a list of the transactions from the last 30 days. Mass Payments transactions are identified by Mass Payment in the transaction title.

Viewing Transaction Details

To view the details of any specific Mass Payments transaction:

  1. Log in to your PayPal business account at www.paypal.com.

  2. Click Activity at the top of the page to open the Activity page.

    Note: If you don't see Activity at the top of the page, navigate to My Account > History > Advanced Search. This opens the Advanced History Search page, which is similar to the Activity page.

  3. Specify any of the following search criteria:

    • Select the time frame for the activity you want to display.
    • In the I'm looking for dropdown menu, select Payments received.
  4. Click View to start the search. The Activity list displays the results.

Viewing Transaction Logs

You can view or download a transaction log for your Mass Payments transactions. The Transaction log contains a summary of a mass payment transaction, such as date and time processed, and transaction status. It also contains detailed transaction information for each recipient.

  1. In the transaction list on the Activity page, click on the title of the transaction that you want to review. The Mass Payment Details page opens.
  2. Click View Details to open the BatchLog.txt dialog box.
  3. Save the log file. You can also open the log directly in an application.

Downloading History Logs

You can download Mass Payments information and save it on your computer using downloadable history logs. The Download History page allows you to specify a time frame for payments and transactions to include in these logs.

  1. Log in to your PayPal business account at www.paypal.com.

  2. Navigate to Reports > Transactions > Download history. Note that if you don't see Reports at the top of the page, then navigate to History > Download history.

  3. Select the desired date range and file type, and then click Download. This downloads a file of the specified format, which displays all transactions and their status values. Mass Payments are indicated by Mass Payments in the transaction title.

    Note: Payments denied by a recipient are not included in this report.

Receiving Instant Payment Notifications for Mass Payments

If you have Instant Payment Notification (IPN) enabled for your account, PayPal sends an IPN for each completed payment made during Mass Payments transaction processing. PayPal also generates a status for each payment. The status can be Completed, Failed, Reversed, or Unclaimed. For descriptions of the status values, see IPN and PDT Variable Reference in the Instant Payment Notification Guide. If recipients have IPN set up on their account, they will also receive an IPN for each completed payment.

For more information about Instant Payment Notifications, see the IPN Integration Guide.

Using the Settlement Report and the Transaction Detail Report

Note: The Settlement and Detailed Transaction reports can be used only by approved merchants and processing partners. Contact your PayPal account manager for more information.

The Settlement and Detailed Transaction reports identify different types of transactions with transaction event codes (T-codes).

Mass payment transactions display the following T-codes in these two reports:

  • T0001 - Mass Payment (successful)
  • T0104 - Mass Payment batch fee
  • T1105 - Reversal of a general account hold
  • T1114 - Mass Payment reversal transaction
  • T1115 - Mass Payment refund transaction
  • T1503 - Temporary hold on funds during processing

While the transaction is being processed, the transaction event code will appear in the report as T1503 when PayPal places a temporary hold to reserve the total Mass Payment amount plus the associated fees from your PayPal account. Once the Mass Payment batch has processed and the hold is released, the transaction event code will be T1105. The adjustment to your PayPal account balance will reflect the status of the individual transactions in that batch. After the release, if one or more transactions is declined, your PayPal account balance may exceed the available account balance shown during the period of the hold. The PayPal Reference ID column will allow you to track the associated transaction on hold. The original Transaction ID will be captured in this column.

Accessing the Settlement Report and the Transaction Detail Report

To access these reports from the PayPal website:

  1. Log in to your PayPal business account at www.paypal.com.

  2. Click Reports at the top of the page and then select Transactions > Settlement or Transactions > Transactions detail.

    Note: If you don't see Reports at the top of the page, navigate to My Account > History > Reports, and then select the Transaction detail report link.

These reports can also be accessed from the PayPal Secure FTP Server, which is defined and described in the Reporting FTP Server Specification document.

About Mass Payments and the Settlement Report

The Settlement Report contains summary information for transactions that affect your PayPal balance.

This report shows sent and refunded Mass Payments. Declined Mass Payments transactions do not appear in this report.

For more information about the Settlement report, see the Settlement Report Specification.

About Mass Payments and the Transaction Detail Report

The Transaction Details Report contains detailed information for transactions that affect your PayPal balance. This report shows all Mass Payment transactions. Declined Mass Payments transactions do not appear in this report.

For more information about the Transaction Detail report, see the Transaction Detail Report Specification.

Mass Payments FAQs >>