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.
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?