Keep Google Sheets and Moneybird updated automatically.
Today you keep everything in a spreadsheet and then retype it into the system that actually has to act on it. This connector fixes that, and we build it on request: what happens in Google Sheets lands in Moneybird by itself, in the shape Moneybird expects. Tell us what you need and we agree exactly what should travel.
What this connector takes off your hands
-
Today you keep everything in a spreadsheet and then retype it into the system that actually has to act on it.
-
Today you type sales into Moneybird by hand, pick the right ledger account and VAT rate per line, and afterwards match the bank entry to the right invoice. One wrong account and your quarterly figures stop adding up.
What Google Sheets to Moneybird saves you
- Book every task you finish in Google Sheets straight into Moneybird.
- Book every new row in Google Sheets straight into Moneybird.
What travels across the link
Everything this connector moves between Google Sheets and Moneybird, and how often.
-
Invoices
to Moneybird automaticallyEvery sale becomes an invoice in Moneybird with its own line items and the order number as reference, so you can trace it back without retyping.
-
Contacts
to Moneybird automaticallyThe customer is recorded as a contact in Moneybird or reused by email, so no duplicate relation appears.
-
VAT
to Moneybird automaticallyThe VAT rate is set per line, and foreign sales get the rate of the destination country, ready for your OSS return.
What each side expects
Google Sheets and Moneybird do not describe the world the same way. This is what has to line up.
Moneybird
Moneybird wants to know, per invoice line, which ledger account and which VAT rate it falls under. A contact has to exist before an invoice can hang off it, and an invoice only counts as paid once a payment is linked to it.
Setting it up
- 01
Request the connector
Let us know you want to link Google Sheets to Moneybird. We get in touch within 24 hours with a timeline.
- 02
We agree what should travel
Together we settle what should travel out of Google Sheets. Moneybird wants to know, per invoice line, which ledger account and which VAT rate it falls under. A contact has to exist before an invoice can hang off it, and an invoice only counts as paid once a payment is linked to it.
- 03
We build and test
You see the connector run on a few test records before anything becomes final.
What you need
- A Google account with edit rights on the spreadsheet, and the tab the rows should go into.
- A Moneybird administration you administer, plus clarity on which ledger account you want this revenue booked to.
Not sure how to get those keys? Step by step:
Where it runs
On app.schakel.app, with your own Schakel account. No webshop required.
We build this connector on request. Tell us what you need and we reply within 24 hours.
Common questions
Can you connect Google Sheets to Moneybird?
Yes. Schakel connects through the official APIs of Google Sheets and Moneybird, so you install nothing on your own server and nothing travels outside those two parties.
Which VAT rate do my sales get in Moneybird?
The rate is set per line: 21%, 9% or 0%. Sales to Belgium and other EU countries get the rate of the destination country, ready for your OSS return.
Are commission and fees booked separately in Moneybird?
Yes. Commission, shipping and other fee types each land on their own ledger account in Moneybird, rather than in one lump sum, so your margin stays readable.
From what moment in Google Sheets does something reach Moneybird?
As soon as you add or finish the row or task in Google Sheets that you chose as the trigger, it reaches Moneybird.
What does connecting Google Sheets and Moneybird cost?
You start free and only pay once the connector is really running. After that the same tiers apply as for any other connector, based on how much runs through it each month.
How often does Google Sheets sync with Moneybird?
That depends on your tier: hourly on the free tier up to real time on the unlimited tier. You can always start a sync yourself as well.
What happens to a return or refund in Moneybird?
A return becomes a credit invoice in Moneybird for the amount actually refunded, not for the whole order, so nothing needs correcting afterwards.
What if Google Sheets or Moneybird is briefly unavailable?
Nothing gets lost. Schakel retries later and the log shows exactly what happened, so at most you notice something coming through a little later.
Missing something you need?
Tell us what Google Sheets and Moneybird should do for you. If it is not in here yet, that is usually because nobody has asked. We build on request and we reply within 24 hours.