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 |
|---|---|---|
N/A | Produces a detailed listing of Billing Items. | |
N/A | Produces a summary report of Billing Items | |
ARDETL | Detailed listing of all billings and payments for various types of invoices. | |
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 |
|---|---|---|
ARSTATE | Generates a statement for customers with outstanding balances. | |
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, options to select ledger codes, and date ranges. A separate statement is created for each customer meeting the selection options.
Select by Balance Amount: When checked, statements for all customers with outstanding balances greater than the balance amount entered will be generated. If left unchecked, it will generate statements for all customers with outstanding balances.
Ledger Codes: Move the Ledger Codes to the right column to generate statements for those particular ledger codes.
Customer: Move the Customer to the right column 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 generate statements.
Accounts Receivable Report
This report provides a snapshot of accounts receivable as of a user-specified reporting date, most commonly June 30th for GAAP purposes. The system 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 the 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 the 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 billing 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 but can be overwritten.
Output Format: Select desired output format
Generate Report