In this article
The purpose of Reconciliation Tool is to reconcile the Hotels Reservations Accounting.
To access
- Go to the Hotel Setup page.
- Click the Actions action, then Tools - Reconciliation.
- The Hotel Reconciliation List is displayed.
Searching process
From Actions bar, you have two ways of filling the reconciliation data:
| Actions | Description |
|---|---|
| Find GL entries on Reservation level | Using this action, the process goes through all General Ledger Entries and groups them by reservations to calculate the accounting amounts. |
| Find GL entries on Doc No. level | Using this action, the process goes through all General Ledger Entries and groups them by reservations and document numbers to calculate the accounting amounts. It can be useful to differentiate between Night Audit postings.This only affects values based on GL entries. |
Filtering
| Filters | Description |
|---|---|
| Property Filter | Sets a property filter on searching process(both). |
| Reservation Filter | Sets a reservation filter on searching process(both). |
| Internal Status | Sets an Internal Status filter on searching process(both). |
| Source Code | Sets a Source Code filter on General Ledger Entries on searching process(both). |
| Posting Date From | Sets Posting Date filter on General Ledger Entries on searching process(both). |
| Posting Date To | Sets Posting Date filter on General Ledger Entries on searching process(both). |
Other actions
| Actions | Description |
|---|---|
| Hide/Show Charges Columns | Hides or shows Charges Columns in the page. It can be useful to have more detailed charges columns to compare with other data. |
| Scheduled Jobs | A link to open the Hotel Job List page. |
While you run the searching process, and if there are many reservations, a dialog window is displayed where you can see how the search is proceeding. The searching process runs some calculations and checks the reservation amounts and the accounting side and compares them.
The table in the Hotel Reconciliation List displays data coming from the reservations, for example Internal Status, Early Checkout, Arrival Date, Departure Date, and Hotel Balance. These columns are followed by fours fields that summarize the results of the reconciliation (see below).
Reconciliation fields
These fields reflect the variance related to Hotel Temp Balance Account, Deposits in the Hotel side, and Deposits from GL side.
| Fields | Description |
|---|---|
| Hotel Balance Acct Difference | Compares the amount posted to GL from Temp Balance Account with the amount from IncExp Entries from Posted Transactions. Click to show or hide detailed columns used to compare. |
| Hotel Deposit Difference | Compares the amount of Deposit Collected from Res. Payment Entries with the amount of Deposit Consumed Res. Payment Entries. Basically compares the prepayment from the Hotel side. Click to show or hide detailed columns used to compare. |
| Deposit Acct Difference | Compares the amount IncExp Entries of deposit collected from Posted Transactions with the amount of Deposit Consumed posted to GL. Basically compares the prepayment from GL side. Click to show orhide detailed columns used to compare. |
| No. of Issues | The number of issues in a reservation. Drill down to see details. |
Reconciliation issues
There are two types of issues, critical and non-critical. An issue is critical, if the reservation is checked out with a balance, or if it is a migrated reservation with a deposit. Any issue related to prepayment data or the Hotel Temp Balance Account is critical. Also, if any of the difference fields is not zero, that too is a critical issue.
Reservations with critical issues are marked in red color.
Basic checks are focused on the difference fields, but there are other checks that are done at Detailed Revenue Entry level or on reservation payment entries that are also reported.
In the Issues page, if a process found any over- or under-consumed DRE, the system shows the lines with the Amount Incl. Tax, NA Consumed, and GL Posted.