AR Invoice Aging Report Overview
Parent Hub: π° Finance & Accounting Reports
Category: π¬ Billing & Receivables (AR)
Target Roles: Accounts Receivable Managers, Hotel Controllers, Credit Managers, Staff Accountants, Directors of Finance, General Managers
Key Value: Monitor outstanding accounts receivable receivables, audit aged direct bill invoices across standard aging buckets (Current through Over 150 Days), track unbilled charges versus billed balances, enforce corporate credit limits, and reconcile company payments on account.
Date Parameter: Single Date Selector | Past & Future (Historical Cutoff As Of Date)
Executive Summary
The AR Invoice Aging report is the core financial control, credit risk assessment, and collections management document within the π¬ Billing & Receivables (AR) category of the π° Finance & Accounting Reports hub. Designed to maintain direct bill ledger integrity and optimize operating cash flow, it delivers comprehensive aging intelligence on all outstanding corporate accounts, direct billing lines, unbilled guest folios, and unapplied payments on account as of an exact operational cutoff date.
-
Structured across 3 defined report sections: AR Aging Details, AR Aging Summary, and AR Aging Account Type Summary, this report establishes complete traceability from macro-level corporate credit exposures down to individual transaction lines. It correlates corporate account profiles (
Company Name,Company Code,Account Type,Company Status) and guest stay contexts (First Name,Last Name,Room Number,Folio No) with official tax and billing identifiers (AR Invoice Number,FD Tax Invoice Number,Fiscal Invoice Number,PO Number,Transaction Number), chronological age indicators (Date,Aging Days), credit limit governance (Credit Limit,Available Credit Limit), and standardized 30-day discrete aging brackets (Current,31 to 60,61 to 90,91 to 120,121 to 150,Over 150) alongside cumulative delinquency thresholds (Over 30,Over 60,Over 90,Over 120 Days).
Key Capabilities
-
Three-Tier Multi-Section Aging Architecture: Seamlessly connects individual guest room direct bill folio charges (
AR Aging Details) to account-level balance sheets (AR Aging Summary) and portfolio-wide classification totals (AR Aging Account Type Summary). -
Granular 30-Day Aging Distribution: Allocates outstanding receivable balances into standardized buckets (
Current,31 to 60,61 to 90,91 to 120,121 to 150,Over 150) based on elapsed operational days (Aging Days). -
Cumulative Delinquency Analysis: Summarizes escalating collection exposure across cumulative delinquency milestones (
Over 30,Over 60,Over 90,Over 120 Days) in Sections 2 and 3 to support targeted dunning workflows. -
Unbilled Direct Bill Segregation: Tracks direct-billed transfers still awaiting formal invoice generation (
Total UnbilledandBilling Status = Unbilled) versus finalized billings (Billing Status = Billed) to prevent delayed corporate statement delivery. -
Credit Limit & Unapplied Cash Auditing: Reconciles authorized spending caps (
Credit Limit,Available Credit Limit) and unallocated corporate deposits or prepayments (Payment On Account) to prevent unauthorized credit extension.
Report Views & Functional Breakdown
The AR Invoice Aging report presents accounts receivable data across 3 defined sections:
ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
β AR INVOICE AGING REPORT β
ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ€
β 3 Defined Report Sections β
ββββββββββββββββββββββββββββββββββββ¬ββββββββββββββββββββββββββββββββββββββ€
β 1. AR Aging Details β 2. AR Aging Summary β
β (Transaction & Folio Lines) β (Company-Level Ledger Balances) β
ββββββββββββββββββββββββββββββββββββ΄ββββββββββββββββββββββββββββββββββββββ€
β 3. AR Aging Account Type Summary (Portfolio & Account Category Totals) β
ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
1. AR Aging Details Section (Transaction & Folio Line Items)
Itemizes every individual debit charge, credit adjustment, unapplied payment, and folio transfer linked to direct bill corporate accounts.
-
Primary Use: Investigating disputed line items, auditing specific guest folios transferred to city ledger, verifying purchase order numbers (
PO Number), and auditing clerk billing entries. -
Key Metrics: Account Type, Company Name, Company Code, Company Address, Date, AR Invoice Number, FD Tax Invoice Number, Fiscal Invoice Number, PO Number, Payment On Account, Current, 31 to 60, 61 to 90, 91 to 120, 121 to 150, Over 150, Total, Aging Days, Credit Limit, Available Credit Limit, Transaction Type, Transaction Number, Transaction Description, First Name, Last Name, Room Number, Folio No, Company Status, Billing Status, Invoice Status, Username.
2. AR Aging Summary Section (Company-Level Ledger Balances)
Aggregates receivables into a consolidated single-line summary for each active direct bill corporate client.
-
Primary Use: Evaluating corporate client credit exposure, monitoring unbilled balances (
Total Unbilled), tracking cumulative delinquency (Over 30throughOver 120 Days), and managing collections calls. -
Key Metrics: Account Type, Company Name, Company Code, Company Address, Payment On Account, Current, 31 to 60, 61 to 90, 91 to 120, 121 to 150, Over 150, Total, Total Unbilled, Credit Limit, Available Credit Limit, Over 30, Over 60, Over 90, Over 120 Days.
3. AR Aging Account Type Summary Section (Portfolio & Category Totals)
Rolls up aging totals across broad accounts receivable account classifications and master portfolio groups.
-
Primary Use: Providing executive management and controllers with high-level aging distributions for balance sheet reviews, allowance for doubtful accounts estimations, and bad debt provisioning.
-
Key Metrics: Account Type, Payment On Account, Current, 31 to 60, 61 to 90, 91 to 120, 121 to 150, Over 150, Total, Credit Limit, Available Credit Limit, Over 30, Over 60, Over 90, Over 120 Days.
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 three report sections, sorted in alphabetical order by column name:
π° Financial Posting & Aging Logic:
Aging Days Calculation: Derived as Report As-Of Date - Transaction Date. Balances are placed into discrete brackets:
Current(0-30 days),31 to 60,61 to 90,91 to 120,121 to 150, andOver 150.Cumulative Aging Formulas: In Section 2, cumulative brackets represent rolling sums:
Over 30 = (31 to 60) + (61 to 90) + (91 to 120) + (121 to 150) + Over 150
Over 60 = (61 to 90) + (91 to 120) + (121 to 150) + Over 150
Over 90 = (91 to 120) + (121 to 150) + Over 150
Over 120 Days = (121 to 150) + Over 150}
Total Balance Due: In all sections, net exposure reflects: Total = Payment On Account + Current} + Over 30 (where
Payment On Accountis a negative credit figure).Section Balancing Parity: The grand total in Section 2 equals the portfolio grand total in Section 3.
|
Column Name |
Section Applicability |
Description |
Data Source / System Mapping |
Includes Taxes & Fees? |
|
121 to 150 |
All Sections |
Receivable balance aged between 121 and 150 calendar days from the invoice or transaction posting date. |
City Ledger > Aging (121-150d) |
Yes |
|
31 to 60 |
All Sections |
Receivable balance aged between 31 and 60 calendar days from the invoice or transaction posting date. |
City Ledger > Aging (31-60d) |
Yes |
|
61 to 90 |
All Sections |
Receivable balance aged between 61 and 90 calendar days from the invoice or transaction posting date. |
City Ledger > Aging (61-90d) |
Yes |
|
91 to 120 |
All Sections |
Receivable balance aged between 91 and 120 calendar days from the invoice or transaction posting date. |
City Ledger > Aging (91-120d) |
Yes |
|
Account Type |
All Sections |
Operational classification assigned to the corporate debtor profile (e.g., |
Company Master > Account Category |
N/A |
|
Aging Days |
Section 1 |
Number of elapsed calendar days from the transaction posting or invoice date to the report as-of date. |
Calculated: $\text{As-Of Date} - \text{Posting Date}$ |
N/A |
|
AR Invoice Number |
Section 1 |
Unique master system accounts receivable invoice number assigned to the direct billing statement. |
AR Billing Engine > Master Invoice ID |
N/A |
|
Available Credit Limit |
All Sections |
Remaining credit line available for the company profile ($\text{Credit Limit} - Total Outstanding Balance). |
Company Credit Master > Unused Credit |
Yes |
|
Billing Status |
Section 1 |
Current billing lifecycle state of the direct bill transaction (e.g., |
AR Invoicing Engine > Billing Stage |
N/A |
|
Company Address |
Sections 1, 2 |
Registered physical street address or billing location of the corporate debtor entity. |
Company Master > Billing Address |
N/A |
|
Company Code |
Sections 1, 2 |
Unique corporate alphanumeric identifier or city ledger account code assigned to the company profile (e.g., |
Company Master > Account Code |
N/A |
|
Company Name |
Sections 1, 2 |
Official registered commercial trade name, corporate billing account, or agency title. |
Company Master > Legal Company Name |
N/A |
|
Company Status |
Section 1 |
Operational lifecycle state of the company profile in the property management system (e.g., |
Company Master > Account Status |
N/A |
|
Credit Limit |
All Sections |
Maximum authorized direct billing credit ceiling established for the corporate account. |
Company Credit Master > Authorized Cap |
Yes |
|
Current |
All Sections |
Outstanding direct bill balance aged within the current active billing window (0 to 30 days). |
City Ledger > Aging (0-30d) |
Yes |
|
Date |
Section 1 |
Calendar date on which the charge, invoice, or payment transaction was posted to the accounts receivable ledger. |
City Ledger > Posting Date |
N/A |
|
FD Tax Invoice Number |
Section 1 |
Sequential front desk tax invoice number generated at checkout and linked to the direct bill transaction. |
Front Desk Cashiering > Tax Invoice Ref |
N/A |
|
First Name |
Section 1 |
First name of the primary registered guest associated with the direct-billed reservation folio. |
Guest Profile > First Name |
N/A |
|
Fiscal Invoice Number |
Section 1 |
Official fiscal sequential invoice reference attached to the transaction record for statutory and fiscal compliance. |
Fiscal Engine > Fiscal Reference |
N/A |
|
Folio No |
Section 1 |
Internal folio sequence identifier representing the specific guest folio routed to direct bill. |
Folio Subledger > Folio Sequence ID |
N/A |
|
Invoice Status |
Section 1 |
Settlement state of the invoiced charge (e.g., |
AR Invoicing Engine > Invoice Status |
N/A |
|
Last Name |
Section 1 |
Last name (surname) of the primary registered guest associated with the direct-billed reservation folio. |
Guest Profile > Last Name |
N/A |
|
Over 120 Days |
Section 2 |
Cumulative receivable balance aged beyond 120 calendar days (121 to 150 + Over 150). |
Calculated: Rolling Aging (>120d) |
Yes |
|
Over 150 |
All Sections |
Severely delinquent direct bill receivable balance aged beyond 150 calendar days from the transaction date. |
City Ledger > Aging (>150d) |
Yes |
|
Over 30 |
Section 2 |
Cumulative receivable balance outstanding and overdue beyond 30 calendar days (Brackets > 30\d). |
Calculated: Rolling Aging (>30d) |
Yes |
|
Over 60 |
Section 2 |
Cumulative receivable balance outstanding and overdue beyond 60 calendar days (Brackets > 60). |
Calculated: Rolling Aging (>60d) |
Yes |
|
Over 90 |
Section 2 |
Cumulative receivable balance outstanding and overdue beyond 90 calendar days (Brackets > 90). |
Calculated: Rolling Aging (>90d) |
Yes |
|
Payment On Account |
All Sections |
Unallocated customer payments, advance deposits, or unapplied credit settlements posted directly to the corporate account balance. |
AR Cashiering > Unapplied Cash |
Yes |
|
PO Number |
Section 1 |
Customer purchase order number or client billing authorization reference code. |
Folio Billing Setup > PO / Voucher Ref |
N/A |
|
Room Number |
Section 1 |
Physical guest room number assigned to the reservation corresponding to the direct-billed charge. |
Room Inventory Master > Assigned Room |
N/A |
|
Total |
All Sections |
Net outstanding accounts receivable balance reflecting the sum of discrete aging intervals less payments on account. |
Calculated: Net Customer Liability |
Yes |
|
Total Unbilled |
Section 2 |
Cumulative monetary value of guest checkout folio charges routed to direct bill that have not yet been finalized into master invoices. |
Folio Subledger > Unbilled Direct Bill |
Yes |
|
Transaction Description |
Section 1 |
Descriptive narrative or line-item remarks detailing the transaction (e.g., payment tender method such as |
City Ledger > Transaction Description |
N/A |
|
Transaction Number |
Section 1 |
Unique system PMS transaction identifier or internal folio line sequence reference. |
Financial Audit Trail > Transaction ID |
N/A |
|
Transaction Type |
Section 1 |
Classification of the accounts receivable ledger entry (e.g., |
City Ledger > Entry Classification |
N/A |
|
Username |
Section 1 |
System login credential or user identifier of the operator who processed or authorized the direct bill transaction. |
Security / User Directory > User ID |
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:
-
Section 1: AR Aging Details
-
Company & Account Context (Cols 1β7):
Company Code|Company Name|Account Type|Company Status|Company Address|Credit Limit|Available Credit Limit -
Invoice & Transaction Identifiers (Cols 8β18):
Date|AR Invoice Number|Fiscal Invoice Number|FD Tax Invoice Number|PO Number|Folio No|Transaction Number|Transaction Type|Billing Status|Invoice Status|Aging Days -
Guest & Stay Details (Cols 19β22):
First Name|Last Name|Room Number|Transaction Description -
Financial Aging Breakdown & Balances (Cols 23β30):
Payment On Account|Current|31 to 60|61 to 90|91 to 120|121 to 150|Over 150|Total|Username
-
-
Section 2: AR Aging Summary
-
Company & Credit Context (Cols 1β6):
Company Code|Company Name|Account Type|Company Address|Credit Limit|Available Credit Limit -
Financial Aging Breakdown & Totals (Cols 7β19):
Payment On Account|Current|31 to 60|61 to 90|91 to 120|121 to 150|Over 150|Over 30|Over 60|Over 90|Over 120 Days|Total Unbilled|Total
-
-
Section 3: AR Aging Account Type Summary
-
Account Classification & Credit Facility (Cols 1β3):
Account Type|Credit Limit|Available Credit Limit -
Aggregate Portfolio Aging & Balances (Cols 4β15):
Payment On Account|Current|31 to 60|61 to 90|91 to 120|121 to 150|Over 150|Over 30|Over 60|Over 90|Over 120 Days|Total
-
-
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. |
|
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 AR Invoice Aging report features an interactive pie chart to help analyze aging invoice distributions across corporate accounts. Aggregate receivables on the fly using the Group By feature. Group your data by Company Name, Transaction Type, Date, or Transaction Status to review high-level summaries alongside detailed line items. By selecting a metric from the Select Base Column dropdown menuβsuch as Payment On Account, total Total balances, or specific aging brackets (Current, 31 to 60, Over 150)βthe chart dynamically renders percentage share breakdowns accompanied by an interactive color-coded legend across all report sub-tabs.
-
Bar Chart Visualizer: The AR Invoice Aging report includes a customizable bar chart to help visualize outstanding invoice balances and aging exposure chronologically. By selecting options from the Select Column (Y-Axis) dropdown menu, users can switch the chart view to display net balance totals (Total), unallocated payments (Payment On Account), or specific aging brackets (Current, 31 to 60, 61 to 90, 91 to 120, 121 to 150, Over 150) alongside the detailed transaction table across the AR Aging Details, AR Aging Summary, and AR Aging Account Type Summary sub-tabs.
Advanced Controls
-
Exporting: Download reports in Excel or PDF format for offline distribution, collection packets, or audit reviews.
-
Filtering: Filter data by specific Company Name, Billing Status (
Billedvs.Unbilled), or Invoice Status (OPEN,VOID). -
Highlighting (Conditional Formatting): Apply custom rules to automatically highlight accounts approaching their credit limit threshold or overdue balances exceeding 60 days.
π Related Reports & Next Steps
Within π¬ Billing & Receivables (AR):
-
Accounts Receivable Activity Report β Audit every detailed line-item transaction hitting the AR ledger.
-
Company Accounts Report β Evaluate corporate profiles, assigned direct-bill privileges, and overall stay production.
-
Direct Bill Aging Report β Segment outstanding corporate debt across Accounts Receivable, Invoices, and Settlements.
-
Direct Bill Reconciliation Report β Identify payment gaps, verify guarantee statuses, and finalize corporate direct bills.
-
Invoice Details Report β Analyze line-item invoice lifecycles including settled and unsettled amounts.
Cross-Pillar Deep Dives:
-
βοΈ Ledgers & Trial Balance: To reconcile city ledger balances against general ledger accounts, review Direct Bill Ledger Details Report.
-
π³ Payments & Transactions: To inspect corporate checks, credit card settlements, or client prepayments, 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.