Working Capital for Shopify Brands: The Real Playbook

Working capital is the cash a business has to fund operations after paying short-term debts. It equals current assets minus current liabilities. For Shopify brands, it is dominated by inventory tied up in 60-90 day purchase orders, Shopify Payments payout lag, and ad spend funded weeks before revenue lands — not the textbook treasury model most guides describe.

What is working capital?

Working capital is current assets minus current liabilities. It measures how much short-term cash a business has after settling short-term debts. A positive number means the business can cover near-term obligations. A negative number means short-term debts exceed liquid assets, which often signals a cash crunch is coming.

The textbook formula looks clean on paper. Most guides from JPMorgan, Investopedia, and similar treasury-focused outlets explain it through the lens of corporate manufacturers with 90-day receivables and steady supplier terms. That model does not match how a Shopify brand actually operates.

For DTC brands, working capital lives in four places: cash in the operating bank, Shopify Payments balance in transit, inventory in the 3PL, and prepaid ad spend on Meta and Google. The liabilities side is dominated by supplier POs in production, sales tax owed across nexus states, and credit card balances funding ad spend.

The brand above has $295,000 in working capital. That sounds healthy until you realize the next PO deposit is $150,000 and Q4 ad spend ramp will burn $80,000 in the next 30 days. Working capital is a snapshot. The cash conversion cycle is the movie.

Takeaway: A Shopify brand's working capital number means nothing without context on the next PO, the payout lag, and the ad spend ramp. The four-line balance sheet view hides the timing problem that actually kills DTC brands.

How do you calculate working capital for a Shopify store?

Working capital equals current assets minus current liabilities. For a Shopify store, current assets include cash, Shopify Payments balance in transit, inventory at landed cost, and prepaid expenses. Current liabilities include supplier AP, sales tax payable, gift card liability, accrued ad spend, and short-term credit card debt.

The current assets line for DTC

• Cash and equivalents — operating accounts at Mercury, Brex, or a traditional bank.
• Shopify Payments in transit — the balance between sale capture and payout. The Shopify Help Center guide to payouts confirms standard payout cycles run 1-3 business days depending on region.
• Inventory at landed cost — units at the 3PL valued at full landed cost, including freight, duties, and inbound handling. See our guide on landed cost for the full calculation.
• Accounts receivable — wholesale invoices outstanding, marketplace balances (Amazon, Faire), and chargeback recoveries.
• Prepaid expenses — annual SaaS subscriptions (Klaviyo, Gorgias, Recharge), insurance, prepaid freight.

The current liabilities line for DTC

• Accounts payable — open supplier POs, freight forwarder invoices, agency retainers.
• Sales tax payable — accrued sales tax owed across nexus states. We use Bookkeep for sales tax accrual across the 100+ Shopify stores Ottit closes books for.
• Gift card liability — unredeemed gift card balance, which is deferred revenue until used.
• Accrued ad spend — Meta and Google charges incurred but not yet billed to the card.
• Credit card balances — Ramp, Brex, or Amex balances funding ad spend and SaaS.
• Customer deposits — preorder balances and Recharge subscription prepayments not yet shipped.

The calculation is mechanical once the chart of accounts is set up correctly. The hard part is making sure each line is actually on the balance sheet. Gift card liability gets missed constantly. Sales tax payable is often understated. Accrued ad spend rarely appears outside accrual-basis books.

Takeaway: Pull the working capital calculation from a clean balance sheet, not a quick QuickBooks export. If gift card liability, sales tax payable, and accrued ad spend are missing, the number is wrong by tens of thousands.

Why does working capital matter more for Shopify brands than for traditional businesses?

Working capital matters more for Shopify brands because the DTC cash cycle has more friction than traditional retail. Inventory POs require 30-50% deposits months before goods arrive. Ad spend must be funded weeks before revenue lands. Shopify Payments holds 1-3 days of revenue in transit. Each step locks up cash that can't fund the next round of growth.

A traditional manufacturer sells on net-60 terms and gets net-30 from suppliers. The cash cycle is roughly neutral. A Shopify brand sells to consumers who pay instantly via Shopify Payments, but the cash sits in transit while suppliers demand deposits 60-90 days before goods land in the 3PL.

Here is what the cycle looks like for a typical DTC brand running a 90-day overseas manufacturing lead time:

