• Home
  • About Us
  • Contact
  • Your Account
  • Subscribe
No Result
View All Result
Wednesday, February 1, 2023
Alternatives Watch
  • Hedge Funds
    • Manager News
    • Mandates
    • Service Provider News
    • CTAs/Managed Futures
  • Private Equity
    • Manager News
    • Mandates
    • Service Provider News
  • Private Credit
    • Manager News
    • Mandates
    • Service Provider News
  • RE/Infrastructure
    • Manager News
    • Mandates
    • Service Provider News
  • Investor News
    • Endowments and Foundations
    • ESG
    • Pensions
    • Platforms
    • Consultants
  • Research
    • Investor Scorecard
    • Manager Scorecard
  • Subscribe
  • Log In
  • Hedge Funds
    • Manager News
    • Mandates
    • Service Provider News
    • CTAs/Managed Futures
  • Private Equity
    • Manager News
    • Mandates
    • Service Provider News
  • Private Credit
    • Manager News
    • Mandates
    • Service Provider News
  • RE/Infrastructure
    • Manager News
    • Mandates
    • Service Provider News
  • Investor News
    • Endowments and Foundations
    • ESG
    • Pensions
    • Platforms
    • Consultants
  • Research
    • Investor Scorecard
    • Manager Scorecard
  • Subscribe
  • Log In
No Result
View All Result
Alternatives Watch
No Result
View All Result

Why Excel isn’t always excellent for tracking financial data

Ken EylerbyKen Eyler
July 12, 2022
in Hedge Funds, Open Access, Service Provider News
Why Excel isn't always excellent for tracking financial data

By leungchopan/Envato Elements

ShareTweetShareSendSend

Excel has been a mainstay for those in the financial profession for decades now. Since its release in 1985, and the introduction of competing applications such as Google Sheets; spreadsheets have come to serve as essential and powerful analytical tools. They are widely available, inexpensive, and can be quickly customized and made to work across a variety of situations.

However, for all their benefits, without substantial work, planning, and error-detection building they are prone to errors. Errors that can cost thousands (and sometimes millions) of dollars if not managed and checked effectively.

I’m sure we’ve all experienced an Excel error in our time. Data placement errors are common. After all, it’s a human entering that information and humans make mistakes. Likewise, formula errors are incredibly common, including referencing incorrect or incomplete cells or ranges, and bad formulas that yield an incorrect result that may not be obvious.

Take J.P. Morgan for example. In 2012, the company experienced a $6 billion (yes, with a ‘b’) trading loss as a result of an Excel copy-and-paste error. While creating value-at-risk (VaR) models using Excel, an employee accidentally copied the wrong information from one spreadsheet to another, resulting in an extreme understatement of the company’s risk and a key factor in the overall $6 billion loss.

You can now see how in working with ultra-high-net-worth individuals and families, these “minor Excel errors” can quickly rack up to significant and costly mistakes. For that reason, it’s my view that core information for businesses and families should not be housed in spreadsheets. Especially when there is an increasingly diverse range of alternative solutions available that are more fit for purpose.

Building software has become far less expensive and as such, easier to do than ever before. It is also easier to access uniquely tailored solutions that offer a service and/or product combination that is bespoke to your business or families’ unique needs. In many instances, newer software that was not on the market ten or even five years ago is now available and affordable. And even in instances where the software may not be individually affordable due to the scale required, outsourcing to third parties who run software for many families or businesses can make a lot of sense.

Here are a few examples of powerful software solutions that are available now and worth considering as Excel substitutes:

  • FirmView by PFA Solutions – A SaaS platform to manage private capital funds including all of the people aspects of Carry, allocations, deal management at the person level, plus private investment exposure and performance, and partner-level activity. No need to keep an Excel file with each employee’s share of a whole or part of an investment.
  • MAGPIE – A bespoke software and service offering for managing private collections, such as stamps, coins, watches, trading cards, artwork, and anything else that one can collect. Magpie replaces the need for spreadsheets listing the item, value, location, etc.
  • FundCount – A complete accounting and investment performance & reporting combination system capable of tracking any investment, any partnership allocation including waterfalls, hurdles, capital commitments, and anything creative investors can dream up, with the security of a balanced general ledger.
  • Expensify – Automated expense management that even includes OCR technology to read receipts thereby limiting the potential for keying errors, and totaling formula errors.

