|
Review budget vs Actual costs
|
Project accountant
|
Use the Actual versus budget report to compare original budgets, revised budgets, actuals, and variances.
The report includes:
- Original budget: total of all expense and revenue budgets
- Revised budget: total of original budget, revisions, transfers, and carry-forwards
- Actuals: total of posted debits and credits for selected financial dimensions
- Variance: difference between actual and revised budgets, shown as amounts and percentages
The report groups data by budget model and dimension values. |
|
Close project
|
Project accountant
|
The required steps depend on the project type: - Check if all transactions are posted and all amounts are invoiced.
- Complete the project estimation.
If you closed the project too early, you can reopen it to post late transactions. |
|
Review invoices
|
Project accountant
|
Run the Customer invoice report for projects to view invoice details for a selected date range.
Use the following parameters to filter the report:
| Parameter | Description |
|---|
| Invoice | Select whether to include invoices for actual project transactions. |
| On-account | Select whether to include on-account invoices. |
| Invoice date | Define the starting and ending invoice dates to include. |
| Invoice account | Click Select. In the ProjPrintInvoice form, in the Criteria field, select an invoice account to include. To add more, click Add. |
| Project contract ID | Click Select. In the ProjPrintInvoice form, in the Criteria field, select a project contract to include. To add more, click Add. |
| Sales currency | Click Select. In the ProjPrintInvoice form, in the Criteria field, select a sales currency to include. To add more, click Add. |
| Invoice | Click Select. In the ProjPrintInvoice form, in the Criteria field, select an invoice to include. To add more, click Add. |
|
|
Review profitability
|
Project accountant
|
Review the posted project invoice journal. |
|
Analyze Cash flow
|
Project accountant
|
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:
| Parameter | Description |
|---|
| Invoice | Select whether to include customer invoices for actual project transactions. |
| On-account | Select whether to include on-account invoices. |
| Invoice date | Select the starting and ending invoice dates to include. |
| Invoice account | Click Select. In the ProjPrintInvoice form, in the Criteria field, select an invoice account to include. To add more, click Add. |
| Project contract ID | Click Select. In the ProjPrintInvoice form, in the Criteria field, select a project contract to include. To add more, click Add. |
| Sales currency | Click Select. In the ProjPrintInvoice form, in the Criteria field, select a sales currency to include. To add more, click Add. |
| Invoice | Click 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:
| Parameter | Description |
|---|
| Include project types | Select the project types to include on the report. |
| Include transaction types | Select the transaction types to include. You must select at least one. |
| Project date | Enter a from and to date to include project-posted transactions. |
| Ledger date | Enter a from and to date to include ledger-posted transactions. |
| Actual vs. Budget | Select whether to show actual values or budgeted values. |
| Forecast model | Select the forecast model to use for the report. |
| Project view | Select how the first column is displayed on the report. |
| Project level | Choose the number of subproject levels to display:
- 0 – Summarize all projects in one line
- 1 – Show only parent projects
- 2 – Show subprojects
|
| Skip blank ID | Exclude projects without IDs, such as internal ones. |
| Skip zero | Exclude rows with amounts equal to zero. |
| Show amount | Choose 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 hour | Select whether to display quantity of hours, cost for posted hours, or both. |
| PL ratio | Choose 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
|
| Project | Click Select. In the Project profit and loss form, select projects to include. To add more, click Add. |
|
|
Analyze utilization
|
Project accountant
|
Review the Project invoice proposal.
The proposal shows rental totals. |
