PayPal balance report
DocsBetaLast updated: March 22nd 2024, @ 5:46:30 am
Using the balance report, you can view:
- transactions that affect the settlement of funds in your accounts
- a summary of beginning and ending balances for your accounts
- daily balance changes
- expected settlements in the next 24 hours
The balance report is available through PayPal's website and the Secure FTP Server. For more information about using SFTP to access reports, see SFTP Reports .
How to use the PayPal balance report
Note: After you enable standard settlement, all transactions will be available for settlement on the next day. Contact your PayPal account manager to subscribe to this report and have it delivered by SFTP daily.
Use Cases | Report Type | Delivery Method | Recon Guide |
| Download a sample report |
| Reports Reconciliation Guide |
| Download a sample report |
| Reports Reconciliation Guide |
How to get the report
- Subscribe to the report to have it delivered to your SFTP folder. Reach out to your account team to subscribe to SFTP delivery.
- Generate and download the report from the PayPal portal.
Important: PayPal can enhance these reports and add additional attributes to the reports in the future. Use column names when integrating with these reports, so that your integrations don't break when new columns are added to the reports.
Know before you begin
- The report is only available in comma-separated values (CSV) format.
- The report uses UTF-8 (8-bit UCS/Unicode Transformation Format) character encoding.
- Amounts in this report are expressed in major units of currency. For example: dollars for USD and yen for JPY. See PayPal-supported currencies for a list of all ISO-4217 currency codes that PayPal supports for use with payments and balances.
- Money refunded from your account is shown with a minus sign. For example, -1000 USD is shown as the refunded amount.
- A single report file can contain a maximum of a million records. If the report contains more than a million records, the report is split across multiple files.
- For reports that are split over multiple files, only the first file has a report header record. Only the last file has a report footer and a report record count.
- The balance report is generated daily by 12:00 PM daily in the leading time zone of the reporting window. The report is available on the Secure FTP Server in the
/ppreports/outgoingdirectory
. For help with SFTP reports, see Access SFTP reports.
Report file name
The naming convention of the report filename is as follows: ABC1-6ABKUHNC34696-BTR_BALANCE_TRANSACTIONAL-REPORT-20220601-1-1-20220602000000.CSV
For more details about file naming convention, see the glossary
Report Specifications
All merchant reports include the following sections:
- Report Header
- Report Summary
- Report Details
- Report Footer
Your report contains the following sections:
CSV Code | Section | Description | Configurable |
RH | Report Header | This section includes following information:
| No |
RS | Report Summary | This section includes following information:
| No |
RD | Report Details | For balance transactional reports: This section includes all transactions that impacted the balances shown in the summary section. For balance summary reports: This section includes an aggregated view of all transactions that contribute to the balances in the summary section. | No |
RF | Report Footer | This section includes the following information:
| No |
RH: Report Header
This applies for both the balance transactional report and the balance summary report:
Position | Column name | Optional/Required | Data type | Description |
1 | RH | Required | Static, 2 characters | Indicates that this row of data contains report body data. |
2 | Report name | Required | Character varying (256) | Name of the report. The default name is `BALANCE_TRANSACTIONAL_REPORT` for a transactional report and `BALANCE_SUMMARY_REPORT` for a summary report. If the name is customized, the report shows the custom name. |
3 | Report status | Required | Success/Error | Report generation status. |
4 | Report generated | Required | YYYY-MM-DD | The date and time when the report file was generated, in the following format: YYYY/MM/DD where:
|
5 | Hierarchy | Required | Character varying (256) | Encrypted PayPal account number for an account holding individual account in PayPal. |
6 | Time zone | Required | Character varying (256) | Time zone of the report. |
RS: Report Summary Section
This applies for both the balance transactional report and the balance summary report:
Position | Column name | Optional/Required | Data type | Description |
1 | Account ID | Required | Character varying (256) | Encrypted account number of the merchant. |
2 | Balance | Required | Numeric (23, 2) | The beginning and ending balances for the day or the date range for which the report is generated. The beginning balance for the next day is usually the ending balance for the previous day. The ending balance is usually the opening balance and the sum of net amounts from transactions that happened during the day or a selected date range. |
3 | Currency | Required | 3-character currency code Max length: 3 characters | Currency of fee. See PayPal-supported currencies for possible values. |
4 | Available | Required | Numeric (23, 2) | Amount held by PayPal because of risk and compliance rules. After risk checks are cleared, the balance is available for you to withdraw. |
5 | Withheld | Required | Numeric (23, 2) | Amount held by PayPal because of risk and compliance rules. After risk checks are cleared, the balance is available for you to withdraw. |
6 | Total | Required | Numeric (23, 2) | The sum of your available and withheld balances. |
RD: Report Details
- Balance Transaction Report
- Balance Summary Report
Report details for the balance transaction report:
Position | Column name | Optional/Required | Data type | Description |
1 | Record ID | Required | Character varying (256) | Unique identifier for the transaction. |
2 | Related record ID | Optional | Character varying (256) | Unique ID of a previous transaction referenced by this transaction. For example, refund transactions also contain the ID of the original sale transaction. Use the Original Record ID to track the history of transactions associated with the original sale. |
3 | Original record ID | Optional | Character varying (256) | Unique ID of a previous transaction referenced by this transaction. For example, refund transactions also contain the ID of the original sale transaction. |
4 | Record type | Required | Character varying (256) | Type of the transaction. See the glossary for more information. |
5 | Record subtype | Optional | Character varying (256) | Subtype of the transaction. See the glossary for more information. |
6 | Merchant account ID | Required | Character varying (256) | Encrypted account number of the merchant. |
7 | Partner identifier | Optional | Character varying (256) | Partner Identifier |
8 | Invoice ID | Optional | Character varying (256) | The invoice ID passed at the time of transaction. |
9 | Original invoice ID | Optional | Character varying (256) | The invoice ID of the original sale transaction. Uses to link all transactions associated with the original invoice ID. |
10 | Custom Field | Optional | Character varying (256) | Custom field. |
11 | Payment instrument type | Optional | Character varying (256) | The method of payment used to process the transaction. See the glossary for more information. |
12 | Payment instrument subtype | Optional | Character varying (256) | The specific tender used to process the transaction. See the glossary for more information. |
13 | Created at | Required | YYYY-MM-DD HH:MM:SS | Date and time the transaction was initiated, in the following format: YYYY/MM/DD HH:MM:SS offset. Where:
|
14 | Record currency | Required | 3-character currency code Max length: 3 characters | Currency of the transaction. See PayPal-supported currencies for possible values. |
15 | Gross amount | Required | Numeric (23, 2) | Total amount of the transaction before deducting fees. |
16 | Total fees net billed | Optional | Numeric (23, 2) | The record of fees associated with the settlement. All transactional fees are included in this amount. This field contains the fee amount value for all transactions where a transactional fee has been processed. |
17 | Net amount | Required | Numeric (23, 2) | The net disbursed amount, which is the gross amount minus total fees billed. |
18 | Transfer ID | Optional | Character varying (256) | Unique ID passed at the time funds are withdrawn. Passed to the bank, Hyperwallet, or any external instrument that appears against the merchant's bank or Hyperwallet statement. |
19 | External payout instrument | Optional | Character varying (256) | Indicates where the withdrawal was paid out. For example, bank or HW (Hyperwallet). |
20 | Counterparty account ID | Optional | Character varying (256) | Encrypted account number of the counterparty. |
21 | Counterparty name | Optional | Character varying (256) | Name of the counterparty. |
22 | Case ID | Optional | Character varying (256) | The ID of the dispute if the transaction is tied to a dispute. |
23 | Store ID | Optional | Character varying (256) | ID of the store where the transaction was initiated. |
24 | Reader ID | Optional | Character varying (256) | Terminal ID in the store where the transaction was initiated. |
25 | Payment channel | Optional | Character varying (256) | Indicates if the transaction is online or offline. |
26 | Reason code | Optional | Character varying (256) | The reason for declining the transaction, when available. For credit card transactions, the code is a processor decline code. For bank transactions, the code is a bank decline code. For more information, see processor decline codes. For more information on UDD Sepa declines, refer here. |
27 | Payment tracking ID | Optional | Character varying (256) | The tracking ID specified by partners to obtain information about a payment or to request a refund. This value is not unique and can be blank. |
28 | Credit transaction fees | Optional | Numeric (23, 2) | The credit-related transaction fee amount for a merchant-selected credit offering. |
29 | Credit term | Optional | Character varying (256) | The time span covered by the merchant-selected credit offer. The length of the term is captured in months. |
30 | Annual percentage rate | Optional | Numeric (23, 4) | The interest rate for the year. |
31 | Campaign fees currency | Optional | 3-character currency code Max length: 3 characters | Currency of fee. See PayPal-supported currencies for possible values. |
32 | Campaign fees | Optional | Numeric (23, 2) | The fee charged to the merchant for each sale with the discount applied during the campaign. |
33 | Campaign Discount currency | Optional | 3-character currency code Max length: 3 characters | Currency of fee. See PayPal-supported currencies for possible values. |
34 | Campaign discount | Optional | Numeric (23, 2) | The discount amount applied in the transaction. Merchants can offer discounts as either a dollar amount or percentage to customers for marketing campaigns. |
35 | Campaign name | Optional | Character varying (256) | Name given to the campaign that merchants can track on the campaign dashboard. |
RF: Report Footer
This applies for both the balance transactional report and the balance summary report:
Position | Column name | Optional/Required | Data type | Description |
1 | RF | Required | Static 2 characters | Indicates that this row of data contains report footer data. |
2 | File number | Required | Numeric (23, 2) | The current file number, which is part of the file naming convention. |
3 | Total records | Required | Numeric (23, 2) | The number of transactions included in the detail section in a specific file. This field is shown in the report only if there are transactional details. |
4 | Total files | Required | Numeric (23, 2) | The number of files generated for the report. |