Skip to main content

Notifications

Deep Dive into Asset Leasing Posting Types

Community Member Profile Picture Community Member Microsoft Employee

You just enabled the Asset Leasing module and are excited to begin using one of the latest modules Dynamics 365 F&O has to offer. You navigate to the Asset Leasing parameters setup and are shocked to see 16 different posting types awaiting your configuration. You think to yourself, “Do I really need all these accounts?”

This blog post will set out to answer that question and to give examples of when these accounts will be used.

pastedimage1623277199531v1.png

 

Let’s start with the most commonly used posting types:

  

Lease Asset

The account associated with the right-of-use asset. This account will be debited when initially recognizing a lease under the new standards IFRS 16 and ASC 842. This account may either be debited or credited for a lease modification depending on if the modification increases or decreases the lease liability.

This account will not be used for leases associated to a fixed asset. Rather than debiting the lease asset, the initial recognition journal entry will debit that fixed asset directly as an acquisition entry.

7455.pastedimage1623277289656v1.png

 

This account would also not be used for deferred rent treatment leases include those leases classified as operating under ASC 840 and IAS 17, or short-term or low value under IFRS 16 and ASC 842.

5751.pastedimage1623277343749v2.png

 

Example journal entries:

 

Transaction Type

Dr/Cr

Posting Type

Dr

Cr

Initial recognition

Dr

Lease asset

100,000

 

Initial recognition

Cr

Lease liability

 

100,000

 

 

Lease Liability

As the name indicates, the account associated with the lease liability arising from the discounting of payments under the new standards IFRS 16 and ASC 842. This account will be credited upon initial recognition under the new standards. This account will be debited for lease payments and credited for interest accruals.

Like the lease asset account, if leases are classified as deferred rent treatment, there would be no need for the lease liability account as these leases are “off balance sheet”.

 

Example journal entries:

Transaction Type

Dr/Cr

Posting Type

Dr

Cr

Initial recognition

Dr

Lease asset

100,000

 

Initial recognition

Cr

Lease liability

 

100,000

 

Transaction Type

Dr/Cr

Posting Type

Dr

Cr

Interest expense

Dr

Interest expense

10,000

 

Interest expense

Cr

Lease liability

 

10,000

 

Transaction Type

Dr/Cr

Posting Type

Dr

Cr

Lease payment

Dr

Lease liability

2,000

 

Lease payment

Cr

Lease payment/Vendor

 

2,000


 

 

Interest Expense

Journal entries produced from the liability amortization schedule record the interest expense accrued on the lease liability. The account mapped to this posting type represents the interest expense and will be debited and the lease liability will be credited.

Leases classified as deferred rent treatment would not use the interest expense posting type as there is no lease liability to amortize.

 

Example journal entries:

 

Transaction Type

Dr/Cr

Posting Type

Dr

Cr

Interest expense

Dr

Interest expense

10,000

 

Interest expense

Cr

Lease liability

 

10,000

 

 

Depreciation Expense

The account associated with the expense related to the depreciation of the right-of-use asset under IFRS 16, ASC 842, and finance leases under IAS 17 and ASC 840. This account will be debited when a right-of-use asset is depreciated each month.

When a lease is tied to a fixed asset the depreciation is conducted through the Fixed Assets module so there would be no need for this account for such leases.

Example journal entries:

Transaction Type

Dr/Cr

Posting Type

Dr

Cr

Right-of-use depreciation expense

Dr

Depreciation expense

4,000

 

Right-of-use depreciation expense

Cr

Accumulated depreciation

 

4,000

 

  

Accumulated Depreciation

The account associated with the contra-asset account of the right-of-use asset. This account will be credited when depreciation expense is posted.

Again, like the Lease Asset and Depreciation Expense, this account is needed whenever leases are not tied to fixed assets.

 

Example journal entries:

 

Transaction Type

Dr/Cr

Posting Type

Dr

Cr

Right-of-use depreciation expense

Dr

Depreciation expense

4,000

 

Right-of-use depreciation expense

Cr

Accumulated depreciation

 

4,000

  

 

Lease Payment

The Asset Leasing module gives users some flexibility when determining how they want their lease payments to be posted. When configuring the lease book, the ‘Pay to vendor’ parameter will determine whether lease payments generated from the lease payment schedule will be offset directly to the vendor or to this account.

 

6648.pastedimage1623277377202v3.png

 

If the ‘Pay to Vendor’ parameter is enabled on the lease book setup, this account would not be used. In such case, when generating entries from the payment schedule, the module will create invoices directly to the vendor listed on the lease details.

6457.pastedimage1623277402720v4.png

 

Example Journal Entry:

 

