The Daily Report is Out of Balance
What it means to have the Daily Report Out of Balance
This generally means that some numbers, somewhere, did not report where they should have, or that a balance has been left open when the night audit was processed.
There are two types of "Out of Balance"
A difference in the Daily Report General Balance
You will find that difference generally on pages 3 to 5, depending on how big the report is.
A difference between the closing balance of the previous day on the Daily Report and the opening balance of the current day
The opening and closing balance are on the first page of the Daily report, at the bottom.
Common Causes
- An Accounting Code is not mapped to the Daily Report
- One of the Guest Ledger House Accounts had a balance at the time the Night Audit was run
- A folio that was "Checked Out with Balance" has been purged
Troubleshooting Steps
Is there an Accounting Code not mapped to the Daily Report?
Each Accounting Code needs to be set up to report to a category in the Daily Report.
For payment codes, it has to report to the Daily Report AND to the Operator Cash Out Report.
You can find more information on Accounting Codes setups:
To find out if this is the cause, take the
difference that the report is off for and do a search in the Transaction log for that day.
You will find this report is Accounting > Night Audit > Reprint Reports > Transaction Log Report.
If there is an accounting code that matches
the difference, check under the Accounting Settings of that code and confirm that the code is set to report to the Daily Report.
Once you map the code to the Daily Report, the report will no longer show the difference.
Was there a balance on one of the hotel's Guest Ledger House Accounts?
If a Guest Ledger House Account does NOT have a zero balance
at the time of night audit (excluding the City Ledger House Account), it will
create a difference on the Daily Report.
You will have to go through the house accounts and see if
there could have been a balance for that day.
If the house account currently has a balance, it will need to be balanced:
- by posting a misc code - charge or payment - or any code that will offset the balance
- by voiding the charge/payment that is causing the balance
If the house account does not
have a balance, maybe it has already been balanced. You can find that by looking at the last transactions posted on this House Account.
In that case, this will cause the Daily Report to be short
one day and over another day.
If this is the case, the house account will not need correction as both day's balances are offsetting one another now.
Was a "Checked out with balance" folio purged during the last audit?
Depending on the settings, Visual Matrix does purge all reservations and financial data after 3 to 5 years (7 years for financial data).
If a "Checked out with Balance" folio has been purged, then the balance has been taken out from the Guest Ledger balance.
This also means that the folio will not be in Visual Matrix anymore.
This will require our Product Support Team to work on it for confirmation. Please open a ticket at help.visualmatrix.com.
However, if this situation is confirmed, there will be nothing that could be done to correct the error balance.
This is not an error or an issue from Visual Matrix itself.
Related Articles
Checked out with Balance Folios
What is a Checked Out with Balance Folio? This is when a folio has been checked out but still has a balance on it. Visual Matrix will alert you when you attempt to: - check out a folio if the balance is not at 0 - closeout of a checked-out folio ...What is the Accounting Code 7T
The 7T code is a code used by Visual Matrix to transfer an Advance Deposit from the Advance Deposit City Ledger Balance to the Guest Folio on the Guest Ledger Balance. This code cannot be voided. If it happens, then the ledger will not be in balance ...I need to check out a room but there is still a balance on the folio
A room cannot be checked out if the folio still carries a balance. The first question will be to find what type of balance is it and then we will be able to find ways to resolve it. What is the type of balance: Credit or Debit A Credit balance is a ...Can I apply a non calendar Accounting Year in Visual Matrix?
Yes, you can. If you are on a non-calendar accounting year and you need to change your accounting periods, contact our Client Experience Team at help.visualmatrix.com at least a couple of days before the change has to be done. A form will have to be ...How to check that my Ledger Balances are Correct?
The ledger balances are the totals of each ledger accounts that you will find in your Daily Report on the first page, sometimes on the second page. There are three Ledger Balances: - Advance Deposits; - City ledger; - Guest Ledger. Each closing ...