Accounts Receivable Reports

AR Template Reports

Please refer to the SSDT Template Reports for further information on the following Accounts Receivable reports.

AR Canned Reports

Please refer to the following canned report links for further information.

Customer Statement Report

This report generates a statement for customers with outstanding balances. It contains the billing date, ledger code, billing number, the total charges, total payments, and the balance due.  Specific selection options are available, including the option to set a minimum debit or credit balance and options to select certain ledgers code and date ranges.  A separate statement is created for each customer meeting the selection options.

Open

• Select by Balance Amount:  When checked, it will generate statements for all customers with outstanding balances greater than the balance amount entered.  If left unchecked, it will generate statements for all customers with outstanding balances.

• Ledger Codes: Move the Ledger Codes to the right column in order to generate statements for those particular ledger codes.

• Customer:  Move the Customer to the right column in order to generate statements for the Customer(s) selected.

• Start Date/End Date: Enter beginning and ending billing dates

• Output Format: Output format options include PDF and XML

• Print:  Click Print to Generates statements

Accounts Receivable Report

This report provides the ability to generate a report listing the accounts receivable as of a user-specified reporting date (usually June 30th).  It will apply the appropriate rules for determining what is an "accounts receivable" for inclusion in this report. These rules depend on the fund type. For proprietary and similar fund types, revenues are recognized when earned. For governmental and similar fund types, revenues are recognized when measurable and available. The available period is generally considered to be 60 days from the end of the fiscal year, although this could vary by district.

Open

• The Reporting Date is the date used to determine if the item is a receivable as of this date. (Date is usually June 30 of the fiscal year being closed. A blank field will default to the current date.)

• The Available Period is the number of days to be used as the available period for governmental accounts.  It defaults to 60 but can be overwritten. 

• Fund types:

  • Governmental Fund Type

    • If you select Governmental fund type, if the service date of an item is on or before the reporting date, and the payment date is after the reporting date but within the available period. it is considered a receivable under the rules for governmental funds.  If no payment has been made, then the item is not a receivable under the rules for governmental funds. If no service date is entered, then the billing date will be used as the service date.

  • Proprietary Fund Type

    • If you select Proprietary Fund type, a record will be selected if the service date of the item is on or before the reporting date, and the payment date is either after the reporting date (if paid), or the billlng is still outstanding.  If no service date is entered, then the billing date will be used as the service date.

• Select desired Sort Options. Defaults are provided by can be overwritten.

• Output Format: Select desired output format

• Generate Report