Report: Collection Summary

From Agency Systems Wiki
Jump to navigation Jump to search
Related Pages
Related Categories

The collection summary provides an aged report for clients with outstanding balances due to the agency, and includes the client's phone number and the Date Since Last Payment (DSLP). The DSLP represents the number of days since the last non-invoice transaction was posted to the client's account.

From the My Newton Campus Forum: Frequently Asked Questions

All Agency Systems customers are invited to join the My Newton Campus user community forum.

Access and Report Process

  1. Select A/R -> Collection Summary. (Requires Security System: A/R -> Collection Summary -> View)
  2. Select the desired Sort By... method.
  3. Select the desired Aging Date.
  4. Leave the Department as "All Departments" unless the agency uses department separation for locations.
  5. Optionally select Include clients with credit balances.
  6. Select Preview or Print.

Report Window Options

Menu-ar-collsummary.png Menu-ar-collsummary-byproducer.png

Sort By

Sort by client number: Leave as "All Clients" to see the entire agency listing, or select a beginning and ending client. The clients are listed in numerical order.

Sort by client's alpha code: Leave as "All Producers" for the entire agency listing, or select a single producer. The clients are listed alphabetically.

Sort by client's producer: Leave as "All Producers" for the entire agency listing, or select a single producer. If run for "All Producers" there will be a page break between each producer's section. This allows the pages to be handed out for collection calls.

Sort by balance: All agency client accounts are listed from the largest balance to the smallest.

Aging Date

The aging date is used to determine the age of a transaction by comparing the date it was created in the system to the date selected for the report. For example, a transaction will be 35 days old if it was created 35 days prior to the aging date.

Department

Leave as "All Departments" for the entire agency listing, or select a single department. Filtering by department will limit the transactions displayed based on the selected department code. For example, if the collection summary is run for department code PL, and an account includes both an invoice in department PL and a cash receipt in department GA, only the invoice will be displayed on the report.

Include Clients With Credit Balances

Since the purpose of the report is for collections, clients with a credit balance (the agency owes the client money) are not included by default. Check the box to include clients with credit balances.