'Collation.AI'', is a comprehensive data aggregation and reporting platform offering AI-driven backoffice, portfolio analytics, and client reporting solutions for Wealth Managers.

We originated from the WealthTech provider Canopy.cloud, which reports on over USD 170 billion in assets and is supported by many Family Offices, Credit Suisse, and UBS.

Our AI bots, extract data from any system (or PDF document), Put it into a data warehouse and maintain data integrity and consistency, We create workflows around the data in the warehouse, then data is pushed to any system or application our clients wants.

Key Benefits:
INTEGRATION SUMMARY:

• Most of Collation.AI’s customers need to prepare financial statements for the investment activities and for this they typically use some of the popular cloud-based accounting systems (e.g. Sage Intacct is the higher market share we see, but we also see Archway, Allvue, QuickBooks etc.).
• Sage is great for accounting activities, esp. in a multi-entity environment, but investment reporting is requires extra insight. Collation.AI fills this gap by importing data from Sage Intacct into a data warehouse and running a set of analytics on it. Collation.AI clients continue to use Sage as their single source of truth and simply bolt on Collation.AI’s investment reporting (e.g. TWR, MWR, IRR, Volatility, Sharpe Ratios, VaR, PME, DPI, TVPI, etc.) on top of it as an overlay.

MAIN OBJECTIVE:

• Is to get a copy of the client’s data into the data warehouse and keep it in sync. Our primary focus is on getting data from Sage Intacct into the data warehouse, but in some cases we may need to push journal entries into Sage as well.

IDEAL CUSTOMERS:

• Registered Investment Advisors (RIAs), Family Offices, Independent Wealth Managers, External Asset Managers, Trusts, Fiduciaries etc. that need to prepare financial statements for the investment activities and for this they typically use some of the popular cloud-based accounting systems.

CUSTOMER BENEFITS OF THE INTEGRATION:

1. No change required on our mutual clients’ tech. stack e.g. Sage remains as their single source of truth so no risk of breaking something, unnecessary time/money spent on lengthy implementations etc. Bolted on top quickly and results come in extremely quick
2. Sage is a great GL tool but does not do Investment Reporting. Single Family Offices usually buy Addepar for investment reporting (which is expensive both in terms of license costs and specialized manpower to run it). Collation.AI will bolt seamlessly on top of Sage whereby we provide powerful, flexible, scalable Investment Reporting (e.g. TWR, MWR, IRR, Volatility, Sharpe Ratios, VaR, PME, DPI, TVPI, etc.) as an overlay.
3. All our customers get a continuously updating data warehouse where we collate all their data from their various systems including Sage but also their CRM, Portfolio System (if they have one), Websites, PDF documents etc. We create a data warehouse for all our customers.
4. Depending on the use case, Collation will be able to automate the generation of journal entries from sources like Bank Data Feeds and push them into Sage Intacct.
5. We can do partial ownership reporting for our customers. This is often a key requirement in complex Single-Family Offices when individual family members own different entities in varying percentages which change over time.

Requirements:

Integrating with this application requires you to use the partner’s SenderID. By using the partner’s SenderID, you do not need to buy a web services developer license from Sage and your API usage will not count towards your API performance tier. Sage may prevent customers from integrating with this application under their own SenderID.

Price:
Flat Annual Fee for platform +  One-time setup fee

Integration Approved Countries:
United States