Shopify Bookkeeping Best Practices for Sage 50 Users

A Shopify business is not a traditional retail business. Your customers are everywhere, your inventory moves differently, your payment processing is complex, and your financial data is scattered across Shopify, your payment gateway, and Sage 50.

Applying traditional bookkeeping practices to a Shopify business doesn't work. You end up with a chart of accounts that hides important information, revenue that's double-counted, inventory that doesn't reconcile, and tax liability that's a surprise.

This post is a comprehensive guide to structuring your Sage 50 accounting for a Shopify business.

In this post:

• Chart of accounts for e-commerce
• Recording sales and revenue
• Handling discounts and refunds
• Inventory methods for e-commerce
• Tax handling and compliance
• Reconciliation cadence and methods
• Audit trail preservation
• Year-end preparation
• FAQ

Chart of Accounts for E-Commerce

Your chart of accounts should reflect the flow of money in a Shopify business, not a brick-and-mortar retail business.

Revenue Accounts

Create separate accounts for each revenue stream:

4100 — Shopify Sales (or 4100–4110 for multiple stores/channels) 4200 — Discounts and Promotions (Contra-revenue) 4210 — Refunds (Contra-revenue) 4220 — Gift Card Sales (If you offer gift cards)

Cost of Goods Sold (COGS)

5100 — Cost of Goods Sold (only if you track COGS for manufacturing or drop-shipping businesses)

Operating Expenses

6100 — Payment Processing Fees (Merchant Fees) 6110 — Shopify Platform Fee (Monthly subscription) 6120 — Fulfillment and Shipping 6200 — Advertising and Marketing 6210 — Salaries and Wages 6300 — Packaging and Supplies 6400 — Shipping and Postage (Actual shipping costs paid)

Asset & Liability Accounts

1100 — Cash | 1200 — Accounts Receivable | 1300 — Inventory 2100 — Accounts Payable | 2200 — Sales Tax Payable | 2210 — Gift Card Liability

Recording Sales and Revenue

The Right Way: Full Order Detail

When a Shopify order comes in, your accounting should record the full picture:

Debit: Bank $54.19
Debit: Merchant Fees Expense $1.81
Credit: Sales Revenue (4100) $55.00
Credit: Sales Tax Payable (2200) $4.50

The Wrong Way: Net Recording

Don't post the net amount to sales. This understates revenue and overstates profit.

Handling Discounts and Refunds

A discount is an incentive. A refund is a return. Record them separately so you can track both rates.

Customer buys $100 with $10 coupon:
Debit: Bank/AR $90
Debit: Discounts (4200) $10
Credit: Sales Revenue (4100) $100

Inventory Methods for E-Commerce

Perpetual: Track inventory quantity and value continuously. Use this if you have a Shopify-integrated system (like Sagify Inventory Sync).

Periodic: Count inventory at month-end. Use this if inventory is simpler.

With Sagify, perpetual is simpler because inventory syncs automatically.

Tax Handling and Compliance

Create a Sales Tax Payable account for each state where you have nexus. Reconcile to Shopify's tax report monthly. For Canada, track GST/HST separately.

Reconciliation Cadence and Methods

Daily (optional): Compare Shopify orders to Sage 50 transactions. Weekly: Reconcile Shopify order total to Sage 50 sales total. Monthly: Bank reconciliation (critical) and inventory reconciliation.

Audit Trail Preservation

Link every Sage 50 entry to the original Shopify order. Use Sage 50's built-in audit log. Archive supporting documents for 7 years.

Year-End Preparation

November: Run YTD P&L, reconcile all balance sheet accounts, calculate estimated tax. December 1–20: Process final orders, collect final invoices, reconcile inventory. December 21–31: Complete final bank reconciliation, generate trial balance. After 12/31: Post closing entries, generate final statements.

---

Ready to implement best practices for your Shopify business? Book a free demo and we'll review your current setup and identify gaps.

Related Reading

• Month-End Close Checklist for Shopify Stores - Detailed monthly procedures
• How to Reconcile Shopify Payouts in Sage 50 - Payout reconciliation guide
• How to Sync Sage 50 and Shopify Inventory - Inventory reconciliation
• How to Import Shopify Orders into Sage 50 - Order import methods
• Your Top Questions About Sagify, Answered - Setup and configuration
• Shopify Sage 50 Integration: The Complete Guide - Pillar guide that ties all the practices together
• Is Sage 50 Good for a Shopify Business? - Why Sage 50 remains the right backbone