Reports - Project Accounting - Project Transactions

Overview

This report will provide details related to what transactions (labor, expense, fixed price, funding caps, etc.) have been charged to a particular project, with additional details regarding which of those transactions have been posted to the journals.  

When running this report, you can specify which types of transactions you are interested in viewing.

Roles

This report is available to users having any of the following roles:  Administrator, P&R Administrator and the following Project Administrator roles: Resource Requestor, Project Viewer, Project Manager, Project Lead, Project Approvers.   

Note that Project Administrators will have their visibility limited as follows:

• If not a Bill Rate Manager:
• • In Charges group -- Bill & Billable columns hidden
  • In Postings -- all columns but Cost hidden
  • The following transactions will also be hidden:
  • • Fixed Price, Pre-Billed Labor, Funding Cap Adj, and Additional Items invoice charges
• If not a Cost Rate Manager:
• • In Charges group -- Cost columns will display a dash
  • In Postings -- Cost columns will display a dash

See report notes below for additional information about what may and may not appear in the report output.

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)

Selection Criteria

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

Example Report Output

Report / Field Description Notes

• Arranged by Project Manager, Project Org, Project, Task, and Transaction Type.
• Person / Description - contains:
  • time, expense report - the person is the owner of the timesheet or expense report

  • financial document labor - the name of the person from the financial document detail line

  • financial expense - customer-vendor/person/description from detail line

  • financial item - fixed price item description from detail line

  • empty for all other transaction types
• Labor Category / Expense Type / Item - contains:
  • time - timesheet cell or financial document (Vendor Invoice) labor category
  • expense report & financial document expense - expense type
  • item - item name and code
  • empty for all other transaction types

  • Note: Financial document expense/labor/item are not supported for intercompany transactions, only labor and expense transactions

• Reference:
  • expense report number
  • financial document expenses and items - financial document type (JE, VI, VP, etc.) and the financial document number
  • empty for all other transaction types
• Invoice Number - invoice number of the last Unanet invoice with a Post Date that is in the Posted Date Range, that includes this transaction
• Date - transaction date
• Is Billable - billable indicator of the project type associated with the charge
• Quantity
  • cost - all hours or quantity
  • billable - hours or quantity reported with the billable project type
  • write off - hours or quantity written off in an invoice
  • item quantities will not be included in totals
• Charges
  • Cost - if the access user is not an Administrator or P&R Administrator and they do not have the Cost Rate Manager role, this column will have no values for Labor transactions
    • labor - hours * eff cost rate
    • expense report / financial document expenses - expense amount
    • item - amount from the VI item detail line
    • empty for all other transaction types

    • for borrower's intercompany transactions,  if intercompany posting options are set to cost plus intercompany markup then labor cost is (intercompany cost rate * person's cost rate + cost rate) * hours. If  intercompany posting options are set to person bill rate, then labor cost is  person bill rate * hours. Expense cost can either be the expense amount, or the intercompany balancing project's expense type markup * expense amount, or the cost amount plus burden depending on the posting options setting for intercompany cost.

  • Bill - if the access user is not an Administrator or P&R Administrator and they do not have the Bill Rate Manager role, this column will be hidden
    • labor - hours * eff bill rate
    • expense report / financial document expenses - expense amount with markup
    • item - Cost / Amount if the item is configured as Bill by "Rate", Cost / Amount * (1 + markup%)  if the item is configured as Bill by "Markup"
    • fixed price, pre-billed labor, additional charge - amount
    • fee cap adj, funding cap adj - bill amount

    • for lender's intercompany transactions, bill amount can either be the person bill rate or (intercompany cost rate * person's cost rate + cost rate) * hours, depending on the intercompany posting options.

  • Billable - if the access user is not an Administrator or P&R Administrator and they do not have the Bill Rate Manager role, this column will be hidden  
    • labor, expense report, financial document expenses, items - amount if Is Billable = Y, zero otherwise
    • fixed price, pre-billed labor, additional charge - amount
    • fee cap adj, funding cap adj - bill amount. Note, bill amount for a revenue funding cap adjustment will be 0.

    • for borrower's intercompany transactions, billable amount can either be the cost amount of the expense or the borrowing project's expense type markup (if no markup, use markup from admin setup)  * expense amount, or the cost amount plus burden, depending on the intercompany cost posting options.

  • Postings
    • write off - if "Include unposted data only" is checked, shows write offs from unposted invoices only; otherwise, all write offs from the invoice listed on this transaction
    • all other columns - sum of all journal entries for the given category (billed, unbilled, etc.) within the Posted Date Range
    • If the access user is not an Administrator or P&R Administrator and they do not have the Bill Rate Manager role, columns Write-Off, Unbilled, Billed, Deferred, and Revenue will be hidden.
    • If the access user is not an Administrator or P&R Administrator and they do not have the Cost Rate Manager role, Cost column will have no values for Labor transactions.

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.  

Note that certain output will also be hidden from the resulting CSV file depending on whether the user running the report as a Bill Rate Manager and/or Cost Rate Manager as follows:

If not a Bill Rate Manager:

• In Charges group – Bill & Billable columns hidden
• In Postings – all columns but Cost hidden
• The following transactions will also be hidden:
• • Fixed Price, Pre-Billed Labor, Funding Cap Adj, and Additional Items invoice charges

If not a Cost Rate Manager:

• In Charges group – Cost columns will display a dash (which should be blank in csv)
• In Postings – Cost columns will display a dash (which should be blank in csv)