Deep Dive into Asset Leasing Posting Types
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.
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.
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.
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.
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.
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:
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.
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:
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.
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.
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:
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
-
Deep Dive into Asset Leasing Posting TypesI 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?
-
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.?
-
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
-
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
-
Thanks Brian, I think I would have never found the Short-Term Lease Liability Reclass option if not for this article :)
*This post is locked for comments