メインコンテンツにスキップ
商品詳細は英語で表示されます。翻訳は近日公開予定です。
Payment Reconciliation & Settlement Matching for Business Central — A per-tenant Business Central extension that imports PSP  — 1/1イメージプレビュー

A per-tenant Business Central extension that imports PSP and acquirer settlement files,

auto-matches payouts to invoices and orders, splits gross versus fees versus refunds to the correct G/L accounts, and surfaces an exception worklist for everything that does not tie out. Built, installed and supported by ECOSIRE.

Payment Reconciliation & Settlement Matching for Business Centralとは?

A per-tenant Business Central extension that imports PSP and acquirer settlement files, auto-matches payouts to invoices and orders, splits gross versus fees versus refunds to the correct G/L accounts, and surfaces an exception worklist for everything that does not tie out. Built, installed and supported by ECOSIRE. Built to order by ECOSIRE for Dynamics 365 BC (build-to-order) — indicative price from $999.00 USD; request a quote for a scoped proposal.

主な機能

Auto-import of settlement and payout files from PSPs and acquirers (CSV, JSON, or direct PSP-API pull), parsed through a configurable field-mapping table so new file layouts need no code change
Per-PSP Settlement Provider setup table that stores parser mappings, default G/L accounts, fee/refund contra accounts and currency per provider
Matching engine that ties payout lines to Sales Invoices, Sales Orders and posted Cust. Ledger Entries using order reference, payment-intent ID, amount and configurable date/amount tolerances
Automatic split of net deposits into gross sales, processor fees and refunds, each posted to its designated G/L account via a General Journal
Exception Worklist page (AL list page) for unmatched, partially matched and disputed items, with manual match, reassign and write-off actions
Multi-PSP and multi-currency handling tied to Business Central currency and exchange-rate tables, with per-provider rounding tolerance
Scheduled imports and matching runs via the Business Central Job Queue, with run logs and a per-batch reconciliation summary
Event-subscriber posting hooks (no modification of Microsoft base objects) so the extension stays upgrade-safe across BC updates
Dedicated permission sets separating import, matching, posting and setup so finance roles get least-privilege access
Drill-down from any matched line back to the source invoice, ledger entry and the originating settlement file row for full audit traceability
Reconciliation status dashboard cue group showing matched / unmatched / exception counts and value per import batch
Optional OData/REST API page exposure of reconciliation results for Power BI or Power Platform reporting

受注生産、すべておまかせ

自分での設定は不要 — ECOSIRE が構築・インストール・サポートする実働アプリです。

  1. 1

    ご注文

    一回限りの構築料金から始めます。キックオフで一緒に範囲を決めます。

  2. 2

    構築とインストール

    ECOSIRE がお客様の Dynamics 365 Business Central 上で構築・設定・インストールします。

  3. 3

    本番稼働 + サポート

    約1週間(営業日ベース)で稼働し、本番稼働後2週間のサポートが付きます。納品したコードの不具合は無償で修正します。

この製品について

If your finance team manually reconciles card and PSP settlements against Business Central sales, this extension removes the spreadsheet. ECOSIRE builds it to order as a per-tenant AL extension installed directly on your Business Central environment (cloud SaaS or on-prem) — not a generic AppSource download.

