NetSuite Insights & Guides | CuriousRubik

NetSuite Shopify Integration in Singapore: A Worked Week

Written by Swara | Nov 16, 2026, 4:31:00 AM

A worked example for Singapore retail finance and operations leads who sell on Shopify and keep their books in NetSuite.

Last reviewed: 16 November 2026. Product details reflect this review date. Availability and behavior can vary by account, role and release.

A NetSuite Shopify integration in Singapore connects orders and stock with your finance records. For Shopify Payments payout sync, bill paid orders as cash sales and leave them undeposited. Match each payout deposit to the bank, then reconcile refunds, fees and GST using the store's tax settings and monthly fee invoice.

What does a NetSuite Shopify integration in Singapore do?

A NetSuite Shopify integration is a connection that moves products, prices and stock from NetSuite to your Shopify store, and brings orders and payouts into NetSuite. Refunds follow one chosen direction. NetSuite stays the system of record. Shopify stays the place where customers shop and pay.

Oracle's NetSuite Connector supports Shopify. It syncs items, prices, inventory, orders and fulfillments. With the Shopify Payout Report sync, it also creates a deposit in NetSuite for each Shopify Payments payout, with the fees on their own lines.

Before enabling payout sync, reauthorize the Shopify account in Connector to grant the required permissions.

Some companies use an integration platform or a custom build instead. Confirm their record design separately. This example uses NetSuite Connector.

How should NetSuite be set up before the first Shopify order?

Settle these decisions before you switch the order sync on. Each one changes what finance sees at month end.

  1. Bill web orders as cash sales. The Payout Report sync expects a cash sale for each paid order, left undeposited until the payout arrives. Leave cash refunds undeposited too and enable refund sync.
  2. Use one web customer or real customers. Many Singapore stores post web orders to one customer record per channel and keep the shopper's details on the order. Real customer records help if you run loyalty or B2B accounts.
  3. Map GST inclusive prices. A GST registered business must show prices that include GST, and Shopify sends the order total that way. Map the standard rated 9% tax code, so NetSuite splits the net sale from the output tax on each line.
  4. Choose a location for stock. Map the Shopify location to the NetSuite location that ships web orders, so stock and fulfillment stay in step.
  5. Set the payout accounts. Under Shopify > Settings > Other Transactions, open Settlement. Map Payout Base Account, Payout Cash Back Account, Payout Other Account and Payout Undeposited Account. Test their postings with finance.
  6. Pick one refund direction. The Connector syncs refunds one way per Shopify account. Oracle suggests refunding in NetSuite and syncing to the store, so the credit sits on the original sale.

People matter as much as settings. Train the store and finance teams on the new flow before go live. Our guide to NetSuite training in Australia sets out a role based plan that works just as well for a Singapore team.

A hypothetical week for a Singapore Shopify store

A hypothetical Singapore homeware store is GST registered, sells only on its own Shopify store and uses Shopify Payments with a weekly payout in SGD. A January 2027 payout batch covers 120 orders worth S$21,800 including GST, a refund of S$218 and S$545 in fees. Assume all sales are standard rated.

Orders become cash sales

Each paid order arrives as a cash sale, left in undeposited funds. Across the week, NetSuite holds S$21,800 there. GST is 9/109 of a GST inclusive price, so the week splits into S$20,000 of sales and S$1,800 of output tax. Rounding happens per order, so expect a few cents of difference in a real week.

Fulfillment updates both systems

The warehouse picks and packs each order in NetSuite against the web location. With fulfillment sync configured, shipped item fulfillments send status and tracking to Shopify. Test notification settings separately.

Inventory sync updates Shopify from the mapped NetSuite quantity. Confirm the location and available quantity rule before enabling it.

One refund becomes a cash refund

A customer returns an S$218 lamp. The team approves the return in NetSuite and issues a cash refund against the original cash sale, which syncs back to Shopify. NetSuite reverses S$200 of sales and S$18 of output tax.

Verify that the refund reverses the original tax treatment in the GST report. A tax code alone does not prove the return is correct. For physical returns, our NetSuite customer returns guide for Singapore covers inspection and restocking.

The payout becomes one deposit

Assume the settled batch pays out S$21,037. Weekly scheduling does not bypass settlement time or bank processing. The Payout Report sync builds the NetSuite deposit from the payout report, line by line.

Deposit lineAmount (S$)
120 cash sales21,800
Cash refund(218)
Shopify Payments fees, including 9% GST(545)
Deposit total21,037

The deposit total matches the bank line, so the bank reconciliation is a single match. Unmatched lines can use Payout Undeposited Account when Add non-imported transactions as standalone lines is enabled. Review that setting and clear unexplained balances weekly.

Three weekly checks keep the flow healthy.

  1. The unmatched payout account is back to zero.
  2. Undeposited funds holds only orders paid after the payout cutoff.
  3. The order count in NetSuite for the week equals the order count in Shopify.

If any check fails, look first at orders that failed to sync. Review Connector errors and retry only after checking for duplicate records.

How do GST and Shopify fees reach the GST F5 return?

Shopify Payments fees in Singapore include GST at 9%. Shopify issues a monthly invoice that shows the GST paid on fees. In the example, the S$545 of fees is S$500 plus S$45 of GST.

Agree a clearing pattern with your accountant. Deposit fee lines debit fee clearing. A monthly vendor bill debits fee expense and eligible input GST, and credits accounts payable.

Settle that bill through fee clearing to credit the gross fees there. Posting the bill to clearing alone would not clear both balances. Test account types and reporting before adopting this pattern.

These figures assume the invoice supports a full input tax claim in the same GST period. Reconcile the monthly invoice to all fee deductions. The week's contribution to that period's GST F5 is:

  • Box 1, standard rated supplies: S$19,800 (S$20,000 less the S$200 refund)
  • Box 5, taxable purchases: S$500
  • Box 6, output tax: S$1,782
  • Box 7, input tax: S$45

Whether you can claim the fee GST depends on your registration and the invoice details, so confirm with your tax adviser. If you also sell on marketplaces, our NetSuite marketplace integration guide for Singapore shows how escrow and settlement reports differ from Shopify payouts.

Which Shopify setup fits your store?

Most Singapore stores fit one of these patterns. Pick the one closest to yours, then test it with a real week of orders in a sandbox.

Your situationSetup that fits
One SGD store, Shopify Payments onlyCash sales, one web customer, Payout Report sync, fee clearing account
Several payment methods outside Shopify PaymentsPayout sync for Shopify Payments, a separate deposit and clearing account for each other provider
Store prices in several currenciesKeep SGD as the payout currency where possible, then check exchange differences in NetSuite
B2B buyers on accountInvoices and terms for those customers, cash sales for card buyers
Several Singapore and overseas entities on NetSuite OneWorldConfirm store ownership and subsidiary mapping, then test customer, location and bank assignments

If you already sell on Shopify and close the month from spreadsheets, start with the payout. Once the deposit matches the bank every week, the rest of the month end gets much easier. The legacy CuriousRubik post on how to reconcile Shopify and NetSuite from orders to payouts has a monthly tie out you can run beside it.

CuriousRubik's NetSuite ecommerce integration team can design the record flow, set up the Connector and test a full week with you before go live. See our NetSuite Singapore page and our work with retail and ecommerce companies.

Related reading

NetSuite Marketplace Integration for Singapore Sellers

How a Singapore seller on two marketplaces moves from order to bank in SGD.

NetSuite Customer Returns in Singapore: RMA to Credit Note

How a return moves from authorization to a GST compliant credit note.

NetSuite Ecommerce Integration in Australia for Retailers

How Australian retailers design record ownership, refunds and payouts.