Pablo Vasconcellos Leal: From Financial Chaos to Data-Driven Growth
Pablo Vasconcellos Leal, a multi-segment retail and services business, faced a critical challenge: fragmented financial data across multiple business units made it impossible to understand true profitability or make informed decisions. Through a comprehensive financial transformation focused on data standardization, system integration, and disciplined reporting, the company gained clarity on unit-level performance, improved cost allocation, and built the foundation for sustainable, data-driven growth across all segments.
The Challenge
Pablo Vasconcellos Leal operates a diverse portfolio of retail and service businesses—from mobility solutions to artisan goods, jewelry, and antiques—all under a single corporate structure. On the surface, the company was thriving. Sales were strong. Customer traffic was steady. The business had momentum.
However, beneath that success lay a troubling reality: nobody truly understood which segments were profitable.
Financial data was scattered across multiple systems, spreadsheets, and manual processes. Different business units used different tools. Expense allocations were inconsistent. Revenue recognition varied by segment. When leadership tried to answer basic questions—"Is MOB actually profitable?" or "What's the real margin on this product?"—the answers were unclear, contradictory, or simply unavailable.
"Our finances were bagunçada," one team member described it. Disorganized. Chaotic. The company was running on sales momentum, not financial clarity.
This fragmentation created real problems. Cross-subsidization between segments went undetected. Pricing decisions were made without understanding true costs. Cash flow forecasting was guesswork. And worst of all, leadership couldn't allocate resources strategically because they didn't know which units deserved investment and which were draining capital.
The company needed more than better spreadsheets. It needed a complete financial transformation.
The Solution
The transformation began with a clear diagnosis: before making any strategic decisions, the company needed to see the truth in its numbers.
The team implemented a comprehensive financial framework built on three core pillars: data standardization, system integration, and disciplined reporting.
First, they unified their data architecture. Multiple legacy systems were consolidated into a single ERP platform with modular profiles for each business segment. This wasn't just a technical upgrade—it created a single source of truth. Every transaction, from the moment it occurred, flowed into one system. No more reconciling between spreadsheets and software. No more wondering which version was correct.
Second, they redesigned how financial data was classified and tracked. The team created standardized expense categories, separated freight costs from merchandise costs, and implemented clear cost allocation rules. They built unit-level income statements (DREs) for each segment—MOB, Casino, Grupo Fronteira, and others—so leadership could see exactly how each business was performing.
"We needed to know if each segment could stand on its own two feet," the leadership explained. The new structure made that visible.
Third, they established disciplined monthly closing processes. Bank reconciliations became routine. Accounts receivable and payable were tracked with precision. Data entry followed standardized rules. Weekly alignment meetings ensured consistency and caught errors early.
The commitment from the top was absolute. Leadership understood that financial clarity was non-negotiable. Every team member involved in data entry, from finance to operations, received training on the new processes. The company assigned clear ownership—designating specific people responsible for data quality and reporting cadence.
"Once we could see the real numbers, everything changed," a team member reflected. "We stopped guessing and started deciding."
The Transformation
The results came quickly and compounded over time.
Visibility became the first win. Within weeks, leadership could see unit-level profitability. They discovered which segments were truly profitable and which were consuming resources. They identified products with unexpectedly low margins once freight, taxes, and all costs were factored in. They spotted cash flow patterns they'd never seen before.
Cost allocation improved dramatically. By separating fixed and variable costs, allocating shared expenses proportionally, and tracking costs by segment, the company gained precision in understanding unit economics. Pricing decisions could now be based on actual costs, not assumptions.
Cash flow forecasting became reliable. With bank accounts separated by segment and reconciliations happening monthly, the company could project cash needs with confidence. They could plan for seasonal variations. They could negotiate better terms with suppliers and lenders because they had data to back up their requests.
Decision-making accelerated. What once took weeks of manual reconciliation now took days. Leadership could review performance, identify issues, and act—all within a monthly cycle. The company began testing pricing strategies, promotional campaigns, and inventory adjustments with real data to measure results.
Beyond the numbers, something deeper shifted. The organization developed a culture of financial discipline. Data quality became a point of pride. Teams understood how their work contributed to the company's financial health. Decisions were no longer based on intuition or hope—they were grounded in facts.
The company also built capacity for the future. With clean data and standardized processes in place, they could now layer on more sophisticated analyses: margin optimization by product, ROI tracking for marketing campaigns, scenario planning for growth initiatives.
"We went from managing by the seat of our pants to managing by the numbers," leadership reflected. "And that's changed everything about how we think about growth."
The transformation wasn't just about fixing the past. It was about building the foundation for sustainable, profitable expansion. With financial clarity as their compass, Pablo Vasconcellos Leal could now pursue growth with confidence—knowing exactly which opportunities would drive real value and which would just add complexity.
The journey continues. But for the first time, the company is walking it with eyes wide open.
Your management works better when you know exactly what to do
Let's clarify your priorities and build what really matters for your company.
- Consulting focused on your business's real challenges
- Measurable results, not empty promises
- Direct method you can apply
- Data that shows the right path
- Solutions built for your specific context