Account History Report

The Account History Report screen is divided into two sections; System Parameters and User Parameters. In the System Parameters section, the user must specify details for the format of the report; in the User Parameters section, the user must specify details pertaining to the content of the report. For general information on running reports and on defining System Parameters, please refer to the Running Reports help document.

Report Description

The Account History report is produced based on a user selected range of Clients and Matters. For the selected Clients and Matters, the report displays all Bills, and all transactions for each Bill. Report details include the Bill Number, Transaction Date, Journal Number, Journal Type, Transaction Type, Transaction Amount, Interest Amount, and the Total Amount with Interest. Totals are per Invoice, per Matter, and per Client. Client/Matters that carry a zero balance will not be included in this report.

The report output can be generated into an Excel spreadsheet file, or in the same manner as most other reports (i.e. format selected in the System Parameters section). When generating an Excel file, the user must specify the full path and file name (i.e. c:\My Documents\Account History.xls). Keep in mind that this report can be generated in the manner selected in the System Parameters section AND generated to an Excel file at the same time; there is no need to run the report twice if the user wishes to have Excel output in addition to output in another format.

User Parameters

User Parameters

Client Number X to X
The user must enter the unique identifiers of the Clients that define the range of Clients to be included in the report. These fields default to the first and last possible Clients (i.e. by default, all Clients are included).

Matter Number X to X
The user must enter the unique identifiers of the Matter that define the range of Matter to be included in the report. These fields default to the first and last possible Client (i.e. by default, all Matters are included).

Report By
From the list provided, the user must select the format of the report. Valid options include All Accounts Rendered (i.e. the report will be generated for all accounts), and Outstanding Accounts Only (i.e. the report will be generated for only those accounts with outstanding balances). The user also has the option to manually enter their Report By selection. This field defaults to the All Accounts Rendered option.

Suppress Zero YN
From the list provided, the user must select either Y (i.e. Yes, meaning all zero entries/balances will not be displayed in the report) or N (i.e. No, meaning all zero entries/balances will be displayed in the report).

Create Excel Output
To send the report contents to an Excel spreadsheet file, the user must select the "Y" (i.e. Yes) option form the drop down list provided. This field defaults to the "N" (i.e. No) option. Keep in mind that this report can be generated in the manner selected in the System Parameters section AND generated to an Excel file at the same time; there is no need to run the report twice if the user wishes to have Excel output as well as output in another format.

Excel Destination
If the user has selected to send the report contents to an Excel spreadsheet file, they must then specify the exact path and name for that file (i.e. c:\My Documents\Account History.xls).