The Daily Report is Out of Balance

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

    • Night Audit Daily Report (Cloud) 🎥

      ? Watch Video The Daily report recaps all the activity within the last audit. This daily report includes hotel statistics, like the total earnings from hotels revenue centers. Numbers from each revenue centres will display for the day, MTD (month to ...
    • Reprint the Night Audit Reports (Cloud)

      Once the night audit is completed, the page will switch automatically from the Run Audit tab to the Reprint Report tab. Visual Matrix is paper saving... the reports are not printing nor printing nor sending automatically at the end of the audit but ...
    • Create a Daily Detail Report Category (Cloud) 🎥

      ? Watch Video The Daily Report contains guest ledger and city ledger numbers categorized within each ledger. These categories are customizable from this location. Path: Management > Accounting Settings > Report Headings > Daily Detail Report ...
    • Night Audit Revenue Tax Summary Report (Cloud)

      The Revenue Tax Summary report shows the total Revenue for one or multiple days (taxable and exempted) and the total taxes as well as the total exempted revenue. Path: Accounting > Night Audit > Reprint Reports > Room and Tax. Generate report 1. ...
    • Night Audit Tax Exempt Report (Cloud) 🎥

      ? Watch Video The Tax Exempt report shows the total Revenue that was exempted, the amount of tax posted, and the type of exemption (Partial or Exempt). A tax-exempt room revenue will only show on the report if it was posted by the night audit. A ...