イメージプレビュー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.
Excel-Native Financial Reporting for Business Centralとは？
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. 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.
主な機能
受注生産、すべておまかせ
自分での設定は不要 — ECOSIRE が構築・インストール・サポートする実働アプリです。
- 1
ご注文
一回限りの構築料金から始めます。キックオフで一緒に範囲を決めます。
- 2
構築とインストール
ECOSIRE がお客様の Dynamics 365 Business Central 上で構築・設定・インストールします。
- 3
本番稼働 + サポート
約1週間（営業日ベース）で稼働し、本番稼働後2週間のサポートが付きます。納品したコードの不具合は無償で修正します。
この製品について
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.
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.
得られるもの
- A per-tenant Business Central extension (.app) containing the AL API pages, queries, and any table/page extensions, deployed to your sandbox and then production
- A set of live Excel workbook templates (P&L, balance sheet, cash flow, plus your priority operational reports) pre-connected to your BC data
- Configured Job Queue entries for scheduled refresh and email distribution
- Permission sets aligned to your finance roles, assigned to the relevant users
- Source code, build pipeline notes, and a deployment runbook handed over for full ownership
- A walkthrough/training session for your controller and FP&A team, plus a short admin guide and warranty support window
これは誰のためのものですか
Controller
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.
FP&A Analyst
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.
Finance Director / CFO
Needs consolidated, multi-company numbers and scheduled distribution to the board — delivered in Excel they trust, with auditable drill-back to BC transactions.
Excel-Native Financial Reporting for Business Central の比較方法
| 基準 | エコシエール | カスタムビルド | 競合他社 | Dynamics 365 Business Central 標準機能 |
|---|---|---|---|---|
| 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 | 付属 | 付属 | 含まれていない | 部分的なサポート |
Excel-Native Financial Reporting for Business Central に関するよくある質問
Is this an instant download from Microsoft AppSource?
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.
What is the typical delivery lead time?
After a short scoping call, a standard build is usually delivered in roughly one working week: 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.
How does ongoing support and updates work after delivery?
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.
Will it interfere with our Business Central data or performance?
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.
Can the same data feed Power BI or Power Apps, not just Excel?
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.
関連モジュール
Energy & Utility Operations
A build-to-order Business Central extension that turns meter readings into billed, collectable revenue — connection registry, cycle billing runs, slab tariffs, service complaints and disconnection workflows. ECOSIRE scopes, builds, installs and supports it for your tenant.
Enterprise Asset Management / CMMS
An embedded EAM/CMMS extension for Dynamics 365 Business Central — asset register with hierarchy, preventive and condition-based maintenance schedules, work orders with labor and parts costing, and spare-parts inventory tied to BC items. Built to order, installed as a per-tenant AL extension, and supported by ECOSIRE.
Field Service Mobile & Scheduling for Business Central
Real-time technician scheduling, offline mobile job execution and on-site invoicing — built as a per-tenant AL extension on your Business Central service management, installed and supported by ECOSIRE.
Fleet Management for Business Central
A build-to-order AL extension that adds a vehicle register, preventive maintenance scheduling, fuel and expense logging, driver assignment, and total-cost-of-ownership reporting to your Business Central tenant — built, installed and supported by ECOSIRE.
Excel-Native Financial Reporting for Business Central
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.
- 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