PayPal Multi-Currency Reconciliation: How Freelancers Fix Mismatched Transactions (2026)

Transparency: I built Tally Assistant, which handles multi-currency PayPal reconciliation automatically. This guide covers the manual process plus AI-assisted alternatives.

Quick Answer: Why Don't My PayPal Totals Match My Bank?

Currency conversion is the culprit. When a UK client pays you £500 via PayPal, PayPal converts it to USD at their rate (with a 3-4% markup baked in), then deposits the USD amount to your bank. The £500 you invoiced becomes roughly $620 after conversion and fees — but your bank statement shows only the final USD deposit. The gap is PayPal's currency conversion spread, and reconciling it manually is the #1 headache for international freelancers.

---

The Three Numbers That Never Match

For every international PayPal payment, there are three different amounts:

What You See	Amount	Where
What you invoiced	£500	Your invoice
What the client paid	£500	PayPal transaction log
What PayPal converted	~$618.50	PayPal's conversion (mid-market - 3.5%)
What hit your bank	~$618.50	Bank statement

Your bookkeeping needs to track: the original invoice currency (GBP), the settled amount (USD), and PayPal's fee. If you only record the bank deposit, you lose the original currency information — which matters for tax reporting and client reconciliation.

---

Step-by-Step: Manual PayPal Multi-Currency Reconciliation

Step 1: Export the Right PayPal CSV

Go to PayPal → Activity → Statements → Custom. Select:

• Transaction type: All transactions
• Date range: Your accounting period
• Format: CSV

PayPal's default "Download" button gives you a simplified CSV. The Statements → Custom export includes the Currency, Gross, Fee, and Net columns you need for multi-currency reconciliation.

Step 2: Separate by Currency

Open the CSV in Google Sheets. Add a filter on the Currency column. Group transactions:

USD transactions → match directly to bank deposits
EUR transactions → check conversion rate
GBP transactions → check conversion rate
AUD, CAD, JPY, etc. → check conversion rate

Step 3: Calculate Expected Settlement for Each Foreign-Currency Transaction

For each non-USD transaction:

Expected USD = Original Amount × PayPal Exchange Rate - PayPal Fee

PayPal's exchange rate is embedded in the transaction details, not the CSV. You need to:

1. Open each transaction in the PayPal web interface
2. Click "Details" to see the conversion rate applied
3. Manually calculate

This is the step that takes hours if you have 20+ international payments a month.

Step 4: Match Against Bank Deposits

PayPal batches multiple payments into single bank deposits. A $3,000 deposit might be:

£500 from Client A → $618.50
€800 from Client B → $872.00
$1,200 from Client C → $1,200.00
$309.50 from Client D (USD) → $309.50
────────────────────────────
Total deposit: $3,000.00

You need to reverse-engineer which transactions were batched together. Tip: PayPal's "Settled" column in the Activity download shows the batch reference ID — filter by that ID to group transactions that landed together.

---

The Quick Fix: AI-Powered Reconciliation

If manual reconciliation takes more than 2 hours a month, AI bookkeeping tools can eliminate it entirely. Tally Assistant handles multi-currency PayPal CSVs by:

1. Auto-detecting currency columns — reads Currency, Gross, Fee, Net regardless of CSV layout
2. Applying daily exchange rates — converts all foreign-currency transactions to your base currency using that day's rate (via Frankfurter API)
3. Flagging PayPal fees — separates the transaction amount from PayPal's processing fee so your books show both
4. Matching clients — links "PayPal — John Smith" to your existing client "John Smith"
5. Preserving original currency — records both the original amount (e.g., £500) and the converted amount (e.g., $618.50) in the same transaction

---

Common PayPal Reconciliation Errors (And How to Prevent Them)

Error 1: Recording the Gross Instead of Net

You invoiced £500. PayPal took £17.50 in fees. You received £482.50.

Wrong: Recording £500 as income (overstates revenue, understates expenses) Right: Recording £500 income + £17.50 PayPal fee (expense category: "Payment Processing Fees")

Error 2: Using the Wrong Exchange Rate

PayPal's rate includes a 3-4% markup. If you use Google's mid-market rate to convert EUR to USD, your numbers won't match PayPal's settlement.

Fix: Always use PayPal's actual conversion rate from the transaction details, or use the daily official rate and record the difference as "Currency Conversion Loss."

Error 3: Forgetting About Currency Conversion Fees

PayPal charges a separate currency conversion fee (typically 3-4%) on top of their transaction fee. This doesn't appear as a separate line — it's baked into the exchange rate. If the mid-market rate is 1.25 USD/GBP and PayPal gives you 1.205, that 0.045 difference is their fee.

Fix: Create an expense entry: "PayPal Currency Conversion Fee" = (Mid-Market Amount - PayPal Settled Amount).

Error 4: Mixing Up "Available" vs "Pending" Balances

PayPal's CSV may show transactions that haven't settled yet. Always reconcile against completed/settled transactions only. Pending authorizations can change or be voided.

---

Quick Reference: PayPal CSV Column Map

What You Need	PayPal CSV Column	Notes
Date	Date	Transaction date, not settlement date
Time	Time	Useful for sorting same-day transactions
Client name	Name	The sender's PayPal name — may not match your client record
Gross amount	Gross	Before fees
Fee	Fee	PayPal's transaction fee
Net amount	Net	What you actually received
Currency	Currency	The original transaction currency
Transaction ID	Transaction ID	Unique — use for matching
Reference	Item Title or Reference Txn ID	May contain your invoice number

---

When to Use PayPal's "Financial Summary" Report

If the CSV approach drives you crazy, PayPal offers a Financial Summary report (PDF) that groups transactions by currency and shows total fees and conversions. It's less flexible for bookkeeping but easier to read:

PayPal → Reports → Financial Summaries → Monthly Financial Summary

Use this for a high-level check: "Did my monthly PayPal net roughly match my bank deposits?" If the numbers are way off, dig into the CSV.

related:

• "multi-currency-bookkeeping-for-freelancers"
• "upwork-income-tracking-guide" productSlug: "multi-currency"

---

Bottom Line

PayPal multi-currency reconciliation is painful because PayPal's conversion spread, batching, and fees are spread across multiple screens and files. The manual approach works if you have fewer than 5 international payments a month. Beyond that, an AI bookkeeping tool that reads PayPal CSVs natively saves hours and catches errors you'd miss.

If you're spending more than 2 hours/month on PayPal reconciliation:

• Try AI-powered import that reads PayPal CSVs, detects currencies, and auto-categorizes fees — free to start
• Or: export PayPal's Financial Summary PDF for monthly sanity checks