Customer Statement Report Overview
Parent Hub: π° Finance & Accounting Reports
Category: π¬ Billing & Receivables (AR)
Target Roles: Accounts Receivable Managers, Credit Managers, Hotel Controllers, Staff Accountants, Billing Coordinators, Directors of Finance
Key Value: Client-facing accounts receivable statement delivery, auditing itemized customer invoice and payment transactions, tracking aged debt across standardized aging intervals (Current to Over 120 Days), verifying authorized credit limits and payment terms, and communicating official bank remittance instructions for electronic fund transfers.
Date Parameter: Single Date Selector | Past & Future (Statement As-Of Cutoff Date)
Executive Summary
The Customer Statement report is the authoritative client-facing financial summary, dunning instrument, and accounts receivable billing document within the π¬ Billing & Receivables (AR) category of the π° Finance & Accounting Reports hub. Generated for corporate clients, travel management companies, and direct billing accounts, it consolidates all open accounts receivable ledger activity into a formal, auditable commercial statement as of a designated cutoff date.
-
Structured across 3 defined report sections: Statement Details, Aging Summary, and Bank Details, this report provides complete financial clarity for both property controllers and client accounts payable teams. Preceded by an executive account profile header (
Customer Name,Customer Code,Customer Address,Company Contact,Contact Number,Contact Email,Approved Credit Limit,Currency,Payment Term), the report itemizes open invoices and unapplied payments (Statement Details), summarizes delinquency across 30-day discrete intervals (Aging Summary), and presents official depository routing credentials (Bank Details). This comprehensive layout streamlines invoice reconciliation, accelerates payment collections, substantiates disputed charges, and ensures electronic remittances route directly to verified hotel bank accounts.
Key Capabilities
-
Three-Section Statement Architecture: Combines itemized transaction lines (
Statement Details), consolidated delinquency totals (Aging Summary), and remittance wiring details (Bank Details) on a single professional client statement. -
Client Metadata & Profile Header: Displays master corporate billing information, approved credit capacity (
Approved Credit Limit), invoice settlement terms (Payment Term, e.g., Net 7, Net 30), and billing currency (Currency, e.g., USD). -
Itemized Ledger Transaction Auditing: Catalogs billed charges (
Transaction Type = Invoice) alongside credits and settlements (Transaction Type = Payment), displaying line-by-line monetary values (Total Amount). -
Comprehensive Statutory & Billing Identifiers: Tracks official billing keys across master city ledger invoices (
Invoice Number), front desk tax invoices (Tax Invoice Number), fiscal receipts (Fiscal Invoice Number), electronic e-invoices (E Invoice Number), customer purchase orders (PO Number), and client tracking references (Customer Reference Number). -
Discrete Aging Interval Summary: Allocates total customer debt into standardized delinquency brackets (
Current to 30,31 to 60,61 to 90,91 To 120,Over 120 Days) and calculates the exact gross balance due (Total Due). -
Official Depository & Remittance Instructions: Details the property's financial institution credentials (
Bank Name,Bank Identification Number,Bank Address,Account Name,Account Number,IBAN,swift code) to eliminate payment misdirection during wire and ACH settlements.
Report Views & Functional Breakdown
The Customer Statement report presents corporate accounts receivable data across 3 defined sections:
ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
β CUSTOMER STATEMENT REPORT β
ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ€
β 3 Defined Report Sections β
ββββββββββββββββββββββββββββββββββββ¬ββββββββββββββββββββββββββββββββββββββ€
β 1. Statement Details β 2. Aging Summary β
β (Itemized Invoices & Payments)β (Aged Delinquency & Total Due) β
ββββββββββββββββββββββββββββββββββββ΄ββββββββββββββββββββββββββββββββββββββ€
β 3. Bank Details (Depository Wiring & Remittance Instructions) β
ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
1. Statement Details Section (Itemized Invoices & Payments)
Itemizes all individual transactions posted to the client's city ledger account, linking master billing invoices with applied payments.
-
Primary Use: Providing the customer with an itemized transaction ledger, cross-referencing invoice numbers against purchase orders, and verifying guest stay dates.
-
Key Metrics: Date, Transaction Type, Invoice Number, Tax Invoice Number, Fiscal Invoice Number, E Invoice Number, PO Number, Customer Reference Number, Arrival Date, Departure Date, Number Of Nights, Transaction Number, Description, First Name, Last Name, Total Amount.
2. Aging Summary Section (Aged Delinquency & Total Due)
Consolidates the customer's total open debt into standardized 30-day aging buckets to highlight current vs. overdue obligations.
-
Primary Use: In-house credit control auditing and client notification of overdue balances beyond agreed payment terms.
-
Key Metrics: Credit Limit, Current to 30, 31 to 60, 61 to 90, 91 To 120, Over 120 Days, Total Due.
3. Bank Details Section (Depository Wiring & Remittance Instructions)
Presents the hotel property's official banking coordinates required for electronic funds transfers (EFT), Automated Clearing House (ACH) transactions, and international SWIFT wire settlements.
-
Primary Use: Facilitating prompt, secure electronic remittances by providing client AP departments with complete routing and depository credentials.
-
Key Metrics: Bank Name, Bank Identification Number, Bank Address, Account Name, Currency, Account Number, IBAN, swift code.
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 31 exact dynamic columns available across the 3 report sections, sorted in alphabetical order by column name:
π° Financial Posting & Statement Aging Logic:
Line-Item Posting: In Section 1, debit charges appear as positive amounts under
Total Amount, while client payments, credit memos, and refunds appear as negative amounts.Total Balance Due: Calculated in Section 2 as Total Due = Current to 30 + (31 to 60) +(61 to 90) + (91 To 120) + Over 120 Days.
Reconciliation Parity: The cumulative sum of line items in Section 1 (sum:Total Amount) equals the
Total Duepresented in Section 2.
|
Column Name |
Section Applicability |
Description |
Data Source / System Mapping |
Includes Taxes & Fees? |
|
31 to 60 |
Section 2 |
Receivable balance aged between 31 and 60 calendar days from the invoice or transaction date. |
City Ledger > Aging (31-60d) |
π’ Yes |
|
61 to 90 |
Section 2 |
Receivable balance aged between 61 and 90 calendar days from the invoice or transaction date. |
City Ledger > Aging (61-90d) |
π’ Yes |
|
91 To 120 |
Section 2 |
Receivable balance aged between 91 and 120 calendar days from the invoice or transaction date. |
City Ledger > Aging (91-120d) |
π’ Yes |
|
Account Name |
Section 3 |
Registered title or legal commercial name on the hotel property's remittance bank account. |
Property Banking Master > Account Title |
N/A |
|
Account Number |
Section 3 |
Bank account number designated for electronic customer payments, wire transfers, or direct deposits. |
Property Banking Master > Bank Account Number |
N/A |
|
Arrival Date |
Section 1 |
Check-in or arrival date of the guest stay associated with the invoiced line item. |
Reservation Engine > Arrival Date |
N/A |
|
Bank Address |
Section 3 |
Physical branch address or mailing location of the property's financial depository institution. |
Property Banking Master > Branch Address |
N/A |
|
Bank Identification Number |
Section 3 |
National bank transit number, routing transit number (ABA/RTN), or clearing house branch identifier. |
Property Banking Master > Routing / Transit Number |
N/A |
|
Bank Name |
Section 3 |
Name of the financial depository institution where remittances and invoice payments should be directed. |
Property Banking Master > Bank Name |
N/A |
|
Credit Limit |
Section 2 |
Maximum authorized direct billing credit threshold extended to the customer account. |
Company Credit Master > Authorized Cap |
π’ Yes |
|
Currency |
Section 3 |
Standard ISO currency code (e.g., |
Property Banking Master > Currency Code |
N/A |
|
Current to 30 |
Section 2 |
Receivable balance aged within the current 0 to 30-day billing cycle (including unapplied payments on account). |
City Ledger > Aging (0-30d) |
π’ Yes |
|
Customer Reference Number |
Section 1 |
External tracking reference, voucher code, or client identifier assigned by the customer to the transaction. |
AR Invoicing Engine > Customer Ref |
N/A |
|
Date |
Section 1 |
Calendar date on which the invoice was generated or the payment was posted to the account. |
City Ledger > Posting Date |
N/A |
|
Departure Date |
Section 1 |
Check-out or departure date of the guest stay associated with the invoiced line item. |
Reservation Engine > Departure Date |
N/A |
|
Description |
Section 1 |
Operational line narrative or transaction remarks describing the direct billing event or settlement. |
City Ledger > Transaction Description |
N/A |
|
E Invoice Number |
Section 1 |
Electronic invoice reference code generated for compliant digital tax reporting and e-invoicing portals. |
Fiscal / E-Invoice Engine > E-Invoice ID |
N/A |
|
First Name |
Section 1 |
First name of the primary in-house guest whose stay charges were direct-billed to the customer account. |
Guest Profile > First Name |
N/A |
|
Fiscal Invoice Number |
Section 1 |
Legally mandated fiscal sequential invoice reference attached to the transaction record. |
Fiscal Engine > Fiscal Reference |
N/A |
|
IBAN |
Section 3 |
International Bank Account Number utilized for cross-border electronic funds transfers and wire payments. |
Property Banking Master > IBAN Number |
N/A |
|
Invoice Number |
Section 1 |
Unique master system accounts receivable invoice number generated when charges are billed to the customer. |
AR Billing Engine > Master Invoice ID |
N/A |
|
Last Name |
Section 1 |
Last name (surname) of the primary in-house guest whose stay charges were direct-billed to the customer account. |
Guest Profile > Last Name |
N/A |
|
Number Of Nights |
Section 1 |
Total duration of the guest stay represented by the billed charge. |
Reservation Engine > Room Nights |
N/A |
|
Over 120 Days |
Section 2 |
Receivable balance outstanding and delinquent beyond 120 calendar days from the invoice or transaction date. |
City Ledger > Aging (>120d) |
π’ Yes |
|
PO Number |
Section 1 |
Customer purchase order number or corporate billing authorization tracking reference. |
Folio Billing Setup > PO / Voucher Ref |
N/A |
|
swift code |
Section 3 |
Society for Worldwide Interbank Financial Telecommunication (SWIFT) / BIC code for international bank remittances. |
Property Banking Master > SWIFT / BIC |
N/A |
|
Tax Invoice Number |
Section 1 |
Official sequential tax invoice number assigned to the transaction for statutory reporting and audit compliance. |
Front Desk Billing > Tax Invoice ID |
N/A |
|
Total Amount |
Section 1 |
Gross monetary value of the line item, where positive amounts reflect invoiced debits and negative amounts represent payments applied. |
City Ledger > Transaction Amount |
π’ Yes |
|
Total Due |
Section 2 |
Cumulative gross balance outstanding and payable by the customer as of the statement date (sum of all aging brackets). |
Calculated: Gross Customer Liability |
π’ Yes |
|
Transaction Number |
Section 1 |
Unique system PMS transaction identifier or internal folio sequence reference. |
Financial Audit Trail > Transaction ID |
N/A |
|
Transaction Type |
Section 1 |
Classification of the ledger entry on the customer statement (e.g., |
City Ledger > Entry Classification |
N/A |
Customization & Platform Features
User & Property Preferences
-
Personal Preference: Tailor your individual view by hiding or dragging columns. Your preference saves 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: Statement Details
-
Posting Date & Transaction Classification (Cols 1β2):
Date|Transaction Type -
Core Invoice & Statutory Tax Identifiers (Cols 3β6):
Invoice Number|Tax Invoice Number|Fiscal Invoice Number|E Invoice Number -
External Client & Procurement References (Cols 7β9):
PO Number|Customer Reference Number|Transaction Number -
Stay Itinerary & Nights Duration (Cols 10β12):
Arrival Date|Departure Date|Number Of Nights -
Guest Profile & Folio Narration (Cols 13β15):
First Name|Last Name|Description -
Billed Financial Balance (Col 16):
Total Amount
-
-
Section 2: Aging Summary
-
Credit Governance Baseline (Col 1):
Credit Limit -
Chronological Delinquency Buckets (Cols 2β6):
Current to 30|31 to 60|61 to 90|91 To 120|Over 120 Days -
Cumulative Outstanding Balance (Col 7):
Total Due
-
-
Section 3: Bank Details
-
Banking Institution Identity & Location (Cols 1β3):
Bank Name|Bank Identification Number|Bank Address -
Account Registration & Base Currency (Cols 4β5):
Account Name|Currency -
Settlement Account & Electronic Clearing Routing (Cols 6β8):
Account Number|IBAN|swift 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
-
Exporting & Statement Delivery: Download in Excel or PDF format to email professional statement packages directly to client accounts payable leads.
-
Filtering: Filter data by specific date ranges, transaction types, or invoice statuses.
-
Highlighting (Conditional Formatting): Apply custom rules to automatically highlight overdue balances exceeding 60 days or statements approaching credit limits.
π Related Reports & Next Steps
Within π¬ Billing & Receivables (AR):
-
Accounts Receivable Activity Report β Audit every line-item transaction hitting the city ledger.
-
AR Invoice Aging Report β Categorize open corporate balances across standardized aging bands.
-
Direct Bill Aging Report β Segment corporate debt across AR, Invoices, and Settlements.
-
Direct Bill Reconciliation Report β Identify payment gaps and verify guarantee statuses for corporate invoicing.
-
Invoice Details Overview Report β Detailed lifecycle tracking of every generated invoice.
Cross-Pillar Deep Dives:
-
βοΈ Ledgers & Trial Balance: To reconcile city ledger statement totals against general ledger accounts, review Direct Bill Ledger Details Report.
-
π³ Payments & Transactions: To inspect corporate checks, electronic bank wires, or credit card settlements, cross-reference Payment Activity Report.
-
π Forward Revenue & Analytics: Looking for forward-facing revenue projections or macro performance metrics (like RevPAR or ADR)? Please visit the π Revenue & Analytics reporting hub.