Audit Trail Report
Report on all transactions by posting or creation date in RMS.
The Audit Trail Report is an interactive Financial report providing a record of every transaction by Posting or Creation Date.
-
Information
-
Use
- Add Button
Information
The Audit Trail Report is an interactive Financial report providing a record of every transaction by Posting or Creation Date and can be used to review every transaction for a specific General Ledger Account Code for a date range.
Additional options for the report include filters for Category, User, Transaction Source & Account Classification as well as options to include, exclude or only include Voids, Receipt Refunds, Manager Only (Owner Accounting), Transfers and Transaction Comments.
Enterprise customers can select 'Group by Property' under 'More Options' when generating the Audit Trail report.
The Audit Trail Report will include the following information:
| Report Column | Details |
|---|---|
| Posting Date | The actual date when the transaction was created on the account. |
| Creation Date | The Accounting Date when the transaction was created on the account. |
| Trans No | The unique Transaction Number identifying the transaction throughout RMS. |
| Res No | The Reservation Number associated to the Account the transaction was created on. |
| Acc No | The Account Number the transaction was created on. |
| Area | The Area assigned to the Reservation associated to the Account the transaction was created on. |
| Name | The Guest Name associated to the Account the transaction was created on. |
| Transaction Description | The description of the transaction as shown on the account. Includes 'Void' for records of voided transactions and 'Suspense' for Receipts created on an account where there were no charges to be allocated to. |
| Tax Invoice | The Tax Invoice number associated to the transaction. '0' indicates the transaction is not included on any Tax Invoice. |
| GL Code | The General Ledger Account Code this transaction is allocated to. |
| Username | The Username for the RMS User that created the transaction on the account. |
| Debit | The value of the Charge or Credit Note transaction created or voided on the account. |
| Credit | The value of the Receipt transaction created, refunded or reversed on the account. |
Creation Date is the actual date the charge is created on the account.
Posting Date is the Accounting Date at the time the charge is created on the account.
Users will require Security Profile access to view this report.
-
Use
- Add Button
Use
- Go to Reports > Accounting > Audit Trail in RMS.
- Select by Date or Transaction Number.
-
Date: Select a Date Range.
- Select by Posting Date or Creation Date.
- Transaction Number: Enter the Transaction Number Range.
-
Date: Select a Date Range.
- Optional: Select the General Ledger Account Codes.
- Optional: Select a Group By option.
-
Optional: Select 'More Options'.
- Select additional Report Options.
- Build.
Creation Date is the actual date the charge is created on the account.
Posting Date is the Accounting Date at the time the charge is created on the account.
Select any reservation number or account number on the report to go to that reservation or account in a new tab.
-
Guide
- Add Button
Guide
Go to Reports > Accounting > Audit Trail in RMS.
Select by Date or Transaction Number.
Date: Select a Date Range.
Select by Posting Date or Creation Date.
Transaction Number: Enter the Transaction Number Range.
Optional: Select the General Ledger Account Codes.
Optional: Select a Group By option.
Optional: Select 'More Options' and choose additional Report Options.
Select 'Build' to generate the report.
The Audit Trail Report will detail all transactions created in the selected date range or transaction range.
Select a Reservation Number or Account Number on the report to open that reservation or account in a new tab.
Use
- Go to Reports > Accounting > Audit Trail in RMS.
- Select by Date or Transaction Number.
-
Date: Select a Date Range.
- Select by Posting Date or Creation Date.
- Transaction Number: Enter the Transaction Number Range.
-
Date: Select a Date Range.
- Optional: Select the General Ledger Account Codes.
- Optional: Select a Group By option.
-
Optional: Select 'More Options'.
- Select additional Report Options.
- Build.
Creation Date is the actual date the charge is created on the account.
Posting Date is the Accounting Date at the time the charge is created on the account.
Select any reservation number or account number on the report to go to that reservation or account in a new tab.
-
Guide
- Add Button
Guide
Go to Reports > Accounting > Audit Trail in RMS.
Select by Date or Transaction Number.
Date: Select a Date Range.
Select by Posting Date or Creation Date.
Transaction Number: Enter the Transaction Number Range.
Optional: Select the General Ledger Account Codes.
Optional: Select a Group By option.
Optional: Select 'More Options' and choose additional Report Options.
Select 'Build' to generate the report.
The Audit Trail Report will detail all transactions created in the selected date range or transaction range.
Select a Reservation Number or Account Number on the report to open that reservation or account in a new tab.