{"id":1653,"date":"2026-03-03T07:19:49","date_gmt":"2026-03-03T06:19:49","guid":{"rendered":"https:\/\/newcraft.dev\/posts\/\/"},"modified":"2026-03-03T07:20:44","modified_gmt":"2026-03-03T06:20:44","slug":"how-to-get-shopify-vat-numbers-into-your-accounting-software","status":"publish","type":"marketing-post","link":"https:\/\/newcraft.dev\/nl\/posts\/how-to-get-shopify-vat-numbers-into-your-accounting-software\/","title":{"rendered":"How to Get Shopify VAT Numbers Into Your Accounting Software"},"content":{"rendered":"\n

\n TL;DR:<\/strong> Shopify doesn’t natively pass validated VAT numbers to accounting software. To get VAT IDs onto invoices in tools like Billbee, sevDesk, Exact Online, or Xero, you need them stored as order attributes. The EU Tax Exemption app<\/a> validates VAT numbers via VIES and saves them to every order automatically, so your accounting stack can pick them up without manual work.\n<\/p>\n\n\n\n

The Problem: VAT Numbers Get Stuck in Shopify<\/h2>\n\n\n\n

\n You validate a customer’s VAT number. The order gets tax-exempt status. But when your accounting software pulls the order, the VAT number is nowhere to be found.\n<\/p>\n\n\n\n

\n This is one of the most common frustrations for B2B Shopify sellers in Europe. Shopify can mark a customer as tax-exempt, but that status alone doesn’t tell your invoicing tool which VAT number justified the exemption. And without the VAT number on the invoice, your reverse charge invoice isn’t compliant.\n<\/p>\n\n\n\n

\n The fix is straightforward: the VAT number needs to be stored as an order attribute (note_attributes) that your accounting software can read. That’s exactly what the EU Tax Exemption app does automatically<\/a> for every validated B2B order.\n<\/p>\n\n\n\n

\n Below is a practical guide for connecting that data to the most popular European accounting and invoicing tools.\n<\/p>\n\n\n\n

How It Works: The Data Flow<\/h2>\n\n\n\n

\n Before diving into specific tools, here’s what happens behind the scenes:\n<\/p>\n\n\n\n

    \n \n
  1. Customer enters their VAT number at checkout (or via the storefront widget<\/a>)<\/li>\n\n \n
  2. The number is validated against the EU VIES database in real time<\/li>\n\n \n
  3. Tax exemption is applied to the order (reverse charge or full exemption)<\/li>\n\n \n
  4. The validated VAT number is saved as a vat-id<\/code> order attribute in Shopify<\/li>\n\n \n
  5. Your accounting software reads that attribute when it syncs the order<\/li>\n\n<\/ol>\n\n\n\n

    \n The key is step 4. Without the VAT number stored on the order itself, your accounting tool has nothing to grab. Let’s look at how each tool handles this.\n<\/p>\n\n\n\n

    Billbee<\/h2>\n\n\n\n

    \n Billbee is the go-to multichannel order management tool for German and Austrian Shopify sellers. It handles invoicing, shipping labels, and accounting exports, including DATEV.\n<\/p>\n\n\n\n

    \n Billbee reads Shopify’s order note_attributes by default. Once the EU Tax Exemption app saves the VAT number as a vat-id<\/code> attribute, Billbee picks it up automatically during order sync.\n<\/p>\n\n\n\n

    \n Setup:<\/strong>\n<\/p>\n\n\n\n

      \n \n
    • In Billbee, go to Settings and then Invoice Templates<\/li>\n\n \n
    • Add the VAT ID field placeholder to your invoice template<\/li>\n\n \n
    • Billbee maps the vat-id<\/code> from Shopify’s additional details to the customer’s tax number field<\/li>\n\n \n
    • Reverse charge invoices are generated automatically when the VAT ID is present and the customer is from a different EU country<\/li>\n\n<\/ul>\n\n\n\n

      \n Billbee also exports to DATEV format, so the VAT number flows all the way through to your tax advisor.\n<\/p>\n\n\n\n

      sevDesk<\/h2>\n\n\n\n

      \n sevDesk is popular with small and mid-sized German businesses for bookkeeping, invoicing, and tax filing. Their Shopify integration syncs orders directly into sevDesk and creates invoices automatically.\n<\/p>\n\n\n\n

      \n Setup:<\/strong>\n<\/p>\n\n\n\n

        \n \n
      • Connect sevDesk to Shopify via their app or through Billbee as a middleware<\/li>\n\n \n
      • sevDesk reads the customer’s VAT ID from the order’s additional details<\/li>\n\n \n
      • In your sevDesk invoice settings, enable the reverse charge notice for EU B2B invoices<\/li>\n\n \n
      • The VAT number appears on the generated invoice alongside the 0% VAT line<\/li>\n\n<\/ul>\n\n\n\n

        \n If you use sevDesk through Billbee, the VAT number passes through both systems. If you use sevDesk’s direct Shopify integration, make sure it’s configured to read note_attributes.\n<\/p>\n\n\n\n

        lexoffice (Lexware Office)<\/h2>\n\n\n\n

        \n lexoffice is another major German cloud accounting tool, especially popular with freelancers and small businesses. Their Shopify app syncs orders and creates bookkeeping entries.\n<\/p>\n\n\n\n

        \n Setup:<\/strong>\n<\/p>\n\n\n\n

          \n \n
        • Install the lexoffice Shopify app from the App Store<\/li>\n\n \n
        • The app imports orders with their note_attributes, including the vat-id<\/code><\/li>\n\n \n
        • In lexoffice, the VAT ID is linked to the customer contact record<\/li>\n\n \n
        • When generating invoices, lexoffice includes the customer’s VAT number and applies the correct reverse charge treatment<\/li>\n\n<\/ul>\n\n\n\n

          \n lexoffice also handles the E\u00dcR (Einnahmen\u00fcberschussrechnung) and VAT returns, so having the VAT number on the order makes your tax filings more accurate from the start.\n<\/p>\n\n\n\n

          DATEV<\/h2>\n\n\n\n

          \n DATEV isn’t something you use directly. It’s the standard format German tax advisors use. Your accounting tool needs to export Shopify data in DATEV-compatible format, and the VAT number needs to be part of that export.\n<\/p>\n\n\n\n

          \n How to get VAT numbers into DATEV:<\/strong>\n<\/p>\n\n\n\n

            \n \n
          • Via Billbee:<\/strong> Export orders in DATEV format. Billbee includes the VAT ID from order attributes in the export file<\/li>\n\n \n
          • Via sevDesk:<\/strong> sevDesk generates DATEV-ready exports with customer VAT numbers attached<\/li>\n\n \n
          • Via lexoffice:<\/strong> lexoffice exports are DATEV-compatible and include VAT IDs<\/li>\n\n \n
          • Via Pathway Accounting Export Pro:<\/strong> Dedicated Shopify-to-DATEV app that reads note_attributes<\/li>\n\n<\/ul>\n\n\n\n

            \n The common thread: all of these tools need the VAT number to be stored on the Shopify order. Without it, your DATEV export has a gap that your Steuerberater will flag.\n<\/p>\n\n\n\n

            Exact Online<\/h2>\n\n\n\n

            \n Exact Online is the dominant accounting platform in the Netherlands and Belgium. Many Dutch Shopify sellers use it for their complete financial administration, including BTW-aangifte (VAT returns).\n<\/p>\n\n\n\n

            \n Setup:<\/strong>\n<\/p>\n\n\n\n

              \n \n
            • Use a connector like Sherpaan, Marello, or a custom Zapier\/Make integration to sync Shopify orders to Exact Online<\/li>\n\n \n
            • Map the vat-id<\/code> order attribute to the “BTW-nummer” field on the Exact Online contact<\/li>\n\n \n
            • When Exact generates invoices, it pulls the VAT number from the contact record and applies the correct ICL (intracommunautaire levering) tax code<\/li>\n\n<\/ul>\n\n\n\n

              \n For Dutch sellers: the VAT number is required on your ICP-opgave (EC Sales List). Having it flow automatically from checkout to Exact saves you from manually cross-referencing orders at the end of each quarter.\n<\/p>\n\n\n\n

              Moneybird<\/h2>\n\n\n\n

              \n Moneybird is a popular Dutch and Belgian cloud accounting tool known for its clean interface and strong VAT handling. Many smaller Dutch Shopify stores use it.\n<\/p>\n\n\n\n

              \n Setup:<\/strong>\n<\/p>\n\n\n\n

                \n \n
              • Connect Shopify to Moneybird via their API or a connector like Zapier<\/li>\n\n \n
              • Map the vat-id<\/code> order attribute to Moneybird’s “BTW-nummer” contact field<\/li>\n\n \n
              • Moneybird automatically applies the “Levering\/dienst naar landen binnen de EU (intracommunautair)” tax rate (0%) when a valid EU VAT number is present<\/li>\n\n \n
              • The VAT number appears on the generated invoice with the correct reverse charge notice<\/li>\n\n<\/ul>\n\n\n\n

                \n Moneybird also generates the ICP declaration data you need for your quarterly VAT filing with the Belastingdienst.\n<\/p>\n\n\n\n

                e-Boekhouden<\/h2>\n\n\n\n

                \n e-Boekhouden is a widely used Dutch accounting platform, particularly among ZZP’ers and small businesses. It’s affordable and handles Dutch VAT requirements well.\n<\/p>\n\n\n\n

                \n Setup:<\/strong>\n<\/p>\n\n\n\n

                  \n \n
                • Use a connector or webhook-based integration to push Shopify order data to e-Boekhouden<\/li>\n\n \n
                • Include the vat-id<\/code> from the order’s note_attributes in the customer record<\/li>\n\n \n
                • e-Boekhouden uses the VAT number to determine the correct tax treatment for intracommunautaire leveringen<\/li>\n\n<\/ul>\n\n\n\n

                  Xero<\/h2>\n\n\n\n

                  \n Xero is widely used across the UK, Ireland, and increasingly in other European markets. It handles multi-currency and VAT well, making it a solid choice for cross-border B2B sellers.\n<\/p>\n\n\n\n

                  \n Setup:<\/strong>\n<\/p>\n\n\n\n