Transaction Type

Dr/Cr

Posting Type

Dr

Cr

Lease payment

Dr

Lease liability

2,000

 

Lease payment

Cr

Lease payment

 

2,000

 

Lease Expense

When a lease is classified as a deferred rent treatment lease, lease payments are expensed to the Lease Expense posting type. This account will be debited when an invoice is posted against a deferred rent treatment lease.

This account would only be used for leases classified as deferred rent treatment as non-deferred rent treatment lease payments would decrease the lease liability.

 

Example Journal Entry:

Lease Payment (Deferred Rent Treatment Lease):

Transaction Type

Dr/Cr

Posting Type

Dr

Cr

Lease payment

Dr

Lease expense

2,000

 

Lease payment

Cr

Deferred rent liability

 

   500

Lease payment

Cr

Lease payment

 

1,500

 

Deferred Rent Asset (Liability)

The account associated with the deferred rent asset or liability resulting from a deferred rent treatment lease. This account will be debited when an invoice is posted against a deferred rent treatment lease if the lease payment amount is greater than that period’s straight-line rent expense. This account will be credited if the lease payment is less than that period’s straight-line rent expense.

This account is also used in initial recognition when there is a value in the deferred rent carryover field. When transitioning a lease from the previous lease accounting standards, the amount of deferred or accrued rent is included in the recognition of the beginning right-of-use asset balance. Carried over deferred rent assets, represented as a positive value, will be credited and will increase the right-of-use asset upon initial recognition, while any deferred rent liability, represented as negative values in this field, will decrease the right-of-use asset:

6266.pastedimage1623277454446v5.png

 

 

Example Journal Entries:

Transaction Type

Dr/Cr

Posting Type

Dr

Cr

Lease payment

Dr

Lease expense

2,000

 

Lease payment

Dr

Deferred rent asset

   500

 

Lease payment

Cr

Lease payment

 

2,500

 

Transaction Type

Dr/Cr

Posting Type

Dr

Cr

Initial recognition

Dr

Lease asset

105,000

 

Initial recognition

Cr

Lease liability

 

100,000

Initial recognition

Cr

Deferred rent liability

 

    5,000

 

 

Lease Increase/Decrease

In accordance with the lease accounting standards, there are several items that are included in the calculation of the right-of-use asset upon initial recognition. These items include initial direct costs, lease prepayments, and estimated dismantling costs which increase the right-of-use asset in addition to lease incentives which decrease the right-of-use asset.

2248.pastedimage1623277503304v6.png

This account serves as a catchall for those additional right-of-use asset considerations upon the initial recognition or lease adjustment to offset the lease asset.

 

Example Journal Entries:

Assume a lease with 5,000 of initial direct costs at the initial recognition:

Transaction Type

Dr/Cr

Posting Type

Dr

Cr

Initial recognition

Dr

Lease asset

105,000

 

Initial recognition

Cr

Lease liability

 

100,000

Initial recognition

Cr

Lease increase/decrease

 

    5,000

 

Assume a lease with 1,000 of lease incentives arising from a lease adjustment:

Transaction Type

Dr/Cr

Posting Type

Dr

Cr

Lease adjustment increase

Dr

Lease asset

49,000

 

Lease adjustment increase

Dr

Lease increase/decrease

  1,000

 

Lease adjustment increase

Cr

Lease liability

 

50,000

 

 

Short-Term Lease Liability

For disclosure purposes, companies may need to separate their liabilities into current and non-current portions. The Asset Leasing module records the entire liability amount to the account mapped to the Lease Liability posting type. To reclassify the short-term or current portion of the lease liability, the user can run the short-term lease liability reclass through the batch job:

4762.pastedimage1623276073716v8.png

This entry will reclassify the current portion of the lease liability, shown on the liability amortization schedule, from the lease liability account to the short-term lease liability accounts on the last day of the period. This opposite entry is booked on the following day to reverse the reclassification.

 

Example journal entry:

Transaction Type

Date

Dr/Cr

Posting Type

Dr

Cr

Short-term lease liability reclass

1/31/2021

Dr

Lease liability

2,500

 

Short-term lease liability reclass

1/31/2021

Cr

Short-term lease liability

 

2,500

Short-term lease liability reclass

2/1/2021

Dr

Short-term lease liability

2,500

 

Short-term lease liability reclass

2/1/2021

Cr

Lease liability

 

2,500

 

 

Rounding Difference

When a lease is denominated in a different currency from the accounting or reporting currencies defined on the ledger for that legal entity, it is common that rounding differences may occur upon translation. This penny difference is captured in the Rounding Difference posting type.

This account is not necessary when all leases are transacted in the same currency as the accounting and reporting currencies.

 

