The Challenge

Distribuidora de Embalagens Castropil operates a network of distribution centers and retail locations, serving customers across multiple regions. The company's strength lies in its ability to serve diverse markets and maintain strong customer relationships. However, behind the scenes, the financial and operational infrastructure was struggling to keep pace with growth.

The core problem was fragmentation. Financial data lived in multiple places—spreadsheets, legacy systems, and disconnected databases. Each location operated with its own processes. There was no unified view of profitability by unit. When leadership needed to understand how a specific store was performing, or whether a location was truly profitable after accounting for shared costs, the answer took weeks to assemble and was often unreliable.

"We had data everywhere, but we didn't have information," one finance leader explained. "We couldn't see which units were actually making money. We couldn't allocate costs fairly. And we couldn't make decisions fast enough."

The consequences rippled through the organization. Pricing decisions were made without clear margin visibility. Cost allocation was inconsistent, making some units appear profitable while others looked like drains on resources. Leadership couldn't confidently answer basic questions: What's our break-even point by location? Which units should we invest in? Where are we losing money?

Beyond the numbers, the manual work was exhausting. Month-end closes took weeks. Reconciliation between different reporting systems created endless loops of rework. The finance team spent more time chasing data than analyzing it. And with multiple locations, multiple cost centers, and complex tax situations across states, the complexity only grew.

The Solution

Castropil's leadership recognized that growth required a different approach. They needed to move from reactive, manual processes to a system-driven, data-informed operation. The decision was clear: build a unified financial reporting framework that would give every leader visibility into their unit's true performance.

The transformation started with three foundational moves.

First: Unified Data Architecture

The team implemented automated data consolidation, pulling information directly from the ERP system (Proteus) and creating a single source of truth. Instead of manual spreadsheet transfers, data now flows automatically into a consolidated DRE (income statement) that reflects each unit's performance. A dashboard was built to display results by unit and by time period, making it easy to spot trends and compare performance across locations.

"Once we had one version of the truth, everything changed," a finance director noted. "We stopped arguing about the numbers and started using them to make decisions."

Second: Structured Cost Allocation

The company implemented a formal rateio (cost allocation) framework. Shared costs—logistics, back-office functions, administrative overhead—are now allocated to each unit based on clear, documented rules. This replaced the ad-hoc approach that had distorted unit profitability for years.

The impact was immediate. Units that appeared unprofitable suddenly showed positive margins once costs were allocated fairly. Other units revealed hidden inefficiencies. For the first time, leadership could see the true economics of each location.

Third: Process Standardization and Governance

Beyond the numbers, the company established a formal cadence for financial reporting. Monthly closes now follow a standardized process. Data validation happens at each step. Organograms were updated. Job descriptions were clarified. Training programs were rolled out to ensure everyone understood the new processes.

This wasn't just about finance. The company unified its credit and financial departments, reallocated roles to eliminate bottlenecks, and created clear accountability for each process. A new employee was hired specifically to manage bank reconciliation, reducing dependence on any single person.

"The biggest shift was moving from 'that's how we've always done it' to 'here's the process, here's who owns it, and here's how we measure success,'" a team member reflected.

The Transformation

The results came quickly and in multiple dimensions.

Immediate Wins

Data quality improved dramatically. Discrepancies between systems were resolved. One location's data that had been misallocated for months was corrected, immediately improving the accuracy of unit-level reporting. Pending credit and cadastral issues that had accumulated were nearly eliminated through better process discipline.

The finance team's workload shifted. Instead of spending 60% of their time chasing data, they now spend that time analyzing it. Month-end closes that once took weeks now happen with greater confidence and speed. The QR code system for payment registration added another layer of control and visibility.

Strategic Clarity

With unit-level profitability now visible, leadership could ask—and answer—the hard questions. Break-even analysis by location became possible. The company could see which units needed investment, which were mature, and which required restructuring. Pricing decisions could now be made with full visibility into margins and cost structures.

The consolidated DRE revealed that certain shared costs were disproportionately burdening specific units. By reallocating these costs fairly, some units moved from appearing unprofitable to showing healthy margins. This single insight changed the conversation about which locations to keep, which to invest in, and which to consolidate.

Operational Discipline

Beyond finance, the standardization created a ripple effect. Processes became documented and repeatable. New hires could be trained faster. Handoffs between departments improved. The company reduced its dependence on individual knowledge holders. When someone left, their work didn't disappear—it was documented and transferable.

The leadership team also shifted. With clear data and defined processes, management became more data-driven and less personality-driven. Decisions were debated based on facts, not opinions.

Foundation for Growth

Perhaps most importantly, Castropil now has the infrastructure to scale. The automated data flows, standardized processes, and clear accountability mean that adding new locations or expanding existing ones no longer creates chaos in the back office. The company can grow without proportionally increasing its finance and administrative burden.

"We went from managing by crisis to managing by plan," a senior leader said. "That's the real transformation. We can now think about the future instead of just surviving the present."

The journey isn't finished. The company continues to refine its cost allocation models, deepen its analysis of unit-level profitability, and explore opportunities like logistics optimization and process automation. But the foundation is solid. Leadership has visibility. Processes are standardized. Data is trusted.

For a company built on serving customers across multiple locations, that clarity is everything. It's the difference between growth that's managed and growth that's chaotic. And it's the platform on which Castropil's next chapter will be built.