D365 Finance and Supply Chain Fit Gap Analysis Worksheet
A fit gap worksheet is where a D365 project decides what the standard product covers and what the business must change or build. This version records the response type for each requirement, adds effort and day rate, and totals the cost so you can discuss scope with numbers.
| Req ID | Process area | Requirement | Fit result | Response | Priority | Effort (days) | Day rate | Estimated cost | |
|---|---|---|---|---|---|---|---|---|---|
$3,600 | |||||||||
$9,600 | |||||||||
$2,400 | |||||||||
$21,000 | |||||||||
$15,600 | |||||||||
$6,000 |
Effort figures are examples. Add risk and test effort separately, and review every Gap line for a process change or standard feature alternative before approving customization.
Get a second opinion on your gaps
Send your fit gap list and we will point out gaps that standard features or reporting could cover.
Optional. The tool and every export work without this. No spam.
How to use the worksheet
List each business requirement on its own row with an ID and process area. Mark the fit result, then choose the response: standard, configuration, extension, ISV, integration, report, process change or out of scope. Add effort in days and your blended rate and the cost column is computed for you. Review with process owners in workshops and update priority so Must items are not trimmed during budget negotiation.
- One requirement per row, written as an outcome.
- Split partial fits into the fit part and the gap part.
- Export to Excel for sign-off and baseline versioning.
Method behind a good fit gap
Fit gap analysis is only as strong as the requirement quality. Requirements should be testable and linked to a process step. Evaluate each against the standard business process library and the actual configuration in a demo environment, not only against slides. For each gap, ask whether the business can adopt the standard process, whether personalization or a report solves it, and only then whether an extension or ISV is justified.
Reading the totals
The total effort and cost give an order of magnitude for the customization backlog. Look at the share of cost in the Must category and at the average per requirement. A high concentration in a single process area suggests either an unusual business model or a design that should be challenged. Use the response column to compare how much of the scope relies on extensions versus configuration.
Common mistakes
Teams often estimate only development effort and ignore design, test, data, training and upgrade impact. Another trap is recording gaps without owners.
- No link between a requirement and a test case.
- Customizing to match a legacy screen layout rather than the outcome.
- Ignoring the One Version update cost of each extension.
- Treating ISV licenses as free of ongoing cost.
Frequently Asked Questions
What is a fit gap analysis in a D365 project?
It compares business requirements to what the standard D365 Finance and Supply Chain product can do and records whether each requirement is a fit, a partial fit or a gap, plus the planned response and its effort.
How do I estimate effort for a gap?
Estimate design, build, unit test, integration test, documentation and deployment separately, then add a contingency. Developers often estimate only build time, which understates the real cost by a wide margin.
Should every gap be built?
No. Challenge each gap with a process change, standard configuration, personalization, report or Power Platform alternative first. Every extension adds testing and upgrade effort on each One Version update, so build only what the business case supports.
Can I use this for other ERPs?
The structure works for any ERP. The process areas and response types in the dropdowns are set for D365 Finance and Supply Chain, but you can retype them to suit another product.
If you want an independent view on which gaps could be solved with standard features, reports or AI assisted reporting, Netray can review your worksheet.
Related Tools
D365 F&O Implementation Health Assessment
Ten-question self-assessment of customization load, update discipline, security, data quality and reporting for a D365 F&O environment.
Microsoft DynamicsD365 F&O Chain of Command Extension Generator
Produces X++ skeletons for chain of command class extensions, table data event handlers and a form extension handler.
Microsoft DynamicsD365 F&O Data Migration Load Sequence Reference
Dependency-ordered list of the master, setup and transactional data areas to load when migrating to D365 F&O.
Microsoft DynamicsD365 F&O Go-Live Cutover Readiness Checklist
Checklist of data, environment, integration, user and support items to confirm before a D365 Finance and Supply Chain go-live.
More Microsoft Dynamics tools
See all- D365 F&O OData URL Builder
- D365 Data Management Import Worksheet Template
- D365 Batch Job Checklist
- D365 Security Role Design Worksheet
- D365 One Version Update Test Checklist
- D365 Finance and Supply Chain Functional Design Document Template
- D365 Finance and Supply Chain Fit-Gap Analysis Worksheet
- D365 Finance and Supply Chain Data Migration Mapping Worksheet
- D365 Finance and Supply Chain Cutover Plan Template
Keep exploring
Free tools
- D365 Finance and Supply Chain Fit-Gap Analysis WorksheetAn editable fit-gap register that totals gap hours and cost by fit type, so you can see the true size of customization before you commit.
- D365 Fit-Gap Analysis Document TemplateA fill-in fit-gap document for D365 projects covering scope, requirement rows, fit classification, gap approach, effort and sign-off.
- D365 Finance and Supply Chain Functional Design Document TemplateA fill-in functional design document for a D365 F&O gap, covering requirement, process, data, security and test approach, with sign-off lines.
ERP fixes and how-tos
- Dynamics 365 Supply Chain Management API: OData, Custom Services and Data PackagesD365 Supply Chain / F&O APIs explained: OData data entities, custom services, the data management package API, Entra ID authentication and when to use each.
- Dynamics 365 Supply Chain Wave Planning and Inventory JournalsHow wave planning and inventory journals work in Dynamics 365 Supply Chain Management: wave templates, wave steps, work templates, journal names and posting.
- Dynamics 365 Supply Chain Warehouse Only Mode: What It Is and Its LimitsWhat warehouse management only mode is in Dynamics 365 Supply Chain Management, how to enable it, how orders arrive as shipment orders, and its limits.
AI on your ERP
- AI for Dynamics 365 Finance and Supply Chain beyond CopilotAI for D365 Finance and Supply Chain beyond Microsoft Copilot: private LLM grounded on data entities and OData, on-prem-capable via Local Business Data.
- AI for Dynamics 365 Production Control: Orders, Planning and SchedulingAI for Dynamics 365 F&SCM production control: production orders, BOM and route data, master planning and scheduling, explained in plain English on private servers.
Integrations
- How to connect Microsoft Teams to Dynamics 365 Finance and Supply ChainConnect Dynamics 365 Finance and Supply Chain to Microsoft Teams: business events, adaptive cards, Power Automate approvals and Entra ID auth, with limits.
- How to use ChatGPT with Dynamics 365 Finance and Supply ChainUsing ChatGPT with Dynamics 365 Finance and Supply Chain: custom GPT actions over OData, exports versus live access, data controls and when to go private.
Software
- Microsoft Dynamics 365 Finance and Supply ChainDynamics 365 Finance and Supply Chain Management explained for manufacturers: modules, data entities, OData, deployment, strengths, limits and alternatives.
- Dynamics 365 Field ServiceDynamics 365 Field Service handles work orders, resource scheduling and mobile technicians on Microsoft Dataverse. Modules, integrations and alternatives.