Question

Post to Slack when new Xero expense claim submitted - trouble getting test data

  • 15 May 2023
  • 5 replies
  • 19 views

Userlevel 1

I am trying to set up a Zap that sends a Slack notification once a new expense has been submitted to Xero. However, it does not pull through any recent data for testing. The Xero trigger event is “New Expense Claim Receipt”. This is the only one I could see related to expenses in Xero, but perhaps ‘receipt’ is not actually a submission? Has anyone else tried this process? 


5 replies

Userlevel 7
Badge +8

Hi @cb_etch - welcome to community! 

I’m not overly familiar with Xero but I wonder if you could try the “New Bill” Trigger since it relates to Accounts Payable and see if that pulls through your test data. 

If that doesn’t help, can you share some screenshots of your set up with us (void of personal info) so we can take a closer look? 

Userlevel 1

Thanks Liz. I tried out your suggestion and it works great when the trigger is set as a New Bill. However, our internal process dictates that expenses don’t get converted in to a ‘Bill’ until they are approved. The purpose of this Zap is to allow us to manage expense approvals in a different way. i.e. We’d get a Slack notification when a new request has been submitted so that our commercial team can mark it with a checkmark emoji when approved, which in turn indicates to our finance person that they can go ahead and generate a new Bill in Xero ready for payment. 
Therefore, ideally I’d need to use the New Expense Claim trigger, but it doesn’t work.

Userlevel 7
Badge +6

Hi there @cb_etch,

I appreciate the detailed explanation of the issue.

The trigger "New Expense Claim Receipt," is triggering on the "Receipt" portion. In Xero, You have the Expense Claim and then you have the associated Receipts attached to it - it's the Receipt portion that is being used for this trigger. So if you create an expense claim, but if there aren't any Receipts associated to it, it wouldn't trigger the Zap.

So just to double-check — are you trying to trigger when a new Expense Claim is added or if a new (Expense Claim) Receipt is added? This will help with determining which trigger might work best. For instance, Xero deprecated the Expense API in 2018, and now instead use "Account Payable" Bills/Invoices for Expenses. So the "New Bill" trigger might work better when coupled with a filter step it only run on specific types of Bills (aka Expenses).

Thanks! 😊

Userlevel 1

Hi, Thanks so much for your reply. This is useful info and it’s a shame that the original expense API is no longer available for use via Zapier.   
Not all of the expenses submitted to Xero by our staff have receipts attached, e.g. milage claims, so it doesn’t sound like the New Expense Claim Receipt trigger will be a reliable solution for us. 
I like your suggestion of filtering bills by type=expenses, but will need to see if we can adjust our internal process to work with this. 
Thanks again.

Userlevel 7
Badge +8

@cb_etch If you have any additional questions after working on your internal process, please don’t hesitate to reach back out! 😃

Reply