# How to Reconcile PayPal Transactions Each Month

- Author: PreciseBankFlow (https://www.precisebankflow.com)
- Published: 2025-01-26
- Updated: 2025-01-26
- Category: Payment and deposit reconciliations
- Canonical: https://www.precisebankflow.com/blog/reconcile-paypal-transactions

> How to reconcile PayPal transactions: treat PayPal as a bank account, use the activity report, record fees and holds, and tie transfers to the bank.
To reconcile PayPal transactions each month, give PayPal its own account in the ledger and treat it like a bank. Download PayPal's activity report for the month, record every sale at its gross amount, book fees, refunds and holds as separate lines, and tie each transfer out of PayPal to a deposit on the bank statement.

## Setting up PayPal as its own bank account in the ledger

A PayPal balance is money the business owns that sits outside its bank, so it needs its own balance sheet account, usually set up as a bank-type account named for the PayPal login. Every sale, fee, refund and transfer then passes through that account, and its closing balance can be compared with the one PayPal reports.

The alternative most small businesses start with is posting PayPal transfers straight to sales when they land in the checking account. That works until someone asks what the business sold in March, or why fees never appear on the income statement. A dedicated PayPal account fixes both. Sales enter it at gross. Fees leave it as an expense. Transfers to the bank move money from one asset account to another, which is what they are.

A few setup choices save trouble later:

- **One ledger account per PayPal account.** A business with a US dollar balance and a euro balance, or with two PayPal logins, should have one ledger account for each, so each can be reconciled on its own.
- **A start date with a known balance.** Pick a month-end, read the PayPal balance on that date from the activity report, and enter it as the opening balance. If the PayPal account has been running for years without books, the guidance on [setting the opening balance for a first bank reconciliation](/blog/first-bank-reconciliation-opening-balance) applies here too.
- **A separate fees account.** Payment processing fees deserve their own expense line rather than a share of bank charges, so they can be reviewed against sales volume.

The same structure fits other processors. A business that also takes cards through Square can follow the parallel process for [reconciling Square deposits to sales and fees](/blog/reconcile-square-deposits), and the clearing-account idea is identical.

## Which PayPal activity report should the monthly reconciliation start from?

Start from the transaction activity download in PayPal's account history, set to the first and last day of the month, in CSV format. It lists each transaction with its gross amount, fee, net amount and running balance, which is everything the reconciliation needs. The monthly statement PDF is useful as a check on the closing balance.

According to [PayPal's help article on downloading transaction history](https://www.paypal.com/us/cshelp/article/how-do-i-download-my-transaction-history-help145), the download is built from the History page, can be produced as PDF, Quicken, QuickBooks, CSV or tab-delimited files, covers up to the past seven years, and takes up to 12 months of activity per request. A catch-up project covering several years therefore needs one request per year of activity.

CSV is the best choice for reconciliation because it keeps every column. A typical row carries:

- the date and time, and the time zone PayPal used;
- the transaction type, such as a payment received, a refund, a hold, a currency conversion or a transfer to the bank;
- the gross amount, the fee and the net amount;
- the counterparty's name and email;
- a transaction ID, and for refunds a reference to the original payment;
- the balance after the transaction.

Two quirks catch people out. First, the time zone: a sale late on the last evening of the month can fall into the next month if the report uses a different zone from the books. Pick one convention and keep it. Second, some events produce more than one row, for example a hold and its later release, or a currency conversion that appears once in each currency. Filter by transaction type before summing, and read the PayPal balance column rather than trusting a total you built yourself.

## Recording PayPal fees, refunds and currency conversions

Record each PayPal sale at its gross amount, with the fee as a separate expense, so the ledger matches the gross, fee and net columns in the activity report. Refunds reduce sales and come out of the PayPal balance. A currency conversion moves value between two balances and may create a small exchange gain or loss.

### Fees

PayPal deducts its fee before the money reaches the balance, so the net amount is what you can spend. The entry for an example $120.00 sale with a $4.08 fee is a debit to the PayPal account of $115.92, a debit to processing fees of $4.08, and a credit to sales of $120.00. Booking the month's fees as one summary entry is fine if the total agrees with the fee column of the report.

### Refunds

When a customer is refunded, the gross sale is reversed and the PayPal balance falls. Whether any of the original fee comes back depends on PayPal's current terms for your account, so read the fee column on the refund row instead of assuming. Record the refund against sales returns or the original income account, and record any returned fee as a reduction of fee expense.

### Currency conversions

A payment received in a foreign currency may sit in a separate currency balance or be converted on arrival. Each conversion shows as a pair of rows: one leaving the foreign balance and one arriving in dollars. If you keep separate ledger accounts by currency, record the conversion as a transfer between them at the rate PayPal used, and post any difference to exchange gain or loss.

## PayPal holds, reserves and open disputes at month-end

Money that PayPal holds back still belongs to the business but cannot be spent yet. It belongs on the books in the same PayPal account or a separate "PayPal funds on hold" asset, never in sales or expense. Open disputes are a different matter: the sale stands, but the risk of losing it should be tracked until the case closes.

Holds take several forms. A payment may be held for some days after a sale, a reserve may be kept against future refunds, or an account may be limited while PayPal reviews it. Each shows on the activity report as a row moving money out of the available balance, and a later row releasing it. At month-end, list every hold that has not yet been released, with its amount and original transaction ID. That list is a reconciling item between the available balance PayPal shows and the total balance in your books.

A dispute or chargeback works differently. When a buyer opens a case, PayPal may move the disputed amount to a hold. If the buyer wins, the hold becomes a reversal, and the sale is effectively undone. Book the reversal when the case closes, not when it opens, but keep a list of open cases with the reconciliation so a reviewer can see what is at risk.

Shopify stores that take PayPal see a version of this problem in two places at once. The walk-through on [reconciling Shopify payouts to orders and the bank](/blog/reconcile-shopify-payouts) explains why PayPal orders never appear in a Shopify payout, which is why they need this separate reconciliation.

## How do PayPal transfers tie to the bank statement?

Each transfer out of PayPal to the business's bank appears twice: as a withdrawal row on the PayPal activity report and as a deposit on the bank statement, usually one to a few business days later. Match the two by amount, record the transfer as a movement between asset accounts, and list any transfer still on its way at month-end.

Matching is easy when transfers are few and amounts are distinct. It gets harder with automatic daily transfers of similar amounts. In that case match in order: the oldest unmatched PayPal withdrawal against the oldest unmatched bank deposit for the same amount. A PayPal withdrawal on the last day of the month that has not reached the bank by the statement date is an amount in transit. It is no longer in the PayPal balance and not yet in the bank balance, so it should sit in a transfers-in-transit account or be listed as a deposit in transit on the bank reconciliation.

Money also moves the other way. A business that adds money to PayPal from its bank, or pays a supplier from PayPal funded by the bank, creates rows that need the same pairing. A transfer that appears on only one side is a real exception, not a timing difference, once a few business days have passed.

## A worked PayPal month from opening to closing balance

A finished PayPal reconciliation starts from the opening balance, adds gross sales, subtracts fees, refunds, transfers and other payments, and arrives at a computed closing balance. That figure should equal the closing balance on PayPal's report, after allowing for listed holds. Any difference left over is an error to find, not to adjust away.

The table below reconciles one example month. All figures are made up for illustration.

| Line (example) | Amount |
| --- | ---: |
| Opening PayPal balance, March 1 | 2,140.55 |
| Add: gross payments received, 84 sales | 9,862.00 |
| Less: PayPal fees on those sales | (342.17) |
| Less: refunds to customers, 3 orders | (296.00) |
| Add: fees returned on refunds | 0.00 |
| Less: transfers to checking, 4 withdrawals | (9,100.00) |
| Less: supplier paid from PayPal | (410.00) |
| Less: funds moved to hold, open dispute | (85.00) |
| **Computed available balance, March 31** | **1,769.38** |
| Available balance per PayPal report | 1,769.38 |
| **Difference** | **0.00** |
| Funds on hold, listed with transaction ID | 85.00 |
| **Ledger balance of the PayPal account** | **1,854.38** |

Example values only. The transfer list would show that three of the four withdrawals reached the bank in March and one of $2,300.00, sent on March 31, arrived on April 2.

Notice what the reviewer can check from this one page. Sales tie to the gross column. Fees tie to the fee column. Each transfer ties to a bank line or to the in-transit list. The hold is named and dated. Firms that run this tie-out for many clients and many accounts often move it into [general ledger reconciliation software with preparer and reviewer sign-off](/blog/general-ledger-reconciliation-software), so the open items carry forward month to month instead of living in separate spreadsheets.

On the bank side, the PayPal deposits still have to be found and ticked on the checking statement. [PreciseBankFlow](/get-started) reads each statement line, checks that the statement foots, and lists deposits that match no ledger entry, which is where a missing PayPal transfer shows up.

## Mistake: booking PayPal bank deposits as sales

Recording each PayPal transfer that lands in checking as sales is the most common PayPal bookkeeping error. It understates income by the fees, hides refunds, ignores money still sitting in PayPal, and double-counts if anyone also records the original sales. The fix is to route every transfer through the PayPal account as an asset-to-asset movement.

The error is easy to spot once you look for it. Sales on the income statement match the deposits from PayPal to the dollar, there is no processing fee expense at all, and the balance sheet has no PayPal account even though the business clearly holds money there. Another sign is a sales figure that jumps in months when someone sweeps the PayPal balance to the bank, even though orders were flat.

Correcting it for past months takes three steps:

1. Download the activity reports for each affected month and total gross sales, fees, refunds and transfers.
2. Reclassify the PayPal deposits in the ledger from sales to the PayPal account, then record gross sales, fees and refunds from the report.
3. Set the PayPal account balance at each month-end to the report's balance, and confirm the difference is zero before moving on.

If the books for those periods are already closed or filed, talk to whoever prepares the returns before changing them, since the correction changes reported revenue and expenses even if profit barely moves.