EXECUTIVE OVERVIEW
Bottom-line health of the business across the active selection.
Revenue
—
—
Costs
—
—
Net Profit
—
—
Margin
—
vs. revenue
Collected
—
—
CxC · Receivable
—
—
Paid Costs
—
—
Pending Costs
—
—
Clients
—
Projects
—
Avg profit / client
—
Retainer revenue
—
—
Best client by profit
—
—
Worst client by profit
—
—
CLIENT PROFITABILITY
Who pays the bills · who quietly drains them.
TOP 10 CLIENTS BY PROFIT
BOTTOM 10 CLIENTS BY PROFIT
REVENUE vs MARGIN · bubble = profit (cost for losses)
profit loss low margin (<35%)
WARNING LIST · clients with negative or low margin
| Client | Revenue | Profit | Margin | Flag |
|---|
ALL CLIENTS · sortable
| Client | Revenue | Cost | Profit | Margin | Projects | CxC |
|---|
PROJECT PROFITABILITY
Project-name drift can distort these numbers — see warning list below.
⚠ Project profitability assumes that revenue and costs share the same PROYECTO text. Variants like
"Proyecto: X" vs "X" will appear as two projects. Use the warnings table to spot these.
TOP 10 PROJECTS BY PROFIT
BOTTOM 10 PROJECTS BY PROFIT
PROJECTS WITH COST · NO REVENUE
| Project | Client | Cost |
|---|
PROJECTS WITH REVENUE · NO COST
| Project | Client | Revenue |
|---|
MONTHLY TREND
Revenue, costs, profit and margin over time.
REVENUE · COST · PROFIT BY MONTH
MARGIN % BY MONTH
CxC & PENDING COSTS BY MONTH
COLLECTION & PAYMENT STATUS
Liquidity view · what's in the account vs. what's still in the air.
REVENUE BY STATUS
COSTS BY STATUS
PENDING REVENUE · CxC
| Client | Project | NCF | Amount |
|---|
PENDING COSTS
| Supplier | Client | Project | Amount |
|---|
SUPPLIER & COST ANALYSIS
Where the money goes once we win the job.
TOP 15 SUPPLIERS BY COST
COST BY ROLE / POSITION
COST BY CATEGORY
SUPPLIER LEDGER · sortable · pending balances flagged red
| Supplier | Paid | Pending | Total cost | Projects | Avg / project |
|---|
FIXED / RETAINER REVENUE
Rows tagged FIJO · the predictable backbone.
Total retainer revenue
—
Retainer clients
—
Project-based clients
—
RETAINER REVENUE BY CLIENT
RETAINER REVENUE BY MONTH
OC · PENDING PURCHASE ORDERS
Sheet OC abril · separate, not merged into main profitability.
This module shows requested costs that are not yet fully integrated in the main accounting.
Treat these as forward commitments. They are not deducted from profit above.
Total OC value
—
—
Clients involved
—
Suppliers involved
—
OC COST BY CLIENT
OC COST BY SUPPLIER
OC DETAIL
| Client | Project | Supplier | Position | Status | Amount |
|---|
AUTOMATED INSIGHTS
Generated from the current selection. Updates with filters.
DETAILED LEDGER
Every line, searchable and sortable. Negative profit in red.
| Year | Month | Client | Project | NCF | Supplier | Position | Category | Revenue | Cost | Profit | Status | Fixed | Source |
|---|
—
1