Running Imbalance Analysis
Property: Select a property from the list.
Start Date: Enter the start date to run the imbalance analysis. Date defaults to the business date, but it cannot be equal to or greater than the current business date.
End Date: Enter the end date to run the imbalance (maximum date range to be entered can be 180 days). Date defaults to business date, but it cannot be equal to or greater than the current business date.
Note:
You cannot select dates still open when the Income Audit OPERA Control is activeGuest Ledger with Trial Balance: Run to verify and view the imbalance between the Guest Ledger columns in the Financial_Transactions table and the Trial_Balance table. A grid is displayed informing the user of the transaction, where the difference in figures is originating from, and the dollar amount it is for.
Package Ledger with Trial Balance: Run to verify and view the imbalance between the Package Ledger columns in the Financial_Transactions table and the Trial_Balance table. A grid is displayed informing the user of the transaction, where the difference in figures is originating from, and the dollar amount it is for.
Deposit Ledger with Trial Balance: Run to verify and view the imbalance between the Deposit Ledger column in the Financial_Transactions table and the Trial_Balance table. A grid is displayed informing the user of the transaction, where the difference in figures is originating from, and the dollar amount it is for.
A/R Ledger with Trial Balance: Run to verify and view the imbalance between the A/R Ledger columns in the Financial_Transactions table and the Trial_Balance table. A grid is displayed informing the user of the transaction, where the difference in figures is originating from, and the dollar amount it is for.
Passer By: Run to verify that all the Passer By totals in the Guest_Ledger table are equal. If there is an imbalance, the transaction is displayed along with amount difference.
Cashiers: Run to verify that all of the cashiers transactions are equal. If an imbalance should occur, the transaction is listed along with the difference in the amount.
C/O with Balance: Run to view all the guests that have a "Checked Out" status and folio closed, but still have a balance with the property. Grid displays the name of the guest, Arrival and Departure dates, Reservation Status, and the remaining balance that is still owed.
Invalid Transactions: Run to view all the invalid transactions, if any should develop. A list of the transactions that are invalid is displayed, along with the amount that it is wrong.
Effective Package Ledger: Run to verify the accuracy of packages consumed by guests. A grid displays informing the Reservation and Guest ID, Arrival and Departure dates, Reservation Status, and the dollar amount difference. An Autofix button is available to attempt to fix the imbalance automatically.
Package Ledger with Guest Ledger: Checks that the Guest Ledger's wrapper transaction is equal to the amount posted in the Package Ledger for the room portion amount of the package.
Summary of All: Checks all of the options available in the list, except the AR Health Check, and provides a Send to File button. A file called <property>balance.txt will be created. The file is located in the \runtimes directory in a Thick Client environment and in the \export directory in a Thin Client environment, to ensure that in a Thin Client environment the user will have the ability to download this file to the local PC to send to support.
Click Start.
If an imbalance exists, write down the ledger that is shown as out of balance from running the verification. Next run the imbalance analysis for the verification type for the specific ledger only. This will display the list of dates for which that particular ledger is out of balance and other information regarding the transactions causing the imbalance.
Enter the date.
Click Repopulate Trial Balance link and click Start.
Wait for the procedure to complete, click OK to close.
Fix naguestleddetail and deposit_ledger: Fixes the Guest Ledger and Guest Ledger Detail reports for the property, by finding where the data was missing in the Reservation Details table and repopulating the information.
Repopulate missing Bills into Folio Tax: Select this option to find the missing bill information and repopulate it into the Folio_Tax table for a specific date.
Fix Invalid AR Posting: Selecting this option fixes invalid A/R postings/bills in Financial_Transactions table and repopulates the invoice into the AR_Invoice_Header for the property.
Fix DBs For Adjusted Invoices: Selecting this option fixes adjusted invoices in the database.
Parent topic: Data Management