Night audit tie-out
3 business date(s): statistics room revenue 1687, room charges posted 1538. 159 to post, 228 to reverse, 3 finding(s) to review; 1 date(s) tie out.
By business date
| business date | stats revenue | posted revenue | rooms sold | occupied rooms | to post | to reverse | status |
|---|---|---|---|---|---|---|---|
| 2026-11-14 | 536 | 387 | 5 | 5 | 149 | 0 | correct |
| 2026-11-15 | 764 | 764 | 6 | 5 | 10 | 228 | correct |
| 2026-11-16 | 387 | 387 | 3 | 3 | 0 | 0 | ok |
By finding
| code | count | amount |
|---|---|---|
| occupied_not_charged | 1 | 149 |
| revenue_mismatch | 1 | 149 |
| charged_twice | 1 | 139 |
| rate_differs | 1 | 10 |
| zero_rate_not_comp | 1 | 0 |
| charged_not_occupied | 1 | 89 |
| rooms_sold_mismatch | 1 | 0 |
All rows (8)
| business date | room | finding | action | amount | detail |
|---|---|---|---|---|---|
| 2026-11-14 | 105 | occupied_not_charged | post | 149 | Room 105 is in house (R1005) but has no room charge posted for 2026-11-14. Expected 149 at the in-house rate (BAR). |
| 2026-11-14 | revenue_mismatch | review | 149 | The statistics report shows room revenue 536 for 2026-11-14; room charges posted add up to 387 (difference 149). | |
| 2026-11-15 | 102 | charged_twice | reverse | 139 | Room 102 (R1002) has 2 room charges on 2026-11-15: 139 + 139 = 278. One charge of 139 is expected. |
| 2026-11-15 | 104 | rate_differs | post | 10 | Room 104 (R1004) was charged 109 on 2026-11-15; the in-house rate is 119 (AAA). Undercharged by 10. |
| 2026-11-15 | 107 | zero_rate_not_comp | review | Room 107 (R1007) is in house at a rate of 0 on 2026-11-15 under rate code BAR, which is not a comp code. Check the rate or move it to a comp code with an approval. | |
| 2026-11-15 | 110 | charged_not_occupied | reverse | 89 | Room charge of 89 posted to room 110 on 2026-11-15, but the room is not on the in-house list for that night. Check for a wrong room number or a guest who already left. |
| 2026-11-15 | rooms_sold_mismatch | review | The statistics report shows 6 rooms sold for 2026-11-15; the in-house list has 5 occupied room(s). | ||
| 2026-11-16 | ok | 0 | Ties out. |
Limits
- Reads only the files you give it. It does not log in to a PMS, channel manager, OTA extranet, payment processor, lock system or bank.
- Room charges are found by transaction code when room_codes is set, otherwise by description words; name your codes for an exact tie-out.
- It never charges a guest, refunds, voids, posts to a folio or changes a rate. A person does that in the PMS or terminal.
- Not legal, tax or accounting advice. A person decides what to post, collect, dispute or pay.
Written by a Fairroom agent from your files. Nothing was sent, posted or paid.