{"id":1302,"date":"2026-05-05T09:16:01","date_gmt":"2026-05-05T09:16:01","guid":{"rendered":"https:\/\/balancify.nl\/kennisbank\/geen-categorie\/submitting-shopify-files-for-your-bookkeeping-how-it-works\/"},"modified":"2026-05-05T09:28:06","modified_gmt":"2026-05-05T09:28:06","slug":"submitting-shopify-files-for-your-bookkeeping-how-it-works","status":"publish","type":"doc","link":"https:\/\/balancify.nl\/en\/kennisbank\/e-commerce\/submitting-shopify-files-for-your-bookkeeping-how-it-works\/","title":{"rendered":"Submitting Shopify files for your bookkeeping: how it works"},"content":{"rendered":"

Do you use Shopify for your webshop? Then we\u2019ll need a few files from you to process your bookkeeping correctly.<\/p>\n

No worries \u2014 below you\u2019ll see exactly what to submit \ud83d\udc47<\/p>\n

\n

1. Order export from Shopify (quarterly)<\/h2>\n

Send us an Excel export of all your orders each quarter<\/strong>.<\/p>\n

\ud83d\udc49 We\u2019ll take care of the rest.<\/p>\n

\ud83d\udccc Important<\/h3>\n

Is your Shopify backend set to EUR<\/strong>?<\/p>\n

\ud83d\udc49 Then we may be able to set up a connection with Jortt
\ud83d\udc49 In that case, you won\u2019t need to send Excel files anymore<\/p>\n

Just send us a message and we\u2019ll check this for you.<\/p>\n

\n

Where can you find the export?<\/h3>\n
    \n
  • Go to Orders<\/strong> in Shopify<\/li>\n
  • Click Export<\/strong><\/li>\n
  • Choose All orders<\/strong> or a date range<\/li>\n
  • Select the correct quarter<\/li>\n
  • Download as Excel\/CSV<\/strong><\/li>\n<\/ul>\n
    \n

    What\u2019s included?<\/h3>\n

    This file includes:<\/p>\n

      \n
    • revenue<\/li>\n
    • VAT<\/li>\n
    • orders<\/li>\n
    • country of delivery<\/strong><\/li>\n<\/ul>\n

      \ud83d\udc49 We use this to:<\/p>\n

        \n
      • process your VAT correctly<\/li>\n
      • handle OSS (international sales)<\/li>\n
      • allocate your revenue properly<\/li>\n<\/ul>\n

        \u26a0\ufe0f Send this file via WhatsApp<\/strong>
        (Jortt does not support Excel uploads)<\/p>\n

        \n

        2. Shopify invoices (monthly)<\/h2>\n

        Upload your Shopify invoices in Jortt every month.<\/p>\n

        Where can you find them?<\/h3>\n
          \n
        • Go to Shopify \u2192 Payouts \u2192 Documents<\/strong><\/li>\n<\/ul>\n
          \n

          What\u2019s included?<\/h3>\n
            \n
          • transaction fees<\/li>\n
          • payment fees<\/li>\n
          • other Shopify costs<\/li>\n<\/ul>\n

            \ud83d\udc49 We use this to process your expenses<\/p>\n

            \n

            3. Using a payment provider? (like Mollie)<\/h2>\n

            Are you using a payment provider alongside Shopify?<\/p>\n

            Then we\u2019ll also process those payouts and fees.<\/p>\n

            \ud83d\udc49 We recommend Mollie
            It has an automatic integration with Jortt<\/strong><\/p>\n

            \u2714\ufe0f Less manual work
            \u2714\ufe0f Automatic processing
            \u2714\ufe0f Always accurate reconciliation<\/p>\n

            Using a different provider?
            Then please send us:<\/p>\n

              \n
            • payout reports<\/li>\n
            • fee overviews<\/li>\n<\/ul>\n
              \n

              4. Using PayPal?<\/h2>\n

              Then send us a quarterly overview of:<\/p>\n

                \n
              • all transactions<\/li>\n
              • fees<\/li>\n
              • refunds<\/li>\n<\/ul>\n

                \ud83d\udc49 This helps us reconcile everything correctly<\/p>\n

                \u26a0\ufe0f Excel files should be submitted via WhatsApp<\/strong><\/p>\n

                \n

                How we process this<\/h2>\n
                  \n
                • You send the files<\/li>\n
                • We process revenue and VAT<\/li>\n
                • We book all costs<\/li>\n
                • We make sure everything matches<\/li>\n<\/ul>\n

                  \ud83d\udc49 You don\u2019t have to worry about anything<\/p>\n

                  \n

                  Conclusion (quick summary)<\/h2>\n

                  Please submit:<\/p>\n

                    \n
                  • \ud83d\udcca Order export \u2192 quarterly (via WhatsApp)<\/li>\n
                  • \ud83d\udcc4 Shopify invoices \u2192 monthly upload<\/li>\n
                  • \ud83d\udcb3 Payment provider data (if applicable)<\/li>\n
                  • \ud83d\udcb3 PayPal overview (if applicable)<\/li>\n<\/ul>\n

                    \ud83d\udc49 We\u2019ll handle the rest.<\/p>\n","protected":false},"featured_media":1300,"template":"","meta":{"_acf_changed":false},"kennisbank-categorie":[31],"class_list":["post-1302","doc","type-doc","status-publish","has-post-thumbnail","hentry","kennisbank-categorie-e-commerce"],"acf":[],"yoast_head":"\nSubmitting Shopify files for your bookkeeping: how it works | Balancify<\/title>\n<meta name=\"description\" content=\"Doing your Shopify bookkeeping? Find out which files you need to submit to keep your accounts complete and accurate.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/balancify.nl\/en\/kennisbank\/e-commerce\/submitting-shopify-files-for-your-bookkeeping-how-it-works\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Submitting Shopify files for your bookkeeping: how it works | Balancify\" \/>\n<meta property=\"og:description\" content=\"Doing your Shopify bookkeeping? Find out which files you need to submit to keep your accounts complete and accurate.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/balancify.nl\/en\/kennisbank\/e-commerce\/submitting-shopify-files-for-your-bookkeeping-how-it-works\/\" \/>\n<meta property=\"og:site_name\" content=\"Balancify\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/balancifyboekhouden\" \/>\n<meta property=\"article:modified_time\" content=\"2026-05-05T09:28:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/balancify.nl\/wp-content\/uploads\/2026\/05\/shopify-bestanden-aanleveren.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1536\" \/>\n\t<meta property=\"og:image:height\" content=\"1024\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@balancify\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/balancify.nl\\\/en\\\/kennisbank\\\/e-commerce\\\/submitting-shopify-files-for-your-bookkeeping-how-it-works\\\/\",\"url\":\"https:\\\/\\\/balancify.nl\\\/en\\\/kennisbank\\\/e-commerce\\\/submitting-shopify-files-for-your-bookkeeping-how-it-works\\\/\",\"name\":\"Submitting Shopify files for your bookkeeping: how it works | Balancify\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/balancify.nl\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/balancify.nl\\\/en\\\/kennisbank\\\/e-commerce\\\/submitting-shopify-files-for-your-bookkeeping-how-it-works\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/balancify.nl\\\/en\\\/kennisbank\\\/e-commerce\\\/submitting-shopify-files-for-your-bookkeeping-how-it-works\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/balancify.nl\\\/wp-content\\\/uploads\\\/2026\\\/05\\\/shopify-bestanden-aanleveren.png\",\"datePublished\":\"2026-05-05T09:16:01+00:00\",\"dateModified\":\"2026-05-05T09:28:06+00:00\",\"description\":\"Doing your Shopify bookkeeping? Find out which files you need to submit to keep your accounts complete and accurate.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/balancify.nl\\\/en\\\/kennisbank\\\/e-commerce\\\/submitting-shopify-files-for-your-bookkeeping-how-it-works\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/balancify.nl\\\/en\\\/kennisbank\\\/e-commerce\\\/submitting-shopify-files-for-your-bookkeeping-how-it-works\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/balancify.nl\\\/en\\\/kennisbank\\\/e-commerce\\\/submitting-shopify-files-for-your-bookkeeping-how-it-works\\\/#primaryimage\",\"url\":\"https:\\\/\\\/balancify.nl\\\/wp-content\\\/uploads\\\/2026\\\/05\\\/shopify-bestanden-aanleveren.png\",\"contentUrl\":\"https:\\\/\\\/balancify.nl\\\/wp-content\\\/uploads\\\/2026\\\/05\\\/shopify-bestanden-aanleveren.png\",\"width\":1536,\"height\":1024,\"caption\":\"Minimalist image of a laptop with a webshop dashboard on a white background.\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/balancify.nl\\\/en\\\/kennisbank\\\/e-commerce\\\/submitting-shopify-files-for-your-bookkeeping-how-it-works\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/balancify.nl\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Submitting Shopify files for your bookkeeping: how it works\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/balancify.nl\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/balancify.nl\\\/en\\\/\",\"name\":\"Balancify\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/balancify.nl\\\/en\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/balancify.nl\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/balancify.nl\\\/en\\\/#organization\",\"name\":\"Balancify\",\"url\":\"https:\\\/\\\/balancify.nl\\\/en\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/balancify.nl\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/balancify.nl\\\/wp-content\\\/uploads\\\/2024\\\/06\\\/balancify-logo.png\",\"contentUrl\":\"https:\\\/\\\/balancify.nl\\\/wp-content\\\/uploads\\\/2024\\\/06\\\/balancify-logo.png\",\"width\":696,\"height\":696,\"caption\":\"Balancify\"},\"image\":{\"@id\":\"https:\\\/\\\/balancify.nl\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/balancifyboekhouden\",\"https:\\\/\\\/x.com\\\/balancify\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Submitting Shopify files for your bookkeeping: how it works | Balancify","description":"Doing your Shopify bookkeeping? Find out which files you need to submit to keep your accounts complete and accurate.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/balancify.nl\/en\/kennisbank\/e-commerce\/submitting-shopify-files-for-your-bookkeeping-how-it-works\/","og_locale":"en_US","og_type":"article","og_title":"Submitting Shopify files for your bookkeeping: how it works | Balancify","og_description":"Doing your Shopify bookkeeping? Find out which files you need to submit to keep your accounts complete and accurate.","og_url":"https:\/\/balancify.nl\/en\/kennisbank\/e-commerce\/submitting-shopify-files-for-your-bookkeeping-how-it-works\/","og_site_name":"Balancify","article_publisher":"https:\/\/www.facebook.com\/balancifyboekhouden","article_modified_time":"2026-05-05T09:28:06+00:00","og_image":[{"width":1536,"height":1024,"url":"https:\/\/balancify.nl\/wp-content\/uploads\/2026\/05\/shopify-bestanden-aanleveren.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_site":"@balancify","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/balancify.nl\/en\/kennisbank\/e-commerce\/submitting-shopify-files-for-your-bookkeeping-how-it-works\/","url":"https:\/\/balancify.nl\/en\/kennisbank\/e-commerce\/submitting-shopify-files-for-your-bookkeeping-how-it-works\/","name":"Submitting Shopify files for your bookkeeping: how it works | Balancify","isPartOf":{"@id":"https:\/\/balancify.nl\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/balancify.nl\/en\/kennisbank\/e-commerce\/submitting-shopify-files-for-your-bookkeeping-how-it-works\/#primaryimage"},"image":{"@id":"https:\/\/balancify.nl\/en\/kennisbank\/e-commerce\/submitting-shopify-files-for-your-bookkeeping-how-it-works\/#primaryimage"},"thumbnailUrl":"https:\/\/balancify.nl\/wp-content\/uploads\/2026\/05\/shopify-bestanden-aanleveren.png","datePublished":"2026-05-05T09:16:01+00:00","dateModified":"2026-05-05T09:28:06+00:00","description":"Doing your Shopify bookkeeping? Find out which files you need to submit to keep your accounts complete and accurate.","breadcrumb":{"@id":"https:\/\/balancify.nl\/en\/kennisbank\/e-commerce\/submitting-shopify-files-for-your-bookkeeping-how-it-works\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/balancify.nl\/en\/kennisbank\/e-commerce\/submitting-shopify-files-for-your-bookkeeping-how-it-works\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/balancify.nl\/en\/kennisbank\/e-commerce\/submitting-shopify-files-for-your-bookkeeping-how-it-works\/#primaryimage","url":"https:\/\/balancify.nl\/wp-content\/uploads\/2026\/05\/shopify-bestanden-aanleveren.png","contentUrl":"https:\/\/balancify.nl\/wp-content\/uploads\/2026\/05\/shopify-bestanden-aanleveren.png","width":1536,"height":1024,"caption":"Minimalist image of a laptop with a webshop dashboard on a white background."},{"@type":"BreadcrumbList","@id":"https:\/\/balancify.nl\/en\/kennisbank\/e-commerce\/submitting-shopify-files-for-your-bookkeeping-how-it-works\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/balancify.nl\/en\/"},{"@type":"ListItem","position":2,"name":"Submitting Shopify files for your bookkeeping: how it works"}]},{"@type":"WebSite","@id":"https:\/\/balancify.nl\/en\/#website","url":"https:\/\/balancify.nl\/en\/","name":"Balancify","description":"","publisher":{"@id":"https:\/\/balancify.nl\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/balancify.nl\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/balancify.nl\/en\/#organization","name":"Balancify","url":"https:\/\/balancify.nl\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/balancify.nl\/en\/#\/schema\/logo\/image\/","url":"https:\/\/balancify.nl\/wp-content\/uploads\/2024\/06\/balancify-logo.png","contentUrl":"https:\/\/balancify.nl\/wp-content\/uploads\/2024\/06\/balancify-logo.png","width":696,"height":696,"caption":"Balancify"},"image":{"@id":"https:\/\/balancify.nl\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/balancifyboekhouden","https:\/\/x.com\/balancify"]}]}},"_links":{"self":[{"href":"https:\/\/balancify.nl\/en\/wp-json\/wp\/v2\/doc\/1302","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/balancify.nl\/en\/wp-json\/wp\/v2\/doc"}],"about":[{"href":"https:\/\/balancify.nl\/en\/wp-json\/wp\/v2\/types\/doc"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/balancify.nl\/en\/wp-json\/wp\/v2\/media\/1300"}],"wp:attachment":[{"href":"https:\/\/balancify.nl\/en\/wp-json\/wp\/v2\/media?parent=1302"}],"wp:term":[{"taxonomy":"kennisbank-categorie","embeddable":true,"href":"https:\/\/balancify.nl\/en\/wp-json\/wp\/v2\/kennisbank-categorie?post=1302"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}