ZenotiHelp

Guests Statements Report

ZTZenoti Docs Team Updated April 22, 2026 6 min readReference

The Guests Statements report provides a guest-level view of outstanding balances for guests with house accounts. Each row shows one guest's total dues, billed and unbilled amounts, aging across billing cycles, late fees accumulated, wallet balance, and most recent payment details. Finance teams, center managers, and collections staff use the report to prioritize dues follow-ups, analyze aging, and reconcile wallet balances.

Audience: Finance operators, center managers, and collections teams responsible for guest dues, house accounts, and recurring billing reconciliation.


On this page


Use cases

  • Identify guests with outstanding dues and prioritize collection follow-ups.
  • Analyze the aging of unpaid balances across billing cycles (current, one cycle, two cycles, three-plus cycles).
  • Review the breakdown of billed and unbilled dues for each guest.
  • Track late-fee accumulation across current and past billing cycles.
  • Reconcile wallet balances and most recent payment details for each guest.

Access the report

  1. At the organization or center level, click Reports.
  2. Search for and select Guests Statements Report. Alternatively, click the Statements category and select the report from the list.
  3. Apply the required filters and click Refresh to load results.
  4. For a range exceeding one year, click Email to receive the report by email instead of viewing on-screen.
  5. Scroll horizontally within the report grid to view all columns.

Available filters

Apply these filters to narrow the data before refreshing:

Filter Options and values Description
Payment Type None, Credit Card, ACH, and other configured payment types. Multi-select. Filters guests by the payment method associated with their account. Select All to include guests regardless of payment method.
Centers Centers your account has access to. Multi-select. Returns statement data for the selected centers. Centers you cannot access are not listed. Select All for the full accessible scope.
As On Date Date picker. Defaults to the current date. Specifies the date as of which outstanding dues, aging, and late fees are calculated. Balances reflect the state on the selected date.

Column descriptions

Each row represents one guest statement.

Guest identity

Column Short description Details
Center name Center associated with the guest. The center to which the guest's account and outstanding balance belong. Use this column to segment data by operational ownership.
Guest name Guest profile name tied to the statement. Displays the guest profile name. Use to locate the guest and review history from the profile when required.
Phone number Contact phone number. The phone number on the guest's profile. Displays NA when no phone number is on file.
Email ID Contact email address. The email address on the guest's profile. Displays NA when no email address is on file.
Guest code Guest identifier, where configured. The guest code if the organization uses guest codes. Blank when guest codes are not configured.

House account and payment method

Column Short description Details
House account holder House-account status. True when the guest currently has a house account; False otherwise. This value reflects the current status and is NOT affected by the As On Date filter. The report also includes guests who are not active members but have pre-existing statements on their accounts.
Payment method Payment method on file. The payment method associated with the guest's account as of the report run date. Examples: OnlineCreditCard, ACH. Not affected by the As On Date filter. Displays NA when no payment method is configured.

Totals and unbilled dues

Column Short description Details
Total due Total outstanding balance. The total amount owed by the guest, including all billed and unbilled dues across all billing cycles. Interpret alongside Unbilled Due and Total Billed Due for a complete exposure picture.
Unbilled due Amount not yet added to an invoice. The portion of the guest's outstanding balance that has not yet been added to an invoice. Reflects the balance as of the report run date — NOT affected by the As On Date filter.
Total billed due Total billed but unpaid. The cumulative amount billed to the guest that remains unpaid across all billing cycles.

Aging (carried-over columns)

Column Short description Details
Carried over zero cycles due Current-cycle carry-forward. The outstanding amount from the current billing cycle that has been carried forward due to non-payment.
Carried over one cycles due One-cycle carry-forward. The outstanding amount from one billing cycle ago that remains unpaid and has been carried forward.
Carried over two cycles due Two-cycle carry-forward. The outstanding amount from two billing cycles ago that remains unpaid and has been carried forward.
Carried over three plus cycles due Three or more cycles carry-forward. The outstanding amount from three or more billing cycles ago. Higher amounts indicate recurring overdue behavior.

Late fees

Column Short description Details
Current late fees Late fees in the current cycle. The late fees charged in the current billing cycle. Late-fee behavior is governed by the organization's configured late-fee rules.
Total late fees Cumulative late fees. The cumulative total of all late fees charged to the guest across all billing cycles. Review alongside the Carried Over columns to assess overall overdue exposure.

Dues by cycle

Column Short description Details
Zero cycles due Amount due in the current cycle. Total amount due in the current billing cycle before carry-forward.
One cycles due Amount due from one cycle ago. Total amount due from one billing cycle ago that remains outstanding.
Two cycles due Amount due from two cycles ago. Total amount due from two billing cycles ago that remains outstanding.
Three plus cycles due Amount due from three or more cycles ago. Total amount due from three or more billing cycles ago that remains outstanding.

Payment history

Column Short description Details
Last payment date Date of most recent payment. The date of the guest's most recent payment. Blank when no payment record exists.
Last payment amount Amount of most recent payment. The amount paid in the most recent transaction. Displays 0 when no payment has been made.
Last payment method Method used for most recent payment. The payment method used for the most recent payment. NOT affected by the As On Date filter — reflects the most recent payment method on record regardless of the date range. Displays NA when no payment record is available.

Wallet

Column Short description Details
Wallet balance Available wallet balance as of the selected date. The total available balance in the guest's wallet as of 11:59 PM of the date selected in the As On Date filter. If the selected date is the current date, the column shows the balance up to the report refresh time. The column footer displays the cumulative wallet balance across all rows shown in the report.

Considerations

  • As On Date scope. The As On Date filter determines the snapshot date for outstanding dues, aging, and late-fee calculations. Note that House Account Holder, Payment Method, Unbilled Due, and Last Payment Method are NOT affected by this filter — they always reflect current or report-run-date values.
  • Aging review. The Carried Over columns reflect the aging of unpaid balances across cycles. Review these columns alongside Total Late Fees to assess the extent of a guest's overdue exposure.
  • Guests with zero Total Due. A guest may appear with a Total Due of 0 if they have a wallet balance or a payment method on file. Use this to reconcile wallet activity for otherwise-paid guests.
  • Late-fee calculation. Late fees are calculated based on the organization's configured late-fee rules. Review Current Late Fees and Total Late Fees together with the Carried Over columns to understand the full recovery picture.
  • Inactive members. The report includes guests who are not active members but have pre-existing statements on their accounts.
  • Payment Type filter behavior. The Payment Type filter supports method categories. Guests with no payment method on file appear under NA.
Was this article helpful?
Your feedback helps us improve our documentation.