Converting PayPal Activity Reports to Journal Entries
Why PayPal Accounting Is Tricky
PayPal is one of the oldest and most widely used payment processors, but its reporting is notoriously difficult for bookkeepers. Unlike Stripe's clean transaction-level exports or Amazon's structured settlement reports, PayPal's activity download mixes every type of transaction into a single chronological feed: sales, refunds, transfers, holds, currency conversions, subscription payments, and personal transactions.
The result is a CSV that requires significant filtering and categorization before it can be turned into journal entries. If you record PayPal activity incorrectly, you'll end up with duplicated revenue (recording both the sale and the transfer), missed fees, or unreconciled holds that throw off your bank balance.
Anatomy of the PayPal Activity Download
Want to skip the manual work?
Upload your settlement file — no login required. SettleBooks parses it and generates a balanced journal entry in under 60 seconds.
Try the free Settlement Summary Viewer →PayPal's downloadable activity report (accessed via the Activity page) contains these key columns:
| Column | Description |
|---|---|
| Date | Transaction date and time |
| Type | Transaction type (e.g., "Website Payment", "Payment Refund", "General Withdrawal") |
| Status | Completed, Pending, Held, Denied, etc. |
| Gross | Total transaction amount before fees |
| Fee | PayPal processing fee (negative value) |
| Net | Amount after fees (Gross + Fee) |
| Balance | Running PayPal balance after this transaction |
| Transaction ID | Unique PayPal transaction identifier |
| Currency | Transaction currency code |
The critical thing to understand: PayPal's activity includes both sides of transfers. When money moves from PayPal to a bank account, you'll see a "General Withdrawal" in the activity — this is not revenue, it's just a transfer between accounts. Recording it as income is one of the most common PayPal bookkeeping errors.
PayPal Transaction Types
PayPal uses dozens of transaction type labels. Here are the ones that matter most for bookkeeping:
Revenue Transactions
- Website Payment / Express Checkout Payment: Standard e-commerce sale
- Mobile Payment: Sale completed via PayPal mobile
- eBay Auction Payment: Payment received through eBay integration
- Subscription Payment: Recurring payment received
Fee and Deduction Transactions
- Payment Fee: Processing fee charged on an incoming payment (usually shown on same row)
- Currency Conversion Fee: Fee for converting between currencies
Refund Transactions
- Payment Refund: Full or partial refund issued to buyer
- Payment Reversal: Forced reversal (chargeback or dispute)
Transfer Transactions (Not Revenue)
- General Withdrawal: Transfer from PayPal to bank account
- Bank Deposit to PayPal: Funding from bank to PayPal balance
- General Currency Conversion: Converting balance between currencies
How PayPal Fees Work
PayPal's fee structure differs from Stripe in several ways that affect reconciliation:
- Standard processing: 2.99% + $0.49 per transaction (current US rates)
- Refund fee handling: When you issue a refund, PayPal keeps the original processing fee (unlike some processors that return it)
- Currency conversion: PayPal applies an exchange rate markup of 3-4% above the mid-market rate, shown as a separate conversion line
- Dispute/chargeback fee: $20.00 per chargeback (waived for sellers with under 0.40% dispute rate)
Fee Credits on Refunds
When a sale is refunded, the fee for the original transaction is not returned. This means your refund journal entry needs to account for the lost fee separately — the refund to the customer is the gross amount, but your PayPal balance only decreases by the net.
Worked Journal Entry Example
Suppose you're recording a week of PayPal activity with the following summary:
| Category | Amount |
|---|---|
| Gross sales (28 transactions) | $6,450.00 |
| Processing fees | −$242.16 |
| Refunds issued (3 orders) | −$185.00 |
| Currency conversion fees | −$12.40 |
| Net activity | $6,010.44 |
A withdrawal of $5,500.00 was made to the bank during this period. The journal entry:
| Account | Debit | Credit |
|---|---|---|
| PayPal Balance (asset) | $6,010.44 | |
| PayPal Processing Fees | $242.16 | |
| Refunds & Returns | $185.00 | |
| Currency Conversion Fees | $12.40 | |
| Sales Revenue | $6,450.00 | |
| Totals | $6,450.00 | $6,450.00 |
The bank transfer is recorded as a separate entry:
| Account | Debit | Credit |
|---|---|---|
| Bank Account (checking) | $5,500.00 | |
| PayPal Balance (asset) | $5,500.00 |
This keeps the PayPal balance as an intermediate asset account, matching how the money actually flows.
How to Download Your PayPal Activity
- Log in to PayPal Business
- Go to Activity > All Transactions
- Set the date range for the period you need
- Click Download (top right)
- Select CSV format and Balance affecting filter
- Choose Completed status to exclude pending transactions
- Download the file
For high-volume accounts, download in monthly batches to keep file sizes manageable.
Importing into Your Accounting Software
QuickBooks Online
Use the SettleBooks PayPal converter to filter out transfers, categorize transaction types, and generate balanced journal entries. Export as IIF for Desktop or CSV for Online.
Xero
After converting with SettleBooks, import the Xero-formatted CSV via Accounting > Manual Journals. Each period's activity becomes a single balanced entry, with the PayPal balance account acting as a clearing account.
Sage
Export as Sage CSV from SettleBooks and import through Transactions > Journal Entries. PayPal fee categories are mapped to Sage nominal codes automatically.
Edge Cases to Watch For
Holds and Pending Transactions
PayPal may hold funds for new sellers or flagged transactions. Held funds appear in the activity with Status = "Held" but don't affect the available balance. Do not record held transactions as revenue until the hold is released (Status changes to "Completed"). Filter your download to completed transactions only.
Payment Reversals vs. Refunds
A refund is voluntary — you issue it. A reversal is involuntary — PayPal or the buyer's bank forces it. Reversals often come with a chargeback fee and should be tracked separately for dispute management.
Pending eChecks
eCheck payments take 3-5 business days to clear. They appear as "Pending" initially. Only record them when the status changes to "Completed" to avoid overstating revenue.
Multi-Currency Accounts
If your client accepts multiple currencies, PayPal maintains separate balances per currency. Currency conversions between these balances are not revenue or expense — they're reclassifications. Record them as transfers between currency-specific PayPal sub-accounts if you need that level of detail.
Personal vs. Business Transactions
If the PayPal account is used for both business and personal transactions, you'll need to filter out personal items. SettleBooks flags common personal transaction types (like "Friends and Family" payments) during the conversion process.
Recommended Chart of Accounts
| PayPal Category | Account Name | Account Type |
|---|---|---|
| Gross sales | Sales Revenue | Income |
| Processing fees | PayPal Processing Fees | Expense |
| Refunds | Refunds & Returns | Contra-Revenue |
| Currency conversion fees | Currency Conversion Fees | Expense |
| Chargebacks | Chargeback Losses | Expense |
| Dispute fees | Dispute Fees | Expense |
| PayPal balance | PayPal Balance | Current Asset |
| Bank transfer | Bank Account | Asset |
Automate Your PayPal Reconciliation
Filtering PayPal activity, removing transfers, handling multi-currency lines, and building balanced journal entries by hand is one of the most time-consuming bookkeeping tasks. SettleBooks does it in seconds — upload your PayPal activity CSV and get clean, balanced journal entries for any accounting platform.