Difference between revisions of "Report: Collection Summary"

From Agency Systems Wiki
Jump to navigation Jump to search
(initial save)
 
(updated how to access only)
 
(10 intermediate revisions by 2 users not shown)
Line 30: Line 30:
 
</table>
 
</table>
  
The collection summary provides an aged report for [[Client Profile|clients]] which includes the client's phone number and the '''D'''ate '''S'''ince '''L'''ast '''P'''ayment (DSLP). The DSLP represents the number of days since the last non-invoice transaction was posted to the client's account.
+
The collection summary provides an aged report for [[Client Profile|clients]] with outstanding balances due to the agency, and includes the client's phone number and the '''D'''ate '''S'''ince '''L'''ast '''P'''ayment (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 ==
+
== Frequently Asked Questions (FAQ)==
All Agency Systems customers are invited to join the [http://www.mynewtoncampus.com/forum/ My Newton Campus user community forum].
+
*[[Talk:Report:_Collection_Summary#Collection_Summary_vs._Client_Aged_Receivables.3F|Collection Summary vs. Client Aged Receivables?]]
*[http://mynewtoncampus.com/forum/index.php?topic=132.0 What is the difference between the collection summary and the client aged receivable reports?]
 
  
 
== Access and Report Process ==
 
== Access and Report Process ==
#Select '''A/R -> Collection Summary'''. ''(Requires [[Security System|Security System:]] A/R -> Collection Summary -> View)''
+
#Select '''Client -> Collection Summary'''. ''(Requires [[Security System|Security System:]] A/R -> Collection Summary -> View)''
 
#Select the desired '''[[#Sort By|Sort By...]]''' method.
 
#Select the desired '''[[#Sort By|Sort By...]]''' method.
 
#Select the desired '''[[#Aging Date|Aging Date]]'''.
 
#Select the desired '''[[#Aging Date|Aging Date]]'''.
 
#Leave the '''[[#Department|Department]]''' as "All Departments" unless the agency uses department separation for locations.
 
#Leave the '''[[#Department|Department]]''' as "All Departments" unless the agency uses department separation for locations.
 
#Optionally select '''[[#Include Clients With Credit Balances|Include clients with credit balances]]'''.
 
#Optionally select '''[[#Include Clients With Credit Balances|Include clients with credit balances]]'''.
#Select '''Preview''' or '''Print'''.  
+
#Select '''Preview''' or '''Print'''.
  
 
== Report Window Options ==
 
== Report Window Options ==
Line 53: Line 52:
 
'''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 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.
+
'''Sort by balance:''' All agency client accounts are listed from the largest balance to the smallest.
  
 
===Aging Date===
 
===Aging Date===
A transaction will be 35 days old if it is 35 days prior to the 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===
 
===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.
+
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 Profile|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===
 
===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.
+
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.

Latest revision as of 19:06, 6 March 2019

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.

Frequently Asked Questions (FAQ)

Access and Report Process

  1. Select Client -> 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.