WIP Detail Ledger

The WIP Detail Ledger report includes detail for all unbilled WIP. This report includes a balance forward as of the starting date of the report, and the detail of all unbilled WIP within the date range. Balance forward is calculated based on the date range entered and only includes nonhistoric WIP.

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, there is no comparable report. In Practice Advantage, the comparable report is WIP Detail Ledger.

Report Specifications

The following report options and filters are available to determine report contents.

Options and Settings
Option	Setting	Description
Show Last Bill	Yes/No	Includes or excludes the client’s last bill date and amount.
Show Last Payment	Yes/No	Includes or excludes the client’s last payment date and amount.
Show Current Fiscal Year Write Up/Downs	Yes/No	Includes or excludes the client’s current fiscal year write up/downs.
Show AR Balance	Yes/No	Includes or excludes the clients AR balance.
Show Client Address	Yes/No	Includes or excludes the client’s primary address.
Show Invoice Description	Yes/No	Includes or excludes the invoice description for each transaction.
Show Note	Yes/No	Includes or excludes the invoice notes for each transaction.
Hide Comma	Yes/No	Includes or excludes commas in numbers.
Hide Penny	Yes/No	Includes or excludes pennies in amounts.
Hide Details	Yes/No	Includes or excludes details of each transaction. If hidden, select to subtotal your groups to view the amounts for each selected grouping.

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 – Principal	Client ID.Sub ID
Business Code	Client Bill Manager	Client Name
Category ID	Client Billing Group	Client Office
Category Name	Client Business Unit	Client Primary Service Type
Client	Client ID	Client Region
Client Sub ID	Project	Sort Name
Client Type	Project ID	Staff ID
Financial Reporting Client Group	Project Name	Subcategory ID
Line of Business	Project Office	Subcategory Name
Manager	Return Group	Tax Type
Posted Date	Service Code ID	Transaction Date
Primary Partner	Service Code Name

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 Office	Project Name
Category ID	Client Primary Service Type	Project Office
Category Name	Client Region	Service Code ID
Client	Client Sub ID	Service Code Name
Client – Principal	Client Type	Sort Name
Client Bill Manager	Financial Reporting Client Group	Staff
Client Billing Group	Line of Business	Staff ID
Client Business Unit	Manager	Subcategory ID
Client ID	Primary Partner	Subcategory Name
Client ID.Sub ID	Project
Client Name	Project ID

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	Date	Service Code Name
Client	Hours	Staff ID
Client ID	Project	Staff Name
Client Name	Rate

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
Project	The project associated with the WIP transaction. If there is no project, unassigned displays.
Client	The client name and ID. The format is Client Sort Name (Client ID.Sub-ID).
Last Bill	The client’s last invoice date and amount
Last Paid	The client’s last payment date and amount.
YTD Write up/downs	The client’s total write ups/downs for the current fiscal year.
AR Balance	The client’s AR balance.
Client ID	The Client ID Sub ID associated with the WIP.
Client Name	The client name associated with the WIP.
Balance Forward	The total unbilled WIP as of the beginning date of the report.
Date	The date of the transaction.
Staff ID	The staff ID associated with the WIP.
Staff	The staff last name, first name associated with the WIP.
Service Code	The service code name associated with the WIP.
Hours	The total hours for the transaction.
Rate	The rate for the transaction.
Amount	The total amount for the transaction.

WIP Detail Ledger Sample Report