For Singapore finance leads selling on Shopee or Lazada, one worked example of how marketplace sales and payouts land in NetSuite.
Last reviewed: 4 November 2026. Product details reflect this review date. Availability and behavior can vary by account, role and release.
NetSuite marketplace integration in Singapore brings marketplace orders, refunds, fees and payouts into NetSuite so stock stays accurate and every payout reconciles to the bank. The key is a clearing account for each marketplace. Sales go in gross, fees and refunds come off, and the payout to the bank clears the balance to zero.
A marketplace integration is the agreed flow of records between a selling platform and NetSuite: items and stock out, orders and settlements in. NetSuite stays the system of record for items, prices, stock and the ledger.
NetSuite Connector offers prebuilt marketplace flows for Amazon, eBay and Walmart. For Shopee and Lazada, which many Singapore sellers use, the link runs through an integration platform or a connector built on the NetSuite REST web services. Either way, the design questions are the same.
Before the build starts, agree these points with sales, the warehouse and finance:
The finance side is what usually goes wrong. A marketplace holds the buyer's money until the order is complete, then pays you a net amount after commission, service fees and refunds. No single payout ever equals a day of orders, so you need a method that explains the difference every time.
A hypothetical Singapore homeware company sells on Shopee and Lazada as well as its own wholesale channel. It is GST registered and prices on both marketplaces include 9% GST. Stock sits in one warehouse in Tai Seng.
The finance team sets up NetSuite like this before the integration goes live:
Each completed order comes in as a cash sale against the marketplace customer, with the payment posted to the clearing account instead of the bank. Refunds come in as cash refunds against the same account. The integration also sends tracking numbers back to each shop when the warehouse ships, so the marketplace can release the money on time.
The team keeps the marketplace's own order number on every cash sale in a custom field. That one field makes the later reconciliation much faster, because the settlement report lists the same number for each order, refund and fee line. It also helps customer service find a shopper's order in NetSuite without searching by name.
Take one Shopee payout cycle for the hypothetical seller. Completed orders total S$21,800 including GST. Refunds total S$545 including GST. Shopee's settlement report shows commission and service fees of S$1,635 and shipping fees of S$218, both including GST.
Here is how each part posts:
| Record in NetSuite | Amount (S$) | Ledger effect |
|---|---|---|
| Cash sales for completed orders | 21,800 | Clearing up 21,800, sales 20,000, output GST 1,800 |
| Cash refunds | 545 | Clearing down 545, sales down 500, output GST down 45 |
| Vendor bill for commission and service fees | 1,635 | Fees expense 1,500, input GST 135 |
| Vendor bill for shipping fees | 218 | Shipping expense 200, input GST 18 |
| Bill payment from the clearing account | 1,853 | Clears both fee bills against the payout |
| Transfer of the payout to the operating bank account | 19,402 | Bank up 19,402, clearing down 19,402 |
Check the clearing account. It started at zero, went up by 21,800 and came down by 545, 1,853 and 19,402. That leaves zero, which proves the payout is fully explained.
Post the fee bills from the marketplace's tax invoice for the cycle, not from a guess. If the marketplace charges GST on its fees and gives you a valid tax invoice, the GST is usually claimable as input tax. Confirm the treatment with your tax adviser, especially for fees billed by an overseas entity.
You reconcile a payout by matching the bank line to one transfer, and the clearing account to the settlement report's order list. In NetSuite, the steps are:
Anything left in clearing after step 5 is a question to answer. In practice it is usually an order still in the return window, a refund that came in late or a fee type the mapping does not know yet. Our guide to NetSuite cash application in Singapore covers matching receipts to open items in the same way.
The cycle also feeds your GST return. In this example, the cycle adds S$19,500 to box 1 (standard rated supplies) and S$1,755 to box 6 (output tax) after the refunds. It adds S$1,700 of fees to box 5 (taxable purchases) and S$153 to box 7 (input tax), all excluding GST. Our walkthrough of the NetSuite GST F5 return shows how to trace each box back to transactions.
Some refunds arrive after the payout that included the original order. Post the cash refund when the marketplace confirms it, against the same clearing account. The next payout will be smaller by that amount, and the clearing account still comes back to zero over the two cycles. If the item comes back to the warehouse, receive it into a returns location first, so a person can check it before it goes back on sale.
Marketplaces often run vouchers and campaigns, and some of the cost falls on the seller. Map each seller funded voucher type to its own discount item, so campaign cost shows apart from commission. Ask the marketplace account manager which fees are charged per order and which are charged per campaign, because they appear in different parts of the settlement report.
The worked example posts every order as its own cash sale. That suits most sellers, but very high volumes may want a summary instead. Pick the pattern that fits how you sell.
| Your situation | Pattern that fits | Why |
|---|---|---|
| Under a few thousand orders a month | One cash sale per order | Easy to trace a single shopper's refund or complaint |
| Many thousands of orders a day | One summary cash sale per day per marketplace | Fewer records, with order detail kept in the settlement file |
| Selling in more than one country through the same marketplace | One subsidiary or clearing account per country and currency | Payouts arrive in different currencies and tax rules differ |
| Seller funded vouchers or campaigns | A separate discount item mapped to its own account | Shows campaign cost apart from fees |
Whichever pattern you choose, keep stock updates at the order level, because the warehouse picks orders, not summaries.
At CuriousRubik, we design the clearing accounts and fee mapping before we connect the first order. Our NetSuite ecommerce integration team can map your Shopee and Lazada settlement reports to NetSuite and test a full payout cycle in your sandbox account. Read more about our work with NetSuite customers in Singapore.
If the marketplace link is part of a new rollout, add the clearing account search to your daily watch list. Our hypercare plan for the weeks after go live shows how. For an own store setup, see how NetSuite ecommerce integration in Australia handles payouts and refunds.
How Singapore receipts from PayNow, GIRO and transfers are matched to open invoices.
How to prepare the Singapore GST F5 return from NetSuite and trace each box.
How a web store connects to NetSuite, from tax inclusive prices to payouts.