Report: Collection Summary

From Agency Systems Wiki
Revision as of 16:17, 26 June 2015 by Mlively (Talk | contribs) (initial save)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
Related Pages
Related Categories

The collection summary provides an aged report for clients which 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 list from the largest balance to the smallest.

Aging Date

A transaction will be 35 days old if it is 35 days prior to the aging date.

Department

Leave as "All Departments" for the entire agency listing, or select a single department. If run for department code PL, and have an invoice in that department and a cash receipt in department GA, only the invoice will be included.

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