Invoice Details .ng
Invoice Details
Report Description: The Invoice Details Report provides a list of invoice details for a defined date or period. Report includes invoice date, invoice number, status, confirmation number, guest name, billing date, payments, unsettled amount, room revenue, taxes, etc.
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 |
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 | =sum(AR transactions) |
Settled Amount | Total amount already paid and settled on the invoice | Not Applicable | =sum(payments) |
Unsettled Amount | Remaining balance yet to be paid on the invoice | YES | =sum(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 | =sum(room revenue) |
Room Taxes | Taxes applied to room charges | YES | =sum(room taxes) |
Other Charges | Additional charges beyond room fees | NO | =sum(other charges) |
Other Taxes | Taxes applied to additional charges | YES | =sum(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