Skip to main content
BlogOctober 31, 202611 min read

Stripe-to-NetSuite variances: how to record fees, refunds, and chargebacks so the amounts tie

Fees, refunds, and chargebacks cause most Stripe-to-NetSuite variances. How to record each one so payouts reconcile to the cent, every run.

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

Part of the payment reconciliation and cash application guide.

Stripe-to-NetSuite variances: how to record fees, refunds, and chargebacks so the amounts tie

Most Stripe-to-NetSuite variances come from five sources: processing fees that were netted instead of recorded, refunds recorded in the wrong period or not at all, disputes and dispute fees withdrawn from a payout, NetSuite amounts that were edited after sync, and currency conversion. Each one has a correct NetSuite entry. Record fees as a Cash Back line to an expense account, refunds as a credit memo and customer refund that clear through the deposit, and disputes to a dedicated account until they resolve. Do that every payout and the amounts tie to the cent.

The variance itself is rarely large. It's a $15 dispute fee here and a $13.35 unreturned processing fee there. The problem is that small, unexplained differences accumulate in a suspense account, and at quarter-end nobody can say which payout created which cent.

Key takeaways

• Record Stripe fees gross, never netted. Book the payment at the invoice amount and the fee as a separate Cash Back line on the deposit, coded to merchant processing fees.

• Refunds need two records: a credit memo against the original invoice and a customer refund that clears through the payout's deposit.

• Stripe doesn't return processing fees on refunded payments, so a refund never fully reverses the original charge and its fee.

• Disputes are a lifecycle, not an entry. Post the withdrawn amount to a chargebacks account, the fee to expense, and clear the account when the dispute is won or lost.

• Loopfour, the deterministic finance workflow automation platform, applies these entries as predefined rules on every payout and routes any unexplained variance to an approver instead of a suspense account.

What causes an amount mismatch when reconciling Stripe to NetSuite?

An amount mismatch happens when the NetSuite records selected for a payout don't sum to what Stripe actually paid out. Either a component of the payout wasn't recorded in NetSuite, or a NetSuite record doesn't equal its Stripe counterpart.

Tools name these explicitly. Celigo's payout reconciliation app creates variance transactions of type "Amount Mismatch," when a NetSuite transaction's value doesn't match Stripe, and "Missing Transaction," when no NetSuite transaction is found (Celigo documentation). Stripe's own connector raises an unequal_amounts validation error and lists common causes: manual edits to the NetSuite amount, workflows or scripts that modify amounts, currency conversion differences, and tax or fee adjustments applied in NetSuite (Stripe troubleshooting guide).

The variance table: cause, symptom, and the correct NetSuite entry

Use this table to diagnose a variance and book the right entry. Amounts in the worked entries below are illustrative.

CauseHow it shows upCorrect NetSuite treatment
Processing fees nettedDeposit is short by the fee total; revenue understatedPayment at gross; Cash Back line to merchant processing fees
Refund not recordedDeposit is short by the refund amountCredit memo on the invoice plus customer refund from Undeposited Funds, included in the deposit
Fee on a refunded chargeRefund and original charge don't net to zeroNo reversal of the original fee; it stays in expense
Dispute withdrawnDeposit is short by the disputed amountCash Back line to a chargebacks account (or credit memo and customer refund, per policy)
Dispute feeDeposit is short by the dispute feeCash Back line to merchant processing fees
Dispute wonA later payout is higher than its chargesOther Deposit line crediting the chargebacks account
Partial refundDeposit is short by less than the invoice amountCredit memo for the refunded portion only, plus customer refund
Amount edited in NetSuiteunequal_amounts or Amount MismatchRestore the synced amount; fix the source if the change was intended
Invoice total changed after payment link sentCharge amount differs from amount dueRestore the original invoice amount or handle tax setup
Currency conversionDeposit in settlement currency differs from payment currencyRecord the Stripe settlement amount and rate; separate conversion fees if needed

