Connecting Shopify to AccBooks AI

Overview

The Shopify integration automatically imports your store’s orders, payouts, refunds and fees into AccBooks — so your eCommerce revenue and costs are always reconciled without manual data entry.

Connecting Shopify

1. Go to Settings → Integrations → Shopify.
2. Click Connect Shopify store.
3. Enter your Shopify store URL (e.g., yourstore.myshopify.com).
4. You’re redirected to Shopify’s OAuth page. Log in to your Shopify admin.
5. Grant AccBooks read access to your orders, payouts and customers.
6. You’re redirected back to AccBooks. The integration status shows Active.

AccBooks imports the last 90 days of order history on first connection.

What gets imported

Shopify item	AccBooks treatment
Orders (paid)	Creates sales income in your Revenue account
Shopify Payments payouts	Creates a bank transaction in the Shopify holding account
Shopify fees	Posted to Merchant charges expense account
Refunds	Creates a negative entry matching the original order
Shipping revenue	Posted to Delivery income account
Gift cards sold	Held as deferred income until redeemed
Gift cards redeemed	Released from deferred income to revenue

Nominal code mapping

AccBooks creates a Shopify holding account nominal code (similar to the Stripe integration). Order revenue flows through this account and is cleared when Shopify sends payouts.

Configure the mapping under Settings → Integrations → Shopify → Nominal codes:

• Product revenue (by category if needed)
• Shipping revenue
• Shopify fees
• Refunds
• Shopify holding account

VAT and Shopify

If you’re VAT-registered and collect VAT through your Shopify store:

• AccBooks imports the VAT element of each order separately.
• VAT is posted to your output VAT account (code 2200).
• The net revenue (ex-VAT) is posted to your sales account.

Configure under Settings → Integrations → Shopify → VAT handling.

Multi-currency Shopify stores

If you sell in multiple currencies, AccBooks converts each transaction to GBP using the exchange rate on the order date. Shopify payouts in foreign currencies are treated as foreign currency bank transactions.

Order-level reporting

AccBooks stores individual order data, enabling:

• Revenue by Shopify product category.
• Return rate analysis.
• Average order value over time.
• Geographic revenue breakdown (by shipping country).

Go to Reports → Shopify analytics for these reports.

Inventory integration (optional)

If you use Shopify’s inventory management, AccBooks can track cost of goods sold (COGS) by:

• Importing your product costs from Shopify.
• Calculating COGS per order based on items sold.
• Posting COGS journals automatically.

Enable under Settings → Integrations → Shopify → Inventory and COGS.

Reconciling Shopify payouts

AccBooks reconciles Shopify payouts automatically — matching them to the corresponding transactions when they appear in your bank feed. Any discrepancy (e.g., Shopify deducted more fees than expected) is flagged in the reconciliation queue.

Disconnecting Shopify

Go to Settings → Integrations → Shopify → Disconnect. Historical Shopify data is retained in AccBooks.

Shopify and Making Tax Digital

AccBooks includes Shopify revenue in your VAT return calculations automatically. If your store sells to both UK and EU consumers, the system tracks which transactions attract UK VAT (domestic or zero-rated exports) and flags EU transactions for separate OSS reporting.