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.
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.
Settle these decisions before you switch the order sync on. Each one changes what finance sees at month end.
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 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.
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.
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.
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.
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 line | Amount (S$) |
|---|---|
| 120 cash sales | 21,800 |
| Cash refund | (218) |
| Shopify Payments fees, including 9% GST | (545) |
| Deposit total | 21,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.
If any check fails, look first at orders that failed to sync. Review Connector errors and retry only after checking for duplicate records.
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:
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.
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 situation | Setup that fits |
|---|---|
| One SGD store, Shopify Payments only | Cash sales, one web customer, Payout Report sync, fee clearing account |
| Several payment methods outside Shopify Payments | Payout sync for Shopify Payments, a separate deposit and clearing account for each other provider |
| Store prices in several currencies | Keep SGD as the payout currency where possible, then check exchange differences in NetSuite |
| B2B buyers on account | Invoices and terms for those customers, cash sales for card buyers |
| Several Singapore and overseas entities on NetSuite OneWorld | Confirm 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.
How a Singapore seller on two marketplaces moves from order to bank in SGD.
How a return moves from authorization to a GST compliant credit note.
How Australian retailers design record ownership, refunds and payouts.