Tax Report .ng | HotelKey Knowledge Base

Revision Date: 2026-08-03

A Tax Report is a comprehensive financial document generated by a business to summarise all taxable transactions, collected taxes (like Sales Tax, VAT, or GST), and tax exemptions over a specific period. Its primary purpose is to ensure regulatory compliance, support accurate tax filings, and provide a clear audit trail for government authorities.

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

Exempted Tax Details Section:

It breaks down every non-taxable transaction and its legal justification to prove to auditing authorities why tax was not collected.

Non Exempted Tax Details Section:

This report lists every transaction subject to standard taxation, breaking down the taxable revenue, the specific tax rates applied, and the actual tax amounts collected for government remittance.

Available Report Columns for above Sections:

Column Name	Column Description	Amount Includes Taxes and Fees	Calculation
Transaction Number	A unique system-generated identifier assigned to a specific financial entry or posting.	Not Applicable	Not Applicable
Folio Number	An internal account or bill number used to consolidate all charges incurred by a specific guest or room.	Not Applicable	Not Applicable
Transaction Type	The classification of the financial entry, indicating whether it is a charge, payment, adjustment, or correction.	Not Applicable	Not Applicable
Room Number	The specific physical accommodation identifier assigned to the guest during their stay.	Not Applicable	Not Applicable
Guest Name	The full name of the registered guest as it appears on the primary account profile.	Not Applicable	Not Applicable
First Name	The individual given name of the guest for profile tracking and personalisation.	Not Applicable	Not Applicable
Last Name	The family name or surname of the registered guest.	Not Applicable	Not Applicable
Company Name	The corporate entity or business organisation associated with the booking and responsible for billing.	Not Applicable	Not Applicable
Last 4 Digits Credit Card Number	Showing only the first 4 digits of a guest's card used to identify stored card on file without exposing the full number.	Not Applicable	Not Applicable
Prefix of Credit Card Number	Showing only the last 4 digits of a guest's card used to identify stored card on file without exposing the full number.	Not Applicable	Not Applicable
Number of Nights	The total duration of the guest's stay calculated by overnight intervals.	Not Applicable	Not Applicable
Number of Guests	The total combined count of all individuals staying in the assigned room.	Not Applicable	Not Applicable
Adults	The total number of mature or age-qualified guests registered to the room for occupancy and rate calculations.	Not Applicable	Not Applicable
Children	The total number of minor or underage guests registered to the room, often subject to different rate tiers.	Not Applicable	Not Applicable
Room Rate	The base cost charged per night for the physical lodging accommodation, excluding taxes and fees.	Not Applicable	Not Applicable
Tax Exemption Category	The legal classification code explaining why a guest or company is waived from paying standard taxes.	Not Applicable	Not Applicable
Check In Date	The official calendar calendar day the guest arrives and takes possession of the room.	Not Applicable	Not Applicable
Check Out Date	The official calendar day the guest vacates the room and settles their final bill.	Not Applicable	Not Applicable
Exempted Revenue	The total sales income generated from the transaction that is legally protected from taxation.	Not Applicable	Not Applicable
Fiscal Invoice Number	A legally mandated, sequence-controlled receipt number required by government tax authorities for official reporting.	Not Applicable	Not Applicable
General VAT 7 PCT	A predefined tax code applying a 7% Value Added Tax rate to eligible charges (e.g., room, F&B) posted to the folio.	Not Applicable	Not Applicable
VAT 22 PCT MISC	The total monetary amount collected for a 22% Value Added Tax applied to miscellaneous goods or services.	Not Applicable	Not Applicable
TAX 2PTC	The monetary calculation for a localised 2% transaction tax applied to specific billable items.	Not Applicable	Not Applicable
CITY TAX 0.14	A flat municipal tax of 0.14 units charged per night or per transaction to support local infrastructure.	Not Applicable	Not Applicable
Food and Beverage Tax 19PCT	The specific 19% tax levied exclusively on food, drinks, and restaurant services consumed at the property.	Not Applicable	Not Applicable
Test Tax Type	A temporary tax category used in a staging environment to test system calculations before going live.	Not Applicable	Not Applicable
FRAIS Environmentaux/Service Charge Environment .	An environmental fee or eco-service charge levied to offset the property's carbon footprint and sustainability efforts.	Not Applicable	Not Applicable
City Tax for SE 5.875	A highly specific municipal tax rate of 5.875% or units applied based on a unique local jurisdiction or special economic zone.	Not Applicable	Not Applicable
VAT 10PCT	The total monetary amount collected for a standard 10% Value Added Tax on applicable hospitality services.	Not Applicable	Not Applicable
City Tax 0.18	A fixed local municipal fee of 0.18 units added to the bill to fund city tourism and public services.	Not Applicable	Not Applicable
GST 15 PCT	The total monetary amount collected for a 15% Goods and Services Tax mandated by national tax laws.	Not Applicable	Not Applicable
VAT 20	The total monetary amount collected for a standard 20% Value Added Tax applied to taxable items.	Not Applicable	Not Applicable
State Tax 225PCT	A specialised, high-percentage or specific sub-point state tax rate of 2.25% applied by regional government authorities.	Not Applicable	Not Applicable
Tax 3PTC	A duplicate or secondary 2% transaction tax entry used for a separate municipal or district billing tier.	Not Applicable	Not Applicable
Test	A generic placeholder or trial column used by system developers to check data flow and formatting.	Not Applicable	Not Applicable
VAT4	The total monetary amount collected for a specific Tier-4 or 4% Value Added Tax rate.	Not Applicable	Not Applicable

