Best answer

Creating a Stripe invoice in QuickBooks Online: Amount issue

  • 10 February 2022
  • 3 replies
  • 77 views

I have a zap from stripe when a payment is made that checks to see if the customer exists in quickbooks online, and adds the customer if needed. Then it adds the invoice, payment, and stripe fee into quickbooks. However, there are two issue I am running into is a multi-line invoice. 

The reason for this is stripe sends the amounts with out the decimal place. For Example Amount {100, 100, 120} when really the amounts were $1.00, $1.00, $1.20. So I need to adjust the amounts and the unit price to be divided by 100. For a single line invoice it is not difficult, but not sure how to be able to do that for multiple lines. 

Any thoughts on how to do this?

icon

Best answer by Troy Tessalone 10 February 2022, 22:41

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.

3 replies

Userlevel 7
Badge +14

Hi @Griffin

This can be handled in a Zap Code step: https://zapier.com/apps/code/help

Userlevel 7
Badge +14

@Griffin 

Try this Code:

 

CONFIG

 

OUTPUT

 

That was exactly what I needed! Thank you!