Report fields and formats reference

Activity Download report

The Activity Download Report provides you with access to transaction details for advanced reporting. You can customize reports with user-selected date ranges, file types, and data fields. The Activity Download Report is available for merchants with access to the reporting portal. It is available at the account level. The Activity Download Report contains standardized fields and support multiple output formats. Understanding these specifications helps you process and integrate report data effectively.

Know before you begin

The reports character encoding is UTF-8 (8-bit UCS/Unicode Transformation Format).
The reports are available in these formats:
- Portable Document Format (PDF)
- Comma-Separated Values (CSV)
- Tab-Separated Value (TAB)
- Quickbooks (IIF-enabled only for US accounts)
- Quicken (QIF-USD only)

Note: An Activity Download Report of CSV or TAB format can contain a maximum of 50,000 records. If the report contains more than 50,000 records, the report is split across multiple files and compiled into a ZIP file.

Getting Started

Common Report Fields

Transaction Level Fields

Transaction ID: Unique identifier for each transaction
Transaction Date: When the transaction occurred
Transaction Type: PAYMENT, REFUND, ADJUSTMENT, etc.
Transaction Status: SUCCESS, PENDING, FAILED, etc.
Amount: Transaction amount in original currency
Currency Code: Three-letter ISO currency code
Fee Amount: PayPal processing fees
Net Amount: Amount after fees

Merchant Information

Merchant Account ID: Your PayPal account identifier
Store ID: Physical or online store identifier
Invoice Number: Your internal invoice reference
Custom Field: Additional tracking data

Customer Details (when available)

Payer Email: Customer’s PayPal email
Payer Name: Customer’s name
Payer Country: Customer’s country code
Shipping Address: Delivery address details

Supported File Formats

CSV Format

Transaction ID,Date,Type,Status,Amount,Currency,Fee,Net
TXN123456789,2024-01-15,PAYMENT,SUCCESS,100.00,USD,3.20,96.80

JSON Format

{
  "transaction_details": [
    {
      "transaction_info": {
        "transaction_id": "TXN123456789",
        "transaction_event_code": "T0006",
        "transaction_initiation_date": "2024-01-15T10:30:00Z",
        "transaction_updated_date": "2024-01-15T10:30:00Z",
        "transaction_amount": {
          "currency_code": "USD",
          "value": "100.00"
        },
        "fee_amount": {
          "currency_code": "USD",
          "value": "3.20"
        },
        "transaction_status": "S",
        "transaction_subject": "Payment for Order #12345"
      }
    }
  ]
}

Field Specifications

Date Fields

Format: ISO 8601 (YYYY-MM-DDTHH:MM:SSZ)
Timezone: UTC unless specified
Precision: Seconds level

Amount Fields

Decimal Places: Up to 2 for most currencies
Negative Values: Indicated by minus sign
Zero Values: Represented as “0.00”

Status Codes

Code	Description
S	Success
P	Pending
F	Failed
C	Cancelled
R	Refunded

Transaction Event Codes

T0006: Payment received
T0007: Payment sent
T0111: Refund issued
T0200: Chargeback initiated

Custom Field Mapping

// Map PayPal fields to your system
const mapTransactionFields = (paypalTransaction) => {
  return {
    internalId: paypalTransaction.custom_field,
    externalId: paypalTransaction.transaction_id,
    amount: parseFloat(paypalTransaction.transaction_amount.value),
    currency: paypalTransaction.transaction_amount.currency_code,
    status: mapStatus(paypalTransaction.transaction_status),
    timestamp: new Date(paypalTransaction.transaction_initiation_date)
  };
};

Report availability and retention

Activity download reports can be generated for any time period within the last 7 years. Users can select a time period of up to 12 months at a time for report generation. In addition to choosing dates from a calendar, you can choose:

Since last download
Today
Yesterday
Past month
Past 3 months
Past 6 months

Report file name

The filename of a report from Activity Download follows this naming convention: Download.*format* format is one of the following:

CSV: A comma-separated value file.
TAB: A tab-separated value file.
PDF: A portable document format file.
IFF: An Intuit Interchange Format file.
QIF: A Quicken Interchange Format file.

Download fields

