City Ledger Accounting AGING Report (Cloud) 🎥

City Ledger Accounting AGING Report (Cloud) 🎥

The City Ledger AGING report provides a categorized view of customer invoices based on the time elapsed after the billing or due date. It groups outstanding invoices into date ranges of 30 days to help track and manage accounts receivable efficiently. This report can be printed for reference and analysis.
Path: Accounting > City Ledger > Aging Report

Narrow down the report using the optional available filters (from left to right):
- by range of account numbers.
- by date. Note that the Aging report is a dynamic report, not a static one. If a past date is chosen, it will still reflect any transaction posted after that date, like a payment.
- by member code. A member code is a group of multiple City Ledger accounts.

You can choose how the numbers in the Aging report will display: by invoice date or by folio posting date.
Regardless of the chosen selection, the city ledger balance remains unaffected. Opting for the posting date will display period balances (30/60/90 days) according to the day the charge was posted on the folio. Conversely, selecting by invoice date will showcase period balances (30/60/90 days) based on the date the folios were invoiced to the city ledger account.

Click Refresh to apply any of the options.



Click in any of the columns header to sort the list of account.



The first section of the Aging report will show the C/L Account number, member code (if attached to one) and the account name.



The second section will show the current 30-day period balance, the past 60/90-day period balance and the current total balance of the account.



The first line will always be the totals of Uninvoiced Items.



The last section of the window will will give the total of all CL accounts by date ranges of 30 days and the total current balance.



Click Print to keep a copy.




    • Related Articles

    • City Ledger "Uninvoiced Items" (Cloud)

      After directing billing for a folio, it initially appears in the uninvoiced items within the Accounting section. It only transitions to the designated City Ledger Account and appears in the AGING report for that account after being invoiced. Path: ...
    • 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 ...
    • Sales & Mktg City Ledger Forecast Report (Cloud) 🎥

      ? Watch Video The City Ledger forecast report will display a recap of each City Ledger currently linked to a reservation in the system. Path: Sales & Marketing > Reports > Forecast > City Ledger Generate report 1. Narrow down the report by choosing ...
    • 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 ...
    • 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 ...