Financial Details

The Financial Summary routine allows the user to view specific information about a Client or Bill Entity's financial status with the Firm. For example, this routine displays the individual's current balance in Trust, WIP, AR, and Aged AR. A summary of the individual's financial transactions to date are also displayed (i.e. totals in Billing, Receipts, AR Write-Offs, WIP Deletions, and WIP Variance). Note: Information in this form and it's sub forms is for display purposes only, and cannot be edited or updated by the user.

The Financial Summary routine can be accessed five different ways; from the eQuinox main menu, from within the AR Follow Up Activities routine, from within the Maintain Matter Information routine, from within the Close Client Matters routine, and from within the Client Collections routine. When accessed from the main menu or from the AR Follow Up Activities routine, the information displayed is for the current Bill Entity. When accessed from the Client Collections routine, if accessed when viewing the Client Details tab, the information displayed is for the current Client; if accessed when viewing the Entity Details tab, the information displayed is for the current Bill Entity.

Field Definition

Note: When the Financial Summary routine is accessed from the Client tab of the Client Collections routine, or from the Close Client Matters routine, the Client and Matter information will be displayed in the first section of this screen. When accessed from either the Bill Entity tab of the Client Collections routine, or the AR Follow Up Activities routine, the Bill Entity information will be displayed in the first section of this screen.

Bill Entity
The unique identifier and name of the Bill Entity for which the user is viewing financial information. The Bill Entity displayed in the current Bill Entity in the routine from which this form was accessed.

Client
The unique identifier and name of the Client for which the user is viewing financial information. The Client displayed is the current Client in the Client Collections routine.

Matter
The unique identifier and name of the Matter for which the user is viewing financial information. The Matter displayed is the current Matter in the Client Collections routine.

Cutoff Date
The cutoff date for statistics (i.e. financial details for the current Entity/Client/Matter will only go as far back as the date specified in this field). This field defaults to the current system date, but can be changed by making a selection from the calendar provided.

Financial Details

The section of the screen seen here displays the Client or Bill Entity's current balance in Trust, Work in Progress, Accounts Receivable, and Aged Accounts Receivable. This information is for display purposes only and cannot be edited or updated by the user.

Trust
The current Client or Bill Entity's balances for Regular Trust (the amount of Regular Trust available for use, and the amount of Regular Trust on hold), balances for Special Trust (the amount of Special Trust available for use, and the amount of Special Trust on hold), and Total balances (i.e. Regular balance + Special balance, for both Trust available and on hold).

By double-clicking any of the Trust fields, the user can view details about these Trust balances. See the Financial Details - Trust Bank Activity section below for more information.

WIP
The current Client or Bill Entity's Billable and Non Billable Work in Progress balances. The balances for Billable and Non Billable Hours and Fees are displayed, as well as balances for Billable Expense (i.e. the total WIP Expense, including Flow Tax), Billable Total before Tax, and Billable Flow Tax.

By double-clicking the Hours or Fees fields, the user can view details about the Work in Progress balances; see the Financial Details - Billable/Non-Billable Time Dockets section below for more information.

By double-clicking the Expense field, the user can view details about the Work in Progress balances; see the Financial Details - Expense section below for more information.

Accounts Receivable The current Client or Bill Entity's Total AR balance. The Total is also broken down into individual AR balances for Fees, Expenses, Disbursements, and Tax. By double-clicking the fields in this section, the user can view details about Outstanding Bills for the current Client or Bill Entity. See the Financial Details - Outstanding Bills section below for more information.
Interest The total amount of outstanding Interest owed by the current Client or Bill Entity. Aged Accounts Receivable The breakdown of the current Client or Bill Entity's Accounts Receivable by age. Balances are displayed for the individual's Current AR (i.e. currently due for payment), AR that is aged by 30 Days (i.e. payment due at least 30 days ago), AR that is aged by 60 Days (i.e. payment due at least 60 days ago), and AR that is aged by Over 90 Days (i.e. payment is due at least 90 days ago).
The Financial Summary To Date section of the screen displays a summary of the current Client or Bill Entity's financial transactions. This information is for display purposes only and cannot be edited or updated by the user.

Billing
The total dollar amount of Fees, Disbursements, and Tax that have been billed to the current Client or Bill Entity to date.

O/S Credits
The total dollar amount of outstanding credits (i.e. credit amounts that have not yet been applied to AR amounts) that the current Client or Bill Entity holds to date in Fees and Disbursements.

Pending Credits
The total dollar amount of pending credits (i.e. possible credit amounts that have not yet been established) that the current Client or Bill Entity holds to date in Fees, Disbursements, and Tax.

Receipts
The total dollar amount of receipts that have been applied to outstanding Fees, Disbursements, and Tax for the current Client or Bill Entity to date.

AR Write-Offs
The total dollar amount of Accounts Receivable Fees, Disbursements, and Tax that has been written off to date for the current Client or Bill Entity.

WIP Deletions
The total dollar amount of Work in Progress Fees, Disbursements, and Tax that has been written off to date for the current Client or Bill Entity.

WIP Variance
The total dollar amount of the variance for Work in Progress Fees and Disbursements (i.e. the amount Billed minus the Work in Progress amount).

