Dynamics 365 Asset leasing data migration, D365 lease accounting module imports and lease abstraction

No. Asset leasing in Dynamics 365 Finance is a calculation and posting module, and a good one. It classifies each lease as finance, operating, short-term or low value, builds the payment, liability amortization, depreciation and expense schedules, and generates the journal entries from initial recognition through termination. Partners describe it as compliant with US GAAP (ASC 842) and IFRS 16.

What it does not do is open a lease. The Microsoft Learn module on creating a lease is a list of fields a person fills in on the Lease summary: lease description, fair value of the asset, implicit rate, incremental borrowing rate, compounding interval, asset useful life, deferred rent carryover, transfer of ownership, unique asset, annuity type, initial direct cost, lease incentives, lease prepayments, dismantling costs and residual value guarantee. Then you select Create schedules. Every one of those inputs comes from the lease file, your treasury team or your old ASC 840 balances.

That is the normal split for an ERP lease module. We cover the same workstream for SAP RE-FX lease abstraction and NetSuite lease accounting.

The table below follows the Lease summary fields in the order Microsoft documents them, plus the payment schedule. The middle column is where the answer actually lives.

Two inputs on that list are judgments, not facts. Microsoft calls them management decisions, such as how likely a renewal option is to be exercised. The abstract cannot make that call for you, but it should put the option terms, notice window and rent in front of the person who does. The rate inputs are covered on our incremental borrowing rate page and in the note on the risk-free rate election.

Dismantling costs. Microsoft is explicit that this field applies only under IFRS 16, and that entering an amount while working under US GAAP causes the right-of-use asset to be calculated incorrectly. A restoration clause still belongs in the abstract, because it drives an asset retirement obligation under separate guidance. It just does not belong in that field on a US GAAP book.

Deferred rent carryover. This takes the deferred rent balance for operating leases that were previously modified and folds it into the straight-line cost. It is not in the lease at all. It comes from your old schedules, which is why a lease abstract and a balance roll-forward should travel together into the migration file.

There is a timing trap as well. Once the payment schedule is confirmed, Microsoft notes the lease is no longer available for editing, and later changes go through the lease adjustment process. A wrong commencement date or a missed free-rent month found after confirmation is an adjustment entry, not a typo fix. Our rent abatement extraction page shows how free rent is captured month by month so it lands correctly in the schedule the first time.

1. Configure. Asset leasing parameters, lease books per accounting standard, lease groups, posting profiles, and the thresholds the classification tests use.
2. Fill the migration template. Implementation partners supply an Excel template for lease data. Crowe, for one, lists a data migration template and a review of migration options in its packaged Asset leasing implementations on the Microsoft marketplace.
3. Import and create schedules. Leases load, then schedules are generated per book: payment, liability amortization, depreciation and expense, with the initial right-of-use asset and liability.
4. Review and confirm. Payment amounts and variable payments can still be changed before you select Confirm schedule. After that the lease is locked.
5. Associate fixed assets where the right-of-use asset should be depreciated through the Fixed assets module.

Step two is the long one, and it is the only one that needs somebody to read every lease. For the wider project plan around it, see our ASC 842 implementation guide.

Microsoft lists Dynamics 365 Finance at $210 per user per month and Finance Premium at $300 per user per month, both paid yearly. Asset leasing is a module of Finance, and the Finance pricing page does not list it as a separate charge. The partner implementation is quoted on top, and it usually covers configuration, testing and training, with the lease data supplied by you.

Reading the back catalog is therefore its own budget line: internal hours, an outsourced abstraction project, or software at a published rate of $49 a month for 15 leases, $149 for 75, $399 for 250 or $800 for 500. Other vendors are compared in our lease abstraction software pricing roundup.

One scoping note. Asset leasing ships with Dynamics 365 Finance, not with Business Central. If your company runs Business Central, lease accounting comes from an app, and we price those apps in Business Central lease accounting apps and ASC 842 pricing.

• Free rent folded into the first payment. Abated months need to appear as their own zero or reduced lines, or the straight-line expense is wrong from month one.
• Gross rent keyed as the lease payment. Operating expense pass-throughs and taxes are not fixed lease payments unless you elected to combine components. Split them in the abstract so the decision is visible.
• Amendments typed over the original. A modification should go through the lease adjustment process with its own effective date, not a silent overwrite of the original record.
• Commencement taken from the signature date. Under ASC 842 commencement is when the lessor makes the asset available. See our note on the lease commencement date.
• Options loaded without notice dates. The renewal judgment needs the window, not just the existence of an option. The critical date extraction page lists what to capture.

Upload the executed lease and every amendment, rider and side letter. The AI reads the set and returns a structured abstract with each field tied to its page and clause. A reviewer checks the flagged fields, approves, and exports Excel or CSV. Your Dynamics 365 consultant maps those columns to the migration template, adds the treasury rates and the deferred rent balances, and loads.

Because the abstract does not depend on the target system, the reading can run while the partner is still scoping the project, and it stays useful if the platform decision changes. If you are still choosing tools, our best lease abstraction and administration software comparison and the plans on our pricing page are the next two stops.