"Exclude 0 Balance" in a City Ledger Statement (Desktop)

Path: Accounting > City Ledger > Print Statement

A balance statement is not meant to show only the balance of an account. It will show any invoice created, payment posted, and applied to an account for a specific date range. The "Exclude 0 Balance" checkbox will exclude City Ledger accounts that have a zero balance from the search results, based on the decided date range and chosen accounts. The exclusion will only be for the screen view, not for the statement itself. If you do the same search (dates and accounts) when Excluding 0 Balances, and look at the scroll bar on the right side of the result, the number of results will/might be much smaller.

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.

For example, 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 (Desktop) 🎥

  ? Watch Video Path: Accounting > City Ledger > Print Statements Generate statement 1. Narrow down the report using the optional available filters (from left to right): - by specific account number or range of CL accounts. - by start and end date the ...

• Update/Customize City Ledger Statements (Desktop)

  The City Ledger Statement text is the text that is showing at the bottom of a City Ledger Statement, as shown below. Path: Management > Setup > Property > Forms To update/customize this text, follow the next steps. In the middle left side, click on ...

• Apply a Payment on a City Ledger Account (Desktop) 🎥

  ? Watch Video Path: Accounting > City Ledger > Accounting Listing This step is after you have posted the payment on the City Ledger account. 1. Click on the City Ledger account. 2. Click on the Payments tab. 3. Click/highlight the payment to apply. ...

• View a City Ledger Account Details (Desktop) 🎥

  ? Watch Video Account Detail will show you the Invoices on the Account that have a balance due. Path: Accounting > City Ledger > Account Listing > Open a CL Account > go to Account Details Select an Invoice # to view: - Invoice details (bottom ...

• Sales & Mktg City Ledger Export (Desktop) 🎥

  ? Watch Video Part of any business is marketing their products and/or services they supply to their existing or potential customers. Visual Matrix offers a platform that will allow you to create mailing lists for their existing customer base. There ...