Accounts Receivable Activity
Report Description: The Accounts Receivable Activity report provides real-time, up-to-date details on accounts receivable activity at the reservation level, offering the most current transaction information available.
Date Range: All open accounts receivable activity up to current business day
Available Report Columns for Following Sections:
|
Column Name |
Column Description |
Amount Includes Taxes and Fees |
Calculation |
|
Date |
Date of the transaction |
Not Applicable |
Not Applicable |
|
Company Name |
Local direct bill company name on the reservation |
Not Applicable |
Not Applicable |
|
Company Code |
Local direct bill company code (ex - 5010) |
Not Applicable |
Not Applicable |
|
Transaction Type |
Type of transaction posted (example - reservation, house account, manual AR, etc.) |
Not Applicable |
Not Applicable |
|
Transaction Number |
Confirmation number or house account number. |
Not Applicable |
Not Applicable |
|
Name |
Name of the house account or guest name on the reservation |
Not Applicable |
Not Applicable |
|
Current |
Current balance of uninvoiced transactions aged between 0 and 30 days in Accounts Receivable. |
YES |
current = (all charges + taxes) - (adjustments) |
|
31 to 60 |
Balance of un-invoiced transactions aged between 31 and 60 days in Accounts Receivable. |
YES |
31 to 60 = (all charges + taxes) - (adjustments) |
|
61 to 90 |
Balance of un-invoiced transactions aged between 61 and 90 days in Accounts Receivable. |
YES |
61 to 90 = (all charges + taxes) - (adjustments) |
|
91 to 120 |
Balance of un-invoiced transactions aged between 91 and 120 days in Accounts Receivable. |
YES |
91 to 120 = (all charges + taxes) - (adjustments) |
|
121 to 150 |
Balance of un-invoiced transactions aged between 121 and 150 days in Accounts Receivable. |
YES |
121 to 150 = (all charges + taxes) - (adjustments) |
|
Over 150 |
Balance of un-invoiced transactions aged between 121 and 150 days in Accounts Receivable. |
YES |
Over 150 = (all charges + taxes) - (adjustments) |
|
Transaction Status |
Transaction status of the reservation or House Account (ex: Checked Out, Closed, etc.) |
YES |
Not Applicable |
Misc Report Information:
Available Features:
-
Export: ability to download and save the file into an alternate format.
-
Filter: filter a range of data based on criteria defined by the user.
-
Highlight: also known as conditional formatting is the ability to highlight certain values making them easier to identify.
-
Bar Graph: ability to view data in a bar chart.
-
Grouping: ability to view the data grouped by: All, Transaction Type, Date, Transaction Status
-
Pie Chart: ability to view grouped data in a Pie Chart view.
Available Configuration:
-
User Preferences: allows the user to customize their report view by repositioning or removing columns.
-
Property Preferences: allows the property to customize the report view for all users by repositioning or removing columns.
Baseline Configuration:
-
Property Preferences Settings:
-
Following columns to be disabled for initial deployment:
-
Not Applicable
-
-