Disbursement Report

Document Version 1.1

Changelog

Report Definition

To reconcile your daily deposits from PayPal and Braintree with your system of records to clear your receivables, you will need to use the Disbursement Report. This report will contain both summarized and event-level detail of every payment event that impacted a deposit from PayPal and Braintree to your deposit bank account.

Report format

The Disbursement Report contains 4 sections:

• Header
• Summary
• Detail
• Footer

Header

The Header section will contain report configuration and status information. This is where you will find information like the timezone of the data in the report, or report name.

Summary

The Summary section will contain summarized data about the disbursement batches from the reporting period. Each disbursement batch will appear as a line-item in this section and will have information like the total amount disbursed per merchant account, the transfer ID of the disbursement, and the bank account to which the funds were disbursed.

Detail

The Detail section will contain line-item detail for all the disbursement impacting events (e.g. transactions, disputes, etc.).

Footer

This section will provide data that can be used to verify that the number of records ingested into your system matches the number of records in the file. It will also include the total number of files generated for the day and the sequence number of the files within that set.

How to Use the Report

Reconciling deposit amount to funding account in PayPal

Below are the steps to reconcile the line-item deposit records from PayPal on your bank statement with the Disbursement Report:

1. Match each deposit amount from PayPal on your bank statement with the amounts found in the Net Disbursed Amount columns of the Summary section of the Disbursement Report
2. Locate the Funding Account for each deposit line-item in the Summary section. For Brazil, this value will always be a PayPal Account Number because both PayPal Wallet and Credit/Debit Card transactions are disbursed through a PayPal account.
3. Use the values found in the Funding Account column of the Summary section for each line-item deposit to identify the rows in the Detail section that belong to each deposit.
4. Sum the values found in Net Disbursed column for each group of rows filtered by Funding Account. The sum for each group will match the amounts found in the Summary sections

Once you have confirmed that all the disbursement impacting items (e.g. transactions, disputes, etc) are present in the report, you can begin reconciling the items by Record Type as outlined in the following sections.

Reconciling standard sales and refunds

To reconcile standard sales and refunds records that have been disbursed to your bank account, follow the below methodology:

1. Locate records where Record Type is either Sale or Refund.
2. With the Sale and Refund records selected, iterate through the set using the Record ID field to locate the Transaction ID, and ingest the following data at a minimum:
   • Disbursement Date – The date the installment was disbursed
   • Transfer ID – The unique ID include in the descriptor on the bank transfer. Summing all the Net Disbursed items in the disbursement report by Transfer ID will equal the deposit amount in your bank account.
   • Net Disbursed – The amount of the installment net fees, in disbursement currency, that was included in the deposit.

Reconciling installments

To reconcile the installments that have been disbursed to your bank account, follow the below methodology:

1. Locate records where Record Type = installments and Record Subtype = disbursements.
2. With the installment disbursement records selected, iterate through the installments using the Record ID field to locate the Installment ID, and ingest the following data at a minimum:
   • Disbursement Date – The date the installment was disbursed
   • Transfer ID – The unique ID include in the descriptor on the bank transfer. Summing all the Net Disbursed items in the disbursement report by Transfer ID will equal the deposit amount in your bank account.
   • Net Disbursed – The amount of installment net fees, in disbursement currency, that was included in the deposit.
3. Locate records where Record Type = Installments and Record Subtype = Adjustments, and repeat step 2, but for the adjustment records in your system of record.

Reconciling disputes

To reconcile disputes that have impacted your disbursement, follow the below methodology:

1. Locate records where Record Type = Dispute.
2. With the dispute records selected, iterate through disputes using the Dispute ID column to identify the dispute.
3. Match the value in the Net Disbursed column with the disputed amount.
   • If Record Subtype = Chargeback then the dispute should have a status of Lost and should be a negative amount
   • If Record Subtype = Chargeback reversal then the dispute should have a status of Won and be a positive amount

Data dictionaries for Disbursement Report sections

Report Header Data Dictionary

Report Summary Data Dictionary

Report Detail Data Dictionary

Footer Data dictionary

Record types and subtypes

Payment instrument types and subtypes

Changelog