Tally AssistantPayPal Multi-Currency Reconciliation: How Freelancers Fix Mismatched Transactions (2026)
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:
- Open each transaction in the PayPal web interface
- Click "Details" to see the conversion rate applied
- 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 30 minutes a month, AI bookkeeping tools can eliminate it entirely. Tally Assistant handles multi-currency PayPal CSVs by:
- Auto-detecting currency columns — reads
Currency,Gross,Fee,Netregardless of CSV layout - Applying daily exchange rates — converts all foreign-currency transactions to your base currency using that day's rate (via Frankfurter API)
- Flagging PayPal fees — separates the transaction amount from PayPal's processing fee so your books show both
- Matching clients — links "PayPal — John Smith" to your existing client "John Smith"
- 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.
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 30 minutes/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