Invoice Details .ng
Invoice Details
Report Description: The Invoice Details Report lists all invoice information for a specified date or date range. It includes invoice date, invoice number, status, confirmation number, guest name, billing date, payments, unsettled amounts, room revenue, taxes, and more.
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 |
Invoice Date | Date the invoice was generated | Not Applicable | Not Applicable |
Invoice Number | Unique identifier for each invoice | Not Applicable | Not Applicable |
Invoice Status | Current status of the invoice (e.g., pending, paid, etc.) | Not Applicable | Not Applicable |
Confirmation No | Reservation confirmation number linked to the invoice | Not Applicable | Not Applicable |
PO Number | Purchase order reference associated with the invoice | Not Applicable | Not Applicable |
Guest Name | Name of the primary guest associated with the invoice | Not Applicable | Not Applicable |
Billing Date | Date when the billing transaction was processed | Not Applicable | Not Applicable |
Total Payments | Total amount due on the invoice | YES | Total Payments = (AR transactions + manual AR) |
Settled Amount | Total amount already paid and settled on the invoice | Not Applicable | Settled Amount = (payments) |
Unsettled Amount | Remaining balance yet to be paid on the invoice | YES | Unsettled Amount = (total payments) - (settled amount) |
Last Settled Date | Date of the most recent payment settlement on the invoice | Not Applicable | Not Applicable |
Room Revenue | Total revenue generated from room charges | NO | Room Revenue = (sum of room revenue) |
Room Taxes | Taxes applied to room charges | YES | Room Taxes = (room taxes) |
Other Charges | Additional charges beyond room fees (ex: parking, wifi, etc.) | NO | Other Charges = (other charges) |
Other Taxes | Taxes applied to additional charges | YES | Other Taxes = (other taxes) |
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