Activity Download Specification report

The Activity Download provides users with access to transaction details for any advanced reporting need. This feature allows merchants customization of reports, through user-selected date ranges, file types, and data fields. The Activity Download is available for use by any merchant 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

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 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 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.
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/County/
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 Funds
  • Instant Transfer
  • Instant
  • Non-Instant
  • eCheck
  • Credit Card
  • Electronic Funds Transfer
  • Direct Debit
  • Buyer Credit
  • PayPal Pay Later
  • eBay Master Card
  • PayPal Credit
  • Payment with giropay
  • Virtual Terminal Transaction
  • Debit Card
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|2000|USD|ABCD It is not unique and can have blanks.
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|2000|USD|ABCD It is not unique and can have blanks.
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.