Should I reconcile PayPal to the bank transfer or the activity report?

Reconcile to the activity report first: it explains the fees, disputes, holds, and conversions behind the balance. The bank transfer only confirms that a swept amount reached the bank; it does not decompose the activity that produced it.

How should PayPal fees be handled in NetSuite?

PayPal deducts a fee per transaction, so fees should be isolated from gross sales into a fee expense (or configured clearing treatment) rather than absorbed into net revenue. The exact posting depends on the chart of accounts and close policy.

Does PayPal reconciliation require Celigo?

No. PayPal keeps a running balance, not a clean payout, and that balance moves for per-transaction fees, disputes, holds, pending e-checks, and currency conversion well before any bank sweep; none of it depends on Celigo. Celigo can carry the activity report into NetSuite when a brand already uses it elsewhere; decomposing that balance activity is the reconciliation, and Vista Recon handles it either way.

PayPal to NetSuite reconciliation

PayPal reconciliation to NetSuite

A channel guide for finance teams whose PayPal activity, balance, and bank sweeps have to tie to NetSuite without rebuilding every transaction by hand.

Request pricing Explore Vista Recon

The method

How do you reconcile PayPal to NetSuite?

PayPal reconciliation to NetSuite matches the PayPal settlement or activity report to the orders, refunds, per-transaction fees, disputes, holds, and currency conversions behind each movement, separately from the bank withdrawal that later moves funds out of the PayPal balance. The method decomposes the activity report before posting, so finance reviews exceptions instead of reverse-engineering the balance.

Key takeaways

Reconcile from the PayPal activity/settlement report, not from the bank transfer that sweeps the balance.
PayPal nets a per-transaction fee on each payment, so gross sales never equal the balance change.
Disputes, holds, reserves, and pending e-checks move money on their own timeline; separate each before posting.
Multi-currency balances add a conversion step that has to be isolated so it does not distort revenue.

01 · The pattern

Why does PayPal not reconcile to NetSuite?

PayPal keeps a running balance rather than paying out a clean batch, and that balance moves for many reasons NetSuite records separately. Each payment nets a per-transaction fee, disputes and holds withhold funds, e-checks stay pending for days, and multi-currency balances convert at PayPal's rate. The bank transfer that later sweeps the balance is a separate event again, so matching the transfer alone proves cash landed but explains none of the activity underneath it.

The bank sweep is a balance withdrawal, not a settlement of specific orders.
A per-transaction fee is deducted on each payment before it reaches the balance.
Disputes, claims, and risk holds withhold or reverse funds after the original sale.
e-checks post as pending and clear days later; multi-currency payments convert at PayPal's rate.

02 · The pattern

Which PayPal report lines need NetSuite treatment?

Each activity category needs a known NetSuite destination or an exception reason. The goal is to preserve enough PayPal detail that NetSuite carries accurate revenue, fee, dispute, and currency treatment, not a balance change no one can explain at close.

PayPal detail	NetSuite treatment	Review gate
Payment / transaction	Customer payment, deposit, or order-related activity	Confirm the payment maps to the expected NetSuite customer and channel.
Per-transaction fee	Fee expense or configured clearing treatment	Isolate the fee from gross sales before posting.
Dispute, claim, or chargeback	Refund, credit, or exception queue	Tie it back to the original payment and review period timing.
Hold, reserve, and currency conversion	Clearing, timing exception, or FX treatment	Track holds until release and keep conversion out of revenue.

03 · The pattern

How does Altura make PayPal reconciliation repeatable?

Altura turns the PayPal-to-NetSuite logic into an operator method: normalize the activity report, map each line to NetSuite activity, isolate fees, disputes, holds, and conversion, then define the review gate before ledger-impacting entries post. Vista Recon is the product path for that governed workflow.

Normalize the PayPal activity report before comparing it to NetSuite.
Reconcile the balance change to its underlying transactions, then the bank sweep to the balance.
Use exception reason codes to separate holds and pending e-checks from true misses.
Feed repeat exceptions back into mapping, integration, or NetSuite configuration fixes.

Shared vocabulary

What terms matter on this page?

These definitions keep the method precise and extractable for answer engines, while giving finance a shared vocabulary for source files, NetSuite treatment, and review gates.

PayPal balance

The funds held in the PayPal account between when a payment is received and when the balance is swept to the bank.

Reserve / hold

An amount PayPal withholds against risk or dispute exposure, creating a timing difference that must be tracked until release.

e-check (pending)

A bank-funded PayPal payment that posts as pending and clears days later, so the sale and the available cash fall in different windows.

Where it goes next

When the pattern becomes an operating decision

This pattern sits between the settlement library, productized reconciliation, and the service paths that explain why the mismatch keeps recurring.

If this reconciliation pattern is caused by connector behavior, the operating decision belongs with a Celigo NetSuite integration partner. If the issue comes from a stalled implementation or brittle partner handoff, compare it with NetSuite HealthCheck and recovery. If the same pattern recurs every close, evaluate Vista Recon against the full NetSuite payout reconciliation.

Authorship

Who wrote this guide?

Written by Dave Charland, Founder, Altura Innovation. Last updated 2026-07-04.

FAQ

Frequently asked questions

Need this payout source to tie to NetSuite?

Tell us where the source file, NetSuite record, and close process stop agreeing, and we will help scope the safest Vista Recon path.