Retyping orders into an accounting app and a CRM is one of the most common, and most error-prone, chores in a small online store. A wrong amount here, a missed refund there, and month-end reconciliation becomes a hunt. This guide shows how to connect the three systems so each one gets the data it needs.
Decide what each system is for
| System | Is the “home” for | Needs from Shopify |
|---|---|---|
| Shopify | Products, stock, orders | n/a |
| Accounting (Xero, QuickBooks, Zoho Books…) | Sales, VAT, payments, fees, refunds | Sales and payment totals, tax, fees, refunds |
| CRM / email platform | Customer relationship, marketing consent, service history | Customer details, order history, value, consent |
Each kind of data has one home. The others read from it. See single source of truth for customer data.
Accounting: connector first
Most accounting tools offer a Shopify connector or an app in the Shopify App Store. Start there before building anything. Check who publishes it (the accounting vendor or a third party), what it costs and what it syncs.
Per-order or daily summary?
| Per-order invoices | Daily (or per-payout) summary | |
|---|---|---|
| What gets created | One invoice or sales receipt per order | One journal or invoice per day or per payout, with totals |
| Good for | Low volume, B2B, when each customer needs an invoice | Higher volume consumer stores |
| Downside | Clutters the books at volume | Less detail per customer in accounting |
Many stores use summaries for accounting and keep customer-level detail in Shopify and the CRM. Ask your accountant which they prefer before you switch anything on.
The mapping decisions
Whatever tool you use, decide these explicitly:
- VAT: in the UAE, Shopify uses Manual Tax, so you set the 5% rate and whether prices include it. Make sure the connector maps Shopify’s tax lines to the right VAT code. Confirm the treatment with your accountant.
- Shipping: revenue line or separate income account? Taxed or not?
- Discounts: reduce the sale, or recorded separately?
- Payment fees: Shopify Payments pays out net of fees. Record the fees as an expense so sales aren’t understated.
- Cash on delivery: COD orders stay unpaid in Shopify until you mark them paid. Decide when the sale is recorded and how courier cash remittances are reconciled.
- Refunds and returns: credit notes or negative receipts, and stock returning to inventory.
- Gift cards: a liability when sold, revenue when redeemed.
Reconcile weekly
Once a week, match Shopify payouts to bank deposits, and payouts to the orders and fees in accounting. A connector that runs silently for months with an unnoticed mapping error is worse than none. The mapping sheet includes a reconciliation log.
CRM: customers and order history
What the CRM or email platform needs:
- Customer: name, email, phone (in
+971format), and marketing consent with its source and date - Order summary: order count, total spent, first and last order date, products or categories bought
- Events for flows: order placed, fulfilled, refunded
Many email platforms (Klaviyo, for example) and CRMs have Shopify integrations that do this out of the box. If yours doesn’t, an automation fills the gap.
When to use an automation platform
Use n8n, Make or Zapier when the connectors don’t do what you need. For example:
- creating a deal in the CRM for large or B2B orders
- alerting the team about high-value orders or failed COD deliveries
- syncing to a tool with no Shopify connector
In n8n, the Shopify Trigger node listens for store events (such as new orders), and there are nodes for Xero and QuickBooks Online, plus HTTP Request for anything else. Apply the same safeguards as any production automation: search before creating to avoid duplicates, retry on failure, and alert a person if it still fails. See error handling in n8n.
A rollout plan
- Agree the mapping with your accountant, using the sheet.
- Connect accounting with the connector, starting from a set date (not all of history).
- Run in parallel for two weeks. Compare with how you did it before.
- Connect the CRM or email platform for customers and order events.
- Add automations only for the gaps.
- Reconcile weekly, and document what runs where. See how to document automations.
Plan ahead for UAE e-invoicing, which is being phased in from 2027. Your accounting setup will need to issue structured e-invoices through an accredited provider. See UAE e-invoicing for small businesses.
Frequently asked questions
Should we import all our old orders?
Usually not into accounting. Start from a clean date agreed with your accountant. For the CRM or email platform, importing past customers and order history is useful for segmentation, as long as you respect their marketing consent status.
Can one tool do both accounting and CRM?
Suites such as Zoho (Books plus CRM) or HubSpot with accounting integrations reduce the number of connectors. The mapping decisions above still apply.
What breaks most often?
Tax mapping after a settings change, refunds that don’t sync, and connectors that stop after a password or permission change. Weekly reconciliation catches all three.
If you’d like the sync designed and set up with your accountant, that’s part of our online store service.
Free download · Excel template
Shopify sync mapping sheet
A field-by-field mapping from Shopify to your accounting and CRM, with the decisions to make (VAT, shipping, discounts, fees, COD, refunds) and a weekly reconciliation log.
Download itNo sign-up. Opens in Excel, Google Sheets or Numbers.
Rather have it done?
This is the kind of work our online store service covers. Tell us where you are today and we’ll reply with a plan and a fixed price.
Let’s talk