Aged Trial Balance Report Instructions

Use the Aged Trial Balance Report to provide a snapshot of your accounts receivables.  This report lists customer accounts receivable balances for each service and can provide a breakdown of their respective aging buckets and their finance charges, if applicable.  This report has the option to print the associated invoice detail for open item customers.  The Customer History Report also provides invoice detail information.  You can tailor the report using a variety of criteria including sort options, subtotal options and selection by Account range.  You can also choose to list totals only while excluding the customer aging buckets detail.

Tips:

• This report is also known as the ATB.

• You can run this report as often as necessary as files are not affected.

• For more information about running reports, see Print View.

• For more information about the buttons on the toolbar, see the Reporting Toolbar.

Directions:

To see directions for...

• Opening the Aged Trial Balance Report, click More.

   

  1.  Click Reports from the Menu Bar.

  2.  Click Miscellaneous.

  3.  Click Aged Trial Balance Report.
  
  Or, use the keyboard shortcut:  [ALT] [e] [m] [m] [a].

   

  Aged Trial Balance Report Window Example:

  

   

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

   

  Aged Trial 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 icon.
  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 icon.
  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 icon.
  Rate Class	To select the Rate Classes to report, click to check the appropriate Rate Classes listed. Tip:  To quickly select or de-select all Rate Classes listed, click the Check All icon.
  Credit Rating	To select the Credit Ratings to report, click to check the appropriate Credit Ratings listed. Tip:  To quickly select or de-select all Credit Ratings listed, click the Check All icon.
  Sort	To choose a sort option, click to select the appropriate button. Sort Options: Account - Sorts and prints customers with overdue balances in Customer ID order. Last Name - Sorts and prints customers in Customer Last Name order. Financial Period - Sorts and print customers in Financial Period order. Balance - Sorts and prints in customer balance amount order. None - Prints the report in specified user-defined field order allowing you to sort or pull data into the ATB to suit your purpose.  For example, if you want to print the report in book/sequence number, define a user definable field as Book/Sequence, maintain info in the field, then choose that option.
  Select Customers Note:  The From and Through fields are only active if you select Account as the Sort option.
  From	To limit the report to a range of customers, enter the appropriate beginning Customer ID in the range. Tip:  To include all customers, leave blank.
  Thru	To limit the report to a range of customers, enter the desired ending Customer ID in the range. Tip:  To include all customers, leave blank.
  Paperless and Non-paperless	Entry Options: To include all customers on the report, choose Paperless and Non-Paperless. To only include customers who receive paper statements on the report, click to select Non-paperless only. To only include customers with paperless statements on the report, click to select Paperless only.
  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, leave this box unchecked.
  Company Totals	To print totals for each Company at the end of the report, click to select this box. To omit printing Company totals at the end of the report, leave this box unchecked.
  Finance Period Totals	To print totals for each Finance Period at the end of the report, click to select this box. To omit printing Finance Period totals at the end of the report, leave this box unchecked.
  Totals Only	To print totals only while excluding the detail, select this box.   To print detail as well as, totals, leave this box unchecked.
  Merge Other Detail	Note:  This field is only available if extended aging information is set up.  For more information, contact NDS Technical Support.
  Compressed Detail	To print a compressed detail version of the report where customer information is compressed into a single line, click to select Compressed Detail.  Otherwise, leave this box unchecked.
  Compressed Total	To print a compressed total where customer amounts are accumulated into a single total, click to select Compressed Total.  Otherwise, leave this box unchecked.
  Compressed Balance	To print a compressed customer balance, click to select Compressed Balance.  Otherwise, leave this box unchecked.
  Include Zero Balance	To include all customers on the ATB, click to select Include Zero Balance.  Otherwise, leave this box unchecked.
  Budget Accts Only	To print the report for budget accounts, click to select Budget Accts Only.  Otherwise, leave this box unchecked.
  Show Invoice Details	To include invoice details on the report, click to check this box.  To omit invoice details, please leave this box blank. Notes:   The Show Invoice Details option only pertains to Open Item accounts. The invoice details included are Invoice Number, Bill Date, Post Date and Invoice Outstanding Balance.
  Previous Customers	To print previous customers associated with a specified location who have an outstanding balance, click to select Previous Customers. Notes: You must specify the Locations to print previous customers for. Previous customers are only tracked if you change owners using the Add/Change Owner Wizard.
  Customer ID(s)	Entry Options: To print an individual account, enter the Customer ID. (up to 12 characters) To build a list of customers to print: 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 build a range of customers, enter the beginning Customer ID, followed by a hyphen (-) and then the ending Customer ID. To print all customers on the report, please leave blank.
  Location ID(s)	Entry Options: To print an individual location, enter the Customer ID. (up to 12 characters) To build a list of locations to print: Enter the Location ID followed by a comma (,). Continue to enter the desired locations. To complete the location list, press [TAB]. To search for the appropriate Location ID, click Search . To build a range of locations, enter the beginning Location ID, followed by a hyphen (-) and then the ending Location ID. To print all locations on the report, please leave blank.
  	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]
  Server Process Status
  Status	Displays information pertaining to the various phases of the reporting process to guide you. Note:  The status displays Complete when the process is ended.  In addition, the Message window displays Time Started and Time Ended to alert you when the routine is complete.
  	To close the window when the report is complete, click Close .

   

• Report Samples, click More.

   

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