Unbilled Detail and Aging Options Tab

The Options tab of the Unbilled Detail and Aging Options dialog box gives you additional control over the data displayed on the Unbilled Detail and Aging report.

Contents

Options

Field Description
Show Timesheet Comments Select this check box if you want timesheet comments included in the report.
Use Reporting Default Terms

If you select this check box, the report uses default billing terms when no labor or expense billing terms are defined for a project. If you have projects that have only fee terms, you can use this option to the see the labor and expense at a billing value.

Deltek determines default terms for a project as follows:

  • If default billing terms exist for the project on the Labor tab and Expenses/Units tab of the Billing Terms form, the report uses those billing terms.
  • If no default billing terms exist for the project on the Labor tab or Expenses/Units tab of the Billing Terms form, the report uses the global default terms defined on the Reporting Default Terms form (Settings > Billing > Reporting Default Terms).
Show Project/Phase/Task Info

Select this check box to include the following additional information for each project, phase, and task:

  • Compensation
  • Revenue Type
  • Principal
  • Project Manager
  • Client Number

If you select this check box, you can also include job-to-date billed amounts.

Show JTD Billed Select this check box to include job-to-date billed amounts. This option is only available if you select Show Project/Phase/Task Info.
Single Line Summary Select this check box to display a one-line summary for each project, phase, and task.
Show Final Totals Select this check box if you want a Final Totals line at the end of the report. That line shows total hours and amounts for the entire report. Whether the final totals are for cost or billing depends on the Aging Report Basis option (see description below).
Show Employee Totals Select this check box if you want the report to show total hours and amounts for each employee.

Include

Field Description
Billable transactions Select this check box to include transactions with a status of Billable.
Held transactions Select this check box to include transactions with a status of Held.
Transactions to be Written Off Select this check box to include transactions with a status of Write off.
Transactions to be Deleted Select this check box to include transactions with a status of Deleted.
Non-billable transactions

Select this check box to include transactions with a status of Non-billable.

  • Non-billable transactions at billing rates display with a status of B and no amount.
  • Non-billable transactions at cost rates display with a status of B and the transaction amount. Generate the report at cost rates to review the non-billable transactions for a project with their amounts.
Report Cost in If you use multiple currencies, select the currency type for cost amounts.

Aging Date

Select the date from which the aging data is calculated:

Field Description
Today's Date Age transactions based on the current date.
Period End Date Age transactions based on the last day of the current accounting period.
Specific Date Age transactions based on the date that you specify.

Final Totals and Aging Report Basis

Select one of the following:

Field Description
At Cost The report includes non-billable transactions.
At Billing The report excludes non-billable transactions.

Bill thru Date

Specify a cutoff date for transactions to be included in the report.

Field Description
Today's Date The cutoff date is the date that you generate the report.
Accounting Period End Date The cutoff date is the end date of the current accounting period when you generate the report. For example, if you generate the report on 5/11/2018, the cutoff date is 5/31/2018, the last day of the accounting period.
Specific Date The cutoff date is the date that you specify in Bill thru Date on the Options tab.

Bill thru Period

If you enter a specific date in Bill thru Date, the period that you specify in Bill thru Period must be consistent with that date. Specify a cutoff period for transactions to be included in the report:

Field Description
Current The cutoff period is the current active period when you generate the report. For example, if you generate the report on 5/11/2018, the cutoff period is 05/2018.
Period The cutoff period is the period that you specify in Bill thru Period on the Options tab.