Client Ledger
The Client Ledger report shows the detail WIP and AR transactions by client. The report shows a balance forward as of the starting date entered. The report includes detail of all WIP and AR transactions after that balance forward to the ending date entered.
Permissions Required for this Report
In the staff profile, staff must be assigned to a security group that is granted View functional rights for the following:
- Security group profile > Functional rights > Reports > Shared Library > Shared Views
- Security group profile > Functional rights > Reports > Firm Library > Custom
- Security group profile > Functional rights > Reports > Firm Library > Standard > Firm
- Security group profile > Functional rights > Reports > Firm Library > Standard > Practice
- Security group profile > Functional rights > Reports > Firm Library > <report name>
- Security group profile > Functional rights > Administration Manager > Client Manager > Approved Clients
Reports in Foundation that are Comparable
In Practice Management, the comparable report is the Client Ledger Report. In Practice Advantage, there is no comparable report.
Report Specifications
The following report options and filters are available to determine the report contents.
Options and Settings | ||
---|---|---|
Option | Setting | Description |
Show Invoice Description |
Yes/No |
Includes or excludes the invoice description column. |
Hide Comma |
Yes/No |
Includes or excludes commas in numbers. |
Hide Penny |
Yes/No |
Includes or excludes pennies in amounts. |
Include Deleted Clients |
Yes/No |
Includes or excludes deleted client information. |
Default Filters | ||
---|---|---|
Field Name | Operator | Value |
Transaction Date | Between | First Day Of Current Fiscal Year, Last Day Of Current Fiscal Year |
Optional Filters | ||
---|---|---|
Available Fields | ||
Accounting Period Date |
Client ID.Sub ID |
Payments/Adjustments |
Amount |
Client Name |
Posted Date |
Applied |
Client Office |
Primary Partner |
Billed |
Client Primary Service Type |
Progress |
Business Code |
Client Region |
Return Group |
Category ID |
Client Sub ID |
Service Code ID |
Client |
Client Type |
Service Code Name |
Client – Principal |
Description |
Staff ID |
Client Bill Manager |
Financial Reporting Client Group |
Subcategory ID |
Client Billing Group |
Hours |
Subcategory Name |
Client Business Unit |
Line of Business |
Tax Type |
Client ID |
Manager |
Transaction Date |
Grouping | ||
---|---|---|
Available Fields | ||
Business Code |
Client ID.Sub ID |
Manager |
Category ID |
Client Name |
Primary Partner |
Category Name |
Client Office |
Return Group |
Client |
Client Primary Service Type |
Service Code ID |
Client – Principal |
Client Region |
Sort Name |
Client Bill Manager |
Client Sub ID |
Subcategory ID |
Client Billing Group |
Client Type |
Subcategory Name |
Client Business Unit |
Financial Reporting Client Group |
Tax Type |
Client ID |
Line of Business |
|
Sorting | ||
---|---|---|
Available Fields | ||
Amount |
Client Name |
Progress |
Applied |
Date |
Service Code |
Billed |
Hours |
Staff ID |
Client |
Payments/Adjustments |
|
Report Fields
The following fields are available for this report. The fields that display and the position of fields are based on the report's settings, grouping, sorting, and filters.
Report Fields | |
---|---|
Field | Description |
Client |
The client name, and client ID, and sub-ID |
Client Name |
The client name. |
Balance Forward |
The balance for the WIP and AR prior to the beginning date of the report. |
Date |
The date of the transaction. |
Description |
The description of the transaction type. |
Staff ID |
The staff ID of the person assigned to the WIP transaction. |
Service Code |
The service code assigned to the transaction (for WIP transactions only). |
Hours |
The total hours tied to the transaction (for WIP transactions only). |
Amount |
The total amount of the WIP transaction. |
Progress |
The total amount of progress billed for the transaction (for WIP transactions only). |
Applied |
The total amount of progress applied to the transaction (for WIP transactions only). |
Balance |
The WIP balance after each transaction. |
Billed |
The total amount billed for the transaction (for AR transactions only). |
Payments/Adjustments |
The total amount of payments and adjustments for the transaction (for AR transactions only). |
Balance |
The AR balance after each transaction. |
Client Ledger Sample Report