Reports - Project Accounting - Billing and Revenue Summary

Overview

This report will provide summary level information related to what has happened in the system with respect to billing and revenue recognition.  This report does not include any projected values.  The transactions reported on in this report are the result of the Post or Invoice Completion processes.  This report provides a summary of all billing and revenue transactions posted to Unanet Journals for a given project through a given date.  

When running this report, you will need to indicate whether the resulting output should include data related to Billing or Revenue or both.  A number of the values appearing on this report will allow you to click through to see additional details regarding what makes up a particular number as displayed on a Billing and Revenue Detail report.  You can return to the Summary report after having clicked through to the Detail version.

If you choose to report on contracts in Reporting Options, you will also see the owning organization, customer, code, title, manager, funded value, and total value for each contract. This also applies to the Download report details to CSV option.

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

• CSV Output  (options available to save as a CSV report)

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)

• Billing and Revenue Detail Report      (to view a detail report containing billing and revenue information)

• FAQ - How can I recognize retained/unbilled fee revenue on a Cost Plus contract without impacting AR Aging or showing on the invoice until billed? (search for this topic in the Knowledge Center)

Selection Criteria

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

Example Report Output

The summaries of the deferred revenue, recognized revenue, and billed charges equate directly to their respective journal transactions.  Unbilled journal transactions, however, may be further subcategorized by this report into unbilled and deferred billings.    

Data Collection Notes

• Indirect Charges generated by the Billing Post for CP projects will be shown at a summarized 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
• Billings Deferred column -- used prior to v10.0 -- would be an artifact of a Fixed Price item having its revenue recognized before the item is eligible to be billed.

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

CSV Output

On this report you will notice the CSV () icon, which can be used to generate a CSV formatted output.  Whatever columns you select under Column Options will also appear in the CSV formatted document.