The Transaction Log report displays all transactions conducted by the selected user on a given date. The available filters enable you to specify the posting type (revenue, payment, etc.) you want to view, as well as select transactions based on the associated code category or view any transactions related to a specific accounting code posted by the user on the chosen date.
Path: Front Office > Reports > Front Office > Trans Log.
The Transaction Log report screen can be divide into 3 sections:
- The Operator Cash out.
- The Operator Totals.
- The Transactions Details.
Generate report
1. Narrow down the report using the optional available filters from the Operator Cash Out section (from top to bottom):
- by date. The date cannot be changed. For the Operator Cash Out report for a previous day, go to Accounting > Night Audit > Reprint Report.
- by operator ID.
- by type of transaction: advance deposit transfer (7T), guest ledger balance, payment or revenue.
- by category of payment or revenue.
- by accounting code.
2. Click Refresh.
3. Complete the "Reported" column from the Operator Totals section. The System Total are from Visual Matrix activity for the current day based on the filters selected in the Operator Cash Out section. From left to right:
- System Total: shows the total amount that was posted in Visual Matrix.
- Reported: users have to enter here at the end of their shift the total that they have in hand to compare with what has been posted in Visual Matrix.
- For the Cash, the reported will be the amount that is in the draw minus the cash fund that stays in the draw.
- For the Checks, the reported will be the total amount of all checks collected.
- For the Credit Cards, if you are processing through Visual Matrix, the amount will be the one from the System Total field. If you are not processing through Visual Matrix, the amount will come from the end of shift or sub total tickets generated by your external credit card machine.
- Over/(Short): will show any discrepancy between the System Total and the Reported.
At the conclusion of their shift, each user is required to report their individual total. During the night audit, the verification process involves checking the total reported by each user, accomplished by selecting "ALL" in the Operator ID within the Operator Cash Out section (1).
In the event that one user posts a payment and another voids or adjusts it, User #1 may have a payment on their report that was never received, while User #2 may reflect a refund or adjustment that was never genuinely processed. These conflicting entries in each user's report will offset each other. If such a situation arises, it is recommended to report only what is precisely reflected in the System Total.
4. View the report before print.
5. Click Print
Detailed report
- Accounting code and name of the transaction posted.
- Room number and folio or code of the house account where the transaction was posted.
- Visual Matrix Internal Transaction ID.
- Confirmation # of the folio (group or individual) where the transaction was posted on.
- Guest or group name or name of the House Account if the amount was posted in one.
- Reference noted either from the reference field when posting or as a reason of void or adjustment.
- Amount of the transaction.
- Amount adjusted in case of an override.
- Visual Matrix Transaction ID of the original posting.
- Date the original transaction was posted.
- If the transaction was voided, an X will show.
- If the transaction was a transfer from a group master or from another room/folio, the original room will show in the "From" column.
- ID of the user who posted the transaction.
- Time the transaction was posted.
- Total posted for each accounting code.