Office Earnings
Use the Office Earnings report for a high-level summary of financial activity for revenue-producing projects. The report includes current, year-to-date, and job-to-date totals for revenue, spent, and profit or loss. It also displays key job-to-date totals, including totals for revenue, billing, and accounts receivable.
Use the Office Earnings report to determine the following:
- Which project managers earned the most on their projects this year?
- What types of work are most profitable?
- Which departments are most profitable this year?
Although you can generate the Office Earnings report at any time, managers usually generate it after each accounting period is closed to review project revenue and profitability.
Select the Source of Budget Data
If you use the Planning application, use the options on the Budget tab to select the source of the project budget data for the report:
- Project Budget Worksheet in Accounting
- The plan mapped to the project in Planning
Revenue by Category: Multiple Unbilled Accounts
If your company tracks multiple unbilled accounts, you can use this report to review unbilled revenue amounts for labor, consultants, expenses, and up to two additional custom revenue methods.
Effective Dates
Billing includes the option to specify effective dates for billing rates. You can establish a schedule of rates at which employee labor is billed throughout the course of a project.
If a project's billing rate is determined by a billing labor rate table, the date of the transaction affects the billing rate. This applies to transactions entered through Transaction Entry, using a Billing Labor Insert, or using a Billing Labor Transfer. DPS compares the transaction date with the effective dates in the billing labor rate table to determine which billing rate to use to calculate the billing amount.
Project Activity and the Office Earnings Report
Most project reports consider a project to have activity in a given period if any labor or expenses are posted for it during that period. However, the Office Earnings report also considers a project to have activity if any invoices or cash receipts are posted for it. If you drill down to the Labor Detail report or Expense Detail report from the Office Earnings report, those reports also use this broader definition of activity.
Improve Performance with the Use Summary Table Option
Calculations performed for this report place high demands on processor resources. In some cases, it can take a long time to generate the report for large databases. To minimize the time it takes to generate the report, first run the Refresh Project Summary Table utility and then select the Use Summary Table option on the General tab of the Options dialog box for this report.
Drill Down on Project Number
If you preview the Office Earnings report and drill down on the project number, the Project Progress report displays with data for that project.
Multiple Currencies
If you use multiple currencies, a report may display amounts in different currencies. If the report contains a total for a column that contains mixed currencies, that total displays as ####, rather than as an actual amount. If you generate a report with a mix of currencies, you can include currency symbols or codes to identify the currency for each amount.
For more direct comparison of amounts, you can select a presentation currency for the report so that all amounts display in a single currency. To do that, select Presentation Currency in Report In on the General tab of the Options dialog box and specify the currency and the date for determining exchange rates.
Options Dialog Box
Use the Options dialog box to specify reporting options for a report. Depending on the report, the dialog box contains one or more of the following tabs: General, Sorting/Grouping, Columns, Budget, Metrics, User Defined Sections, Activity, Drill Down, Layout, and Graph.