Company Financials

Import guide for key financial metrics of Portfolio Companies

A Portfolio Company needs to implement 5 API endpoints to import its data into AIRR automatically. The Organisation team then adds the URLs of these endpoints in General Settings -> Company Connections. A scheduled process in AIRR downloads the data from these endpoints once a day into AIRR and saves a new record every time a new data comes up.

AIRR supports multiple currencies for that API (the portfolio companies can submit their metrics in any currency they want, and those will be converted into the reporting currency of your Organisation in AIRR).

All API endpoints have to be protected with login and password and support Basic Auth. The response format should be json, in accordance with the endpoints described below. HTTPS is optional.

Get Revenue LTM

GET https://your_portfolio_company_website.com/revenue_ltm

Returns cumulative revenue for your Portfolio Company for the last twelve months.

Headers

Name	Type	Description
Accept	string	application/json
Authorization	string	Basic HTTP authorisation header

200

{
    revenue: 100000000,
    date:2020-01-01,
    currency: USD
}

Get EBITDA LTM

GET https://your_portfolio_company_website.com/ebitda_ltm

Returns cumulative EBITDA for your Portfolio Company for the last twelve months.

Headers

Name	Type	Description
Authorization	string	Basic HTTP authorisation header
Accept	string	application/json

200

{
    ebitda_ltm: 50000000,
    date: 2020-01-01,
    currency: USD
}

Get Net Income LTM

GET https://your_portfolio_company_website.com/net_income_ltm

Returns cumulative Net Income for your Portfolio Company for the last twelve months

Headers

Name	Type	Description
Authorization	string	Basic HTTP authorisation header
Accept	string	application/json

200

{
    net_income_ltm: 1000000,
    date: 2020-01-01,
    currency: USD
}

Get Cash on Account

GET https://your_portfolio_company_website.com/cash

Returns total amount of cash on account for your Portfolio Company.

Headers

Name	Type	Description
Authorization	string	Basic HTTP authorisation header
Accept	string	application/json

200

{
    cash: 4000000,
    date: 2020-01-01,
    currency: USD
}

Get Debt Outstanding

GET https://your_portfolio_company_website.com/debt

Returns total amount of all outstanding loans of your Portfolio Company.

Headers

Name	Type	Description
Authorization	string	Basic HTTP authorisation header
Accept	string	application/json

200

{
    debt: 500000,
    date: 2020-01-01,
    currency: USD
}