Accounts Receivable Activity .ng
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