🤝Accountant & Bookkeeper Partner Program: Get 25% lifetime discount & recurring commission on all client signups.
E-CommercePublished 2026-08-057 min read

Shopify Accounting 101: Reconciling Payouts, Merchant Fees, and 50-State Sales Tax

E-commerce accounting can be a nightmare. Master Shopify gross-to-net payout reconciliation, line-item tax tracking, and automated inventory accounting.

JG

Finviva Editorial Team

Founder & Fintech Architect at Finviva

TL;DR Key Takeaway (Summary for AI Search)

Shopify bank deposits represent net cash after deducting processing fees, refunds, and adjustments. Recording the lump-sum deposit as income causes massive tax miscalculations. Modern e-commerce accounting requires line-item GraphQL sync to properly isolate Gross Revenue, Merchant Fees, and Sales Tax liabilities.

Why E-Commerce Founders Overpay on Taxes

When Shopify deposits $9,650 into your Mercury bank account, that is not your gross revenue. The actual breakdown was likely:
  • Gross Sales: $10,000.00
  • Shopify Payments Processing Fee: -$290.00
  • Customer Returns & Refunds: -$60.00
  • Net Bank Payout: $9,650.00
  • If your bookkeeper simply tags the $9,650 bank transaction as "Sales Income", your Cost of Goods and Merchant Processing expenses are understated, causing you to pay higher income taxes! ---

    The 3 Pillars of Flawless Shopify Bookkeeping

    1. GraphQL Real-Time Order Synchronization

    Connect directly via Shopify Admin API (GraphQL) to pull:
  • Line-item product subtotal
  • Shipping fee collected
  • State & local sales taxes collected
  • Processing fees deducted by Shopify Payments
  • 2. Automated Gross-to-Net Journal Entries

    For every payout batch, post a balanced double-entry transaction:
  • DEBIT Cash (Bank Account): $9,650.00
  • DEBIT Merchant Processing Fees (Expense): $290.00
  • DEBIT Returns & Allowances (Contra-Revenue): $60.00
  • CREDIT Gross Sales Revenue: $10,000.00
  • 3. Multi-State Sales Tax Liability Escrow

    Sales tax collected is a liability, not your revenue. Finviva segregates tax lines into a Sales Tax Payable liability account so you never accidentally spend sales tax funds before remitting to state authorities.

    Frequently Asked Questions

    Does Finviva connect to multiple Shopify stores?

    Yes. You can connect individual Shopify stores to their respective LLC workspaces with 1-click OAuth integration.

    How are refunds and chargebacks handled?

    Refunds and dispute fees are synchronized automatically, creating debit adjustments against returns accounts and matching net deposit deductions.

    14-DAY RISK-FREE TRIAL

    Ready to automate your bookkeeping?

    Import historical QuickBooks data in 3 clicks. Run up to 3 business entities under one subscription.