Analysis of Shopify Inc.’s Q2 2026 10-Q
Filing dated 5 August 2026 for the quarter ended 30 June 2026
Where the filing and the story diverge
Shopify’s Q2 revenue grew 34% and operating income rose to $488M. But $1.06B of the $1.50B net income came from marking equity investments to market, after the same marks drove a Q1 loss of $581M. Transaction and loan losses rose 76% as the lending book grew 22% in six months, and the filing reports payments losses and loan losses on one line.
- Three findings: 71% of Q2 net income came from investment marks; Transaction and loan losses rose 76%, reported as one combined line; The lending book grew 22% in six months, mostly bought from partner banks. Each is set out below with the figure, where it sits in the filing and what would close it.
- What it does not show. Nothing here shows a misstatement.
- Q2 revenue
- $3,583M, up 34%
- GMV
- $115.6B, up 32%
- Operating income
- $488M
- Net income
- $1,502M
- Free cash flow
- $654M, an 18% margin
Area by area: what is solid and what is stretched
Shopify has no debt, quick receivables and large cash. The risk sits in how much reported profit depends on investment marks, and in a lending book and loss line growing faster than revenue.
Three findings, ranked by importance
Each is set out in full below: what the filing shows, the numbers, the evidence and what would close it.
71% of Q2 net income came from investment marks
Net income of $1,502M included $1,063M of gains from marking equity investments to market. Without them, Shopify’s own measure puts net income at $439M. The same marks swung the other way in Q1, which implied a loss of $581M.
Net other income, including taxes, was $1,014M in Q2, about two-thirds of pre-tax income (our calculation), driven by $1,250M of net gains on equity and other investments. Six-month net income was $921M, so Q1 must have been a $581M loss (our calculation) on the same holdings. Q2 operating cash flow was 0.44 times net income because the gains are non-cash; over six months it was 1.24 times, which is healthy. The business is generating cash; it is the GAAP net income line that moves with the portfolio.
The earnings release shows the marks and a non-GAAP net income excluding them; the 10-Q gives six-month net income.
Transaction and loan losses rose 76%, reported as one combined line
Transaction and loan losses reached $141M against $80M a year earlier. The income statement combines payments losses and Shopify Capital credit losses; the loan note shows $81M of credit-loss provision, up from $42M.
No standard tag exists at this combined level, so Shopify uses its own. The split has to be read from Note 6: credit-loss provision of $81M (against $42M), which leaves about $60M of payments and transaction losses (our calculation). Net charge-offs rose to $59M from $35M. Allowance coverage on the loan book held steady at about 10% (9.98% against 9.85%), so provisioning has not loosened. The point is the speed: losses are growing faster than merchant revenue as the lending book scales.
Income statement for the combined line; Note 6 for the credit-loss provision, charge-offs and allowance.
The lending book grew 22% in six months, mostly bought from partner banks
In Q2, Shopify bought or originated $1,584M of loans and cash advances and collected $1,417M. Purchases from partner banks were $1,400M of that, up from $1,000M a year earlier.
Gross loans and cash advances reached $2,426M, against $1,979M a year earlier. Loan interest and fee income rose to $91M from $62M. From April, cash flows for merchant cash advances moved from operating to investing activities, which keeps operating cash flow on a lending-consistent basis but means comparisons need care. The book is still small against $10.9B of cash and investments, but it is the fastest-growing source of risk on the balance sheet.
Note 6 and the cash flow statement in the earnings release.
Other findings, checked and set aside
Each item was tested against the filing. None changes the lead findings above.
| Item | What the filing shows, and why it is not a lead finding |
|---|---|
| XBRL: the combined loss line | Shopify uses its own tag for transaction and loan losses because no standard tag combines them; the split is only visible in the loan note. |
| XBRL: one investment line, several measurement bases | Two custom tags tie to the same caption: $4,854M in total and $3,299M carried at fair value. Use the smaller figure for anything “at market”. |
| XBRL: equity-paid revenue cluster | Custom tags track deferred revenue, revenue recognised and investments received as consideration for services. |
| XBRL: one standard tag, two captions | The provision tag carries “credit losses on receivables” in one note and “transaction and loan losses” in another. |
| Related parties | Flexport, an equity-method investee: no revenue share earned in 2026 so far; $3M of co-marketing revenue in Q2. |
| Acquisitions | No business combination in the period. |
7 disclosures moved
10-Q Q2 2026 compared with the 10-K for 31 December 2025.
| Status | Disclosure | Before | Now |
|---|---|---|---|
| New | Share buybacks Q2 2026 vs Q2 2025 · Note 10; cash flow statement | None in Q2 2025 | $1,445M gross in Q2; Class A shares down 14.7M since December |
| New | Buyback authorisations Note 10 | — | $2.0B in Q1 plus $3.0B in Q2, $5.0B in total |
| Changed | Merchant cash advance cash flows Cash flow statement footnote | Operating activities | Investing activities from April 2026 |
| Changed | Transaction and loan losses Q2 2026 vs Q2 2025 · Income statement | $80M | $141M |
| Changed | Loans and merchant cash advances, net Balance sheet | $1,784M at Dec 31 | $2,184M |
| Changed | Accumulated other comprehensive income Balance sheet | $1M | $(7)M on hedge losses |
| New | COO employment agreement Exhibit 10.1 | Not present | Effective 1 August 2026 |
Shopify started buying back shares at scale, moved cash-advance flows into investing, and its losses line grew fastest of any cost.
5 markers for 3 November
Set before the numbers, so the read can be checked afterwards.
| Marker | Now | Gap widens if | Gap closes if | Result |
|---|---|---|---|---|
| Q3 revenue growth | Guided low-thirties %; Q2 was 34% | Growth falls below the low thirties | Growth lands in or above the guide | Closed |
| ResultQ3 revenue grew 32% to $3,742M, within the low-thirties guide. Source: Shopify Q3 2026 results release and Form 10-Q, 3 Nov 2026. | ||||
| Transaction and loan losses | 5.07% of merchant revenue in Q2 | The ratio rises again | The ratio stabilises or falls | Closed |
| Resulttransaction and loan losses fell to $120M from $148M a year earlier and $141M in Q2, while merchant revenue kept growing, so the ratio fell. The credit-loss provision on the loan book dropped to $63M from $81M in Q2. Source: Shopify Q3 2026 results release and Form 10-Q, 3 Nov 2026. | ||||
| Investment marks | 71% of Q2 net income | Marks again make up most of net income, or turn it into a loss | Net income excluding investments grows with operating income | Closed |
| Resultequity investments marked down by $122M after tax, cutting net income to $462M; excluding them, net income rose to $584M from $367M, growing with operating income. The swing from a $1,063M gain in Q2 to a loss in Q3 shows why the marks need separating. Source: Shopify Q3 2026 results release and Form 10-Q, 3 Nov 2026. | ||||
| Lending book | $2,184M, up 22% in six months | Book growth speeds up while losses rise | Growth slows with allowance coverage near 10% | Closed |
| Resultloans and cash advances grew to $2,350M from $2,184M in June, a slower pace than the first half, while net charge-offs held at $59M. Allowance coverage eased to about 9.5% of the gross book from about 10%. Source: Shopify Q3 2026 results release and Form 10-Q, 3 Nov 2026. | ||||
| Free cash flow margin | 18% in Q2; guided high teens to low twenties | Margin falls below the high teens | Margin lands in or above the guide | Closed |
| ResultQ3 free cash flow was $816M, a 22% margin, at the top of the high-teens to low-twenties guide. Source: Shopify Q3 2026 results release and Form 10-Q, 3 Nov 2026. | ||||
These are monitoring checks set before the numbers, not forecasts of a loss or breach.
How the read is scoring
Markers and promises set before the numbers, marked as results come in.
| Type | Item | Set before the numbers | Result |
|---|---|---|---|
| Marker | Q3 revenue growth | Guided low-thirties %; Q2 was 34% | Closed Q3 revenue grew 32% to $3,742M, within the low-thirties guide. Source: Shopify Q3 2026 results release and Form 10-Q, 3 Nov 2026. |
| Marker | Transaction and loan losses | 5.07% of merchant revenue in Q2 | Closed transaction and loan losses fell to $120M from $148M a year earlier and $141M in Q2, while merchant revenue kept growing, so the ratio fell. The credit-loss provision on the loan book dropped to $63M from $81M in Q2. Source: Shopify Q3 2026 results release and Form 10-Q, 3 Nov 2026. |
| Marker | Investment marks | 71% of Q2 net income | Closed equity investments marked down by $122M after tax, cutting net income to $462M; excluding them, net income rose to $584M from $367M, growing with operating income. The swing from a $1,063M gain in Q2 to a loss in Q3 shows why the marks need separating. Source: Shopify Q3 2026 results release and Form 10-Q, 3 Nov 2026. |
| Marker | Lending book | $2,184M, up 22% in six months | Closed loans and cash advances grew to $2,350M from $2,184M in June, a slower pace than the first half, while net charge-offs held at $59M. Allowance coverage eased to about 9.5% of the gross book from about 10%. Source: Shopify Q3 2026 results release and Form 10-Q, 3 Nov 2026. |
| Marker | Free cash flow margin | 18% in Q2; guided high teens to low twenties | Closed Q3 free cash flow was $816M, a 22% margin, at the top of the high-teens to low-twenties guide. Source: Shopify Q3 2026 results release and Form 10-Q, 3 Nov 2026. |
6 questions, checked against the call
Raised by the 10-Q. To be tested again at Q3 results on 3 November.
Investor relations: Investor Relations, Shopify Inc. · IR@shopify.com
What this does and does not show
Only $3.3B of the $4.85B investment line is at market value
The “equity and other investments” caption mixes fair-value equity stakes with private holdings, convertible notes and term deposits measured on other bases; about $1.6B is not at market.
Not tested on a call in this read.
What would resolve this: The mix is disclosed in one table each quarter.
Revenue paid in equity stakes
Some partners pay for services with equity; Shopify recognised $13M of such revenue in Q2 and held $124M of related deferred revenue.
Not tested on a call in this read.
What would resolve this: The partner arrangements and amounts are disclosed.
Subscription visibility
Monthly recurring revenue grew 19.5% to $221M while total deferred revenue grew about 4% since December.
Not tested on a call in this read.
What would resolve this: Deferred revenue keeps pace with recurring revenue.
Nothing here shows a misstatement.
Shopify has no debt, operating cash flow is healthy over six months, and loan-loss coverage has held steady.
- Net income excluding investments grows with operating income
- The loss ratio stabilises
- Lending growth slows with steady coverage
- Revenue lands in the guided range
- Investment marks drive another swing in net income
- The loss ratio keeps rising
- The lending book accelerates while losses rise
- Free cash flow margin falls below the guide
Every figure ties back to the filing
Helmledgers reads the full filing, including the notes, and ties every figure to the statement or note it comes from, with each number re-checked against the source before release. This is an accounting read of public SEC filings, not an audit opinion and not investment advice.
- Severity
- High: material effect on cash, debt or reported results. Medium: worth tracking, smaller or less certain effect.
- On the call
- Direct answer, Partly answered (topic addressed, figure missing), Sidestepped (raised but not answered) or Not asked.
- Since the read
- Confirmed by a later disclosure, Escalated (grown since), Open (untested) or Missed (not flagged by the read).
- Said versus done
- Kept, Slipped (late), Changed (plan or terms changed), Missed or Reversed.
- Markers
- Measurable checks set before results, each with what would widen or close the gap. Scored after the next results.
- Closes if
- The evidence that would resolve a finding.
Helmledgers and its analysts hold no position in Shopify (SHOP) securities.
This is an accounting read of public SEC filings. It is not an audit opinion and not investment advice.