Reconciling-Reviewing Data
- Julie Leake (Unlicensed)
- Carissa Warnock (Unlicensed)
The Reconcile/Review Data screen displays data entered by day. These two screens are identical with one exception: amounts can be entered/edited when in Reconcile but is view-only when in Review. The Reconcile screen is used to edit/adjust amounts to make the day balance. You cannot post a day until it is in balance. The Review screen is used to view data after a day has posted. If you find that data needs to be changed after a day has posted, you will need to Re-Open the day.
| Field | Description | Notes |
Daily Notes | (icon) Enter notes about the day. For example, maybe the day's revenues were less than expected. You can note that this was due to a bad ice storm which caused flights to be cancelled and limited vehicle travel. | |
Out of Balance | Denotes the amount by which the day is out of balance. If the number is greater than or less than 0.00, the day is out of balance and must be reconciled before you can post the day. | |
Post Day | (Reconcile only) Mark the day as complete after everything has balanced. | |
Re-Open Day | (Review only) Re-open a day that was previously posted, so you can enter/edit data. | If you re-open a day, all days subsequent to that date are also re-opened and you must re-post all of those days. |
Control Summary | Displays a summary of Receipts, Funds and other pertinent Statistics. This screen is accessed by clicking on a Date in the Daily Revenue Recap, or by clicking the button on the Reconcile/Review page(s). This screen is view only. If the data doesn't appear to be correct, verify that you have correctly configured the following Revenue Line codes: The following table lists each value and which revenue line in the revenue structure is used to obtain the value. |
Value | Revenue Line Code | Cell |
|---|---|---|
Revenue | TTL_REV | gross |
Taxes | TTL_REC | tax |
Adjustments | TTL_ADJ | net |
Total Receipts | TTL_REC | gross |
Credit Card | AR_CC | payments |
Cash | TTL_CSH | net cash |
Accounts Receivable | AR_AR | payments |
Total Funds | ;AR_CC, TTL_CSH, AR_AR | ??? |
Net Revenue | TTL_REV | net |
ADR | RMS _REV, and TTL_RMS or MKT_MIX | calculation - needs formula |
Accounts Receivable Balance | AR_BAL | end balance |
Occupancy % | TTL_RMS or MKT_MIX | calculation - needs formula |
RevPar | RMS _REV | ??? |
Vacant Rooms | RMS _OCC,RMS _OOO | ??? |
| Field | Description |
Description | Displays the name of the item as it appears in the Revenue Structure configuration. There are several sections in the tree (Receipts, Funds, etc.). All sections can be collapsed to view top line information or expanded to view detail lines. |
Revenue Line Note | Enter notes about a specific revenue line on the data you are reconciling. |
Other column headers | Denotes the cell(s) of which the revenue line is composed. The column headers change depending on the revenue line type. |
Reconciling/Reviewing Data
- Select Reconcile/Review in the Daily Revenue Recap screen next to the day/date for which you want to reconcile/review data.
- Do one of the following:
- If you are Reconciling, proceed to Step 2.
Or - If you are Reviewing, close the window when done, or click Re-Open Day and proceed to the appropriate section of this manual.
- If you are Reconciling, proceed to Step 2.
- Determine whether or not the day is Out of Balance:
- If it is Out of Balance, proceed to the next step.
Or - If the day is in balance, click Post Day and close the screen.
- If it is Out of Balance, proceed to the next step.
- Enter/change amounts as needed to bring the day's balance to zero.
- Click the Save icon.
- Click Post Day.