Etsy reports no VAT
On sales all across Europe Etsy simply passes zero. There is nothing to read off the order, so the rate has to come from somewhere else.
KPL-0008
Book your Etsy sales into Yuki as sales invoices, with your Etsy fees kept apart.
Etsy pays you one lump sum that already has the sale netted off: listing fees, transaction fees and ads are gone. Schakel picks the orders up and books them into Yuki as sales invoices, carrying the VAT code you chose per situation. The Etsy fees travel along as journal entries. Both run through an Etsy clearing account, so your payout reconciles cleanly against your bank statement.
Sales invoicesVAT codesEtsy feesContactsRefunds
Set this up Free to start · 30 days unlimited
You make things. Somewhere between the kiln and the post office, three numbers have to be reconciled: what you sold, what Etsy kept, and what actually landed. Etsy hands you only the last one, as a single line on your bank statement. Everything on this page exists to put the first two back where they belong, so that line stops being a puzzle.
The clearing account
What is left on it is exactly your payout
Etsy pays one lump sum with the sale already netted off, so your revenue, your costs and your payout are three different numbers. Schakel puts the first two on an Etsy clearing account: sales go on, Etsy fees come off. The balance that stays behind is the payout Etsy sends your bank, which is what makes the bank line reconcilable instead of mysterious.
Etsy clearing account This payout period
- On Sales invoices 31 orders, VAT per order + € 1,842.30
- Off Etsy fees Listing, transaction, advertising − € 214.86
Balance left standing € 1,627.44
Reconciles against
Your bank statement
Etsy Ireland UC € 1,627.44
No Etsy buyer ever sits in your books as a wrongly open receivable, and the payout is not booked a second time. Yuki does not allow a journal entry to touch a bank account, and that is right: your bank statement books that payout itself, so anything else would put the money in twice.
Four codes
Why you copy four VAT codes across yourself
It is the one bit of setup that feels like work, so here is exactly why it exists. Neither side of this connector can hand the codes over, and guessing them is the one failure mode that would not announce itself.
Yuki cannot list its codes
Yuki has no API that returns your VAT rates. It looks a code up from the type and percentage pair, and if that pair does not exist in your domain it cancels the whole invoice.
The four you fill in
- Domestic Your own administration country
- EU consumer Buyer in the EU, no VAT number
- EU business Buyer in the EU, with a VAT number
- Outside the EU Buyer beyond the union
Two more things worth knowing before you start. Selling in dollars or pounds only works if your Yuki contract includes foreign currency, which is a paid option, and without it Yuki refuses the invoice. And Yuki can email an invoice to a customer, but we keep that hard off and deliberately did not make it a setting: an accounting connector should never be one wrong tick away from mailing your buyers.
In Yuki
What Schakel books into your administration
Six things, each visible per order in the log, in Yuki vocabulary rather than ours.
Orders as sales invoices
Every Etsy order becomes one sales invoice with a line per item and the Etsy order number as its reference. The buyer lands as a contact in Yuki keyed to their Etsy id, so a returning buyer reuses the same contact instead of creating a second one.
A VAT code per situation
Schakel picks one of your four codes per order, from the buyer country and the country of your administration. The codes come out of your own Yuki domain, so they are guaranteed to exist.
Etsy fees as journal entries
Listing fees, transaction fees and advertising land on the cost account you point at, instead of quietly coming off your revenue. As a maker you therefore see what a sale really earns rather than only what is left at the bottom.
Refunds to buyers
Yuki has no separate credit note type, so a refund becomes a sales invoice with negative quantities pointing back at the original. Your revenue and your VAT correct themselves, with no manual work.
Everything through the clearing account
Sales go on it, Etsy fees come off it, and the balance is the payout. That is what turns one unexplained bank line into a figure you can tick off.
Revenue from earlier this year
You choose the date bookings start from, and the catch-up is spread over several runs so your Etsy limit is not spent all at once. Orders from before your administration start date are skipped, because Yuki would book those as an opening balance with no revenue and no VAT while reporting success anyway.
Before and after
What the quarter looks like
| Task | By hand | With Schakel |
|---|---|---|
| Getting Etsy orders into Yuki | Retyped from the seller app | A sales invoice per order |
| Seeing what a sale really earns | Fees hidden inside the payout | Etsy fees on their own cost account |
| Choosing a VAT code | Guessed from a zero on the order | One of four codes, on buyer country |
| Reconciling the Etsy payout | One bank line nobody can explain | The clearing account balance, to the cent |
| Etsy buyers in your receivables | A row of open contacts | Settled through the clearing account |
| A refund to a buyer | A correction by hand | Negative quantities on the original |
| Catching up on this year | A weekend of typing | From the date you pick, spread over runs |
How you start
Four steps, then it runs
The third one takes the longest, and the panel above explains exactly why it exists.
- 01
Connect your Etsy shop
Etsy wants every seller to create their own app, so you do that once in your Etsy account and then give Schakel read access to your orders and your Etsy ledger. Your shop, listings and selling stay exactly as they are.
- 02
Connect Yuki
You paste your Yuki webservice key. If it reaches several administrations, you then pick which one gets the bookings. Your Yuki password is never asked for or stored.
- 03
Fill in the booking details
You point at the ledger accounts for revenue, shipping, Etsy fees and the clearing account, pick the Yuki payment method that points at that clearing account, and copy your four VAT codes across. Schakel checks that the payment method really exists before you can save.
- 04
Check the first invoices, then let it run
You look the first invoices over in Yuki. Once it looks right, every next order arrives on its own, and the log shows per order what was booked.
Ready to stop retyping Etsy orders into Yuki?
Connect the shop, connect the domain, fill in the booking details once.
Your Etsy app keys and your Yuki webservice key are stored encrypted, and no password for either side is asked for or held. Access can be revoked from either side at any time.
What you need
- An Etsy shop you own, plus your own Etsy app which you create once
- A Yuki domain with a webservice key for the administration you book into
- A ledger account for your Etsy clearing account, plus a Yuki payment method pointing at it
- The VAT rates from your Yuki domain, because no Yuki API returns that list
Where it runs
On app.schakel.app, with your own Schakel account. No webshop required.
Another pair
Connect a different pair
Etsy and Yuki is one of many. Pick two systems and see what travels between them.
Common questions
Why do I have to create an Etsy app myself?
Etsy gives every app its own daily limit and ties it to one seller. With your own app you use your own headroom, so a busy month at another seller never affects your bookings. Creating it takes a few minutes and happens once.
Why do I have to fill in the VAT codes myself?
Etsy hands over no VAT amount, and no Yuki API returns your VAT rates. Yuki looks a code up from the type and percentage pair, and if that pair does not exist it cancels the whole invoice. Copying them across from Yuki, under Settings and VAT rates, is therefore the only way that does not fail silently.
Is my Etsy payout booked?
No, and that is deliberate. Yuki does not let a journal entry touch a bank account, and it is right not to: your bank statement books it later anyway. The payout therefore sits as the balance on your Etsy clearing account until you reconcile it against your bank line.
I sell in dollars or pounds, does that work?
Only if your Yuki contract includes foreign currency. That is a paid option at Yuki, and without it Yuki refuses the invoice. If it is not in your contract, let us know before you start.
Do my buyers get email from Yuki?
No. Yuki can email an invoice to the customer, but we keep that hard off and it is not a setting. An accounting connector should never be one wrong tick away from mailing your buyers.
Can I still book revenue from before I connected?
Yes, back to your administration start date. You choose the date Schakel starts from, and the catch-up is spread over several runs so your Etsy limit is not spent all at once.
Can you connect Etsy to Yuki?
Yes. Schakel connects through the official APIs of Etsy and Yuki, so you install nothing on your own server and nothing travels outside those two parties.
Which VAT rate do my sales get in Yuki?
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.