Marketplace Settlement & Fee Reconciliation for Business Central

Key Features

Imports settlement and payout reports from Amazon (Settlement V2 / FBA), Walmart Marketplace and eBay into a dedicated AL staging table for review before posting

Marketplace-specific parser codeunits that map each fee type (referral, FBA, fulfillment, ads, subscription, reserve, adjustment) to the correct G/L account

Auto-posts marketplace fees, advertising charges and refunds as standard General Journal / ledger entries via event subscribers — never bypassing BC posting controls

Net-payout matching that ties each marketplace deposit to its corresponding bank receipt so the settlement reconciles to the cent

Per-order and per-channel margin reporting by combining gross sales, allocated fees and COGS with Business Central dimensions

Discrepancy and missing-fee alerting that flags short payouts, unmatched deposits, duplicate settlement IDs and unexpected fee types

Configurable account and dimension mapping page so finance owns the rules without touching AL code

Job Queue entry for scheduled, unattended settlement import and posting on your chosen cadence

Idempotent imports keyed on marketplace settlement ID to prevent double-posting if a report is re-imported

Dedicated permission sets separating who can import, who can map accounts and who can post to the ledger

Refund and reserve handling that reverses the original revenue and fee lines cleanly with full audit trail

Optional REST/OData and Dataverse export so the same reconciled data feeds Power BI dashboards and Power Platform flows

Multi-currency aware — books marketplace amounts in transaction currency and applies your BC exchange-rate setup

Full posting audit log linking every ledger entry back to its source settlement line and original report file

Built to order, done for you

No DIY setup — a working app, built, installed and supported by ECOSIRE.

You order

Start with a one-time build price. We scope it with you at kickoff.

We build & install

ECOSIRE builds, configures and installs it on your Dynamics 365 Business Central.

Go live + support

You go live in about 2–4 weeks, with a post-launch support window.

About this Product

Multichannel sellers running Microsoft Dynamics 365 Business Central rarely struggle with sales orders — they struggle with the settlement. Each Amazon, Walmart or eBay payout bundles dozens of gross sales against FBA fees, referral fees, advertising charges, refunds, reserves and adjustments, then deposits a single net amount that never matches an invoice line. Finance teams end up keying it into one lump G/L entry, losing all fee visibility and true per-channel margin.

This is a build-to-order extension, not an instant AppSource download. ECOSIRE builds, installs and supports it as a per-tenant AL extension deployed directly to your Business Central environment (cloud SaaS or on-prem). We scope it to your marketplaces, your chart of accounts and your posting conventions during a short discovery call, then deliver a working, tested extension.

Under the hood it ships AL table and page extensions for staging settlement lines, codeunits for parsing each marketplace's report format, and event subscribers on posting routines so nothing bypasses your standard controls. Settlement files (or the marketplace REST/OData feeds where available) flow into a staging table, get mapped to the correct G/L accounts and dimensions, and post as proper General Journal / ledger entries. A scheduled Job Queue entry can run imports unattended, dedicated permission sets lock down who can post, and reconciliation pages match each net payout to its bank receipt so the deposit ties out to the penny.

The result: every marketplace fee lands in its own account, refunds reverse cleanly, per-order and per-channel margin becomes reportable, and missing-fee or short-payout discrepancies surface as alerts instead of year-end surprises. Optional Power BI / Dataverse export feeds the same data to your dashboards.

What you get

A per-tenant Business Central AL extension (.app) built for your environment and BC version, installed on your sandbox then production

Discovery and mapping workshop to capture your marketplaces, chart of accounts, dimensions and posting conventions

Configured account/fee mapping, permission sets and a Job Queue entry for scheduled imports

Source AL project (table/page extensions, parser codeunits, event subscribers) delivered to you so you are never locked in

Sandbox UAT with your real settlement files and sign-off before go-live

Admin and finance-user guide covering import, review, posting and reconciliation workflows

30 days of post-go-live support plus an optional ongoing support and update plan

Who this is for

Finance Controller / Accountant

Owns month-end close and needs every marketplace payout to reconcile against the bank and post fees to the right accounts instead of one lump-sum journal.

Multichannel E-commerce Operations Manager

Sells across Amazon, Walmart and eBay and wants true per-channel and per-order margin once fees and ads are netted out, not just topline revenue.

Business Central Administrator / IT Lead

Responsible for the BC tenant and wants a clean per-tenant extension with proper permission sets, Job Queue automation and no fragile spreadsheet macros.

How Marketplace Settlement & Fee Reconciliation for Business Central Compares

Criterion	ECOSIRE	Custom Build	Competitor
Built and installed for your tenant with your chart of accounts and fee mapping	Included	Partial support	Partial support
Parses Amazon / Walmart / eBay settlement report formats out of the box	Included	Not included	Partial support
Auto-posts fees, ads and refunds as proper ledger entries via event subscribers	Included	Partial support	Partial support
Net-payout to bank-receipt matching that ties out to the cent	Included	Partial support	Partial support
Per-order and per-channel margin reporting using BC dimensions	Included	Partial support	Partial support
Discrepancy and missing-fee alerting	Included	Not included	Partial support
Source AL project delivered — no vendor lock-in	Included	Included	Not included
Ongoing support adapting to marketplace report-format changes	Included	Partial support	Partial support

Frequently Asked Questions about Marketplace Settlement & Fee Reconciliation for Business Central

Is this a download from Microsoft AppSource?

No. This is a build-to-order extension. ECOSIRE builds it for your specific marketplaces and chart of accounts, then installs it as a per-tenant AL extension directly on your Business Central environment. There is no public AppSource listing to download — that is what lets us tailor the fee mapping and posting logic to your books.

What is the typical delivery lead time?

After a short discovery call to confirm your marketplaces, accounts and dimensions, a standard build is usually ready for sandbox UAT within about 2 to 4 weeks. Timing depends on how many marketplaces and how unusual your fee structure is; we confirm a firm date in writing before we start.

How are ongoing support and updates handled?

Every build includes 30 days of post-go-live support. After that you can take an optional support plan covering bug fixes, adapting to marketplace report-format changes (Amazon, Walmart and eBay periodically revise their settlement schemas), and compatibility updates when Microsoft ships major Business Central releases. Because you also receive the source AL project, you are never locked to us.

Which marketplaces and Business Central versions are supported?

Out of the box we target Amazon (Settlement V2 / FBA), Walmart Marketplace and eBay, and we can add others during scoping. It works on supported Business Central cloud (SaaS) and on-premises versions — we build the extension against your specific BC version so the table/page extensions and event subscribers match your platform.

Will it interfere with our existing posting setup or controls?

No. It uses standard AL event subscribers and posts through normal General Journal / ledger routines, so your existing number series, dimensions, approval and posting controls all still apply. Imports stage to a review table first, and dedicated permission sets separate importing, mapping and posting so nothing posts to the G/L without the right authorization.

Can the reconciled data feed Power BI or Power Platform?

Yes. The extension can expose the reconciled settlement and margin data via the Business Central REST/OData API and optionally sync to Dataverse, so your Power BI dashboards and Power Platform flows report on the same fee-allocated, payout-matched numbers.