BeyondERP.Newsletter
Menu

Report page · Asset leasing

Lease balances forecast

A report that forecasts lease liability and right-of-use asset balances over a period, taken from the liability amortization and asset depreciation schedules.

Business process
Analyze asset leases
Menu item
AssetLeaseForecastReport
Setup steps
1 on this page
Show what matters for
PAGE GUIDEWhat the page does and how to use it8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA report that forecasts lease liability and right-of-use asset balances over a period, taken from the liability amortization and asset depreciation schedules.
What you do hereUse this page to set the filters and print projected lease liability, right-of-use asset balances and projected expenses for your leases.
ExampleFor example, BEAT's budget owner runs it for next year to plan the lease interest, depreciation and the split between short-term and long-term liability.
Lease balances forecast page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

Business processAnalyze assets › Analyze asset leases
Menu pathAsset leasing › Inquiries and reports › Lease reports › Lease balances forecast
Set up firstConfirmation batch Microsoft Learn
Used next byFive years undiscounted payment forecast Microsoft Learn
Related pagesLease movements Microsoft Learn
End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

When to run it

When to run itWhen you budget or forecast lease expenses and balances, or prepare the split of the liability into short-term and long-term.
How oftenOn demand, typically during budgeting and at year end.
What the output showsProjected liability and right-of-use asset balances per lease, taken from the liability amortization and asset depreciation schedules. Because it reads the schedules, not posted transactions, a difference from Lease movements usually means schedule lines that are not yet posted.

Source: Microsoft Learn

Setup steps on this page

Run the Lease balances forecast report

Produce the Lease balances forecast figures for the period you report.

Steps from Microsoft

  1. Go to Asset leasing > Inquiries and reports > Lease reports > Lease balances forecast.
  2. Enter a From date and To date in the future period you want to project, for example the next fiscal year for a budget.
  3. Filter on the leases or lease groups to include.
  4. Read the liability side (Payments, Interest, Ending balance, Short-term liability, Long term liability) and the asset side (Depreciation expense, Ending balance, Equity adjustment) for each lease.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
PaymentsThe total lease payments that fall within the report date range.Microsoft Learn
InterestThe total lease interest expense within the report date range.Microsoft Learn
Ending balanceThe lease liability balance as of the To date.Microsoft Learn
Short-term liabilityThe short-term liability amount from the amortization schedule as of the To date.Microsoft Learn
Long term liabilityThe long-term liability amount from the amortization schedule as of the To date.Microsoft Learn
Depreciation expenseThe total depreciation expense within the report date range.Microsoft Learn
Equity adjustmentThe beginning balance minus the beginning net book value.Microsoft Learn

Common errors and fixes

MessageWhat to do
The report shows lower figures than expectedJournals for the period aren't posted yet, or a schedule isn't confirmed. Post the period's journals and run it again. Microsoft Learn
Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Run the Lease balances forecast reportRun it for the coming year per posting layer to plan interest, depreciation and the short-term liability.It comes from the liability amortization and asset depreciation schedules, so it shows the future balances that confirmed leases will produce.Which leases go into the forecast?Leaving unconfirmed leases out of the plan without noticing: only their schedules can feed the forecast once created.Test: Forecast follows the schedules

Feature management and licence

Feature to turn onAsset leasing (Must be on)Multi-company purpose (Optional)
Licence or add-inAsset leasing must be turned on in Feature management (feature Asset leasing). Microsoft Learn describes three Asset leasing roles: Maintain lease (add, edit and post leases), View lease (view leases and schedules and run reports) and Lease clerk (create new leases only). View lease users run it, as do Maintain lease users.

Microsoft Learn

Solution architect

5Design impact

Shared or per companyRuns for the legal entities you select. With the Multi-company purpose feature (version 10.0.44) the legal entities are picked from an organization hierarchy. Microsoft Learn
Can it be undoneNothing to undo: The report only reads lease schedules; it changes nothing. Microsoft Learn
If you change it laterThe forecast reads the lease schedules and changes nothing; it changes when leases are added, adjusted, revalued or terminated. Microsoft Learn
Technical architect

6Technical

Menu itemAssetLeaseForecastReport Checked in Dynamics 365
FormSysOperationTemplateForm Checked in Dynamics 365
Roles to set it up and use itTo use itLease accountant AssetLeaseLeaseMaintainAccountant LedgerAccountantLease manager AssetLeaseLeaseViewAccounting manager LedgerAccountingManagerGive people one of these roles. On this system, 4 roles can run this page.Checked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=AssetLeaseForecastReport
Data migrationLoad order: The Lease balances forecast report has no data entity in Data management, so it can't be loaded from a file or a configuration template. A report stores no data; it reads the lease books and schedules, so migrate the leases instead.Microsoft Learn
Everyone

8Sources

KEEP EXPLORING

More in Asset leasing.

Open the other pages and setup steps in this module, or go back to the Atlas Hub to search every page.