How do I record Stripe fees separately when reconciling in NetSuite?

Record the customer payment at the gross invoice amount, then add the Stripe fees for the payout as a Cash Back line on the NetSuite deposit, coded to a merchant processing fee expense account. Oracle's documentation describes the Cash Back subtab as the place to enter an amount, account, and memo for money taken back from a deposit (Oracle NetSuite: Making deposits).

That is also how Stripe's connector does it. According to Stripe's documentation, Stripe fees and fee refunds post as Cash Back and Other Deposit lines, and most fees post to a Payment fees category by default, which you can remap per fee type.

Illustrative payout: $9,655.00 of charges with $281.50 in fees.

AccountDebitCredit
Operating bank account$9,373.50
Merchant processing fees$281.50
Undeposited Funds$9,655.00

Three fee types need their own mapping decision:

• Payment processing fees: the per-transaction fee on each charge.

• Stripe service fees: fees for other Stripe products and services, which post to the same account by default but can be separated.

• Interchange Plus (IC+) fees: under IC+ pricing, Stripe's documentation notes that fees don't appear on the individual charge and are recorded on the payout as network fees and Stripe fees. Map both categories deliberately, or they'll surface as an unexplained difference.

How do I reconcile a payment processor with refunds and chargebacks?

Reconcile refunds and chargebacks by recording each one as its own NetSuite transaction, clearing it through the deposit for the payout it reduced, and tracking disputes in a dedicated account until they resolve. The payout is the anchor: whatever reduced that payout has to appear on that payout's deposit.

Refunds

A refund needs a credit memo against the original invoice and a customer refund that pays it out. Stripe's multi-currency documentation notes that its connector creates both a Credit Memo and a Customer Refund for refunds and disputes (Stripe: multiple currencies).

Illustrative $450.00 full refund on a paid invoice:

RecordAccountDebitCredit
Credit memoRevenue (or sales returns, per policy)$450.00
Credit memoAccounts receivable$450.00
Customer refundAccounts receivable$450.00
Customer refundUndeposited Funds$450.00

The customer refund then appears as a negative item on the payout's deposit. Do not reverse the original processing fee. Stripe states that fees from the original charge aren't returned when you refund.

Chargebacks, from opened to resolved

A dispute moves through three states, and each one needs an entry. Stripe withdraws the disputed amount and a dispute fee when the dispute opens. If you win, the amount comes back in a later payout as a dispute reversal. If you lose, the amount stays gone. Fee amounts vary by region and pricing, so check Stripe pricing for yours; the $15.00 below is illustrative.

EventAccountDebitCredit
Dispute opened (deposit Cash Back lines)Chargebacks receivable$600.00
Dispute openedMerchant processing fees$15.00
Dispute openedOperating bank account (deposit reduced)$615.00
Dispute won (deposit Other Deposit line)Operating bank account$600.00
Dispute wonChargebacks receivable$600.00
Dispute lost (journal entry)Chargeback losses (or revenue reduction, per policy)$600.00
Dispute lostChargebacks receivable$600.00

The chargebacks account should be near zero once disputes resolve. Any balance is a list of open disputes, and you can reconcile it to Stripe's open disputes at every month-end. If you counter a dispute, Stripe's dispute fees FAQ notes that a dispute countered fee applies in addition to the dispute received fee, and the countered fee is returned if you win.

Some teams follow the connector's model instead and record a lost dispute as a credit memo and customer refund. Either approach works if it's documented, applied consistently, and agreed with your auditors.

Book a workflow review to see your own fee, refund, and dispute entries mapped as rules, with every variance routed to a named approver.

How to find the source of a variance fast

Work from the payout down, not from the ledger up. A top-down search through NetSuite rarely finds a $15 difference. A payout-level comparison finds it in minutes.

• Pull the payout's itemized transactions from Stripe's payout reconciliation report, grouped by reporting category.

• Compare category totals to the deposit's lines: charges to payments, refunds to customer refunds, fees to Cash Back lines, disputes to the chargebacks lines.

