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