I am using Zapier to trigger an Invoice in Xero (Accounting) from Lodgify (Short-term rental management software).
I have a Zap setup & working that imports all of the summary data but it come thru as a single line item, and then requires manual editing to split out the room rate fee's and the cleaning fee, linen fee, commission, etc.
I need assistance to import 2 or 3 line items where the room fee's, cleaning and linen fee's can be on separate line items on Xero Invoice.
I have tried setting up using "Utilities Formatter on Zapier" using the "Text to Line Item" feature, however I can not work out how split into line items based on API data available form Lodgify? It may be that the Lodgify API is not providing granular data?
I have attached screenshots of the fields available when setting up Zap and the resulting import into Xero, Invoice as created by Xero/Zapier, and Manual Edit of Invoice.
Thanks for your assistance.
Kind Regards
Paul