Keep Google Sheets and Exact Online 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 Exact Online by itself, in the shape Exact Online 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 post sales into Exact Online by hand, per line on the right ledger account and with the right VAT code. With several administrations or financial years that retyping gets riskier, and you spot a mistake only at reconciliation.
What Google Sheets to Exact Online saves you
- Book every task you finish in Google Sheets straight into Exact Online.
- Book every new row in Google Sheets straight into Exact Online.
What travels across the link
Everything this connector moves between Google Sheets and Exact Online, and how often.
-
Invoices
to Exact Online automaticallyEvery sale becomes an invoice in Exact Online with its own line items and the order number as reference, so you can trace it back without retyping.
-
Contacts
to Exact Online automaticallyThe customer is recorded as a contact in Exact Online or reused by email, so no duplicate relation appears.
-
VAT
to Exact Online 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 Exact Online do not describe the world the same way. This is what has to line up.
Exact Online
Exact Online works per administration, with its own chart of accounts, VAT codes and relations. An entry lands in a journal, so which journal and which ledger account you use has to be settled up front.
Setting it up
- 01
Request the connector
Let us know you want to link Google Sheets to Exact Online. 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. Exact Online works per administration, with its own chart of accounts, VAT codes and relations. An entry lands in a journal, so which journal and which ledger account you use has to be settled up front.
- 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.
- An Exact Online account with rights on the administration you want linked. You grant Schakel access once through Exact itself.
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 Exact Online?
Yes. Schakel connects through the official APIs of Google Sheets and Exact Online, so you install nothing on your own server and nothing travels outside those two parties.
Which VAT rate do my sales get in Exact Online?
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 Exact Online?
Yes. Commission, shipping and other fee types each land on their own ledger account in Exact Online, rather than in one lump sum, so your margin stays readable.
From what moment in Google Sheets does something reach Exact Online?
As soon as you add or finish the row or task in Google Sheets that you chose as the trigger, it reaches Exact Online.
What does connecting Google Sheets and Exact Online 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 Exact Online?
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 Exact Online?
A return becomes a credit invoice in Exact Online for the amount actually refunded, not for the whole order, so nothing needs correcting afterwards.
What if Google Sheets or Exact Online 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 Exact Online 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.