Reports - Project Accounting - Invoice Details

Overview

This report provides a view of the data that is included on an invoice, not necessarily at the same level as the data displayed on the invoice.  The output can include invoices having a status of draft, completed and those having been marked extracted (via the Admin >> Export >> Accounts Receivable export).  This report may be helpful when reviewing multiple invoices for an individual project or a set of projects. This report will show the details of each invoice along with the multiple group totals (e.g. project, project organization, etc.).

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)

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

• List & Edit Invoices   (to view additional information about viewing and editing existing invoices)

• Invoice Completion Process      (learn more about what happens when an invoice is completed)

Selection Criteria

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

Example Report Output

Item's inclusion on the report will be partially controlled by comparing a key date to the Invoice Date range on the selection criteria screen.  For the following categories of data that is associated with a particular invoice, the key date of comparison is:

• Time Entries - Timesheet Cell Work Date
• Expense Entries - Expense Line Item Dates
• Item Entries - Item Line Dates
• Pre-Billed Labor Entries - Bill Date
• One-Time Charge Entries - Invoice Date
• Cost Plus Summary Entries - Invoice Date
• Fixed Price Items - either the task's completed date, or the project's completed_date or the bill_date

The Category name provided for the various types of data comes from:

• Time Entries - Labor Category
• Expense Entries - Expense Type Name
• Item Entries - Item Code and Name
• Pre-Billed Labor Entries - Pre-Billed Labor Description
• Fixed Price Items - Fixed Price Item Description
• One-Time Charge Entries - One-Time Charge Description
• Cost Plus Summary Entries - Cost Element Description if it exists, otherwise the Cost Element Code
• Pre-Billed Labor Offset - determined as the sum of all offsetting pre-paid labor invoiced on this invoice and shows with a category of "Labor Offset from Pre-Billed Labor"