+1 480 485 7373
Microsoft Teams
What moves between Amazon and Business Central
Orders in
Seller Central orders arrive as sales orders or invoices. Each keeps Amazon's order ID, ship-to address, item lines, shipping charges and promotions for later matching.
Stock out
For merchant-fulfilled listings, the integration sends the available quantity in your own warehouse to Amazon. That way 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. That confirms the order.
Money in
Settlement reports list every sale, refund, fee, reimbursement and adjustment. Each line is then ready to post to 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. The job of a Business Central Amazon integration is then to push stock levels to Amazon fast enough to avoid overselling. That matters most if the same stock also feeds a web store.
With Fulfillment by Amazon, the stock sits in Amazon's network, and Amazon ships it. We set up a separate Business Central location for FBA inventory. We record inbound shipments to Amazon as transfers from your warehouse, and post sales out of that location. Amazon's FBA stock reports then let you check its count against Business Central. That is how you notice lost, damaged and reimbursed units instead of writing them off by accident.
Mapping settlement lines to the general ledger
How we build an Amazon connection
- 1
Inventory the channels
List which marketplaces you sell on and which fulfillment method each SKU uses. Also note whether you sell as a third-party seller in Seller Central. The other route is Vendor Central, where you sell to Amazon as a vendor. That usually runs on EDI instead.
- 2
Choose the connector route
Several vendors offer AppSource connectors, and integration platforms offer Amazon adapters. A custom build can also call the SP-API directly. We compare these routes against your SKU count, order volume and settlement needs.
- 3
Match SKUs and ASINs
We map every Amazon seller SKU to a Business Central item or item reference before a single order comes in. That includes bundles and multipacks.
- 4
Design the settlement posting
Each settlement line type gets a G/L account. A clearing account per marketplace takes the gross amounts, and the net disbursement clears against the bank.
- 5
Run in parallel, then switch
We run orders and a full settlement cycle side by side with your current method. Finance compares the results before the Business Central Amazon integration replaces the old process.
When an automated Amazon link is not worth it yet
- ✓A handful of Amazon orders a week, where one summary journal per settlement is quick and accurate
- ✓A catalog that still changes each week, so you would redo the SKU map before it pays off
- ✓No one in finance with time to own the settlement reconciliation, whatever tool you choose
What do sellers ask about Amazon and Business Central?
Does Microsoft offer a standard Amazon connector for Business Central?
Not in the way it offers one for Shopify. Instead, you use a third-party AppSource app, an integration platform or a custom build on Amazon's Selling Partner API. We help you compare them on FBA inventory and settlement detail, where they differ most.
Should every Amazon order become a separate sales invoice?
Not always. Sellers with many orders often post a summary instead. One invoice per order lets you trace each sale, but it creates many documents. A summary by day or settlement keeps the ledger lean. The connector still keeps each order's 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, you have accounted for the whole settlement. 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. Check your filing position with your tax advisor, since you may still need to register and report.
Can FBA stock appear in Business Central?
Yes, as its own location. Transfers feed it when you send stock in, and Amazon sales reduce it. 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.