About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

  • Home
  • Get Help
  • How Do I
  • Where can I find the “Stripe Other Fees” for Subscriptions, Invoicing, etc.?
Best answer

Where can I find the “Stripe Other Fees” for Subscriptions, Invoicing, etc.?

S

Hello!  I create a Sales Receipt in QBO for each new invoice in Stripe, and then I also create an Expense for the Stripe Transaction (credit card) fee.  This is tied to the customer and is (generally) working.  My question is where to find the “Stripe Other Fees” for Subscriptions, Invoicing, etc.  These are deducted from our payouts.  They appear to be a daily total of fees (e.g., if we have 4 payments in one day, we see one amount for that day for the .5% subscription fee).  I’m having trouble figuring out the trigger as I cannot locate a “Find Payout” or similar.  Does anyone know where I can find this?

 

I don’t think this is tied to a customer but I could be wrong.  I’m planning to set up a generic vendor “Stripe” to captures these expenses. Any thoughts or insights would be appreciated.

icon

Best answer by christina.d 14 June 2022, 23:19

View original
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

6 replies

christina.d
Userlevel 7
Badge +9

Hey there, @SusanW! Thanks for reaching out and welcome to the Community! 🎉 We’re so excited you’re here!

I dig some looking and I wonder if the “Find Charge” action might be helpful in locating the fees you’re looking for. The charge ID is required and should look something like ch_1234567890.:

Also in terms of actual setup this is slightly similar request that maybe helpful. Perhaps with a bit of tweaking for your needs.

I hope some of this helps! Keep us posted!

S

Hi Christina.d,

Thank you for your response.  The Balance_transaction_fee detail amount is the Stripe transaction fee (credit card fee).  I do have that fee.  I’m looking for the fees for Zapier services - the subscription fees and invoicing fees.  These are charged when our payouts are processed. Any other thoughts?  

S

Sorry, to clarify it’s the Additional Stripe Fees I’m trying to locate and not Zapier Fees.

 

christina.d
Userlevel 7
Badge +9

Hiya Susan! I can see you were able to open a ticket with my friends in support! I wanted to pop their response below in case it’s helpful! 

  • Looking at the New Invoice trigger you're using, and I can see that the product included on your invoice is included in the data being returned.
  • The Product name as well as the Price and Product ID.
  • Next, the Find Charge step being used returns the Stripe fee that can be used to create the additional line in your Sales Receipt.

You’ll also need to map the product code from Stripe to the Product ID from QuickBooks Online. A good way to accomplish this would be with a Lookup Table. You can read more about Lookup Tables here:
 
https://zapier.com/help/create/format/create-lookup-tables-in-zaps
 
For some added insight, the values on the left of your Lookup Table would be the Product ID's that you get from Stripe, and the value on the right would need to be the IDs of your products in QuickBooks Online that represent the Stripe products:
 
4a5fa731504cc41a9312d55358cdd539.png

I hope this gets ya back on track! 

S

Hello Christina.d,

Appreciate your response.  Just to clarify, I already have the Stripe Transaction fee (credit card fee) incorporated into my Zap.  Stripe has an additional fee for their services, and that’s what I cannot find in Zapier.  I’ve looked in Stripe (latest), Stripe (1.14.1) and Stripe (Legacy) for this information with no success.  I’ve looked in New Charge, New Event (specifically New Payout, which only provides the total payout), New Order and New Plan. I’ve tried to link the New Event/New Payout to a Subscription but cannot determine the unique key that links them.

 

First up is the Biling (Subscription) Fee, which I assume is triggered by a new subscription with a successful payment.  This is .5% fee payable to Stripe and not the Stripe Transaction Fee for credit card processing.

 

Any thoughts to find this info would be greatly appreciated. Thanks All!

S

Appreciate all the support but I’m manually adding information until we can find an automated solution.  Stripe processing fees (not credit card transaction fees) exist for any Stripe user so welcome your assistance if you see this note.

 

  

Terms & Conditions