The following download data fields are available in the Activity Download report:

Column name: The exact field name as it appears in the report, representing a specific transaction detail.
Position: The sequential order of the column if all available fields are included in the report.
State: Indicates whether a field is included in the report by default:
- Mandatory: Always included and cannot be removed.
- Selected: Included by default, but can be deselected by the user.
- Unselected: Not included by default, but can be added by the user.
Users can customize which fields appear in their report by editing the selection of Selected and Unselected fields.

Download data fields

Position	Column name	Data type	Char max length	State	In PDF	Description
1	Date	Date	10	Mandatory	Yes	The localized completion date of the transaction. For the US, `MM/DD/YYYY`.
2	Time	Time	8	Mandatory	No	The localized completion time of the transaction. Format is `HH:MM:SS`.
3	TimeZone	Alphanumeric	32	Mandatory	No	The time zone used for displaying transaction date and time.
4	Name	Alphanumeric	200	Mandatory	No	Counterparty name. Business name for business users and name for personal or premier users. Not unique and can have blanks.
5	Type	Alphanumeric	100	Mandatory	Yes	Transaction event code (T-Code) description. Not unique and can have spaces. See the Transaction Detail Report Specification for a full list of T-Codes.
6	Status	Alphanumeric	127	Mandatory	Yes	The status of the transaction. Possible values include Completed, Denied, Reversed, Pending, Active, Expired, Removed, Unverified, Voided, Processing, Created, Canceled, and more for invoice activity such as Error, Draft, Unpaid, Paid, Marked as paid, Refunded, etc. Not unique and can have blanks.
7	Currency	3-char currency code	3	Mandatory	Yes	Currency of transaction. Not unique and cannot have blanks.
8	Gross	Currency/Money	25	Mandatory	Yes	Localized gross amount. Total amount of the transaction including fees. Not unique and cannot have blanks.
9	Fee	Currency/Money	25	Mandatory	Yes	Localized fee amount associated with the transaction. Not unique and can have spaces.
10	Net	Currency/Money	25	Mandatory	Yes	Localized net amount of the transaction (usually gross minus fee). Not unique and can have blanks.
1	Date	Date	10	Mandatory	Yes	The localized completion date of the transaction in a format based on the user’s country. For the US, `MM/DD/YYYY`
2	Time	Time	8	Mandatory	No	The localized completion time of the transaction. Format is `HH:MM:SS`.
3	TimeZone	Alphanumeric	32	Mandatory	No	The time zone used for displaying transaction date and time.
4	Name	Alphanumeric	200	Mandatory	No	Counterparty name. Business name for business users and name for personal or premier users. Is not unique and can have blanks.
5	Type	Alphanumeric	100	Mandatory	Yes	Transaction event code (T-Code) description. Is not unique and can have spaces. See the Transaction Detail Report Specification for a full list of T-Codes.
6	Status	Alphanumeric	127	Mandatory	Yes	The status of the transaction. Possible values for all activity: Completed Denied Reversed Pending Active Expired Removed Unverified Voided Processing Created Canceled Possible additional values are supported for invoice activity: Error Draft Unpaid Paid Unpaid (sent) Marked as paid Marked as refunded Refunded Partially refunded Scheduled Partially paid Payment pending It is not unique and can have blanks.
7	Currency	3-char currency code	3	Mandatory	Yes	Currency of transaction. It is not unique and cannot have blanks.
8	Gross	Currency/Money	25	Mandatory	Yes	Localized gross amount. To talk amount of the transaction including fees. It is not unique and cannot have blanks.
9	Fee	Currency/Money	25	Mandatory	Yes	Localized fee amount associated with the transaction. This field contains the fee amount value for all transactions where a transactional fee has been processed. Fees are not amortized across several transactions. Is not unique and can have spaces.
10	Net	Currency/Money	25	Mandatory	Yes	Localized net amount of the transaction (usually gross fee). It is not unique and can have blanks.
11	From Email Address	Alphanumeric	127	Mandatory	No	The email address of the person with which the merchant transacted (buyer). It is not unique and can have blanks.
12	To Email Address	Alphanumeric	127	Mandatory	No	The email address of the transaction recipient. It is not unique and can have blanks.
13	Transaction ID	Varchar	24	Mandatory	No	Encrypted Transaction ID. The ID of the transaction against which the case was filed. This unique 17-character ID is generated by PayPal and cannot be altered. It is unique and can have blanks.
14	CounterParty Status	Alphanumeric	127	Unselected	No	The accounts status of the counterparty. Possible values: Verified Unverified Unregistered It is not unique and can have blanks.
15	Shipping Address	Alphanumeric	127	Unselected	No	The complete shipping address for the transaction. This information is a pass-through of what was provided by the payer. It is not unique and can have blanks.
16	Address Status	Alphanumeric	127	Selected	No	The status of the counterparty’s shipping address. Possible values: Confirmed Non-Confirmed It is not unique and can have blanks.
17	Item Title	Alphanumeric	127	Selected	No	The item title specified by a buyer in the website Auction/Item title field. It is specified by the seller in any of the following `buttoncreation` fields (`item_name` or `item_name_x`): PayPal Shopping Cart Item Name Buy Now Item Name Donations Item Name Subscriptions Name It is not unique and can have blanks.
18	Item ID	Alphanumeric	127	Selected	No	Specified by the seller in any of the following `buttoncreation` fields (`item_name` or `item_name_x`): PayPal Shopping Cart Item Name Buy Now Item Name Donations Item Name Subscriptions Name It is not unique and can have blanks.
19	Shipping and Handling Amount	Currency/Money	25	Selected	No	The localized amount paid, as reported by either PayPal or the merchant, for shipping and handling as a part of the transaction. It is not unique and can have blanks.
20	Insurance Amount	Currency/Money	25	Selected	No	The localized insurance amount, as reported by either PayPal or the merchant, for the transaction. It is not unique and can have blanks.
21	Sales Tax	Currency/Money	25	Selected	No	The localized sales tax amount, as reported by either PayPal or the merchant, paid as part of the transaction. It is not unique and can have blanks.
22	Option 1 Name	Alphanumeric	64	Selected	No	The Option 1 Name associated with a transaction. It is specified by the seller in any of the following `buttoncreation` fields )`on0` or `on0_x`): 3 PayPal Shopping Cart Option 1 Name 3 Buy Now Option 1 Name 3 Subscription Option 1 Name It is not unique and can have blanks.
23	Option 1 Value	Alphanumeric	200	Selected	No	The Option 1 Value associated with a transaction. It is entered by the buyer in any of the following website fields: 3 PayPal Shopping Cart Option 1 Value 3 Buy Now Option 1 Value 3 Subscription Option 1 Value It is specified by the seller in any of the following`A1:F56` fields: 3 PayPal Shopping Cart Option 1 Value 3 Buy Now Option 1 Value 3 Subscription Option 1 Value It is not unique and can have blanks.
24	Option 2 Name	Alphanumeric	64	Selected	No	The Option 2 Name associated with a transaction. It is specified by the seller in any of the following `buttoncreation` fields )`on0` or `on0_x`): 3 PayPal Shopping Cart Option 2 Name 3 Buy Now Option 2 Name 3 Subscription Option 2 Name It is not unique and can have blanks.
25	Option 2 Value	Alphanumeric	200	Selected	No	The Option 2 Value associated with a transaction. It is entered by the buyer in any of the following website fields: 3 PayPal Shopping Cart Option 2 Value 3 Buy Now Option 2 Value 3 Subscription Option 2 Value It is specified by the seller in any of the following fields: 3 PayPal Shopping Cart Option 2 Value 3 Buy Now Option 2 Value 3 Subscription Option 2 Value It is not unique and can have blanks.
26	Auction Site	Varchar	255	Unselected	No	The name of the auction site: eBay Yahoo! Auctions uBid.com Amazon.com Auctions MSN Auctions BidVille Other It is not unique and can have blanks.
27	Buyer ID	Varchar	255	Unselected	No	The ID of the buyer making the purchase in the auction. This ID can be different from the payer ID provided for the payment. It is not unique and can have blanks.
28	Item URL	Alphameric	4000	Unselected	No	The URL of the eBay/Auction Item. In the case of multiple items, items are separated with a comma and shown along with the payment row. For example, `http://cgi.ebay.com/ws/eBayISAPI.dll?ViewItem&item=252297991684`. It is not unique and can have blanks.
29	Closing Date	Alphanumeric	100	Unselected	No	The close date of eBay/Auction Item. The date format is based on the user’s country. For example, `3/12/2016 10:31:52 PM`. It is not unique and can have blanks.
30	Escrow ID	Numeric	22	Unselected	No	The ID associated with the eBay Escrow CN Checkout transaction. It is not unique and can have blanks.
31	Reference Txn ID	Varchar	24	Mandatory	No	The encrypted Transaction ID of the parent transaction. It is unique and can have blanks.
32	Invoice Number Text		127	Selected	No	The invoice ID set by the merchant with the transaction. Uniqueness enforced by PayPal when the transaction is created. If an invoice ID was sent with the capture request, this value is reported here. However, if no invoice ID was sent with the capture request, the value of the invoice ID (if any) from the authorizing transaction is reported here. It is not unique and can have blanks.
33	Custom Number	Alphanumeric	256	Selected	No	Shown only to seller/admin. The shopping cart customer number, Buy Now customer number, Subscription custom number, gift certificate tracking ID, or Masspay 2.0 disbursement ID. It is not unique and can have blanks.
34	Quantity	Numeric	25	Selected	No	This shows the total number of items present in the payment transaction. For item rows, it shows quantity of an individual item.
35	Receipt ID	Alphanumeric	19	Mandatory	No	The receipt identification number. 16-digit number in `xxxx-xxxx-xxxx-xxxx` format. It is not unique and can contain blanks.
36	Balance	Currency/Money	25	Selected	No	Reflects the running amount in the merchant’s bank account (available balance) in the currency of the transaction. Balance equals the previous balance plus the net. It is not unique and can contain blanks.
37	Address Line 1	Varchar	300	Selected	No	The first line of the shipping address. It is not unique and can have blanks.
38	Address Line 2/ District/ Neighborhood	Varchar	300	Selected	No	The second line of the shipping address. It is not unique and can have blanks.
39	Town/City	Alphanumeric	120	Selected	No	The town or city of the shipping address.
40	State/Province/ Region/Country/ Territory/Prefecture/ Republic	Alphanumeric	120	Selected	No	The state, province, region, territory, prefecture, or republic of the shipping address. It is not unique and can have blanks.
41	Zip/Postal Code	Varchar	60	Selected	No	The zip or postal code of the shipping address. It is not unique and can contain blanks.
43	Contact Phone Number	Numeric	22	Selected	No	The contact phone number. It is not unique and can contain blanks.
44	Subject	Alphanumeric	256	Selected	No	The Transaction Subject/Item name. The subject of the payment as passed through the payer to the payee. This data is controlled by the payer exclusively in the interfaces through which it is sent. It is not unique and can contain blanks.
45	Note	Varchar	4000	Selected	No	The transaction note. A special note of payment as passed through by the payer to the payee. This data is controlled by the payer exclusively in the interfaces through which it is sent. It is not unique and can have blanks.
46	Payment Source	Varchar	50	Unselected	No	The funding method. Possible values are: PayPal PayPal Funds Instant Transfer Instant Non-Instant eCheck Credit Card Electronic Funds Transfer Direct Debit Buyer Credit PayPal Pay Later Plus Card eBay Master Card PayPal Credit Payment with giropay Virtual Terminal Transaction Debit Card Venmo Apple Pay Google Pay Network Token Pay Upon Invoice Supported APMs It is not unique and can have blanks.
47	Card Type	Varchar	30	Unselected	No	The funding source used for the transaction. Possible values are: `VISA` `MASTERCARD` `AMEX` `BANKCARD` `DISCOVER` `DINERS` `SWITCH` `SOLO` `GE` `CARTES_BANCIARES` `JCB` `UNKNOWN` It is not unique and can have blanks.
48	Transaction Event Code	Alpahanumeric	5	Unselected	No	The T-Code number. It is not unique and cannot have blanks.
49	Payment Tracking ID	Varchar	127	Unselected	No	The tracking ID specified by partners to obtain information about a payment or to request a refund. It is not unique and can have blanks.
50	Bank Reference ID	Varchar	13	Unselected	No	The bank reference ID. It is unique and can have blanks.
51	Transaction Buyer Country Code	Varchar	45	Unselected	No	The buyer country code. It is not unique and can have blanks.
52	Item Details	Varchar	1024	Unselected	No	The item details. It is not unique and can have blanks.
53	Coupons	Varchar	2048	Unselected	No	The information about all the coupons associated with the transaction. Each individual item contains four pipe-delimited parts of information: 3 Incentive code (offers or coupon) 3 Amount 3 Currency 3 Campaign ID (associated with store offer or coupon) For example, for a USD $20 store offer with offer code 1234 and campaign ID ABCD, the delimited information would be `1234
54	Special Offers	Varchar	2048	Unselected	No	The informationa bout all the store credits associated with the transaction. Each individual item contains four pipe-delimited parts of information: 3 Incentive code (offers or coupon) 3 Amount 3 Currency 3 Campaign ID (associated with store offer or coupon) For example, for a USD $20 store offer with offer code 1234 and campaign ID ABCD, the delimited information would be `1234
55	Loyalty Card Number	Varchar	100	Unselected	No	The customer’s loyalty card provided to the merchant. This is applicable for Point of Sale transactions only. It is not unique and can have blanks.
56	Authorization Review Status	Varchar	2	Unselected	No	Indicated the current status of the transaction and whether it is under review. If it is under review, then the status is either Green (01) or Yellow (02). Possible values are: 01 02 Blank It is not unique and can have blanks.
57	Protection Eligibility	Varchar	2	Unselected	No	Indicates whether the transaction is eligible (01), not eligible (02), or partially eligible (03) for seller protection. Possible values are: 01 02 03 It is not unique and can have blanks.
58	Country Code	Varchar	64	Selected	No	The two letter country code of the shipping address. It is not unique and can have blanks.
59	Balance Impact	Varchar	64	Selected	No	The impact on the balance for the transaction. Possible values are: Debit Credit Memo It is not unique and cannot have blanks.
60	Buyer Wallet	Varchar	10	Unselected	No	The text that identifies the company (PayPal or one of its subsidiaries) that processes the payment. It is not unique and can have blanks.
61	Comment 1	Varchar	1000	Unselected	No	A note that accompanies a gateway transaction. It is not unique and can have blanks.
62	Comment 2	Varchar	1000	Unselected	No	A note that accompanies a gateway transaction. It is not unique and can have blanks.
63	Invoice Number	Varchar	200	Selected	No	The identifier of the invoice issued by the merchant. It is not unique and can have blanks.
64	PO Number	Varchar	200	Unselected	No	The identifier of the manifest of goods bought from the merchant. It is not unique and can have blanks.
65	Customer Reference Number	Varchar	80	Unselected	No	The identifier of the customer for a merchant. It is not unique and can have blanks.
66	Payflow Transaction ID (PNREF)	Varchar	80	Unselected	No	The unique idenitifier for the gateway transaction. It is not unique and can have blanks.
67	Tip	Currency/Money	25	Unselected	No	The amount of money paid by a consumer to a merchant over and above the item costs and any handling amounts in appreciation for services rendered. It is not unique and can have blanks.
68	Discount	Currency/Money	25	Unselected	No	The amount of discount given on the ordinary price of an item or group of items by the merchant. It is not unique and can have blanks.
69	SellerID	Varchar	200	Unselected	No	The unique idenitifier for the merchant at the marketplace site. It is not unique and can have blanks.
70	Risk Filter	Varchar	500	Unselected	No	The risk checks that the transaction matches. For a list of possible balues see Changed Download Fields It is not unique and can have blanks.
71	Tax ID Type	Varchar	4	Unselected	No	Indicates the tax ID type of the buyer. Available for Brazil only. Possible values are: CPF CNPJ It is not unique and can have blanks.
72	Tax ID	Varchar	80	Unselected	No	The buyer’s taxpayer registry number. Avaiable for Brazil only. It is not unique and can have blanks.
73	Number of Installments	Numeric	26	Unselected	No	The number of installments for the credit offer. Available for Brazil and Mexico only. It is not unique and can have blanks.
74	Installment Amount	Currency/Money	26	Unselected	No	The installment amount for the credit offer. Only available for Brazil and Mexico. It is not unique and can have blanks.
75	Installment Fee	Currency/Money	26	Unselected	No	The installment fee for the credit offer. Only available for Brazil and Mexico. It is not unique and can have blanks.
76	Credit Transactional Fee	Currency/Money	26	Unselected	No	The credit-related transaction fee amount for a merchant-selected credit offering.
77	Credit Promotional Fee	Currency/Money	26	Unselected	No	The credit-related transaction fee amount for a merchant-selected credit offering with a promotional APR.
78	Credit Term	Numeric	26	Unselected	No	The time span covered by the merchant-selected credit offer. The length of the term is captured in months.
79	Credit Offer Type	Alphanumeric	64	Unselected	No	The name of the credit offer used by the buyer as a funding instrument.
80	Original Invoice ID	Varchar	200	Unselected	No	The invoice ID of the original payment record. This ID helps users link and track all related transactions to the original parent transaction.
81	Campaign Fee	Currency/Money	22	Unselected	No	The fee charged to a merchant for each sale with a discount applied during a campaign.
82	Campaign Name	Varchar	200	Unselected	No	The name given to the campaign. Merchants can track this name on the campaign dashboard. Examples: `XMAS2021`, `Sales Recovery Campaign`.
83	Campaign Discount	Currency/Money	22	Unselected	No	Denotes the value of a discount amount applied in the transaction. For marketing campaigns, merchants can offer customers a discount in either a dollar amount or percentage.
84	Campaign Discount Currency	3-char currency code	3	Unselected	No	Denotes the currency of the discounted amount.
85	Payment Source Subtype	Varchar	50	Unselected	No	The funding source used for the transaction and the name of the credit offer used by the buyer as a funding instrument. Possible values are: `VISA` `MASTERCARD` `AMEX` `BANKCARD` `DISCOVER` `DINERS` `SWITCH` `SOLO` `CARTES_BANCIARES` `GE` `JCB` `CB_NATIONALE` Pay in 3 Pay in 4 Easy Payments 0% for 4 months Installments For Wallets and Network token, Payment Source Subtype would show details of card type and card brand used to fund the transaction. For example: `Credit Card-VISA` `Debit Card-MASTERCARD` It is not unique and can have blanks.
86	Decline Code	Varchar	50	Unselected	No	UDD SEPA Decline Codes
87	Fastlane Checkout Transaction	Varchar	1	Unselected	No	Indicates whether the transaction was checked out using fastlane accelerated checkout.

