---
title: "Abicart OSS report per country and VAT rate · Hypamoon"
description: "Splitting Abicart sales per country and VAT rate in a spreadsheet each quarter? Get the totals per country of delivery and rate, for your accountant."
url: https://hypamoon.com/connect-to/abicart/oss-report
---

1.  [Connect to](https://hypamoon.com/connect-to)
2.  [Abicart](https://hypamoon.com/connect-to/abicart)
3.  OSS report

For teams that run on Abicart

# Abicart OSS report per country and VAT rate

Abicart charges VAT per country of delivery on the Plus and Pro plans. Its own pages point to accounting software for reports such as Intrastat; shops without that link split the order export by country and rate themselves before the One Stop Shop return.

[Start free](https://app.hypamoon.com/?mode=signup&utm_source=connect-to&utm_campaign=abicart/oss-report)

## How it goes today

1.  Export the orders of the quarter from the admin.
2.  Sort them by the country they were delivered to.
3.  Split the amounts per VAT rate and take out cancelled orders.
4.  Type the totals into the return or mail them to the accountant.

## How it can go

**Your quarterly sales per country of delivery and VAT rate, in one file.**

After each quarter you get a file per country of delivery: sales without VAT and the VAT per rate, in the order currency and in your base currency, shipping on its own line, consumers and businesses apart, and the orders behind each total. Norway is listed on its own.

## Say this in ChatGPT, Claude or Copilot

Your chat gets connected to Hypamoon first, with this request filled in. You paste your Abicart key in the portal, never in the chat.

Your request

> With Hypamoon, after each quarter, take the Abicart orders delivered to other countries and total them per country of delivery and VAT rate: sales without VAT and the VAT, in the order currency and our base currency, shipping on its own line, cancelled orders out. Keep business customers apart and list Norway on its own. Email me and our accountant the file with the orders behind each total.

[Build this in your chat](https://hypamoon.com/connect?via=connect-to~abicart/oss-report&say=a%20quarterly%20Abicart%20file%20of%20sales%20and%20VAT%20per%20country%20of%20delivery%20and%20rate%2C%20for%20us%20and%20our%20accountant.)

[Start free](https://app.hypamoon.com/?mode=signup&utm_source=connect-to&utm_campaign=abicart/oss-report)

You create an API key yourself in your Abicart admin, under Settings, External Connections, API Keys, and copy it with your Store ID. Give this tool its own key; you can switch it off there at any time. It stays yours.

## More for teams on Abicart

-   [**Each month I export our webshop orders and turn them into a sheet for the accountant.**](https://hypamoon.com/connect-to/abicart/accountant-export)
-   [**I check the bank for each transfer order and mark it paid in the webshop myself.**](https://hypamoon.com/connect-to/abicart/unpaid-orders)
-   [**I put the order export next to our purchase prices to see what we earn per order.**](https://hypamoon.com/connect-to/abicart/profit-per-order)
-   [**We keep a coloured status on orders that still wait for a product and check them by hand.**](https://hypamoon.com/connect-to/abicart/backorders)
-   [**We print a delivery note for each order and walk to the shelves for every one.**](https://hypamoon.com/connect-to/abicart/pick-list)
-   [**Before I order from a supplier I go through our stock product by product.**](https://hypamoon.com/connect-to/abicart/reorder-list)
-   [**At year end I export our products and multiply stock by purchase price in a spreadsheet.**](https://hypamoon.com/connect-to/abicart/stock-value)
-   [**Everything for Abicart**](https://hypamoon.com/connect-to/abicart)
