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

Note: The Manager and Primary Partner field names are the default values defined for client responsible staff. The first ten client responsible staff List values that are defined by your firm are available field options.

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

 

Note: The Manager and Primary Partner field names are the default values defined for client responsible staff. The first ten client responsible staff List values that are defined by your firm are available field options.

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