Finance Reports - Trial Balance

Modified on Sat, 22 Jan 2022 at 09:37 AM

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.