General

Spreadsheets Vs. Software – evaluating the best approach for IFRS 16

By January 29, 2020 No Comments

It is often our experience that C level executives consider IFRS 16 / AASB 16 solely a compliance exercise and as such approach the new standard with a certain reluctance to investing in new systems. Additionally, the complexities associated with IFRS 16 are often overlooked until departments are in the depths of rolling out new business as usual (BAU) practices covering the new standard.

Blue Sweet Tooth Blog Banner (2)

This leads to an inevitable adoption of Excel by organisations and their accounting teams tasked with transitioning and maintaining IFRS 16 accounting. Whilst IFRS 16 accounting using Excel may appear to be the way forward for many CFOs, there are significant pitfalls associated with this approach, depending on the complexity of the business.

In this blog explore the pros and cons of using spreadsheet applications such as Excel for the transition to IFRS 16 and maintaining ongoing compliance post implementation.

The Pros of Spreadsheet Accounting

  1. Entities and their employees are familiar with, and well-accustomed to, using spreadsheets
  2. Simplicity – no software implementation required
  3. Spreadsheet solutions have been previously used by organisations as a path to compliance for former accounting standards e.g. IAS 17, IFRS 15, IFRS 9 etc
  4. Seemingly lower cost barriers
  5. No additional hosting requirements
  6. Readily available/immediate, familiar and understandable

The Cons of Spreadsheet Accounting

  1. Building efficient spreadsheets is often dependent upon, and limited to, the capabilities of the builder/owner
  2. Difficulty exists in troubleshooting, navigating and reviewing spreadsheets
  3. Excel lacks the critical controls needed to preserve the integrity of data
  4. Spreadsheets are always vulnerable to changes either through deliberate or accidental human interventions/errors that are extremely difficult to isolate and correct
  5. Difficulty in tracking by who, when and where changes are made – proving problematic for auditing purposes
  6. Although spreadsheets may appear a cheaper option, they do require more maintenance and may even require external support (at a cost) to sustain
  7. A significant amount of manual processes is required to support the use of spreadsheets (e.g. backup/disaster recovery etc)
  8. No independent verification by an expert

If you’re interested in a deeper analysis of the the pros and cons and tools to help you evaluate the best approach you can download our latest whitepaper , or reach out today.