Skip to main content
Question

Create an invoice in Xero & log it in an AirTable


Forum|alt.badge.img

So … we are a small boutique hotel, renting private suites, and I’m trying to automate all my accounting tasks.

I have a webhook that is pulling in data from a transaction, I need to create an invoice in Xero with that and log it in an AirTable.

Issues:​​​​​​

I have the grand total, I need to be able to create the invoice from that total, so I’ve set up a crazy multi step zap, but I know there’s an easier way to do this … I’ve just been looking at it for too long.:upside_down:

so … the Grand Total is 366.85 … I started with a math operation Numbers zap to subtract the 15% tax and the fee.  But maybe there’s a good spreadsheet style formula that will be better?:rolling_eyes:

Did this topic help you find an answer to your question?
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

GetUWired
Forum|alt.badge.img+12
  • Zapier Expert
  • 1030 replies
  • February 3, 2021

@AmandaAdama 

can you elaborate on the crazy multi steps? Possibly share screenshots of the set up so that I can further assist simplifying 


Forum|alt.badge.img
  • Author
  • Beginner
  • 3 replies
  • February 3, 2021

It’s just math, I guess.  

Anyway, I had a professional set something up for me.  I think he’ll figure it out.

Thanks for the reply. :)


GetUWired
Forum|alt.badge.img+12
  • Zapier Expert
  • 1030 replies
  • February 3, 2021

@AmandaAdama 

No problem! Always happy to assist if it’s ever needed!