跳至主要内容
产品详细信息以英文显示。翻译即将推出。
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

    上线 + 支持

    约一个工作周内上线,并包含两周上线支持。我们交付的代码中的缺陷免费修复。

关于此产品

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 的需求,我们将发送价格、许可选项和量身定制的方案,通常在一个工作日内。

现在无需付款。此操作会向我们的团队发送报价请求——我们会通过邮件跟进价格和后续步骤。