Eliminate Excel with LemonEdge Algorithms
Bring your offline workbooks into LemonEdge, work with real-time data and automate your processes with our proprietary spreadsheet solution – Algorithms.
Stop plugging gaps with Excel
Firms have come to rely on offline spreadsheets to plug the gaps between their core system's capabilities and their business needs - but having umpteen offline processes isn't without its pitfalls.
The risks of offline spreadsheets:
Lack of security – files can go anywhere.
Time-consuming – reliant on manual processes.
Data goes bad – infrequent updates.
A black box – no audit trail.
Like a spreadsheet just embedded
With the same look'n'feel as Microsoft Excel, LemonEdge Algorithms gives your team all the calculation capabilities with none of the risks. Everything from the rows and columns to the cell formula and functions is the same - there's no learning curve when you move your workbooks over.
Security at the forefront
Our data access and security model apply to all data and functions in the system, including Algorithms. Eliminate your security headaches by bringing your Excel workbooks into LemonEdge, where only authorised users can read, write and update data, including the underlying spreadsheet formulae!
Maintain a detailed audit history
Anything that happens in LemonEdge is logged into your audit history and Algorithms is no different. User activity, formulae changes, and more are all logged safely and securely, enabling you to review changes quickly and if needed, unpick something causing an issue.
Executive Director, Private Equity
How private markets firms can harness the benefits of Algorithms.
Private Equity GPs
Often, calculations set out in the Offering Memorandums are beyond the capabilities of any out-of-the-box system and end up in Microsoft Excel. Whether it’s complex carry or waterfall calculations or something else, a series of manual processes and risks are created. With LemonEdge, existing calculations can be copied into Algorithms and connected to all of your data sources and left to run securely and automatically.
Fund Administrators
Fund administrators do things differently from one another, with a breadth of subtle variations from client to client. It’s not scalable, and results in a sea of offline spreadsheets, scattered across the organisation. While idiosyncrasies will never change for your clients, offline processes and calculations can be imported and securely embedded for automated, audited processing by using Algorithms.
Family Offices
Unless a Family Office (or Multi-Family Office) firm has a suite of applications covering the entire scope of functionality required, they invariably compromise by deploying stop-gap Excel solutions. LemonEdge Algorithms removes the compromise by bringing all data, processes, security, audit, and control inside the system.
4 benefits of Algorithms
1. Secure
Protect your data using our user access permissions.
2. Automate
Automate your calculations using new or pre-existing Excel formulae.
3. Key-person risk
Often only one person who 'knows' how the sheets work.
4. Audit and history
Track every change and maintain your historical calculations.
See the future of fund accounting
Just some of what we’re excited to show you:
Tell us about you and your firm, and we’ll come straight back to you to schedule a personalised demo.
A proven alternative to legacy systems
"LemonEdge has proven market-leading capabilities that will enable the continuing evolution of our operations to become agile, efficient and able to add further value to our investors.”
Guillaume de Malliard, COO and Partner at Astorg Group
Frequently asked questions
Yes. All the standard cell-based formulae, functions, calculations, etc are the same in LemonEdge Algorithms as in Microsoft Excel. In addition, any Excel Macro or VBA processing can also be imported into LemonEdge using the system’s unique low-code capabilities.
Yes. Any data from the LemonEdge database can be pulled directly into an Algorithm making for a very convenient method of getting at the information required for any calculation or process. Equally, any results arising from an Algorithm can be saved back into the LemonEdge database, including complex results such as accounting transactions.
Algorithms are for all practical purposes indistinguishable from Excel workbooks, which means that anyone familiar with Excel can immediately use Algorithms in the same way (though pulling/pushing data from/to the LemonEdge database does require additional knowledge).
Extremely easy. Simple copy/paste is all that’s required.
Still have questions?
Request a demo and we'll answer them.
LemonEdge featured in The Commonwealth at 75 as a standout organisation shaping the Commonwealth
