Technology · Data and BI

KPIs your company reviews every week. And that change what it does.

BI projects, performance dashboards and management by KPIs and OKRs for small and midsize businesses (SMBs) and multinational subsidiaries: from your data sources all the way to the results review meeting.

KPIsOKRsDashboardsBI projects

From spreadsheet to dashboard

Same number. A different conversation.

Drag to compare the spreadsheet that gets passed around by email with the dashboard everyone checks. The data is the same; what changes is the time it takes to reach a decision.

results_v3_FINAL_revised.xlsx3 versions in email

	Aug	Sep	Oct
Revenue	1,312,400	1,298,770	#REF!
Cost	-842,110	-851,300	-839,020
Margin	35.8%	34.5%	?
Past due	4.1%	=B7/B2	5.2%
Cash	—	see statement	188,230

Manually updated Oct 12Who edited it last?

SpreadsheetDashboard

KPIs and OKRs

KPIs show the health of the business. OKRs show where it's headed.

We define a handful of KPIs per area, each with a formula, a source and an owner, and tie the most important ones to the quarter's objectives.

Quarterly OKR · example

Objective: profitable growth

KR1 · Contribution margin from 34% to 38%70%

KR2 · Past-due rate below 3%45%

KR3 · Recurring revenue at 40% of total85%

Every key result has an owner, weekly tracking and an end-of-quarter review.

Business Intelligence Projects

Your business on a dashboard, not in a spreadsheet.

We build BI dashboards connected to your company's data sources, with automatic data refresh and role-based access. Explore a sample Solidy financial dashboard, with an automated tour of its key views.

Connected to your ERP and other data sources

Automatic data refresh

Role-based access, from the owner to each manager

Company Name

Accounts ReceivablePast DueScoreCollectionsKPIsResults (P&L)

Total receivableR$ 0164 invoices

Past dueR$ 0rate 4.26%

Total not yet dueR$ 095.7% of total

Average invoiceR$ 8.4Kper invoice

DSO38.2 daysaverage collection period

Past-due rate4.26%total portfolio

Top 10 accounts receivable

Alfa DistribuidoraR$ 162K
Beta TecnologiaR$ 118K
Cobalto ServiçosR$ 96K
Delta LogísticaR$ 81K
Eixo ComércioR$ 52K
Fênix AlimentosR$ 47K
Gama SaúdeR$ 45K
Horizonte EngenhariaR$ 43K

Top past-due customers

Lumen VarejoR$ 26K
Monte AzulR$ 10K
Norte Sul TransportesR$ 9K
Órion EducaçãoR$ 6K
Prisma DigitalR$ 4K
Quasar IndústriaR$ 3K
Rota SulR$ 1K
Sigma MédicaR$ 1K

Tier 1 · above R$ 20KR$ 986,240Customers 18 · Invoices 64 · Past due 2.4%

Tier 2 · R$ 10K to 20KR$ 204,710Customers 13 · Invoices 25 · Past due 4.8%

Tier 3 · up to R$ 10KR$ 191,460Customers 61 · Invoices 75 · Past due 10.9%

AR aging

← Past dueR$ 59K

ReferenceTODAY

Current →R$ 1.32M

Due in 91–180 days

Due in 31–60 days

Due in 16–30 days

Due in 1–15 days

1–15 days past due

16–60 days past due

60+ d past due

Customers by payment terms

Up to 30 days31 to 45 days46 to 60 days60+ days

Total receivable balanceR$ 1,382,410164 open invoices

Past-due balanceR$ 117,120as of today · 8.47%

Current past-due %8.47%of total balance

Change in period↗ +2.4 p.p.Sep: 12.1% vs Aug: 9.7%

Average days late19.8 business dayslast 90 days

Invoices paid late11.2%last 90 days (41 of 366)

Past-due trend (%)

DailyMonthlyQuarterlyAnnual

02/0909/0916/0923/0930/0907/1013/10

Receivables balancePast-due balance% past due

Past-due invoices by aging bucket

