WooCommerce to Spiris
Sales, refunds, fees and payouts from WooCommerce, booked in Spiris as balanced vouchers. Each payout clears the sales in it, so the clearing account closes and the bank ties.
- Status
- Builtnot live
- Clearing account
- 1580back at 0.00 after each payout
- Chart of accounts
- BASsuggested accounts, yours to change
- Kinds of event
- 7booked as balanced vouchers
Status, honestly
Built · not live. WooCommerce: Built and tested against our own test systems, from WooCommerce's public documentation. Not yet run against the real WooCommerce; not yet live. Spiris: Built and tested against our own test systems, and checked against Spiris's published API description. Not yet run against the real Spiris; not yet live. Where each connector stands
What is booked when
Each sale is booked in Spiris the day it happens, on the clearing account. When WooCommerce pays out, one voucher moves the money to the bank, and the clearing account is back at zero.
| Account | Debit, SEK | Credit, SEK | VAT |
|---|---|---|---|
| 9–11 Nov · Sales, 12 orders | |||
| 1580Clearing, WooCommerce | 7,480.00 | ||
| 3001Sales | 5,984.00 | 25 % | |
| 2611Output VAT | 1,496.00 | ||
| Σ | 7,480.00 | 7,480.00 | |
| 11 Nov · Refund, 1 order | |||
| 3001Sales | 384.00 | 25 % | |
| 2611Output VAT | 96.00 | ||
| 1580Clearing, WooCommerce | 480.00 | ||
| Σ | 480.00 | 480.00 | |
| 12 Nov · Payout from WooCommerce | |||
| 1930Bank | 6,783.10 | ||
| 6570Payment fees | 216.90 | ||
| 1580Clearing, WooCommerce | 7,000.00 | ||
| Σ | 7,000.00 | 7,000.00 | |
| Clearing 1580 after the payout | 0.00 | ||
Example amounts. Account numbers are our suggestions in the BAS chart used in Sweden. You or your accountant can change every one. They have not yet been reviewed by an accountant.
The clearing account closes
Between a sale and its payout, the money sits on the clearing account 1580: money WooCommerce owes you. Every payout clears exactly the sales and refunds in it, so the account returns to zero with each payout, and at month end it holds only what is still on its way. Anything left that should not be there is listed for you or your accountant to look at.
What gets booked, and how
- Sales
- Each paid order becomes a voucher: revenue split by VAT rate, with shipping and discounts where they belong, against the clearing account 1580.
- Refunds
- Reversed on the same accounts as the sale, on the day they happen.
- Fees
- WooCommerce's fees are booked as a cost 6570 when the payout shows them, so revenue stays at what the customer paid. You choose the VAT on fees: none, reverse charge, or domestic VAT.
- Payouts
- Each payout is one voucher: the money moves from the clearing account 1580 to the bank account 1930, net of fees. It is booked only once every sale in it is booked, so it ties to the cent.
- VAT
- Output VAT by rate on every sale and refund, on the VAT accounts Spiris uses.
- Sales to other EU countries
- Sales to consumers in other EU countries go to their own accounts, so your OSS return is a sum, not a search.
- Gift cards
- A sold gift card is booked as a debt, and as revenue when it is used. The rule awaits an accountant's ruling.
What you control
- The accounts
- We suggest accounts from your own chart of accounts. Keep them, or change any one.
- The start date
- Book from today, or from the start of your financial year.
- Review first
- Turn on review mode and nothing posts until you or your accountant approve it.
- VAT on fees
- Pick how the fees are taxed. It applies from the next payout.
- Your accountant's access
- Give your accounting firm a login of its own: read only, or read and approve.
- Stopping
- Disconnect whenever you like. What has been booked stays in your books.
When something fails
- Short outages retry on their own
- If Spiris is down or busy, we wait and try again. Each voucher carries a reference and a retry looks for it first, so nothing is booked twice.
- What only you can fix is said plainly
- Sign in again, an account that is missing or inactive, a locked period: you see it in plain words, with the one thing to do.
- A payout waits for its sales
- If a payout arrives before a sale in it, it waits and is booked once the sale is.
- Closed months stay closed
- Nothing is booked into a period that is locked or signed off. Late items go on the first open day, with the original date in the text.
- We check the books
- Every six hours we check that what we booked is still in Spiris and that every payout cleared. A difference is shown to you, or fixed by us when it is ours.
About Spiris
Each event becomes a voucher in Spiris (formerly Visma eEkonomi), with the order or payout in the voucher text.
About WooCommerce
Shop platform. WooCommerce has no payouts of its own. Connect the payment provider that pays you (Stripe or Klarna) beside the shop, and its payouts clear the shop's sales.
Want this connector when it's ready?
Nothing is live and nothing is for sale yet. The next page says how you will be able to hear about it.