Shopify → MoneybirdBeta
Your Shopify orders, into Moneybird.
Integrator’s flagship beta recipe books paid Shopify orders in Moneybird as external sales invoices, with VAT per line, OSS rates, shipping and discounts split by VAT rate, and payment registered. Refunds become credit invoices. Check a dry run on your own orders before anything is written.
- Secondsthrough webhooks when Shopify is connected through the Integrator app; scheduled checks and Run now are also available
- 1 invoiceper order and one credit invoice per refund, also when a run is repeated
- 0 emailsto your customers: orders are booked as external sales invoices, which Moneybird never sends
- Per lineVAT rates, so orders that mix 9% and 21% are booked correctly
From Shopify to Moneybird
How it works
Five steps run for every order, on their own. You only step in when an order needs a decision.
- 01
An order is paid
Shopify tells Integrator about the order. Integrator reads it: customer, lines, VAT per line, shipping, discounts and refunds.
- 02
It is checked first
Before anything is written, Integrator checks the order against your Moneybird administration: the tax rates exist, the contact is clear, and the lines add up to what the customer paid.
- 03
The invoice is booked
The order becomes an external sales invoice in Moneybird, with the order number as its reference. The customer’s contact is found by email, or created.
- 04
The payment is registered
A paid order gets its payment on the order date, so the invoice does not wait in your open receivables.
- 05
Refunds follow
When you refund an order in Shopify, the refund is booked as a credit invoice with the returned products, and settled with a negative payment.
Example
An illustrative order
Illustrative example, not a customer order: a flower shop sells two bunches of tulips (9% VAT) and a vase (21% VAT), with 10% off and €6.95 shipping. A week later one bunch comes back and the shipping is refunded. This is what Integrator books in Moneybird, prices including VAT.
- 2 × Bos tulpen (9%)
- €20.00
- 1 × Vaas (21%)
- €30.00
- Discount code, 10%
- −€5.00
- Shipping, Standaard
- €6.95
- of which VAT
- €7.38
- Paid
- €51.95
| Line | Qty | Price | VAT |
|---|---|---|---|
| Bos tulpen (TUL) | 2 | 10.00 | 9% |
| Vaas (VAAS) | 1 | 30.00 | 21% |
| Verzendkosten (Standaard) | 1 | 6.95 | 21% |
| Korting 9% btw | 1 | −2.00 | 9% |
| Korting 21% btw | 1 | −3.00 | 21% |
| Total, paid on 2 September | €51.95 | ||
Each discount stays with the VAT rate of the products it was given on.
| Line | Qty | Price | VAT |
|---|---|---|---|
| Bos tulpen (TUL) | −1 | 10.00 | 9% |
| Korting | 1 | 1.00 | 9% |
| Verzendkosten | 1 | −6.95 | 21% |
| Total, refunded on 10 September | −€15.95 | ||
The returned bunch keeps its share of the discount; the refunded shipping keeps its 21%.
Built in
What it takes care of
The details that make an accounting integration trustworthy are part of the recipe, not something you configure.
The right VAT on every line
Each product is booked with its own Moneybird tax rate. For customers in another EU country, the country’s own (OSS) rate is used when your administration has one.
Refunds as credit invoices
Every refund becomes its own credit invoice with the returned products, their share of the discount, and any refunded shipping, settled with a negative payment.
Shipping and discounts included
Shipping and discounts are their own invoice lines, at the VAT rate of what they belong to. When Shopify taxed shipping at two rates, it is split the same way.
Contacts kept tidy
Customers are matched to a Moneybird contact by exact email, and created when they are new. Or book every order to one contact, such as “Webshop customers”.
A trail that prevents duplicate bookings
Integrator tracks source-to-destination records, and replays do not duplicate them. Uncertain writes stop for a person to check. Existing invoices are not changed or deleted.
Every order traceable
Follow the per-record trail. Recognised errors come with a plain-language cause and fix from a reviewed catalogue; unknown errors are marked “not yet explained”. Fixed records can be resent with one click.
Field by field
What goes where
Fields the integration does not own are left alone. The mapping can be adjusted per integration under Advanced.
| In Shopify | In Moneybird | How |
|---|---|---|
| Order number | Invoice reference | “Webshop order #1043”, so you find it back in both systems. |
| Order date | Invoice date | The day the order was placed. |
| Billing name, company, email and country | Contact | Found by exact email, or created. Optionally one fixed contact for every order. |
| Line items | Invoice lines | Title with SKU, quantity and price, as on the order. |
| VAT rate of each line | Sales tax rate | The active Moneybird rate with that percentage; for EU customers abroad, their country’s rate first. |
| Discounts | Discount lines | One line per VAT rate, with the discounts on products at that rate. |
| Shipping | Shipping line | The shipping price after shipping discounts, at its own VAT rate. |
| Payment status “paid” | Payment | The order total, on the order date. Can be turned off. |
| Each refund | Credit invoice and payment | “Webshop order #1043 refund …”, dated the day of the refund. |
About ten minutes
Set it up
No consultant, no spreadsheet of field names. Connect both accounts, check the preview, turn it on.
- 1
Connect Shopify
Install Integrator by CLATE on your store and approve the permissions Shopify shows. Access renews automatically.
- 2
Sign in with Moneybird
Approve access in Moneybird. If your login opens more than one administration, choose the one to book in. A personal API token works too.
- 3
Choose where to start
Book orders from the moment you turn it on, from a date you pick, or all of them. Orders older than 60 days need Shopify’s approval for full order history.
- 4
Check a dry run, then turn it on
The dry run checks up to 20 recent real orders without writing anything. You see what would be booked before a single invoice exists.
Settings you can change
- Only book paid orders
- On by default. Refunded orders count as paid: their invoice is booked and each refund credited.
- Mark the invoice as paid
- On by default. Registers the payment so the invoice does not stay open.
- Book every order to one contact
- Optional. The customer number of a Moneybird contact, instead of a contact per customer.
- Revenue account
- Optional. The account number or name from your chart of accounts; empty uses Moneybird’s default.
- Tax rate for orders without VAT
- Optional. Only needed when you have several 0% rates, such as reverse charge and export.
- What goes where
- Advanced. Change how order fields map to the invoice, such as the reference text or which orders are skipped. Orders in another currency than euros are skipped by default.
Honest limits
When it stops for you
An order that cannot be booked correctly is not booked at all. It waits with a plain explanation, and every other order keeps going.
The lines do not add up
When the invoice lines do not add up to what the customer paid, often because of a gift card or a change made by hand in Shopify, the order waits for you.
Moneybird lacks a tax rate
When the order’s VAT percentage has no active sales tax rate in Moneybird, or several rates share it, you are told which one to add or choose.
A contact is unclear
When more than one Moneybird contact has the customer’s email, you merge them or choose one contact for all orders.
A refund has no clear VAT rate
When a refund returns an amount that is not tied to its products or shipping, and the order has more than one VAT rate, you book that refund by hand.
Outside this integration
- Changes to an order after it was booked, other than refunds, are not followed. Existing invoices are never changed.
- Orders in another currency than euros are skipped by default.
- A refund with more than 50 lines, or an order with more than 10 refunds, stops for booking by hand.
- Moneybird allows 150 requests per 5 minutes per administration, shared with your other apps; a large backlog is booked in batches.
BetaShopify and Moneybird are both supported in beta. Check a dry run with up to 20 recent real orders before switching the recipe on. The dry run writes nothing.
Questions
Can I see what it will do first?
Yes. The dry run shows what would be written for up to 20 recent real orders, and writes nothing.
Will it create duplicates?
Integrator tracks source-to-destination records, and replays do not duplicate them. Uncertain writes stop for a person to check.
Does it change or delete existing invoices?
No. Integrator does not change or delete existing invoices.
How fast does it book orders?
Within seconds for Shopify connected through the Integrator app and for WooCommerce through webhooks. Otherwise, recipes run every 15 or 30 minutes. You can also choose Run now.
What about orders in other currencies?
Non-EUR orders are skipped by default.
What happens when something fails?
Recognised errors come with a plain-language cause and fix from a reviewed catalogue. Unknown errors are marked “not yet explained”. Fixed records can be resent with one click.
What happens if I edit an order after booking?
Edits after booking are not followed, except refunds, which become credit invoices.
Where is my data kept?
Integrator is hosted on Railway in the EU, in Amsterdam. Credentials are encrypted per workspace. Record history is kept for 90 days by default.
See your own orders in Moneybird, before anything is booked.
Connect your store and administration, run a dry run with your real orders, and turn it on when the preview looks right.