1–30 daysR$ 96K · 11 invoices
31–60 daysR$ 4K · 2 invoices
61–90 daysR$ 4K · 1 invoice
91–180 daysR$ 6K · 2 invoices
180+ daysR$ 9K · 3 invoices

Past due by segment

RetailR$ 31K
ManufacturingR$ 31K
LogisticsR$ 23K
EducationR$ 15K
TechnologyR$ 10K
HealthcareR$ 5K
ServicesR$ 3K

Past-due customers

Customer	Segment	1–30d	31–60d	61–90d	91–180d	+180d	Total overdue	Score	Credit bureau	Protests
Lumen Varejo	Retail	R$ 26,410					R$ 26,410	Score 812	Bureau-listed
Monte Azul Distribuidora	Manufacturing	R$ 22,380					R$ 22,380	Score 584	Bureau-listed
Norte Sul Transportes	Logistics	R$ 16,920					R$ 16,920	Score 312
Órion Educação	Education	R$ 14,760					R$ 14,760	Score 871
Prisma Digital	Technology			R$ 3,980	R$ 6,210		R$ 10,190	Score 12	Bureau-listed	R$ 5,400
Quasar Indústria	Manufacturing					R$ 8,870	R$ 8,870		Bureau-listed	R$ 18,300
Rota Sul Logística	Logistics	R$ 2,040	R$ 3,880				R$ 5,920	Score 552
Sigma Médica	Healthcare	R$ 4,960					R$ 4,960	Score 744
Titã Serviços	Services	R$ 3,410					R$ 3,410		Bureau-listed	R$ 2,900
Urano Comércio	Retail	R$ 1,260	R$ 1,140				R$ 2,400	Score 431

Showing 1–10 of 10 customers

Top 10 past-due customers

Lumen VarejoBureau-listedR$ 26K
Monte Azul DistribuidoraBureau-listedR$ 22K
Norte Sul TransportesR$ 17K
Órion EducaçãoR$ 15K
Prisma DigitalBureau-listedR$ 10K
Quasar IndústriaBureau-listedR$ 9K
Rota Sul LogísticaR$ 6K
Sigma MédicaR$ 5K
Titã ServiçosBureau-listedR$ 3K
Urano ComércioR$ 2K

Financial cost of late or deferred payment

Receivable3m6m1y

Customer	Invoices	Overdue amount	Average delay	Cost (CDI)
1. Quasar Indústria	3	R$ 8,870	362.0 days	R$ 1,210
2. Prisma Digital	3	R$ 10,190	104.5 days	R$ 380
3. Rota Sul Logística	3	R$ 5,920	39.2 days	R$ 72
4. Lumen Varejo	1	R$ 26,410	8.0 days	R$ 24
5. Urano Comércio	2	R$ 2,400	20.6 days	R$ 12
6. Titã Serviços	1	R$ 3,410	17.0 days	R$ 11
Total (10 customers)	16	R$ 117,120		R$ 1,730

CDI × days overdue: open and overdue invoices.

Notes on the main overdue customers

10/10Quasar Indústria: three invoices open; suspension notice sent for two of them.

09/10Prisma Digital: confirmed payment for 17/10.

08/10Rota Sul Logística: asked to extend one installment; under review.

Customers in collection litigation

lawsuits in progress, amounts from accounts receivable

Customer	Amount	Filing date
Vega Comércio	R$ 148,000	14/02/2026
Xisto Engenharia	R$ 72,300	22/07/2025
Zênite Alimentos	R$ 15,900	18/11/2025

Customers analyzed112108 active · 4 inactive

Average score641median 636 · mid range

Credit bureau exposureR$ 38.2M41 customers with debts

With adverse records41 / 11237% of the portfolio

Default · no score18 · 316% · 3%

Significant adverse records2421% need attention

Risk matrix · score × exposure

CRITICAL2220% of the portfolio

HIGH1715% of the portfolio

MEDIUM3834% of the portfolio

LOW3531% of the portfolio

⚠ 35% of the portfolio is at critical or high risk: consider reviewing credit limits.

