All Transactions Report Overview
Parent Hub: π° Finance & Accounting Reports
Category: π³ Payments & Transactions
Target Roles: Hotel Controllers, Night Auditors, Staff Accountants, Front Office Managers, Cashier Supervisors, Directors of Finance
Key Value: Comprehensive transaction-level financial auditing across the entire property ecosystem, tracking every charge, tax, payment, refund, tax exemption, and folio transfer across transient reservations, group masters, house accounts, and direct bill settlement paymentsβproviding an end-to-end audit trail for revenue reconciliation, cashier shift balancing, and statutory tax compliance.
Date Parameter: Date Range Selector (Start & End) | Past | Maximum Window: 94 Days in UI - full 365-day background export available.
Executive Summary
The All Transactions Report is the primary, master financial audit log within the π³ Payments & Transactions category of the π° Finance & Accounting Reports suite. Designed for total transaction transparency and General Ledger (GL) reconciliation, it serves as the propertyβs master ledger log, capturing every individual monetary event posted within the system during a selected operational period.
By organizing complete ledger activity across five explicit operational sections (Reservations, Groups, House Accounts, Settlement Payments, and Summary All Sections), this report captures comprehensive transaction metadataβincluding transaction classifications (Transaction Type like CHARGE, TAX, PAYMENT, REFUND), transaction codes (Transaction Code), charge categories (Charge Type Category, Sub Charge Type name), card tokens (Last 4 Digits), outlet locations (Outlet Name), tax documentation (Tax Invoice Number, Fiscal Invoice Number, POS Check Number), transfer audit trails (Transferred Transactions), and staff attributions (Username). This empowers controllers, night auditors, and compliance officers to perform deep-dive financial audits, investigate folio variances, and verify GL control account balances with zero discrepancy.
Key Capabilities
-
Five-Section Property-Wide Transaction Governance: Segregates financial postings across transient stays (
Reservations), master room blocks (Groups), internal operational accounts (House Accounts), corporate AR cash receipts (Settlement Payments), and a consolidated property-wide master journal (Summary All Sections). -
Complete Transaction Lifecycle Classification: Categorizes every financial posting by operational function (
Transaction Type, e.g.,CHARGE,PAYMENT,TAX,REFUND,TAX EXEMPTION), high-level revenue stream (Charge Type Category), granular sub-category (Sub Charge Type name), and revenue center (Outlet Name). -
End-to-End Staff & Operator Accountability: Pairs the operator's system login credential (
Username) with their full display name (Employee Nameβ available in version 6.0.6), supported by mandatory operational notes (Remarks,Charge Remarks, andRefund Reason). -
Statutory Tax & Fiscal Compliance Auditing: Links transactions directly to sequential fiscal and tax documentation (
Tax Invoice Number,Fiscal Invoice Number), POS check references (POS Check Number), and external billing keys (Reference External Bill Number). -
Folio Routing & Transfer Traceability: Tracks transactions moved between guest rooms, group masters, or house accounts via dedicated routing indicators (
Transferred Transactions, e.g.,Transferred In). -
Payment Card & Settlement Verification: Logs masked payment card identifiers (
Last 4 Digits) alongside tender codes (Transaction Code) to streamline merchant batch balancing and corporate direct bill payment verification.
Report Views & Functional Breakdown (All 5 Sections)
The All Transactions Report presents property-wide financial activity across five structured operational sections:
ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
β ALL TRANSACTIONS REPORT β
ββββββββββββββββββββββββββββ¬βββββββββββββββββββββββββββ¬βββββββββββββββββββ€
β 1. Reservations β 2. Groups β 3. House Accountsβ
β (Transient Guests) β (Convention Blocks) β (Non-Guest) β
ββββββββββββββββββββββββββββΌβββββββββββββββββββββββββββ΄βββββββββββββββββββ€
β 4. Settlement Payments β 5. Summary All Sections β
β (Corporate AR) β (Consolidated Master Ledger) β
ββββββββββββββββββββββββββββ΄ββββββββββββββββββββββββββββββββββββββββββββββ
1. Reservations Section (Transient Guest Postings)
Itemizes all charges, taxes, payments, refunds, tax exemptions, and transfers posted to individual guest reservation folios.
-
Primary Use: Auditing guest room and incidental charges, verifying checkout payment tenders, reviewing tax exemptions, and investigating folio transfers.
-
Key Metrics: Date, Time, Confirmation Number, Guest Name, First Name, Last Name, Room Number, Folio Number, Transaction Code, Transaction Description, Last 4 Digits, Transaction Type, Charge Type Category, Sub Charge Type name, Outlet Name, Amount, Username, Employee Name (v6.0.6), Remarks, Charge Remarks, Transferred Transactions, POS Check Number, Tax Invoice Number, Fiscal Invoice Number, Company Name, Refund Reason, Quantity, Adults, Reference External Bill Number.
2. Groups Section (Group Master Folio Postings)
Details all master bill postings, banquet charges, attrition fees, group deposits, and payments recorded on group master folios.
-
Primary Use: Reconciling master event billing, auditing group advance deposits, and verifying group tax and outlet postings.
-
Key Metrics: Date, Time, Group Code, Group Number, Group Name, Folio Number, Transaction Code, Transaction Description, Last 4 Digits, Transaction Type, Charge Type Category, Sub Charge Type name, Outlet Name, Amount, Username, Employee Name (v6.0.6), Remarks, POS Check Number, Tax Invoice Number, Charge Remarks, Transferred Transactions, Company Name, Fiscal Invoice Number, Reference External Bill Number, Refund Reason, Quantity, Adults.
3. House Accounts Section (Internal & POS Clearing)
Tracks financial transactions posted to permanent operational clearing accounts (e.g., POS interface, sundry shops) and temporary internal event accounts.
-
Primary Use: Auditing POS interface clearing balances, monitoring internal departmental charges, and verifying miscellaneous house settlements.
-
Key Metrics: Date, Time, House Account Code, House Account Name, Account Type, Folio Number, Transaction Code, Transaction Description, Last 4 Digits, Transaction Type, Charge Type Category, Sub Charge Type name, Outlet Name, Amount, Username, Employee Name (v6.0.6), Remarks, POS Check Number, Tax Invoice Number, Charge Remarks, Transferred Transactions, Fiscal Invoice Number, Reference External Bill Number, Company Name, Refund Reason, Quantity, Adults.
4. Settlement Payments Section (Corporate AR Cash Receipts)
Captures accounts receivable payments on account and corporate billing refunds applied directly to city ledger company profiles.
-
Primary Use: Reconciling corporate check, credit card, and electronic payments against city ledger deposits and auditing AR payment refunds.
-
Key Metrics: Date, Time, Company Code, Company Name, Transaction Code, Transaction Description, Last 4 Digits, Transaction Type, Amount, Username, Employee Name (v6.0.6), Remarks, Refund Reason.
5. Summary All Sections (Consolidated Property-Wide Master Journal)
Combines all transaction records from Reservations, Groups, House Accounts, and Settlement Payments into a unified chronological ledger with property-wide grand totals.
-
Primary Use: Macro-level daily revenue and payment balancing, night audit shift verification, and general ledger subledger reconciliation.
-
Key Metrics: All 35 unified ledger columns spanning reservations, groups, house accounts, settlements, financial amounts, quantities, and adult counts.
Data Dictionary (Dynamic View Columns)
Customize your default view using the Configure (βοΈ) icon on the report page. Below is the full data dictionary representing all 36 exact dynamic columns available across the five report sections, sorted in alphabetical order by column name:
π° Financial Sign Convention & Balancing Logic:
Debit Postings (Positive Amounts): Charges (
CHARGE), statutory taxes (TAX), and payment refunds (REFUND) display as positive monetary figures increasing folio receivables.Credit Postings (Negative Amounts): Guest payments (
PAYMENT), corporate AR settlements, and tax reversals (TAX EXEMPTION) display as negative monetary figures reducing folio balances.Section 5 Consolidation: The
Totalsrow in Summary All Sections represents the net algebraic sum of all debits and credits across all five operational streams.
π Upcoming Release Note (Version 6.0.6):
The Employee Name columnβwhich displays the full first and last name of the staff member alongside their system login (Username)βwill become available starting in the 6.0.6 version release.
|
Column Name |
Section Applicability |
Description |
Data Source / System Mapping |
Includes Taxes & Fees? |
|---|---|---|---|---|
|
Account Type |
Sections 3, 5 |
Structural classification of the house account folio ( |
House Account Master > Account Type |
N/A |
|
Adults |
Sections 1, 2, 3, 5 |
Number of adult guests registered on the reservation or associated with the transaction posting. |
Reservation Engine > Adult Count |
N/A |
|
Amount |
All Sections |
Monetary value of the posted transaction (positive for charges, taxes, and refunds; negative for payments and tax exemptions). |
Financial Ledger > Transaction Amount |
π’ Yes but some lines (transactions) may be No. |
|
Charge Remarks |
Sections 1, 2, 3, 5 |
Specific line-item notes or posting descriptions attached directly to a charge transaction. |
Folio Subledger > Charge Line Notes |
N/A |
|
Charge Type Category |
Sections 1, 2, 3, 5 |
Primary revenue or departmental classification assigned to the transaction code (e.g., |
Chart of Accounts > Charge Category |
N/A |
|
Company Code |
Section 4 |
Unique corporate alphanumeric identifier or city ledger account code assigned to the direct billing account (e.g., |
Company Master > Account Code |
N/A |
|
Company Name |
All Sections |
Registered commercial trade name, corporate billing account, or agency title associated with the reservation or settlement payment. |
Company Master > Company Legal Name |
N/A |
|
Confirmation Number |
Sections 1, 5 |
Primary unique property management system (PMS) confirmation identifier assigned to the guest booking. |
Reservation Engine > Confirmation ID |
N/A |
|
Date |
All Sections |
Operational business calendar date on which the transaction was posted to the folio or ledger. |
Financial Ledger > Business Posting Date |
N/A |
|
Employee Name |
All Sections |
Full first and last name of the staff member who posted the transaction (Available in the 6.0.6 version release). |
Security / User Directory > Full Name |
N/A |
|
First Name |
Sections 1, 5 |
First name of the primary registered guest associated with the reservation folio. |
Guest Profile > First Name |
N/A |
|
Fiscal Invoice Number |
Sections 1, 2, 3, 5 |
Official sequential fiscal invoice reference generated for statutory and government tax compliance. |
Fiscal Engine > Fiscal Document ID |
N/A |
|
Folio Number |
Sections 1, 2, 3, 5 |
Internal folio sequence identifier representing the specific guest, group, or house folio window where the transaction resides. |
Folio Subledger > Folio Window ID |
N/A |
|
Group Code |
Sections 2, 5 |
Unique alphanumeric block booking code assigned to the group contract. |
Group Master > Group Code |
N/A |
|
Group Name |
Sections 2, 5 |
Official title, event name, or master identifier assigned to the group block. |
Group Master > Group Block Name |
N/A |
|
Group Number |
Sections 2, 5 |
Unique central master tracking number assigned to the group booking. |
Group Master > Group ID |
N/A |
|
Guest Name |
Sections 1, 5 |
Full legal name of the primary registered guest, formatted as LAST FIRST. |
Guest Profile > Full Name |
N/A |
|
House Account Code |
Sections 3, 5 |
Unique alphanumeric account code or internal identifier assigned to the house account folio (e.g., |
House Account Master > Account Code |
N/A |
|
House Account Name |
Sections 3, 5 |
Descriptive title or department designation assigned to the house account (e.g., |
House Account Master > Account Name |
N/A |
|
Last 4 Digits |
All Sections |
Masked final four digits of the credit or debit card used for payment or refund processing (e.g., |
Payment Gateway > Masked Card PAN |
N/A |
|
Last Name |
Sections 1, 5 |
Last name (surname) of the primary registered guest associated with the reservation folio. |
Guest Profile > Last Name |
N/A |
|
Outlet Name |
Sections 1, 2, 3, 5 |
Revenue outlet, restaurant, bar, or point-of-sale station where the charge originated. |
POS / Outlet Master > Outlet Title |
N/A |
|
POS Check Number |
Sections 1, 2, 3, 5 |
Point-of-sale guest check or ticket number linked to interface charges posted to the folio. |
POS Interface > Check Reference ID |
N/A |
|
Quantity |
Sections 1, 2, 3, 5 |
Unit count or item quantity associated with the posted charge transaction. |
Folio Subledger > Transaction Quantity |
N/A |
|
Reference External Bill Number |
Sections 1, 2, 3, 5 |
External invoice, voucher, or third-party billing reference number attached to the transaction. |
Folio Subledger > External Bill Ref |
N/A |
|
Refund Reason |
All Sections |
Mandatory justification code or text explanation recorded when processing a payment refund ( |
Cashiering Audit > Refund Reason |
N/A |
|
Remarks |
All Sections |
General operational notes or cashier comments entered during transaction posting or settlement. |
Financial Ledger > Transaction Remarks |
N/A |
|
Room Number |
Sections 1, 5 |
Physical guest room number assigned to the reservation folio. |
Room Inventory Master > Room Number |
N/A |
|
Sub Charge Type name |
Sections 1, 2, 3, 5 |
Granular revenue sub-classification beneath the primary charge category for detailed departmental reporting. |
Chart of Accounts > Sub-Category |
N/A |
|
Tax Invoice Number |
Sections 1, 2, 3, 5 |
Sequential front desk tax invoice number generated and associated with the billed folio transaction. |
Front Desk Cashiering > Tax Invoice ID |
N/A |
|
Time |
All Sections |
Exact time of day (HH:MM:SS) when the transaction was posted in the property management system. |
Financial Ledger > Posting Timestamp |
N/A |
|
Transaction Code |
All Sections |
System accounting code identifying the specific charge, tax, or payment tender (e.g., |
Chart of Accounts > Transaction Code |
N/A |
|
Transaction Description |
All Sections |
Standard descriptive label corresponding to the transaction code (e.g., |
Chart of Accounts > Code Description |
N/A |
|
Transaction Type |
All Sections |
Operational nature of the ledger entry ( |
Financial Ledger > Entry Type |
N/A |
|
Transferred Transactions |
Sections 1, 2, 3, 5 |
Routing status indicator identifying postings moved from or to another folio (e.g., |
Folio Routing Engine > Transfer Flag |
N/A |
|
Username |
All Sections |
System login email address or user credential of the operator who posted the transaction. |
Security / User Directory > User ID |
N/A |
Customization & Platform Features
π Upcoming Release Note (Version 6.0.6):
The Employee Name columnβwhich displays the full first and last name of the staff member alongside their system login (Username)βwill become available starting in the 6.0.6 version release.
User & Property Preferences
-
Personal Preference: Tailor your individual view by hiding or dragging columns. Your preferences save automatically for future sessions.
-
Property Defaults: System Admins can configure standard default layouts across all property users to streamline operational reporting. To maximize audit efficiency, group the columns into the below logical blocks:
-
Section 1: Reservations
-
Posting Timestamp (Cols 1β2):
Date|Time -
Primary Reservation Key & Room Anchor (Cols 3β5):
Confirmation Number|Room Number|Folio Number -
Guest Profile & Corporate Affiliation (Cols 6β10):
Guest Name|First Name|Last Name|Adults|Company Name -
Transaction Classification & Departmental Hierarchy (Cols 11β16):
Transaction Type|Transaction Code|Transaction Description|Charge Type Category|Sub Charge Type name|Outlet Name -
Financial Posting, Volume & Settlement Tender (Cols 17β19):
Amount|Quantity|Last 4 Digits -
Staff Accountability (Cols 20β21):
Username|Employee Name -
External POS, Statutory Tax & Billing References (Cols 22β25):
POS Check Number|Reference External Bill Number|Tax Invoice Number|Fiscal Invoice Number -
Audit Transfers & Explanatory Remarks (Cols 26β29):
Transferred Transactions|Refund Reason|Charge Remarks|Remarks
-
-
Section 2: Groups
-
Posting Timestamp (Cols 1β2):
Date|Time -
Group Master & Folio Identifiers (Cols 3β7):
Group Number|Group Code|Group Name|Company Name|Folio Number -
Transaction Classification & Departmental Hierarchy (Cols 8β13):
Transaction Type|Transaction Code|Transaction Description|Charge Type Category|Sub Charge Type name|Outlet Name -
Financial Posting, Volume, Occupancy & Settlement Tender (Cols 14β17):
Amount|Quantity|Adults|Last 4 Digits -
Staff Accountability (Cols 18β19):
Username|Employee Name -
External POS, Statutory Tax & Billing References (Cols 20β23):
POS Check Number|Reference External Bill Number|Tax Invoice Number|Fiscal Invoice Number -
Audit Transfers & Explanatory Remarks (Cols 24β27):
Transferred Transactions|Refund Reason|Charge Remarks|Remarks
-
-
Section 3: House Accounts
-
Posting Timestamp (Cols 1β2):
Date|Time -
House Account & Folio Identifiers (Cols 3β7):
House Account Code|House Account Name|Account Type|Company Name|Folio Number -
Transaction Classification & Departmental Hierarchy (Cols 8β13):
Transaction Type|Transaction Code|Transaction Description|Charge Type Category|Sub Charge Type name|Outlet Name -
Financial Posting, Volume, Occupancy & Settlement Tender (Cols 14β17):
Amount|Quantity|Adults|Last 4 Digits -
Staff Accountability (Cols 18β19):
Username|Employee Name -
External POS, Statutory Tax & Billing References (Cols 20β23):
POS Check Number|Reference External Bill Number|Tax Invoice Number|Fiscal Invoice Number -
Audit Transfers & Explanatory Remarks (Cols 24β27):
Transferred Transactions|Refund Reason|Charge Remarks|Remarks -
Section 4: Settlement Payments
-
Posting Timestamp (Cols 1β2):
Date|Time -
Corporate Account Identifiers (Cols 3β4):
Company Code|Company Name -
Settlement Transaction Classification (Cols 5β8):
Transaction Type|Transaction Code|Transaction Description|Last 4 Digits -
Financial Settlement KPI (Col 9):
Amount -
Staff Accountability (Cols 10β11):
Username|Employee Name -
Audit Justification & Remarks (Cols 12β13):
Refund Reason|Remarks
-
-
-
-
Section 5: Summary All Sections
-
Posting Timestamp (Cols 1β2):
Date|Time -
Reservation & Guest Entity Identifiers (Cols 3β7):
Confirmation Number|Room Number|Guest Name|First Name|Last Name -
Group Block Entity Identifiers (Cols 8β10):
Group Number|Group Code|Group Name -
House Account & Corporate Entity Identifiers (Cols 11β14):
House Account Code|House Account Name|Account Type|Company Name -
Master Folio Key (Col 15):
Folio Number -
Transaction Classification & Departmental Hierarchy (Cols 16β21):
Transaction Type|Transaction Code|Transaction Description|Charge Type Category|Sub Charge Type name|Outlet Name -
Financial Posting, Volume, Occupancy & Settlement Tender (Cols 22β25):
Amount|Quantity|Adults|Last 4 Digits -
Staff Accountability (Cols 26β27):
Username|Employee Name -
External POS, Statutory Tax & Billing References (Cols 28β31):
POS Check Number|Reference External Bill Number|Tax Invoice Number|Fiscal Invoice Number -
Audit Transfers & Explanatory Remarks (Cols 32β35):
Transferred Transactions|Refund Reason|Charge Remarks|Remarks
-
-
Report Toolbar & Quick Actions
Use the top-right toolbar icons on the report page to manage and export your data view:
|
Icon |
Action / Feature |
Description |
|
Knowledge Article |
Opens the knowledge base article to learn how to interpret this report. |
|
Background Export |
Allows users to download up to 365 days of data directly to their computer in CSV format. |
|
Saved Views |
Saves your column filtering, sorting, and highlight preferences so you can easily reload your custom view later without reconfiguring the report. |
|
Bar Chart |
Displays report data in a visual bar chart format. |
|
Filter |
Opens filter controls to isolate specific data within a column based on your selected criteria. |
|
Highlight |
Highlights column values in a designated color based on selected conditions. |
|
Export |
Exports and downloads the report in various formats (Excel, PDF, CSV) for offline analysis or printing. |
|
Configure |
Opens column selection controls to toggle visibility, reorder columns, or hide rows with all zeros. |
|
Additional Configuration |
Provides advanced report configuration and display formatting options to customize data presentation. |
|
Group By |
Summarize and group report data dynamically in real time. |
Interactive Visualizations & Grouping Controls
-
Group By & Pie Chart Visualization: The All Transactions report features an interactive pie chart to help analyze monetary posting patterns and fee distributions across your property. Users can group transaction entries on the fly by Transaction Type (CHARGE, TAX, PAYMENT, REFUND), Transaction Code, or Transaction Description to evaluate posting patterns. By selecting Amount from the Select Base Column dropdown menu, the chart dynamically displays percentage share breakdowns accompanied by an interactive color-coded legend across the Reservations, Groups, House Accounts, and Settlement Payments sub-tabs.
-
Bar Chart Visualizer: The All Transactions report includes an interactive bar chart to help analyze monetary posting activity, debits, and credit trends over time. By selecting Amount from the Select Column (Y-Axis) dropdown menu, users can visually track daily transaction spikesβincluding positive charges and negative payments/refundsβchronologically alongside the detailed transaction grid across the Reservations, Groups, House Accounts, and Settlement Payments sub-tabs.
Advanced Controls
-
Exporting & General Ledger Auditing: Download in Excel or PDF format to support end-of-month general ledger tie-outs, external tax authority audits, or night audit documentation.
-
Filtering: Filter data by specific Transaction Type, Transaction Code, Charge Type Category, Username, or date ranges.
-
Highlighting (Conditional Formatting): Apply custom rules to automatically highlight high-value adjustments, negative charge entries, or manual tax overrides.
π Related Reports & Next Steps
Within π³ Payments & Transactions & βοΈ Ledgers & Trial Balance:
-
Payment Activity Report β Line-item transaction audit capturing token details and gateway approvals for all payments.
-
All Payments Report β Complete transaction ledger logging all cash, check, credit card, and direct-bill payment receipts.
-
Authorized Payments Report β Audit credit card authorization holds, capture approvals, and card refund processing.
-
Adjustments & Refunds Activity Report β Track rate write-offs, charge adjustments, and cash/card refund transactions.
-
Trial Balance Report β Translate daily transaction postings into formal General Ledger asset, liability, and revenue control accounts.
-
Day End Summary Report β Review consolidated daily revenue, tax, payment, and deposit blueprints at business date close.
Cross-Pillar Deep Dives:
-
ποΈ Taxes & Expenses: To audit tax percentage setups and statutory tax accruals, review Tax Summary Report or Active Taxes & Charge Types Report.
-
π¬ Billing & Receivables (AR): To inspect corporate accounts receivable direct-bill settlements, review Direct Bill Ledger Details Report.