Revised Date:
Invoice Summary
Report Description: The Invoice Summary Report provides a list of invoices and their statuses for a specified date range. It includes the company name, number of open and closed invoices, amounts for open and closed invoices, and the total invoice amount.
Date Range: Current day and up to 365 days in the past
Available Report Columns for Following Sections:
|
Column Name |
Column Description |
Amount Includes Taxes and Fees |
Calculation |
|
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 |
|
Status |
Current status of the company's invoices (e.g., Active, Closed, etc.) |
Not Applicable |
Not Applicable |
|
Open Invoices |
Number of invoices that are currently open and unpaid |
Not Applicable |
Open Invoices = (sum of open invoice |
|
Closed Invoices |
Number of invoices that have been fully settled and closed |
Not Applicable |
Closed Invoices = (sum of closed invoice |
|
Voided Invoices |
Number of invoices that have been voided or canceled |
Not Applicable |
Voided Invoices = (sum of voided invoice |
|
Total Invoices |
Total count of invoices generated for the company |
Not Applicable |
Total Invoices = (open invoice |
|
Total Open Invoice Amount |
Total amount due for all open invoices
*This is the original starting amount of the invoice. |
YES |
Total Open Invoice Amount = (sum of total amounts) |
|
Settled Invoice Amount |
Total amount paid on the company during a time period |
YES |
Settled Invoice Amount = (Settlements) for the company for the defined report period |
|
Balance Invoice Amount |
Open Invoice Balance |
YES |
Balance Invoice Amount = (sum of Invoiced Total Amount) - (sum of Invoice Settled Amount) |
|
Closed Invoice Amount |
Total amount paid for all closed invoices |
Not Applicable |
Closed Invoiced Amount = (sum of settlement amount) |
|
Voided Invoice Amount |
Total amount associated with voided invoices |
YES |
Voided Invoice Amount = (sum of total amount) |
|
Total Invoice Amount |
Overall sum of amounts across all invoices, irrespective of status |
YES |
Total Invoice Amount = (sum of open invoices amount) + (sum of closed invoices amount + sum of voided invoices amount) |
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.
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
-
-