A per-tenant Business Central extension that puts live, drillable financial and operational reporting inside Excel — built, installed, and supported by ECOSIRE on your own BC environment. One-time license from $499.00 USD for Dynamics 365 BC (build-to-order) — includes 12 months of updates and support.

A per-tenant Business Central extension that puts live, drillable financial and operational reporting inside Excel — built, installed, and supported by ECOSIRE on your own BC environment.
今すぐのお支払いはありません。これはチームへの見積もり依頼を送信します。価格と次のステップをメールでご案内します。
Your controllers and FP&A analysts already live in Excel. The problem is the data: today they export static CSVs, paste them into models, and re-key numbers that are stale the moment they're saved. Excel-Native Financial Reporting for Business Central closes that gap. It is a custom AL extension that ECOSIRE builds for your tenant and installs directly on your Business Central environment, so your existing Excel workbooks pull live figures straight from BC over the OData V4 / REST API — no exports, no manual refresh, no copy-paste.
Live Excel report builder backed by dedicated AL API pages and OData V4 queries — workbooks read directly from Business Central with no export step
Cell-level drill-down from any figure to the underlying G/L entries, document numbers, and dimension values
Reusable financial statement templates (P&L, balance sheet, cash flow) mapped to your BC account schedules and account categories
Scheduled report refresh and email distribution driven by the Business Central Job Queue
Multi-company consolidation that rolls up across your BC companies with currency translation rules you define
Dimension-aware filtering (department, project, cost center) using your real BC global and shateable dimensions
We expose your General Ledger entries, dimensions, budgets, and operational tables through purpose-built API pages and queries (page and query objects authored in AL), then wire them into Excel via a managed data connection and a Power Query layer. Analysts build P&L, balance sheet, and cash-flow statements once against named account schedules, and refresh them on demand or on a schedule. Every cell is drillable: double-click a figure to see the underlying G/L entries, document numbers, and dimension values that compose it.
Because it ships as a per-tenant extension (not a one-size AppSource app), the data model, account groupings, dimension filters, and consolidation rules match your chart of accounts — not a generic template. Multi-company consolidation rolls up across your BC companies with currency handling you define. Scheduled refresh and distribution run via the BC Job Queue, emailing finished workbooks to stakeholders.
This is a build-to-order engagement. ECOSIRE scopes, develops, deploys the extension to your sandbox then production, assigns the correct permission sets, and supports it afterward. It is honest, owned, and maintainable — not a black box.
Owns the monthly close and statutory statements. Wants P&L and balance sheet that tie to BC to the penny, refresh on demand, and drill to source without raising an IT ticket.
Builds budgets, forecasts, and variance models in Excel. Needs live actuals from Business Central by dimension and company so the model stops going stale and the re-keying stops.
Needs consolidated, multi-company numbers and scheduled distribution to the board — delivered in Excel they trust, with auditable drill-back to BC transactions.
ecosire.com でライセンスを購入し、アカウント ダッシュボードから Excel-Native Financial Reporting for Business Central モジュールの ZIP をダウンロードします。
ZIP をサーバー上の Odoo カスタム アドオン フォルダーに抽出します (または、[アプリ] > [Odoo.sh / runbot のファイルからインストール] を介してアップロードします)。
開発者モードをアクティブにし、アプリを開き、「アプリリストの更新」をクリックして、「Excel-Native Financial Reporting for Business Central」を検索し、「インストール」を押します。
新しいメニューを開き、ECOSIRE ライセンス キーを貼り付け、外部認証情報 (Shopify、Amazon、Stripe など) を接続して保存します。
組み込みの接続テストを実行し、最初の 10 レコードを同期し、定期的な cron をスケジュールします。何か問題が発生した場合はサポートにお問い合わせください。
| 基準 | エコシエール | カスタムビルド | 競合他社 | オドゥー ネイティブ |
|---|---|---|---|---|
| Live, no-export refresh from Business Central into Excel | ||||
| Cell-level drill-down to G/L entries and dimensions | ||||
| Tailored to your exact chart of accounts and consolidation rules | ||||
| Multi-company consolidation with your currency rules | ||||
| Scheduled refresh and email distribution via Job Queue | ||||
| Built, installed, and supported for you (no in-house AL team needed) | ||||
| Upgrade-safe across BC monthly releases with patching included | ||||
| Full source code and ownership handed over |
No. This is a build-to-order engagement. ECOSIRE develops a custom per-tenant extension tailored to your chart of accounts and dimensions, then installs it on your Business Central environment. There is no instant AppSource download — and that is deliberate, because the data model and consolidation rules are matched to your tenant rather than a generic template.
After a short scoping call, a standard build is usually delivered in roughly 2 to 4 weeks: requirements and account-schedule mapping, AL development of the API pages and queries, deployment to your BC sandbox for UAT, then production install and team training. More companies, complex consolidations, or extra operational reports extend the timeline; we confirm exact dates in writing before starting.
Every build includes a warranty support window, and we offer optional ongoing support plans. Business Central ships monthly platform and app updates, so we write upgrade-safe AL and monitor against major releases. If an update affects the extension, we patch and redeploy it under your support plan. You also receive the full source code and runbook, so you are never locked in.
No. The extension is read-oriented for reporting — it exposes data through API pages and OData queries and does not alter your transactions. Heavy refreshes are scheduled via the Job Queue during off-peak windows, and permission sets ensure users only read data their BC roles permit.
Yes. The same AL API pages and queries can be surfaced through the Power Platform via Dataverse or direct OData connections, so the datasets we build for Excel can also drive Power BI dashboards or Power Apps. We scope that as an optional add-on if you need it.
A per-tenant Business Central extension that puts live, drillable financial and operational reporting inside Excel — built, installed, and supported by ECOSIRE on your own BC environment.