[Eng] Trial Balance
Report Name |
Trial Balance |
Open Link |
Log in – Front Office – Reports – Trial Balance |
Report Summary |
The report displays a summarized financial status of the property for a specific date, with a break down to different ledgers (Guest, AR, Deposit, Package…). |
Report Filter |
|
Report Form |
 |
Column Description |
See the data table below for the details. |
Remarks |
N/A |
No. | Indicators | Description |
1 | Balance Brought Forward | Balance Carried Forward (xxx) figure from the previous days trial balance |
2 | Revenue | Detailed Revenue Transactions by Transaction Code |
2a | Revenue Total | All Revenue Transactions |
3 | Paid Out | Detail Paid Out Transactions by Payment Method |
3a | Paid Total | All Paid Out Transactions |
4 | Non Revenue | Detail Non Revenue Transactions by Transaction Code |
4a | Non Revenue Total | All Non Revenue Transactions |
5 | Payment | Detail Payment Transactions by Payment Method |
5a | Payment Total | All Payment Transactions |
6 | Transaction Total Today | = Revenue Total (2a) + Paid Out Total (3a) + Non Revenue Total (4a) + Payment Total (5a) |
7 | Grand Total | = Balance Brought Forward (1) + Transaction Total Today (6) |
8 | AR Ledger Payments | Payments directly posted in AR |
9 | Deposit Ledger Activity | Deposits Transferred at Check In Deposit Payments |
10 | Balance Carried Forward | Balance Brought Forward to the next business date Trial Balance |
11 | Accruals Today | Floating Allowances, Post Next Day Packages that are not consumed |
12 | Guest Ledger Balance | Total of the Guest Ledger |
13 | Guest Ledger | |
13a | Balance Yesterday | Balance Today (13e) of previous days |
13b | Charges | (Total Amount that has been charged to the guests account) + (Any amounts charged to the guest account as a result of a transfer) |
13c | Payments | (Total Amount that has been paid against the account by the guest) + (Any amounts that have been transferred to the guests account and that is considered a credit) |
13d | Deposits Transferred at Check-In | Deposit Paid |
13e | Balance Today | = Balance Yesterday (13a) + Charges (13b) + Payments (13c) + Deposits Transferred at check in (13d) |
14 | AR Ledger | |
14a | Balance Yesterday | Balance Today (14d) of previous days |
14b | Charges and Transfers | (Total Amount that has been charged to the AR account) + (Any amounts charged to the AR account as a result of a transfer) |
14c | Payments | (Total Amount that has been paid against the account by AR Account) + (Any amounts that have been transferred to the AR account and that is considered a credit) |
14d | Balance Today | = Balance Yesterday (14a) + Charges and Transfers (14b) + Payments (14c) |
15 | Deposit Ledger | |
15a | Balance Yesterday | Balance Today (15d) of previous days |
15b | Deposits Transferred at Check-In | Deposit Paid |
15c | Payments | Total amount paid by the guest on the deposit |
15d | Balance Today | = Balance Yesterday (15a) + Deposits Transferred at Check In (15b) + Payments (15c) |
16 | Package Ledger | |
16a | Balance Yesterday | Balance Today (16f) of previous days |
16b | Package Allowances Created Today | All Package Created for today |
16c | Package Allowances Consumed Today | All Package Posting for today |
16d | Balance Actual | = Balance yesterday (16a) + Package Allowance Created Today (16b) + Package Allowance Consumed Today (16c) |
16e | Future Accruals | |
16f | Balance Today | Balance Actual (16d) |
18 | Hotel Balance | Guest Ledger Balance Today (13e) + AR Ledger Balance Today (14d) + Deposit Ledger Balance Today (15d) + Package Ledger Balance Today (16f) |