Billing Report
The Billing Report shows the breakdown of posted and/or unposted invoices. This report includes the WIP available, the billed amount, and the remaining WIP. The report also shows the realization percent, percent of the WIP billed, and the write up/down percent.
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>
Reports in Foundation that are Comparable
In Practice Management, the comparable report is Billing Report. In Practice Advantage, there are no comparable reports.
Report Specifications
The following report options and filters are available to determine the report contents.
Options and Settings | ||
---|---|---|
Option | Setting | Description |
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 |
Transaction Type |
= |
All |
Invoice Status |
= |
Posted |
Optional Filters | ||
---|---|---|
Available Fields | ||
Accounting Period Date |
Client Primary Service Type |
Primary Partner |
Billed w/Progress |
Client Region |
Progress Bills |
Business Code |
Client Sub ID |
Real % w/Progress |
Client – Principal |
Client Type |
Real % w/o Progress |
Client Bill Manager |
Financial Reporting Client Group |
Sales Tax |
Client Billing Group |
Invoice Status |
Transaction Date |
Client Business Unit |
Invoiced w/o Progress |
Transaction Type |
Client ID |
Line of Business |
WIP Available |
Client ID.Sub ID |
Manager |
WIP on Hold |
Client Name |
Percent Billed |
WIP Remaining |
Client Office |
Posted Date |
Write Up/Down |
Grouping | ||
---|---|---|
Available Fields | ||
Business Code |
Client ID.Sub ID |
Client Type |
Client – Principal |
Client Name |
Financial Reporting Client Group |
Client Bill Manager |
Client Office |
Line of Business |
Client Billing Group |
Client Primary Service Type |
Manager |
Client Business Unit |
Client Region |
Primary Partner |
Client ID |
Client Sub ID |
Sort Name |
Sorting | ||
---|---|---|
Available Fields | ||
Billed w/Progress |
Percent Billed |
WIP Available |
Client ID |
Progress Bills |
WIP on Hold |
Client ID.Sub ID |
Real % w/Progress |
WIP Remaining |
Client Name |
Real % w/o Progress |
Write Up/Down |
Invoice w/o Progress |
Sales Tax |
|
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 ID |
The client ID and sub-ID (Client ID.Sub-ID). |
Client Name |
The client name. |
WIP Available |
The total WIP amount of unbilled with a transaction date before the start date of the report + the total of billed and unbilled WIP with a transaction date within the date range entered. |
WIP On Hold |
The total WIP on hold as of the beginning date of the report. |
Progress Bills |
The total progress bills created during the date range selected. |
Billed w/Progress |
The total of the billed WIP + progress bills – progress applied during the date range selected. |
WIP Remaining |
The total of the WIP available –progress bills during the date range selected. |
Percent Billed |
The progress bills divided by the WIP available during the date range selected. |
Invoiced w/o Progress |
The billed WIP + the write up/down during the date range selected. |
Real % w/Progress |
The (billed WIP + write up/down + progress bills) / (billed WIP + progress bills) = invoiced with progress. The invoiced with progress divided by (billed WIP + progress bills) equals the real % with progress. |
Real % w/o Progress |
The invoiced without progress divided by billed WIP. |
Sales Tax |
The total amount of sales tax billed during the date range. |
Write Up/Down |
The total amount of write up/down during the date range. |
Billing Report Sample