Financial Details - Trust Bank Activity
By double clicking any of the fields in the Trust section on the main screen, the user can view details about the trust balances displayed. If the user double-clicks the Regular field, the sub-form seen below appears, displaying the information specific to the Regular Trust balance; if the user double-clicks the Special field, the sub-form appears displaying information specific to the Special Trust balance. This information is for display purposes only and cannot be edited or updated by the user.

GL Account No, GL Account Description
The number and name/description of the bank account in which the Trust money is being kept.

Account Type
The type of bank account (i.e. this bank account holds either Retainer Trust Funds [R], or it holds Special Trust Funds [S]).

Total Amount
The total dollar amount of Regular or Special Trust in each bank account.

The sections of the screen seen below display a history of Trust transactions specific to the current record in the screen section seen above.

Client, Matter
The unique identifiers of the Client and Matter associated with the current Trust transaction record. The corresponding Client and Matter Names are displayed along the bottom of this section of the screen.

Tran Date
The date on which the current Trust transaction occurred.

Hold Date
If the current record represents a "Hold" transaction, the date displayed is the date on which the Trust amount was placed on Hold.

Description
A description of the Trust transaction, as entered at the time transaction took place.

Client Name
The name of the Client associated with the current Trust transaction. The corresponding Client Number is displayed above.

Ret/All The type of Trust money that was used in the current Trust transaction (i.e. "R" indicates Retainer Funds, "A" indicates Allocated Funds). Amount The dollar amount of the current Trust transaction.
Allocate Bal The Client's Allocated Trust Balance at the time of the current Trust transaction. Retainer Bal The Client's Retainer Trust Balance at the time of the current Trust transaction. Net Balance A running total of the dollar amount of Trust transactions for the current Client (i.e. starting with the Amount of the first transaction, then adding the Amounts of each transaction that follows). Matter Name The name of the Matter associated with the current Trust transaction. The corresponding Matter Number is displayed above.

Financial Details - Billable/Non-Billable Time Dockets

By double-clicking the fields in the Billable or Non Billable WIP section of the main screen, the user can view details about the individual Billable or Non Billable Time Dockets on file for the current Client or Bill Entity.

Before executing a query, the user must select the way in which records on this screen will be displayed (i.e. Ascending or Descending, based on a specific field). This information is for display purposes only and cannot be edited by the user.

Time ID
The unique identifier automatically assigned to the current Time Docket when it was entered into the system.

Client, Matter
The unique identifiers of the Client and Matter associated with the current Time Docket. The corresponding Client and Matter Names are displayed below.

Task
The unique identifier of the Task, if any, associated with the current Time Docket. The corresponding Task Description is displayed below.

Tran Date
The date on which the current transaction took place (i.e. the date on which the Time Docket was entered into the system).

Bill No
The Bill Number associated with the current Time Docket.

Tmkp
The unique identifier of the Timekeeper associated with the current Time Docket. The corresponding Timekeeper Name is displayed below.

Sorting Order, By
Before executing a query, the user must select the way in which records will be displayed, and the field that the sort order is based on (i.e. Sort Ascending based on Transaction Date, sort Descending based on Timekeeper Name, etc).

Description
A description of the current Time Docket.

Rate
The hourly or flat rate charged for the current Time Docket.

Hours, Fees
The number of Hours spent that make up the current Time Docket, and the total Fees amount charged for the current Time Docket.

Client Name, Matter Name
The names of the Client and Matter associated with the current Time Docket. The corresponding unique identifiers are displayed above.

Task Description
A description of the Task, if any, associated with the current Time Docket. The corresponding unique identifier is displayed above.

Timekeeper Name
The name of the Timekeeper associated with the current Time Docket. The corresponding unique identifier is displayed above.

Total Hrs, Total Fees
A running total of the Hours and Fees in the Time Dockets currently displayed (i.e. the sum of the number of hours from each Time Docket, and the sum of the amount of Fees from each Time Docket).

Transactions
This section of the screen displays the details of the transactions that make up the current Time Docket (i.e. the date of the transaction, the Journal through which the transaction was posted, a description of the transaction, the rate at which the Client was billed for the transaction, the number of hours posted for the transaction, and the total amount in fees that the Client was billed for the transaction). To view Tax information for the current transaction record, the user must double click the record.


Financial Details - Expense By double-clicking the Exp field in the Billable WIP section of the main screen, the user can view details about the individual Expense records on file for the current Client or Bill Entity. Before executing a query, the user must select the way in which records on this screen will be displayed (i.e. Ascending or Descending, based on a specific field). This information is for display purposes only and cannot be edited by the user.
	Exp ID The unique identifier automatically assigned to the current Expense when it was entered into the system. Type The type of Expense (i.e. Client or Firm).
Client, Matter The unique identifiers of the Client and Matter associated with the current Disbursement. The corresponding Client and Matter Names are displayed below. Task The unique identifier of the Task, if any, associated with the current Disbursement. The corresponding Task Description is displayed below. Tran Date The date on which the current transaction took place (i.e. the date on which the Disbursement was entered into the system). Bill No The Bill Number associated with the current Disbursement. Tmkp The unique identifier of the Timekeeper associated with the current Disbursement. The corresponding Timekeeper Name is displayed below.

