Use the payout as the bridge
Reconciling each PayPal sale directly to the bank is usually the wrong level of detail. Received payments, refunds, fees, holds, and conversions first change the PayPal balance. PayPal then sends available funds to a linked bank as a withdrawal. On the Activity Download report that withdrawal is classified as a general withdrawal to a bank account (transaction event code T0400, a settlement withdrawal). Manual withdrawals use T0403. Auto-sweep uses T0401 (PayPal transaction codes, read 2026-10-17).
Your reconciliation therefore has two related checks. First, confirm that the balance activity before the withdrawal explains the net that left PayPal. Second, match that withdrawal to the bank deposit. If the export already isolates completed withdrawal rows with a reliable Net amount, begin with the second check and retain the surrounding activity as support.
Control point: reconcile each PayPal account, currency balance, and destination bank account separately.
Export files with enough overlap
From a PayPal business account, go to Activity > All reports > Activities tab > Activity report, then choose Transaction type, Date range and Format (view transactions, Activity Download, read 2026-10-17). Use "Customize report fields" to add fields (view transactions, read 2026-10-17). PayPal's report specification calls this the Activity Download report (Activity Download, read 2026-10-17). PayPal allows any period within the last seven years, with a maximum of twelve months in one report. CSV and TAB files stop at 50,000 records and split into a ZIP when larger (Activity Download, read 2026-10-17).
Keep the columns you need for matching and support: Date, Type, Status, Currency, Gross, Fee, Net, and Transaction ID. Add Bank Reference ID and Transaction Event Code if they are not already selected; both are not selected by default on the official field list and are useful when the bank exposes a reference (Activity Download, read 2026-10-17). From the bank, export statement lines with posting date, description, debit, credit, and currency.
Build a working set of withdrawal rows rather than matching every payment. Filter Type or Transaction Event Code to bank withdrawals (T0400, T0403, T0401) and keep completed items for the first pass (PayPal transaction codes, read 2026-10-17). The Settlements report is at Activity > All reports > Payments tab > Settlements report, and you must contact PayPal to enable access; it summarizes transactions that affect your PayPal balance (view transactions, read 2026-10-17). That report is not available on every account.
Include several business days on both sides of month end. A standard transfer to a bank account is typically completed within one business day and can take up to one to three business days depending on the bank. Transfers started after 7:00 PM ET, or on a weekend or holiday, may take an extra day. Instant Transfers are typically processed within minutes and incur a fee (PayPal help, read 2026-10-17). An overlap prevents ordinary clearing from appearing as missing.
Confirm that the PayPal withdrawal destination matches the bank account under review. Businesses with more than one PayPal balance currency or more than one linked bank can compare a valid withdrawal with the wrong statement. Also note whether the period includes Instant Transfers, because that choice changes both expected timing and the amount that should reach the bank.
Normalize dates, signs, and currencies
The Activity Download Date is the localized completion date of the PayPal event. The bank supplies a posting date. Choose the date that best represents withdrawal initiation, retain the other dates as reference, and compare within a documented business-day window. Do not rewrite dates to make records match.
Normalize the sign convention before matching. A PayPal withdrawal is usually a debit against the PayPal balance, so Gross and Net are often negative on the export even though the bank records a credit. When Balance Impact is present, use Debit and Credit as a check rather than as the amount to match. Verify both conventions with a known deposit. Handle reversals, including a reversal of an ACH withdrawal (T1101), as separate records rather than deleting both sides (PayPal transaction codes, read 2026-10-17).
Keep currencies separate. A USD withdrawal and an EUR deposit are not an amount match, even if the numbers agree. Currency conversion appears as its own events (T0200 or user-initiated T0201) (PayPal transaction codes, read 2026-10-17). When PayPal converts before sending funds, use the withdrawal currency and net that actually left for the bank, and document the conversion evidence. Foreign exchange gains, losses, and conversion spreads require accounting treatment outside a simple amount match.
Match exact payouts first
- Filter to completed PayPal bank withdrawals and bank credits in the expected destination account.
- Match exact currency and amount within the normal posting window.
- Use the bank description, which often includes PAYPAL, plus Transaction ID or Bank Reference ID when either source exposes a useful reference.
- Remove confirmed pairs from the open list.
- Review repeated amounts carefully so date proximity does not create a false match.
PayPal processing fees usually appear on the payment rows in the Fee column before a withdrawal is created. In that common setup, the withdrawal net should equal the bank deposit when fees were already deducted. Instant Transfers incur an extra fee. If the bank receives an amount different from the withdrawal Net, investigate that Instant Transfer fee, a bank return fee, currency conversion, a split posting, or an incorrect source column before classifying the variance.
Explain common PayPal differences
Payout still in transit
A Complete status means PayPal has processed the transfer and sent it out of PayPal (PayPal help, read 2026-10-17). It does not mean the bank has posted the funds. Record the Transaction ID, Net, completion date, transfer type (standard or instant), and destination. Carry it forward and confirm the bank posting in the next period. A Pending Review hold is an automated security review that typically clears within 24 hours and may take up to 72 hours (PayPal help, read 2026-10-17). If the withdrawal later fails or reverses, update the classification rather than leaving it as in transit.
Refunds, holds, and reserves
Refunds reduce the PayPal balance before the next withdrawal, so they change composition rather than creating a separate bank line. Dispute investigation holds (T1110), general or available-balance holds (T1500, T1503), payment review holds, and reserve holds (T2103) can delay what is available to withdraw (PayPal transaction codes, read 2026-10-17). Reserve releases (T2104) later return funds to available balance (PayPal transaction codes, read 2026-10-17). Use the Activity Download Type, Status, and Transaction Event Code columns to support these movements. Do not assume every amount difference is a processing fee.
Multiple payouts or combined bank lines
Instant Transfers, manual withdrawals, and scheduled or auto-sweep withdrawals can produce several bank credits on one day. Conversely, some bank feeds combine or summarize postings. Preserve the individual PayPal withdrawal rows, list every bank component, and document any one-to-many relationship. The sum should agree by currency, and the grouping should be supported by dates and references rather than amount alone.
Failed, canceled, or returned payouts
A failed or reversed withdrawal should not be matched to an unrelated bank deposit. If the bank has a problem (for example incorrect account information), PayPal says you'll be notified within one week, and the money is returned to your PayPal account minus applicable return fees (PayPal help, read 2026-10-17). Trace the original withdrawal, any T1101 ACH withdrawal reversal, and the replacement withdrawal. If the bank posted and returned the funds, retain both bank lines. This preserves the cash trail and avoids hiding a failed settlement inside a later successful batch.
Limit: a CSV workflow cannot confirm facts missing from the exports. When status, destination, or withdrawal composition is unclear, return to PayPal Activity and the bank for source evidence.
Worked example: two sample files
These two files are synthetic. No real account, buyer or bank is behind them. The PayPal file uses the Activity Download column names in PayPal's order: the 15 mandatory columns plus Balance Impact, Transaction Event Code and Bank Reference ID (Activity Download, read 2026-10-22). Dates are in the US format, MM/DD/YYYY.
- paypal-activity-download-sample.csv: six rows from September 21 to 30, 2026.
- bank-statement-paypal-sample.csv: the bank side, two lines, ending September 29.
What's in the PayPal file
- Three USD Express Checkout payments (T0006). Gross minus Fee gives Net: 120.00 − 4.68 = 115.32, 64.50 − 2.74 = 61.76, and 85.00 − 3.46 = 81.54.
- One EUR payment: 50.00 gross, 2.24 fee, 47.76 net. It stays in the EUR balance.
- A withdrawal to the bank (T0400) on 09/24/2026 for -177.08. That's the two earlier USD nets, 115.32 + 61.76. The fees were already taken on the payment rows, so the withdrawal has no fee of its own.
- A second withdrawal on 09/30/2026 for -81.54, status Completed.
The bank file has one PAYPAL TRANSFER credit of 177.08 on 2026-09-25 and a 15.00 monthly service fee on 2026-09-29.
What the free preview shows
Load both files. The preview labels the first file paypal and the second bank, and picks up Date, Name, Type, Currency, Gross, Fee, Net and Transaction ID from the PayPal headers. Every date in this file has a day above 12, so the preview reads it as month first on its own. If every day in your own file is 12 or under, it asks you to choose Month/Day/Year or Day/Month/Year.
- Matched 1: the 09/24 withdrawal and the 09/25 PAYPAL TRANSFER. Reason: exact amount and currency; dates 1 day apart. PayPal shows the withdrawal as a negative debit and the bank shows a positive credit. The match is on the amount, not the sign.
- 09/30 withdrawal, unmatched. PayPal says Completed, but the bank file ends on the 29th. Completed means the money left PayPal, not that the bank has posted it. Carry it forward as in transit and look for 81.54 on the next statement.
- EUR payment, unmatched. There's no EUR bank line, and the preview never matches across currencies. Reconcile the EUR balance on its own.
- The three USD payments, unmatched. Payments never reach the bank one by one. They're the support for the withdrawal's net, which is why the guide filters to withdrawal rows first. Filter Transaction Event Code to T0400, T0401 and T0403 before loading and they drop out of the list.
- Monthly service fee, unmatched. It's a bank charge, not a PayPal transaction. Book it as a bank fee.
Load these two files in the free preview. Matching runs in the browser. $39 once exports the ledger, print view and exceptions list.
Prepare review-ready support
A completed file should show the PayPal Transaction ID, settlement currency, withdrawal Net, relevant PayPal date, bank posting date, bank description, match status, and exception explanation. Attach or retain the original Activity Download and bank files. For open items, include an owner and next action. Reviewers should be able to distinguish ordinary bank clearing from a pending review, a hold, or an item that requires PayPal or bank follow-up.
Compare the total of matched and open PayPal withdrawals with the filtered source report, then compare matched and unexplained bank deposits with the statement. These completeness checks catch records omitted by Type filters or import ranges. The goal is a supported zero difference after timing and other documented items, not a spreadsheet made to balance through plugs.
Using ReconcileCSV for the comparison
To see the match on sample files before using your own export, use the two PayPal sample files above.
ReconcileCSV accepts a PayPal activity or withdrawal CSV and a bank statement CSV, lets you map date and amount columns, proposes deterministic matches inside a date window, and surfaces ambiguous or unmatched rows. The live source picker includes paypal as a label for the PayPal file. The preview is free. Full ledger, print, and exception exports are available after a one-time $39 purchase. There is no account and no OAuth. CSV processing and matching run in the browser; files never leave the browser.
ReconcileCSV does not connect to PayPal, retrieve live withdrawal status, post entries to accounting software, or determine the proper account for fees, holds, reserves, Instant Transfer fees, or foreign exchange. It cannot repair incomplete exports. A preparer must review ambiguous matches and support every accounting conclusion with the original source data.
FAQ
Why reconcile PayPal withdrawals to the bank instead of each PayPal payment?
Received payments, refunds, fees, holds, and conversions first change the PayPal balance. PayPal then sends available funds to a linked bank as a withdrawal, and the bank usually records only that withdrawal. Match the withdrawal to the bank deposit and keep the payment rows as support for what made up the net.
Which PayPal transaction codes mark a withdrawal to a bank?
On the Activity Download report, a general withdrawal to a bank account is T0400. Manual withdrawals use T0403 and auto-sweep uses T0401. Filter Type or Transaction Event Code to those codes and keep completed items for the first pass. A reversal of an ACH withdrawal is T1101; keep it as a separate record.
PayPal shows the withdrawal as Completed. Why isn't it on my bank statement?
A Complete status means PayPal has processed the transfer and sent it out of PayPal. It does not mean the bank has posted the funds. A standard transfer to a bank account is typically completed within one business day and can take up to one to three business days depending on the bank. Transfers started after 7:00 PM ET, or on a weekend or holiday, may take an extra day. Carry the withdrawal forward as in transit and confirm the bank posting in the next period.
Should the bank deposit equal the PayPal withdrawal Net?
In the common setup, yes. PayPal processing fees usually appear on the payment rows in the Fee column before the withdrawal is created, so the withdrawal net should equal the bank deposit. If the bank amount differs, investigate an Instant Transfer fee, a bank return fee, currency conversion, a split posting, or an incorrect source column before classifying the variance.
Why is the PayPal withdrawal negative when the bank shows a deposit?
A PayPal withdrawal is usually a debit against the PayPal balance, so Gross and Net are often negative on the export even though the bank records a credit. Normalize the sign convention before matching and verify both conventions with a known deposit.
How should I handle more than one PayPal currency?
Reconcile each PayPal account, currency balance, and destination bank account separately. A USD withdrawal and an EUR deposit are not an amount match, even if the numbers agree. Currency conversion appears as its own events, T0200 or user-initiated T0201.
What happens if a PayPal withdrawal to the bank fails?
If the bank has a problem, such as incorrect account information, PayPal says you'll be notified within one week and the money is returned to your PayPal account minus applicable return fees. Don't match the failed withdrawal to an unrelated bank deposit. Trace the original withdrawal, any T1101 ACH withdrawal reversal, and the replacement withdrawal, and keep both bank lines if the bank posted and returned the funds.