Settlement and payout files (Stripe, Adyen, PayPal, Checkout.com, Worldpay, or your acquirer's bank-deposit report) are imported through a configurable parser. We model each PSP as a record in a new Settlement Provider setup table, with field mappings stored so CSV/JSON/PSP-API column layouts are decoded without code changes per upload. Imports run on demand or on a schedule via the Job Queue.

The matching engine reconciles each payout line to its originating Sales Invoice, Sales Order, or posted Cust. Ledger Entry using order reference, payment intent ID, amount and date tolerances. When a deposit nets gross sales against processor fees and refunds, the engine splits the lines and posts fees to your designated expense account and refunds to the correct contra account through a General Journal, so the bank deposit reconciles cleanly to the penny.

Anything that does not auto-match lands on an Exception Worklist page — a filterable list page (built as an AL page object) where finance can match manually, reassign, or write off. Multi-PSP and multi-currency are first-class: each provider keeps its own currency and exchange handling tied to BC's currency tables.

Delivered with dedicated permission sets, event-subscriber-based posting hooks (no core object modification), and a short admin guide. Because it ships as an extension, it survives Microsoft's monthly and major BC updates. ECOSIRE scopes your exact PSPs and G/L mapping before build, then installs and supports it.

得られるもの

  • A per-tenant Business Central AL extension (.app) built to your exact PSPs and chart-of-accounts mapping, installed on your environment by ECOSIRE
  • Settlement Provider setup configured for each of your live PSPs/acquirers with field mappings, default and contra G/L accounts, and currency
  • Job Queue entries configured for scheduled import and matching, plus the Exception Worklist and reconciliation dashboard pages
  • Dedicated permission sets assigned to your finance and admin roles
  • Source AL project (table/page extensions, event subscribers, parser codeunits) delivered to your team or kept under ECOSIRE maintenance, per your choice
  • Admin and finance-user guide covering import, exception handling, posting and adding a new PSP, plus a post-install handover session

これは誰のためのものですか

Finance / Accounts Receivable Manager

Owns month-end and needs every PSP deposit to tie out to invoices and the G/L. Lives in the exception worklist, approves write-offs, and wants fees and refunds posted correctly without rebuilding spreadsheets each cycle.

Business Central Administrator / IT Lead

Responsible for a clean, upgrade-safe tenant. Cares that this is an event-subscriber-based extension (no base-object changes), scoped by permission sets, scheduled through the Job Queue, and that it survives Microsoft's monthly BC releases.

Controller / Finance Director

Wants accurate, auditable revenue and processor-cost figures. Values the drill-down from G/L back to the settlement file row and the Power BI/OData feed for monitoring reconciliation health across multiple PSPs and currencies.

Payment Reconciliation & Settlement Matching for Business Central の比較方法

基準エコシエールカスタムビルド競合他社Dynamics 365 Business Central 標準機能
Auto-import of PSP/acquirer settlement files (CSV/JSON/API)付属部分的なサポート部分的なサポート含まれていない
Auto-match payouts to invoices, orders and ledger entries with tolerances付属部分的なサポート部分的なサポート含まれていない
Automatic gross / fee / refund split posted to the correct G/L accounts付属部分的なサポート部分的なサポート含まれていない
Exception worklist for unmatched and disputed items付属含まれていない部分的なサポート含まれていない
Configured to your exact PSPs and chart of accounts at delivery付属付属含まれていない含まれていない
Upgrade-safe (event subscribers, no base-object changes)付属部分的なサポート付属付属
Installed and supported on your tenant by the builder付属部分的なサポート含まれていない含まれていない
Multi-PSP and multi-currency handling out of the box付属部分的なサポート部分的なサポート含まれていない

Payment Reconciliation & Settlement Matching for Business Central に関するよくある質問

Is this a Microsoft AppSource app I can install instantly?

No. This is a build-to-order extension. ECOSIRE scopes your specific PSPs, settlement file formats and G/L mapping, builds the AL extension to match, and installs it as a per-tenant extension on your Business Central environment. There is no instant AppSource download — it is configured to your tenant and supported by us.

How long does delivery take after purchase?

Typical lead time is one working week from the scoping call, depending on how many PSPs you reconcile, the complexity of your settlement file formats and your chart-of-accounts mapping. A single-PSP build is on the shorter end; multi-PSP, multi-currency scopes take longer. We confirm a firm date once requirements are agreed.

How do ongoing support and updates work?

Because it ships as an extension using event subscribers rather than modifying Microsoft base objects, it is designed to survive BC monthly and major updates. ECOSIRE provides post-install support, fixes any issue caused by a Microsoft platform change, and can add new PSPs or adjust G/L mappings on request. Ongoing support terms are agreed at purchase.

Which PSPs and acquirers can you support?

Any provider whose settlement or payout data you can export as CSV/JSON or pull via API — for example Stripe, Adyen, PayPal, Checkout.com, Worldpay, or a bank/acquirer deposit report. Each provider is configured as its own Settlement Provider record with its own parser mapping, so adding a new one later does not require rebuilding the extension.

Will it modify our existing Business Central objects or data?

No core objects are altered. The extension adds its own tables, pages, parser codeunits and event subscribers, and posts through standard General Journals. Posting is gated behind dedicated permission sets, and every matched line drills back to its source invoice, ledger entry and settlement file row for audit.

Can the reconciliation results feed Power BI or the Power Platform?

Yes. We can expose the reconciliation results as an OData/REST API page so Power BI, Power Automate or a Dataverse integration can read matched, unmatched and exception data for dashboards and alerts. This is included as an optional deliverable when you need cross-system reporting.

見積もりを依頼

Payment Reconciliation & Settlement Matching for Business Central

A per-tenant Business Central extension that imports PSP and acquirer settlement files, auto-matches payouts to invoices and orders, splits gross versus fees versus refunds to the correct G/L accounts, and surfaces an exception worklist for everything that does not tie out. Built, installed and supported by ECOSIRE.

  • Auto-import of settlement and payout files from PSPs and acquirers (CSV, JSON, or direct PSP-API pull), parsed through a configurable field-mapping table so new file layouts need no code change
  • Per-PSP Settlement Provider setup table that stores parser mappings, default G/L accounts, fee/refund contra accounts and currency per provider
  • Matching engine that ties payout lines to Sales Invoices, Sales Orders and posted Cust. Ledger Entries using order reference, payment-intent ID, amount and configurable date/amount tolerances
  • Automatic split of net deposits into gross sales, processor fees and refunds, each posted to its designated G/L account via a General Journal

見積もりを依頼

Payment Reconciliation & Settlement Matching for Business Central のご要望をお知らせください。価格、ライセンスの選択肢、貴社に合わせたご提案を、通常1営業日以内にお送りします。

今すぐのお支払いはありません。これはチームへの見積もり依頼を送信します。価格と次のステップをメールでご案内します。