Accounting Setup Details Report Overview
Parent Hub: βοΈ System & Administration Reports
Category: π₯οΈ System Log Reports
Target Roles: Hotel Controllers, Directors of Finance, Income Auditors, System Administrators, Night Auditors, General Managers
Key Value: Complete configuration governance over property accounting master data, verifying charge type setup and transaction codes, auditing payment tender methods, reviewing tax and fee inclusive/exclusive rules, and ensuring general ledger and cost center interface alignment.
Date Parameter: Current Business Day Only (Dynamic Live Data)
Executive Summary
The Accounting Setup Details Report is an essential configuration baseline, chart of accounts auditing, and financial master data governance document within the π₯οΈ System Log Reports category of the βοΈ System & Administration Reports hub. Designed to maintain financial posting integrity across the property management system, it provides a comprehensive inventory of all revenue charge codes, expense postings, guest folio display labels, tax and fee calculation rules, payment settlement tenders, and back-office accounting mappings.
-
By organizing system financial parameters into 2 defined report sections: Charge Types and Payment Types, this report enables hotel controllers and system administrators to inspect posting logic for guest ledger debit items (
Charge Types) alongside cashiering settlement methods (Payment Types). It details property identifiers (Property Code), charge definitions (Charge Type Name,Charge Type Code,Charge Label,Status), operational and system categories (Charge Type Category,System Category), statutory compliance parameters (Tax Type,Fee Type,Tax Inclusive/Exclusive,Fee Inclusive/Exclusive), back-office general ledger mappings (Cost Center Code,GL Account Code,Project Code), payment tenders (Payment Type), and card brand associations (Card Type) to prevent misposted revenue and out-of-balance ledger exports.
Key Capabilities
-
Two-Section Financial Configuration Governance: Segregates transaction debit posting definitions (
Charge Types) from settlement credit tenders (Payment Types) into structured administrative views. -
Charge Code & Folio Label Auditing: Maps technical PMS transaction codes (
Charge Type Code) directly to internal accounting titles (Charge Type Name) and guest-facing folio display text (Charge Label). -
Multi-Level Financial Categorization: Verifies departmental revenue groupings (
Charge Type Category, e.g., Room Rent, Spa, Outlet, Laundry) against core architectural posting engines (System Category, e.g.,ROOM_RENT,FOOD,BEVERAGE,MISC_CHARGE,MISC_EXPENSE,NON_REVENUE,BAR). -
Tax & Surcharge Application Rules: Audits statutory tax mappings (
Tax Type, e.g., City Tax, State Tax) and fee triggers (Fee Type) alongside calculation modes (Tax Inclusive/Exclusive,Fee Inclusive/Exclusive) to ensure regulatory fiscal compliance. -
Payment Method & Card Brand Administration: Catalogs all accepted cashiering tenders (
Payment Type, e.g., Cash, Credit Card, Bill to Company, Check, Bank Transfer) and operational statuses (Status) in Section 2. -
ERP & General Ledger Interface Verification: Validates chart of accounts routing fields (
Cost Center Code,GL Account Code,Project Code) to guarantee seamless financial synchronization with external accounting ledgers.
Report Views & Functional Breakdown
The Accounting Setup Details Report presents financial master setup parameters across 2 defined sections:
ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
β ACCOUNTING SETUP DETAILS REPORT β
ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ€
β 2 Defined Report Sections β
ββββββββββββββββββββββββββββββββββββ¬ββββββββββββββββββββββββββββββββββββββ€
β 1. Charge Types β 2. Payment Types β
β (Revenue & Folio Postings) β (Tender & Settlement Methods) β
ββββββββββββββββββββββββββββββββββββ΄ββββββββββββββββββββββββββββββββββββββ
1. Charge Types Section (Revenue & Folio Postings)
Monitors every configured charge code utilized across front desk cashiering, point-of-sale interfaces, and night audit room postings.
-
Primary Use: Auditing active vs. inactive posting codes, verifying department and system category rollups, and checking tax and fee inclusion rules.
-
Key Metrics: Property Code, Charge Type Name, Charge Type Code, Charge Label, Status, Charge Type Category, System Category, Tax Type, Fee Type, Tax Inclusive/Exclusive, Fee Inclusive/Exclusive, Cost Center Code, GL Account Code, Project Code.
2. Payment Types Section (Tender & Settlement Methods)
Catalogs all settlement methods, electronic credit card configurations, house billing setups, and refund tenders available for cashiering transactions.
-
Primary Use: Verifying authorized cashiering tenders, auditing card brand mapping, and confirming settlement GL accounts for night audit cashier balancing.
-
Key Metrics: Property Code, Payment Type, Card Type, Cost Center Code, GL Account Code, Status.
Data Dictionary (Dynamic View Columns)
Customize your default view using the Configure (βοΈ) icon on the report page. Below is the full data dictionary representing all 16 exact dynamic columns available across the 2 report sections, sorted in alphabetical order by column name:
βΉοΈ Configuration Rule Logic: Fields in this report reflect core property accounting definitions. In Section 1,
Tax Inclusive/ExclusiveandFee Inclusive/Exclusivedefine whether taxes and surcharges are embedded in the menu/charge price (Inclusive) or dynamically calculated as secondary folio lines (Exclusive).
|
Column Name |
Section Applicability |
Description |
Data Source / System Mapping |
Includes Taxes & Fees? |
|
Card Type |
Section 2 |
Specific credit card network or payment card brand classification linked to the payment tender (e.g., |
Payment Gateway > Card Brand Code |
N/A |
|
Charge Label |
Section 1 |
Descriptive label or folio display name that appears on guest folios, invoices, and billing statements when the charge is posted. |
Financial Setup > Guest Folio Display Label |
N/A |
|
Charge Type Category |
Section 1 |
Operational department or revenue category grouping the charge type (e.g., |
Financial Setup > Department Category |
N/A |
|
Charge Type Code |
Section 1 |
Unique alphanumeric transaction code assigned to the charge type for posting and interface mapping (e.g., |
Financial Setup > Transaction Code |
N/A |
|
Charge Type Name |
Section 1 |
Official descriptive system title identifying the charge type within the accounting master setup. |
Financial Setup > Internal Charge Name |
N/A |
|
Cost Center Code |
Both Sections |
Internal financial accounting code identifying the specific cost center, operating department, or business unit responsible for the charge or payment. |
Accounting Setup > Cost Center ID |
N/A |
|
Fee Inclusive/Exclusive |
Section 1 |
Indicates whether applicable operational fees and surcharges are included within the base charge rate ( |
Fee Master > Calculation Method |
N/A |
|
Fee Type |
Section 1 |
Specific surcharge, facility fee, or administrative fee rule linked to and triggered by the charge type. |
Fee Master > Fee Classification Code |
N/A |
|
GL Account Code |
Both Sections |
General ledger account code assigned to map revenue or payment transactions directly into the back-office financial ledger and chart of accounts. |
Accounting Setup > General Ledger Account |
N/A |
|
Payment Type |
Section 2 |
Tender method or financial settlement classification configured for cashiering and billing settlement (e.g., |
Cashiering Setup > Payment Tender Code |
N/A |
|
Project Code |
Section 1 |
Internal project, capital expenditure, or promotional accounting code assigned to track specific business initiative transactions. |
Accounting Setup > Project Accounting Code |
N/A |
|
Property Code |
Both Sections |
Unique property identifier or short PMS code for the hotel location (e.g., |
Property Master > Property Code |
N/A |
|
Status |
Both Sections |
Operational configuration state of the charge type or payment method ( |
System Setup > Configuration State |
N/A |
|
System Category |
Section 1 |
Core PMS system-level financial classification governing posting behavior, folio calculations, and reporting rollups (e.g., |
System Core > Financial Engine Category |
N/A |
|
Tax Inclusive/Exclusive |
Section 1 |
Indicates whether sales taxes, VAT, or local occupancy taxes are included within the posted charge amount ( |
Tax Master > Tax Application Rule |
N/A |
|
Tax Type |
Section 1 |
Tax rule or tax authority schedule applied to the charge type (e.g., |
Tax Master > Tax Rule Code |
N/A |
Customization & Platform Features
User & Property Preferences
-
Personal Preference: Tailor your individual view by hiding or dragging columns. Your preferences save automatically for future sessions.
-
Property Defaults: System Admins can configure standard default layouts across all property users to streamline operational reporting. To maximize audit efficiency, group the columns into the below logical blocks:
-
Section 1: Charge Types
-
Property Context & Charge Master Identifiers (Cols 1β3):
Property Code|Charge Type Name|Charge Type Code -
Display Label & Operational Lifecycle State (Cols 4β5):
Charge Label|Status -
Revenue Classification & Category Hierarchy (Cols 6β7):
System Category|Charge Type Category -
Tax & Fee Configuration Rules (Cols 8β11):
Tax Type|Tax Inclusive/Exclusive|Fee Type|Fee Inclusive/Exclusive -
Financial & General Ledger Accounting Distribution (Cols 12β14):
Cost Center Code|GL Account Code|Project Code
-
-
Section 2: Payment Types
-
Property Context & Tender Identifiers (Cols 1β3):
Property Code|Payment Type|Card Type -
Operational Lifecycle State (Col 4):
Status -
Financial & General Ledger Accounting Distribution (Cols 5β6):
Cost Center Code|GL Account Code
-
-
Report Toolbar & Quick Actions
Use the top-right toolbar icons on the report page to manage and export your data view:
|
Icon |
Action / Feature |
Description |
|
Knowledge Article |
Opens the knowledge base article to learn how to interpret this report. |
|
Saved Views |
Saves your column filtering, sorting, and highlight preferences so you can easily reload your custom view later without reconfiguring the report. |
|
Filter |
Opens filter controls to isolate specific data within a column based on your selected criteria. |
|
Highlight |
Highlights column values in a designated color based on selected conditions. |
|
Export |
Exports and downloads the report in various formats (Excel, PDF, CSV) for offline analysis or printing. |
|
Configure |
Opens column selection controls to toggle visibility, reorder columns, or hide rows with all zeros. |
|
Additional Configuration |
Provides advanced report configuration and display formatting options to customize data presentation. |
Advanced Controls
-
Chart of Accounts Gap Analysis: Filter Section 1 for blank
GL Account CodeorCost Center Codefields to identify newly created transaction codes that lack general ledger interface routing before month-end financial close. -
Tax Configuration Auditing: Filter Section 1 by
Tax TypeandTax Inclusive/Exclusiveto ensure room packages, F&B outlets, and retail items apply the correct local municipal occupancy and state sales tax schedules. -
Highlighting (Conditional Formatting): Apply custom rules to automatically highlight inactive codes (
Status = Inactive), unassigned GL accounts, or active payment tenders with unmapped card types.
π Related Reports & Next Steps
Within βοΈ System & Administration Reports & π₯οΈ System Log Reports:
-
Operator Security Report β Comprehensive user access control audit tracking user roles, permission templates, and profile statuses.
-
User Activity Report β Reservation modification audit log tracking room moves, charge adjustments, and cancellations.
Cross-Pillar Deep Dives:
-
π³ Financial & General Ledger: Reconcile transaction posting codes (
Charge Type Code) with Revenue Activity Report and Trial Balance Report, to ensure folio charges post to the correct chart of accounts. -
π€ User Activity Reports: Cross-reference active payment tenders (
Payment Type) with Clerk Shift Report and Clerk Activity Report to verify tender balancing across front desk shift drops.