Uninvoiced Transactions .ng | HotelKey Knowledge Base

Revised Date: 2026-07-02

Uninvoiced Transactions

Report Description: The Uninvoiced Transactions report provides a list of transactions that have not been billed, including confirmation number, folio number, guest name, stay, and rate details, aiding property managers in identifying un-billed charges. This report includes transaction data for House Accounts, Group Master, Room Summary, House Account Summary, Group Master Summary, Per Tax Code.

Date Range: This report can render the data for up to 30 days in the past

Common Available Report Columns for Following Sections:

Column Name	Column Description	Amount Includes Taxes and Fees	Calculation
Net Amount	Net amount of the transaction	Not Applicable	Not Applicable
General VAT 7 PCT	A standard 7% Value Added Tax typically applied to core hospitality services, such as lodging or specific reduced-rate goods.	Not Applicable	Not Applicable
HAMBURG City Tax	A localized municipal tax levied specifically by the city of Hamburg on overnight accommodation stays.	Not Applicable	Not Applicable
City Tax 2PCT	A flat 2% local municipal tax calculated based on the room rate or total accommodation revenue.	Not Applicable	Not Applicable
VAT 22 PCT Misc	A standard 22% Value Added Tax applied to miscellaneous hotel charges, premium goods, or ancillary services.	Not Applicable	Not Applicable
Tax 2PTC	A 2% tax configuration code (likely a typo for 2PCT) applied to designated transactional items on the ledger.	Not Applicable	Not Applicable
City Tax 0.14	A fixed municipal fee of 0.14 units (currency-based) charged per guest, per night, or per stay.	Not Applicable	Not Applicable
Food & Beverage Tax 19PCT	A standard 19% tax rate specifically designated for restaurant, bar, catering, and room service revenue.	Not Applicable	Not Applicable
Test Hamburg CT	A test environment or trial configuration code used to simulate and validate the Hamburg City Tax calculation before going live.	Not Applicable	Not Applicable
Test Tax Type	A placeholder or sandbox tax category used by system administrators to test posting rules without affecting active financial ledger categories.	Not Applicable	Not Applicable
Frais environnementaux / Service charge Environment	A local eco-fee or service charge levied on guests to offset the environmental impact and sustainability costs of their stay.	Not Applicable	Not Applicable
STATE TAX 8.875	A specific 8.875% state-level sales or lodging tax calculated on gross room revenue.	Not Applicable	Not Applicable
CITY TAX FOR SE 5.875	A dedicated 5.875% municipal or city-level tax applied to accommodation charges within a specific economic zone or region.	Not Applicable	Not Applicable
VAT 10 PCT	A standard 10% Value Added Tax applied to targeted hospitality services, such as reduced-rate lodging or dining.	Not Applicable	Not Applicable
STATE TAX 14.75	A premium 14.75% state-level hospitality or occupancy tax applied to overnight stays.	Not Applicable	Not Applicable
City tax 0.18	A fixed municipal fee of 0.18 units (currency-based) charged per guest or per night.	Not Applicable	Not Applicable
GST 15 PCT	A standard 15% Goods and Services Tax applied broadly to room rates and ancillary hotel purchases.	Not Applicable	Not Applicable
VAT 20	A standard 20% Value Added Tax applied to general goods, services, and miscellaneous property transactions.	Not Applicable	Not Applicable
State tax 225pct	A highly specific or unique 225% state tax rate configuration, typically used for specialized regulatory penalties, luxury items, or internal testing.	Not Applicable	Not Applicable
TAX 3PTC	A 3% tax configuration code (likely shorthand or a typo for 3PCT) applied to designated transactional items on the ledger.	Not Applicable	Not Applicable
Test	A generic sandbox or placeholder tax profile used by system administrators to run simulations without impacting live financial reporting.	Not Applicable	Not Applicable
Tax on Tax Text	A placeholder or system rule description used to test compounding tax logic, where a secondary tax is calculated on top of an initial tax amount.	Not Applicable	Not Applicable
VAT 4	A standard 4% Value Added Tax applied to reduced-rate goods or specific hospitality services.	Not Applicable	Not Applicable
Total Amount	Total amount of the transaction	YES	=sum(net amount) + (taxes)

Room Details Section:

Provides a list of un-invoiced transactions by room number with posting code and description.