Get your lease accounting done for free this month-end
Get your lease accounting done for free this month-end
The lease accounting software you want
Input the details of the contract, run your journals, and your lease accounting is done. It’s as simple as that. Performing lease accounting manually will seem completely antiquated, and you’ll probably kick yourself for not using Cradle earlier.
As a lessee, to calculate a lease manually involves the following steps:
1) Familiarize yourself with the new lease accounting standard. Understand the nuances of calculating a lease liability and right of use asset.
2) Perform a lease liability calculation. Calculate the present value of the future lease payments at a point in time, ensuring you’ve captured all the relevant inputs to the calculation.
3) Set up a right-of-use asset depreciation schedule. Use the lease liability value plus several other inputs prescribed by IFRS 16 / AASB 16.
4) Each calculation needs to be updated any time there is a modification to the lease contract.
Then for monthly reporting, to calculate the journal entries, it is necessary to:
Or you can use Cradle.
It’s easy to fall into the trap of assessing lease accounting software solely on a functionality basis. However, there is no point in having every lease accounting feature possible if the finance and other teams using the software can’t work out how to use it. Cradle is specifically designed so this does not happen.
We’ve done this by ensuring our IFRS 16 / AASB 16 software mirrors that of the standard. Start with the Initial Recognition tab, where the user must fill out all mandatory fields required to present value the future lease payments. Then move onto the inputs specific to the ROU asset. If you enter nonsensical data our validations will catch it, explain the error, and highlight the field that needs to be updated.
Once those details are set, you should only revisit the Initial Recognition page if there’s been an error in the entered data. Where do you make lease modifications? In the Modification tab. We’re so confident in our user interface we allow customers to sign up and onboard agreements themselves with no training. You can run your journals in no time. But if you do hit a roadblock, we have a bounty of help material from “How to input a CPI increase” to “I want to recalculate my lease agreement manually,” and if that does not suffice, our 24/7 customer support team is there to help you along the way.
There's no room for error when preparing a set of financial statements in compliance with the International Financial Reporting Standards (IFRS) / Australian Accounting Standard Board (AASB). Despite this, material errors continually occur in a set of financial statements. These errors will, on occasion, get past the company's auditors.
This is understandable given the finance team's sheer workload and the limitations of an audit, as it's impossible to audit everything.
Using Cradle's lease accounting software will mitigate the risk of material misstatement to a company's financial statements. The financial reports generated are uniform, secure, quick, and, most importantly, comply with the new lease accounting standards and the general principles of accounting.
With Cradle, you can generate all relevant financial reports related to your lease portfolio:
No matter your reporting calendar, Cradle can accommodate those reporting requirements. How? Cradle's calculations are performed daily. You have the ability to run your statements for any date ranges. Want to run your income statement for 7 days? You can do that. Cradle even gives the user the ability to drill down on account values at the start or end of the day. Even your auditors will be impressed. Don't worry; forecasting is also available. Want to gauge your total lease liability and right of use asset in 2025, no problems. Want to see what your cash flow statement will look like over the next ten years separated between financing and operating activities? Again no issues.
The final feature of our financial reports is that they can be run at any reporting level. Want to see the disclosure report of an individual agreement or a specific company, Cradle can accommodate that. Have a company structure with 50 subsidiaries and a total of 5,000 lease agreements and need the consolidated financial reports? Cradle will produce the reports in seconds.
The financial reporting requirements of IFRS 16 / AASB 16 have been in effect long enough to be captured in most companies’ financial reporting cycles. It should come as no surprise that post-implementation requirements of the standards are just as arduous after the transition to IFRS 16 / AASB 16 when done manually. The time spent on the adoption of the new lease accounting standard is only the beginning and requires significant upkeep.
Any change to the leased assets expiry date or future lease payments impacts the lease liability and right of use asset. A simple CPI increase to the fixed payment amount will result in a remeasurement of the lease liability and right of use asset, but remember you do not have to update the discount rate.
There are many nuances in IFRS 16 / AASB 16 that can be missed when done manually. This even applies to lease accounting software solutions. As Deloitte states:
"Accounting systems will need to be able to cater for scenarios where remeasurement of the liability is required, potentially with an updated discount rate. Basic spreadsheet solutions may struggle to cope with such demands as well as identifying when such remeasurements are required."
The development team at Cradle couldn’t agree more. For example, different types of decrease in scope modifications will dictate different calculation methodologies. If you are curious about how Cradle’s modification accountings stacks up, refer to this article, which compares Cradle’s numbers to the IFRS 16 Illustrative Examples. You will quickly realize that even Excel is probably not IFRS 16 compliant.
Cradle is engineered to handle any modification of a leasing contract. Furthermore, we have records to ensure all users understand the modifications made to the applicable contract. Clean, simple and easy to understand. We are incredibly proud of our user experience for modification accounting and encourage our potential customers to compare this experience with other market solutions.
If you have several lease agreements in a foreign currency, the foreign exchange (FX) accounting can be as demanding as the lease accounting. In principle, FX accounting should be relatively straight forward. Delineate between if the account is monetary or non-monetary and use the applicable FX rate based on the rules set out in IAS 21 / AASB 121.
However, anyone that has done FX accounting knows things can quickly get confusing and convoluted despite the fact it’s merely converting one currency to another. That’s why we have FX functionality for lease accounting. When using Cradle, input the relevant FX rates, and those foreign leases will be converted to the applicable functional currency. Does your parent entity have a different reporting currency to a subsidiary’s functional currency? Cradle supports this as well.
The functionality requirements for lease accounting software are apparent; they're mandated by IFRS 16 / AASB 16.
But lease accounting is only one aspect of managing a lease portfolio. Under the previous lease accounting standard IAS 17 / AASB 117, the finance team only had to pay close attention to finance leases. Accounting for the remainder of the lease portfolio as operating leases was extremely straightforward.
This has all changed with IFRS 16 / AASB 16. Several teams within the organization need access to the information of a company's lease portfolio for various reasons. At Cradle, we understand this, and that's the reason why there's a clear divide between lease administration and lease accounting.
We also understand that every company's lease administration needs are different, and having a standardized experience would fall short of our customer's needs. So that's why we have an incredibly robust and customizable lease management system. Your lease administration can be tailored to suit your portfolio requirements. With Cradle, you can input any form of data and standardize this for the entire lease portfolio. All custom fields can be searched for, stratified and exported.
Microsoft Excel is an excellent tool when used for the right problem. From a lease accounting perspective, user permissions are another example of where Excel can fall short. Having to continuously maintain and update the same spreadsheet where multiple team members have access not only only compromises accuracy but it's also inefficient. Something as simple as a colleague updating the wrong version in which you spent the last four hours doing a lease accounting modification can set you back hours. Not to mention they're all password protected with "leaseABC". This is not the best practice from a financial reporting process perspective and it increases material misstatement risk.
On the other hand, Cradle has been specifically engineered to address these problems. Firstly, replicating a company's corporate structure, it allows ultimate flexibly to what teams manage what portfolios while maintaining oversight. Have a foreign subsidiary with a sizable lease portfolio. Add a superuser to that subsidiary and let them handle that specific lease portfolio.
Cradle brings the benefits of software to lease accounting.
Every company's finance team has to walk the tightrope between reporting the financial results that matter to the company while maintaining its regulatory financial reporting requirements. Juggling these two tasks doesn't get any more challenging than during year-end. Having to prepare a set of financial statements is exhaustive, not to mention they also need to get audited.
However, imagine that it's all done for your lease accounting, every aspect that will impact your financial statements. All you need to do is run the reports, and not only will you have the figures for your income statement, balance sheet, cash flow statement, but all the applicable disclosures as well. The auditors are also happy; you've given them access to your lease portfolio where they can access all relevant calculations and supporting documents. That should make things go a little more smoothly.
When using Cradle, this is the reality, no late nights trying to get the disclosure report done as it's always an afterthought. No negotiation of overruns with the auditors for time delays. Our disclosure report adheres precisely to the requirements of IFRS 16 / AASB 16 paragraph 53:
It is all too common that an accountant will mutter, "there must be an easier way," and when excel crashes, it usually is something else! Excel is a brilliant tool and has its place, but managing and accounting for a lease portfolio is not it. Cradle ticks all the boxes, and if you've put the decision off, it's never too late. It is engineered specifically for your lease portfolio and at a price where the time it will save is easy to quantify. We're not exaggerating the limitations of spreadsheets. Acuity Magazine - the member magazine for Chartered Accountants Australia & New Zealand just published Bad spreadsheets are killing your business. Get ahead of your errors and use Cradle.
But don't worry, all our reports are exportable to your favourite spreadsheet software, Excel.
At Cradle, we sweat the details, so you don't have to. It all starts with the calculation methodology of how to present value the lease liability. There are various ways to calculate the present value of the future lease payments, even in Excel. To drill down even further within the present value formula, each aspect can get incredibly granular. We do daily calculations. That's the building block to ensure we can handle any lease scenario. There are considerations like what day count convention will be used to calculate the lease liability's interest. Excel's XNPV formula uses Actual/365 Fixed; while to get the same number as in the IFRS illustrative examples, the Actual/Actual ISDA day count convention will be needed. Does this matter? To you, maybe not, but to us, it's paramount.
In Cradle you have the choice of what calculation methodology to use for your lease accounting. Want to get the same numbers as the IFRS Illustrative examples? Select Actual/Actual ISDA. Want to be able to recalculate Cradle's numbers in Excel to the cent? Choose Actual/365 fixed.
All our calculations can be exported to a CSV file for your recalculations or for the auditors to look at.
There's a variety of ways to get your lease portfolio data into Cradle. Whether you're looking to upgrade your current IFRS 16 / AASB 16 software, drive efficiencies and move away from Excel, or you're about to transition to the new standard, we offer a solution for you.
The options you have available are:
Lease accounting is only one part of your financial reporting requirements. We understand it’s essential to get the information back to your general accounting ledger. As a result, you can set up Cradle to mirror your accounting environment. For each account in Cradle, you can set a general ledger code to match that used in your accounting system. If you have multiple cost centres using the same leased asset or account, you can also weigh general ledger codes.
Your success is our success, and we want to ensure we provide all relevant resources to navigate and account for your lease portfolio. Part of your subscription includes 24/7 access to our customer support team. Our team has experience with the standard and are qualified chartered accountants. We're well equipped to answer any questions that arise. So if you hit a roadblock, we're always there to help.
Furthermore, when signing up, you'll get specialized training based on the needs of your lease portfolio. This provides an excellent opportunity to discuss best practices and how best to get the most out of our AASB 16 / IFRS 16 lease accounting software.
The last aspect of our customer success offering is access to a huge selection of documents and videos of "how to's" in Cradle. This goes beyond using our software and helps navigate the standard. Let's say you're unsure of what a non-lease component is. Click on our help button, and you're directed to an in-depth explanation with details of the impacts of utilizing the practical expedient offered by IFRS 16 / AASB 16 on your lease liability and ROU asset.
Consolidated Leasing Sub-ledger
General ledger Integration
“Cradle has been a joy to work with. They have no red tape and our queries are dealt with promptly and efficiently. They were able to make custom enhancements with ease and have been very helpful and instrumental in our success for transition. Would highly recommend.”