PayPal statement and Activity counts differ: check balance impact
Updated · 5 min read
A PayPal statement and an Activity Download can contain different populations. Before treating the difference as missing money, separate balance impact, external funding and currency-conversion legs. A card-funded purchase can appear in both PayPal and the card record without becoming two purchases.
The desktop apps export date, description, and amount as CSV. Open CSV in Excel to save an XLSX workbook. Statement support varies: verify the result against your own PDF.
Request reports with comparable scope
This guide uses PayPal’s merchant reporting specifications, not a universal personal-account menu. Confirm that the reports are available for the actual account and retain its selected reporting scope.
- Obtain the intended monthly/custom statement with its account, dates and time zone. Statements include balance-affecting activity; pending uncaptured authorizations, pending eChecks and unresolved disputes are excluded from that statement population.
- Obtain the corresponding Activity Download with the actual fields/filters retained. Keep every CSV/TAB ZIP part; one downloaded part cannot establish complete coverage.
- Inspect Balance Impact, which distinguishes Debit, Credit and Memo, plus available Transaction ID and Reference Txn ID. Blank/omitted fields are missing evidence, not proof of no relationship.
- For potential card/bank funding, inspect available Payment Source and independent external evidence. Payment Source is not selected by default; an absent column does not prove payment from a PayPal balance.
- Keep each conversion currency and its documented event meaning separately. Do not delete a live entry, classify an expense or create a bank withdrawal from equal amounts alone.
A statement time-zone change applies to newly generated statements, not retrospectively to an old file. Preserve which report version and time-zone setting you actually compared.
Select the native report and its fields first
PayPal’s US statement-download instructions give two web routes. For reports, open History, choose the download icon and Custom, select the report and follow the generation prompts, then choose Download when ready. For a monthly statement, open the account-statements reporting page, request the required month and download it when ready. These are documented US routes, not a guaranteed menu for every country or personal account; the merchant specifications below describe report contents. A PayPal Credit card billing statement is a separate document, not the merchant Activity population.
| Report choice | What matters for this investigation |
|---|---|
| Monthly/custom statement | Balance-affecting population; choose the period, currency and actual statement time zone |
| Activity Download CSV/TAB | Retain available Balance Impact, Payment Source and relationship identifiers; selected columns affect the evidence |
| Activity Download PDF | The specification omits Balance Impact and Payment Source from PDF; a shorter file does not prove those values were blank |
The Activity specification marks Payment Source as unselected by default. If the downloaded field was not selected, obtain the appropriate native text report when available rather than calling the purchase balance-funded. Distinguish an omitted column, an empty value and an unknown relationship in the working record.
Inventory the complete export: monthly/custom CSV reports over 150,000 records are split into a ZIP and only the first file carries column names. Activity CSV/TAB above 50,000 records is also split into ZIP parts under its own specification. Preserve part order and headers before importing into a working sheet. The statement specification says changing the time zone affects later-generated statements, not old files already held. These are separate reasons to align period, currency, time zone and report parts before counting supposed missing or duplicate transactions.
One purchase, two systems, different balance effects
The fictional downloadable file stipulates a funding credit of +60 EUR and a purchase with a −60 EUR effect on the PayPal balance, plus an external card charge of −60 EUR. A retained receipt and funding association are given by the example. We read and filtered the CSV: the PayPal balance effect is zero, while one stipulated 60 EUR purchase is represented across the two systems. Adding both purchase and card-charge observations as separate expenses would count the stipulated purchase twice.
| Teaching observation | Layer | EUR | Interpretation |
|---|---|---|---|
| Funding | PayPal balance | +60 | Funding, not another purchase |
| Purchase | PayPal balance | −60 | Receipt-backed purchase in the case |
| CardCharge | External card | −60 | Given funding association to that purchase |
The linkage is not inferred from the matching 60. Without the receipt and source association, the relationship remains unresolved. The worksheet does not determine expense recognition or tax treatment.
Conversion legs stay in their currencies
The separate fictional currency file has USD −110, EUR +100 and a seller payment EUR −100. Actual CSV grouping gives USD −110 and EUR 0. Summing 110 and 100 as a single-currency expense or treating both conversion legs as two purchases loses the relationship.
PayPal’s transaction-event codes distinguish T0200 general, T0201 user-initiated and T0202 negative-balance conversion. Interpret the actual event from its own perspective and fields; a conversion reference does not automatically establish a bank withdrawal or current fees. These teaching figures are not a real exchange-rate quote.
Preserve unknown relationships rather than removing rows
Keep original statement, every Activity part, selected fields and external evidence together. Record population, currency or funding questions separately before any authorized accounting change. Use the overlapping CSV guide for shared duplicate-candidate review; removing same-amount rows cannot resolve PayPal report semantics.
Download the fictional funding/purchase file, currency-leg file and executed layer/currency totals. They use author-defined fields, not a PayPal export schema or tested merchant account.
For a bank source available only as PDF, LocalExtract prepares a local CSV, one PDF at a time, with date,description,amount. Review the rows and preserve source identity separately; it does not connect to PayPal or automatically classify funding and conversion events.
Official documentation checked October 17, 2026.
LocalExtract Team
We build LocalExtract, a desktop bank statement converter. Questions or corrections? Contact · Editorial policy