Skip to main content

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

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions 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
  • Is it possible to create a Zap matching the Stripe payments with the QuickBooks invoice?

Hey, currently im trying to get a connection between stripe and quickbooks. My Team sends our invoice via quickbooks, these invoices include a stripe payment link. I want to create a Zap that matches the stripe payments with the existing quickbooks invoice (so that we now if it’s paid or not). To match both transactions we made it mandatory for our customers to type in the quickbooks invoice number in to stripe payment.

Can anyone help me with my problem? Is it even possible to create something like that with zapier?

 

Thank you very much for helping me!

Thanks for joining the Community here, @Livarto! 😁

Assuming the field that the customers fill out with the invoice number is sent over from Stripe I’d have thought you could achieve this using the following set up:

  • Trigger: New Payment (Stripe) - runs when a new payment is made.
  • Action: Find Customer (QuickBooks Online) - Since the Customer field in the next action is a required field this step is necessary in order to find the customers ID in QuickBooks.
  • Action: Create Payment (QuickBooks Online) - records a payment in QuickBooks using information selected from the Stripe trigger. For the Customer field, you’d choose the Custom value option and select the ID field from the Find Customer action. And for Line Linked Invoice field you’d select the invoice number supplied by the New Payment trigger.

 

That should allow the Zap to record the payment in QuickBooks and associate it with the correct customer and invoice. Want to give that setup a try and let us know how it goes? 

Hi @Livarto 

Good question.

You may be able to make this more dynamic by including the QBO Invoice ID in the metadata of the Stripe Payment Link.

 

Help: https://stripe.com/docs/payment-links/url-parameters

 

You can use these QBO Zap actions:

  • Find Invoice
  • Update Invoice

 

 

Hi @Livarto 

Good question.

You may be able to make this more dynamic by including the QBO Invoice ID in the metadata of the Stripe Payment Link.

 

Help: https://stripe.com/docs/payment-links/url-parameters

 

You can use these QBO Zap actions:

  • Find Invoice
  • Update Invoice

 

 

 

Hey Troy, thank you so much for your help! You really understand my problem and you got the solution. I still have a question. Please excuse my question, ill bet its sounds very stupid to you, but im completely new in that topic. Do i need to write some code to get the QBO Invoice ID in to the meta data. I watched a video on youtube and i asked chatGpt both told me to that i have to write code.

Thank you very much!

@Livarto 

You can use a combo of a static value and dynamic value to create the Stripe Payment Link.

In Airtable you can do this with a Formula field.

e.g. if this is the Stripe Payment Link: https://stripepaymentlink.com

Then modify to be like this: https://stripepaymentlink.com?client_reference_id==VALUE]

>VALUE] would be the dynamic value you want to send.

BE SURE TO TEST!

Terms & Conditions