Report Description: The All Transactions Report provides a comprehensive list of every financial movement—including charges, taxes, and payments—individually listed by folio. This report facilitates financial reconciliation and VAT mapping for Reservations, Groups, and House Accounts.
Date Range: Historical, 365 days in the past up to present date.
Transaction Type: Select from below transaction type
-
All
-
Charge
-
Tax
-
Tax Exemption
-
Tax Exemption Removal
-
Payment
-
Refund
-
Fee
User : Select the user from the dropdown.
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 |
Calculation |
|
Date |
Date of the transaction (ex - March 25, 2024) |
Not Applicable |
|
Time |
Time of the transaction (ex - 05:39:49 AM) |
Not Applicable |
|
Confirmation Number |
Confirmation number on the reservation |
Not Applicable |
|
Guest Name |
Primary guest name on the reservation |
Not Applicable |
|
First Name |
Split of Guest Name as First Name |
Not Applicable |
|
Last Name |
Split of Guest Name as Last Name |
Not Applicable |
|
Room Number |
Room number on the reservation (if assigned) |
Not Applicable |
|
Folio Number |
Folio Number |
Not Applicable |
|
Transaction Code |
Transaction code / charge type code |
Not Applicable |
|
Transaction Description |
Transaction description / charge type name (ex - Accommodation) |
Not Applicable |
|
Last 4 Digits |
Last 4 digits of credit card (if relevant) |
Not Applicable |
|
Transaction Type |
Type of transaction (ex - Tax, Charge, Payment) |
Not Applicable |
|
Charge Type Category |
Category of the charge type that is relevant for the reservation (ex - Room Rent, Misc) |
Not Applicable |
|
Sub Charge Type Name |
Sub Category of the charge type that is relevant for the reservation (ex - Room Rent, Misc) |
Not Applicable |
|
Outlet Name |
Will indicate if POS is associated with the charge, tax, or payment |
Not Applicable |
|
Amount |
Transaction amount |
Not Applicable |
|
Username |
Username that processed that transaction |
Not Applicable |
|
Remarks |
Remarks on the transaction, if logged |
Not Applicable |
|
Charge Remarks |
A text note explaining specific reasons or details behind a manually posted fee. |
Not Applicable |
|
Transferred Transactions |
Financial items moved from one folio or guest account to another. |
Not Applicable |
|
POS Check Number |
The unique transaction ticket number generated by an integrated food or retail outlet. |
Not Applicable |
|
Tax Invoice Number |
The legally required billing identification code used for corporate tax reporting. |
Not Applicable |
|
Fiscal Invoice Number |
A government-regulated serial code used to track revenue for localised financial compliance. |
Not Applicable |
|
Reference External Bill Number |
A unique identification number used to track and link billing vouchers, receipts, or invoices generated by third-party systems vendors to a guest's folio ledger. |
Not Applicable |
|
Company Name |
The registered corporate entity or business group responsible for paying the folio. |
Not Applicable |
|
Refund Reason |
A mandatory note explaining why money is being returned to a customer's payment method. |
Not Applicable |
|
Quantity |
The unit volume multiplier showing the total number of items or services posted to the account (e.g., 2 breakfast vouchers). |
Not Applicable |
|
Adults |
The number of adults linked to the reservations. |
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 |
Calculation |
|
Date |
Date of the transaction (ex - March 25, 2024) |
Not Applicable |
|
Time |
Time of the transaction (ex - 05:39:49 AM) |
Not Applicable |
|
Group Code |
Group master code of the transaction |
Not Applicable |
|
Group Number |
Group confirmation number |
Not Applicable |
|
Group Name |
Name of the group |
Not Applicable |
|
Folio Number |
Folio Number |
Not Applicable |
|
Transaction Code |
Transaction code / charge type code |
Not Applicable |
|
Transaction Description |
Transaction description / charge type name (ex - Accommodation) |
Not Applicable |
|
Last 4 Digits |
Last 4 digits of credit card (if relevant) |
Not Applicable |
|
Transaction Type |
Type of transaction (ex - Tax, Charge, Payment) |
Not Applicable |
|
Charge Type Category |
Category of the charge type that is relevant for the reservation (ex - Room Rent, Misc) |
Not Applicable |
|
Sub Charge Type Name |
Secondary label that categorises a detailed transaction sub-item within a main department fee (e.g., "Espresso" under the main "Food & Beverage" charge type). |
Not Applicable |
|
Outlet Name |
Will indicate if POS is associated with the charge, tax, or payment |
Not Applicable |
|
Amount |
Transaction amount |
Not Applicable |
|
Username |
Username that processed that transaction |
Not Applicable |
|
Remarks |
Remarks on the transaction, if logged |
Not Applicable |
|
Charge Remarks |
Remarks on the charges. |
Not Applicable |
|
Transferred Transactions |
Financial items moved from one folio or guest account to another. |
Not Applicable |
|
POS Check Number |
The unique transaction ticket number generated by an integrated food or retail outlet. |
Not Applicable |
|
Company Name |
Name of the Company associated with the Group Reservation. |
Not Applicable |
|
Tax Invoice Number |
The legally required billing identification code used for corporate tax reporting. |
Not Applicable |
|
Fiscal Invoice Number |
Notifies the Invoice number of |
Not Applicable |
|
Refund Reason |
A mandatory note explaining why money is being returned to a customer's payment method. |
Not Applicable |
House Accounts Section:
Provides a detailed list of transactions associated with non-guest House Accounts.
Available Report Columns for Following Sections:
|
Column Name |
Column Description |
Calculation |
|
Date |
Date of the transaction (ex - March 25, 2024) |
Not Applicable |
|
Time |
Time of the transaction (ex - 05:39:49 AM) |
Not Applicable |
|
House Account Code |
House Account “Account Number” |
Not Applicable |
|
House Account Name |
Name of the house account |
Not Applicable |
|
Account Type |
Indicates type of house account (Temporary or Permanent) |
Not Applicable |
|
Folio Number |
Folio Number |
Not Applicable |
|
Transaction Code |
Transaction code / charge type code |
Not Applicable |
|
Transaction Description |
Transaction description / charge type name (ex - Accommodation) |
Not Applicable |
|
Last 4 Digits |
Last 4 digits of credit card (if relevant) |
Not Applicable |
|
Transaction Type |
Type of transaction (ex - Tax, Charge, Payment) |
Not Applicable |
|
Charge Type Category |
Category of the charge type that is relevant for the reservation (ex - Room Rent, Misc) |
Not Applicable |
|
Sub Charge Type Name |
Secondary label that categorizes a detailed transaction sub-item within a main department fee (e.g., "Espresso" under the main "Food & Beverage" charge type). |
Not Applicable |
|
Outlet Name |
Will indicate if POS is associated with the charge, tax, or payment |
Not Applicable |
|
Amount |
Transaction amount |
Not Applicable |
|
Username |
Username that processed that transaction |
Not Applicable |
|
Remarks |
Remarks on the transaction, if logged |
Not Applicable |
|
Charge Remarks |
A text note explaining specific reasons or details behind a manually posted fee. |
Not Applicable |
|
Transferred Transactions |
Financial items moved from one folio or guest account to another. |
Not Applicable |
|
POS Check Number |
The unique transaction ticket number generated by an integrated food or retail outlet. |
Not Applicable |
|
Tax Invoice Number |
The legally required billing identification code used for corporate tax reporting. |
Not Applicable |
|
Fiscal Invoice Number |
A government-regulated serial code used to track revenue for localized financial compliance. |
Not Applicable |
|
Company Name |
The registered corporate entity or business group responsible for paying the folio. |
Not Applicable |
|
Refund Reason |
A mandatory note explaining why money is being returned to a customer's payment method. |
Not Applicable |
Settlement Payments Section:
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 |
Calculation |
|
Date |
Date of the transaction (ex - March 25, 2024) |
Not Applicable |
|
Time |
Time of the transaction (ex - 05:39:49 AM) |
Not Applicable |
|
Company Code |
Company code in AR of the transaction |
Not Applicable |
|
Company Name |
Name of the company |
Not Applicable |
|
Transaction Code |
Transaction code / charge type code |
Not Applicable |
|
Transaction Description |
Transaction description / charge type name (ex - Accommodation) |
Not Applicable |
|
Last 4 Digits |
Last 4 digits of credit card (if relevant) |
Not Applicable |
|
Transaction Type |
Type of transaction (ex - Tax, Charge, Payment) |
Not Applicable |
|
Amount |
Transaction amount |
Not Applicable |
|
Username |
Username that processed that transaction |
Not Applicable |
|
Remarks |
Remarks on the transaction, if logged |
Not Applicable |
|
Refund Remarks |
A mandatory note explaining why money is being returned to a customer's payment method. |
Not Applicable |
Summary All Sections
|
Column Name |
Column Description |
Calculation |
|---|---|---|
|
Date |
Date of the transaction (ex - March 25, 2024) |
Not Applicable |
|
Time |
Time of the transaction (ex - 05:39:49 AM) |
Not Applicable |
|
Confirmation Number |
Confirmation number on the reservation |
Not Applicable |
|
Guest Name |
Primary guest name on the reservation |
Not Applicable |
|
First Name |
The isolated given name of the primary account holder. |
Not Applicable |
|
Last Name |
The isolated family or surname of the primary account holder. |
Not Applicable |
|
Room Number |
Room number on the reservation (if assigned) |
Not Applicable |
|
Group Code |
Group master code of the transaction |
Not Applicable |
|
Group Number |
Group confirmation number |
Not Applicable |
|
Group Name |
Name of the group |
Not Applicable |
|
House Account Code |
House Account “Account Number” |
Not Applicable |
|
House Account Name |
Name of the house account |
Not Applicable |
|
Account Type |
Indicates type of house account (Temporary or Permanent) |
Not Applicable |
|
Folio Number |
Folio Number |
Not Applicable |
|
Transaction Code |
Transaction code / charge type code |
Not Applicable |
|
Transaction Description |
Transaction description / charge type name (ex - Accommodation) |
Not Applicable |
|
Last 4 Digits |
Last 4 digits of credit card (if relevant) |
Not Applicable |
|
Transaction Type |
Type of transaction (ex - Tax, Charge, Payment) |
Not Applicable |
|
Charge Type Category |
Category of the charge type that is relevant for the reservation (ex - Room Rent, Misc) |
Not Applicable |
|
Sub Charge Type Name |
Secondary label that categorizes a detailed transaction sub-item within a main department fee (e.g., "Espresso" under the main "Food & Beverage" charge type). |
Not Applicable |
|
Outlet Name |
Will indicate if POS is associated with the charge, tax, or payment |
Not Applicable |
|
Amount |
Transaction amount |
Not Applicable |
|
Username |
Username that processed that transaction |
Not Applicable |
|
Remarks |
Remarks on the transaction, if logged |
Not Applicable |
|
Charge Remarks |
A text note explaining specific reasons or details behind a manually posted fee. |
Not Applicable |
|
Transferred Transactions |
Financial items moved from one folio or guest account to another. |
Not Applicable |
|
POS Check Number |
The unique transaction ticket number generated by an integrated food or retail outlet. |
Not Applicable |
|
Tax Invoice Number |
The legally required billing identification code used for corporate tax reporting. |
Not Applicable |
|
Fiscal Invoice Number |
A government-regulated serial code used to track revenue for localised financial compliance. |
Not Applicable |
|
Reference External Bill Number |
A unique identification number used to track and link billing vouchers, receipts, or invoices generated by third-party systems vendors to a guest's folio ledger. |
|
|
Company Name |
The registered corporate entity or business group responsible for paying the folio. |
Not Applicable |
|
Refund Reason |
A mandatory note explaining why money is being returned to a customer's payment method. |
Not Applicable |
|
Quantity |
The unit volume multiplier showing the total number of items or services posted to the account (e.g., 2 breakfast vouchers). |
Not Applicable |
|
Adults |
The total head count of adult occupants registered to the room or reservation when the transaction occurred. |
Not Applicable |
Misc Report Information
Available Features:
-
Export: Download data in CSV, Excel, or PDF formats.
-
Filter: Filter by date, user, or specific transaction types.
-
Highlight: Conditional formatting for high-value transactions or specific codes.
-
Bar Chart: View distribution of transaction types or amounts.
-
Group By: Aggregate data by All, Transaction Code, Description, or Transaction Type.
Available Configuration:
-
User Preferences: Customising personal column order and visibility.
-
Property Preferences: Property-wide column configuration.
Baseline Configuration:
-
Property Preferences Settings:
-
Following columns to be disabled for initial deployment:
-
None
-
-