Activity Download Specification report

DocsCurrentLast updated: January 19th 2022, @ 1:18:48 pm


The Activity Download Report provides users with access to transaction details for advanced reporting. This feature allows merchants to customize reports, through 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.

Know before you begin

  • You must have a PayPal secure file transfer protocol (SFTP) account to access reports.

  • 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.

Report availability and retention

Custom statements are available for any time period within the last 3 years.

Each statement summarizes data from the date range specified, from 00:00:00 AM on the starting day of the date range to 23:59:59 PM on the last day of the date range. If the requested date range of a custom statement includes the current day, transaction and summary information is included as of the time stated on the webpage. You can configure the time zone from the Account Properties section on your reporting portal. Updating the time zone only affects statements generated after the change.

In addition to choosing dates from a calendar, you can choose:

  • Since last download
  • Today
  • Yesterday
  • Past month
  • Past three (3) months
  • Past six (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 fields are available in the Activity Download report. The column names below reflect the column names in the report, which contain details for each transaction. Position refers to the order of columns if all were to be selected. Download fields indicated as having an "unselected" state are those which are not selected upon default to appear in the report, in contrast to fields in "selected" and "mandatory" states which do appear in the report. Fields with "unselected" or "selected" as their state may have the state changed by the user choosing to edit/customize download fields.

Download data fields

PositionColumn nameData typeChar max lengthStateIn PDFDescription
1DateDate10MandatoryYesThe localized completion date of the transaction in a format based on the user's country. For the US, MM/DD/YYYY
2TimeTime8MandatoryNoThe localized completion time of the transaction. Format is HH:MM:SS.
3TimeZoneAlphanumeric32MandatoryNoThe time zone used for displaying transaction date and time.
4NameAlphanumeric200MandatoryNoCounterparty name. Business name for business users and name for personal or premier users. Is not unique and can have blanks.
5TypeAlphanumeric100MandatoryYesTransaction 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.
6StatusAlphanumeric127MandatoryYesThe 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.
7Currency3-char currency code3MandatoryYesCurrency of transaction. It is not unique and cannot have blanks.
8GrossCurrency/Money25MandatoryYesLocalized gross amount. To talk amount of the transaction including fees. It is not unique and cannot have blanks.
9FeeCurrency/Money25MandatoryYesLocalized 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.
10NetCurrency/Money25MandatoryYesLocalized net amount of the transaction (usually gross fee). It is not unique and can have blanks.
11From Email AddressAlphanumeric127MandatoryNoThe email address of the person with which the merchant transacted (buyer). It is not unique and can have blanks.
12To Email AddressAlphanumeric127MandatoryNoThe email address of the transaction recipient. It is not unique and can have blanks.
13Transaction IDVarchar24MandatoryNoEncrypted 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.
14CounterParty StatusAlphanumeric127UnselectedNoThe accounts status of the counterparty. Possible values:
  • Verified
  • Unverified
  • Unregistered
It is not unique and can have blanks.
15Shipping AddressAlphanumeric127UnselectedNoThe 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.
16Address StatusAlphanumeric127SelectedNoThe status of the counterparty's shipping address. Possible values:
  • Confirmed
  • Non-Confirmed
It is not unique and can have blanks.
17Item TitleAlphanumeric127SelectedNoThe 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.
18Item IDAlphanumeric127SelectedNoSpecified 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.
19Shipping and Handling AmountCurrency/Money25SelectedNoThe 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.
20Insurance AmountCurrency/Money25SelectedNoThe localized insurance amount, as reported by either PayPal or the merchant, for the transaction. It is not unique and can have blanks.
21Sales TaxCurrency/Money25SelectedNoThe 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.
22Option 1 NameAlphanumeric64SelectedNoThe 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.
23Option 1 ValueAlphanumeric200SelectedNoThe 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 followingA1: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.
24Option 2 NameAlphanumeric64SelectedNoThe 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.
25Option 2 ValueAlphanumeric200SelectedNoThe 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.
26Auction SiteVarchar255UnselectedNoThe 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.
27Buyer IDVarchar255UnselectedNoThe 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.
28Item URLAlphameric4000UnselectedNoThe 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.
29Closing DateAlphanumeric100UnselectedNoThe 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.
30Escrow IDNumeric22UnselectedNoThe ID associated with the eBay Escrow CN Checkout transaction. It is not unique and can have blanks.
31Reference Txn IDVarchar24MandatoryNoThe encrypted Transaction ID of the parent transaction. It is unique and can have blanks.
32Invoice Number Text127SelectedNoThe 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.
33Custom NumberAlphanumeric256SelectedNoShown 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.
34QuantityNumeric25SelectedNoThis shows the total number of items present in the payment transaction. For item rows, it shows quantity of an individual item.
35Receipt IDAlphanumeric19MandatoryNoThe receipt identification number. 16-digit number in xxxx-xxxx-xxxx-xxxx format. It is not unique and can contain blanks.
36BalanceCurrency/Money25SelectedNoReflects 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.
37Address Line 1Varchar300SelectedNoThe first line of the shipping address. It is not unique and can have blanks.
38Address Line 2/District/NeighborhoodVarchar300SelectedNoThe second line of the shipping address. It is not unique and can have blanks.
39Town/CityAlphanumeric120SelectedNoThe town or city of the shipping address.
40State/Province/Region/County/
Territory/Prefecture/Republic
Alphanumeric120SelectedNoThe state, province, region, territory, prefecture, or republic of the shipping address. It is not unique and can have blanks.
41Zip/Postal CodeVarchar60SelectedNoThe zip or postal code of the shipping address. It is not unique and can contain blanks.
43Contact Phone NumberNumeric22SelectedNoThe contact phone number. It is not unique and can contain blanks.
44SubjectAlphanumeric256SelectedNoThe 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.
45NoteVarchar4000SelectedNoThe 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.
46Payment SourceVarchar50UnselectedNoThe funding method. Possible values are:
  • 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
  • Pay Upon Invoice
  • Supported APMs
It is not unique and can have blanks.
47Card TypeVarchar30UnselectedNoThe 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.
48Transaction Event CodeAlpahanumeric5UnselectedNoThe T-Code number. It is not unique and cannot have blanks.
49Payment Tracking IDVarchar127UnselectedNoThe tracking ID specified by partners to obtain information about a payment or to request a refund. It is not unique and can have blanks.
50Bank Reference IDVarchar13UnselectedNoThe bank reference ID. It is unique and can have blanks.
51Transaction Buyer Country CodeVarchar45UnselectedNoThe buyer country code. It is not unique and can have blanks.
52Item DetailsVarchar1024UnselectedNoThe item details. It is not unique and can have blanks.
53CouponsVarchar2048UnselectedNoThe 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
54Special OffersVarchar2048UnselectedNoThe 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
55Loyalty Card NumberVarchar100UnselectedNoThe 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.
56Authorization Review StatusVarchar2UnselectedNoIndicated 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.
57Protection EligibilityVarchar2UnselectedNoIndicates 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.
58Country CodeVarchar64SelectedNoThe two letter country code of the shipping address. It is not unique and can have blanks.
59Balance ImpactVarchar64SelectedNoThe impact on the balance for the transaction. Possible values are:
  • Debit
  • Credit
  • Memo
It is not unique and cannot have blanks.
60Buyer WalletVarchar10UnselectedNoThe text that identifies the company (PayPal or one of its subsidiaries) that processes the payment. It is not unique and can have blanks.
61Comment 1Varchar1000UnselectedNoA note that accompanies a gateway transaction. It is not unique and can have blanks.
62Comment 2Varchar1000UnselectedNoA note that accompanies a gateway transaction. It is not unique and can have blanks.
63Invoice NumberVarchar200SelectedNoThe identifier of the invoice issued by the merchant. It is not unique and can have blanks.
64PO NumberVarchar200UnselectedNoThe identifier of the manifest of goods bought from the merchant. It is not unique and can have blanks.
65Customer Reference NumberVarchar80UnselectedNoThe identifier of the customer for a merchant. It is not unique and can have blanks.
66Payflow Transaction ID (PNREF)Varchar80UnselectedNoThe unique idenitifier for the gateway transaction. It is not unique and can have blanks.
67TipCurrency/Money25UnselectedNoThe 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.
68DiscountCurrency/Money25UnselectedNoThe 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.
69SellerIDVarchar200UnselectedNoThe unique idenitifier for the merchant at the marketplace site. It is not unique and can have blanks.
70Risk FilterVarchar500UnselectedNoThe risk checks that the transaction matches. For a list of possible balues see Changed Download Fields It is not unique and can have blanks.
71Tax ID TypeVarchar4UnselectedNoIndicates the tax ID type of the buyer. Available for Brazil only. Possible values are:
  • CPF
  • CNPJ
It is not unique and can have blanks.
72Tax IDVarchar80UnselectedNoThe buyer's taxpayer registry number. Avaiable for Brazil only. It is not unique and can have blanks.
73Number of InstallmentsNumeric26UnselectedNoThe number of installments for the credit offer. Available for Brazil and Mexico only. It is not unique and can have blanks.
74Installment AmountCurrency/Money26UnselectedNoThe installment amount for the credit offer. Only available for Brazil and Mexico. It is not unique and can have blanks.
75Installment FeeCurrency/Money26UnselectedNoThe installment fee for the credit offer. Only available for Brazil and Mexico. It is not unique and can have blanks.
76Credit Transactional FeeCurrency/Money26UnselectedNoThe credit-related transaction fee amount for a merchant-selected credit offering.
77Credit Promotional FeeCurrency/Money26UnselectedNoThe credit-related transaction fee amount for a merchant-selected credit offering with a promotional APR.
78Credit TermNumeric26UnselectedNoThe time span covered by the merchant-selected credit offer. The length of the term is captured in months.
79Credit Offer TypeAlphanumeric64UnselectedNoThe name of the credit offer used by the buyer as a funding instrument.
80Original Invoice IDVarchar200UnselectedNoThe invoice ID of the original payment record. This ID helps users link and track all related transactions to the original parent transaction.
81Campaign FeeCurrency/Money22UnselectedNoThe fee charged to a merchant for each sale with a discount applied during a campaign.
82Campaign NameVarchar200UnselectedNoThe name given to the campaign. Merchants can track this name on the campaign dashboard. Examples: XMAS2021, Sales Recovery Campaign.
83Campaign DiscountCurrency/Money22UnselectedNoDenotes 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.
84Campaign Discount Currency3-char currency code3UnselectedNoDenotes the currency of the discounted amount.

See also