A complete and transparent audit trail is essential for accurate financial controls. The Transaction Log Report records every posting made in the system—payments, revenue, adjustments, transfers, and more—so your team can review daily activity by operator, transaction type, category, or accounting code. It’s a powerful tool for front-office, audit, and accounting teams who need to verify posting integrity, investigate discrepancies, and support end-of-day reconciliation.
Path: Front Office > Reports > Front Office > Trans Log.
A second version of this report is also available in the Night Audit section, offering additional filters such as Exclude Details, Adjust/Void Only, and Summary Only when you need a more streamlined, audit-specific view of the day’s activity.
Use the following filters to narrow the transactions shown in the report. These options allow you to control exactly which postings appear:
- Dates: Select the date you want to review (defaults to today).
- Operator ID: Choose a specific user to see only their postings, or select ALL to view every operator’s activity.
- Type: Filter by transaction type such as Revenue, Payment, Guest Ledger Balance, or Adv Dep Xfer.
- Category: Filter by posting category (Cash, Credit Card, City Ledger, F&B, Room, Tax, Misc, etc.).
- Acct Code: Choose a specific accounting code to focus on one charge line, tax type, fee, or deposit code.
3. Click Refresh to generate results based on your filter selections.
Use this section to understand how the Transaction Log Report displays every posting completed for the selected date, operator, type, category, or account code. The report is structured to show what was posted, where it was posted, who posted it, and any adjustments or voids made to the original transaction.
Posting Details
- Code: Accounting code and description for the posting (e.g., OCCUPANCY TAX, HOTEL STAY TAX).
- RM: Room or house account the posting was applied to.
- Trans ID: Unique transaction ID automatically assigned by the system.
- Conf #: Confirmation (reservation) number tied to the posting.
- Guest Name: Guest associated with the transaction.
- Reference: Description or reason entered with the posting (e.g., “Error,” “Adjustment,” authorization ID).
Amounts & Adjustments
- AMT: Dollar amount of the posting.
- Adj: Adjustment amount, if the original transaction was modified.
- Orig ID: Original transaction ID when this line is an adjustment or void.
- Date: Posting date of the original transaction.
- Void: Indicates if the transaction was voided (“X”).
Audit Trail Details
- From: Originating room number when a transfer occurs.
- Clerk: Operator ID of the user who performed the transaction.
- Time: Timestamp of the posting.
Tips & Use Cases
- Use this report to verify that all revenue, payment, and adjustment postings match expected activity.
- Identify users with frequent voids or adjustments for training or review.
- Export and filter by accounting code to support audit worksheets and month-end reconciliation.
- Compare operator totals with actual cash-outs or payment records for discrepancies.
Still Need Help With This Topic?
Ask Yourself:
- Was the correct date range selected?
- Is the transaction type filter set appropriately (Revenue / Payment)?
- Is there a specific user or accounting code that needs investigation?
Support May Ask You:
- What date or filter selections did you apply?
- Which operator or accounting code shows the issue?
- Can you provide the transaction ID, room number, or folio reference involved?