Northline Coffee — July Revenue Walk: Shopify to QuickBooks (2026-07)

Northline Coffee — July Revenue Walk: Shopify to QuickBooks (2026-07) A data-flow diagram generated by Mosofin. 01 / Shopify (orders SoT) 02 / Deductions 03 / Net sales 04 / QuickBooks (books SoT) Gross sales · Shopify order total · 01 / Shopify (orders SoT) · amount: unknown · Shopify Gross sales Shopify order total amount: unknown Sales tax collected · liability · 02 / Deductions · not revenue Sales tax collected liability not revenue Gift cards sold · deferred · 02 / Deductions · not revenue Gift cards sold deferred not revenue Refunds + discounts · contra revenue · 02 / Deductions · Shopify Refunds + discounts contra revenue Shopify Net sales · gross − contra · 03 / Net sales · recognized basis Net sales gross − contra recognized basis Stripe fees · expense line · 03 / Net sales · below revenue · Stripe Stripe fees expense line below revenue Revenue · QuickBooks P&L · 04 / QuickBooks (books SoT) · books SoT Revenue QuickBooks P&L books SoT Sales tax payable · balance sheet · 04 / QuickBooks (books SoT) Sales tax payable balance sheet Gift card liability · balance sheet · 04 / QuickBooks (books SoT) Gift card liability balance sheet tax collected pass-through gift cards pass-through less refunds + discounts contra = net sales Shopify recognized accrual fees are an expense Stripe remit later liability until redeemed liability Legend money contra / deduction timing difference account

Why the dashboards differ

  • • Shopify shows gross sales including tax and gift cards
  • • Stripe shows net payouts after fees
  • • QuickBooks revenue is net sales — the only number to sign off

Guardrails

  • • Every node is a Shopify or QuickBooks fact; nothing is estimated
  • • Amounts are tagged unknown: none were supplied for 2026-07
  • • Fees reduce cash, not revenue

Brief

  • • Entity: Northline Coffee LLC · accrual
  • • Orders SoT: Shopify · Books SoT: QuickBooks
  • • Audience: controller