"Exclude 0 Balance" in a City Ledger Statement? (Cloud)

"Exclude 0 Balance" in a City Ledger Statement? (Cloud)

A balance statement serves a broader purpose than simply displaying an account's balance. It provides a comprehensive overview of invoices created, payments posted, and their application to an account within a specified date range. When the "Exclude 0 Balance" checkbox is selected, City Ledger accounts with a zero balance will be omitted from the search results for the chosen date range and selected accounts. However, it's important to note that this exclusion is only applicable to the screen view and does not affect the statement itself. Therefore, running the same search with the "Exclude 0 Balances" option checked and unchecked may yield different result counts.
Path: Accounting > City Ledger > Print Statement


Exclude Zero Balances has no effect on what appears on the statement.
Typically in a 30-day period, payments and applied payments to an invoice will not show because payment would have not been posted during the same 30 days range when the invoice was created.
When printing a statement, the date range is what will predetermine what will show on the report and not what box was checked.



The following screenshots will show the same statement, both with the Exclude 0 Balance box checked, but both for different dates.
1. The first one will have a short range
2. The second one will have a larger date range.


    • Related Articles

    • Print City Ledger Statements (Cloud)

      City Ledger (CL) statements summarize financial transactions for an entity's account with a hotel or property, including charges, payments, and balances. They are crucial for transparent financial record-keeping and billing accuracy. Path: Accounting ...
    • Update/Customize City Ledger Statements (Cloud)

      The City Ledger Statement text is the text that is showing at the bottom of a City Ledger Statement, as shown below. Path: Management > Property Settings > Forms To update/customize this text, follow the next steps. 1. On the bottom left side, click ...
    • Print/Create City Ledger Invoices (Cloud) 🎥

      ? Watch Video Creating a City Ledger invoice involves generating a document that details the charges incurred by a guest or entity with a City Ledger account. An invoice can include multiple folios, simplifying the billing process by consolidating ...
    • City Ledger Over Credit Limit Report (Cloud)

      The Over Credit Limit report identifies City Ledger (CL) accounts that have exceeded their established credit limit. This report is crucial for financial monitoring and helps in managing credit risks effectively Path: Accounting > City Ledger > Over ...
    • Sales & Mktg City Ledger Profile (Cloud) 🎥

      ? Watch Video The City Ledger in Sales and Marketing provides various sections of information for clients that have Direct Billing privileges. Path: Sales and Marketing > City Ledger. The City Ledger profile in Sales & Marketing is divided into 5 ...