Solved

Reservation Payment Report?

  • 13 January 2023
  • 4 replies
  • 92 views

Userlevel 5
Badge

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!!

icon

Best answer by Mick 17 January 2023, 02:52

View original

4 replies

Userlevel 3
Badge

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 🌹

 

Userlevel 6
Badge +6

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

Userlevel 5
Badge

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!

Userlevel 6
Badge +6

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