Skip to main content
Solved

Reservation Payment Report?

  • January 13, 2023
  • 4 replies
  • 114 views

Ethros
Forum|alt.badge.img

Hi

 

My accountant is asking for a report that details each reservation and their payments.

Is there a way to extract this information?

 

Looking at the various reports I can get all the reservations and their totals.

And all the payments and their bills per person (the MEWS way)

 

Anyone have an idea how to get the payments per reservation?

 

Thanks!!

Best answer by Mick

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

View original
Did this topic help you find an answer to your question?

Joanna.Svehlova
Mews Employee
Forum|alt.badge.img

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 🌹

 


Mick
Guru
Forum|alt.badge.img+6
  • Guru
  • January 17, 2023

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


Ethros
Forum|alt.badge.img
  • Helper
  • January 18, 2023

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!


Mick
Guru
Forum|alt.badge.img+6
  • Guru
  • January 18, 2023
Ethros wrote:

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? 

 

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings