Invoice Details .ng

Column Name

Column Description

Amount Includes Taxes and Fees

Calculation

Company Name

The name of the corporate account or travel agency responsible for the invoice balance

Not Applicable

Not Applicable

Invoice Date

The calendar date when the bill was transferred out of the guest folio and officially generated as a corporate invoice.

Not Applicable

Not Applicable

Invoice Age

The total number of days that have passed since the invoice was generated, indicating how long the bill has remained unpaid.

Not Applicable

Not Applicable

First Name

Primary guest first name

Not Applicable

Not Applicable

Last Name

Primary guest last name

Not Applicable

Not Applicable

Invoice Number

A unique, system-generated numerical tracking sequence used to permanently identify that specific corporate billing document.

Not Applicable

Not Applicable

Due Date

The contractually agreed-upon deadline date by which the company must submit payment to settle the invoice balance.

Not Applicable

Not Applicable

Invoice Status

The current state of the bill in the accounting lifecycle, indicating whether it is active and outstanding (OPEN) or finalized and paid (CLOSED).

Not Applicable

Not Applicable

Confirmation  No

The unique confirmation number tied to the guest's specific reservation in the system.

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

The total sum of all financial credits, advance deposits, or partial payments received and applied toward this specific invoice.

YES

=sum(AR transactions)

Settled Amount

The total portion of the invoice balance that has been successfully cleared and reconciled through accounting payment matches.

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 (parking, wifi, etc.)

NO

=sum(other charges)

Other Taxes

Taxes applied to additional charges

YES

=sum(other taxes)