This guide accompanies the Croma workshop with the Finance & Investment Club at Uniandes, on 6 October at 1:00 p.m. in the Sala Bloomberg SD. The full step by step is here.
The problem#
Anyone who analyses companies loses hours assembling the information before they can analyse it. Downloading a PDF, copying a balance sheet, retyping a company record, checking the figure pasted correctly. Those are hours that do not go into analysis, they go into mechanical work of little value. And most companies have no ticker to search for. Supersociedades alone receives the financial statements of about 30,000 companies a year.
The solution#
Connect your assistant, whether that is Claude, ChatGPT or whichever you use, to two things. Croma gives it access to all of government data, Composio opens better connections to the apps you already use.
Croma#
Croma connects your assistant to government data. One connection and it queries RUES and Supersociedades in Colombia, SEC filings and OFAC sanctions in the United States, CGU debarments and PGFN federal tax debt in Brazil, the DOF and the CNBV in Mexico, and on through more than 90 official sources across six countries. Every figure arrives with its source and its date.
Composio#
Composio connects it to the tools you already work in, from Gmail and Calendar to Drive and more than 1,000 applications. And its connectors are far more powerful than the ones Claude and ChatGPT ship with.
Step 1: connect your assistant to Croma#
If you have not done it yet, the full guide is at How to connect Croma to Claude, or How to connect Croma to ChatGPT if that is where you work. Five minutes, and the free plan covers the whole workshop.
To check it worked, open a new chat and type this.
Busca el NIT 900843898 en RUES y ármame un mini dashboard con lo que encuentres.If it answers with Rappi S.A.S., active in the Bogotá chamber, you are set. The prompts are in Spanish, as in the workshop. Translate them if you prefer, the sources are the same.
Step 2: seven queries to start with#
Seven queries, ready to copy and paste. Five of them use the same company, Rappi.
The first time your assistant uses a source it asks for permission. Accept it and let it work.
1. Who the company is#
RUES is the commercial register. It tells you whether the company exists, whether it is current and who represents it.
Prompt: the register record
Busca el NIT 900843898 en RUES y dame una ficha de la empresa: estado del registro, cámara, actividad, fecha de constitución, última renovación y representantes legales.You will see Rappi S.A.S., active in the Bogotá chamber, incorporated in April 2015, filed under software development, renewed in March 2026, with seven legal representatives on record.
2. What it is worth and how it is doing#
Supersociedades holds up to ten years of income statement, balance sheet and cash flow, as the company filed them.
Prompt: ten years in a dashboard
Trae los estados financieros de Rappi, NIT 900843898, de Supersociedades. Dame ingresos, utilidad neta, patrimonio y margen bruto por año en una tabla, en millones de pesos, y ármame un mini dashboard con esas cifras y una gráfica de ingresos y utilidad por año.You will see a company that went from COP 6 billion in 2016 to 767 billion in 2025, that lost money in eight of those ten years, that ran on negative equity in 2016 and again from 2019 to 2021, and that turned its first profit in 2024.
Prompt: compare it with another
Compara a D1, NIT 900276962, con Ara (Jerónimo Martins Colombia), NIT 900480569. Ingresos, margen bruto, utilidad neta y pasivos frente a activos en 2025, con el crecimiento de ingresos frente a 2024. Dime en qué se parecen y en qué no.Two Colombian discount chains with similar gross margins and opposite results. D1 sold COP 11.1 trillion in 2025, 7% more than the year before, at a 19% gross margin, and earned COP 214 billion. Ara sold COP 16.3 trillion, 18% more, at a 17% gross margin, and lost COP 579 billion. Both carry liabilities of 97% and 99% of their assets, and Ara is left with COP 52 billion of equity against COP 9.5 trillion of liabilities. This is where the work stops being data collection and starts being judgement.
3. Who owns it#
Along with the financial statements, Supersociedades receives the shareholding and the control roles.
Prompt: shareholders and control
Dime quién es el dueño de Rappi, NIT 900843898, según lo que radicó en Supersociedades: accionistas, porcentaje de participación, país y quién firma como revisor fiscal.A single shareholder, Rappi Inc, domiciled in the United States, holding 100% of the 1,800,618 shares. At that point the question stops being a Colombian one.
4. The parent, in Delaware#
The Delaware register answers for the company that sits above the operation.
Prompt: the parent company
Busca Rappi en el registro de Delaware y dame el detalle de Rappi, Inc.: número de expediente, fecha de constitución, tipo de sociedad y agente registrado.Seven matches, among them Rappi, Inc., Rappi USA, Inc. and Rappi Connect, LLC. The first is file 5966994, a Delaware corporation filed on 17 February 2016, with United Corporate Services as its registered agent in Dover. Two queries and you have the whole chain, from the Colombian operation to the company that controls it.
5. The namesakes, in Florida#
Florida publishes companies with their officers, their registered agent and their annual reports. It also publishes everyone with a similar name.
Prompt: search by name
Busca en el registro de Florida las empresas cuyo nombre contenga Rappi y dime cuáles están activas, con su tipo de sociedad y su agente registrado.Seventeen matches, and almost none has anything to do with Rappi. There is a Rappi Transport LLC, a Rappi Colombian Food Inc and an investment vehicle called Soma Capital Rappi SPV (GP), LLC. A register searches by name, not by company.
6. The operating footprint, in Mexico#
SIEM records establishments by state and by chamber, so it shows where a company actually operates.
Prompt: establishments by state
Busca Cemex en el SIEM de México y dime en cuántos estados tiene establecimientos registrados, con la cámara de cada uno, en una tabla.About thirty establishments, across Jalisco, Sonora, Hidalgo and San Luis Potosí among others, most of them registered with the Cámara Nacional del Cemento. A couple of look-alike names that are not Cemex slip into the results, so check the table. The example changes company here on purpose. Rappi does not appear in SIEM, and that is an answer too: not every company is in every register.
7. Everything else#
Croma has more than 90 official sources across six countries. These queries use five.
Prompt: what is in it for me
Revisa todas las herramientas de Croma que tienes disponibles y, con lo que sabes de mí y de mi trabajo, dime en qué las podría usar en mi día a día. Dame ejemplos concretos, no una lista de fuentes.Step 3: email it with Composio#
An analysis that stays in the chat is no use to anyone else. The last step is sending it to your team.
Composio is the bridge that connects Gmail to your assistant. One connection reaches more than 1,000 applications.
- Create your free account at dashboard.composio.dev, find Gmail and click Connect.
- In Claude go to Customize → Connectors, click + then Add custom connector. In ChatGPT it is the + menu in the chat, under Apps and connectors. Paste these two values.
Composiohttps://connect.composio.dev/mcpBack in the chat where you ran the analysis, ask for this.
Envíale por correo a tomas@usecroma.com el análisis de Rappi: asunto "Rappi, diez años de estados financieros", un resumen de tres líneas y la tabla completa en el cuerpo del mensaje.What comes next#
The same data covers verifying a company before signing, screening against sanctions lists, following court cases or checking public procurement. Every case is in solutions, and every source in /mcp.
Join the community#
If you built your first analysis, tell us which company you used. The Croma community is on WhatsApp, where we share prompts, answer questions and announce the next workshops.