Finance Reports - Trial Balance

Modified on Mon, 2 Sep at 3:04 PM

This is an Accounting report which shows the movement from deposits to guest ledger for a full date as per selection, including totals for deposits both received and redeemed and in-house balance movements.  

This report does not work in the same manner as a traditional trial balance in your account solution. This works on a day by day basis rather than on a period basis.  

 

Deposit Ledger

  • Start Balance – This will be the balance of the deposit ledger at the beginning of that day.
  • Deposits Received – Splits out the way in which the deposits have been paid e.g. Mastercard or Bank Transfer.
  • Deposits Transferred to In-House – These are deposits that have been moved from the deposit ledger as the guest has now checked in.
  • End Balance – This will be the balance of deposit ledger at the end of that day.


Start Balance + Deposits Received - Deposits Redeemed = End Balance


In-House Ledger

  • This is where guests have now checked in and the transactions have been processed against their reservations. 
  • Start Balance – This is the balance of all reservations that are currently checked in at the start of the day. 
  • Revenue Received – This shows all the revenue that has been put through during that day including the different categories transactions relate to.  
  • Payments Received – This is a record of the payments received during that day with a split of how they have been paid.  
  • Deposits Redeemed – These are deposits that have been redeemed during that day and will have been transferred from the deposit ledger.  
  • End Balance – The balance of the in-house ledger at the end of the day.

 

Start Balance + Revenue Received - Payments Received - Deposits Redeemed = End Balance

 

Customer Sales Ledger 

  • Start balance – The balance of the customer sales ledger within Hop at the start of the day.
  • Account to Company Received – This is the amount that has been moved to an account that has credit facilities.
     
  • Payments Settled – Is the value of payments that have been settled within the Customer Sales Ledger (CSL).
  • End Balance – The balance of the CSL at the end of the day.

 

Daily Reconciliation

  • Revenue Received – Value of revenue received during the day.
  • Payments Received – Value of payments received during the day.
  • Deposits Received – Value of Deposits received during the day.
  • Deposits Redeemed – Value of deposits transferred from the deposit ledger.
  • Total In-house balance – The balance of checked in reservations during the day.

 

This report can be printed or downloaded to a PDF or CSV format.

 


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