Settlement, reconciliation & API — found from sitemap — PayPal

Cited by

Facts read from this source

• Settlement report purpose Report an error

  “It provides detailed information about each transaction that affects the settlement of funds to their accounts and summarizes total debits, credits, and beginning and ending balances for each currency that they hold in their accounts.”

• Settlement report delivery Report an error

  “PayPal generates and delivers the Settlement report to the /ppreports/outgoing directory on the SFTP server daily before 12:00 PM (noon) in the leading time zone of the reporting window.”

• Settlement report retention Report an error

  “After it is generated, the report remains available for 1 year from its generation time.”

• Settlement report formats Report an error

  “The report is available in CSV (comma-separated values) or TAB (tab-delimited) format.”

• Settlement report encoding Report an error

  “The character encoding of this report is UTF-8 (8-bit UCS/Unicode Transformation Format).”

• Settlement report approval required Report an error

  “You must be an approved merchant to use this report. To request access, contact your PayPal account manager or customer support.”

• Settlement report sftp required Report an error

  “You also need an SFTP account to access PayPal's SFTP server and retrieve your reports.”

• Settlement report notifications Report an error

  “PayPal monitors the generation and delivery of this report at all times and maintains 2 contact points for notifications”

• Settlement report versions Report an error

  “When multiple versions exist, you can receive 2 versions of the same report concurrently to test and integrate a new version.”

• Settlement report max records Report an error

  “Regardless of report format (CSV or TAB), a report file of this type can contain a maximum of 1 million records. If the report contains more records, it is split across multiple files.”

• Settlement report row types Report an error

  “RH Report header Report header data FH File header File header data SH Section header Section header data CH Column header Section body data SB Row data Section body data SF Section footer Section footer data SC Section record count Section record count data RF Report footer Report footer data RC Report record count Report record count data FF File footer File footer data”

• Settlement report reconciliation timezone Report an error

  “The Settlement Report reconciles to the Settlement Withdrawal for any time zone from Pacific Standard Time (PST, which is GMT minus 7 or 8 hours depending on daylight saving time) to any time zones that are up to 9 hours ahead of PST.”

• Settlement report multi account windows Report an error

  “reportingWindow The window of time when the report was generated: A (America/New York to America/Los Angeles), H (America/Los Angeles to Asia/Hong Kong), R (Asia/Hong Kong to Europe/London), or X (Europe/London to America/New York)”

• Settlement report gross amount always included Report an error

  “The Settlement report always includes the gross amount for transactions that are processed in any currency. If no fees are involved, the report does not include the fee fields, and the net amount equals the gross amount.”

• Settlement report money format Report an error

  “Money amount fields in this report are unsigned, and they include no currency symbol, decimal separator, or other punctuation.”

• Settlement report body fields Report an error

  “2 transaction_id Varchar; blanks allowed; max 24 characters Transaction ID of the money movement event. PayPal generates this ID, and a merchant cannot alter it.”

• Settlement report reference id types Report an error

  “The type of the PayPal reference ID: ODR (order ID), TXN (transaction ID), SUB (subscription ID), or PAP (preapproved payment ID)”

• Settlement report disputes excluded Report an error

  “For transactions with associated disputes, claimant information appears only in the dispute report, not in the settlement report or transaction detail report.”

• Settlement report section per account Report an error

  “The report is also organized by section, where each section represents a single PayPal account. If you are not using Multiple Account Management, the report contains only a single section.”

• Settlement report partner fields Report an error

  “5 partner_account_id Varchar; blanks allowed; max 127 characters The partner's account ID for the merchant. This is the value that the partner passes in the <PartnerMerchantExternalID> tag of the Multiple Account Management batch input file.”

• Settlement report fh rf not in v001 Report an error

  “The FH, SC, RC, and RF rows are not available in Settlement Report version 001.”

• Settlement report format change Report an error

  “To change the format that you receive, contact your PayPal account manager or customer support.”

• Settlement report version 001 row exclusions Report an error

  “Each row consists of a 2-letter row type code that is followed by the details for that row type.”