Marketplace Settlement & Fee Reconciliation for Business Centralとは？
A per-tenant Business Central AL extension that imports marketplace settlement reports from Amazon, Walmart and eBay, auto-posts fees, ads and refunds as ledger entries, matches net payouts to bank receipts, and flags discrepancies — built and supported by ECOSIRE for your tenant. Built to order by ECOSIRE for Dynamics 365 BC (build-to-order) — indicative price from $499.00 USD; request a quote for a scoped proposal.
商品詳細は英語で表示されます。翻訳は近日公開予定です。
イメージプレビューA per-tenant Business Central AL extension that imports marketplace settlement reports from Amazon,
Walmart and eBay, auto-posts fees, ads and refunds as ledger entries, matches net payouts to bank receipts, and flags discrepancies — built and supported by
ECOSIRE for your tenant.
主な機能
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
受注生産、すべておまかせ
自分での設定は不要 — ECOSIRE が構築・インストール・サポートする実働アプリです。
- 1
ご注文
一回限りの構築料金から始めます。キックオフで一緒に範囲を決めます。
- 2
構築とインストール
ECOSIRE がお客様の Dynamics 365 Business Central 上で構築・設定・インストールします。
- 3
本番稼働 + サポート
約2〜4週間で稼働し、リリース後のサポート期間が付きます。
この製品について
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.
得られるもの
- 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
これは誰のためのものですか
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.
Marketplace Settlement & Fee Reconciliation for Business Central の比較方法
| 基準 | エコシエール | カスタムビルド | 競合他社 | Dynamics 365 Business Central 標準機能 |
|---|---|---|---|---|
| Built and installed for your tenant with your chart of accounts and fee mapping | 付属 | 部分的なサポート | 部分的なサポート | 含まれていない |
| Parses Amazon / Walmart / eBay settlement report formats out of the box | 付属 | 含まれていない | 部分的なサポート | 含まれていない |
| Auto-posts fees, ads and refunds as proper ledger entries via event subscribers | 付属 | 部分的なサポート | 部分的なサポート | 含まれていない |
| Net-payout to bank-receipt matching that ties out to the cent | 付属 | 部分的なサポート | 部分的なサポート | 含まれていない |
| Per-order and per-channel margin reporting using BC dimensions | 付属 | 部分的なサポート | 部分的なサポート | 含まれていない |
| Discrepancy and missing-fee alerting | 付属 | 含まれていない | 部分的なサポート | 含まれていない |
| Source AL project delivered — no vendor lock-in | 付属 | 付属 | 含まれていない | 含まれていない |
| Ongoing support adapting to marketplace report-format changes | 付属 | 部分的なサポート | 部分的なサポート | 含まれていない |
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.
関連モジュール
見積もりを依頼
Marketplace Settlement & Fee Reconciliation for Business Central
A per-tenant Business Central AL extension that imports marketplace settlement reports from Amazon, Walmart and eBay, auto-posts fees, ads and refunds as ledger entries, matches net payouts to bank receipts, and flags discrepancies — built and supported by ECOSIRE for your tenant.
- 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