The Challenge

Daiane Pitta runs a thriving baby products retail business. The store offers everything families need—diapers, hygiene products, and baby care items—with a focus on personalized service and community connection. For years, the business served its customers well. But behind the scenes, something was broken.

The financial picture was a mess. Data lived in multiple places: the point-of-sale system, spreadsheets, bank statements, and handwritten notes. No single source of truth existed. When Daiane tried to understand profitability, she found conflicting numbers. One system showed expenses at 37,000 for a month. Another showed 54,000. Which was real? Nobody knew.

Pricing was equally chaotic. Products were marked up by a flat percentage—usually 30%—without considering the actual cost of doing business. Taxes, freight, and operating expenses weren't factored in. The result? Many items sold at negative margins. The more Daiane sold, the more money she lost.

Cash flow was a constant crisis. Suppliers demanded payment upfront. Customers paid on credit. The gap between outflows and inflows created a perpetual squeeze. Some months showed a deficit of 40,000 or more. Daiane couldn't tell if the business was actually profitable or slowly dying.

"I didn't have a clear picture of what was really happening," Daiane recalls. "I was making decisions based on gut feeling, not numbers. That's no way to run a business."

The core issue wasn't lack of effort. Daiane worked tirelessly. The problem was lack of visibility. Without reliable financial data, she couldn't make smart decisions about pricing, inventory, or growth. The business had potential, but it was trapped by its own disorganization.

The Solution

Daiane knew something had to change. She brought in a consultant to help rebuild the financial foundation from scratch. The goal was simple: create a system where numbers were reliable, decisions were data-driven, and growth was sustainable.

The transformation started with cash flow. A structured daily cash tracking spreadsheet was created. Every transaction—every sale, every payment—was recorded with a date, description, amount, and category. This wasn't glamorous work, but it was essential. Within weeks, the real picture emerged. The discrepancies between systems became visible. More importantly, Daiane could now see her actual cash position each day.

Next came the Demonstração de Resultado (DRE)—the income statement. Instead of relying on one system, the team built an integrated approach. Data flowed from the point-of-sale system into Excel. Expenses were classified consistently using a standardized menu. A pivot table automatically aggregated the numbers. The result fed directly into the DRE. No more manual calculations. No more errors.

But the biggest breakthrough came with pricing. The consultant introduced a new model: the CLD method (Custo, Lucro, Despesas—Cost, Profit, Expenses). Instead of a simple markup, pricing now accounted for:

• The actual cost of goods
• Freight and handling
• Taxes (including ICMS and substitution tax)
• Operating expenses (rent, utilities, payroll)
• Desired profit margin

For the first time, Daiane could see exactly what each product needed to sell for to be profitable. A diaper that appeared to have a 30% margin actually had a negative margin once taxes and overhead were included. The new model revealed these hidden losses immediately.

The team also built a separate spreadsheet for tax calculations. ICMS substitution tax (ST) was computed product-by-product and incorporated into the cost base. This was critical for a business operating under the Simples Nacional tax regime. The math was complex, but the spreadsheet made it automatic.

"Once I saw the real numbers, everything changed," Daiane says. "I realized I was pricing myself out of business. The new model showed me exactly what I needed to charge to actually make money."

Reconciliation became a weekly ritual. The cash flow spreadsheet was compared against bank statements. Discrepancies were investigated and resolved. The DRE was cross-checked against actual payments. Over time, the numbers converged. Trust in the data grew.

The consultant also helped with the human side. Daiane and her team received training on the new systems. Responsibilities were clarified. A regular cadence of financial reviews was established. The message was clear: financial discipline wasn't optional. It was the foundation of everything.

The Transformation

The results came quickly. Within a few months, the picture shifted dramatically.

Cash flow improved. The deficit that had reached 40,000 in June shrank to 15,000 in July. By August, the business was nearly at break-even. By September, the team projected a positive cash position. This wasn't luck. It was the result of better pricing, tighter cost control, and visibility into where money was actually going.

Profitability returned. With pricing corrected, margins became healthy. Products that had been sold at a loss were repriced. The business moved from operating with negative or razor-thin margins to achieving margins in the 10-15% range on the CLD basis. For a retail business, this was sustainable.

Daiane gained confidence. "Now I know exactly what's happening," she says. "I can see the cash, I understand the margins, and I can make decisions with confidence. That's worth everything."

The team also discovered unexpected insights. Certain products were far more profitable than others. Some suppliers offered better terms than others. The data revealed opportunities for negotiation and optimization that had been invisible before.

Beyond the numbers, something else shifted. The business moved from reactive to proactive. Instead of scrambling to cover shortfalls, Daiane could plan. She could forecast cash needs. She could negotiate with suppliers from a position of strength. She could invest in growth because she understood the financial impact.

The community connection deepened too. With stable finances, Daiane could focus on what she did best: serving families. She launched a "Rede de Apoio" (support network) program—bi-weekly meetings for mothers to share parenting tips and advice. The store became more than a retail location. It became a trusted community hub.

Looking ahead, the foundation is solid. The systems are in place. The team understands the numbers. The next phase is growth. With reliable financial data and disciplined pricing, Daiane can scale confidently. New products, new marketing initiatives, and expanded hours are all on the horizon.

"This transformation wasn't just about fixing numbers," Daiane reflects. "It was about taking control of my business. Now I'm not just working in it—I'm actually running it. And that makes all the difference."

The journey from chaos to clarity took time and discipline. But it proved one thing: when you have reliable data and a clear system, growth becomes possible. For Daiane Pitta, that clarity is just the beginning.