Example journal entry:

 

Assume a lease denominated in JPY in a legal entity where the accounting currency is GBP and reporting currency is INR. The exchange rates are GBP > JPY is .01 and JPY > INR is 1.293:

Transaction Type

Dr/Cr

Posting Type

Dr

Cr

Amount in accounting currency

Amount in reporting currency

Initial recognition

Dr

Lease asset

220,571.63

 

2,205.69

285,271.91

Initial recognition

Dr

Lease increase/decrease

    4,082.24

 

     40.82

    5,279.68

Initial recognition

Cr

Lease liability

 

224,653.87

(2,246.54)

(290,551.59)

Initial recognition

Dr

Rounding difference

0.00

 

        0.03

           0.00

 

 

The following posting types are less frequently used for most companies. In most cases, you can get away with not having these accounts mapped on Day 1. They are used in less frequent scenarios, typically around intricate lease adjustments. It’s easy to see how comprehensive the module can be and how the module can cover the rarest of scenarios.

 

Impairment Expense

When the lease is not associated to a fixed asset, the user can impair the right-of-use asset via the impairment function on the book details.

8664.pastedimage1623276092267v10.png

 

In a lease impairment journal entry, the impairment expense posting type is debited and the lease asset directly credited. This account would not be used for leases associated to a fixed asset as impairments are conducted in the fixed assets module.

 

Example journal entry:

Transaction Type

Dr/Cr

Posting Type

Dr

Cr

Lease asset impairment

Dr

Impairment expense

10,000

 

Lease asset impairment

Cr

Lease asset

 

10,000

 

Retained Earnings

Under US GAAP ASC 842, when a lease modification changes the classification of a lease from finance to operating, the right-of-use asset is written up to match the lease liability. The retained earnings posting type is used to offset the lease asset writeup.

For leases accounted under IFRS 16, this posting type is not used.

 

Example journal entry:

Assume a finance lease accounted for under ASC 842 with a liability carrying balance of $500,000 and lease asset balance of $253,000. The lease is adjusted, and the liability increases by $750,000. After the adjustment, the lease is classified as an operating lease. The first two lines of the entry will reverse the balances out of the finance liability and lease asset. The next two lines will place those same amounts in the operating liability and asset accounts as the lease is now an operating lease going forward. The next two lines represent the $750,000 increase to the lease liability and lease asset. Finally, the final two lines represent the write up of the lease asset to match the lease liability amount (1,250,000 – 1,003,000 = 247,000):

 

Transaction Type

Dr/Cr

Posting Type

Dr

Cr

Lease adjustment decrease

Dr

Finance lease liability

500,000

 

Lease adjustment decrease

Cr

Finance lease asset

 

253,000

Lease adjustment decrease

Dr

Operating lease asset

253,000

 

Lease adjustment decrease

Cr

Operating lease liability

 

500,000

Lease adjustment decrease

Dr

Operating lease asset

750,000

 

Lease adjustment decrease

Cr

Operating lease liability

 

750,000

Lease adjustment decrease

Dr

Operating lease asset

247,000

 

Lease adjustment decrease

Cr

Retained earnings

 

247,000

 

 

Gain/Loss on Lease Modification

When a lease is adjusted and the lease liability is decreased by an amount larger than the carrying value of the lease asset, the difference is booked to the Gain/loss on lease modification posting type. This is applicable for both IFRS and ASC nondeferred rent treatment leases.

 

Example journal entry:

Assume a lease with a carrying balance of the lease asset of $50,000 and liability carrying value of $75,000. The lease was adjusted and the new sum of present value of payments is only $10,000. The adjustment entry would decrease the lease liability by $65,000 (75,000 – 10,000 = 65,000). However, the lease asset’s carrying value is only $50,000 and cannot be decreased past its carrying value. Therefore, the lease asset is decreased to 0 and the remainder of $15,000 (65,000 – 50,000) is posted to the Gain/loss on lease modification account:

Transaction Type

Dr/Cr

Posting Type

Dr

Cr

Lease adjustment decrease

Dr

Lease liability

65,000

 

Lease adjustment decrease

Cr

Lease asset

 

50,000

Lease adjustment decrease

Cr

Gain/loss on lease modification

 

15,000

 

 

Variable Payment

The payment schedule for every lease has a column specifically for variable payments. This column is editable for all unposted months even after the payment schedule is confirmed. These payments do not impact the lease liability and are expensed to the Lease payment posting type. The total payment amount between the payment amount and variable payment is credited to either the Lease Payment or vendor accounts.

6215.pastedimage1623277598793v7.png

 

Example journal entry:

 

Transaction Type

Dr/Cr

