Lease Accounting Software Computation Process

Generate cash flows

Based on the start date, effective date, end date, frequency of the lease, payable at beginning or end etc, cash flows for the entire period is generated as follows:

Change the following data – only start from 1-4-2019 onwards

Cashflow

Variable cashflows

If you upload lease with Cash flow as “YES” then click the export cash flow. If the Cash Flow field is not ‘YES’ then the ‘Upload Cash Flow’ and ‘Export Cash Flow’ buttons will not be active. The Status of the record for which Cash flows should be updated will be shown as ‘New’.

Mylease

A csv file “allcashflow.csv” will be downloaded by the system with the pre fixed lease id and lease payment schedule.

Update the variable cash flows in the same file

Open the All cash flow and update the amount column alone and save the file in the same format as shown below. Do not change any field or content of this file. Only the cash flow amount should be updated before uploading the same.

Samplecashflow

Now select the Upload cash flow icon and upload the “AllCashFlow.CSV’ file

Uploadcash

Status is now changed to ‘Processed New’ as shown below:

Cashupload

Pandemic cash flows

The lessor may provide some relief considering the pandemic situation. If so you can upload the revised cash flows taking into account the concessions so that the system will provide the necessary accounting treatment of the same.

Step 1

Get the  revised cash flows where COVID concessions are available. The input format is the same as the cash flow input format. Based on this, the present value of the cash flows is computed. Then get the difference between the present value and the value of the liability just before the COVID concessions are granted.

Step 2

Add another column for COVID Concession which would show the number as derived in Step 1.

Pass an entry for that amount as Debit Liability and Credit Covid  Concession (P&L) Account

Pandemic

Export Pandemic cash flows

Export Pandemic cash flow for the concerned lease for which pandemic concession is given by the lessor. This will download a file ‘All Pandemic Cash Flows.csv’ showing the existing cash flows for the lease selected.

Exportpandemic

Update Pandemic concessions

Update the file with the concessions that are provided by the lessor. Please note that only the ‘Concession Amount’ field should be updated and no other field should be tampered with.

Pandemicdata

Upload ‘All Pandemic cash flows.csv’ file

Uploadpandemic 1

View Pandemic Cash flows

Pandemiccashflow

Computation for Right-of-use

Compute the Right-of-use – Asset

Important points to be noted:

1. If ‘Avail exemption’ = Yes then the record is ignored.

2. The schedule of rental payments is prepared based on the start date and the end date of the lease. The payment dates is based on Monthly, Quarterly, Half Yearly or Yearly and also based on when it is payable – at END or at BEGINNING.

4. Rent escalation is taken care of. The escalation percentage and the tenure are considered in the schedule.

5. Discount factor is calculated based on the incremental borrowing rate given in the input file. Calculate the discount factor based on the formula

6. Dismantling costs should be treated like lease payments.

Asset – Right to Use

Prepare the schedule of dates first.

1. Right to use balance = Take the amount from ‘Right to Use Valuation’ tab.

2. Amortization also taken from that tab.

Rightuse

Liability

Prepare the schedule of dates first.

1. Starting point is the Right to Use value taken the amount from ‘Right to Use Valuation’ tab.

2. Find the Finance cost – Use the incremental borrowing rate from input file in the formula

Lease Liability Opening balance * EXP (Incremental Borrowing rate / total number of days in the year * (Current entry date – previous entry date) ) – Lease Liability Opening balance.

3. All other columns are self-explanatory.

Liability

Journal entries

Journal Entries

Balance Sheet

1. All the journal entries are aggregated lease ID wise. Then each account is posted with all the journal entries as shown below:

Balance Sheet

Consolidated Balance Sheet

Balance Sheet Consolidated 1

Lease Id wise summary for any given date should be prepared like shown above.

Main Account

Main Accounts

Lease accounting, interest-free deposit lease period extended after year 1

Lease accounting, interest-free deposit lease period extended after year 1 Details for lease accounting for lease extension Let us assume the following details for lease accounting: Lease start date: 1-Apr-2019 Lease end date: 31-Mar-2024 Lease payments: Rs. 2,75,000 Lease Deposit: Rs. 3,00,000 Payment frequency: Annual – payable at the end Incremental borrowing rate: 9% Lease extension on 1-4-2020: Lease …
Read More

Lease accounting, lease period extended after year 1 – Journal entries

Lease accounting, lease period extended after year 1 – Journal entries Details for lease accounting for lease extension Let us assume the following details for lease accounting: Lease start date: 1-Apr-2019 Lease end date: 31-Mar-2024 Lease payments: Rs. 2,75,000 Payment frequency: Annual – payable at the end Incremental borrowing rate: 9% Lease extension on 1-4-2020: Lease Modification effective date: …
Read More

Lease accounting Journal Entries for Modification

Lease accounting Journal entries for Modification Details for lease accounting with modification Let us assume the following details for lease accounting: Lease start date: 1-Apr-2019 Lease end date: 31-Mar-2024 Lease payments: Rs. 2,75,000 Lease Deposit: Rs. 3,00,000 Payment frequency: Annual – payable at the end Incremental borrowing rate: 9% Lease modification: Lease Modification effective date: 1-Apr-2020 Lease payments: Rs. …
Read More

Lease accounting with an interest-free deposit

Lease accounting with an interest-free deposit Details for lease accounting Let us assume the following details for lease accounting: Lease start date: 1-Apr-2019 Lease end date: 31-Mar-2024 Lease payments: Rs. 2,75,000 Lease Deposit: Rs. 3,00,000 Payment frequency: Annual – payable at the end Incremental borrowing rate: 9% Right-of-use Recognition of Lease liability Amortisation of Right-of-use Finance cost Interest free deposit Imputed interest income Amortisation …
Read More

Journal entries for lease accounting

Journal entries for lease accounting Details for lease accounting Let us assume the following details for lease accounting: Lease start date: 1-Apr-2019 Lease end date: 31-Mar-2024 Lease payments: Rs. 2,75,000 Payment frequency: Annual – payable at the end Incremental borrowing rate: 9%   Right-of-use   Recognition of Lease liability Amortisation of Right-of-use Finance cost Trial balance Profit & Loss Account Balance Sheet
Read More

Steps in lease accounting

Steps in lease accounting Details for lease accounting Let us assume the following details for lease accounting as per Ind AS 116 Lease start date: 1-Apr-2019 Lease end date: 31-Mar-2024 Lease payments: Rs. 2,75,000 Payment frequency: Annual – payable at the end Incremental borrowing rate: 9% Step 1: Calculate the right-of-use The right-of-use is first calculated as follows: Step …
Read More

Subscribe to our News Letter

Get periodical updates from us

Subscribe to our News Letter

I hope you enjoy reading this blog

Scroll to Top