These are just a few examples of what’s currently available to streamline and safeguard wealth. Thanks to the pace of technological innovation, what may have once seemed prohibitive due to cost or complexity is now far more commonplace than you might think.

Managing an individual or families’ wealth is a huge responsibility. When you weigh the risk of costly mistakes due to common Excel errors, you might find you can’t afford to ignore more up-to-date and tailored solutions.

ShareTweetShareSendSend
Previous Post

Stone Point closes Trident IX at $9bn

Next Post

CIO Talks: Xponance’s Tina Byles Williams

Ken Eyler

Ken Eyler

Ken advises multi- and single-family offices, and select business enterprises bringing a practical approach to solving problems and managing the multifaceted responsibilities of significant wealth, guiding the team at Aquilance (formerly My Accountant) as they work with individuals, families, single- and multi-family offices, and their advisory teams. He devoted over a year as an Advisor to and Partner in Aquilance and assumed the CEO role in July of 2021.

Related Posts

Patient Square closes inaugural fund at $3.9bn
Private Equity

Patient Square closes inaugural fund at $3.9bn

MFA welcomes UK regulator's recognition of short selling in ESG
ESG

MFA welcomes UK regulator’s recognition of short selling in ESG

Titan’s Morgan reveals how she is keeping up with crypto
CTAs/Managed Futures

Titan’s Morgan reveals how she is keeping up with crypto

NY pension adds $1.2bn across PE, credit, HF and real estate programs
Pensions

NY pension adds $1.2bn across PE, credit, HF and real estate programs

AI hedge fund Castle Ridge builds success with multi-model system
Hedge Funds

AI hedge fund Castle Ridge builds success with multi-model system

Next Post
CIO Talks: Xponance’s Tina Byles Williams

CIO Talks: Xponance's Tina Byles Williams

Log In/Out

Lost your password?

Search the AW Archives

No Result
View All Result

Recent News

AW Top 10 reads for January

AW Top 10 reads for January

Patient Square closes inaugural fund at $3.9bn

Patient Square closes inaugural fund at $3.9bn

MFA welcomes UK regulator's recognition of short selling in ESG

MFA welcomes UK regulator’s recognition of short selling in ESG

Titan’s Morgan reveals how she is keeping up with crypto

Titan’s Morgan reveals how she is keeping up with crypto

Be an Alts Insider

Sign up for your FREE daily alts news briefing

Subscribe

Subscribe to AW
Alternatives Watch

© 2019-2022, All Rights Reserved  |  BMV Digital

Navigate Site

  • Hedge Funds
  • Private Equity
  • Private Credit
  • RE/Infrastructure
  • Investor News
  • Research
  • Subscribe
  • Log In

Follow Us

No Result
View All Result
  • Hedge Funds
    • Manager News
    • Mandates
    • Service Provider News
    • CTAs/Managed Futures
  • Private Equity
    • Manager News
    • Mandates
    • Service Provider News
  • Private Credit
    • Manager News
    • Mandates
    • Service Provider News
  • RE/Infrastructure
    • Manager News
    • Mandates
    • Service Provider News
  • Investor News
    • Endowments and Foundations
    • ESG
    • Pensions
    • Platforms
    • Consultants
  • Research
    • Investor Scorecard
    • Manager Scorecard
  • Subscribe
  • Log In

© 2019-2022, All Rights Reserved  |  BMV Digital

Be an alts insider

Start your days in the know with our free newsletter

No, I don't want to be an alts insider

Thank

You!

Follow us
on LinkedIn

Lost your password?

Cookie Consent
We do not use cookies on our website other than those that are strictly necessary for the website to function. By clicking “Accept”, you consent to the use of all six strictly necessary cookies.
Do not sell my personal information.
Cookie Settings Accept
Manage consent

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. These cookies ensure basic functionalities and security features of the website, anonymously.
CookieDurationDescription
cookielawinfo-checkbox-analytics11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
cookielawinfo-checkbox-functional11 monthsThe cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checkbox-necessary11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-others11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
cookielawinfo-checkbox-performance11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
viewed_cookie_policy11 monthsThe cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.
Save & Accept
Powered by CookieYes Logo