1. Day 0 — Pay 30% PO deposit to overseas supplier. Cash leaves the bank.
2. Day 60 — Pay 70% PO balance before goods ship. More cash out.
3. Day 75 — Pay inbound freight, duties, and customs broker.
4. Day 90 — Inventory lands at ShipBob, becomes sellable.
5. Day 90-120 — Fund Meta and Google ad spend to drive traffic.
6. Day 90-150 — Sales happen. Shopify Payments captures cash.
7. Day 93-153 — Payouts hit the bank account, 3 days after sale.
8. Day 105-165 — Sales tax remitted, AP cleared, cycle restarts.

From PO deposit to cash back in the bank, the cycle can run 100-150 days for a brand sourcing overseas. During that entire window, working capital is locked up. A brand growing 50% year over year needs proportionally more working capital each cycle just to maintain inventory depth.

This is why profitable Shopify brands run out of cash. The P&L can show 22% net margins while the bank balance trends toward zero because every dollar of profit immediately gets recycled into a bigger PO and a bigger ad budget.

Takeaway: The DTC cash cycle is structurally cash-hungry. Brands that don't model the PO-to-payout window will hit a cash wall around the second or third growth cycle, regardless of profitability.

What ratios actually predict cash crunches for ecommerce brands?

The generic 2:1 current ratio benchmark is misleading for Shopify brands. The ratios that actually predict cash crunches are the cash conversion cycle, the inventory-to-cash ratio, and weeks of operating cash on hand. These metrics capture timing — which is where DTC working capital problems live.

Why the 2:1 current ratio fails for Shopify brands

Most generic guides cite 2:1 as the healthy current ratio benchmark. That number assumes inventory is liquid and convertible to cash within the operating cycle. For a Shopify brand sitting on 90 days of inventory at the 3PL, the inventory line is not nearly as liquid as cash. A brand can show a 2.5:1 current ratio and still miss payroll because all the assets are stuck as units in Texas.

Why the cash conversion cycle wins

The cash conversion cycle (CCC) measures how many days cash is tied up from supplier payment to customer collection. For a Shopify brand, the formula adapts to the DTC reality:

A 43-day CCC means cash is locked for roughly six weeks between paying suppliers and collecting from customers. To grow 50%, the brand needs roughly 50% more working capital to fund a 50% larger inventory PO over that same cycle. This is the math that determines whether a brand can self-fund growth or needs financing from Wayflyer or a similar capital provider.

Takeaway: Replace the 2:1 current ratio with the cash conversion cycle as the primary working capital health metric. Track it monthly. A rising CCC is the earliest warning sign of a cash crunch.

How do you record working capital transactions in QuickBooks?

Working capital transactions span the PO cycle, payout sync, and accrual entries. Most Shopify brands miss the prepaid inventory and accrued ad spend entries entirely, which understates current liabilities and overstates working capital. Here are the journal entries that matter.

PO deposit to overseas supplier

The deposit lives as Prepaid Inventory, not as inventory or COGS, until goods arrive. This keeps the balance sheet honest about what is sellable versus what is just cash sitting overseas.

Inventory receipt at landed cost

Shopify payout sync

Shopify Payments captures the sale, holds the balance 1-3 days, then deposits the net to the bank. The correct entry separates gross sales, fees, refunds, and the in-transit balance. We use Bookkeep for revenue recognition and payout sync across the 100+ Shopify stores Ottit closes books for monthly.

The Shopify Payments Clearing account is the in-transit balance that sits on the current asset side of working capital. It gets cleared when the payout hits Mercury 1-3 days later.

Takeaway: Working capital accuracy depends on accrual-basis bookkeeping with proper prepaid inventory, accrued freight, and sales tax payable entries. Cash-basis books understate liabilities and overstate working capital. The cash vs accrual choice matters more than most operators realize.

How do Shopify brands fund working capital gaps?

When working capital tightens, Shopify brands typically pull from four sources: retained earnings, revenue-based financing, supplier term extensions, and corporate credit cards. The right mix depends on the cash conversion cycle, gross margin, and growth rate. Each option has tradeoffs that show up on the balance sheet.

Revenue-based financing

Wayflyer and similar capital providers fund inventory POs and ad spend against future revenue. Typical terms are 6-12% fee for 4-6 month repayment, paid as a percentage of daily Shopify sales. For a brand with a 45-day CCC and 60% gross margin, this can be cheaper than equity dilution. For a brand with a 90-day CCC and 35% gross margin, it can compound into a debt spiral.

