+1 480 485 7373
Microsoft Teams
What moves between Amazon and Business Central
Orders in
Seller Central orders arrive as sales orders or invoices, with Amazon's order ID, ship-to address, item lines, shipping charges and promotions kept for later matching.
Stock out
For merchant-fulfilled listings, available quantity from your own warehouse is sent to Amazon so you stop selling what you cannot ship.
Shipments out
When your warehouse posts a shipment for an FBM order, the carrier and tracking number go back to Amazon to confirm the order.
Money in
Settlement reports come back with every sale, refund, fee, reimbursement and adjustment, ready to post against a clearing account.
FBA and FBM need different inventory thinking
With merchant fulfillment, Business Central is the inventory master. Your team picks, packs and ships, and the integration's job is to push availability to Amazon quickly enough to avoid overselling, especially if the same stock also feeds a web store.
With Fulfillment by Amazon, the stock physically sits in Amazon's network, and Amazon ships it. We set up a separate Business Central location for FBA inventory, record inbound shipments to Amazon as transfers from your warehouse, and post sales out of that location. Periodic FBA inventory reports then let you compare what Amazon says it holds with what Business Central expects, which is how lost, damaged and reimbursed units get noticed instead of written off by accident.
Mapping settlement lines to the general ledger
How we build an Amazon connection
- 1
Inventory the channels
Which marketplaces, which fulfillment method per SKU, and whether you sell as a third-party seller in Seller Central or as a vendor to Amazon through Vendor Central, which usually runs on EDI instead.
- 2
Choose the connector route
AppSource connectors exist from several vendors, integration platforms offer Amazon adapters, and a custom build can call the SP-API directly. We compare them against your SKU count, order volume and settlement needs.
- 3
Match SKUs and ASINs
Every Amazon seller SKU is mapped to a Business Central item or item reference, including bundles and multipacks, before a single order is imported.
- 4
Design the settlement posting
Each settlement line type gets a G/L account, a clearing account per marketplace absorbs the gross amounts, and the net disbursement clears against the bank.
- 5
Run in parallel, then switch
Orders and a full settlement cycle are processed side by side with your current method, and finance compares the results before the old process is retired.
When an automated Amazon link is not worth it yet
- ✓A handful of Amazon orders a week, where posting one summary journal per settlement is accurate and quick
- ✓A catalog still changing weekly, where SKU mapping would be redone before it pays off
- ✓No one in finance with time to own the settlement reconciliation, whatever tool is chosen
Amazon and Business Central questions sellers ask
Does Microsoft offer a standard Amazon connector for Business Central?
Not in the way it offers one for Shopify. Amazon integrations are provided by third-party AppSource apps, integration platforms or custom builds on Amazon's Selling Partner API. We help you compare them on how they handle FBA inventory and settlement detail, which is where they differ most.
Should every Amazon order become a separate sales invoice?
Not necessarily, and high-volume sellers often choose summarized postings. Individual invoices give full traceability per order but create a large volume of documents. Summarizing by day or settlement keeps the ledger lean while the connector keeps order-level detail for lookups.
How do we reconcile an Amazon disbursement to the bank?
Post the settlement's gross sales, fees and adjustments through a marketplace clearing account, then clear the net disbursement against the bank statement line. When the clearing account returns to zero, the settlement is fully explained. Anything left over is a specific line to investigate, not a mystery difference.
Do we need to charge sales tax on Amazon orders ourselves?
In US states with marketplace facilitator laws, Amazon generally collects and remits the sales tax on your marketplace sales. That tax should not land in your own sales tax liability in Business Central. Confirm your filing position with your tax advisor, because registration and reporting duties can still apply.
Can FBA stock appear in Business Central?
Yes, as its own location fed by transfers when you send stock in and reduced by Amazon sales. Regular comparison with Amazon's inventory reports catches differences early. That is also how you spot units Amazon owes you a reimbursement for.
Talk to us about your project.
Tell us what you run today and what has to change. A senior consultant replies with a written next step.