City Ledger Reports

Updated on Mar 31, 2021

The following article reviews the related reports that can be printed for the City Ledger. Most are available from within the City Ledger itself, some are located under the Reports menu of the PMS.

Aged Balance Summary

Located under Operations > City Ledger > Reports > Aged Balance > Summary

This report shows a 30/60/90 day summarized breakdown of money owed on all City Accounts.

Aged Balance Detail

Located under Operations > City Ledger > Reports > Aged Balance > Detail

This report shows a 30/60/90 day detailed breakdown of money owed on all City Accounts.

Statement for Selected Account

Located under Operations > City Ledger > Reports > Statement for Selected Account

This report provides a list of all Open Invoices for the selected City Ledger Account.
This report can also be accessed directly from the City Ledger Account by selecting the Print Statement button located at the bottom of the City Ledger Account Master screen

City Ledger Transaction Report

Located under Operations > City Ledger > Reports > City Ledger Transaction Report

This report is a Transaction Register Balance for all charges/payments that have been made directly in the City Ledger. Front Desk Transfers will also be displayed on this report.

Payment Details

Located under Operations > City Ledger > Reports > Payment Details

This report produces a list of all City Ledger Accounts with any Payment Credits
This report also produces a list of any payments that were made on City Ledger Accounts for the selected date

Invoices

Located under Operations > City Ledger > Reports > Invoices

This report displays a list of charges/payments for a selected invoice

NOTE: This option under the Reports menu is only available after you have searched for an invoice. You also have the option to view this report by selecting the Print Invoice button after you have opened an Invoice.

There are two options when viewing a report from the Reports Menu:

Print Default Invoice – allows you to print a copy of the default invoice that is located in the PMS
Select Custom Invoice – if you have created a Custom Invoice in the City Ledger, this allows you to select to view your invoice in the customized format (For more information regarding Custom Invoices, please see the corresponding section of this document)

Account Listing

Located under Operations > City Ledger > Reports > Account Listing

This report provides a summarized list of all City Ledger Accounts.

Account Detail

Located under Operations > City Ledger > Reports > Account Detail

This report provides a more detailed listing of all City Ledger Accounts

Daily Balances for City Accounts

This report provides a summary of the daily balances of City Accounts. It shows the Balance In at the start of the day, any Charges or Payments made, and the Balance Out at the time of printing.

Invoice Listing

Operations > City Ledger > Search button (F3) > Invoice Listing

This report provides a list of all the open invoices for a City Ledger Account for a specific date range.

To run the Invoice Listing Report, go to Operations > City Ledger and select the Search button at the top of the screen.

Check the box next to Invoice Listing and use the drop down menu next to Account to search for the desired Account to print.

After a City Ledger Account has been selected, choose to view:

All Open Invoices – this will display all open invoices for this City Ledger Account
By Date – Allows viewing of invoices between a selected date range

Select OK to view Invoice Listing

The Open Invoices tab will open, and a list of invoices will appear on the screen. To print an Invoice Listing Report, select the Print button located at the top of the screen.