Skip to main content

How do I reconcile Stripe payouts across multiple currencies in NetSuite?

Reconcile each currency's payouts separately, against a bank account held in that currency, rather than converting to base currency up front. Stripe settles each currency independently, and NetSuite needs the transaction-currency amount preserved so its own revaluation, not a manual conversion, produces the base-currency gain or loss.

Zuny FesterBy Zuny Fester, Head of Operations and Marketing
Reviewed by Zuny Fester
Published Last reviewed Editorial policy

Part of the payment reconciliation and cash application guide.

Rule of thumbOne bank account per settlement currency, matched separately
Where conversion happensNetSuite's currency revaluation, not a manual pre-conversion
Common failure modeConverting to base currency before matching, which breaks the transaction-currency link
Gain/loss accountRealized and unrealized exchange rate gain/loss, per NetSuite's multi-currency setup

Why single-currency reconciliation logic breaks here

Stripe settles payouts in the currency the charge was processed in, not automatically converted to your company's reporting currency. A US company accepting EUR and GBP payments gets separate EUR and GBP payouts, each needing its own bank account (real or virtual) in NetSuite to land in. If those payouts get converted to USD before they're matched against invoices, the link between the original transaction-currency amount and the invoice is lost, and NetSuite's own currency revaluation — which is what's supposed to calculate the realized gain or loss — has nothing correct left to revalue.

The correct sequence

Match each payout, in its native currency, against invoices booked in that same currency. Let the payout post to a bank account (or bank sub-account) held in that currency. Only at period end does NetSuite's currency revaluation process convert the ending balance to base currency and post the resulting gain or loss — that revaluation step is where currency movement is supposed to be recognized, not earlier in the matching process.

Next step

Map the finance workflow with the most exposure and prove the automation path.

Bring the invoice, contract, payment reconciliation, or customer finance workflow you have to defend at audit. Loopfour can map the trigger, controls, integrations, and approval loop.

Book a workflow review

Field mapping

Multi-currency Stripe-to-NetSuite field mapping

Stripe fieldNetSuite fieldNotes
Payout currencyBank account currencyMust match; do not convert before posting
Charge amount (transaction currency)Customer payment (transaction currency)Applied against the invoice in the same currency
Period-end balanceCurrency revaluationConverts to base currency; posts realized/unrealized gain or loss
Stripe fee (transaction currency)Processing fee expense (transaction currency)Also revalued at period end alongside the bank balance

Frequently Asked Questions

You need a way to hold and reconcile each currency separately in NetSuite — that's usually a dedicated bank account per currency, though some setups use virtual sub-accounts under one physical account.

At NetSuite's currency revaluation step, typically run as part of the period close checklist, not at the moment the payout is matched to an invoice.

You lose the transaction-currency link between the payout and the invoice it settles, which breaks both the match itself and the revaluation calculation that depends on knowing the original currency and amount.

Sources

Related