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

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. The same search (dates and accounts) with Excluding 0 Balances checked and unchecked, will not display the same number of results.

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)

  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 Statement is ...

• 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 ...

• City Ledger Accounting AGING Report (Cloud) 🎥

  ? Watch Video The City Ledger AGING report allows you to view and Print the classification of accounts based on the amount of time elapsed after the billing date or due date. The outstanding customer invoices are categorized by date ranges of 30 ...

• Post a Payment on a City Ledger Account (Cloud) 🎥

  ? Watch Video Path: Accounting > City Ledger > Account Listing 1. Click on the City Ledger account. 2. Click on Payments from the toolbox on the right. 3. Choose the method of payment: - A/R Direct Bill Debit: this will post a debit to the balance. ...

• View a City Ledger Account Details (Cloud) 🎥

  ? 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 ...