Reports - Project Accounting - Billing and Revenue Details

Overview

This report will provide details related to what has happened in the system with respect to billing and revenue recognition.  This report does not include any projected values.  This report may be helpful for investigating the transactions that were posted to Unanet Journals for a given project.  This report will show the origins of the data that has been posted for the project.  For example, you will be able to see the revenue recognized for a given Fixed Price item, or individual labor and expense actuals that contributed to the revenue for a Cost Plus project.  

When running this report, you will need to indicate whether the resulting output should include details related to Billing or Revenue but not both at once.  Details can be included based on Item Date (when the item of interest happened) or Journal Date (the date associated with the item during the Post or Invoice Completion process).  

When running this report for Cost Plus projects, the labor and expense will be shown at the time cell / expense data allocation level.  Indirect charges and fees (i.e. discount, fringe, G&A, overhead, etc) will be shown with the appropriate cost element's description.

Roles

This report is available to users having any of the following roles:  Administrator, P&R Administrator, Billing Manager, Billing Viewer (and their alternates).

License

This report is available with the Project Tracking and Project Portfolio family of licenses.

Topics covered on this help page include:

• Selection Criteria   (options available to tailor report output)

• Example Report Output

You may also be interested in:

• Project Accounting > Instructional Guide  (search for this topic in the Knowledge Center)

• Billing > Instructional Guide    (search for this topic in the Knowledge Center)

• Post                         (to view additional information about posting data)

• Add Invoices          (to view additional information about creating invoices)

• Billing and Revenue Summary Report      (to view a summary report containing billing and revenue information)

Selection Criteria

Field Descriptions (click on a link below for additional information)

Example Report Output

Field Description Notes

Category - will be populated as follows:

• funding cap adj - will contain the following verbiage "Funding Cap Adjustment"
• fee cap adj - will contain the following verbiage "CP Fee Cap Adjustment"
• all labor charges - labor category (this applies to T&M, CP Direct, CP Indirect, and CP Fee charges for labor)
• all expense charges - expense type name, if it exists, or code (this applies to T&M, CP Direct, CP Indirect, and CP Fee charges for expense or financial document expense)
• all item charges - item name (this applies to T&M, CP Direct, CP Indirect, and CP Fee charges for items)

Doc Type - can have the following values:

• ER - Expense Report

• VI  - Vendor Invoice

• VP - Vendor Payment

• D - Deposit

• JE - Journal Entry

• CP - Customer Payment

• TS - Timesheet

Cost Element - will be populated only for CP projects as follows:

• direct charge (labor or expense) - cost element description if exists, cost element code otherwise

• indirect cost - cost element description if exists, cost element code otherwise
• fee or fee cap adjustment - fee method name
• all other charges - empty

Comments - when displayed contains the following values:

• Labor - time cell comment (if it exists)
• Expense report items - expense line item comment concatenated with an expense wizard data (if it exists)
• Financial document expenses - description from the detail line (if it exists)

Quantity - when pertaining to labor, shows timesheet cell hours for direct charge rows only. This column will be empty for any labor-related indirect charge. Item quantities will appear in this column as applicable.

Data Collection Notes

• Indirect Charges generated by the Billing Post for CP projects will be shown at the individual timesheet cell or expense line item allocation level
• Fee and Funding Cap Adjustments will appear in this report
  • Fee Cap Adjustments are calculated for each fee defined for a project
  • Funding Cap Adjustments are calculated for each task and/or project where the cap was defined either for billing or revenue
• Charges shown for the draft invoices should be reduced by the amount of write off for any given charge
• Recognized revenue shown in the report should include recognized revenue and revenue write off transactions

Items appearing in the report output are listed alphabetically by name.  

See the Post and Invoice Completion processes for more information about how Unanet Journal entries are created.