Activity Report

Document Version 1.1

Changelog

Report Definition

The Activity Report is a daily report that contains all transactions that were Submitted for Settlement or Settlement Declined from the previous processing day. The purpose of this report is to provide projected disbursement dates and total transaction fees for all transactions to aid in forecasting receivables from PayPal. By saving the projected disbursement dates for all transactions in your system of record, you will be able to more easily track transactions that will be disbursed in the future. For merchants who offer installments, this report will also capture any adjustments to future installment disbursement that may occur due to credit card disputes or refunds.

For merchants who process credit cards (with or without installments), this report will contain the Projected Disbursement Date for the following type of transactions:

• Credit card sale and refund transactions
• Debit card sale and refund transactions
• Newly created installment transactions
• Adjustments to installments

Obtaining projected disbursement dates

In Brazil, card-based transactions can take anywhere from 2 to 30 days to be disbursed depending on the card type. The default disbursement is 30 days, however a feature called Predefined Funds Anticipation allows merchants to pay a premium to accelerate the funding of credit card based transactions. For more information about this feature visit this page.

Whether you opt to pay for Predefined Funds Anticipation or not, it will be important to obtain and store the projected disbursement dates for all transactions and installments in your system of record so that you can track your receivables and forecast future disbursements.

Standard sale and refund transactions

To obtain the projected disbursement date for a standard sale or refund transaction, follow the below steps:

1. Filter the report on Record Type = Sale or Refund
2. Use the values in found in the Record ID column to match the IDs of transaction sales and refunds in your system of records
3. Save the value found in the Projected Disbursement Data column along with the transaction in your system

Sale transactions with installments

When a sale transaction is created and submitted for settlement with installments, the transaction response object will contain the following data for each installment:

• Installment ID
• Installment Amount

When the installments are initially created, the Projected Disbursement Date will be NULL and will be populated within twelve hours.

Installment records should be stored separately from standard sale transactions in your system of record because they will be paid out over time, so tracking them individually will be required in order to reconcile PayPal’s data with your system of record, and with your deposit bank account.

Steps to locate installment projected disbursement dates

1. Select all records where Record Type = Installment and Record Subtype is empty.
2. Once the installment records are filtered to just those that represent newly created installments, iterate through the set using the Record ID column to identify the installment ID for which the record pertains to.
3. Locate the Projected Disbursement Date field, add this date to your system of record, and save it with the installment record.

Installment adjustments

The amount of an installment can be affected by two types of payment events:

• Full and partial refunds
• Full and partial disputes

Whenever a transaction with installments is refunded or has a dispute that has Lost associated with it, every installment will have its amount adjusted equally.

Additionally, adjustments can occur on both installments previously disbursed as well as installments that are to be disbursed in the future.

In the case an adjustment is made to an installment that has previously been disbursed, the adjustment amount will be netted out of the next disbursement, so it’s important to track the installment adjustments as they are created so that you can reconcile the installment disbursements with both your deposit account and your system of record.

Types of installment adjustments

Refunds

In the case of refunds, each installment will be reduced by the amount of the refund divided by the number of installments.

Disputes

Dispute adjustments are typically negative adjustments and will reduce installment amounts. In some cases, disputes can be reversed, resulting in a positive adjustment.

Steps to locate information in the Activity Report

In order to maintain your system of records for installments, you will need to save installment adjustment records separately.

1. To isolate the installment adjustment records, select all records with Record Type = Installment and Record Subtype = Adjustment from the Daily Activity Report
2. Iterate through the installment adjustment records, using the Record ID field to identify the installment ID and save the following fields:
   • Settlement Amount – This will be used to obtain the amount of the adjustment. Add this value to the installment amount in your system of record to obtain the new amount for the installment.
   • Installment Disbursed
     • If TRUE then the installment’s adjustment amount will be netted from a future disbursement whose date can be obtained from the Projected Disbursement Date field. Installment adjustments for previously disbursed installments should be tracked as separate objects in your system of record because they will have their own money movement event, and will need to be reconciled using the Disbursement Report.
     • If FALSE then only future disbursed installments will be affected. In this case, the installment adjustment will have the same projected disbursement date as the installment.
   • Projected Disbursement Date – This is the date the adjustment amount will be netted from a future disbursement
   • Reason – This is the reason for the adjustment. The reason will either be a refund or dispute.
   • Adjuster ID – This is the ID of the object in your system that caused the installments to be adjusted.
     • When Reason = refund the Adjuster ID will be the ID of the refund in your system.
     • When Reason = dispute the Adjuster ID will be the ID of the dispute in your system.

Data dictionary of Activity Report

Record types and subtypes

Payment instrument types and subtypes

Changelog