Best Practices

Validate all field formats before processing.
Handle missing or null fields gracefully.
Store original data for audit purposes.
Use consistent field mapping across systems.

Grow your business

Send payouts

Analyze reports

Report fields and formats reference

Activity Download report

Know before you begin

Getting Started

Common Report Fields

Transaction Level Fields

Merchant Information

Customer Details (when available)

Supported File Formats

CSV Format

JSON Format

Field Specifications

Date Fields

Amount Fields

Status Codes

Transaction Event Codes

Custom Field Mapping

Report availability and retention

Report file name

Download fields

Download data fields

Best Practices

Grow your business

Send payouts

Analyze reports

​Activity Download report

​Know before you begin

​Getting Started

​Common Report Fields

​Transaction Level Fields

​Merchant Information

​Customer Details (when available)

​Supported File Formats

​CSV Format

​JSON Format

​Field Specifications

​Date Fields

​Amount Fields

​Status Codes

​Transaction Event Codes

​Custom Field Mapping

​Report availability and retention

​Report file name

​Download fields

​Download data fields

​Best Practices

Activity Download report

Know before you begin

Getting Started

Common Report Fields

Transaction Level Fields

Merchant Information

Customer Details (when available)

Supported File Formats

CSV Format

JSON Format

Field Specifications

Date Fields

Amount Fields

Status Codes

Transaction Event Codes

Custom Field Mapping

Report availability and retention

Report file name

Download fields

Download data fields

Best Practices