{"id":17038,"date":"2021-08-13T17:24:28","date_gmt":"2021-08-13T17:24:28","guid":{"rendered":"https:\/\/synder.com\/help\/?p=17038"},"modified":"2026-09-17T19:44:52","modified_gmt":"2026-09-17T19:44:52","slug":"how-to-sync-stripe-metadata-into-quickbooks-online-with-synder","status":"publish","type":"post","link":"https:\/\/synder.com\/help\/how-to-sync-stripe-metadata-into-quickbooks-online-with-synder\/","title":{"rendered":"How to Sync Stripe Metadata Into QuickBooks Online With Synder"},"content":{"rendered":"\n

Integrating Stripe with your website or an eCommerce platform provides your clients with an effortless and safe way to pay for the goods and services you sell, and is certainly advantageous to your business. Synder<\/a> will help you auto-record all sales and expenses in your QuickBooks Online, categorize<\/a> and reconcile all the synced data in one click<\/a> giving you all the insights and allowing for efficient analytics and modeling of your business. Synder synchronizes Stripe transactions\u2019 metadata so that you don\u2019t miss a bit of information and get all the essential details reflected in your books.
If some customer, item, tax, or other transaction details are coded in the Stripe Metadata <\/em>field, follow the steps listed in this guide to set up Smart rules<\/a> so that Synder could transfer all the information to your QuickBooks automatically.<\/p>\n\n\n\n

Note:<\/strong> This automation is available for QuickBooks<\/strong> only. Stripe metadata is not available as a Smart Rules field in Xero, so it cannot be used to update transactions there.<\/p>\n\n\n\n

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

  1. Set up Smart rules to extract transaction details from Stripe metadata<\/a><\/li>
  2. 1) Sync Product and Service details from Stripe metadata with Smart rules<\/a><\/li>
  3. 2) Sync Customer details from Stripe metadata with Smart rules<\/a><\/li><\/ol>\n\n\n\n

    Note<\/strong>. Synder puts all information taken from the Stripe Metadata <\/em>field into the Memo <\/em>field in QuickBooks Online automatically. You need to set up a Smart rule in Synder to move the details needed to the corresponding field in QuickBooks (e.g. Tax<\/em>, Customer<\/em>, Product or Service<\/em>, Class <\/em>field, etc.).<\/p>\n\n\n\n

    Set up Smart rules to extract transaction details from Stripe metadata<\/strong><\/h2>\n\n\n\n

    By creating a rule, you can update any synchronized transaction adding missing data or correcting recorded data to make sure there is nothing you need to edit manually to have your books accurate and detailed. This provides you with each and every detailed reporting opportunity and the ability to make informed decisions for your business. Check out this detailed guide to learn more about How rules work in Synder<\/a>.<\/p>\n\n\n\n

    Smart rules work on the basis of if-then conditions, so you can create rules and make Synder adapt to your needs. The process contains 2 phases:<\/p>\n\n\n\n

    1. Synchronization of a transaction from Stripe to QuickBooks Online.<\/li>
    2. Update of the created QuickBooks transaction based on the information inside of it, which happens almost instantly based on the conditions of the rule.<\/li><\/ol>\n\n\n\n
      \nSync mode note:<\/strong> Smart Rules run in Per-Transaction sync only<\/strong>. They are not available in Summary Sync (Daily Summary)<\/strong> on any platform. If your organization syncs in Summary mode, use Mapping \/ Grouping<\/a> instead — it is the Summary-mode substitute for Smart Rules.

      New to sync modes? See       How Smart Rules Work in Synder<\/a>.\n<\/div>\n\n\n\n\n\n

      Below are examples of how to extract various transaction details from Stripe metadata and sync them to QuickBooks Online with the help of Smart rules. You can use the same principle to build any rule and adjust Synder to your specific needs.<\/p>\n\n\n\n

      1. Sync Product and Service details from Stripe metadata with Smart rules<\/strong><\/h2>\n\n\n\n

      Step 1<\/strong>. Go to the Smart rules<\/strong> tab on the left menu \u2192 Rules <\/em>\u2192 hit the Create rule<\/strong> button.<\/p>\n\n\n\n

      \"\"<\/figure>\n\n\n\n

      Step 2<\/strong>. As a trigger that starts the rule, select Sales Receipt* \u2192 Created \u2192 Condition* button. Once you sync a transaction via Synder, you will have both Expense and Sales Receipt\/Invoice\/Payment created in QuickBooks, and the created Sales Receipt will trigger a rule to work.
      *Sales Receipt<\/em><\/strong>. During the synchronization, Synder can create different objects such as Sales Receipts, Invoices, Payments, Refund receipts etc. in your books, make sure you selected the one needed to trigger the rule. 
      *Condition<\/em><\/strong> means that you are going to specify additional conditions for the rule to be applied to specific Sales Receipts. You can select Action<\/em><\/strong> right away if you want the flow to be applied to each of the synchronized Sales Receipts.<\/p>\n\n\n\n

      \"\"<\/figure>\n\n\n\n

      Step 3<\/strong>. Now we start to build our if-then algorithm. From the Select field<\/em> dropdown select Memo <\/strong>\u2192 Contains  \u2192 Name of the Product or Service (e.g. Apple) \u2192 click Yes. That means, if <\/strong>the Memo field of a transaction contains the value \u201cApple\u201d, then<\/strong> the action described at the next step will be applied to the Sales Receipt.<\/p>\n\n\n\n

      \"\"<\/figure>\n\n\n\n

      Step 4<\/strong>. You can continue adding conditions (if<\/em>-boxes), but for our current rule, we select the Actions <\/strong>button. Select QuickBooks action<\/em> to be applied to Sales Receipt<\/em> \u2192 Update current<\/em>* \u2192 Set QuickBooks entity data<\/em>. 
      *Update Current<\/em><\/strong> \u2013 <\/em>an option to update currently synchronized Sales Receipt which triggered the rule.<\/em><\/p>\n\n\n\n

      \"\"<\/figure>\n\n\n\n

      Step 5<\/strong>. Select the item from the dropdown with your QuickBooks Products and Services that will be associated with the Sales Receipt if it matches the previously set conditions. Click the Submit <\/strong>button \u2192  Save & Close rule<\/strong>.
      Note<\/strong>. You can also modify other fields of the Sales Receipt and edit tax, customer, class, etc.<\/p>\n\n\n\n

      \"\"<\/figure>\n\n\n\n

      Once a transaction that is compliant with the selected criteria is synced you can go to Smart rules <\/strong>\u2192 Executions<\/strong> to check if the rule was triggered and applied or check the execution under the Synced transaction at once. Use the \u201cShow object<\/em>\u201d link to open the log of the transaction updated by the rule.<\/p>\n\n\n\n

      \"\"<\/figure>\n\n\n\n

      Hit Show in QB<\/em> to see the results on the QuickBooks side and check your P&L reports.<\/p>\n\n\n\n

      \"\"<\/figure>\n\n\n\n

      Congratulations, you did it! Enjoy the automatic categorization<\/a> of synced data and precise Profit and Loss reports that will provide you with all the necessary info to plan and develop your business.<\/p>\n\n\n\n

      2. Sync Customer details from Stripe metadata with Smart rules<\/strong><\/h2>\n\n\n\n

      Step 1<\/strong>. Go to the Smart rules<\/strong> tab on the left menu \u2192 Rules <\/em>\u2192 hit the Create rule<\/strong> button.<\/p>\n\n\n\n

      \"\"<\/figure>\n\n\n\n

      Step 2<\/strong>. As a trigger that starts the rule, select Sales Receipt* \u2192 Created \u2192 Condition* button. Once you sync a transaction via Synder, you will have both Expense and Sales Receipt\/Invoice\/Payment created in QuickBooks, and the created Sales Receipt will trigger a rule to work.
      *Sales Receipt<\/em><\/strong>. During the synchronization, Synder can create different objects such as Sales Receipts, Invoices, Payments, Refund receipts etc. in your books, make sure you selected the one needed to trigger the rule. 
      *Condition<\/em><\/strong> means that you are going to specify additional conditions for the rule to be applied to specific Sales Receipts. You can select Action<\/em><\/strong> right away if you want the flow to be applied to each of the synchronized Sales Receipts.<\/p>\n\n\n\n

      \"\"<\/figure>\n\n\n\n

      Step 3<\/strong>. Now we start to build our if-then algorithm. From the Select field<\/em> dropdown, select Memo <\/strong>\u2192 Contains  \u2192 Customer\u2019s info (e.g. email, shipping address, Name etc.) \u2192 click Yes<\/strong>. That means, if <\/strong>the Memo field of a transaction contains the value \u201cdiego.rodriguez@example.com\u201d, then<\/strong> the action described at the next step will be applied to the Sales Receipt.<\/p>\n\n\n\n

      \"\"<\/figure>\n\n\n\n

      Step 4<\/strong>. You can continue adding conditions (if<\/em>-boxes), but for our current rule, we select the Actions <\/strong>button. Select QuickBooks action<\/em> to be applied to Sales Receipt<\/em> \u2192 Update current<\/em>* \u2192 Set QuickBooks entity data<\/em>. 
      *Update Current<\/em><\/strong> \u2013 <\/em>an option to update currently synchronized Sales Receipt which triggered the rule.<\/em><\/p>\n\n\n\n

      \"\"<\/figure>\n\n\n\n

      Step 5<\/strong>. Select the Customer needed from the dropdown with your QuickBooks Customer list that will be associated with the Sales Receipt if it matches the previously set conditions. You can also modify other fields of the Sales Receipt and edit item, tax, class, etc. Click the Submit <\/strong>button \u2192  Save & Close rule<\/strong>.<\/p>\n\n\n\n

      \"\"<\/figure>\n\n\n\n

      Once a transaction that is compliant with the selected criteria is synced, you can go to Smart rules<\/strong> \u2192 Executions<\/strong> to check if the rule was triggered and applied or check the execution under the Synced transaction at once. Use the \u201cShow object<\/em>\u201d link to open the log of the transaction updated by the rule.<\/p>\n\n\n\n

      \"\"<\/figure>\n\n\n\n

      Hit Show in QB<\/em> to see the results on the QuickBooks side and check your P&L reports.<\/p>\n\n\n\n

      \"\"<\/figure>\n\n\n\n

      Congratulations, you did it! Enjoy the automatic categorization<\/a> of synced data and precise Profit and Loss reports that will provide you with all the necessary info to plan and develop your business.<\/p>\n\n\n\n

      Reach out to the Synder team<\/em><\/a> via online support chat, phone, or email with any questions you have \u2013 we\u2019re always happy to help you!<\/p>\n\n\n\n