Hi,

Thank you for the interesting question. 

I hope our community members can share their experiences with us.

Did you try to check the reservation report with the option load balances?

After exporting to Excel you will have the balance as well as the Bill no. if already closed. 

Looking for your kind feedback.

Thank you.

Joanna

Hi @Ethros, 

To my knowledge, I do not think there is a single report which includes this

As you mention, payments in Mews do not sit against a reservation, they sit on a guest profile & are only associated to a reservation once you close the bill. 

​​​As @Joanna.Svehlova mentions, the reservation report with load balances option checked could be used in conjunction with the accounting report to tie it all back together. 

These reports could be scheduled to be emailed to your accountant & with some excel magic it could be collated into a single document. 

Hope that helps. 

Regards
Mick

Hi - 

I’ve checked that report.   It is completed stays we are after, as opposed to open balances.

Yes - hoping for some communal brain power!

Hi @Ethros, 

If you changed the status to only include checked out reservations for the required date range, would that suffice?