Accounting Setup Details .ng

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.

charge types.png
Charge Types Section
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.

Payment Types.png
Payment Types Section

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/Exclusive and Fee Inclusive/Exclusive define 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., VISA, MASTER, AMEX, DISCOVER, JCB).

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., ROOM RENT, SPA, IN ROOM DINING 1, OUTLET 1, LAUNDRY, STAY, STATISTICS).

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., CPPRR, 3842, 1212, 15350).

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 (Inclusive) or posted as separate line items (Exclusive).

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., CASH, CREDIT CARD, BILL TO COMPANY, CHECK, Bank Transfer).

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., HTLKY).

Property Master > Property Code

N/A

Status

Both Sections

Operational configuration state of the charge type or payment method (Active or Inactive).

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., ROOM_RENT, FOOD, BEVERAGE, MISC_CHARGE, MISC_EXPENSE, NON_REVENUE, BAR, LAUNDRY).

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 (Inclusive) or calculated and added as separate tax line items (Exclusive).

Tax Master > Tax Application Rule

N/A

Tax Type

Section 1

Tax rule or tax authority schedule applied to the charge type (e.g., CITY TAX, STATE TAX, VAT).

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

Image 9-29-26 at 1.04β€―PM.png

Knowledge Article

Opens the knowledge base article to learn how to interpret this report.

Image 9-29-26 at 12.37β€―PM.png

Saved Views

Saves your column filtering, sorting, and highlight preferences so you can easily reload your custom view later without reconfiguring the report.

Image 9-29-26 at 12.39β€―PM.png

Filter

Opens filter controls to isolate specific data within a column based on your selected criteria.

Image 9-29-26 at 12.40β€―PM.png

Highlight

Highlights column values in a designated color based on selected conditions.

Image 9-29-26 at 12.42β€―PM.png

Export

Exports and downloads the report in various formats (Excel, PDF, CSV) for offline analysis or printing.

Image 9-29-26 at 12.43β€―PM.png

Configure

Opens column selection controls to toggle visibility, reorder columns, or hide rows with all zeros.

Image 9-29-26 at 12.44β€―PM.png

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 Code or Cost Center Code fields 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 Type and Tax Inclusive/Exclusive to 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.

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: