Top summary
Reconcile PayPal the way you reconcile a bank, not the way you reconcile a payout report: prove that opening balance plus gross receipts, minus fees, refunds, disputes, hold and reserve movements, and transfers, equals the closing balance on the PayPal statement, then tie each transfer to one bank deposit.
- PayPal is a stored-balance account with four money states; only the "available" state can reach your bank.
- The proof unit is the monthly closing balance, not an individual deposit.
- Holds and reserves are timing items, not expenses; never write them off to make the month close.
This is for an ecommerce operator who sells through a store or marketplace, collects some or all payments into a PayPal business account, and finds that monthly sales, the PayPal balance, and the bank deposits never agree. The decision to complete: close the month with a PayPal account you can defend, or identify exactly which variance blocks the close. Question evidence was collected on 13 August 2026 from Google autocomplete: "how to reconcile paypal in quickbooks online," "how to reconcile paypal in xero," "paypal reconciliation report," "paypal balance reconciliation report," "why is my paypal balance on hold," and "what amount does paypal report to irs." The final title is supported by at least two independent signals from that list.
Why is PayPal reconciliation a different problem than card-processor reconciliation?
Stripe or Shopify Payments settle net batches to your bank on a schedule, so the reconciliation unit is the payout. PayPal behaves like a bank account you happen not to control: money arrives as gross receipts, fees are deducted per transaction, refunds and disputes draw the balance down, holds and reserves quarantine part of it, and cash only reaches your actual bank when a transfer runs. If you import each bank transfer as "sales," you get a number that is simultaneously wrong as revenue (it excludes what stayed in PayPal) and wrong as cash flow (it mixes weeks of activity).
The consequence: your books need a PayPal ledger account that behaves like a second bank account, with its own opening balance, activity, and closing balance every month.
What are the four money states inside a PayPal balance?
The PayPal User Agreement describes the levers that move money out of your reach. Understanding the states explains most "missing money" before you spend an hour hunting for it:
| State | What it means | How it arises | Accounting treatment |
|---|---|---|---|
| Available | Withdrawable now | Cleared receipts net of everything below | Cash equivalent in the PayPal ledger |
| Pending | Receipt not yet cleared into the balance | Payment review, eCheck clearing | Note as in-transit; do not spend it in forecasts |
| On hold | Received but temporarily unavailable | New seller status, higher-risk categories, dispute rates; PayPal weighs account tenure, activity, business type, and past disputes | Still your asset; track in a held-funds sub-account |
| Reserve | Quarantined against future reversals | Rolling reserve (a percentage of each day's receipts released later on schedule) or minimum reserve (a fixed floor kept in the balance) | Restricted cash sub-account; release schedule documented |
Two details matter for the close. A rolling reserve releases on a schedule (PayPal's own example: 10% held for a 90-day rolling period, so day-1 money releases on day 91), which makes the reserve balance a predictable, auditable ladder. And holds decided for legal or court-order reasons can outlast the ordinary window, so an aged hold needs a status note, not an assumption.
What is the balance-proof equation?
Reconcile the month with one equation, run per currency:
Opening balance + gross receipts - PayPal fees - refunds sent - dispute debits and dispute fees +/- hold and reserve movements - transfers to bank +/- other adjustments = closing balance.
Every term comes from the downloadable activity report, not the dashboard. The equation closes only when the computed closing balance equals the closing balance on the PayPal monthly statement, to the cent. Each transfer in the equation then matches one deposit line in your real bank statement; unmatched transfers are timing items at the cutoff date, nothing more.
Fee math deserves care because PayPal prices per transaction. As of the fee page checked for this article (last updated 15 July 2026), the standard US domestic rate for PayPal Checkout commercial transactions is 3.49% plus a fixed fee of $0.49 for USD, and a standard dispute fee of $15.00 per dispute applies in USD. Your rate can differ by product, volume, or agreement, so verify against your own statement rather than assuming the published rate.
Which variance do I chase first?
When the equation fails, triage in this order:
- Transfers with no bank line (or the reverse). A transfer in transit across the month boundary is the most common and least dangerous break. Confirm value dates before touching anything else.
- Unexplained fee variance. Recompute expected fees (rate times volume plus fixed fees per transaction) and compare to actual. A mismatch here often means a rate change, a cross-border uplift, or micropayment pricing you forgot you had.
- Hold and reserve deltas. The change in held plus reserved funds must equal the hold/reserve movement term. If the statement's "unavailable" total moved by $5,000 but your equation only shows $4,000 of new holds, find the missing $1,000 in the activity export filtered to hold events.
- Refund and dispute mismatches. Refunds draw down the balance; disputes may debit the principal and a separate dispute fee. Confirm each against the Resolution Center record.
- Currency conversion residue. Multi-currency accounts convert at PayPal's transaction exchange rate including its conversion spread; convert each currency leg separately, never net them.
Worked hypothetical example: one month with a rolling reserve
Hypothetical example, not a customer result. Assume a home-goods store runs PayPal alongside card payments. Assumptions for the month: opening available balance $3,000 and opening rolling reserve $6,000 (10% reserve on a 90-day schedule); 400 orders totalling $52,000 gross receipts; PayPal Checkout pricing at 3.49% + $0.49; refunds of $2,600 principal; one dispute lost at $340 principal plus a $15 dispute fee; new reserve holds of $5,200; scheduled reserve releases of $4,100 from receipts 90 days prior.
| Equation term | Amount |
|---|---|
| Opening available balance | $3,000.00 |
| Gross receipts (400 orders) | +$52,000.00 |
| Fees: 3.49% of $52,000 plus 400 x $0.49 | -$2,010.80 |
| Refunds sent | -$2,600.00 |
| Dispute principal + dispute fee | -$355.00 |
| New rolling-reserve holds (10%) | -$5,200.00 |
| Scheduled reserve releases | +$4,100.00 |
| Computed available before transfers | $48,934.20 |
| Transfers to bank | -$46,000.00 |
| Closing available balance | $2,934.20 |
| Closing reserve balance ($6,000 + $5,200 - $4,100) | $7,100.00 |
The PayPal statement should therefore show a total balance of $10,034.20, split $2,934.20 available and $7,100.00 reserved, and the bank statement should show $46,000.00 of PayPal deposits (in one or several transfers). Interpretation: revenue for the month is $52,000 gross minus refunds under the store's policy, not $46,000; the reserve is restricted cash, not a loss. Limits: this example uses published standard rates as assumptions, excludes currency conversion and subscription billing, and assumes no fee clawback on refunds; confirm each treatment against your own agreement and statements.
What does the monthly close look like in practice?
- Export the full-month activity report and the monthly statement from PayPal's reporting area after the month ends.
- Post gross receipts to revenue (per your policy), fees to a merchant-fee expense account, refunds against sales or a returns account, and dispute items to a dedicated disputes account with status.
- Move hold and reserve activity through restricted-cash sub-accounts so the available balance stays visible.
- Run the balance-proof equation per currency; resolve variances in the triage order above.
- Match each transfer to one bank deposit; document in-transit items at the cutoff.
- File the export, statement, and a one-page close summary with the computed-versus-statement closing balance.
Definition of done: computed closing equals statement closing per currency; every transfer has a bank disposition; reserve and hold balances carry a release schedule or status note; and no bank deposit was posted directly to revenue.
When does this method break or need professional review?
Get help when you run multi-currency balances with frequent conversions, PayPal plus two or more other processors into one bank account, subscription or marketplace flows where PayPal is one leg of a split payment, or any account under a long-running limitation. Cross-check the year at tax time: PayPal is a TPSO and issues Form 1099-K over $20,000 and 200 transactions of goods-and-services payments, and that gross figure should reconcile back to the same ledgers you closed monthly. If your monthly files cannot reproduce your annual totals, fix that before filing, not after an IRS notice.
Sources and last updated
Last updated: 13 August 2026. Sources, last checked 13 August 2026: PayPal, User Agreement (holds, limitations, and reserves sections); PayPal, PayPal Merchant Fees (page last updated 15 July 2026); PayPal Help Center, monthly statement and reports guidance; IRS, Understanding your Form 1099-K; IRS, Recordkeeping. Caigeek runs this close as a managed service for ecommerce sellers: inputs are your PayPal exports and bank feeds, outputs are a reconciled PayPal ledger, a reserve release ladder, and an exception log with owners.
FAQ
Why is my PayPal balance on hold or pending?
PayPal's user agreement says it may hold payments from new sellers, higher-risk categories, or accounts with performance issues, and may place rolling or minimum reserves on business accounts. Held and reserved funds are yours but unavailable for withdrawal until released.
Are PayPal fees tax deductible?
Generally yes: processing fees on business receipts are an ordinary business expense. Record them as a separate expense line rather than netting them against revenue, so gross sales and fee costs both stay visible.
Does PayPal report my sales to the IRS?
PayPal is a third-party settlement organization. It must issue Form 1099-K when your goods-and-services payments exceed $20,000 and 200 transactions, and may issue one below that. The form reports gross payments, which you reconcile to your own receipts records.
What report should I use to reconcile PayPal?
Use the downloadable activity/transaction report for the full month rather than the dashboard balance view, plus the monthly statement. The activity export exposes fees, holds, and transfers as separate line types, which the dashboard hides.