Shopify POS accounting and ERP integration
Connect Shopify POS to QuickBooks Online, Business Central or Dynamics GP
Shopify POS runs the counter well. What it does not do is give your controller a clean daily posting into the general ledger. We build that connection, and we build it as a supported product rather than a one-off script.
The gap between Shopify POS and your accounting system
Retailers who move to Shopify POS usually discover the same thing in month one. The stores are running fine, the inventory is unified, and the books have quietly become a manual job. Someone is exporting a report every morning, splitting tenders by hand, guessing at cost of goods, and reconciling gift card liability in a spreadsheet.
Shopify does not close this gap and has little reason to. The boundary between the point of sale and the general ledger is where the accounting rules live, and those rules are yours, not Shopify’s. It is also the boundary we have been working on since 2000.
Our Shopify POS accounting integrations post what a retail controller actually needs: daily sales summaries by store and department, tender type reconciliation with cash variance, cost of goods sold, inventory valuation movements, gift card and loyalty liability, and intercompany where you run multiple entities.
Connectors
What we connect Shopify POS to
QuickBooks Online
Shopify POS to QuickBooks Online posting: daily sales journals by store and department, tenders, cost of goods, inventory values, gift card liability and sales tax. Built on the same engine as our existing QuickBooks Online connectors on the Intuit App Store.
Dynamics 365 Business Central
Two-way Shopify POS and Business Central integration. Items, pricing and inventory out to Shopify, store sales, tenders, costs and customers back into BC. Purchasing and receiving stay in Business Central.
Dynamics GP
For retailers not ready to leave GP. Sales posting, inventory movements and item master sync between Shopify POS and Dynamics GP, using integrations we have had in client production for years.
Scope
What gets posted
| Area | What flows | Why it matters |
|---|---|---|
| Daily sales | Sales summary journal by store, department and tax code | Store level profit and loss without a month end reconstruction |
| Tenders | Cash, card, gift card, store credit, split payments and cash variance | Bank reconciliation matches the deposit, and cash shortages surface daily |
| Cost of goods | COGS posting at the cost carried in your accounting system | Gross margin by store is accurate rather than estimated |
| Inventory | Valuation movements, transfers, adjustments and shrink | The balance sheet inventory number is defensible at year end |
| Liabilities | Gift card and loyalty balances | Unredeemed liability is tracked instead of discovered |
| Customers | Customer and house account records where applicable | Accounts receivable for trade counters and wholesale pickup |
Pricing
Shopify POS integration pricing
One accounting or ERP posting connection is included in the Multi-Store Shopify POS migration package.
QuickBooks Online
QBO posting connector
From $3,900
plus subscription from $195 per month
- Chart of accounts and department mapping
- Daily sales, tender and cost of goods posting
- Sales tax and gift card liability handling
- Parallel run and sign-off with your accountant
Business Central
BC integration
From $6,500
plus subscription from $345 per month
- Two-way item, price and inventory sync
- Store sales, tenders and cost posting into BC
- Customer and house account sync
- Purchasing and receiving stay in Business Central
Dynamics GP
GP integration
From $6,500
plus subscription from $345 per month
- Sales and inventory posting into Dynamics GP
- Item master synchronisation
- Built on integrations already in client production
- A migration path to Business Central when you are ready
Questions
Shopify POS accounting integration FAQ
Does Shopify POS integrate with QuickBooks Online?
Not natively at the level a controller needs. Shopify can push order level data through third party apps, but daily sales summaries by store and department, tender reconciliation, cost of goods and inventory valuation are not handled out of the box. That is exactly what our Shopify POS to QuickBooks Online connector does.
How does Shopify POS integrate with Dynamics 365 Business Central?
We build a two-way integration: item master and pricing flow from Business Central to Shopify, and store sales, tenders, cost of goods, inventory movements and customer records flow back. Purchasing and receiving stay in Business Central where they belong.
What does a Shopify POS accounting integration cost?
The QuickBooks Online posting connector starts at $3,900 and a Business Central or Dynamics GP integration starts at $6,500. One accounting or ERP posting connection is included in our Multi-Store migration package at $18,500.
Can you post store sales by location and department?
Yes. That is the point. Daily sales summaries are posted by store and by department so your store level profit and loss is real rather than reconstructed from a spreadsheet at month end.
Do we still need the integration if we only have one store?
Usually yes, but it is simpler. Even a single store generates daily tenders, cash variances, gift card liability and cost of goods that someone otherwise keys in by hand every morning.
Related pages
Shopify POS migration services
Fixed-price migration from any legacy POS to Shopify POS
Retail Management Hero to Shopify POS, by people who know RMH
Move off unsupported Dynamics RMS onto a web based POS
Two week fixed-fee audit of an existing Shopify POS setup
Stop keying your store sales in by hand
Tell us how many stores you run and what you keep your books in. We will show you exactly what the daily posting would look like.