Customer Statement
Query Params
Date (<= CBD - 1)
Company
Sections
Statement Details
Displays all open invoice line items and settlement payments; ARs are not displayed
Columns
Date: date of invoice/payment
Transaction Type: invoice/payment
Invoice Number: AR invoice number
Tax Invoice Number: tax invoice number (for invoice countries)
eInvoice Number: blank
PO Number: invoice line item PO number; else res/GM/HA PO number
Customer Reference Number: blank
Arrival Date: res check in date (blank for GM/HA)
Departure Date: res check out date (blank for GM/HA)
Number of Nights: res number of nights (blank for GM/HA)
Transaction Number: res confirmation number, GM code, or HA number
Description: primary guest name, GM name, or HA name
Total Amount: open invoice/payment amount
Aging Summary
Summary of invoices and settlement payments; ARs are not included
Columns:
Credit Limit
Current to 30
31 to 60
61 to 90
91 to 120
Over 120 Days
Total Due: sum of all aging buckets
Payment Due: sum of aging buckets >= payment term days
Bank Details
One row per Property Settings > Property Details > Additional Details > Bank Account Number
Columns:
Bank Name
Bank Identification Number
Bank Address
Account Name
Currency
Account Number
IBAN
Swift Code
Modules
Companies and Direct Bill > Accounts Receivable > Download Customer Statement
Reports > Dynamic Reports > Companies > Customer Statement
Sample