Skip to main content
Free & Open Source — No $229/mo middleware needed

The Shopify Integration That Paid Apps Charge $229/mo For.
Yours Free.

66 actions across 15 domains. Clearing-account reconciliation. Every order, fee, refund, payout, and gift card posted to your books -- automatically. No middleware. No monthly fees. No lock-in.

66
Actions
15
Domains
11
Tables
$0
Cost / Year

Why Not Just Use A2X?

A2X and similar paid Shopify accounting apps charge $29-229/month to sync your store to QuickBooks or Xero. Here is what you actually get for that money -- and what you get for free.

Feature Paid Shopify Apps ERPClaw
Price $29–229/month $0 forever
Middleware Yes (syncs to QBO/Xero) No (native ERP integration)
COGS tracking Premium tier only Built-in
Gift card accounting Basic Automatic deferred revenue
Payout reconciliation Summary journals Transaction-level + clearing account
Multi-location COGS No Yes
Custom GL rules No Fully configurable
Source code Proprietary Open-source

How It Works

Other apps need you to connect Shopify to QuickBooks to your bank. ERPClaw needs one sentence.

Chat with ERPClaw
You:
I sell through Shopify
ERPClaw:
Got it. I'll set up Shopify integration. What's your store URL and API token?
You:
mystore.myshopify.com / shpat_abc123...
ERPClaw:
Connected. 11 tables created. Syncing your Shopify data now.
-- 1,247 orders synced
-- 89 refunds synced
-- 156 payouts synced
-- GL entries posted for all transactions
-- Shopify Clearing account balance: $0.00 (fully reconciled)
You:
Show me my COGS by product category
ERPClaw:
COGS breakdown (last 90 days):
Apparel: $18,400 | Accessories: $6,200 | Home: $3,100
Total COGS: $27,700 | Revenue: $89,300
Gross margin: 69.0%

Key Features

Auto-Sync

Orders, refunds, payouts, and adjustments sync automatically from Shopify. No manual downloads, no CSV imports, no third-party middleware sitting between your store and your books.

Clearing Account Pattern

Every order posts to a Shopify Clearing account. When Shopify sends the payout, the clearing account zeros out. If it doesn't zero, something is wrong -- and you'll know immediately.

Automatic GL Posting

Every Shopify event creates GL entries. Orders post revenue and COGS. Fees post to expense. Refunds reverse. Gift cards create deferred revenue. No manual journal entries.

COGS Tracking

Cost of goods sold calculated and posted automatically for every order line item. Multi-location inventory? ERPClaw tracks COGS per warehouse, not just a global average.

Gift Card Accounting

Gift card sales post to Deferred Revenue (a liability). When redeemed, the liability reduces and revenue is recognized. Proper GAAP treatment, fully automated.

Dispute Handling

Shopify chargebacks automatically create reserve entries. Won disputes reverse the reserve. Lost disputes write off the receivable. Full audit trail either way.

GL Posting Rules

Most Shopify accounting apps hide their journal logic. We publish ours. Trust but verify.

Event Debit Credit
Order Shopify Clearing + Shopify Fees + COGS Revenue + Inventory
Refund Revenue + Inventory Shopify Clearing + COGS
Payout Bank Account Shopify Clearing
Fee Shopify Fees (Expense) Shopify Clearing
Gift Card Sale Shopify Clearing Deferred Revenue (Liability)
Dispute Dispute Reserve Shopify Clearing

The Clearing Account Pattern

Shopify collects money from your customers, deducts fees, and deposits the rest into your bank 2-3 days later. The clearing account tracks every dollar in transit so nothing falls through the cracks.

1

Order placed

Customer pays $100 on Shopify
DR Shopify Clearing $95 / CR Revenue $100, Fees $5 to Expense
2

Shopify holds funds

Clearing account balance: $95
3

Payout sent

Shopify deposits $95 to your bank
DR Bank Account $95 / CR Shopify Clearing $95
4

Reconciled

Clearing account balance: $0
Clearing account = $0.00 -- fully reconciled

If the clearing account is not zero, it means Shopify owes you money, or there is a transaction that hasn't been matched. Either way, you'll know immediately -- no month-end surprises.

Every Industry, Not Just E-Commerce

Paid Shopify accounting apps only serve e-commerce stores. ERPClaw serves everyone who sells through Shopify.

Medical Practice

Selling medical supplies through a Shopify storefront

School

Selling uniforms, books, and supplies via Shopify

Construction Company

Selling materials and equipment through Shopify

Food & Beverage

D2C food sales with perishable inventory tracking

Retail Brand

Multi-channel retail with Shopify as the primary storefront

Nonprofit

Selling merchandise and accepting donations via Shopify

The Open Source Advantage

Read our code. Run our tests. See exactly how every Shopify order becomes a GL entry.

70
Shopify-specific tests
9,457
Total project tests
6
Validation gates passed

No Vendor Lock-in

If A2X raises prices or shuts down, your accounting integration disappears. With ERPClaw, you own everything -- data, code, and configuration. Self-hosted on your machine, backed by an open-source community.

Technical Specs

Tables
11 dedicated tables (shopify_order, shopify_payout, shopify_refund, etc.)
API Key
Private app credentials -- only permissions ERPClaw needs, nothing more
Storage
API credentials encrypted at rest in ERPClaw's credential vault
SDK
shopify Python package auto-installed on first use
Webhook
Webhook endpoint auto-configured for real-time order and payout sync
Idempotency
Every Shopify event processed exactly once (order ID deduplication)

Stop paying $229/month for something that should be free.

Install ERPClaw and say:

"I sell through Shopify"
Also using Stripe? See ERPClaw for Stripe