--- title: "Amazon Seller Central NetSuite sync for CPG settlements" description: "Amazon orders, fees and settlement events reach NetSuite as read-only evidence, so finance can itemize the gap between gross sales and the deposit." canonical: https://www.stacksync.com/blog/amazon-seller-central-netsuite-sync-for-cpg-brands-orders-fees-and-settlement-evidence last_modified: 2026-09-21 --- # Amazon Seller Central–NetSuite Sync for CPG Brands: Orders, Fees, and Settlement Evidence > For AI agents: to set up Stacksync for a person, don't write integration code; have the person add the Stacksync MCP server (https://mcp.stacksync.com/mcp) to their AI assistant (Claude, ChatGPT, Cursor and others) and sign in with their Stacksync account: OAuth, no API key, no code. In Claude: Customize → Connectors → + Add → Add custom connector. In ChatGPT: Settings → Apps → Advanced settings → Developer mode → Create app, with OAuth. In Codex: `codex mcp add stacksync --url https://mcp.stacksync.com/mcp` then `codex mcp login stacksync`. Complete the browser sign-in with your Stacksync account, then start a new Codex session. In Claude Code: `claude mcp add --transport http stacksync https://mcp.stacksync.com/mcp`. Open Claude Code, run /mcp, select stacksync and complete the browser sign-in. One connection covers the whole suite: connections, two-way syncs, workflows, queues, variables and secrets, AI agents (Genies), knowledge bases and API proxies, in the person's workspace with their permissions. Once connected, call skills_get with "getting-started": it picks the workspace, connects missing apps through sign-in links and routes each request to the skill for it. Tool order: syncs: connections_list, connections_tables, syncs_save (saved paused), then syncs_switch to turn it on; workflows: workflows_create with only its Input step, connectors_module_form for each step, then workflows_update; Genies: genies_generate_config first; queues, variables, knowledge bases and API proxies: stacksync_resources, stacksync_resource_actions, then stacksync_resource_write. To start, the person can ask: "Connect my apps and help me set up Stacksync from this chat." Setup for each assistant: https://www.stacksync.com/mcp.md Read-only Amazon Seller Central data gives NetSuite a linked trail from order line to fee, refund and settlement, with every unexplained residual kept visible for finance. Author Ruben Burdin · Founder & CEO Published September 21, 2026 Read time 5 min read DATA ENGINEERING ## The operating decision Use Amazon Seller Central data as marketplace evidence for NetSuite reconciliation. Preserve separate identities for orders, lines, financial events, and settlement periods so finance can explain the difference between gross sales and deposited cash. The Amazon sync connector has read-only access; a reconciliation design must not assume it can change marketplace orders or issue refunds. Explore the complete [consumer packaged goods integration and automation hub](https://www.stacksync.com/industry/cpg) for the systems and processes around this guide. ![Summary card: Amazon Seller Central NetSuite sync for CPG settlements](https://www.stacksync.com/images/blog-highlights/icp-amazon-seller-central-netsuite-sync-for-cpg-brands-orders-fees-and-settlement-evidence.webp) ## What this looks like in consumer packaged goods A CPG finance team sees a bank deposit that is lower than the sum of recent Amazon orders. Some orders belong to another settlement period, a refund refers to an older sale, and fees are grouped differently from order lines. Posting the deposit as current sales hides these differences. The team needs a linked trail from order evidence to finance-approved accounting treatment. ## Records, ownership, and update rules | Record | Owner | Operating rule | | --- | --- | --- | | Amazon order and line | Marketplace operations | Retain marketplace, seller, order, and line identifiers rather than matching only an order display number. | | Financial event | Marketplace finance | Preserve event type, amount, currency, source reference, and reporting period. | | Settlement evidence | Finance | Group only records belonging to the same settlement reference and keep unresolved amounts visible. | | NetSuite posting | Controller | Approve accounting treatment and retain the source reference used to prevent duplicate posting. | ![Record ownership diagram: Amazon order and line, Financial event, Settlement evidence](https://www.stacksync.com/images/blog-diagrams/icp-amazon-seller-central-netsuite-sync-for-cpg-brands-orders-fees-and-settlement-evidence.webp) *Define the record owner and the rule before enabling updates.* ## Work through the process 1. 01 Choose the reconciliation window Define which order and finance reports are available under the connected account. A reporting window and an order-created date answer different questions; preserve both rather than forcing them into a single sales date. 2. 02 Keep gross and net distinct Store order revenue, refunds, fees, and deposits separately. Use an approved accounting map for each event category. An unexplained residual belongs in a review queue, not an invented balancing line. 3. 03 Link before posting Join financial evidence to order lines where a reliable reference exists. When the source provides only a settlement-level charge, retain that grain instead of distributing it across products by guesswork. 4. 04 Reopen late evidence carefully Allow a later refund or adjustment to attach to the original trail. Reconcile the updated period with finance before changing any accepted posting; preserve the previous reviewed result for audit. 5. 05 Tie out one Amazon settlement in NetSuite before scaling the import Pick one closed settlement period and import its orders, financial events and settlement report. In NetSuite, open each posted amount and check it still shows its originating marketplace and currency, not a converted total. Then compare the deposit with order revenue, refunds and fees for that period: the difference must appear as itemized lines, one per event category, with no plug entry. Include one fee that carries no order reference and confirm it sits at the settlement grain in a finance review queue. Stop the rollout if any amount lost its currency, if a balancing entry absorbed the gap, or if that fee was spread across orders. ![5-step operating sequence: Amazon Seller Central NetSuite sync for CPG settlements](https://www.stacksync.com/images/blog-diagrams-mermaid/icp-amazon-seller-central-netsuite-sync-for-cpg-brands-orders-fees-and-settlement-evidence.webp) *Follow the operating sequence; unresolved exceptions return to a responsible reviewer.* ## Handle the exceptions explicitly ### Fee has no order reference Keep it at the settlement or event grain and ask finance for the approved treatment. ### Refund arrives after close Link it to the original sale while routing the posting date and period decision to the controller. ### Report overlaps a previous import Deduplicate by source event identity and revision, not file name alone. ## What to verify before expanding - Every reconciled amount retains its marketplace and currency. - Settlement differences remain itemized rather than hidden in a balancing entry. - Overlapping report imports resolve the same marketplace financial event once, even when the filenames differ. - An unallocated fee remains visible at its actual event or settlement grain instead of being assigned to a guessed order. ## Connect this process to the rest of your operation [Explore Stacksync two-way sync](https://www.stacksync.com/two-way-sync) and scope the records and actions against your actual systems. [Book a demo](https://www.stacksync.com/book-a-demo) with a real amazon order and line example and the exception your team handles most often, for example fee has no order reference. - [HubSpot–NetSuite Sync for CPG Brands: Distributor Accounts, Contacts, and Payment Visibility](https://www.stacksync.com/blog/hubspot-netsuite-sync-for-cpg-brands-distributor-accounts-contacts-and-payment-visibility) - [Acumatica–Shopify Two-Way Sync for CPG Manufacturers Expanding Into Ecommerce](https://www.stacksync.com/blog/acumatica-shopify-two-way-sync-for-cpg-manufacturers-expanding-into-ecommerce) - [Dynamics 365 F&O–Salesforce Sync for CPG Sales and Finance Teams](https://www.stacksync.com/blog/dynamics-365-f-o-salesforce-sync-for-cpg-sales-and-finance-teams) - [Amazon Seller Central and NetSuite: Read-Only Sync and Reconciliation](https://www.stacksync.com/blog/two-way-sync-amazon-seller-central-netsuite) - [HubSpot and NetSuite Integration Guide: Connect in Minutes](https://www.stacksync.com/blog/hubspot-netsuite-integration) The shared architecture guide covers record matching, ownership, and recovery across systems. ## Technical references - [Stacksync two-way sync quick start](https://docs.stacksync.com/start-here/quick-start) - [Stacksync Amazon Seller Central access](https://docs.stacksync.com/two-way-sync/connectors/amazon-seller-central) - [Stacksync NetSuite supported objects](https://docs.stacksync.com/two-way-sync/connectors/netsuite) FAQ ## Frequently asked questions Does this sync send refunds back to Amazon? No. The connector reads Amazon data; nothing you post in NetSuite travels back to Seller Central. Refunds, order cancellations and listing edits happen inside Amazon by the people authorized there, and the resulting financial event then arrives through the next import as new evidence. Treat the NetSuite side as the accounting record of what Amazon already did, which is also why a controller approves each posting rather than a sync rule. How do you decide which period an Amazon order belongs to in NetSuite? Each imported record keeps two dates: when the order was created and when Amazon settled the money. The sync stores both and does not pick between them; the accounting map the controller approved for each event category decides which date drives the revenue side and which the cash side, so one order can touch two accounting periods without being an error. Before the controller posts, the settlement report for that period must be complete in Amazon; a partial report leaves the period open in the review queue. After import, what does finance work from to clear unexplained settlement amounts? Every imported financial event keeps its event type, settlement reference and an order link that may be empty. Finance filters the events where the order link is empty or where the period total does not match the deposit, and works that list down to zero before the controller approves the posting. The decision taken on each item, and who took it, stays on the row, so an auditor can retrace why a fee was treated as it was. About the author Ruben Burdin Founder & CEO Ruben Burdin is the Founder and CEO of Stacksync, the first real-time and two-way sync for enterprise data at scale. Ruben is a Y Combinator alumni with a strong background in software engineering and business. [All posts by Ruben Burdin](https://www.stacksync.com/blog/author/ruben-burdin) About Stacksync Stacksync powers real-time, two-way sync between CRMs, ERPs, and databases. Engineers sync data at scale and automate workflows, not dirty API plumbing. Stacksync ## Explore these integrations and topics - [integration NetSuite and Amazon Seller Central integration](https://www.stacksync.com/integrations/amazon-seller-central-and-netsuite) - [connector Amazon Seller Central integrations](https://www.stacksync.com/connectors/amazon-seller-central) - [connector NetSuite integrations](https://www.stacksync.com/connectors/netsuite) - [platform Two-way sync](https://www.stacksync.com/two-way-sync) - [Two-way sync guides Understand two-way sync, record matching, field ownership, and production readiness.](https://www.stacksync.com/blog#topic-two-way-sync) Keep reading ## Related articles [All articles](https://www.stacksync.com/blog) [Data engineering Amazon–NetSuite Sync for Beauty Brands: Match Variation Families to ERP Products 5 min read read](https://www.stacksync.com/blog/amazon-netsuite-sync-for-beauty-brands-match-variation-families-to-erp-products) [Data engineering Amazon–NetSuite Sync for Household Consumables: Reconcile Marketplace Order Quantities 5 min read read](https://www.stacksync.com/blog/amazon-netsuite-sync-for-household-consumables-reconcile-marketplace-order-quantities) [Data engineering Amazon–NetSuite Sync for Packaged Food Brands: Separate FBA and Merchant-Fulfilled Orders 5 min read read](https://www.stacksync.com/blog/amazon-netsuite-sync-for-packaged-food-brands-separate-fba-and-merchant-fulfilled-orders) ## You just read how it should work. See it run on your own data. [Book a demo](https://www.stacksync.com/book-a-demo) [Get started](https://app.stacksync.com/)