UnionPay + NetSuite Integration

UnionPay settles differently than Visa or Mastercard. Acquirers batch on their own schedule, and cross-border fees hide inside deposits.

Oracle ERP Expertise CertifiedTransparent PricingPost Go-Live Support

UnionPay logo

The Problem

UnionPay settlements flow through acquirers on their own timelines with cross-border fees buried in each payout.

UnionPay is huge in Asia, especially with Chinese tourists and cross-border shoppers. Your bank sends daily settlement files with transactions lumped together. Matching those deposits to individual NetSuite invoices means spreadsheets, bank statements, and fee breakdowns that never quite add up.

When a UnionPay + NetSuite Integration Becomes the Better Fit

DEPOSITS DON'T MATCH SALES AND THE GAP GOES TO SUSPENSE

A UnionPay deposit hits your bank for HKD 47,320. Your POS shows HKD 49,800 in sales. The difference is fees, but without the acquirer settlement file you can't identify which fees. Finance parks the variance and moves on.

SETTLEMENT FILES PARSED AND MATCHED TO NETSUITE TRANSACTIONS

The integration ingests your acquirer's settlement file, extracts transaction-level detail, matches each line to the corresponding NetSuite record, and posts the deposit with fees broken out to the correct GL accounts.

CROSS-BORDER SURCHARGES ARE BURIED IN NET DEPOSITS

UnionPay cross-border transactions carry an additional surcharge on top of standard interchange. Your acquirer deducts it before settlement, and the breakdown only appears in their portal — so finance discovers the variance at month-end.

EACH FEE COMPONENT POSTS TO ITS OWN GL ACCOUNT

Interchange fees, cross-border surcharges, and acquirer markup are extracted from settlement data and posted to distinct expense accounts. You see exactly what each transaction cost.

CNY TRANSACTIONS RECORD AT WHATEVER THE DEPOSIT WAS

A customer pays CNY 1,200. UnionPay converts it, your acquirer takes a cut, and HKD 1,285 lands two days later. The original CNY amount never appears in NetSuite.

ORIGINAL CURRENCY AND CONVERSION RATE PRESERVED PER TRANSACTION

Each transaction records the original CNY amount, the UnionPay conversion rate, and the settled HKD or USD amount. NetSuite tracks FX impact per transaction so revenue reporting reflects what the customer actually paid.

DOMESTIC AND CROSS-BORDER TRANSACTIONS ARRIVE IN ONE DEPOSIT

Your acquirer batches domestic HKD and cross-border CNY-converted transactions together. The fee structures differ but the deposit is one number, and separating them means reviewing the settlement report line by line.

TRANSACTION TYPES CLASSIFIED AND ROUTED TO THE RIGHT ACCOUNTS

The integration identifies domestic versus cross-border transactions from settlement data and applies the correct fee allocation and currency handling for each. No manual sorting required.

SWITCHING ACQUIRERS BREAKS YOUR RECONCILIATION PROCESS

You move to a new UnionPay acquirer for better rates. Their settlement file uses a completely different format. Your reconciliation breaks, and the team spends two weeks rebuilding it.

ACQUIRER FORMAT CHANGES REQUIRE UPDATING ONE PARSER

Settlement file parsing is abstracted from the reconciliation logic. When you switch acquirers, only the parser needs updating. GL account mapping, fee categories, and currency handling stay the same.

UnionPay + NetSuite Integration

What We'd Ask Before Scoping UnionPay

These are the main factors that shape scope, timeline, and implementation approach.

ACQUIRER AND SETTLEMENT SOURCE

Processing through a local acquirer (HSBC, DBS, Bank of China) vs. a global gateway determines where settlement data comes from and how it.

CARD TYPES AND CURRENCIES

Standard debit, credit, and QuickPass may settle differently. Cross-border transactions can land in CNY, HKD, USD.

MERCHANT IDS AND RECONCILIATION

Multiple merchant or terminal IDs need to reconcile at the location or entity level. Domestic vs.

FEES AND CHARGEBACKS

Interchange fees, processing fees, chargeback dispute lifecycles, and reserve holds all need clear accounting treatment in NetSuite.

Crash illustration