Sorting Order, By
Before executing a query, the user must select the way in which records will be displayed, and the field that the sort order is based on (i.e. Sort Ascending based on Expense Transaction Date, sort Descending based on Timekeeper Name, etc).

Code, Description
The unique identifier and description of the current Disbursement.

Tax Grp
The Tax Group applied to the current Disbursement.

Qty
The quantity of the Disbursement billed for the current record (i.e. the number of instances of the current Disbursement type).

Amount
The total dollar amount charged for the current Disbursement Expense record.

Flow Tax
The dollar amount of Taxes charged for the current Disbursement Expense record.

Client Name, Matter Name
The names of the Client and Matter associated with the current Disbursement Expense record. The corresponding unique identifiers are displayed above.

Task Description
A description of the Task, if any, associated with the current Disbursement Expense record. The corresponding unique identifier is displayed above.

Code Desc
A description of the current Disbursement. The corresponding unique identifier is displayed above.

Tmkp Name
The name of the Timekeeper associated with the current Disbursement Expense record. The corresponding unique identifier is displayed above.

Total Amt, Total Tax
A running total of the Taxes and Amounts for the Disbursement Expense records currently displayed (i.e. the sum of the Taxes from each record, and the sum of the total amount charged from each record).

Transactions Detail
This section of the screen displays the details of the transactions that make up the current Disbursement record (i.e. the date of the transaction, the Journal through which the transaction was posted, a description of the transaction, the rate at which the Client was billed for a single instance of the Disbursement, the number of instances of the current Disbursement, and the total amount in fees that the Client was billed for the Disbursement). To view Tax information for the current transaction record, the user may double click the record.


Financial Details - Outstanding Bills By double-clicking the Fees, Disb, Tax, or Total fields in the Accounts Receivable section of the main screen, the user can view details about Outstanding Bills for the current Client or Bill Entity. This information is for display purposes only and cannot be edited or updated by the user.
	Bill No, Sub The numbers of the Bill and Sub Bill associated with the current record. Type The type of Bill associated with the current record (i.e. Interim, Posted, etc). Billing Date The date of the current Bill.
Client The unique identifier of the Client associated with the current Bill. The corresponding Client Name is displayed below. Matter The unique identifier of the Matter associated with the current Bill. The corresponding Matter Name is displayed below. Bill Entity The unique identifier of the Bill Entity associated with the current Bill. The corresponding Bill Entity Name is displayed below. Client Name, Matter Name The fields that runs along the bottom of this section of the screen display the names of the Client (i.e. SCOTT, AMBER) and Matter (i.e. Re: Real Estate Matter) associated with the current Bill.

Sorting Order, By
Before executing a query, the user must select the way in which records will be displayed, and the field that the sort order is based on (i.e. Sort Ascending based on Expense Transaction Date, sort Descending based on Timekeeper Name, etc).

Fees, Expenses, Tax
The amount of outstanding Fees, Disbursements, and Tax on the current Bill.

Total
The total amount owing on the current Bill (i.e. the sum of the Fees, Disbursements, and Tax amounts).

Interest
The amount of outstanding Interest on the current Bill.

Bill Entity Name
The field that runs along the bottom of this section of the screen displays the name of the Bill Entity associated with the current Bill (i.e. SCOTT, AMBER).

In the Detail Transactions section of the Outstanding Bills screen (seen below), the user can view the individual transactions that make up the current Bill. This information is for display purposes only and cannot be edited or updated by the user.

Journal Type/No
The type and number of the Journal associated with the current transaction (i.e. the Journal in which the expense was recorded).

Posting Date, Month, Year
The date on which the current transaction occurred.

Tran Desc
A brief description of the current transaction.

Hours The number of hours posted to the Matter during the current transaction.
Fees, Expenses, Tax The dollar amount of Fees, Disbursements, and Tax posted to the Matter during the current transaction. Total The total dollar amount of the current transaction (i.e. the sum of the Fees, Disbursements, Interest, and Tax amounts). Interest, Interest WO The total dollar amount of Interest that has been calculated against the current transaction. To write off this Interest balance, the user must click the Interest WO field. Tax Details When the user clicks the Tax Details button, the *Bill Tax Details* screen (seen below) is presented. TMKP Distribution When the user clicks the Timekeeper Distribution button, the *Timekeeper Distribution* screen (seen below) is presented.

The Bill Tax Details Screen

The Timekeeper Distribution Screen

The Timekeeper Distribution Screen displays the way in which funds from Fees, Expenses, Tax, and Interest from the current Transaction are distributed among Timekeepers. The distribution is shown in actual dollar amounts and in Compensation % (i.e. the percentage of the total that goes to this Timekeeper).

	The Bill Tax Details screen presents the user with details about the Tax that has been applied to the current Transaction. The Tax Type, Status, and Rate are displayed, and the Total Tax amount is broken down into Tax Fees (the amount of Tax on the Fees) and Tax Exp (the amount of Tax on the Expenses).