Why this B2B distributor automated Amazon FBA reconciliation with Business Central Bob’s industry insights #6

A fast-growing B2B distributor recently found itself in a familiar situation. Amazon sales were taking off, but behind the scenes, finance and inventory control were becoming harder to manage every month.

They already used Business Central and had launched on Amazon FBA about six months earlier. The commercial results were encouraging, but the operational side quickly became messy. Reconciliation was time-consuming, stock figures were always slightly out of date, and Amazon’s reporting made it difficult to understand where the money was actually going.

What pushed them to look for a better solution?

At first, they handled Amazon manually. Once a week, all sales were consolidated into a single invoice and booked against one generic customer. It worked, but only just.

As order volumes increased, this approach started to break down. Inventory levels were constantly lagging behind reality, and finance had limited visibility during the month. The team realised that if Amazon kept growing at this pace, the manual work would soon become unsustainable.

Why Amazon FBA made reconciliation so difficult

Amazon FBA introduces a timing problem.

Orders are placed, shipped, settled, refunded, and charged fees, all on different schedules. When sales move quickly, trying to align stock, invoices, fees, and payouts manually becomes a guessing game. By the time reconciliation happened, the numbers were already outdated.

This created uncertainty around stock valuation and made month-end closing more stressful than it needed to be.

How automation changed the picture

Instead of consolidating everything weekly, the approach shifted to importing Amazon orders individually, as soon as Amazon marked them as shipped.

Each order is automatically created as a sales invoice in Business Central. Inventory is deducted immediately from a dedicated Amazon location, without anyone touching the system. The result is stock figures that are accurate within hours instead of days.

Amazon fees are handled separately. When settlement reports become available, those fees are posted directly to the general ledger and linked back to the original invoices. When the Amazon payout arrives, everything matches, without retroactive corrections.

What about refunds and damaged goods?

Returns were still relatively small in volume, but they already affected payouts.

Rather than overcomplicating things, the focus was on getting the financial side right first. Refunds are included so that payments reconcile correctly, while physical return handling can be automated later if volumes increase. It’s a phased approach that grows with the business.

Why a native connector made sense

The key requirement wasn’t flexibility, it was trust.

A standardized, Business Central–native Amazon connector removed the uncertainty. No fragile scripts, no weekly firefighting, and no guessing whether numbers were correct. Orders, inventory, fees, and payments all land where they belong, when they belong there.

For a B2B distributor scaling quickly on Amazon, that reliability turned Amazon from an operational headache into a controlled, predictable sales channel.

Selling on Amazon and still double-checking your numbers every week?

If growth is exposing manual workarounds in Business Central, it may be time to automate the connection, not the spreadsheets.

👉 Schedule a demo or introduction call to see how Amazon FBA integration can simplify reconciliation and inventory control.