Accounts Receivable Activity .ng

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.

Image 9-29-26 at 1.01β€―PM.png
Accounts Receivable Activity Report

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.

SUM(Aging Buckets)

🟒 Yes

Check In Date

Arrival date associated with the reservation.

Reservation > Check In Date

N/A

Check Out Date

Departure date associated with the reservation.

Reservation > Check Out Date

N/A

Company Code

Unique identifier code assigned to the company.

Company Profile > Code

N/A

Company Name

Full name of the contracted corporate account.

Company Profile > Name

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.

Guest Profile > First Name

N/A

Last Name

Last name of the primary guest.

Guest Profile > Last Name

N/A

Name

Full guest or account primary contact name.

Guest Profile / Account 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.

Folio Confirmation Number

N/A

Transaction Status

Status of the record (CHECKED OUT, OPEN, NONE).

Reservation / Account State

N/A

Transaction Type

Source classification (RESERVATION, HOUSE ACCOUNT, MANUAL AR).

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:

Image 9-29-26 at 12.37β€―PM.png

Saved Views

Saves your column filtering, sorting, and highlight preferences so you can easily reload your custom view later without reconfiguring the report.

Image 9-29-26 at 12.51β€―PM.png

Bar Chart

Displays report data in a visual bar chart format.

Image 9-29-26 at 12.39β€―PM.png

Filter

Opens filter controls to isolate specific data within a column based on your selected criteria.

Image 9-29-26 at 12.40β€―PM.png

Highlight

Highlights column values in a designated color based on selected conditions.

Image 9-29-26 at 12.42β€―PM.png

Export

Exports and downloads the report in various formats (Excel, PDF, CSV) for offline analysis or printing.

Image 9-29-26 at 12.43β€―PM.png

Configure

Opens column selection controls to toggle visibility, reorder columns, or hide rows with all zeros.

Image 9-29-26 at 12.44β€―PM.png


Additional Configuration

Provides advanced report configuration and display formatting options to customize data presentation.

Image 9-29-26 at 12.53β€―PM.png

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.

Image 8-5-26 at 6.21β€―PM.png
Group By & Pie Chart Visualization
  • 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.

Image 8-5-26 at 6.24β€―PM.png
Bar Chart Visualizer

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.

Within πŸ“¬ Billing & Receivables (AR):

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.