Distribution by score range

27High35Medium18Low3Very low29No score

Exposure breakdown

by type of issue

Notary protests40.2%R$ 15.4M
Lawsuits27.1%R$ 10.4M
Overdue debts2.1%R$ 0.8M
PEFIN1.6%R$ 0.6M
REFIN1.4%R$ 0.5M
Other debts27.6%R$ 10.5M

Total receivedR$ 2.74 M358 invoices

Change+5.2%vs. previous quarter

Charges collectedR$ 3.6Klate fees, interest and inflation adjustment

Discounts grantedR$ 1.8Kdiscounts + allowances

Received lateR$ 231 K8% of receipts · 41 invoices

Customers who paid96top 5 = 37% of receipts

Top 10 customers by receipts

49.8% of receipts come from the top 10

Alfa Distribuidora
Delta Logística
Horizonte Eng.
Cobalto Serviços
Beta Tecnologia
Gama Saúde
Fênix Alimentos
Eixo Comércio
Jade Educação
Ípsilon Varejo

Receipts breakdown

installments settled + charges − discounts − withholdings

Installments settledR$ 2,738,940
+ Charges (late fees, interest, inflation adjustment)R$ 3,610
− Discounts and rebatesR$ 1,820
− Withholdings (PIS, COFINS, CSLL, IRRF, ISS)R$ 1,590
= Total receivedR$ 2,739,140

CUSTOMER	JUL	AUG	SEP	TOTAL
Jade Educação	6,210	6,210	6,210	18,630
Rota Sul	7,120	5,480	5,390	17,990
Prisma Digital	—	5,330	5,940	11,270
Total	698,420	912,760	931,580	2,542,760

Billings

Gross billingsR$ 1.31MBillings (invoices)

Growth vs. prior month−1.1%Billings (invoices)

Growth vs. prior year+8.1%Billings (invoices)

Average invoice valueR$ 7.6KBillings (invoices)

% recurring billings62.0%active contracts

Customer groups84billed in the month

Billings and client groups

BillingsCustomer groups

Profitability

Net revenueR$ 1.24MP&L

Gross margin47.3%P&L

EBITDA margin17.3%P&L

Net margin11.2%P&L

Margins

GrossEBITDANet

ManagementAccountingAdjustments

Books closed through September.

ACCOUNT	JAN	FEB	MAR	APR	MAY	JUN	JUL	AUG	SEP	T1	T2

Sample Solidy BI dashboard · fictitious names and figures

How a BI project comes together

From scattered sources to a number everyone trusts.

ERPCRMLegacy systemPayrollSpreadsheets

1IntegrationData collected and cleansed automatically

2Data modelA single source of truth, with business rules built in

3Dashboards and cadenceBy area and by role, reviewed in meetings

Management processes

A dashboard nobody reviews is just decoration. That's why we design the meeting too.

Every KPI gets a slot on the calendar, an owner and a meeting format. The dashboard opens the conversation; the minutes close it with an owner and a deadline.

Weekly

Operations meeting30 minutes on the week's KPIs and variances

Monthly

Results review meetingResults, cash and targets, with an action plan for each variance

Quarterly

OKR reviewWhat was achieved and what changes next quarter

Our approach

From the right KPI to the meeting that runs on the dashboard.

Map

KPIs and sources

What management needs to see, where each number comes from and who is accountable for it.

Build

Model and dashboards

Integration, data model and dashboards, validated with the people who will use them.

Implement

Management cadence

Meetings, targets and OKRs tied to the dashboard, with clear owners.

Improve

Monitor and adjust

New views, new KPIs and a review of whatever has stopped being useful.

All under one roof

BI from the team that also produces the numbers.

Technology

Let's talk

Bring the spreadsheet that gets passed around most at your company. We'll show you what it looks like as a dashboard.

In the first conversation, we look at the KPIs you already track, where the numbers come from and what's missing to make decisions with them.

Talk to a partner → Chat on WhatsApp

No obligationReply within 1 business dayStrictly confidential