Invoice Realization with Reason Codes
The Invoice Realization with Reason Codes report allows you to track realization by invoice. This report can be used to explain why amounts have been written up or down in billing.
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 and Practice Advantage, there are no comparable reports. This is a new standard report.
Report Specifications
The following report options and filters are available to determine the report contents.
Options and Settings | ||
---|---|---|
Option | Setting | Description |
Hide Details |
Yes/No |
Includes or excludes the details for each transaction. If excluded, only the headers and footers for each group with amounts only for the grand total display in the report. To view a summary amount for each group, select to subtotal the group. |
Hide Comma |
Yes/No |
Includes or excludes commas in numbers. |
Hide Penny |
Yes/No |
Includes or excludes pennies in amounts. |
Show Write Up/Down Totals for Reason Codes |
Yes/No |
Includes or excludes the total write up/down amount for the reason codes and a grand total for each column. |
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 Name |
Manager |
Client – Principal |
Client Office |
Posted Date |
Client Business Unit |
Client Primary Service Type |
Primary Partner |
Client ID |
Client Region |
Transaction Date |
Client ID.Sub ID |
Client Type |
|
Grouping | ||
---|---|---|
Available Fields | ||
Client Business Unit |
Client Region |
Manager |
Client ID.Sub ID |
Client Type |
Primary Partner |
Client Office |
Invoice # |
|
Sorting |
---|
There are no sorting options for this report. |
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 in Client ID.Sub ID format. |
Client Name |
The client name. |
Invoice # |
The invoice number. |
Invoice Date |
The invoice date. |
Hours |
The total number of hours on the invoice for each reason code. |
WIP Amount |
The total WIP amount on the invoice for each reason code. |
Write Up Write Down |
The write up/down amount for the invoice/reason code. |
Net Invoice |
The WIP that is billed on the invoice, including the surcharge, expenses, write up/down, progress billed, progress applied, sales tax billed, and progress sales tax applied. This number should match the amount on the invoice. |
Progress |
The total progress billed on the invoice for each reason code. |
Applied |
The total progress applied on the invoice for each reason code. |
Sales Tax |
The total sales tax on the invoice for each reason code. |
Real % |
The realization for the invoice. The calculation is billed WIP + write up/down divided by billed WIP. |
Reason Code |
The reason code that is associated with the invoice write up/down. |
Invoice Realization with Reason Codes Sample Report