Accounting
Sage
Connect Sage 200, Sage X3 and Sage Accounting to Shopify, WooCommerce, Magento and your 3PL. Automate orders, stock, invoices and customer data.
Post every Shopify order to Sage Accounting as an invoice, with VAT, multi-currency, payments and refunds reconciled.
A prebuilt blueprint co-built with our partner Jellywall, and part of our Shopify integration and Sage integration range on the integration platform (iPaaS) trusted by 2,000+ brands.
Supporting complex retail operations across fast-growing brands
















































The Shopify and Sage Accounting integration is a prebuilt Patchworks blueprint that posts every Shopify order to Sage Accounting (formerly Sage Business Cloud Accounting) as a sales invoice, with the customer, VAT rate, currency, payment and any refund attached. You configure it to your ledger rather than building an integration from scratch.
| Item |
|
|---|---|
| What it is |
A prebuilt Patchworks blueprint that connects Shopify to Sage Accounting.
|
| Co-built with |
Jellywall, a Patchworks certified agency partner
|
| Systems |
Shopify and Shopify Plus, including multiple stores; Sage Accounting (cloud)
|
| Who it's for |
Shopify brands that need every sale in Sage Accounting at invoice level, especially across several stores, GBP and EUR, or B2B accounts
|
| Flows |
Five flows: orders to sales invoices, customers to contacts, payments and payouts, multi-currency, and refunds to credit notes, plus VAT and product mappings
|
| Direction |
All five run Shopify → Sage, with customers matched to existing Sage contacts
|
| Triggers |
Scheduled, webhook and event-driven process flows
|
| Connection |
Shopify: prebuilt connector, via app install or Admin API access token. Sage Accounting: prebuilt connector, via OAuth 2.0
|
| Setup and implementation |
Within days for a standard setup; in-house, with Jellywall or with another agency partner
|
| How sales are posted |
One sales invoice per Shopify order, not a daily summary
|
| Currencies |
GBP and EUR as standard, where multi-currency is enabled in Sage Accounting. Further currencies are configurable
|
| Extend with AI |
AI Studio builds or changes flows from a prompt, AI Agents explain failed runs, and the MCP Server connects AI tools to your Shopify and Sage data
|
| Security / pricing |
SOC 2 and ISO 27001 / connected systems plus monthly operations, with unlimited users
|
Finance no longer rebuilds sales from Shopify payout reports. Each order becomes a sales invoice in Sage Accounting, traceable from order number to invoice to payment.
No more month-end VAT adjustments or pre-converted totals. Every invoice line carries the right Sage tax rate, and EUR orders stay in euros.
Several stores or markets no longer mean several setups. Each Shopify store posts to the same Sage Accounting business, mapped to its own ledger and bank accounts if you report them separately.
| Flow |
Direction
|
Trigger | What happens in Sage Accounting |
|---|---|---|---|
| Orders → sales invoices |
Shopify → Sage
|
When an order is paid
|
Each paid order creates a sales invoice with its line items, shipping, discounts and VAT.
|
| Customers → contacts |
Shopify → Sage
|
With each order
|
Customers are matched to existing Sage contacts, and a new contact is created only when there's no match, so duplicate accounts aren't created.
|
| Payments and payouts |
Shopify → Sage
|
With each paid order; payouts when Shopify Payments settles
|
Each payment is recorded against its invoice. Shopify Payments payouts and fees are reconciled to the right bank and ledger accounts.
|
| Multi-currency |
Shopify → Sage
|
With each order
|
Invoices are raised in the order currency, such as GBP or EUR, with the exchange rate recorded and the totals balanced in your base currency.
|
| VAT and tax rates |
Mapping
|
Applied to every invoice line
|
Shopify tax lines are mapped to Sage tax rates, including standard, reduced, zero-rated and exempt.
|
| Refunds and cancellations → credit notes |
Shopify → Sage
|
When a refund or cancellation is issued in Shopify
|
A credit note is raised and allocated against the original invoice, including partial refunds.
|
| Products and services (configurable) |
Mapping
|
Applied to every invoice line
|
Line items are matched to Sage products or services, or posted to a ledger account if you don't track products in Sage.
|
Install the Patchworks app in your Shopify store and authorise Sage Accounting through OAuth. There are no API keys to copy or rotate.
Match your VAT rates, ledger and bank accounts, currencies and stores to Sage. The blueprint ships with defaults for a standard UK setup, and any rule it doesn’t cover can be added on the visual canvas or described in AI Studio.
Run real orders through a staging environment and check the invoices, credit notes and payments in Sage before anything reaches your live books.
Flows run on a schedule or as orders happen, and every run is logged, so you can see exactly what reached Sage and when.
| Object |
Daily Summary
|
Shopify & Sage Accounting Workflow |
|---|---|---|
| What lands in Sage |
One summary entry per day or payout
|
One sales invoice per Shopify order
|
| Customers |
Usually one generic "Shopify sales" customer
|
Each customer matched or created as a Sage contact
|
| VAT |
Totals by rate
|
The VAT rate on every invoice line
|
| Refunds |
Netted off in a later summary
|
A credit note against the original invoice
|
| Currencies |
Often converted before posting
|
Invoiced in the order currency, balanced to base
|
| Several stores |
Often a separate setup per store
|
One integration layer, mapped per store
|
| Ledger volume |
Low
|
Higher, at one invoice per order
|
| Best for |
One store, consumer sales, one currency, totals only
|
Multiple stores or currencies, B2B accounts, and an order-level audit trail
|
Sage Accounting is Sage’s cloud accounting software for small and growing businesses, and it works differently from Sage 50, Sage 200 or Sage X3. This integration is built around its API, the records it keeps and the VAT tools finance teams already use.
Need a rule the blueprint doesn’t cover, such as posting orders from your EU store to a EUR bank account? Describe it in a prompt, and AI Studio’s Implementation Agent builds the flow and field mappings for you, typically giving you a working model in minutes. Once you’re live, AI Agents explain any failed run in plain English, and the MCP Server gives AI assistants governed access to your Shopify and Sage data.
A Shopify and Sage integration isn’t tested on launch day. It’s tested on Black Friday, at a VAT change, or by a flash sale that multiplies order volumes overnight.
Sage 50
Desktop accounting. Shopify orders, customers and stock synced without CSV imports.
Sage 200
Mid-market ERP. Orders, stock, customers and pricing kept in step with Shopify.
Sage
Sage 300, Sage 100, Sage Intacct and more, through one Shopify and Sage integration.
Yes. Sage Accounting is the current name for the product previously called Sage Business Cloud Accounting, and before that Sage One. Some app listings and older guides still use the earlier names. If you run Sage’s cloud accounting software in your browser, rather than Sage 50 on a desktop, this accelerator is built for you.
No. Sage 50 and Sage 200 are separate products with their own APIs, so they connect to Shopify differently. Patchworks connects both, along with Sage X3, Sage 300 and Sage Intacct. Visit our Sage integration page to find the right route for the Sage you run.
It depends on how you sell. Many Sage Accounting apps for Shopify post one summary entry per day or per payout, which keeps your ledger small and suits a single store selling to consumers in one currency. Post individual invoices when finance needs to see each order, customer, VAT rate and currency in Sage, when refunds must be matched to the original sale, or when several stores or B2B accounts feed the same Sage business. This accelerator posts one invoice per order.
DO use a daily summary if you sell from one store, in one currency, and only need sales totals in Sage.
DON’T rely on one when finance needs every order, customer, VAT rate and refund traceable in Sage Accounting.
Each Shopify tax line is mapped to the matching tax rate in Sage Accounting, including standard, reduced, zero-rated and exempt sales, so every invoice line carries the right VAT. Because the VAT detail sits on each invoice, Sage Accounting’s own VAT return, including Making Tax Digital submissions, reflects your Shopify sales without re-keying. If rates change, you update the mapping, not the integration.
Yes. GBP and EUR orders are invoiced in Sage Accounting in their original currency, with the exchange rate recorded and the totals balanced in your base currency. This uses Sage Accounting’s multi-currency feature, so it needs to be enabled in your Sage subscription. Further currencies are added the same way, which suits brands selling into Ireland and the EU through Shopify Markets.
Each order’s payment is recorded against its invoice in Sage Accounting. Shopify Payments fees are posted to the ledger account you choose, and payouts are matched to the bank account they land in. Finance can then reconcile the bank feed against individual invoices instead of unpicking a lump-sum deposit.
Patchworks raises a credit note in Sage Accounting and allocates it against the original invoice, so the customer’s account and your VAT position stay correct. A partial refund creates a credit note for the refunded lines or amount only, and refunded shipping is handled in the same way.
Because the core flows are prebuilt, a standard setup can be live within days once both systems are connected and the mappings have been tested in staging. You can implement it in-house with support from Patchworks’ engineers, with Jellywall, who co-built the blueprint, or with one of our other agency partners.
Yes. Every flow can be changed on the visual canvas, whether that’s adding a field, changing a mapping or adding a rule. You can also connect a 3PL, marketplace or CRM to the same integration layer, using a prebuilt connector or one you build in Connector Builder. AI Studio can make many of these changes from a prompt.
They’re queued, not dropped. If Shopify or Sage Accounting hits an API rate limit during a spike, Patchworks holds the data and retries it once the limit clears, and the platform auto-scales as volumes rise. Every run is logged, and failures trigger alerts so they can be retried. Our peak resilience checklist covers what else to prepare.
Yes. Every flow can be changed on the visual canvas, whether that’s adding a field, changing a mapping or adding a rule. You can also connect a 3PL, marketplace or CRM to the same integration layer, using a prebuilt connector or one you build in Connector Builder. AI Studio can make many of these changes from a prompt, as the next answer explains.
Patchworks pricing is based on the number of connected systems and monthly operations, not seats. An operation is counted each time Patchworks sends or receives a data payload, and every plan includes unlimited users. See pricing.
Yes. Patchworks is certified to SOC 2 and ISO 27001. Sage Accounting is authorised through OAuth 2.0, so Patchworks never sees or stores your Sage password, and Shopify connects through the Patchworks app or an Admin API access token that you control. See security and compliance.