Crunchafi

From Spreadsheets to Lease Accounting Software: Leave it in the Past

The article "From Spreadsheets to Lease Accounting Software: Leave it in the Past" by Jess Vento argues that relying on spreadsheets for lease accounting, even for a small number of leases, is ineffective and costly, advocating instead for specialized lease accounting software to better comply with new lease standards and streamline the audit process.

Lease Accounting

From Spreadsheets to Lease Accounting Software: Leave it in the Past

By: Jess Vento

From Spreadsheets to Lease Accounting Software: Leave it in the Past

Request a Demo

First Name*

Last Name*

Email*

Direct Phone Number*

What best describes your organization?*

Please SelectCompany - Non-ProfitCompany - PrivateCompany - PublicConsulting FirmCPA FirmFractional CFOGovernmentPrivate Equity FirmOther

Which product(s) are you interested in?*

  • Lease Accounting
  • Data Extraction
  • FRS 102
  • BUCS

Lead Source Detail

UTM Source

UTM Medium

UTM Campaign

We'll only use your personal information to provide the products and services you've requested. From time to time, we'd like to contact you about other products and services that may be of interest to you. If you consent, please tick above to say how you'd like us to contact you.

  • I agree to receive other communications from Crunchafi.

In order to provide you the content requested, we need to store and process your personal data. If you consent to us storing your personal data for this purpose, please tick the checkbox below.

  • I agree to allow Crunchafi to store and process my personal data.*

You can unsubscribe at any time. See our Privacy Policy for details.

reCAPTCHA

Recaptcha requires verification.

protected by reCAPTCHA

You’ve probably heard a lot about spreadsheets in relation to lease accounting. Perhaps after your first audit with the new lease standards, you’re all too familiar with how “well” they work.

Unfortunately, some misguided advice suggests spreadsheets are a viable solution for a small number of leases. This couldn’t be further from the truth.

Although it may appear as a cost-effective approach to manage a small number of leases, we encourage you to consider the expense of building and maintaining these workbooks. In addition to your team’s hourly wages, costs are associated with auditing and potentially rectifying errors, significantly increasing the cost. Therefore, when evaluating this supposedly “free” alternative, keep in mind the expenses that come along with it:

  • The time to build the spreadsheet and the complex calculations.
  • The time it takes to verify existing data.
  • The time to revise leases if contracts change.
  • The additional audit fees to correct your spreadsheet.
  • The price to continue to maintain that spreadsheet year after year.

After considering these factors, it’s clear spreadsheets are not the most cost-effective or practical solution.  Instead, consider lease accounting software. With the right software, you and your team will increase productivity, reduce errors, and see a positive return on your investment.

Ready to take a look at the software?

When you’re ready to explore software solutions, weighing your options is essential. A full lease management solution may not be necessary depending on the number of leases, but additional features and functionality couldstreamline internal processes. Create a plan to review all solutions.

Here are some tips to keep in mind:

Pricing – Although you’ve used the  “free” option, software doesn’t have to be expensive. Check the pricing models for each solution. Look for a vendor that doesn’t have implementation fees, support fees, or other hidden costs.

Functionality – While spreadsheets seem like an easy solution, software with a simple user interface and a streamlined process can be just as easy to use. Leases should take minutes to enter into your chosen software, and any revisions should be able to be made without hassle.

Access Control– Maintaining version control in spreadsheets can be difficult, especially with multiple contributors. Find a solution that provides an audit trail that allows for the separation of those with full access roles and view-only roles.

Reporting– Reporting is the most powerful part of any lease accounting software, particularly for audits. Software output should not only be verifiable and accurate but should be easy to export.

If you’re interested in exploring a software solution,contact us today.

Related resources

Accounting for GASB 87 and GASB 96\ \ Lease Accounting

What are Right of Use Assets?\ \ Lease Accounting

Why CPA Firms Must Embrace Automation & Client-Centric Audits\ \ Lease Accounting

Get the good sheet in your inbox

First Name*

Last Name*

Email*

reCAPTCHA