You scroll your bank statement looking for the subscription you meant to cancel, and you find eleven lines that all say the same thing: PAYPAL. Different amounts, different dates, no merchant. The charge you’re hunting for is in there somewhere, and the statement will not tell you which one it is.<\/p>\n
This is not a formatting quirk. When you pay through PayPal, PayPal is the merchant of record as far as your bank is concerned. Your bank sees a payment to PayPal. The name of the company that actually billed you \u2014 the streaming service, the newsletter, the cloud storage plan you signed up for on a laptop you no longer own \u2014 exists only inside PayPal’s activity log. To get it out, you have to go to the source.<\/p>\n
A subscription billed directly to a card leaves a readable trail. The merchant name is on the line, so pattern detection \u2014 yours or software’s \u2014 has something to grip. A subscription billed through PayPal leaves an amount and a date and nothing else.<\/p>\n
That matters more than it sounds. Three of those PAYPAL lines might be one-off purchases. Four might be the same vendor at a changing price. Two might be a service that raised its monthly rate 18 months ago and has been collecting the difference since. From the bank side, they are indistinguishable. Any categorization you do on the bank export lands them all in one bucket called, effectively, “PayPal”.<\/p>\n
The fix is to treat PayPal as a separate account with its own statement, because functionally that is what it is.<\/p>\n
The download lives under your account activity on the web version. The mobile app does not produce the same file, so use a browser.<\/p>\n
PayPal moves these labels around from time to time, so if the wording differs slightly, look for the download or statements link attached to the activity view rather than the settings menu.<\/p>\n
A note on file type: if you are offered a PDF statement instead, take it anyway rather than skipping the export. A PDF statement carries the same merchant names, and it can be read and structured on import even though it is not a spreadsheet.<\/p>\n
Open the file and you will find considerably more than a bank export gives you. The columns vary by account type and region, but the ones that do the work are consistent:<\/p>\n
That Type<\/strong> column is the shortcut most people miss. Sort or filter by it and the subscription payments separate themselves from the one-off checkouts without you having to reason about amounts at all.<\/p>\n With the CSV open, three passes will surface almost everything.<\/p>\n Pass one: sort by merchant name.<\/strong> Any name appearing four or more times in a 24-month range is a candidate. You are not looking at amounts yet, only repetition.<\/p>\n Pass two: check the interval.<\/strong> For each repeated name, look at the gaps between dates. Roughly 30 days is monthly. Roughly 365 is annual, and the annual ones are the charges people forget entirely, because they arrive once, from a company they interacted with a year ago.<\/p>\n Pass three: compare the amounts within each merchant.<\/strong> This is where cost creep shows up. A row that reads 8.99, 8.99, 8.99, 10.99, 10.99, 12.99 is a price that moved twice while the charge kept clearing. Nothing about that sequence is visible on the bank side, where all six rows say PAYPAL and sit next to each other in no particular order.<\/p>\n Also check the reference IDs on rows where the merchant name is vague or abbreviated. Payment processors sometimes appear in the Name column instead of the actual business, and a shared reference across rows will still group them correctly even when the name does not help.<\/p>\n Doing those three passes by hand once is fine. Doing them every quarter is the part that does not happen.<\/p>\n PennySlice takes the PayPal CSV directly \u2014 drop the file in, and the structure is detected from the file itself. There is no template to choose and no column-mapping screen, which matters here because PayPal’s column layout differs from every bank export you might also be importing. Excel, OFX and PDF statements work the same way, so if PayPal only offered you a PDF, that file is still usable.<\/p>\n Once it is in, you can ask in plain English \u2014 “which merchants charged me every month last year” or “what did my PayPal subscriptions total in 2025” \u2014 and get figures from your own rows rather than a general answer. That conversational layer covers eight areas of your financial data<\/a>, including imports and recurring predictions.<\/p>\n Two of Penny Spotter’s seven background detectors are aimed squarely at what this file contains. Recurring cost creep flags subscriptions and bills that quietly rose \u2014 the 8.99 that became 12.99. Merchant concentration flags a single merchant taking an outsized share of your spending, which is exactly what PayPal itself looks like until you break the file apart.<\/p>\nHow to find recurring payments in the PayPal file<\/h2>\n
Getting the file into something that keeps watching<\/h2>\n