What is the In-House Report?

Modified on Wed, 13 Mar at 3:01 PM

Activate Deposits by Signing Up!

Get ahead with exclusive access! Premium & Enterprise hoteliers can request activation of all the Deposits reports now by signing up for our exclusive Focus Group. Don't miss the chance to streamline your revenue management with RoomRaccoon.


The In-House Report is a comprehensive report designed to track and display all transactions made by guests during their stay at the hotel, spanning the period from check-in to check-out. This report offers a dynamic view of revenue movements, reflecting how guests' experiences and expenditures contribute to the hotel's overall income.

Upon guest check-in, any pre-payments are included in the "opening balance," forming an integral part of the hotel's total revenue accrued from each guest's stay. The report provides a granular analysis, showing daily opening balances, transaction activities (movement balance), and closing balances, all selectable by specific dates (per day selection). Each entry is categorised by reservation ID, offering an expected breakdown of balances throughout the guest's stay. 

Understanding Balances in the In-House Report

Opening Balance

This represents the total balance at the start of a day. The guest's prepayment (which we recognise as a deposit), becomes redeemed upon check-in, and is factored into this initial balance as a negative value. As guests consume additional services and experiences, their expenditure increases, affecting the closing balance in a positive direction. 

Moving Balance

This balance indicates the daily consumption of hotel services. This figure directly influences the closing balance value, shifting it towards either a positive value (guest owes the hotel) or a negative value (hotel owes the guest for services or refunds).

Please Note: Discounts and surcharges that you apply to the reservation will also contribute to the moving balance. In the case of a surcharge, this will add a positive value to the balance (guest owes more). In the case of a discount, this will add a negative value to the balance (guest owes less). 

Closing Balance

This represents the total outstanding payments owed by either the guests or your hotel at the end of each day. A negative value implies a debt from your hotel to the guest, while a positive value indicates the guest’s debt to your hotel (the guest owes you an outstanding payment). This is synced and locked in for the day upon closing your daily revenue. Upon generation of the guest invoice, the final amount that the guest owes your hotel will be listed for expected payment.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article