Lease Accounting Software – Data Input Process

Creation of Company

Super Admin is the administrative contact from RVSBELL Analytics, who will create the company and the user login ids for all the users of the application.

Creation Of Company

Creation of users

Three users are created by the Super Admin viz., Accountant, Manager and Auditor. All the three login ids should be created before the user starts to work with the system. If the user wants more ‘Accountant’ logins, it can be requested at additional cost and the Super Admin will create the same.

Before the user starts to upload the data etc., all the login ids created by the Super admin must be activated by the user. The user will automatically get an email from RVSBELL Analytics which should be activated by  clicking the link provided in the email and then creating the users own password.

Accountant

Accountant can only input the files. Cannot see data input by other accountants. There can be more than one accountant and such account logins are created by the Super admin upon specific request by the user as mentioned above. Accountants cannot download any data including the data that they have uploaded/entered into the system.

Profiles

Manager

The manager account will also be set up by the Super Admin. Manager can also input the files. Can also see data input by any accountant. Manager can download data in any available formats for download.

Auditor

Auditor cannot input the files. Can see the data input by anyone. Also the Auditor has some views which are not available to other logins – accountants and manager. Auditor can download data in any available formats for download.

Input data upload process

Valuation Date

The valuation data must be first created before any data can be uploaded. Initial date can only be quarter ending dates viz., 31-Mar, 30-Jun, 30-Sep or 31-Dec. The valuation date cannot be any date other than one of these four dates.

Before data for a particular valuation date is uploaded, it should be ensured that the valuation date is set to active. If the valuation date in the input file is different from the one that is set to active, then the input process will throw an error.

Valuation Date

Pressing the next date will automatically create another line item with the next valuation date. The next valuation date is determined based on the frequency of valuation period specified by the Super Admin while creating the user account. For example, if the frequency is quarterly, then the next valuation date would be 30-Jun-2020. If the frequency is Yearly, then the next valuation date would be 31-Mar-2021.

For example if the user wants to upload data for the valuation date 30-Jun-2020, then that should be made active as shown below.

Myvaluation Dates 1

Asset Class

The user should first specify Asset Classes for the lease items. For example, the asset classes could be Office Property, Godown, Guest House, Lap Tops, Motor Car, Two Wheelers etc.

Asset Class
Myassetclass

Lease upload data

Lease Upload Data

Data Validation

If there are data validation errors, then the system would throw out such error messages.

  1. If Avail Exemption is Yes then the corresponding line item is excluded from all computation
  2. If Avail Exemption is No then Exemption type should be NA
  3. If Avail Exemption is Yes and Exemption type is ‘Short Term’, then the End Date less Start Date should not exceed 365 days
  4. If Avail Exemption is Yes and Exemption type is ‘Short Term’, then all rows of the same ‘Asset Class’ should have Avail Exemption = ‘Yes’
  5. If the Asset Class does not match/exist in the asset class master, then an error is displayed
  6. The Start date cannot be later than the valuation date
  7. The effective date cannot be later than the valuation date
  8. The end date should be later than the start date and effective date

Display upload status 

1. New (clean record with no validation errors, yet to be processed)

2. Error (record has validation errors. This record should be uploaded again or can be edited and corrected after which this record will become ‘New’.

3. Exempted – Low Value (record is exempted from all calculations – but used for disclosure purposes)

4. Exempted – Short term record is exempted from all calculations – but used for disclosure purposes)

5. Processed New (Processed for the first time)

6. No change (considered in the next valuation date, but there are no changes in the record)

7. Processed Modified (record is processed after modification from the previous valuation date resulting in additional journal entries)

8. Terminated –  Lease that is terminated

Sample data

The following input data is uploaded into the system for the various valuation dates viz., June-19, Sep-19, Dec-19, Mar-20 and Jun-20.

Note: Lease ID LZ-02 is terminated on 31-May-2020.

Sample Data 1 1
Sample Data 2
Sample Data 3
Sample Data 4
Sample Data 5

Lease Accounting Software

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, 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 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