Collection Balance Report Instructions

Use the Collection Balance Report to provide a snapshot of your accounts receivables for the customers in the collection workfile.  This report lists customer accounts receivable balances for the service specified.

For additional information, click More.

Directions:

To see directions for...

• Opening the Collection Balance Report, click More.

   

  1.  Click Processes from the Menu Bar.

  2.  Click Collection.

  3.  Click Collection Balance Report.
  
  Or, use the keyboard shortcut:  [ALT] [p] [c] [r].

   

  Collection Balance Report Window Example:

  

   

• Choosing the selections at the prompt window, click More.

   

  Collection Balance Report Prompt Options Tip:  To see more information about a field, click the hyperlink for the field name.
  Services	To select the Services to print, click to check the appropriate Services listed. Tip:  To quickly select or de-select all Services listed, click the Check All .
  Companies	To select the Companies to print, click to check the appropriate Companies listed. Tip:  To quickly select or de-select all Companies listed, click the Check All .
  Finance Periods	To select the Finance Periods to print, click to check the appropriate Finance Periods listed. Tip:  To quickly select or de-select all Finance Periods listed, click the Check All .
  Rate Class	To select the Rate Classes to print, click to check the appropriate Rate Classes listed. Tip:  To quickly select or de-select all Rate Classes listed, click the Check All .
  Sort	To choose a sort option, click to select the appropriate button. Sort Options: Account - Prints the report in Customer ID order. Last Name - Prints the report in Customer Last Name order. Financial Period - Prints the report in Finance Period order. Balance - Prints the report in customer balance order. None - Prints the report in no specific order.
  Range Note:  The Range fields are only active if you select Account as the Sort option.
  From	To limit the report to a range of Accounts, enter the appropriate beginning Customer ID in the range. Tip:  To include all Accounts, leave blank.
  Through	To limit the report to a range of Accounts, enter the desired ending Customer ID in the range. Tip:  To include all Accounts, leave blank.
  Service Totals	To print totals for each Service Code at the end of the report, select this box. To omit printing Service Code totals from the end of the report, de-select this box.
  Company Totals	To print totals for each Company at the end of the report, select this box. To omit printing Company totals at the end of the report, de-select this box.
  Finance Period Totals	To print totals for each Finance Period at the end of the report, select this box. To omit printing Finance Period totals at the end of the report, de-select this box.
  Totals Only	To print totals only while excluding the detail, select this box.   To print detail as well as, totals, de-select this box.
  Merge Other Detail	To print regular charges and other charges combined in one column, select this box. To print regular and other charges in separate columns, de-select this box. Note:  This field is only available if extended aging information is set up.  For more information, contact NDS Technical Support.
  Compressed Detail	To print the report in a 132-column format, select this box. To omit printing the report in a 132-column format, de-select this box.
  Compressed Total	To include a Total column in the 132-column report format, select this box. To omit a Total column in the 132-column report format, de-select this box. Notes: This field is only active if you select the Compressed Detail option above. Depending on the Customer Age Balances you have set up, if you choose this option report columns may be moved or combined.
  Include Zero Balance	To include accounts with zero balances on the report, select this box. To omit printing accounts with zero balances on the report, de-select this box.
  Budget Accts. Only	To print budget accounts only, select this box. To print all accounts, de-select this box.
  Previous Customers	To include both current and previous customer balances for a location, select this box. To omit previous customer balances for a location, de-select this box. Tip:  This field is only active if you select to print specific locations by entering Location IDs.
  Customer ID	Entry Options: To print a selected account, enter the Customer ID. (up to 12 characters) To build a list of customers: Enter the Customer ID followed by a comma (,). Continue to enter the desired customers. To complete the customer list, press [TAB]. To search for the appropriate customer ID, click Search . To print all customers on the report, please leave blank.
  Location ID	To print selected locations on the report, enter the Location IDs. (up to 12 characters) Tip:  To build a list of locations: Enter the Location ID followed by a comma (,). Continue to enter the desired locations. To complete the location list, press [TAB].
  	To begin printing to the Windows® default printer, click Print, or press [ENTER]. Keyboard shortcut:  [ALT + p]
  	To print to the Print View window, click here.
  	To escape from the print routine, click Cancel. Keyboard shortcut:  [ALT + c]

   

• Report Sample(s), click More.

   

  To see an example of the report, click Collection Balance Report Sample.