Invoice Summary .ng
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