The Bill Settlement Report lists all bills settled on a selected date and the payment methods used for each settlement.
Overview
The Bill Settlement Report shows every settled bill for the chosen date, broken down by the type of charges on the bill (Accommodation, Extras, Client) and the Receipt Type applied to each settlement (Cash, Credit, Accounts Receivable, Cheque/EFTPOS, Journal). It also identifies the User who processed each settlement.
The report is typically run by night auditors and accounts staff at the end of the trading day to reconcile settlements against the cash drawer, EFTPOS terminal, and gateway totals before completing the Night Audit.
The Bill Settlement Report can be run only for a single date.
Report Option
| Parameter | Type | Default | Description |
|---|---|---|---|
| For | Date | Today | The settlement date the report is run for. Only bills settled on this date are included. |
Guide
In the side menu of RMS, go to Reports > Night Audit > Bill Settlement.
- Select the Date.
- Select Build.
Report Columns
| Column | Description |
|---|---|
| Bill No | The bill number assigned to the settled bill. |
| Area | The Area assigned to the reservation the bill relates to. |
| Guest Name | The name on the reservation account. |
| Arrive | The arrival date of the reservation. |
| Depart | The departure date of the reservation. |
| Bill Amount - Accomm | The accommodation portion of the settled bill. |
| Bill Amount - Extras | The extras portion of the settled bill (Sundry Charges, Add Ons, and other non-accommodation items). |
| Bill Amount - Client | The portion of the bill attributed to a Client account (Company, Travel Agent, or Wholesaler) when charges have been redirected. |
| Settlement Mode - Cash | The amount of the bill settled by cash. |
| Settlement Mode - Credit | The amount settled by credit card. |
| Settlement Mode - AR | The amount transferred to Accounts Receivable. |
| Settlement Mode - Cheque/EFTPOS | The amount settled by cheque or EFTPOS. |
| Settlement Mode - Journal | The amount settled by journal entry (for example, an internal transfer or write-off). |
| User | The User who processed the settlement. |
Use Cases
- End-of-day cash reconciliation - the night auditor runs the report at the end of the trading day to confirm that settled cash, credit, and EFTPOS amounts match the till and terminal totals.
- Settlement audit by user - run the report and review the User column to identify who processed each settlement, helpful when investigating a discrepancy or balancing a shift.
- Payment-mode mix review - compare the Settlement Mode columns across days or weeks to see how the mix of cash, credit, AR, cheque/EFTPOS, and journal settlements is trending.
Related Reports
- Night Audit Report - the day's full ledger movement (charges, cash, advances, guest ledger, city ledger).
- EOD Report - debtors-position summary at the start and end of the chosen date.
- Report of Payment by Ledger - settlements grouped by ledger.
- Advances Ledger Breakdown - movement of unallocated advances during the period.
- Cash Transaction Report - balance the till by payment type, can be filtered per User for a shift report.
Comments
0 comments
Please sign in to leave a comment.