Posting Type

Dr

Cr

Lease payment

Dr

Lease liability

1,000

 

Lease payment

Dr

Variable payment

   200

 

Lease payment

Cr

Lease payment

 

1,200

 

 

Expense Offset

Finally, the Expense offset account configured in the Asset Leasing parameters is simply a placeholder posting type. The actual account to be used to offset against any executory costs is selected directly on the executory costs payment schedule lines:

0184.pastedimage1623277625792v8.png

 

Final Thoughts

 

While there are many posting types to configure the Asset Leasing module, depending on your lease portfolio and configuration of the module, not all accounts are necessary. It’s important to understand when each account is used to understand the proper accounts to map or even if new accounts should be created. It’s easy to appreciate the complexities and full coverage this module provides for all kinds of lease accounting needs.

 

By Brian Markgraf CPA, Crowe, a Microsoft Dynamics 365 Gold Partner https://www.crowe.com/services/consulting/microsoft-dynamics-365

Learn more about Crowe’s Microsoft Asset Leasing Quick Start Implementation here.

Comments

*This post is locked for comments

  • Community member Profile Picture Community member 5
    Posted at
    Deep Dive into Asset Leasing Posting Types
    I was curious - what if the fixed asset was already created in the FA module (because perhaps we didn't know we were going to get a lease/loan for it)? 
    When I do the initial recognition journal, I am recognizing the acquisition cost again, and thus it's duplicating my fixed asset.
     
    What do you suggest - or does D365 have a work around?
  • Paris Yuen Profile Picture Paris Yuen
    Posted at
    Hi Brian, I have some questions when link Fixed Asset record to lease contract record. 1. The initial recogonition for fixed asset and asset leasing module are different, In asset leasing module, the initial recognition journal entry will debit the lease asset, while in fixed asset module will debit that fixed asset directly as an acquisition entry. So when and why will link Fixed Asset record to lease contract record.? 2. When link Fixed Asset record to lease contract record, the fixed asset acquisition price is the same as the sum of the Present Value of all lease contractual payments. Since actual acquisition price is always larger or much larger than total lease payment, how to understand fixed asset acquisition price is the same as the sum of the Present Value of all lease contractual payments.?
  • Community Member Profile Picture Community Member Microsoft Employee
    Posted at
    Hi Viktor, Thank you for reading my post and I appreciate the feedback! To answer your first question, the reclassification journal entry will post on the period end date from the liability amortization schedule. Based on your scenario, I imagine that your lease has a commencement date of the 9th of the month. I would recommend entering leases on the 1st day of the month they commence. Therefore, the schedules will align to the calendar month and the reclass entry will post at the end of the month and reverse itself on the beginning of the next month. I would also recommend enabling the new leasing conventions feature to have the system automatically set the commencement date to the first of the month. You are still able to set the payment schedule payable at the 9th of the month even with the commencement date as the 1st. To answer your second question, the standard reclass is the only option because the system will book all liability transactions to the long term lease liability posting type other than the reclass entry. In your example, you are assuming the payment amount equals the short term liability component - this may not always be the case if the lease is paid monthly. The short term represents what is due in a year and may not always align with the payment amount. Therefore, the system will post to the long term liability account and the reclass entry should be run at the end of the month to reclassify the liability at the balance sheet date. If it is not reversed on the 1st day of the following month, the short term liability amount would accrue an entire year's worth of liability each month. Let me know if this helps your scenario! Thanks! Brian
  • Viktor Kralevski Profile Picture Viktor Kralevski 115
    Posted at
    I have a few additional questions related to the Short-Term Lease Liability Reclass batch: 1. I can't find a way to set the dates for Reclassification - for example, my payments are due on 9th in the month, and the Reclassification job posts the amounts with 9th of the month. Is it possible to have the payment set for middle of the month while the reclassification is with the last day of month? 2. Is it possible to avoid the second part of the reclassification - instead of booking the amount to the short term account, and then getting it back the following day to the standard account, and when paying the instalment to decrease the short term account directly. Example below: instead this: Short-term lease liability reclass 1/31/2021 Dr Lease liability 2,500 Cr Short-term lease liability 2,500 2/1/2021 Dr Short-term lease liability 2,500 Cr Lease liability to get this: 1/31/2021 Dr Lease liability 2,500 Cr Short-term lease liability 2,500 2/9/2021 (payment) Dr Short-term lease liability 2,500 Cr Vendor/Bank account 2,500 Thanks, Viktor
  • Viktor Kralevski Profile Picture Viktor Kralevski 115
    Posted at
    Thanks Brian, I think I would have never found the Short-Term Lease Liability Reclass option if not for this article :)