Unbilled Detail and Aging Report

The Unbilled Detail and Aging report displays the transactions that have been posted but not yet been billed as of the date you specify in the Bill-thru Date or Bill-thru Period fields on the Options tab in the Options dialog box. The report name is "Unbilled Detail and Aging" if you specify aging columns for it. If you do not, the report name is "Unbilled Detail."

The contents of the report depend on when you print it:

  • If you print the report before you accept your final bills, it lists all items available for billing (billable, held, to be written off, or not-billable).
  • If you print the report after you accept your final bills, it lists only the items that are available for the next bill. It excludes items with a status of written-off or deleted.

The Unbilled Detail and Aging report does not include projects that have no billing terms. (You can use the Missing Billing Terms List to identify such projects.) In addition, the report does not include projects that have fee billing terms only.

Labor Billing Rates

You can override the cost rates for labor categories using options on the Max Cost by Category Override tab in the Billing Labor Override Tables form. If you do, labor billing rates in this report reflect those overrides.

Leading Zeros in Invoice Numbers

If your firm uses leading zeros in invoice numbers but you do not want to display the zeros on this report, clear the Display invoice leading zeros option on the General tab of the Accounting System Settings form.

Multicompany

If you use the Multicompany feature, this report is limited to projects that can be billed by the active company. Those projects include the following:

  • Projects owned by the active company.
  • Sub-projects in billing groups with main projects owned by the active company. These sub-projects can belong to other companies.

The report does not include data from sub-projects that are owned by the active company but that are also part of a billing group with a main project owned by another company.

Multicurrency

If you use the Multicurrency feature and you select Use Reporting Default Terms on the Options tab of the Options dialog box for the report, Vision verifies that each project's billing currency matches the currency for the labor rate table or the override table specified on the Labor tab in the Reporting Default Terms form. If it detects a discrepancy, Vision displays a message, and the report does not print.

This occurs if you print the report for any projects for which both of the following are true:

  • The project has no billing terms, or it has No labor billing as the labor method in its billing terms.
  • The project's billing currency is different than the currency for either the labor rate table or the override table specified on the Labor tab in the Reporting Default Terms form.

If this occurs, generate the Missing Billing Terms report with Include only Projects that have no labor terms and cannot use Reporting Default Terms selected on the General tab of the Options dialog box to identify the projects with the billing currency discrepancy. After you modify the billing terms or billing currency to eliminate the discrepancy, generate the Unbilled Detail and Aging report again.

If you generate the Unbilled Detail and Aging report using reporting default terms as part of batch billing or interactive billing and Vision detects a currency discrepancy, as described above, the report will display incorrect amounts for those projects. For batch billing (in draft mode only) and for interactive billing, the invoice will display 0 for the corresponding billing extension amounts.

Multilanguage

If your firm uses the Multilanguage feature, the language saved with an invoice template applies to invoices generated from that template either in Interactive Billing or in Batch Billing. It also applies to Billing Backup reports and AR Statements generated along with those invoices during the billing process. However, it does not apply to the Unbilled Detail reports, if you elect to generate those reports also during batch billing. The Unbilled Detail reports, because they are intended for internal use only, are normally generated in the language that you select when you log in to process batch billing. You can, however, create a set of saved options for a specific language for the Unbilled Detail report in Reporting and then select that set of options for the report when you run the batch billing process.

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.

Related Topics:

  • Display the Unbilled Detail and Aging Report
    The Unbilled Detail and Aging report is a Billing report.
  • Unbilled Detail and Aging General Tab
    Use the General tab to select report options for the Unbilled Detail and Aging report and to save sets of options for reuse.
  • 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.
  • Unbilled Detail and Aging Columns Tab
    Use the Columns tab to select or clear columns, change column sequence, provide new column labels, set column widths, or select number and date formats.
  • Unbilled Reports Additional Columns
    On the Columns tabs of the Options dialog boxes for the Unbilled Detail and Aging report and the Unbilled Summary report, you select columns for the reports. Additional columns are included on these reports if you select the Show Project/Phase/Task Info option on the Options tab of the Options dialog box.
Parent Topic: Billing Reports Overview