The finance decisions Shopify founders actually face
Shopify founders usually know their traffic and conversion well and their margin less well. The gross margin in the Shopify dashboard is a starting point, not the answer. Once an order has been fulfilled, some of it returned, payment fees charged, and its share of paid acquisition, platform fees and apps taken off, the real contribution margin per order is lower than the dashboard suggests. Contribution margin is what a sale leaves you after the costs that come with it.
The decisions that follow all depend on that real number: which channels to push, which products to reorder, how much stock to buy for the next peak, and how much marketing spend the business can afford. As your Fractional CFO, William makes that number visible by channel, by SKU and by group of customers who joined in the same month, then uses it in the budget, the scenarios and the board pack. When you raise, the same numbers become the base for debt and equity raising.
How do you build management accounts from your Shopify data?
Start from the payouts, not the dashboard. Shopify payouts arrive net of fees, refunds and chargebacks, so each one has to be broken back into sales, fees and returns before it reaches the accounting system. Then the costs from every other tool are matched to the same month and the same channel.
Shopify brands tend to run on a similar set of tools: Shopify for orders, a 3PL (an outsourced warehouse) for fulfilment, Klaviyo for email and SMS, one or two paid channels such as Meta, Google or TikTok, a returns platform, a payment processor such as Shopify Payments or Stripe, often a subscription app for repeat orders, and an attribution tool on top. Each one produces data, and almost none of it lines up with Xero or QuickBooks on its own. Many brands already use a connector app that posts Shopify payouts into the accounting system as summarised entries. We work with whatever you have in place.
Our job is to set up that reconciliation cleanly, agree one source for each KPI, and turn the result into monthly management accounts with CFO commentary. The data becomes useful rather than impressive: one P&L, one margin view by channel, one set of numbers everyone trusts.
The two numbers we watch hardest in a Shopify brand's accounts
Two numbers shape the next twelve months for a Shopify brand. The first is blended CAC payback: how long, on a contribution margin basis, the average new customer takes to repay what it cost to win them. CAC (customer acquisition cost) is total marketing spend divided by the new customers it brought in. The second is the cash conversion cycle: the time between paying a supplier for stock and being paid by the customer who buys it. For a Shopify brand it is driven mostly by stock, not by customers paying late, and it sets how fast the brand can grow on its own cash.
We report both every month in the management accounts, next to the P&L, so a rising payback or a slowing stock turn shows up before it hits the bank balance. Fjor, the D2C skincare brand William co-founded and ran as CFO and COO, cut CAC by 90% while he was there. Read the Fjor case study.
How do you forecast cash for a Shopify brand?
Build the forecast from the stock plan outwards. Stock orders, supplier deposits and freight leave the bank weeks or months before the sales they fund, and peaks such as Black Friday pull that cash out even earlier. Shopify payouts then arrive in small daily or weekly amounts, net of fees and refunds.
We build a rolling 12-month cash forecast that includes every stock purchase, your supplier terms, marketing spend by month and the timing of Shopify payouts, then check it against actuals every month. You see the cash pinch points early and know whether the next production run or marketing push is affordable. This is part of our Fractional CFO service. For how this fits the wider picture, see fractional CFO for consumer brands and our D2C and Shopify service.