All Transactions - Night Auditor Key Report .ng
All Transactions
Report Description: All Transactions Report provides a list of all transactions including transaction code, transaction description, transaction type and room number individually and the corresponding amount for a defined date. This report includes transaction data for Reservations, Groups and House Accounts
Date Range: Historical, 94 days in the past up to present date
Reservations Section: The Reservations section provides a detailed list of all transactions by user associated with a reservation.
Available Report Columns for Following Sections:
Column Name | Column Description | Amount Includes Taxes and Fees | Calculation |
Date | Date of the transaction (ex - March 25, 2024) | Not Applicable | Not Applicable |
Time | Time of the transaction (ex - 05:39:49 AM) | Not Applicable | Not Applicable |
Confirmation Number | Confirmation number on the reservation | Not Applicable | Not Applicable |
Guest Name | Primary guest name on the reservation | Not Applicable | Not Applicable |
Room Number | Room number on the reservation (if assigned) | Not Applicable | Not Applicable |
Folio Number | Folio Number | Not Applicable | Not Applicable |
Transaction Code | Transaction code / charge type code | Not Applicable | Not Applicable |
Transaction Description | Transaction description / charge type name (ex - Accommodation) | Not Applicable | Not Applicable |
Last 4 Digits | Last 4 digits of credit card (if relevant) | Not Applicable | Not Applicable |
Transaction Type | Type of transaction (ex - Tax, Charge, Payment) | Not Applicable | Not Applicable |
Charge Type Category | Category of the charge type that is relevant for the reservation (ex - Room Rent, Misc) | Not Applicable | Not Applicable |
Outlet Name | Will indicate if POS is associated with the charge, tax, or payment | Not Applicable | Not Applicable |
Amount | Transaction amount *Tax and fees includes if transaction type is “Tax” | YES* | Not Applicable |
Username | Username that processed that transaction | Not Applicable | Not Applicable |
Remarks | Remarks on the transaction, if logged | Not Applicable | Not Applicable |
POS Check Number | Unique number to identify an order number | Not Applicable | Not Applicable |
Groups Section: The Groups section provides a detailed list of all transactions by a user associated with a group master.
Available Report Columns for Following Sections:
Column Name | Column Description | Amount Includes Taxes and Fees | Calculation |
Date | Date of the transaction (ex - March 25, 2024) | Not Applicable | Not Applicable |
Time | Time of the transaction (ex - 05:39:49 AM) | Not Applicable | Not Applicable |
Group Code | Group master code of the transaction | Not Applicable | Not Applicable |
Group Number | Group confirmation number | Not Applicable | Not Applicable |
Group Name | Name of the group | Not Applicable | Not Applicable |
Folio Number | Folio Number | Not Applicable | Not Applicable |
Transaction Code | Transaction code / charge type code | Not Applicable | Not Applicable |
Transaction Description | Transaction description / charge type name (ex - Accommodation) | Not Applicable | Not Applicable |
Last 4 Digits | Last 4 digits of credit card (if relevant) | Not Applicable | Not Applicable |
Transaction Type | Type of transaction (ex - Tax, Charge, Payment) | Not Applicable | Not Applicable |
Charge Type Category | Category of the charge type that is relevant for the reservation (ex - Room Rent, Misc) | Not Applicable | Not Applicable |
Outlet Name | Will indicate if POS is associated with the charge, tax, or payment | Not Applicable | Not Applicable |
Amount | Transaction amount *Tax and fees includes if transaction type is “Tax” | YES* | Not Applicable |
Username | Username that processed that transaction | Not Applicable | Not Applicable |
Remarks | Remarks on the transaction, if logged | Not Applicable | Not Applicable |
POS Check Number | Unique number to identify an order number | Not Applicable | Not Applicable |
House Account Section: The House Account section provides a detailed list of all transactions by a user associated with a House Account.
Available Report Columns for Following Sections:
Column Name | Column Description | Amount Includes Taxes and Fees | Calculation |
Date | Date of the transaction (ex - March 25, 2024) | Not Applicable | Not Applicable |
Time | Time of the transaction (ex - 05:39:49 AM) | Not Applicable | Not Applicable |
House Account Code | House Account “Account Number” | Not Applicable | Not Applicable |
House Account Name | Name of the house account | Not Applicable | Not Applicable |
Account Type | Indicates type of house account (Temporary or Permanent) | Not Applicable | Not Applicable |
Folio Number | Folio Number | Not Applicable | Not Applicable |
Transaction Code | Transaction code / charge type code | Not Applicable | Not Applicable |
Transaction Description | Transaction description / charge type name (ex - Accommodation) | Not Applicable | Not Applicable |
Last 4 Digits | Last 4 digits of credit card (if relevant) | Not Applicable | Not Applicable |
Transaction Type | Type of transaction (ex - Tax, Charge, Payment) | Not Applicable | Not Applicable |
Charge Type Category | Category of the charge type that is relevant for the reservation (ex - Room Rent, Misc) | Not Applicable | Not Applicable |
Outlet Name | Will indicate if POS is associated with the charge, tax, or payment | Not Applicable | Not Applicable |
Amount | Transaction amount *Tax and fees includes if transaction code is taxable | YES* | Not Applicable |
Username | Username that processed that transaction | Not Applicable | Not Applicable |
Remarks | Remarks on the transaction, if logged | Not Applicable | Not Applicable |
POS Check Number | Unique number to identify an order number | Not Applicable | Not Applicable |
Settlement Payments: The Settlement Payments section provides a detailed list of all transactions by a user associated with a company in accounts receivable.
Available Report Columns for Following Sections:
Column Name | Column Description | Amount Includes Taxes and Fees | Calculation |
Date | Date of the transaction (ex - March 25, 2024) | Not Applicable | Not Applicable |
Time | Time of the transaction (ex - 05:39:49 AM) | Not Applicable | Not Applicable |
Company Code | Company code in AR of the transaction | Not Applicable | Not Applicable |
Company Name | Name of the company | Not Applicable | Not Applicable |
Transaction Code | Transaction code / charge type code | Not Applicable | Not Applicable |
Transaction Description | Transaction description / charge type name (ex - Accommodation) | Not Applicable | Not Applicable |
Last 4 Digits | Last 4 digits of credit card (if relevant) | Not Applicable | Not Applicable |
Transaction Type | Type of transaction (ex - Tax, Charge, Payment) | Not Applicable | Not Applicable |
Amount | Transaction amount | Not Applicable | Not Applicable |
Username | Username that processed that transaction | Not Applicable | Not Applicable |
Remarks | Remarks on the transaction, if logged | Not Applicable | Not Applicable |
Misc Report Information:
Available Features:
Export: ability to download and save the file into an alternate format.
Filter: filter a range of data based on criteria defined by the user.
Highlight: also known as conditional formatting is the ability to highlight certain values making them easier to identify.
Bar Chart: ability to display data in a bar chart view.
Group By: ability to group data All, Transaction Code, Transaction Description or Transaction Type
Available Configuration:
User Preferences: allows the user to customize their report view by repositioning or removing columns.
Property Preferences: allows the property to customize the report view for all users by repositioning or removing columns.
Baseline Configuration:
Property Preferences Settings:
Following columns to be disabled for initial deployment:
None