Accounts Receivable Reports

AR Template Reports

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

Redesign Report	Classic Report	Definition
SSDT AR Billing Detail	N/A	Produces a detailed listing of Billing Items
SSDT AR Billing Summary	N/A	Produces as summary report of Billing Items
SSDT AR Detail Report	ARDETL	Detail listing of all billings and payments for various types of invoices.
SSDT AR Transaction Summary	ARTRAN	Report listing the total billing and/or payment amounts for various types of invoices for one or more customers.

AR Canned Reports

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

Redesign Report	Classic Report	Definition
Customer Statement Report	ARSTATE	Generates a statement for customers with outstanding balances
Accounts Receivable Report	ARCVBL	Generates a report listing the accounts receivable as of a user-specified reporting date

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.

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

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