← Insights Hub

Partner cases · PerfectXL

PerfectXL in the field

Client cases from Navitas partner PerfectXL - the spreadsheet risk software behind steps four and five of the Navitas method. These are PerfectXL's clients and stories, shared here to show what the tooling does in practice.

Global energy company

Crucial blunder in consolidation sheet caught on time

A large oil company missed a subsidiary in a consolidation sheet - PerfectXL caught the issue before the file was finalised.

Before PerfectXL

This company had several proficient Excel users, but the general complexity of files was also very high. While they had four-eyes principles and standardised checks, these processes were manual - not only time consuming, but also error prone. Human error exists in the modelling part of working with Excel, but also in the checks and testing. The client was confronted with this truth when they found an error that could have had significant consequences.

"This software helps me perform the final checks and review on files quickly so I'm sure that I don't miss anything."

After PerfectXL

With PerfectXL tools, users were able to mitigate several potential blunders by having a more complete and standardised check of Excel models. While manual checks still take place on core outputs, the checks PerfectXL automatically performs result in in-depth model reviews exposing any potential weakness or error - and a significant reduction in the time invested in quality control.

Conclusion

People working with Excel at this company feel that the quality of models is higher, confidence in outputs is higher, and the time invested to reach that result is much lower. When risk mitigation is paired with significant time saved, everyone is happy.

Source: PerfectXL client case ↗

Leading asset management company

Standardised audits and documentation for all high-risk models

A leading asset management company categorises spreadsheets as high and low risk. All high-risk spreadsheets are enriched with a PerfectXL report.

Before PerfectXL

Before implementing PerfectXL, the high-risk category felt unusable due to strict restrictions and limitations. Without understanding what potential risks or errors were in place, and without version management software, documenting and justifying changes was a painstaking process. Improving the files at all was incredibly time intensive.

"The PerfectXL reports add a layer of documentation and control that allow us to utilise high-profile models without the fear of unforeseen issues."

After PerfectXL

With PerfectXL, a model's limitations are clearly documented and any change can be validated by running a new report. Changes that might negatively impact a file can be verified with PerfectXL Compare, which shows what has changed between two versions and generates change logs. Confidence in actually using and improving Excel files has increased massively.

Conclusion

Now that users are comfortable with PerfectXL, the risk associated with working with files in either category is much lower, and much of the time burden around documentation and verification has been removed.

Source: PerfectXL client case ↗

Boutique consultancy firm

Automated checks and controls on all outgoing models

A boutique consultancy firm doesn't have the resources to extensively check every file manually - PerfectXL lets the team spend the time saved on providing services.

Before PerfectXL

Before implementing PerfectXL this firm had to invest a significant amount of time manually checking models, relaying feedback clearly and concisely, and then training or informing the Excel users on best practices. While this process generally delivered good results, the investment in terms of time was huge, and there was still often the nagging fear of potentially missing something important in these manual checks.

"We love PerfectXL! It's like an insurance policy for us, we use it on every outbound model to make sure everything is working as it should."

After PerfectXL

The company now has key users analyse any outgoing spreadsheet. Proficient users enrich PerfectXL's findings with comments and feedback before generating reports to share with users, who use those reports to solve any issues, learn better modelling practice through the advice on the reports, and return the auto-generated reports with the updated files. This leads to a clear validation trail and results in higher quality models with much less time invested.

Conclusion

The tools give management and ownership of this consulting firm much more confidence in the files they share with and develop for clients. The risk of mistakes in spreadsheets damaging reputation is mitigated through the use of PerfectXL.

Source: PerfectXL client case ↗

Large accounting firm

Five-minute scans of all incoming sheets lead to efficient reviews

A large accounting firm avoids drawn-out projects by pre-emptively running a quick scan with PerfectXL.

Before PerfectXL

Before implementing PerfectXL this firm would do some basic sense checks on models and then dive right into a review or analysis based on the numbers presented. In some cases those numbers were incorrect due to small mistakes in the source file - and once discovered, all the work done to that point had to be done again, with locating and fixing the mistake taking significant time. Most projects ran fluidly, but where small Excel mistakes produced faulty reviews, the uptick in time spent created friction with clients and a bad experience for all parties involved.

"Five minutes with PerfectXL has saved me many hours on several different occasions."

After PerfectXL

The firm now uses a few core elements of PerfectXL to check the most essential risks - a complete audit does not fall within the scope of their projects. They analyse the file with Explore, scan for external dependencies that need to be available for the review, and quickly check which worksheets are referenced in the output tab. Missing or unexpected references are flagged, and unconnected sheets are briefly reviewed and, where possible, removed to reduce the scope of the review. Risk Finder then checks a few core risks that could negatively affect the output. The process takes 3-10 minutes for most models and gives the reviewer a much higher level of confidence. Even when issues don't pertain to the output, clients appreciate the input on how they can improve their models.

Conclusion

PerfectXL delivers a higher level of confidence when reviewing or using existing Excel models. Faulty outputs are quickly identified, and clients get a more comprehensive review that includes information on the potential shortcomings of their models. A few minutes spent upfront saves much more time for the company as a whole.

Source: PerfectXL client case ↗

Navitas runs PerfectXL Risk Finder and Model Explore analyses for clients, and can arrange the software directly where that's more economical. About the partnership →