Run the Project profitability report to analyze profit or loss by project for a specified date range.

Use the following invoice parameters to filter the report:

ParameterDescription
InvoiceSelect whether to include customer invoices for actual project transactions.
On-accountSelect whether to include on-account invoices.
Invoice dateSelect the starting and ending invoice dates to include.
Invoice accountClick Select. In the ProjPrintInvoice form, in the Criteria field, select an invoice account to include. To add more, click Add.
Project contract IDClick Select. In the ProjPrintInvoice form, in the Criteria field, select a project contract to include. To add more, click Add.
Sales currencyClick Select. In the ProjPrintInvoice form, in the Criteria field, select a sales currency to include. To add more, click Add.
InvoiceClick Select. In the ProjPrintInvoice form, in the Criteria field, select an invoice to include. To add more, click Add.

Review profitability

When you generate this report, the following default parameters are shown. You can use these parameters to filter the data that will be shown on the report:

ParameterDescription
Include project typesSelect the project types to include on the report.
Include transaction typesSelect the transaction types to include. You must select at least one.
Project dateEnter a from and to date to include project-posted transactions.
Ledger dateEnter a from and to date to include ledger-posted transactions.
Actual vs. BudgetSelect whether to show actual values or budgeted values.
Forecast modelSelect the forecast model to use for the report.
Project viewSelect how the first column is displayed on the report.
Project levelChoose the number of subproject levels to display:
  • 0 – Summarize all projects in one line
  • 1 – Show only parent projects
  • 2 – Show subprojects
Skip blank IDExclude projects without IDs, such as internal ones.
Skip zeroExclude rows with amounts equal to zero.
Show amountChoose how to display amounts:
  • With decimals – Two decimal places
  • Without decimals – Rounded to integers
  • Amount in 1,000 – Rounded to thousands
  • Amount in 1,000,000 – Rounded to millions
Show hourSelect whether to display quantity of hours, cost for posted hours, or both.
PL ratioChoose how to display the profit/loss ratio:
  • None – Do not show the PL ratio column
  • Gross margin – Show revenue minus cost
  • Value-added – Show gross margin as a percentage of revenue
  • Both – Show both gross margin and value-added percentage
ProjectClick Select. In the Project profit and loss form, select projects to include. To add more, click Add.


Standard procedure

1. Go to Project management and accounting > Inquiries and reports > Cash flow reports > Project cash flow.
2. Select Yes in the Time and material field.
3. Select Yes in the Fixed-price field.
4. Select Yes in the Hour field.
5. Select Yes in the Expenses field.
6. Select Yes in the Item field.
7. Select Yes in the Fee field.
8. Select Yes in the On-account field.
9. In the From date field, enter a date.
10. In the To date field, enter a date.
11. Select Yes in the Include paid payment field.
12. Select Yes in the Include expected payment field.
13. Click OK.
Related to Notes

Analyze and close project

 

Provide feedback