G’day @SabineSchr, 

I’ve created a similar zap using Mews as the trigger & SMSGlobal as the Action, however you should be able to use any SMS platform which integrates with Zapier for the action.

I’ve recreated it just now in Mews Demo & tested and it works. 

wow, thank you very much for your help.

I will try it :)

@Mick do you also have a solution for an automatic alert at the day of arrival, if the booked room is not paid until 5 am?

We do have a “mews_action-required” for invalid credit cards

but not for bookings which still have an open amount. As we only accept check-in with 100% pre-payment it would be a good automatization about the employees to relieve.

Any ideas how to do it?

@Mick The Zap with SMS after check in is working Thank you very much.

Hi @SabineSchr, 

Great to hear, I am glad you‘ve got it working! 

I do not have a ready solution for reservations with outstanding balances. The money does not sit on a reservation, it is linked to a guest's profile, making it difficult to find an easy solution. We have attempted to use Mews API and PowerBI to create a dashboard of guests with balances, but it has proven to be challenging.

A possible workaround is to schedule a reservation report with the status "arriving," select the "load balance" flag, and then filter the Excel document by the "load balance" column to identify reservations with outstanding balances.

I’d be interested to hear how everyone else is handling this. 

Regards
Mick
 

Dear Mick

Thank you very much for your kind reply.

You mean this report, correct?

Here, we do have one problem The saldo will be 0,00 either when we already got an payment but also when the stay will be covered from the company. As you can see, we do have today two arrivals covered by company. How can this be monitored?

I do very much appreciate your help. 

Have a lovely day

Sabine

Hi @SabineSchr,

Thank you for raising a new concern.

Even if there is a company attached, the balance can be positive.

In these cases, the stay was already covered and the bill was closed. That’s why the saldo was 0. 

If there was still an open bill with the balance or unpaid items/deposits, even if the company would have been attached, the balance would be listed.

Please let me know if this helps

Wish you remarkable evening.

Joanna