Unbilled Summary Options Tab

On the Options tab for the Unbilled Summary report, specify the transactions to include, the time frame for which you are reporting, the aging date, and the aging basis.

You can also set the default terms to be used if no billing terms have been defined for a project. (You may find it helpful to use the Missing Billing Terms List to identify projects without billing terms defined.)

Contents

Options

Field Description
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.

DPS 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).
Print 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 also have the option to 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 Print Project/Phase/Task Info.
Show Final Totals Select this check box if you want a line at the end of the report that shows totals for the entire report.

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.

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.

If you use multiple currencies and you select At Billing, the Report Cost in option is disabled and the report automatically uses the billing currency.

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.