If you would like to request a new article or update to an existing article in the RMS Help Centre please complete the below form.


    If you require assistance or would like to speak with someone from RMS Customer Support please log a Service Request.



    Audit Trail Report

    Report on all transactions by posting or creation date in RMS.

    Decision Tree

    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

    1. Go to Reports > Accounting > Audit Trail in RMS.
    2. Select by Date or Transaction Number.
      1. Date: Select a Date Range.
        1. Select by Posting Date or Creation Date.
      2. Transaction Number: Enter the Transaction Number Range.
    3. Optional: Select the General Ledger Account Codes.
    4. Optional: Select a Group By option.
    5. Optional: Select 'More Options'.
      1. Select additional Report Options.
    6. 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

    1. Go to Reports > Accounting > Audit Trail in RMS.
    2. Select by Date or Transaction Number.
      1. Date: Select a Date Range.
        1. Select by Posting Date or Creation Date.
      2. Transaction Number: Enter the Transaction Number Range.
    3. Optional: Select the General Ledger Account Codes.
    4. Optional: Select a Group By option.
    5. Optional: Select 'More Options'.
      1. Select additional Report Options.
    6. 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.


    Was this article helpful?

    Send Feedback

    Can’t find what you’re looking for?

    Our team of RMS experts are here for you!

    Submit Question