Clerk Activity Report Overview
Parent Hub: βοΈ System & Administration Reports
Category: π€ User Activity Reports
Target Roles: Front Office Managers, Night Auditors, Hotel Controllers, Cashiers, General Managers
Key Value: Monitor front desk cashiering transactions, audit payment postings and refunds by individual user, reconcile shift takings by payment method, track billing adjustments, and verify staff transaction accountability.
Executive Summary
The Clerk Activity Report is an essential cashiering audit, shift reconciliation, and transaction compliance document within the π€ User Activity Reports category of the βοΈ System & Administration Reports hub. Designed to deliver complete financial transparency over front office payment processing and folio postings, it itemizes line-item transactions alongside clerk-level payment method summaries over specified date windows.
-
By organizing cashiering data into 2 defined report sections: Clerk Activity (Line-Item Transaction Detail) and Summary (Clerk & Tender Aggregations), this report enables front office supervisors, night auditors, and hotel controllers to evaluate granular guest folio postings (
Clerk Activity) alongside aggregated shift totals by user and tender type (Summary). It correlates transaction timestamps (Date,Time) and unique tracking identifiers (Transaction Number) with guest profile details (Name,First Name,Last Name,Company,Group Name,Room Number), staff user credentials (Username), accounting classification structures (Department Code,Department Name,GL Account Code,GL Account Name), payment parameters (Payment Type,Payment Detail), and monetary values (Amount,Total Amount).
Key Capabilities
-
Two-Section Cashiering Audit Structure: Organizes front office activity into individual line-item transaction records (
Clerk Activity) and aggregated clerk-by-tender summary totals (Summary). -
Staff User Accountability & Tracking: Logs the exact staff member or automated system process (
Username) executing each financial entry to maintain an airtight cashiering audit trail. -
Multi-Tender Reconciliation: Itemizes payment methods across cash, credit cards (Visa, MasterCard, Amex), checks, and direct bill accounts (
Payment Type), capturing card suffix or voucher references (Payment Detail). -
Folio & Guest Profile Integration: Direct links to guest identities (
Name,First Name,Last Name), assigned room numbers (Room Number), attached group blocks (Group Name), and corporate billing profiles (Company). -
Financial & General Ledger Alignment: Maps transactions to specific operational departments (
Department Code,Department Name) and chart of accounts codes (GL Account Code,GL Account Name) for streamlined night audit balancing.
Report Views & Functional Breakdown
The Clerk Activity Report presents cashiering and transaction audit data across 2 defined sections:
ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
β CLERK ACTIVITY REPORT β
ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ€
β 2 Defined Report Sections β
ββββββββββββββββββββββββββββ¬ββββββββββββββββββββββββββββββββββββββββββββββ€
β 1. Clerk Activity β 2. Summary β
β (Line-Item Detail) β (Clerk by Tender Totals) β
ββββββββββββββββββββββββββββ΄ββββββββββββββββββββββββββββββββββββββββββββββ
1. Clerk Activity Section (Line-Item Detail)
Monitors individual financial transactions posted across guest and group folios, detailing posting dates, timestamps, unique transaction IDs, guest names, companies, room numbers, operating clerks, transaction amounts, department/GL mappings, payment types, and payment details.
-
Primary Use: Conducting shift-end drawer balancing, auditing suspicious payment reversals or refunds, verifying authorization details, and investigating guest billing discrepancies.
-
Key Metrics: Date, Time, Transaction Number, Group Name, Name, First Name, Last Name, Company, Room Number, Username, Amount, Department Code, Department Name, GL Account Code, GL Account Name, Payment Type, Payment Detail.
2. Summary Section (Clerk by Tender Totals)
Aggregates net transactional sums grouped by individual staff user and payment tender type.
-
Primary Use: Reconciling shift totals by cashier, balancing credit card settlement batches against terminal totals, auditing cash drops, and verifying direct billing postings.
-
Key Metrics: Username, Payment Type, Total Amount.
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 18 exact dynamic columns available across the 2 report sections, sorted in alphabetical order by column name:
π° Financial Posting Logic: Figures in
AmountandTotal Amountreflect gross transactional values posted to folios. Positive figures represent payments received, credit card authorizations collected, or debit charges posted. Negative figures represent refunds, cash paid-outs, or transaction reversals. In Section 2,Total Amountrepresents the mathematical sum of all transaction amounts for the given clerk and tender method.
|
Column Name |
Section Applicability |
Description |
Data Source / System Mapping |
Includes Taxes & Fees? |
|---|---|---|---|---|
|
Amount |
Section 1 |
Monetary value of the individual transaction or payment posted to the folio. |
Front Office Ledger > Transaction Amount |
π’ Yes |
|
Company |
Section 1 |
Official corporate account or business profile attached to the guest reservation. |
Profile Master > Company Name |
N/A |
|
Date |
Section 1 |
Calendar date on which the cashiering transaction was posted. |
System Audit Trail > Posting Date |
N/A |
|
Department Code |
Section 1 |
Alphanumeric identifier of the operational department where the transaction originated. |
Financial Setup > Department Code |
N/A |
|
Department Name |
Section 1 |
Descriptive title of the operating department credited with the charge or payment. |
Financial Setup > Department Name |
N/A |
|
First Name |
Section 1 |
First name of the primary guest or profile owner linked to the reservation. |
Guest Profile > First Name |
N/A |
|
GL Account Code |
Section 1 |
General ledger account number assigned to the transaction for accounting reconciliation. |
Accounting Setup > GL Code |
N/A |
|
GL Account Name |
Section 1 |
Descriptive general ledger account title corresponding to the chart of accounts. |
Accounting Setup > Account Name |
N/A |
|
Group Name |
Section 1 |
Name of the group block or master tour account associated with the guest reservation. |
Group Master > Group Name |
N/A |
|
Last Name |
Section 1 |
Last name (surname) of the primary guest or profile owner linked to the reservation. |
Guest Profile > Last Name |
N/A |
|
Name |
Section 1 |
Full combined name of the primary guest (typically formatted as LAST FIRST). |
Guest Profile > Full Name |
N/A |
|
Payment Detail |
Section 1 |
Supplementary identifier for the payment method, such as masked card last 4 digits or check reference. |
Payment Gateway > Card Mask / Suffix |
N/A |
|
Payment Type |
Both Sections |
Tender classification used for the transaction (e.g., |
Payment Gateway > Tender Type |
N/A |
|
Room Number |
Section 1 |
Physical guest room number assigned to the reservation folio at the time of posting. |
PMS Room Master > Room Assigned |
N/A |
|
Time |
Section 1 |
Exact timestamp at which the cashiering entry was committed to the ledger. |
System Audit Trail > Posting Time |
N/A |
|
Total Amount |
Section 2 |
Cumulative net monetary amount posted by the specified clerk under the designated tender type. |
SUM(Section 1 Amount) |
π’ Yes |
|
Transaction Number |
Section 1 |
Unique system-generated transaction tracking ID assigned to the folio entry. |
Folio Ledger > Transaction ID |
N/A |
|
Username |
Both Sections |
Full name or login ID of the staff clerk or automated system user executing the transaction. |
Security Master > Clerk Username |
N/A |
Customization & Platform Features
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: Clerk Activity
-
Transaction Key & Chronological Timestamps (Cols 1β3):
Transaction Number|Date|Time -
Clerk Accountability (Col 4):
Username -
Guest Profile & In-House Locators (Cols 5β8):
Room Number|Name|First Name|Last Name -
Group & Corporate Account Affiliations (Cols 9β10):
Group Name|Company -
Financial Posting & Payment Tender Settlement (Cols 11β13):
Amount|Payment Type|Payment Detail -
Department & General Ledger Distribution (Cols 14β17):
Department Code|Department Name|GL Account Code|GL Account Name
-
-
Section 2: Summary
-
Clerk Accountability & Payment Tender (Cols 1β2):
Username|Payment Type -
Aggregated Financial KPI (Col 3):
Total Amount
-
-
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. |
|
Saved Views |
Saves your column filtering, sorting, and highlight preferences so you can easily reload your custom view later without reconfiguring the report. |
|
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. |
Advanced Controls
-
Cash Drawer & Terminal Balancing: Use Section 2 (
Summary) at the conclusion of every front desk shift to balance cash drawers against posted cash amounts and verify electronic draft capture (EDC) credit card settlement batches. -
Negative Amount & Refund Auditing: Filter Section 1 (
Clerk Activity) byAmount < 0to audit all credit card refunds, cash paid-outs, or billing reversals against manager authorization policies. -
Highlighting (Conditional Formatting): Apply custom rules to automatically highlight high-value payments (
Amount > $1,000), refund transactions (Amount < $0), or system automated entries (Username = system user).
π Related Reports & Next Steps
Within βοΈ System & Administration Reports & π€ User Activity Reports:
-
User Activity β Master system audit trail tracking user logins, screen navigation, configuration changes, and record creation.
-
Operator Security β System-level security and access event tracking across administrative modules.
-
Clerk Shift β Payment information, deposit drop information, shift details and paid out summary.
Cross-Pillar Deep Dives:
-
π³ Financial & Night Audit: Reconcile Section 2
Total Amounttender totals with Net Revenue, Trial Balance, and Credit Card Status to ensure zero ledger variance at night audit close. -
ποΈ Front Desk & Guest Services: Cross-reference line-item guest transactions (
Transaction Number,Room Number) with In-House Guest Balances and Departures List to resolve guest billing inquiries.