The Client: Urban Roots
Urban Roots is a direct-to-consumer (D2C) brand specializing in organic, artisanal food products. Started by a passionate foodie from her home kitchen, the brand had grown rapidly through word-of-mouth and a popular Instagram presence. They were selling across their own Shopify store and multiple online marketplaces like Amazon. While sales were booming, the financial back-end of the business was in chaos. The founder was drowning in spreadsheets, struggling to track inventory, and had no clear idea of her actual profitability.
The Challenge: The Perils of Rapid, Uncontrolled Growth
Urban Roots was a victim of its own success. Their rapid growth had completely outpaced their operational and financial infrastructure. The founder was a brilliant product creator and marketer, but the financial complexity of running a multi-channel e-commerce business was becoming overwhelming.
Key Challenges:
- Inventory Chaos: Inventory was tracked manually on a spreadsheet. This led to frequent stockouts of popular items (lost sales) and over-ordering of slow-moving products (tied-up cash).
- Zero Visibility into Profitability: The founder knew her revenue, but had no idea of her true profit margins. She couldn't accurately calculate the Cost of Goods Sold (COGS) for each product, nor could she determine the profitability of each sales channel after accounting for marketplace fees, shipping, and marketing costs.
- Reconciliation Nightmare: Manually reconciling payments from multiple gateways (Shopify Payments, Amazon, etc.) with bank statements was taking days each month and was prone to errors.
- Inability to Plan: Without reliable financial data, she couldn't make strategic decisions about which products to promote, which channels to invest in, or how to price new items.
The Solution: Building a Financial Foundation for a D2C Brand
Urban Roots engaged Nexa Consultancy to bring order to their financial chaos. We focused on implementing the fundamental systems and reporting necessary to run a modern D2C business effectively.
Phase 1: Clean-Up and System Implementation (Months 1-2)
The first step was to move away from spreadsheets and build a single source of truth.
- Accounting System Setup: We implemented a cloud-based accounting system and integrated it directly with their Shopify store and bank accounts. This automated the process of recording sales and expenses.
- Historical Bookkeeping Cleanup: Our team undertook the painstaking process of cleaning up six months of historical transactions, accurately categorizing every sale and expense to create a reliable financial baseline.
- Inventory Management System: We helped them select and implement a dedicated inventory management software that synced with both Shopify and their accounting system. For the first time, they had real-time visibility into stock levels across all locations.
Phase 2: Process Automation and Reporting (Months 3-6)
With the core systems in place, we focused on automation and generating actionable insights.
- Automated Reconciliation: We set up rules and processes to automate the reconciliation of payments from different channels, reducing a multi-day manual task to a few hours.
- COGS and Margin Analysis: Using the new inventory and accounting systems, we were able to calculate the precise COGS for each SKU. We then built a report that showed the gross margin for every single product and every sales channel. This was a revelation for the founder, who discovered that some of her best-selling products were barely profitable on certain marketplaces due to high fees.
- Monthly MIS Reporting: We delivered a concise monthly MIS report that went beyond a simple P&L. It included key D2C metrics like Average Order Value (AOV), Customer Acquisition Cost (CAC), and repeat purchase rate. We also included a channel profitability analysis, which clearly showed which sales channels were driving the most profitable growth.
Phase 3: Strategic Decision-Making (Months 7-12)
With accurate data at her fingertips, the founder could finally make strategic, data-driven decisions.
- Pricing Strategy Overhaul: Armed with the margin analysis, she adjusted her pricing on several products and strategically removed unprofitable SKUs from high-fee marketplaces, immediately boosting overall profitability.
- Optimized Marketing Spend: By understanding channel profitability, she was able to reallocate her marketing budget away from low-margin channels and double down on the ones that were driving the most value, significantly improving her return on ad spend (ROAS).
- Inventory Planning: Using historical sales data from the new systems, we helped her create an inventory forecast. This allowed her to optimize purchase orders, dramatically reducing both stockouts and the amount of cash tied up in slow-moving inventory.