• Isolate the category that differs. A difference in fees points to IC+ or a missed fee type. A difference in charges points to an edited or missing NetSuite record.

• Compare transaction by transaction within that category, using the balance transaction ID and invoice ID.

• Fix the source record, not the deposit. Plugging a deposit hides the cause and guarantees the same variance next month.

How to stop Stripe-to-NetSuite variances from recurring

Variances stop recurring when every payout component has a predefined entry and anything outside those rules is held for a decision. Suspense accounts exist because nobody decided in advance where a dispute fee goes.

A connector records the standard path. Loopfour governs the edges. Loopfour builds the reconciliation on your Stripe and NetSuite accounts: pull the itemized payout → map each reporting category to its predefined entry → create the deposit → compare totals to the bank → route any unexplained difference to Slack with the payout, the NetSuite records, and the failing category attached. Every run leaves an execution tree, so the answer to "where did this $15 come from" is one click away. For the full picture, see how to reconcile Stripe with NetSuite and why Stripe payouts don't tie to the NetSuite bank deposit.

Frequently asked questions

Should Stripe fees be recorded as an expense or netted against revenue? Record Stripe fees as an expense, separate from revenue. Book the customer payment at the gross invoice amount and add the fees as a Cash Back line on the deposit. Netting fees against revenue understates revenue and makes the payout impossible to trace.

Why doesn't my Stripe refund fully reverse the original payment? Stripe doesn't return the processing fee from the original charge when you refund. The refund returns the customer's money, but the original fee remains an expense. Your books should show the full refund and leave the original fee in place.

Where should chargebacks go in NetSuite? Post the disputed amount to a dedicated chargebacks receivable or disputes account when Stripe withdraws it, and the dispute fee to merchant processing fees. Clear the account when the dispute is won or lost, and reconcile its balance to Stripe's open disputes at month-end.

What causes an Amount Mismatch variance in Celigo or unequal_amounts in the Stripe connector? Both mean a NetSuite record doesn't equal its Stripe counterpart. Common causes are manual edits in NetSuite, scripts or workflows that change amounts, tax adjustments, and currency conversion. Check the record's System Notes, then fix the source rather than the deposit.

How do IC+ fees affect reconciliation? Under Interchange Plus pricing, fees don't appear on individual charges. Stripe records them on the payout as network fees and Stripe fees. Map both categories to accounts in advance, or they appear as an unexplained difference between charges and the deposit.

Conclusion

Stripe-to-NetSuite variances come from a short list of causes: netted fees, unrecorded refunds, disputes and their fees, edited amounts, and currency conversion. Each has a correct entry. Record payments gross, fees as Cash Back lines, refunds as a credit memo plus customer refund, and disputes to a dedicated account through their full lifecycle. Diagnose from the payout down, and fix the source record rather than the deposit.

Tell us the one workflow your team dreads. We will show it running: deterministic, permissioned, and auditable.

Book a demo.

Sources

• Stripe: Stripe payouts in NetSuite

• Stripe: Troubleshoot the connector

• Celigo Help Center: Reconcile your Stripe payouts

• Stripe Support: Understanding fees for refunded payments

• Oracle NetSuite: Making deposits

• How to reconcile Stripe with NetSuite: the complete guide, and which connector you need

• Why your Stripe payouts don't tie to the NetSuite bank deposit

• How to reconcile multi-currency Stripe payouts in NetSuite

• Why payments get stuck in Undeposited Funds after a Stripe payout

• How to automate payment reconciliation in 2026 (step-by-step playbook)

Sources

  1. Stripe, Stripe payouts in NetSuite (opens in a new tab).
  2. Stripe, Troubleshoot the connector (opens in a new tab).
  3. Stripe, Multiple currencies with Stripe and NetSuite (opens in a new tab).
  4. Stripe, Payout reconciliation report (opens in a new tab).
  5. Oracle NetSuite, Making deposits (opens in a new tab).