Charge Type Summary Section:

Available Report Columns for above section:

Column Name	Column Description	Amount Includes Taxes and Fees	Calculation
Charge Type Code	A unique tracking ID assigned to classify specific categories of revenue or transactions.	Not Applicable	Not Applicable
Total Amount	The gross sum of money for the transaction, including all base charges, fees, and applicable taxes.	Not Applicable	Not Applicable
Exempted Revenue For CITY TAX FOR SE 5.875	The portion of sales income legally spared from a specific 5.875% local or special economic zone city tax.	Not Applicable	Not Applicable
Non Exempted Revenue For CITY TAX FOR SE 5.875	The taxable portion of sales income that is fully subject to the 5.875% local city tax.	Not Applicable	Not Applicable
Exempted Revenue For CITY TAX 0.14	The total revenue amount explicitly waived from a flat 0.14-unit municipal tax.	Not Applicable	Not Applicable
Non Exempted Revenue For CITY TAX 0.14	The total revenue amount that remains fully billable under the flat 0.14-unit municipal tax.	Not Applicable	Not Applicable
Exempted Revenue For CITY TAX 0.18	The specific sales earnings legally protected from a flat 0.18-unit local tourism or city tax.	Not Applicable	Not Applicable
Non Exempted Revenue For CITY TAX 0.18	The specific sales earnings that must be taxed under the flat 0.18-unit local tourism or city tax.	Not Applicable	Not Applicable
Exempted Revenue For Food and Beverage Tax 19PCT	The dining or lounge sales volume processed without applying the standard 19% restaurant tax.	Not Applicable	Not Applicable
Non Exempted Revenue For Food and Beverage Tax 19PCT	The dining or lounge sales volume legally required to incur the standard 19% restaurant tax.	Not Applicable	Not Applicable
Exempted Revenue For GST 15PCT	The portion of sales income completely excused from a national 15% Goods and Services Tax.	Not Applicable	Not Applicable
Non Exempted Revenue For GST 15PCT	The portion of sales income that must have the national 15% Goods and Services Tax applied to it.	Not Applicable	Not Applicable
Exempted Revenue For State Tax 225PCT	The revenue completely protected from a specialised regional or state tax rate of 2.25%.	Not Applicable	Not Applicable
Non Exempted Revenue For State Tax 225PCT	The revenue subject to standard regional calculations for the 2.25% state tax rate.	Not Applicable	Not Applicable
Exempted Revenue For Tax 2PTC	The sales figures processed free from a localized 2% transaction tax tier.	Not Applicable	Not Applicable
Non Exempted Revenue For Tax 2PTC	The sales figures required by law to pay into the localized 2% transaction tax tier.	Not Applicable	Not Applicable
Exempted Revenue For Tax 3PTC	The transaction balances shielded from a localized 3% transaction or district tax.	Not Applicable	Not Applicable
Non Exempted Revenue For Tax 3PTC	The transaction balances that are legally subject to the localized 3% transaction or district tax.	Not Applicable	Not Applicable
Exempted Revenue For TEST	The transactional data bypass value used in a test environment to verify system-wide tax-exemption logic.	Not Applicable	Not Applicable
Non Exempted Revenue For TEST	The transactional data trial value used in a test environment to verify system-wide active tax logic.	Not Applicable	Not Applicable
Exempted Revenue For Test Tax Type	The test-environment revenue threshold processed without mock taxes to evaluate configuration stability.	Not Applicable	Not Applicable
Non Exempted Revenue For Test Tax Type	The test-environment revenue threshold subjected to mock taxes to evaluate configuration stability.	Not Applicable	Not Applicable
Exempted Revenue For VAT 10 PCT	Hospitality or service sales completely excluded from a standard 10% Value Added Tax.	Not Applicable	Not Applicable
Non Exempted Revenue For VAT 10 PCT	Hospitality or service sales actively taxed at the standard 10% Value Added Tax rate.	Not Applicable	Not Applicable
Exempted Revenue For VAT 20	The sales values entirely protected from a standard 20% Value Added Tax calculation.	Not Applicable	Not Applicable
Non Exempted Revenue For VAT 20	The sales values fully subject to calculation under the standard 20% Value Added Tax rate.	Not Applicable	Not Applicable
Exempted Revenue For VAT 22 PCT MISC	The miscellaneous or retail sales income processed with a waiver for the 22% Value Added Tax.	Not Applicable	Not Applicable
Non Exempted Revenue For VAT 22 PCT MISC	The miscellaneous or retail sales income that must carry the standard 22% Value Added Tax.	Not Applicable	Not Applicable
Exempted Revenue For VAT 4	The specific service or goods sales explicitly shielded from a lower-tier 4% Value Added Tax.	Not Applicable	Not Applicable
Non Exempted Revenue For VAT 4	The specific service or goods sales that are legally bound to pay the lower-tier 4% Value Added Tax.	Not Applicable	Not Applicable
Exempted Revenue For frais environnementaux / Service charge Environment	The portion of revenue excused from a local environmental surcharge or eco-service fee.	Not Applicable	Not Applicable
Non Exempted Revenue For frais environnementaux / Service charge Environment	The portion of revenue that must include the mandatory local environmental surcharge or eco-service fee.	Not Applicable	Not Applicable
Non-Taxable Amount	The overall base total of items or services on the bill that are inherently exempt from any tax whatsoever.	Not Applicable	Not Applicable

Summary Section:

Available Report Columns for above section:

Column Name	Column Description	Amount Includes Taxes and Fees	Calculation
Tax Name	The specific descriptive title or authority designation assigned to a particular tax category (e.g., VAT, GST, or City Tax).	Not Applicable	Not Applicable
Total Revenue	The gross financial earnings generated by the business before any tax exemptions or deductions are computed.	Not Applicable	Not Applicable
Exempted Revenue	The portion of total sales income that is legally shielded or excluded from having any taxes applied to it.	Not Applicable	Not Applicable
Taxable Payable	The net revenue amount that remains fully subject to taxation after subtracting all legal exemptions.	Not Applicable	Not Applicable
Payable Tax	The final monetary amount of tax collected or owed that must be remitted directly to the government tax authority.	Not Applicable	Not Applicable
Exempted Tax	The calculated monetary amount of tax that would have been collected if the exempt revenue had been subject to standard taxation.	Not Applicable	Not Applicable

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.
Bar Graph: ability to view Revenue and Stay data in a bar chart.
Grouping: ability to view the data grouped by: All, Market Segment, Day of Week_Market Segment
Pie Chart: ability to view grouped data in a Pie Chart view.

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