Accounts Receivable Activity Report Overview
Parent Hub: π° Finance & Accounting Reports
Category: π¬ Billing & Receivables (AR)
Target Roles: Accounts Receivable Managers, Hotel Controllers, Credit Managers, Staff Accountants, Night Auditors, Directors of Finance, General Managers
Key Value: Detailed operational tracking of all debits and manual ledger adjustments transferred to Accounts Receivable, auditing individual guest direct-billed stays, monitoring aged receivable distribution across standardized aging brackets, and reconciling reservation check-in and check-out dates against city ledger posting milestones.
Date Parameter: Current Business Day Only (Dynamic Live Data)
Executive Summary
The Accounts Receivable Activity report is an essential transaction-level auditing, direct bill reconciliation, and credit tracking document within the π¬ Billing & Receivables (AR) category of the π° Finance & Accounting Reports hub. Designed to provide accounting and front office teams with clear visibility into direct billing transfers, it logs every transaction routed to corporate city ledger accounts over a defined date range, capturing both automated guest folio transfers upon departure and manual ledger adjustments.
-
Centered on direct bill ledger governance through the unified Accounts Receivable section, this report establishes complete operational transparency by linking corporate account identifiers (
Company Name,Company Code) directly to guest stay profiles (Name,First Name,Last Name,Transaction Number,Check In Date,Check Out Date,Transaction Status) and financial aging classifications (Current,31 to 60,61 to 90,91 to 120,121 to 150,Over 150,Amount). By itemizing automated folio transfers (RESERVATION) alongside direct accounting entries (MANUAL AR), this report enables finance leaders to verify billing timeliness, audit disputed stay charges, validate city ledger room routing, and ensure accurate aging attribution across accounts receivable portfolios.
Key Capabilities
-
Transaction-Level AR Transfer Auditing: Details every individual debit line transferred from front desk guest folios to the city ledger, logging the exact transfer date (
Date) and monetary total (Amount). -
Operational vs. Manual Entry Disaggregation: Distinguishes between automated folio checkout transfers (
Transaction Type = RESERVATION) and manual city ledger debit postings or balance adjustments (Transaction Type = MANUAL AR). -
Comprehensive Guest Stay Context: Pairs corporate direct billing lines with guest reservation details, including confirmation numbers (
Transaction Number), guest full names (Name,First Name,Last Name), arrival timestamps (Check In Date), departure dates (Check Out Date), and stay lifecycle states (Transaction Status, e.g.,CHECKED OUT,NO SHOW,CANCELLED). -
Multi-Bracket Aging Attribution: Automatically categorizes individual transaction amounts into discrete 30-day aging buckets (
Current,31 to 60,61 to 90,91 to 120,121 to 150,Over 150) based on elapsed operational days from posting. -
Direct Bill Routing Verification: Enables finance teams to verify that room, tax, and incidental charges transferred to company accounts match corporate billing agreements and authorized reservation routing instructions.
Report Views & Functional Breakdown
The Accounts Receivable Activity report presents direct bill transactions in a unified master matrix supporting three primary operational perspectives:
ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
β ACCOUNTS RECEIVABLE ACTIVITY REPORT β
ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ€
β Unified Matrix View β
ββββββββββββββββββββββββββββ¬βββββββββββββββββββββββββββ¬βββββββββββββββββββ€
β 1. Corporate Profile & β 2. Guest Stay Context & β 3. Aging Bucket β
β Posting Milestones β Reservation Status β Distribution β
ββββββββββββββββββββββββββββ΄βββββββββββββββββββββββββββ΄βββββββββββββββββββ
1. Corporate Profile & Posting Milestones
Tracks corporate debtor credentials, client identification codes, and ledger posting dates.
-
Primary Use: Identifying the debtor company, verifying client code accuracy, and auditing city ledger transfer posting dates.
-
Key Metrics: Date, Company Name, Company Code, Transaction Type.
2. Guest Stay Context & Reservation Status
Links city ledger debits to the underlying reservation and physical guest stay details.
-
Primary Use: Verifying folio direct bill routing, auditing no-show or cancellation charges transferred to direct bill, and substantiating corporate invoices with guest stay dates.
-
Key Metrics: Transaction Number, Name, First Name, Last Name, Check In Date, Check Out Date, Transaction Status.
3. Aging Bucket Distribution
Allocates transaction amounts into standardized aging brackets based on the elapsed time between posting and the reporting date.
-
Primary Use: Tracking the aging maturity of individual transactions, identifying newly transferred charges versus aged uncollected items, and reconciling property-level aging totals.
-
Key Metrics: Current, 31 to 60, 61 to 90, 91 to 120, 121 to 150, Over 150, 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, sorted in alphabetical order by column name:
π‘ Tax Treatment Note: All aging bucket balances (Current through Over 150) and the Amount field represent Gross Amounts (Includes Taxes and Fees) transferred from the originating folios.
|
Column Name |
Description |
Data Source / Calculation Formula |
Includes Taxes & Fees? |
|
31 to 60 |
Outstanding gross balance within the 31β60 day window. |
System Aging Calculation (31β60 Days) |
π’ Yes |
|
61 to 90 |
Outstanding gross balance within the 61β90 day window. |
System Aging Calculation (61β90 Days) |
π’ Yes |
|
91 to 120 |
Outstanding gross balance within the 91β120 day window. |
System Aging Calculation (91β120 Days) |
π’ Yes |
|
121 to 150 |
Outstanding gross balance within the 121β150 day window. |
System Aging Calculation (121β150 Days) |
π’ Yes |
|
Amount |
Total gross outstanding balance for the line item. |
|
π’ Yes |
|
Check In Date |
Arrival date associated with the reservation. |
|
N/A |
|
Check Out Date |
Departure date associated with the reservation. |
|
N/A |
|
Company Code |
Unique identifier code assigned to the company. |
|
N/A |
|
Company Name |
Full name of the contracted corporate account. |
|
N/A |
|
Current |
Outstanding gross balance within the 0β30 day window. |
System Aging Calculation (0β30 Days) |
π’ Yes |
|
Date |
Date the transaction was posted to the AR ledger. |
Transaction Posting Timestamp |
N/A |
|
First Name |
First name of the primary guest. |
|
N/A |
|
Last Name |
Last name of the primary guest. |
|
N/A |
|
Name |
Full guest or account primary contact name. |
|
N/A |
|
Over 150 |
High-risk gross balance outstanding past 150 days. |
System Aging Calculation (> 150 Days) |
π’ Yes |
|
Transaction Number |
Confirmation number or house account ID. |
|
N/A |
|
Transaction Status |
Status of the record ( |
Reservation / Account State |
N/A |
|
Transaction Type |
Source classification ( |
System Transaction Tag |
N/A |
Customization & Platform Features
User & Property Preferences
-
Personal Preference: Tailor your individual view by hiding or dragging columns. Your preference saves 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:
-
Company & Account Context (Cols 1β2):
Company Name|Company Code -
Transaction & Activity Identifiers (Cols 3β6):
Date|Transaction Type|Transaction Number|Transaction Status -
Guest & Stay Details (Cols 7β11):
Name|First Name|Last Name|Check In Date|Check Out Date -
AR Aging Breakdown & Total (Cols 12β18):
Current|31 to 60|61 to 90|91 to 120|121 to 150|Over 150|Amount
-
Report Toolbar & Quick Actions
Use the top-right toolbar icons on the report page to manage and export your data view:
|
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 Accounts Receivable Activity report features an interactive pie chart to help analyze aging ledger balances and transaction distributions. Aggregate ledger activity on the fly using the Group By feature. Group your data by Transaction Type, Date, or Transaction Status to evaluate ledger distribution in a structured summary table or switch instantly to an interactive Pie Chart visualization for executive presentation. By selecting a metric from the Select Base Column dropdown menuβsuch as Current, specific aging buckets (31 to 60, 61 to 90, Over 150), or total Amountβthe chart dynamically renders percentage share breakdowns alongside an interactive color-coded legend.
-
Bar Chart Visualizer: The Accounts Receivable Activity report includes a dynamic bar chart to help visualize outstanding ledger balances and aging distributions chronologically. By selecting options from the Select Column (Y-Axis) dropdown menu, users can switch the chart view to focus on total outstanding balances (Amount) or isolate specific aging buckets (Current, 31 to 60, 61 to 90, 91 to 120, 121 to 150, Over 150) alongside the detailed AR transaction table.
Advanced Controls
-
Exporting: Download in Excel or PDF format for offline distribution, audit prep, or executive presentation decks.
-
Filtering: Filter data by specific Company Name, Transaction Type, or Aging Bucket.
-
Highlighting (Conditional Formatting): Apply custom rules to automatically highlight overdue balances (>60 days) or high-value transactions.
π Related Reports & Next Steps
Within π¬ Billing & Receivables (AR):
-
AR Invoice Aging Report β Categorize outstanding invoice balances based on days elapsed since generation.
-
Company Accounts Report β Review corporate profiles, credit limits, and B2B stay production.
-
Direct Bill Aging β Segment outstanding corporate balances across Accounts Receivable, Invoices, and Settlements.
-
Direct Bill Reconciliation Report β Identify payment gaps and verify guarantee statuses for corporate and group invoicing.
-
Invoice Details Report β Detailed lifecycle tracking of every generated invoice including settled vs. unsettled amounts.
Cross-Pillar Deep Dives:
-
βοΈ Ledgers & Trial Balance: To audit unbilled direct bill accounts against general ledger balances, review Direct Bill Ledger Details Report.
-
π³ Payments & Transactions: To inspect corporate settlements and payment processing history, cross-reference Payment Activity Report.
-
π Forward Revenue & Analytics: Looking for forward-facing revenue projections or macro performance metrics (like RevPAR or ADR)? Please visit the π Revenue & Analytics reporting hub.