Why ARO Reporting has become too big for spreadsheets

August 8, 2022

“Why would I buy software to manage my ARO when I have a spreadsheet for that?”

We hear things like this a lot. And at first glance, it’s easy to understand why. Spreadsheets are easy-to-use, highly customizable, and come at no additional cost to most companies.

However, as end-of-life closure activities and obligations have grown in importance and complexity, managing an Asset Retirement Obligations (ARO) program through spreadsheets comes at a hidden cost. The initial benefits of spreadsheets – flexibility, familiarity, and affordability – can’t overcome the challenges posed by utilizing a tool never made for this job.

Excel Wizards out there can create remarkable spreadsheets custom-tailored to meet their personal needs. The issue is that spreadsheets are designed to meet the needs of their creator and are not meant to be mission-critical applications used across multiple departments of a company. If a company intends to share these spreadsheets interdepartmentally, how do they then track changes for audit purposes? Do they know when a formula gets corrupted or broken? When does the sheet stop functioning as one person’s personal tracking system to a full corporate-wide report? More importantly, which version is updated and adjusted to meet changing regulations?

We frequently hear horror stories from companies who have outgrown their spreadsheets, for example:

  • “Things got too complicated” – Simple worksheets originally built to manage at-the-time basic End of Life reporting needs grew into difficult, overblown monsters of dozens of tabs, and fragile nested formulas. Merged and acquired companies became impossible to fit into the legacy structure and had to be managed independently.
  • “We had to call in IT” – As file sizes bloated, spreadsheets became more difficult to load, slow to respond, and more prone to crashes.
  • “I lost my wizard” – Reliance on a single ARO Excel expert meant that when our Excel expert moved on from their role, we had to start from scratch getting someone else up to speed.
  • “We wasted so much time on errors” – From simple data entry errors to broken formulas, we constantly had to do things over because something in the worksheet broke. Finding the formula break was always a long and painful process.
  • “I’m always being asked for reports” – We usually sigh with relief when the task of year-end ARO reporting is done. But banks, investors, and executives are all insisting on more transparency, reporting, and planning when it comes to end-of-life obligations. This is not easy to do on the fly with our unwieldy spreadsheets.
  • “I need a better audit trail” – Managing critical data within spreadsheets means not having an automated log of who made what changes to reports. Anyone who has access to the document can make changes without anyone else knowing.
  • Updating is so manual Every quarter the data needs to be refreshed with all changes to the licenses. Pulling this data is complex and time-consuming.

When you factor in time spent managing any of the seven issues above, spreadsheets start to become a lot less cost-effective than they initially appear. Companies need a more standardized approach that can be easily used, shared, and reported from by anyone throughout the organization. There is significant efficiency from a fully auditable, user-protected, trackable, and cloud-based solution.

Moving away from spreadsheets to AssetBook ARO Manager ended these problems for our clients. ARO Manager was purpose-built for the oil and gas industry, developed through a culmination of government resources, expert opinion, and industry data.

Figure 1 – ARO Manager provides users with a simple, comprehensive look at their end-of-life closure activities and obligations, available to anyone in their organization who needs the data.

ARO Manager directly addresses the problems with spreadsheets by providing:

  • Web-based platform that requires no IT intervention or database management.
  • Simplified ARO processes – users get exactly the columns and data they need without having to be a spreadsheet wizard.
  • Shared experience across departments, with everyone working from the same live file with real-time information for analysis and decision-making.
  • Enhanced scenario analysis – easily substitute cost models, adjust inflation or discount rates, apply discounts for ABC programs, and more.
  • Routine software updates to meet changing needs and regulations – eliminating the need for an Excel wizard to build new functionality into a spreadsheet.
  • SOC compliant process that tracks all changes to satisfy auditors.

You can learn more about the various struggles our clients have had with their previous ARO spreadsheets, including dedicated hardware and our favourite, “the Rainbow Unicorn Spreadsheet of Barf” by attending our upcoming info session “The Problem with Spreadsheets in ARO Management” on August 16th. See below for details.

When: Tuesday, August 16th
Time: 11:00-11:45 am
Where: Zoom – Register here


Interested in this discussion but unable to attend? Contact us today to set up a private demo.