The Night Audit Report is an interactive Financial Revenue report that summarises ledger movements, charges, cash and statistical activity for a selected accounting date range.
Overview
The Night Audit report is an interactive Financial Revenue report providing ledger movements for all transactions that occurred on the selected Accounting Date(s).
Balance Transfers across properties will affect the balancing of the night audit report for all properties involved.
The report can be run for a single property or across multiple properties, scheduled to run automatically as part of End of Day, and used to feed transaction data to financial systems through the available export and interface options.
The Night Audit report will show Areas as 'Under Maintenance' only when the Area Statistics option is selected.
Use Cases
- End of day balancing - Run for the current Accounting Date during End of Day to confirm charges, receipts and ledger movements balance before opening a new day.
- Financial reconciliation - Use the Charge, Cash and Debtor Analysis sections to reconcile daily revenue against the ledger and account balances.
- Feeding external accounting systems - Generate the export and interface files to pass transaction data to a connected financial system.
How to Access
In the side menu of RMS, go to Reports > Night Audit > Night Audit.
- Select the Accounting Date Range.
All below selections are Optional.
Select the Properties.
Select to include the Charge and Cash analysis.
Select to Include Inactive Category.
Select to include the Statistical Analysis section at the end of the Night Audit report.
Select 'Show Debtor Analysis' to see account details for the ledgers.- By G/L Acc Code Grouping.
- By Transaction.
Review additional Night Audit report build options (Optional).
- Select Build.
Report Options
The report options below control which analysis sections and export files are included. Additional options are available by clicking More Options on the report panel.
| Report Option | Type | Default | Description |
|---|---|---|---|
| Show Charge Analysis | Checkbox | On | Adds the Charge Analysis section, breaking down charges by General Ledger Account Code. |
| Show Cash Analysis | Checkbox | On | Adds the Cash Analysis section, breaking down receipts by payment method. |
| Show Statistics Analysis | Checkbox | On | Adds the Statistical Analysis section (occupancy and revenue statistics) at the end of the report. |
| Exclude Complimentary From Room Nights Sold | Checkbox | On | Excludes Complimentary reservations from the Room Nights Sold figure in the Statistics Analysis. |
| Use Net Values on Statistics Analysis | Checkbox | On | Uses net rather than gross values in the Statistics Analysis section. |
| Show Facility Statistics Analysis | Checkbox | On | Adds a Facility Statistics Analysis section covering facility usage. |
| Include Inactive Category | Checkbox | On | Includes Categories marked inactive in the report figures. |
| Show Debtor Analysis | Checkbox | On | Adds the Debtor Analysis section showing ledger account balances and movements. |
| By G/L Acc Code Grouping / By Transaction | Radio | By G/L Acc Code Grouping | Sets how the Debtor Analysis is grouped: by GL Account Code Grouping, or by individual Transaction. |
| Show AR Analysis | Checkbox | On | Adds an Accounts Receivable (AR) analysis section. |
| Show Xero General Ledger Interface | Checkbox | On | Displays the Xero General Ledger interface data on the report. |
| Generate Xero File | Checkbox | On | Produces the Xero export file for the period. |
| Generate OzBiz File | Checkbox | On | Produces the OzBiz export file for the period. |
| Generate Ledger Movement Transaction Files | Checkbox | On | Produces the ledger movement transaction export files. |
| Property | Multi-select | Current property | For multi-property (Enterprise) databases. Limits the report to the selected properties. |
Report Output
The Night Audit report is a multi-section financial summary rather than a single column table. Depending on the options selected, it can include the sections below.
| Section | What it shows |
|---|---|
| Ledger Movements | Charges, receipts and balance movements for each ledger on the selected Accounting Date(s). |
| Charge Analysis | Charges grouped by General Ledger Account Code (when Show Charge Analysis is selected). |
| Cash Analysis | Receipts grouped by payment method (when Show Cash Analysis is selected). |
| Statistics Analysis | Occupancy and revenue statistics for the period (when Show Statistics Analysis is selected). |
| Facility Statistics Analysis | Facility usage statistics (when Show Facility Statistics Analysis is selected). |
| Debtor Analysis | Ledger account balances and movements (when Show Debtor Analysis is selected). |
| AR Analysis | Accounts Receivable balances (when Show AR Analysis is selected). |
See Night Audit Report Breakdown for further report guidance.
Region Functionality
India
For cash receipts that require entering a PAN (Permanent Account Number), the PAN will be shown in the Card column of the Night Audit report. Please make sure to select the 'Show Cash Analysis' option on the report build screen to view this information.
For further information, click HERE.
Related Reports
- EOD Report - end-of-day summary produced during the Night Audit.
- Bill Settlement Report - settlement breakdown for the trading period.
Related Articles
Comments
0 comments
Please sign in to leave a comment.