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
  • How do I mark repeating invoices in Xero as paid when subscription is paid in Stripe?

Hi Guys

 

I have many customers set up in Stripe with subsription payments each month. 

I also have them set up on repeating invoices on Xero.

The issue is each time I get paid in Stripe I have to manually go in & mark the repeating invoice as paid.

No decent solution offered by Xero so is there any way to use Zapier to accomplish this? Perhaps by linking the subscription ID or the customers email / Date paid?

 

cheers

john

Hey there @EggDesign. Welcome to the Community! 😁

Do the payments captured by Stripe happen to collect the invoice number or reference?

If so, you could use a Find Invoice (Xero) action to search for the invoice based on the invoice number/reference that’s received from Stripe. Then you could follow that up with a Update Sales Invoice action to set the status of the invoice that was found to “Paid”.

Do you think that approach could work for your needs here?

Hi Sam

 

Thank you for the welcome! 🙂 Sounds like it could work but im assuming each invoice in Xero or Stripe has a unique refernce or Invoice number as they are repeating invoices? Im not sure but ill look into it! 

 

Is there a way to add the Stripe subscription ID as the corresponding reference  number on the repeating invoice in xero maybe?  

 And on xero

 

cheers

john

 

Sorry for the delay in replying here @EggDesign!

Hmm, if they’ve all got the same invoice number then that could be tricky as you wouldn’t be able to search for the date to determine which invoice it’s for. 🤔

If you there isn’t a way to get a unique ID or reference added for each recurring invoice I wonder if the New Sales Invoice Xero trigger would fire when that recurring invoice is created? If it does then perhaps you could keep a record of each invoice and the month it’s for in a Zapier Table. Then you could search the table when the payment comes in to find a match on both the subscription ID and the current month to find the relevant invoice for that month. To search for a specific month though, you’ll likely need a Formatter action to get the payment date converted into just the month and select it in the search action. More on how to convert dates into custom formats here: Modify date and time formats in Zaps

Hope that helps. If you run into any issues on that or have any further questions do let me know! 

Terms & Conditions