Bank Reconciliation & Payment Matching for Magento 2

主な機能

Bank statement import for CSV, MT940, and CAMT.053 (ISO 20022) formats, with a parser tailored to your bank's exact column/field layout

Auto-matching engine pairs incoming credits to open orders and invoices by payment reference, amount, and customer name with configurable tolerance

Partial-payment handling: split a single credit across multiple orders, or accumulate several credits toward one order balance

Marks orders paid on reconciliation by creating a Magento invoice through the official order/invoice service contracts (no direct SQL state hacks)

Unmatched-transaction queue: a dedicated admin UI Component grid for credits that need manual review, assignment, or write-off

Manual matching workspace with search, suggested candidates, and one-click confirm/reassign/split actions

Cron-based ingestion of scheduled statement files dropped to a configured SFTP/local path for hands-off reconciliation

Granular admin ACL resources (import, match, confirm, configure) so finance and fulfillment roles see only what they should

Full audit trail: every match, confirmation, and reversal is logged with user, timestamp, and source transaction reference

Idempotent imports — duplicate statement lines are detected by bank transaction ID/hash so re-uploading a file never double-counts

Reconciliation dashboard showing matched, partial, unmatched, and overpaid totals per import batch and date range

REST/GraphQL endpoints (optional) to push reconciliation status or pull unmatched transactions into your accounting stack

Multi-currency and multi-store-view aware, matching credits against orders in their order currency

Configurable post-match actions: email customer, add order comment, trigger shipment readiness, or notify a Slack/webhook

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

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

ご注文

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

構築とインストール

ECOSIRE がお客様の Magento 2 上で構築・設定・インストールします。

本番稼働 + サポート

約2〜4週間で稼働し、リリース後のサポート期間が付きます。

この製品について

Merchants who accept bank transfers, manual wire payments, and other offline methods face a slow, error-prone reconciliation gap: a customer places an order, the money lands in the bank days later, and someone has to manually match it before fulfillment. Magento 2 Open Source and Adobe Commerce ship "Bank Transfer Payment" and offline methods, but provide no facility to import a bank statement or reconcile incoming funds against orders.

This extension closes that gap. ECOSIRE designs and builds it as a proper Magento 2 module under app/code/Ecosire/BankReconciliation, wired through di.xml with service contracts, repositories, and an admin controller set guarded by granular ACL resources. It imports bank statements in CSV, MT940, and CAMT.053 (ISO 20022) formats, parses transactions into a reconciliation table, and runs a matching engine that pairs each credit against open orders and invoices by payment reference, customer name, and amount tolerance.

Matched payments can automatically register an invoice and move the order to a "paid" state via Magento's order/invoice service contracts; ambiguous or partial credits route to a review queue. Staff confirm, split, or reassign matches in a dedicated admin grid (UI Components), and a cron job ingests scheduled statement drops.

Because it is build-to-order, ECOSIRE tailors the parser to your bank's exact statement layout, your reference conventions, and your Magento version (2.4.x, Open Source or Adobe Commerce), then installs it on your environment and supports it. This is not an instant Marketplace download — it is a delivered, fitted engineering project with an honest lead time, source code you own, and ongoing support.

得られるもの

A complete custom Magento 2 module (Ecosire_BankReconciliation) under app/code, with composer.json for clean deployment

Bank statement parser fitted to your specific bank export(s) — CSV column mapping, MT940, and/or CAMT.053

Installation and configuration on your Magento 2 staging and production environments (or guided deploy if you prefer)

Admin ACL roles, system configuration, and cron schedule configured for your reconciliation workflow

Full source code ownership with no per-seat or recurring license lock-in, plus setup/upgrade documentation

Knowledge-transfer session for your finance/fulfillment team plus a post-launch support and bug-fix window

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

Finance / Accounts Receivable Lead

Reconciles daily bank credits against orders before releasing fulfillment. Needs auto-matching by reference and amount, a clear unmatched queue, and an audit trail that survives a year-end review — instead of cross-checking a bank CSV against Magento by hand.

Operations / Fulfillment Manager

Can't ship until payment is confirmed for bank-transfer and offline orders. Wants orders to flip to 'paid' automatically the moment a matching credit lands, so warehouse staff get a reliable signal and customers aren't kept waiting on manual checks.

B2B / Wholesale Store Owner

Runs a Magento 2 store where large-ticket buyers pay by wire or bank transfer, often in partial installments. Needs partial-payment accumulation, multi-currency matching, and confidence that the catalog and order data stay clean while finance reconciles.

Bank Reconciliation & Payment Matching for Magento 2 の比較方法

基準	エコシエール	カスタムビルド	競合他社	Magento 2 標準機能
Import CSV/MT940/CAMT.053 bank statements	付属	部分的なサポート	部分的なサポート	含まれていない
Auto-match credits to orders/invoices by reference and amount	付属	部分的なサポート	部分的なサポート	含まれていない
Partial-payment splitting and accumulation	付属	部分的なサポート	含まれていない	含まれていない
Parser fitted to your exact bank's statement layout	付属	付属	含まれていない	含まれていない
Marks orders paid via official invoice service contracts (no SQL hacks)	付属	部分的なサポート	部分的なサポート	含まれていない
Built, installed, and supported for you with a firm lead time	付属	部分的なサポート	含まれていない	含まれていない
Source code ownership with no recurring per-seat license	付属	付属	含まれていない	付属
Unmatched-transaction review queue with full audit trail	付属	部分的なサポート	部分的なサポート	含まれていない

Bank Reconciliation & Payment Matching for Magento 2 に関するよくある質問

How long until the extension is delivered and live on my store?

This is a build-to-order engineering project, not an instant download. After a short scoping call to confirm your bank's statement format, Magento version (2.4.x, Open Source or Adobe Commerce), and matching rules, typical delivery is about 2 to 4 weeks from sample-statement handoff. We share a firm timeline in writing before starting and keep you updated through staging review and production install.

Do I get ongoing support and updates after it's installed?

Yes. Delivery includes a post-launch support window for bug fixes and adjustments, plus knowledge transfer for your team. Because you own the source code, you're never locked into a recurring license. We also offer optional ongoing maintenance to keep the module compatible across Magento 2.4.x upgrades and to adapt the parser if your bank changes its statement layout.

Which bank statement formats can it import?

Out of the box we support CSV, MT940, and CAMT.053 (ISO 20022). Since it's built to order, we fit the parser to your specific bank's export — exact CSV columns, date and amount formats, and reference conventions — so matching works reliably against your real files rather than a generic template.

Will it work with Adobe Commerce as well as Magento Open Source?

Yes. The module is built on standard Magento 2 architecture — service contracts, di.xml, plugins/observers, UI Component grids, ACL, and cron — so it runs on both Magento Open Source and Adobe Commerce (on-prem or Cloud). We confirm your exact 2.4.x version during scoping and test against it before install.

How does it actually mark an order as paid — is that safe?

When a credit is matched and confirmed, the module creates a Magento invoice through the official order and invoice service contracts and registers payment, which moves the order to its paid/processing state cleanly. It does not write order states with raw SQL. Every action is logged with the user, timestamp, and source bank transaction, and imports are idempotent so re-uploading a statement never double-counts a payment.