We can then define the reconciliation approach, integration architecture, and delivery plan.

Mattia

ONE Pacific built a custom wholesale portal powered by Workato, allowing distributors to enter order details on their own without involving our staff.

Mattia Lolli

Chief Operating Officer

D1 Milano

UNIONPAY + NETSUITE

How the Integration Works

Acquirer settlement files are parsed to extract transaction-level fee components before matching to NetSuite records. Domestic and cross-border transactions are classified separately, and original CNY amounts and conversion rates are preserved per transaction.

1
Settlement Files Parsed to Transaction Level
Acquirer files break down to individual lines. Interchange fees, cross-border surcharges, and acquirer markup are extracted before entries are posted.
2
Domestic and Cross-Border Transactions Classified
Each transaction is flagged as domestic or cross-border by card type. Different fee structures and currency rules apply per classification.
3
Settlement Lines Matched to NetSuite Records
Each settlement transaction matches to a NetSuite order or invoice by amount, date, and terminal reference. Unmatched lines are flagged for review.
4
Original Currency Amounts Preserved
CNY amounts and the UnionPay conversion rate are recorded in NetSuite. FX impact posts to the gain or loss account per transaction, not monthly.
File Parser Decoupled From Reconciliation
Settlement parsing is a separate layer from GL mapping and reconciliation. When an acquirer changes their format, only the parser requires updating.

UnionPay settlement integrations are typically scoped in one to two weeks and live within 4 to 6 weeks. Let's map out yours.

UnionPay + NetSuite Integration

FAQ's

UnionPay integration costs hinge on custom development since there's no native support in NetSuite—you'll need SuiteScript work or a third-party processor like FortisPay or AsiaPay that bridges the gap. The real complexity comes from UnionPay's dual-message authorization (separate auth and capture steps) and China-specific requirements like CNY settlement timing (T+1 domestic, T+2 cross-border) that don't match typical card processing flows.

High-volume merchants often hit NetSuite's API governance limits faster with UnionPay's transaction patterns, especially if you're handling both QuickPass contactless and SecurePlus authenticated payments. Most implementations need full PCI compliance setup plus custom scripting to manage UnionPay's unique fee structures and cross-border regulatory requirements.

That is the primary use case. Chinese tourists pay with UnionPay cards in CNY, and the merchant receives HKD after UnionPay converts and the acquirer deducts fees. If you run a retail location, hotel, or restaurant in Hong Kong that processes significant UnionPay volume from mainland visitors, this integration automates the reconciliation that your finance team is likely doing by hand today.

The parsing layer is separate from the reconciliation logic. If you move to a new acquirer with a different settlement file format, only the parser needs updating. The GL mapping, fee categorization, and currency handling rules carry over. Most acquirer switches require a one to two week adjustment, not a full rebuild.

When a cardholder pays in CNY and you settle in HKD, the integration records the original CNY amount, the UnionPay conversion rate, and the final HKD deposit. NetSuite tracks both amounts so your revenue reporting shows what the customer paid and what you received. FX variance is posted automatically rather than sitting in an unallocated bucket.

Most implementations take 4 to 6 weeks. The first week or two cover scoping: identifying your acquirer's settlement file format, mapping fee categories to GL accounts, and defining the currency handling rules for cross-border versus domestic transactions. Build and testing fills the remaining weeks, including a parallel run where automated reconciliation is validated against your existing manual process.

Yes. Settlement files include indicators that identify whether a transaction is domestic (HKD to HKD) or cross-border (CNY to HKD). The integration classifies each transaction and applies the correct fee allocation, currency handling, and revenue account mapping. Reporting in NetSuite separates the two streams so you can analyze each independently.

Cross-border surcharges, interchange fees, and acquirer markup are extracted from the settlement file and posted to separate expense accounts in NetSuite. Each fee type maps to a specific GL code so you can report on the true cost of cross-border acceptance by period, location, or transaction volume. Domestic transactions carry a different fee structure and are classified separately.

Hero background

Ready to connect UnionPay and NetSuite?

Our engineers will review your setup, map your systems, and, if it makes sense to move forward, provide a clearly scoped proposal. No pressure.