Corporate credit cards and net-terms cards

Cards from Ramp and Brex offer 30-day float on ad spend and SaaS, effectively giving the brand a month of free working capital on every dollar of operating expense. For a brand spending $200,000 a month on Meta ads, that 30-day float is $200,000 of working capital without interest, as long as the balance gets paid in full each cycle.

Supplier term extensions

Once a Shopify brand has 12+ months of order history with a supplier, negotiating from 30% deposit / 70% pre-shipment to 20% / 50% / 30% net-30 can free up significant working capital. A brand running $2M in annual POs that moves from full prepayment to net-30 on 30% of the balance frees roughly $50,000 of working capital per cycle.

Takeaway: Stack working capital sources by cost and flexibility. Use card float first because it is free. Use supplier terms next because they reduce the prepaid inventory line directly. Use revenue-based financing only when gross margin and CCC math support it.

What working capital benchmarks do healthy Shopify brands hit?

Healthy Shopify brands typically run a current ratio of 1.3-1.8, a cash conversion cycle of 30-60 days, and 8-16 weeks of operating cash on hand. These ranges are tighter than generic SMB benchmarks because DTC operates on faster inventory turns and shorter receivables cycles than traditional retail or B2B.

Early-stage brands run tighter on every metric because they have less operating history and less inventory depth. Growth-stage brands often hit a working capital wall around the $1-3M ARR range, when inventory POs start outpacing organic cash generation. Established brands have the leverage to negotiate supplier terms and the cash buffer to fund growth without external capital.

Subscription-heavy brands using Recharge tend to run lower working capital ratios because they collect cash before fulfilling. A subscription brand with 60% of revenue on auto-renewal can operate with a current ratio below 1.0 and still be perfectly healthy, because the deferred revenue line acts as a permanent float of customer prepayments.

Takeaway: Benchmark against the right stage. A $2M brand comparing itself to a $20M brand's working capital ratios will draw wrong conclusions. The cash conversion cycle and weeks of cash on hand matter more than the current ratio at every stage.

How do you build a working capital forecast for a Shopify brand?

A working capital forecast projects current assets and current liabilities over the next 13 weeks based on planned POs, payout timing, ad spend, and operating expenses. The output is a weekly cash balance forecast that flags when the brand will hit minimum cash thresholds, typically 6-8 weeks in advance.

The 13-week cash forecast model

1. Start with opening cash — actual bank balance plus Shopify Payments in transit.
2. Layer in weekly Shopify revenue by SKU and channel, net of refunds and processing fees, using Triple Whale or Northbeam attribution data to model the ad-to-revenue lag.
3. Subtract weekly fixed costs — payroll, rent, SaaS (Klaviyo, Gorgias, Recharge, Shopify Plus).
4. Subtract weekly variable costs — 3PL fees, shipping, returns processing, ad spend.
5. Add PO cash outflows with deposit and balance dates from supplier contracts.
6. Add freight and duty outflows roughly 60-75 days after PO deposit.
7. Add sales tax remittance by state, on the actual filing calendar for each jurisdiction.
8. Flag any week where ending cash falls below the minimum threshold — typically 6-8 weeks of operating expenses.

The forecast is rebuilt weekly. Actuals replace projections. The 13-week window is short enough to be accurate and long enough to spot problems before they become emergencies. Most Shopify brands we work with at Ottit run this model in a spreadsheet with QuickBooks data feeding it via a sync tool — Bookkeep or similar.

Takeaway: A 13-week working capital forecast is the single most useful financial tool for a Shopify operator. It catches PO timing problems, ad spend over-runs, and sales tax surprises before they become cash crunches. Update it weekly with actuals.

Related Reading

• Contribution Margin for Shopify Brands: The Real Playbook — how to calculate the margin that funds working capital.
• Landed Cost for Shopify Brands: The Real Playbook — getting inventory valuation right on the balance sheet.
• Break Even Point for Shopify Brands: The Real Formula — the revenue threshold that turns working capital positive.
• Cash vs Accrual Accounting: The Shopify Reality — why accrual books are the only way to measure working capital accurately.
• Profit and Loss Statement for Ecommerce — the P&L structure that ties back to working capital changes.

Sources

• the Shopify Help Center guide to payouts
• the A2X documentation for Shopify accounting
• the Bill.com accounts-payable platform
• the Ramp corporate card and spend platform