Invoice Transaction Detail Report
The Invoice Transaction Detail report supports the option to post fee billed revenue based on transaction detail. On this report, review the transaction detail used to allocate and post fee billing amounts to revenue accounts and to work breakdown structure (WBS) components (project, phases, and tasks).
For each invoice, the report provides complete transaction detail, grouped and subtotaled by general transaction type (labor, consultant, and expenses). You have the option to also display the invoice total amount and totals for each of the invoice sections: fees, labor, reimbursable expenses, and so on.
In addition to posted transactions, the report includes any billing-only transactions created in Interactive Billing. The detail on this report matches the detail displayed in Interactive Billing when the invoice was posted.
Settings
To enable the option to post fee invoice revenue based on transaction detail, use the Fee form of Billing settings (). Then decide to use that option on a project-by-project basis on the Billing Terms form.
Revenue Allocation Based on Cost or Billing
On the Fee form of Billing settings, your enterprise indicates if fee billed revenue is to be allocated to revenue accounts based on transaction cost or transaction billing value. That decision has important implications for how you generate the Invoice Transaction Detail report if you want to review the transaction detail used to make the allocations:
| If the Calculate Transaction Values setting is... | On the Options tab of report settings, you should: |
|---|---|
| Cost | Select all billing statuses under Display Transactions Based On Billing Status |
| Billing | Select only the Final Billed option under Display Transactions Based On Billing Status |
Invoice Adjustments and Credit Memos
If an invoice included on the report has associated adjustments or credit memos, the adjustments and credit memos are included on the report but are listed separately from the invoice detail.
Voided Invoices
The report includes voided invoices for reference, but they have no billed values or labor and expense amounts.
Billing Client
When you use the Records field in the grid on the main Reporting form for the Invoice Transaction Detail report to select specific projects to display in the report, you select projects based on the billing client for a project. This is the billing client that is entered in the Billing Client field on the Accounting tab in the Projects hub.
Record Selection
This report is designed to display information for entire invoices. If you select records for the report based, for example, on phase manager, Vantagepoint selects invoices for that phase manager, but the report includes all data for those invoices, not just that manager's portion of the invoice data.
Changes After Invoice Posting
If, after an invoice is posted, changes are made to the transactions associated with the invoice or to the billing terms, or other changes occur that affect the calculation of billing value or cost (whichever is used to allocate fee billed revenue) for those transactions, the transaction detail on the Invoice Transaction Detail report will no longer tie out to the original fee billed revenue allocations. Vantagepoint does not adjust the allocations for changes that occur after the invoice is posted, but the report is based on your current data.
Multiple Companies
If you use multiple companies, this report only includes invoices for projects billed by the active company. Those projects include the following:
- Projects owned by the active company
- Sub-projects in billing groups with main projects owned by the active company. These sub-projects can belong to other companies.
The report does not include data from sub-projects that are owned by the active company but that are also part of a billing group with a main project owned by another company.